-f mstats

This BRSPACE function lets you manage database statistics.

Function options:

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

  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

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

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

  • 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

  Syntax: -i|-expid <exp_id>|<exp_id_list>

  Default: last statistics export for action import, otherwise none

• -m|-time: time stamp for restore statistics

  Syntax: -m|-time <yyyy-mm-dd hh.mi.ss>

  Default: last version saved by Oracle

• -o|-owner

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

  Default: none

• -r|-exprun: statistics export run log name

  Syntax: -r|-exprun all_sexp|<exp_run_log>|<exp_run_list>

  where:

  all_sexp means all statistics exports

  Default: last BRSPACE statistics export

• -s|-tablespace: tablespace name

  Syntax: -s|-tablespace <tablespace>|<tablespace_list>

  Default: none

• -t|-table: tables to be altered

  Syntax: -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: all (preselection)