RAC realtime monitoring with ORATOP

Key Facts

  • Available for : Linux x86-64,  Linux x86
  • For download location please read Doc ID 1500864.1
  • Press d to toogle between  Realtime  and Cummulative monitoring
  • Press m to toogle between MODULE/ACTION and USER/PROGRAM_NAME display

Oratop Usage

$ oratop -h

oratop: Release 13.2.4
Usage: 
     oratop [ [Options] [Logon] ]
     Logon:
        {username[/password][@connect_identifier] | / }
        [AS {SYSDBA|SYSOPER}]
     Options:
         -i : Interval Delay (requires value in seconds, default: 3s)
         -f : Long format for header & section 4 (default: 80 column)
         -r : IORL mode for Section 2 (default is IOPS)
         -d : Real-Time Top 5 Wait Events (default: Cumulative)
         -m : MODULE/ACTION mode for Section 4 (default: USER/PROGRAM_NAME)
         -b : Batch mode
         -n : maximum number of iterations (requires number)
         -h : Help

First Commands


Connect to a remote instance with wide display 132 
$ oratop -f -i 5 sys/sys@grac42 as sysdba

Refresh display every 5 seconds
$ oratop  -i 5 / as sysdba
oratop 1:   46 GRAC 11:29:16 up  2.4h,  3 ins,   5G mt,  11 sn,  1 us,   1% db
ID %CU HLD MBPS IOPS %FR PGAU ASC ASI ASW ASP   AAS USN  TPS UCPS SSRT DBC DBW
 1   5   3    0    4  18 189M   2   0   0   0   0.0   5    0    6   3m  37  63 
 2   1   2    0    3  34 148M   1   0   0   0   0.0   3    0    5 608u  48  52 
 3   1   1    0    3  40 147M   1   0   0   0   0.0   3    0    5 674u  54  46 
EVENT     (Cumulative)           TOT WAITS  TIME(s)  AVG_MS PCT  WAIT_CLASS   
control file sequential read         78234    12399   158.5  81  System I/O   
log file switch (checkpoint             35     1269 36262.1   8  Configuration
db file sequential read              15094      813    53.9   5  User I/O     
DB CPU                                          548           4               
db file scattered read                3725      237    63.6   2  User I/O     
ID   SID  SPID USR PROG  PGA OPN SQLID/BLOCKER  E/T STATUS STE WAIT_EVENT  W/T
 3    11  3583 B/G LMON   8M                     2h ACTIVE WAI control fi 501m 
 1    11 18701 B/G LMON   8M                     3h ACTIVE WAI control fi 494m 
 2    11  3601 B/G LMON   7M                     2h ACTIVE WAI control fi 218m 

Using Oratop in batch mode

Use -b : batch mode

Additional  flags used 
Use -f switch Long format 
Use -i : Interval Delay (requires value in seconds, default: 3s)
Use -d : Real time processing

$ script ORATOP.out
$ oratop -bdfi5  "/ as sysdba"
$ cat ORATOP.out

oratop: Release 13.2.4 Production on Mon Mar  3 10:45:01 2014

oratop 1:   29 grac4 10:44:37 up  1.9h,  3 ins,   5G mt, 22 sn, 2 us,  24% db
ID %CU HLD MBPS IOPS %FR PGAU ASC ASI ASW ASP   AAS USN  TPS UCPS SSRT DBC DBW                                                    
 3  12   2    0  114  28 251M   1   0   3   0   0.0   6    0   14   5m   8  92                                                     
 2   7   2    0   83  30 251M   1   0   4   0   0.0   7    0   14   5m   9  91                                                     
 1  23   5    0   74  25 290M   2   0   3   1   1.4   9    0   16   7m  20  80                                                     

EVENT     (Real-Time)            TOT WAITS  TIME(s)  AVG_MS PCT  WAIT_CLASS                                                       
DB CPU                                          568          97                                                                   
gc current request                     745        8    10.1   1  Cluster                                                          
gc buffer busy acquire                 741        7     9.7   1  Cluster                                                          

ID   SID  SPID USERNAME           PROGRAM    PGA OPN SQLID/BLOCKER  E/T STATUS STE WAIT_EVENT                                  W/T
 2   143 26182 SCOTT              DEDICATED   2M INS 77bfwdy8jxa0v    0 ACTIVE WAI gc current request                          10m                                     
 2    29 26184 SCOTT              DEDICATED   1M INS 77bfwdy8jxa0v    0 ACTIVE WAI gc buffer busy acquire                      10m                                     
 2    26 26186 SCOTT              DEDICATED   1M INS 77bfwdy8jxa0v    0 ACTIVE WAI gc buffer busy acquire                       9m                                     
 2   156 26188 SCOTT              DEDICATED   1M INS 77bfwdy8jxa0v    0 ACTIVE WAI gc buffer busy acquire                       9m                                     
 3   125 25781 SCOTT              DEDICATED   1M                      0 ACTIVE WAI log file sync                                4m                                     
 3    31 25844 SCOTT              DEDICATED   1M                      0 ACTIVE WAI log file sync                                3m                                     
 3    25 25766 SCOTT              DEDICATED   2M                      0 ACTIVE WAI log file sync                                3m                                     
 1   156 19732 SCOTT              DEDICATED   2M INS 77bfwdy8jxa0v    0 ACTIVE WAI gc current request                           2m                                     
 3   131  6941 B/G                LMS0       13M                     2h ACTIVE WAI gcs log flush sync                           2m                                     
 1   162 19730 SCOTT              DEDICATED   2M INS 77bfwdy8jxa0v    0 ACTIVE WAI gc buffer busy acquire                       2m                                     
 1    28 19745 SCOTT              DEDICATED   2M INS 77bfwdy8jxa0v    0 ACTIVE WAI gc buffer busy acquire                       2u                                     
 3     9  6978 B/G                LGWR       12M                     2h ACTIVE CPU wa for cpu                                   2u

Reference

  • oratop – utility for near real-time monitoring of databases, RAC and Single Instance (Doc ID 1500864.1)

One thought on “RAC realtime monitoring with ORATOP”

Leave a Reply

Your email address will not be published. Required fields are marked *