A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

Oratop Utility

2 min read

Oratop is a text based user interface tool similar to top command for monitoring basic database operations in real time for RAC and Standalone DB.

oratop utility can be downloaded from http://support.oracle.com/

This tool is only available on Linux platforms for Oracle 11.2 and higher, but can connect to Oracle instances running on other platforms.

Create a softlink to the oratop file as a best practice . The file’s permissions will need to be changed to get it executed .

[oracle@localhost oratop]$ ls -ltrh
total 23
-rw-r--r-- 1 oracle oinstall 1347286 Aug  28 14:52 oratop.RDBMS_12.1_LINUX_X64

[oracle@localhost oratop]$ ln -s oratop.RDBMS_12.2_LINUX_X64 oratop

[oracle@localhost oratop]$ chmod 777 oratop.RDBMS_12.2_LINUX_X64

[oracle@localhost oratop]$ ls -ltrh
total 23

lrwxrwxrwx 1 oracle oinstall     27 Aug  28 14:54 oratop -> oratop.RDBMS_12.2_LINUX_X64

-rwxrwxrwx 1 oracle oinstall 1347286 Aug  28 14:52 oratop.RDBMS_12.2_LINUX_X64

Set LD_LIBRARY_PATH environment variable .

[oracle@localhost oratop]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib

[oracle@localhost oratop]$ ./oratop
./oratop -f -d -i 5 / as sysdba

While oratop is running, pressing the ‘h’ key will bring up a help menu showing various commands.

Options:
-d : real-time (RT) wait events, section 3 (default is Cumulative)
-k : FILE#:BLOCK#, section 4 lt is (EVENT/LATCH)
-m : MODULE/ACTION, section 4 (default is USERNAME/PROGRAM)
-s : SQL mode, section 4 (default is process mode)
-c : database service mode (default is connect string)
-f : detailed format, 132 columns (default: standard, 80 columns)
-b : batch mode (default is text-based user interface)
-n : maximum number of iterations (requires number)
-i : interval delay, requires value in seconds (default: 5s)
-v : oratop program version number
-h : this help

Pressing below alphabets for displaying specific information.

k = Events/Latches and File Number, Data Block.
a = Display the database's ASM information
m = Display Programs and Modules.
x = Display Explain Plan for a given SQL identifier.
s = Display Process Mode (default) and SQL Mode.
t = Display tablespace information