Template:SQWareProduction sqwora DbmsStats.ksh help: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older editNewer edit →
m Updated by BatchUser
m Updated by BatchUser
Line 1: Line 1:
<pre>
<pre>
Sourcing sqwora_Global.lib v2024.01 SQWareProduction for Oracle (dbSQWare) ...  
Sourcing sqwora_Global.lib v2024.02 SQWareProduction for Oracle (dbSQWare) ...  


Usage: sqwora_DbmsStats.ksh [-h] -I <instance> [+ options]
Usage: sqwora_DbmsStats.ksh [-h] -I <instance> [+ options]
Line 12: Line 12:
     -I  instance      : Target instance to gather statistics with DBMS_STATS.
     -I  instance      : Target instance to gather statistics with DBMS_STATS.
OPTIONS
OPTIONS
     -h help          : Display the full usage.
     -h                 : Display the full usage.
     -s                : Display samples of usage.
     -s                : Display samples of usage.
     -U  Users          : Schemas list (all without SYS by default),
     -U  Users          : Schemas list (all without SYS by default),
                             to gather statistics for SYS, it must be the only one in the list.
                             to gather statistics for SYS, it must be the only one in the list.
     -EU Users          : Schemas list to exclude.
     -EU Users          : Schemas list to exclude.
     -Pdb pdb_name      : pdb_name for multitenant.
     -Pdb pdb_name      : Set the name of pdb for multitenant.
     -NLS nls_numeric  : default('').
     -NLS nls_numeric  : Change the value for the SQL parameters NLS_NUMERIC_CHARACTERS default('').
     -PCT estimate_pct  : default(10).
     -PCT estimate_pct  : Set the threshold limit to trigger the reports default(10).
     -BSA block_sample  : default(TRUE).
     -BSA block_sample  : Determines the uses of random block sampling or random row sampling default(TRUE).
     -MOP method_opt    : default(FOR ALL INDEXED COLUMNS SIZE REPEAT),
     -MOP method_opt    : Set preference on global, schema, database or dictionary level default(FOR ALL INDEXED COLUMNS SIZE REPEAT),
                             (FOR ALL COLUMNS SIZE SKEWONLY) for SYS.
                             (FOR ALL COLUMNS SIZE SKEWONLY) for SYS.
     -DEG degree        : default(1).
     -DEG degree        : Determines the degree of parallelism used for gathering statistics default(1).
     -GRA granularity  : default(ALL).
     -GRA granularity  : Granularity of statistics to collect default(ALL).
     -CAS cascade      : default(TRUE).
     -CAS cascade      : Determines whether to collect index statistics as part of gathering table statistics default(TRUE).
     -OPT options      : default(GATHER AUTO),
     -OPT options      : Add any other dbmstats options default(GATHER AUTO),
                             (GATHER) for SYS.
                             (GATHER) for SYS.
     -FRT return_code  : Force return code value on error.
     -FRT return_code  : Force return code value on error.
     -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser@$ORACLE_SID ).
     -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser@$ORACLE_SID ).
     -AddMail email     : Email address to add at 'pmexpdba@gmail.com'.
     -AddMail   email   : Email address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -SendReport        : Send execution log report.
     -NoMail            : Deactivate sendmail on error to pmexpdba@gmail.com (by default, send on error).
     -NoMail            : Deactivate sendmail on error to pmexpdba@gmail.com (by default, send on error).
     -Locale   locale   : Force Locale for help display (fr,en).
     -Locale   locale : Force Locale for help display (fr,en).
     -Exec              : Gather statistics (default, display generated commands).
     -Exec              : Gather statistics (by default, display generated commands).


</pre>
</pre>

Revision as of 17:11, 7 April 2024

Sourcing sqwora_Global.lib v2024.02 SQWareProduction for Oracle (dbSQWare) ... 

Usage: sqwora_DbmsStats.ksh [-h] -I <instance> [+ options]

DESCRIPTION
   sqwora_DbmsStats.ksh gather statistics with DBMS_STATS
SUPPORT
   Oracle supported versions: 9iR2 <= v <= 21c

PARAMETERS
     -I  instance       : Target instance to gather statistics with DBMS_STATS.
OPTIONS
     -h                 : Display the full usage.
     -s                 : Display samples of usage.
     -U  Users          : Schemas list (all without SYS by default),
                            to gather statistics for SYS, it must be the only one in the list.
     -EU Users          : Schemas list to exclude.
     -Pdb pdb_name      : Set the name of pdb for multitenant.
     -NLS nls_numeric   : Change the value for the SQL parameters NLS_NUMERIC_CHARACTERS default('').
     -PCT estimate_pct  : Set the threshold limit to trigger the reports default(10).
     -BSA block_sample  : Determines the uses of random block sampling or random row sampling default(TRUE).
     -MOP method_opt    : Set preference on global, schema, database or dictionary level default(FOR ALL INDEXED COLUMNS SIZE REPEAT),
                            (FOR ALL COLUMNS SIZE SKEWONLY) for SYS.
     -DEG degree        : Determines the degree of parallelism used for gathering statistics default(1).
     -GRA granularity   : Granularity of statistics to collect default(ALL).
     -CAS cascade       : Determines whether to collect index statistics as part of gathering table statistics default(TRUE).
     -OPT options       : Add any other dbmstats options default(GATHER AUTO),
                            (GATHER) for SYS.
     -FRT return_code   : Force return code value on error.
     -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser@$ORACLE_SID ).
     -AddMail   email   : Email address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -NoMail            : Deactivate sendmail on error to pmexpdba@gmail.com (by default, send on error).
     -Locale    locale  : Force Locale for help display (fr,en).
     -Exec              : Gather statistics (by default, display generated commands).
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwora_DbmsStats.ksh_help&oldid=27013"