![]() ![]() Specify the number of days of snapshots to choose from Instances in this Workload Repository schema Would you like an HTML report, or a plain text report?Įnter 'html' for an HTML report, or 'text' for plain textĮnter value for report_type: html -Choose html type ![]() You can generate Oracle AWR report by using Enterprise manager, SQL*Plus and TOAD etc.Įxecute awrrpt.sql under $ORACLE_HOME/rdbms/admin directory like following. SQL> select snap_id, begin_interval_time,end_interval_time from dba_hist_snapshot You can list AWR Snapshots by executing following command. Because AWR report will be generated between from Two Snapshot. What is the Oracle AWR ( Automatic Workload Repository ) Reportīefore generate AWR report, you should list all snapshots. Read previous article before this to learn What is the Oracle AWR report. I will explain How to Generate AWR Report via SQL*Plus,Enterprise Manager and Toad in Oracle in this post.ĪWR ( Automatic Workload Repository ) Report ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |