Report written to DEVECI_AWR_10032019.htmlĭisconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production Press to continue, otherwise enter an alternative.Įnter value for report_name: DEVECI_AWR_10032019.html - Type Report name, or Click enter for default name. The default report file name is awrrpt_1_21626_21630.html. Instance DB Name Snap Id Snap Started LevelĮnter value for begin_snap: 21626 - Type begin Snap IDĮnter value for end_snap: 21630 - Type End Snap ID Listing the last day's Completed Snapshots Specifying a number lists all completed snapshots.Įnter value for num_days: 1 - Choose num_days as 1 or more 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 kommentar(er)
