Generate an AWR report for Oracle

1, open the CMD Command dialog box, login Sqlplus (mainly if the administrator account, the user name needs to add as SYSDBA, the password format is [email protected]/instance name), enter the AWR Execute SQL statement (Note that The path is based on the actual installation path).

2, set the Report_type value, here use the default HTML format, directly enter Skip

3. Set the number of AWR reports to display, set the value from 1 to 7.

4. Set the start and end numbering nodes of the log export.

5. Set the path and name of the output log.

6, if the export of more content, may be relatively slow, please wait patiently, until the prompt appears.

For more information about AWR please refer to: HTTPS://CNODEJS.ORG/TOPIC/57F8A9A48489E7CA69F4E8A1

For analysis or no clue, any heavy and long way!

Generate an AWR report for Oracle