Table of Contents
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)
Real good one
Awesome …