Oracle Database

User rating:
5 (3 ratings)

1. Set Up Oracle Monitoring

Create a user account in Oracle (or use an existing one) that LoadUI can use to connect. The user need to have read access to the tables V$LATCH, V$LIBRARYCACHE, V$SYSSTAT, V$SESSION, V$SESSTAT, V$SGASTAT, V$STATNAME, V$SYSTEM_EVENT and V$WAITSTAT.

2. LoadUI Setup

You need to have an Oracle JDBC Driver in your [LoadUI installation directory]/ext directory. The file is called ojdbc6.jar and can be downloaded for free here.

3. Oracle RAC

In LoadUI 2.5.5 we are adding support for RAC. If you are going to use counters that are used globally for your RAC cluster you need to give the user access to the global view, and check the RAC checkbox when creating the Monitor in LoadUI. You need to give the user access to the following tables instead of the regular view: GV$LATCH, GV$LIBRARYCACHE, GV$SYSSTAT, GV$SESSION, GV$SESSTAT, GV$SGASTAT, GV$STATNAME, GV$SYSTEM_EVENT and GV$WAITSTAT.

4. Troubleshooting

Make sure that no firewall is blocking the port used in between the server and LoadUI.

5. Available Statistics

  • Call rates (per sec)
    • Execute Count
    • Parse Count (hard)
    • Parse Count (total)
    • User Commits
    • User Rollbacks
  • Event Waits (per sec)
    • Buffer Busy Waits
    • Control File IO
    • Db File IO
    • Direct Path Read
    • Log File Write
    • SQL*net
  • Logical IO (per sec)
    • Consitent Gets
    • DB Block Changes
    • DB Block Gets
    • User Rollbacks
  • Misc.
    • Chained Fetch Ratio (%)
    • CPU Parse Overhead (%)
    • Cursor Authentications
    • Free List Contention (%)
    • Libcache, Get Hit Rate (%)
    • Libcache, Pin Hit Rate (%)
    • Open cursors
    • Recursive Calls Rate (%)
  • Miss rates
    • Buffer Cache
    • Latch - Immediate
    • Latch - Willing To Wait
    • SQL Area (shared pool reloads)
  • Physical IO (per sec)
    • Physical Reads
    • Physical Writes
    • Redo Writes
  • SGA Memory
    • Fixed SGA
    • Java Pool
    • Large Pool
    • Log Buffer
    • Shared Pool
  • Sessions
    • Active
    • Active (%)
    • Inactive
    • System

You can also extend this monitor to include any counters that you can get using a SQL query.