To pull Top 5 Timed Events via AWR Report, follow the below steps:
STEP-1 change directory to $ORACLE_HOME/RDBMS/ADMIN SQLPLUS sys "/as sysdba" password:xxxx SQL>@awrrpt.sql Current Instance ~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance ----------- ------------ -------- ------------ 258013968 STRM1 1 STRM1Specify the Report Type ~~~~~~~~~~~~~~~~~~~~~~~ Would you like an HTML report, or a plain text report? Enter 'html' for an HTML report, or 'text' for plain text Defaults to 'html' Enter value for report_type:text
STEP-2 Type Specified: textInstances in this Workload Repository schema ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host ------------ -------- ------------ ------------ ------------ * 258013968 1 STRM1 STRM1 streams1.loc aldomain Using 258013968 for database Id Using 1 for instance number Specify the number of days of snapshots to choose from ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Entering the number of days (n) will result in the most recent (n) days of snapshots being listed. Pressing
without specifying a number lists all completed snapshots. Enter value for num_days:
STEP-3 Enter value for num_days: 1 Listing the last day's Completed SnapshotsSnap Instance DB Name Snap Id Snap Started Level ------------ ------------ --------- ------------------ ----- STRM1 STRM1 62 07 Sep 2010 00:00 1 63 07 Sep 2010 01:00 1 64 07 Sep 2010 02:00 1 65 07 Sep 2010 03:00 1 66 07 Sep 2010 04:00 1 67 07 Sep 2010 05:00 1 68 07 Sep 2010 06:00 1 69 07 Sep 2010 07:00 1 70 07 Sep 2010 08:00 1 71 07 Sep 2010 09:00 1 72 07 Sep 2010 10:00 1 73 07 Sep 2010 11:00 1 74 07 Sep 2010 12:00 1 Specify the Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Enter value for begin_snap:
STEP-4 Specify the Begin and End Snapshot Ids ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Enter value for begin_snap: 62 Begin Snapshot Id specified: 62 Enter value for end_snap: 74 End Snapshot Id specified: 74Specify the Report Name ~~~~~~~~~~~~~~~~~~~~~~~ The default report file name is awrrpt_1_62_74.txt. To use this name, press
to continue, otherwise enter an alternative. test_awrrpt.txt STEP-5 SQL>exit CAT test_awrrpt.txt
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
CPU time 94 81.0
os thread startup 1,034 78 75 66.7 Concurrenc
control file parallel write 14,398 34 2 29.5 System I/O
log file parallel write 10,317 33 3 28.0 System I/O
log file sync 3,828 19 5 16.4 Commit
-------------------------------------------------------------
Operating System Statistics DB/Inst: STRM1/STRM1 Snaps: 62-74
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Statistic Total
-------------------------------- --------------------
BUSY_TIME 171,065
IDLE_TIME 4,131,681
NICE_TIME 21
SYS_TIME 149,784
USER_TIME 21,260
LOAD 0
RSRC_MGR_CPU_WAIT_TIME 0
PHYSICAL_MEMORY_BYTES 368,632
NUM_CPUS 1
-------------------------------------------------------------
Statistic Total per Second per Trans -------------------------------- ------------------ -------------- ------------- redo entries 132,772 3.1 16.4 redo log space requests 1 0.0 0.0 redo log space wait time 19 0.0 0.0 redo ordering marks 0 0.0 0.0 redo size 40,214,752 930.5 4,970.3 redo synch time 2,000 0.1 0.3 redo synch writes 35,766 0.8 4.4 redo wastage 3,125,620 72.3 386.3 redo write time 3,394 0.1 0.4 redo writer latching time 5 0.0 0.0
No comments:
Post a Comment