AWR Report In Oracle

From SmartHCM Wiki
Revision as of 09:52, 3 November 2021 by Usman (talk | contribs) (Created page with "sqlplus / as sysdba SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ AWR reports can be generated in the following formats. Please e...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

sqlplus / as sysdba

SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

Specify the Report Type 09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)Usman (talk) AWR reports can be generated in the following formats. Please enter the name of the format at the prompt. Default value is 'html'.

'html' HTML format (default) 'text' Text format 'active-html' Includes Performance Hub active report

Enter value for report_type: html

Enter value for num_days: 1

Specify the Begin and End Snapshot Ids 09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)Usman (talk) Enter value for begin_snap: 880 Begin Snapshot Id specified: 880

Enter value for end_snap: 881 End Snapshot Id specified: 881


Specify the Report Name 09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)09:52, 3 November 2021 (UTC)Usman (talk) The default report file name is awrrpt_1_880_881.html. To use this name, press <return> to continue, otherwise enter an alternative.

Enter value for report_name: AWR_report.html

Report written to AWR_report.html