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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
(29 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<pre>
 
<pre>
Sourcing sqwora_Global.lib v2020.02 SQWareProduction for Oracle (dbSQWare) ...  
+
Sourcing sqwora_Global.lib v2024.07 SQWareProduction for Oracle (dbSQWare) ...  
  
 
Usage: sqwora_DbmsStats.ksh [-h] -I <instance> [+ options]
 
Usage: sqwora_DbmsStats.ksh [-h] -I <instance> [+ options]
Line 7: Line 7:
 
   sqwora_DbmsStats.ksh gather statistics with DBMS_STATS
 
   sqwora_DbmsStats.ksh gather statistics with DBMS_STATS
 
SUPPORT
 
SUPPORT
   Oracle supported versions: 9iR2 <= v <= 20c
+
   Oracle supported versions: 9iR2 <= v <= 21c
  
 
PARAMETERS
 
PARAMETERS
 
     -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 (by default: '').
     -PCT estimate_pct  : default(10).
+
     -PCT estimate_pct  : Determines the percentage of rows to sample between 0.000001 and 100,
     -BSA block_sample  : default(TRUE).
+
                                you can use the constant DBMS_STATS.AUTO_SAMPLE_SIZE (by default: 10).
     -MOP method_opt    : default(FOR ALL INDEXED COLUMNS SIZE REPEAT),
+
     -BSA block_sample  : Determines the uses of random block sampling or random row sampling (by default: TRUE).
                            (FOR ALL COLUMNS SIZE SKEWONLY) for SYS.
+
     -MOP method_opt    : Set preference method 'FOR ALL [INDEXED | HIDDEN] COLUMNS [size_clause]' (by default: FOR ALL INDEXED COLUMNS SIZE REPEAT),
     -DEG degree        : default(1).
+
                                                                                                    (for SYS FOR ALL COLUMNS SIZE SKEWONLY).
     -GRA granularity  : default(ALL).
+
     -DEG degree        : Determines the degree of parallelism used for gathering statistics,
     -CAS cascade      : default(TRUE).
+
                                you can use the constant DBMS_STATS.DEFAULT_DEGREE (by default: 1).
     -OPT options      : default(GATHER AUTO),
+
     -GRA granularity  : Granularity of statistics to collect, only pertinent if the table is partitioned (by default: ALL).
                            (GATHER) for SYS.
+
     -CAS cascade      : Determines whether to collect index statistics as part of gathering table statistics,
 +
                                you can use the constant DBMS_STATS.AUTO_CASCADE (by default: TRUE).
 +
     -OPT options      : Specifies which objects require statistics to be gathered (by default: GATHER AUTO),
 +
                                                                                      (for SYS GATHER).
 
     -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>

Latest revision as of 15:56, 31 October 2024

Sourcing sqwora_Global.lib v2024.07 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 (by default: '').
     -PCT estimate_pct  : Determines the percentage of rows to sample between 0.000001 and 100,
                                 you can use the constant DBMS_STATS.AUTO_SAMPLE_SIZE (by default: 10).
     -BSA block_sample  : Determines the uses of random block sampling or random row sampling (by default: TRUE).
     -MOP method_opt    : Set preference method 'FOR ALL [INDEXED | HIDDEN] COLUMNS [size_clause]' (by default: FOR ALL INDEXED COLUMNS SIZE REPEAT),
                                                                                                    (for SYS FOR ALL COLUMNS SIZE SKEWONLY).
     -DEG degree        : Determines the degree of parallelism used for gathering statistics,
                                 you can use the constant DBMS_STATS.DEFAULT_DEGREE (by default: 1).
     -GRA granularity   : Granularity of statistics to collect, only pertinent if the table is partitioned (by default: ALL).
     -CAS cascade       : Determines whether to collect index statistics as part of gathering table statistics,
                                 you can use the constant DBMS_STATS.AUTO_CASCADE (by default: TRUE).
     -OPT options       : Specifies which objects require statistics to be gathered (by default: GATHER AUTO),
                                                                                       (for SYS GATHER).
     -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).