Show TOC

Syntax documentation-f mstats Locate this document in the navigation structure

This BRSPACE function lets you manage database statistics.

Function options:

  • -a|-action: specifies the type of action to manage the database statistics.

    Input syntax: -a|-action delete|delexp|export|import|lock|restore|showexp|showver|unlock

    • delete deletes statistics of selected tables

    • delexp deletes selected exports of table statistics

    • export exports statistics of the selected tables to the schema-related STATTAB table. You must specify a statistics export ID to make it easier to identify the export. The only restriction on this ID is that it must be 20 characters or less. You specify the ID in the option -i|-expid, as described below.

      Example Example

      For an InfoCube statistics export, you might specify the ID as follows:

      -f mstats -a export -i "InfoCubes Stats"

      End of the example.

    • import imports statistics of selected tables from the schema-related table STATTAB

    • lock locks statistics of selected tables

    • restore restores statistics of selected tables to a previous version saved by Oracle

    • showexp displays the exports of table statistics created by BRSPACE

    • showver displays the previous versions of table statistics saved by Oracle

    • unlock unlocks statistics of selected tables

    Default: none, since you must always specify the action

  • -i|-expid: statistics export ID

    Default: last statistics export for action import, otherwise none

  • -m|-time <yyyy-mm-dd hh.mi.ss>: time stamp for restore statistics

    Default: last version saved by Oracle

  • -o|-owner <owner>|<owner_list>: database owner of tables

    Default: none

  • -r|-exprun <exp_run_log>: statistics export run log name

    Default: last BRSPACE statistics export

  • -s|-tablespace <tablespace>|<tablespace_list>: tablespace name

    Default: none

  • -t|-table all|allsel|[<owner>.]<table>|

    [<owner>.][<prefix>]%[<suffix>]|

    [<owner>.][<prefix>]*[<suffix>]|<table_list>

    where:

    all means preselection of all tables

    allsel means selection of all tables

    Wildcards: “%” and “*” mean preselect and select

    For more information about wildcards for preselect and select, see Selecting Objects in Segment Management with BR*Tools.

    Default: none