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

From Wiki_dbSQWare
Jump to navigation Jump to search
Exploit (talk | contribs)
0 edits
m Updated by Expdbtools
 
No edit summary
 
(76 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<pre>
<pre>
Sourcing sqwora_Global.lib v1.2.09 SQWareProduction for Oracle (expdbTools GPL v3) ...  
Sourcing sqwora_Global.lib v2025.07 SQWareProduction for Oracle (dbSQWare) ...  


Usage: sqwora_GenerateAwr.ksh [-h] -I <instance> [+ options]
Usage: sqwora_GenerateAwr.ksh [-h] -I <instance> [+ options]
Line 7: Line 7:
   sqwora_GenerateAwr.ksh AWR reports generation
   sqwora_GenerateAwr.ksh AWR reports generation
SUPPORT
SUPPORT
   Oracle supported versions: 10gR2 <= v <= 11gR2
   Oracle supported versions: 10gR2 <= v <= 23ai


PARAMETERS
PARAMETERS
     -I  instance      : Target instance for generation
     -I  instance      : Target instance to generation
OPTIONS
OPTIONS
     -h help          : Display the full usage.
     -h                 : Display the full usage.
     -s                : Display samples of usage.
     -s                : Display samples of usage.
     -F  FileName      : Config file with date for generate reports.
     -F  FileName      : Config file with date for generated reports.
    -PdbList    list  : list of pdb_name in multitenant to get details from.
    -Snaps  begin-end  : Generate report between the two snaps. Break in -NoDel and -Local automatically.
     -DIR  directory    : Directory to store reports.
     -DIR  directory    : Directory to store reports.
     -FRT return_code  : Force return code value on error.
     -FRT return_code  : Force return code value on error.
     -Local            : Don't copy reports on .
    -AddMail  email  : Email address to add at 'demo-sqwarebox@dbsqware.com'.
    -SendReport        : Send execution log report.
    -Detail            : loop on all pdb in multitenant to get details from.
     -Local            : Don't copy reports on dbsqware@SQWareWebHost.
    -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser@$ORACLE_SID ).
     -NoDel            : Don't remove local reports.
     -NoDel            : Don't remove local reports.
     -NoMail            : Desactivate sendmail on error to dba (by default, send on error).
    -Locale    locale  : Force Locale for help display (fr,en).
     -NoMail            : Deactivate sendmail on error to demo-sqwarebox@dbsqware.com (by default, send on error).


</pre>
</pre>

Latest revision as of 11:38, 6 July 2025

Sourcing sqwora_Global.lib v2025.07 SQWareProduction for Oracle (dbSQWare) ... 

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

DESCRIPTION
   sqwora_GenerateAwr.ksh AWR reports generation
SUPPORT
   Oracle supported versions: 10gR2 <= v <= 23ai

PARAMETERS
     -I  instance       : Target instance to generation
OPTIONS
     -h                 : Display the full usage.
     -s                 : Display samples of usage.
     -F  FileName       : Config file with date for generated reports.
     -PdbList    list   : list of pdb_name in multitenant to get details from.
     -Snaps  begin-end  : Generate report between the two snaps. Break in -NoDel and -Local automatically.
     -DIR  directory    : Directory to store reports.
     -FRT return_code   : Force return code value on error.
     -AddMail   email   : Email address to add at 'demo-sqwarebox@dbsqware.com'.
     -SendReport        : Send execution log report.
     -Detail            : loop on all pdb in multitenant to get details from.
     -Local             : Don't copy reports on dbsqware@SQWareWebHost.
     -Dist              : For distant connection to database (change $gvsqw_DbaUser to $gvsqw_DistDbaUser@$ORACLE_SID ).
     -NoDel             : Don't remove local reports.
     -Locale    locale  : Force Locale for help display (fr,en).
     -NoMail            : Deactivate sendmail on error to demo-sqwarebox@dbsqware.com (by default, send on error).
Retrieved from "https://wiki.dbsqware.com/index.php?title=Template:SQWareProduction_sqwora_GenerateAwr.ksh_help&oldid=34055"