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

54 thoughts on “What is oratop?

  1. Pingback: cheap oakley sunglasses

  2. Pingback: ray ban sunglasses outlet

  3. Pingback: Brazilian Virgin Hair

  4. Pingback: ray ban outlet

  5. Pingback: oakley sunglasses outlet store

  6. Pingback: ray ban sale

  7. Pingback: cheap ray bans

  8. Pingback: oakley sunglasses for women sale

  9. Pingback: oakley sunglasses sale discount

  10. Pingback: oakley sunglasses

  11. Pingback: ray bans sunglasses

  12. Pingback: oakley sunglasses wholesale distributor

  13. Pingback: oakley sunglasses wholesale outlet

  14. Pingback: ray ban sunglasses sale

  15. Pingback: ray bans sunglasses

  16. Pingback: cheap ray ban sunglasses

  17. Pingback: ray ban outlet

  18. Pingback: ray ban sunglasses outlet

  19. Pingback: cheap oakley sunglasses wholesale

  20. Pingback: oakley mens sunglasses

  21. Pingback: ray ban outlet store

  22. Pingback: cheap oakley sunglasses

  23. Pingback: oakley sunglasses

  24. Pingback: oakley sunglasses outlet

  25. Pingback: ray ban sunglasses

  26. Pingback: ray ban outlet online

  27. Pingback: cheap oakley sunglasses

  28. Pingback: ray ban glasses

  29. Pingback: oakley sunglasses wholesale

  30. Pingback: ray ban outlet store locations

  31. Pingback: ray bans sunglasses

  32. Pingback: oakley sunglasses outlet

  33. Pingback: oakley sunglasses outlet online

  34. Pingback: oakley sunglasses outlet

  35. Pingback: oakley vault

  36. Pingback: nike factory

  37. Pingback: roger vivier online

  38. Pingback: wholsale nike nfl jerseys

  39. Pingback: louis vuitton vesker

  40. Pingback: uggs norge

  41. Pingback: nike outlet

  42. Pingback: parajumpers jakke

  43. Pingback: nike blazer mid vintage noir

  44. Pingback: louis vuitton norge

  45. Pingback: louis vuitton salg

  46. Pingback: nike roshe run nordstrom

  47. Pingback: nike huarache 1992

  48. Pingback: roger vivier sale

  49. Pingback: nike factory store talange

  50. Pingback: nike roshe run menthe

  51. Pingback: nike air max 35

  52. Pingback: michael kors outlet

  53. Pingback: coach factory

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

Leave a Reply