Forum Stats

  • 3,872,915 Users
  • 2,266,490 Discussions
  • 7,911,382 Comments

Discussions

Lightweight Database Performance Monitoring Tool

ProDBA
ProDBA Member Posts: 120 Blue Ribbon

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.

Tagged:

Best Answer

  • cormaco
    cormaco Member Posts: 2,037 Silver Crown

    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.

Answers

  • cormaco
    cormaco Member Posts: 2,037 Silver Crown

    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.

  • ProDBA
    ProDBA Member Posts: 120 Blue Ribbon

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

  • cormaco
    cormaco Member Posts: 2,037 Silver Crown

    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 -
    kuljeet singh - Member Posts: 3,752 Gold Trophy

    EM Express URL would serve the purpose.