SQWareProduction:oracle:bin:sqwora DbmsStats.ksh

From wiki_dbSQWare
Jump to: navigation, search

Presentation

Script $gvsqw_OraBin/sqwora_DbmsStats.ksh :




Online help

The online help is available for most scripts with the -h option.
Ex: $gvsqw_OraBin/sqwora_DbmsStats.ksh -h
Content of this assistance :

Sourcing sqwora_Global.lib v4.0.09 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 <= 12cR1

PARAMETERS
     -I  instance       : Target instance for gather statistics with DBMS_STATS.
OPTIONS
     -h  help           : Display the full usage.
     -s                 : Display samples of usage.
     -U  Users          : Schemas list (all without SYS by default),
                            to gather SYS statistics, it must be the only.
     -EU Users          : Schemas list to exclude.
     -Pdb pdb_name      : pdb_name for multitenant.
     -NLS nls_numeric   : defaut('').
     -PCT estimate_pct  : defaut(10).
     -BSA block_sample  : defaut(TRUE).
     -MOP method_opt    : defaut(FOR ALL INDEXED COLUMNS SIZE REPEAT),
                            (FOR ALL COLUMNS SIZE SKEWONLY) for SYS.
     -DEG degree        : defaut(1).
     -GRA granularity   : defaut(ALL).
     -CAS cascade       : defaut(TRUE).
     -OPT options       : defaut(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            : Desactivate sendmail on error to pmexpdba@gmail.com (by default, send on error).
     -Exec              : Gather statistics (default, display generated commands).

Nuvola apps information.png
Note:
To be sure the aid is accurate, refer directly to the online help script -h option.


Error management

Errors passing arguments

This type of message is generated:

Lack instance parameter, Usage: sqwora_DbmsStats.ksh [-h] -I <instance> [+ options]
For full help : sqwora_DbmsStats.ksh -h

If you are connecting through a terminal, no mail will be sent and you will have more this kind of message:

No send mail because you are in connected mode !!!
Lack instance parameter

If you are not connected to a terminal, the error message appears and is sent by mail to the address contained in the variable $gvsqw_Mail_oracle (See help customize this variable). The subject line will always start by "$gvsqw_MailMsg_oracle : " (See help customize this variable).

Nuvola apps information.png
Note:
Sending mail can be disabled by the option -NoMail for one execution.


Execution errors

Whether you are or not connected to a terminal, the error message appears and an email containing a summary of treatment errors is sent to the address contained in the variable $gvsqw_Mail_oracle (See help customize this variable). The subject line will always start by "$gvsqw_MailMsg_oracle : " (See help customize this variable).

Nuvola apps information.png
Note:
Sending mail can be disabled by the option -NoMail for one execution.


Usage examples

Sourcing sqwora_Global.lib v4.0.09 SQWareProduction for Oracle (dbSQWare) ... 

No standard help for script sqwora_DbmsStats.ksh !

Nuvola apps information.png
Note:
To be sure the examples are accurate, refer directly to the online help script -s option.