Proactively Monitor Oracle performance with DBTuna

With hundreds of configuration parameters and thousands of metrics to monitor, it’s no small task for Oracle DBA's to monitor the overall health of their Oracle databases.

DBTuna takes a time-based approach to monitoring, allowing you to examine the performance of SQL statements over time and where that time was spent, for example, fetching, sorting or waiting on a lock. The statements are then ranked with the worst performing at the top. Data is also by Client, session, user, database, Program, Module and host, allowing you to quickly drill up and down. Once you have identified a problematic statement you can click on the text and it will take you to the SQL screen where you can examine the execution plan.

Other screens within DBTuna allow you to see the performance of sessions currently connected, view database statistics and browse database objects.

Using DBTuna's approach to monitoring you only need to address problems when you see they are affecting your application SQL i.e. if your SQL is running fast why bother focussing on configuration parameters and metrics??

Copyright ©2010 DBTuna. All rights reserved.