What is oratop?

Oratop-light,simple DB monitoring tool for Linux

  • Available for : Linux x86-64,  Linux x86

NOTE: oratop can be used to monitor databases on other platforms but the executable must run on Linux with an Oracle client.

To monitor databases on other platforms simply define an alias in tnsnames.ora of the linux client and connect to the databases remotely as you would with sqlplus

Download the oratop executable for 11gR2 on Linux x86-64 here.

Download the oratop executable for 12c on Linux x86-64 for use with 12c clients here.

Download the oratop executable for 11gR2 on Linux x86-32 here.

Download the oratop executable for 12c on Linux x86-32 for use with 12c clients here.

Please download and review the oratop Users Guide for specific instructions on how to configure and run oratop.  A Quick Start Guide is provided in the Instructions section of this Note.

  • Press d to toogle between  Realtime  and Cummulative monitoring
  • Press m to toogle between MODULE/ACTION and USER/PROGRAM_NAME display

This tool probably useful for system administrators, or like synopsis overview for DBA. This Oracle tool is really easy-to-use, very lightweight and simple for cursory Database performance overview. It can be downloaded from MOS [ID 1500864.1]. This tool made for Linux(x32 and x64) and 11gR2 only. Just run it authorizing with some privileged user:
[oracle@dbtest oratop]$ ./oratop 

[av_image src=’http://linux.focustraining.in/wp-content/uploads/2013/12/oratop.png’ attachment=’2465′ align=’center’ animation=’no-animation’ link=” target=”]

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

Oratop usage: 
$ oratop_11203 -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 

$ oratop -help
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
Reference:
oratop - utility for near real-time monitoring of databases, RAC and Single Instance

52 thoughts on “What is oratop?

  1. Pingback: Brazilian Virgin Hair

  2. Pingback: ray ban outlet

  3. Pingback: oakley sunglasses outlet store

  4. Pingback: ray ban sale

  5. Pingback: cheap ray bans

  6. Pingback: oakley sunglasses for women sale

  7. Pingback: oakley sunglasses sale discount

  8. Pingback: oakley sunglasses

  9. Pingback: ray bans sunglasses

  10. Pingback: oakley sunglasses wholesale distributor

  11. Pingback: oakley sunglasses wholesale outlet

  12. Pingback: ray ban sunglasses sale

  13. Pingback: ray bans sunglasses

  14. Pingback: cheap ray ban sunglasses

  15. Pingback: ray ban outlet

  16. Pingback: ray ban sunglasses outlet

  17. Pingback: cheap oakley sunglasses wholesale

  18. Pingback: oakley mens sunglasses

  19. Pingback: ray ban outlet store

  20. Pingback: cheap oakley sunglasses

  21. Pingback: oakley sunglasses

  22. Pingback: oakley sunglasses outlet

  23. Pingback: ray ban sunglasses

  24. Pingback: ray ban outlet online

  25. Pingback: cheap oakley sunglasses

  26. Pingback: ray ban glasses

  27. Pingback: oakley sunglasses wholesale

  28. Pingback: ray ban outlet store locations

  29. Pingback: ray bans sunglasses

  30. Pingback: oakley sunglasses outlet

  31. Pingback: oakley sunglasses outlet online

  32. Pingback: oakley sunglasses outlet

  33. Pingback: oakley vault

  34. Pingback: nike factory

  35. Pingback: roger vivier online

  36. Pingback: wholsale nike nfl jerseys

  37. Pingback: louis vuitton vesker

  38. Pingback: uggs norge

  39. Pingback: nike outlet

  40. Pingback: parajumpers jakke

  41. Pingback: nike blazer mid vintage noir

  42. Pingback: louis vuitton norge

  43. Pingback: louis vuitton salg

  44. Pingback: nike roshe run nordstrom

  45. Pingback: nike huarache 1992

  46. Pingback: roger vivier sale

  47. Pingback: nike factory store talange

  48. Pingback: nike roshe run menthe

  49. Pingback: nike air max 35

  50. Pingback: michael kors outlet

  51. Pingback: coach factory

  52. Pingback: Wholesale Oakley twoface sunglasses brown brown iridium outlet

Leave a Reply