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

From Wiki_dbSQWare
Jump to: navigation, search
m (Updated by BatchUser)
m (Updated by BatchUser)
 
Line 19: Line 19:
 
     -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.
     -AddMail  email  : Email address to add at 'pmexpdba@gmail.com'.
+
     -AddMail  email  : Email address to add at 'demo-sqwarebox@dbsqware.com'.
 
     -SendReport        : Send execution log report.
 
     -SendReport        : Send execution log report.
 
     -Detail            : loop on all pdb in multitenant to get details from.
 
     -Detail            : loop on all pdb in multitenant to get details from.
Line 26: Line 26:
 
     -NoDel            : Don't remove local reports.
 
     -NoDel            : Don't remove local reports.
 
     -Locale    locale  : Force Locale for help display (fr,en).
 
     -Locale    locale  : Force Locale for help display (fr,en).
     -NoMail            : Deactivate sendmail on error to pmexpdba@gmail.com (by default, send on error).
+
     -NoMail            : Deactivate sendmail on error to demo-sqwarebox@dbsqware.com (by default, send on error).
  
 
</pre>
 
</pre>

Latest revision as of 12:08, 4 April 2025

Sourcing sqwora_Global.lib v2025.03 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 <= 21c

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).