cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Database Agent for Oracle RAC

tarun_agastya1
Inactive

Hi,

With the help of DB agent can we get following details?

1.Capture Timeouts

2.Long Running Queries

3.Connection Failures

can someone help us whether we can capture these details with DB agents for oracle.

Thanks,

1 REPLY 1

BabarQayyum
Leader

Hello Tarun,

Below is the list of database measures available for the Oracle and Oracle RAC agent.


  • Active session count: Number of sessions that are in active state
  • All session count: Number of all sessions (including active)
  • Average physical read bytes: Average size in bytes in 30 second span of disk reads by all database instance activity including application reads, backup and recovery, and other utilities
  • Average physical write bytes: Average size in bytes in 30 second span of all disk writes for the database instance including application activity, backup and recovery, and other utilities.
  • Background CPU usage:
  • Configured nodes: number of nodes configured in cluster, reported by each database instance (node). Configured nodes mean nodes, that are part of this cluster database, even if they are offline or malfunctioning at the moment.
  • Connected nodes: number of connected cluster nodes, reported by each database instance (node). Connected nodes mean nodes, that are currently online, active and working.
  • Connection management:
  • CPU idle:
  • Foreground CPU usage:
  • Non Database CPU usage:
  • PL/SQL execute elapsed time:
  • SQL execute time:
  • SQL parse time:
  • Time spent on other activities:
  • Total wait time per second: Total time spent by all processes waiting on events.
  • User calls count: Number of user calls

You can also use the following plugin for the remaining measures.

https://community.dynatrace.com/community/display/...

Regards,

Babar