Oratop relies on Oracle client libraries. Set the following variables in your ~/.bashrc or before running:
# Change to a directory of your choice, e.g., /opt/oracle cd /opt/oracle
: You must download the standalone binary from My Oracle Support via Doc ID 1500864.1 . It is also bundled with the Autonomous Health Framework (AHF) (formerly TFA Collector). Installation and Setup oratop download linux
Test your SQL*Plus connection first:
If that fails, install cx_Oracle via pip: Oratop relies on Oracle client libraries
./oratop system@//hostname:1521/your_pdb_service
sudo apt update sudo apt install libdbi-perl libdbd-oracle-perl Installation and Setup Test your SQL*Plus connection first:
./oratop /nolog SQL> connect system@your_db
command, it displays critical metrics such as CPU usage, wait events, and top SQL statements in a continuously refreshing interface. Gavin Soorma 1. Availability and Pre-installation
Before we dive into the download, let’s clarify what oratop does. It provides a real-time, dynamic view of an Oracle database, showing:
python3 -c "import cx_Oracle"