Archive for the ‘Tools’ Category

oratop – monitoring tool

Posted: May 22, 2014 in Tools

Just found out about the new oracle tool oratop, not used it live issues yet but it looks a great tool if your on linux and on 11.2.0.3 or >

The oracle note on the product is – oratop – Utility for Near Real-time Monitoring of Databases, RAC and Single Instance (Doc ID 1500864.1)

Sample output

oratop

Very simple to run just download the binary from oracle rename it to oratop, give execute permissions then set your session to the database you want to monitor and run
– $ ./oratop -i 10 / as sysdba
replace the 10 with how ever many secs you want the interval to be

Review oracle’s guide on the tool for all the options – oratop