How To Use oratop For Monitoring Oracle Databases

oratop is a utility that provides a general knowledge of database performance, similar to the top command in linux systems. When used with the Top command, we can get general information about the system performance.

It can be run as compiled script without requiring any installation. You can access the required file from document 1500864.1 at Oracle Support. There are compiled scripts for different operating systems and different database versions.

After downloading the relevant file, the file must be runnable by the oracle user.

Then you can set the required environment variables and run.

In our example, we downloaded the file named oratop.RDBMS_11.2_LINUX_X64, which is the necessary file for our 11.2 version database in Linux x86-64 platform.

Let’s rename the existing file and make it executable for oracle.

With oracle, we can set the necessary variables and run them as follows. Commands must be run in the following order.

We can run the oratop for our database in the local as below. The refresh interval we specified with -i may not provide accurate information in values less than 10 seconds. The default value is 5.

The sample screenshot is as follows.

It is also possible to monitor a remote database. We can also run the oratop command by connecting to other databases as follows.

For example;

Oratop must be run with a user who is either dba or a user who has the authority to select the following.

You can authorize a user for these views as follows.

To get help about oratop, you can run it with the -h parameter as follows.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *