How to take Top 5 Timed Events

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 STRM1

Specify 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:  text

Instances 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 Snapshots

Snap 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: 74


Specify 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

OTN Discussion Forums: Message List - Database - General

Ask Tom HOT ARTICLES

 
© Copyright 2008 - 2011. All rights reserved to dba-sansar.blogspot.com.
All other blogs, posts and entries are the property of their respective authors.
Please email us for your comments and suggessions Click Here