Oracle Database Monitoring with
eG Enterprise

• Quantify overall database server workload. Monitor commits and rollbacks happening
• Identify top queries by I/O activities, CPU usage, memory usage
• Identify which queries are executing for a long time, highlight username, application, and query
• Identify if any application is leaking cursors (e.g., due to ResultSets not being closed)
• Identify the largest tables in the database server

• Monitor space usage by tablespace; determine when a tablespace is likely to run out of space
• Monitor the rollback segments. Track writes, waits, and gets to each segment and determine if additional rollback segments are necessary (e.g., waits > 5%)
• Track activity of each of the data files. Identify if the I/O activity is not balanced across all data files and if additional data files are required to balance the I/O activity
• Track system and session waits by type; identify how the database server can be used to minimize wait time
• Monitor fragmentation level of database tables and indexes, and be proactively alerted to situations when online/offline tuning of the database is required

• Track the session workload to the database server overall and identify sessions killed, sniped or in blocked mode
• Monitor sessions by users and identify if specific user sessions are causing query blocking
• Report on root-blockers - i.e., queries blocking other queries
• Identify which application/user is imposing the most load on the database server. Track if there is a database connection leak that is leaving orphaned connections to the database server

Track the key parameters that can affect database server performance:

• Does the server have sufficient CPU, memory, and disk resources?
• Is one of the disk drives seeing more I/O than others?
• Is there excessive disk queueing that can affect response times?
• Is the disk heavily fragmented and is defragmentation required?
• Are there any I/O errors during disk access that may indicate a faulty disk that is affecting database access?

eG Enterprise allows database performance to be monitored in the context of the applications using the database server.

• Without requiring any agents on the database servers, eG Enterprise APM traces all application accesses and reports on slow queries and exceptions during database processing.
• When a specific web page or URL is slow, you don't have to wonder any more as to what is causing the slowdown. eG Enterprise APM gives you the answers at your fingertips.

This eliminates finger-pointing between application development, application operations, and database admin teams.

• Generates proactive, real-time alerts based on hundreds of Oracle database statistics collected and analyzed in real-time
• Enables anytime, anywhere Oracle database monitoring and reporting of an IT infrastructure from any web browser
• Facilitates effective allocation of operations staff and optimization of Oracle database experts
• Offers integrated monitoring of the entire IT infrastructure including network, server, applications, and databases, and cross-correlation for bottleneck identification and analysis