Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Lightweight Database Performance Monitoring Tool

Ali Raza MemonJun 10 2022

Could someone please recommend a light-weight Oracle database monitoring tool except Enterprise Manager/Cloud Control, to monitor the databases. The requirement is to have a nice graphical representation of peek activities and when we click on it, it should show the activity behind it.
Thanks in advance.

This post has been answered by cormaco on Jun 10 2022
Jump to Answer

Comments

cormaco
Answer

You can try the Instance Viewer in SQL Developer:
SQL Developer Concepts and Usage (oracle.com)
The database instance viewer enables a DBA user to see a graphical representation of information about the instance associated with a connection. The types of information displayed include:
Database
Clients
Sessions
Processes (Counts, Execution Rate, Parse Rate, Open Cursors, Commit Rate)
Waits
Memory (DB Block Rate, Logical Reads, Allocation, Redo Generation)
Storage (Files, Redo Log)
DB CPU Ratio (database operations as a percentage of CPU activity)
Top SQL (provides performance metrics on SQL operations, which are sorted based on the CPU time required)
You can interact with the instance viewer display, including:
Panning the diagram by dragging it
Zooming the diagram in or out by using control-drag
Drilling down to a detailed display by hovering over graphical element to show a dark blue border and then double-clicking in that element
You can control the amount of history shown in graphs that include a time axis by using the Database: Instance Viewer preferences.

Marked as Answer by Ali Raza Memon · Jul 24 2022
Ali Raza Memon

Thanks for the detailed explanation. Do you know any open source one?

cormaco

Thanks for the detailed explanation. Do you know any open source one?
You are aware that SQL Developer is free (but not open source)?
Oracle SQL Developer - Oracle SQL Developer Releases
Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks.

kuljeet singh -

EM Express URL would serve the purpose.

1 - 4

Post Details

Added on Jun 10 2022
4 comments
492 views