Oratop Utility
2 min readOratop 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
