oratop utility for oracle database performance tuning

oratop utility for oracle database performance tuning 

[oracle@pri ~]$ ./oratop -h
oratop: Release 14.1.2
Usage:
         oratop [ [Options] [Logon] ]

         Logon:
                {username[/password][@connect_identifier] | / }
                [AS {SYSDBA|SYSOPER}]

                connect_identifier:
                     o Net Service Name, (TNS) or
                     o Easy Connect (host[:port]/[service_name])
         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 release version number
             -h : this help

[oracle@pri ~]$

ln -s /u01/app/oracle/product/18.0.0/db/lib/libclntshcore.so.18.1 /u01/app/oracle/product/18.0.0/db/lib/libclntshcore.so.12.1


[oracle@pri ~]$ ./oratop / as sysdba
./oratop: error while loading shared libraries: libclntsh.so.12.1: cannot open shared object file: No such file or directory
[oracle@pri ~]$


ln -s /u01/app/oracle/product/18.0.0/db/lib/libclntshcore.so.18.1 /u01/app/oracle/product/18.0.0/db/lib/libclntsh.so.12.1



[oracle@pri ~]$ chmod 777 oratop.RDBMS_11.2_LINUX_X64
[oracle@pri ~]$ ./oratop.RDBMS_11.2_LINUX_X64 / as sysdba

oratop: Release 14.1.2 Production on Fri Feb 15 18:32:24 2019
Copyright (c) 2011, Oracle.  All rights reserved.

Connecting ...
Oracle 18c - IND 18:32:27 up: 0.4h,   1 ins,    0 sn,   0 us, 1.7G mt, 10.0% db
ID %CPU LOAD %DCU   AAS  ASC  ASI  ASW  AST IOPS %FR   PGA UTPS UCPS SSRT  %DBT
 1    0    0    0     9    0    0    0    0    3  15  254M    0    0    0   100

EVENT (C)                        TOT WAITS   TIME(s)  AVG_MS  PCT    WAIT_CLASS
db file sequential read               6389        96    15.1   56      User I/O
DB CPU                                            36           21
db file scattered read                 360        15    43.3    9      User I/O
external table read                      1        15 15072.8    9      User I/O
control file parallel write            577         9    17.2    6    System I/O

ID   SID     SPID USR PROG S  PGA SQLID/BLOCKER OPN  E/T STA STE EVENT/*LA  W/T
 1    60     3836 SYS orat D 5.1M 7qj5jsdnpsn1a SEL    0 ACT CPU cpu runqu   8u

oratop - Utility for Near Real-time Monitoring of Databases, RAC and Single Instance (Doc ID 1500864.1)