361: Advanced Session Performance Monitoring via the SGA
Jonah Harris , EnterpriseDB Corporation Biography
Objectives: | SGA Architecture X$ Table C Structures Collecting Session and Statement Level Performance Data |
Abstract: | As frequent querying of Oracle's dynamic performance views introduces significant result variability and overhead, several commercial third-party Oracle performance monitoring tools have long-since extracted the information directly from the SGA. In this presentation we will take SGA access to the next level by discussing the techniques for retrieving session and statement-level performance data directly from the SGA and applying it to a sample performance monitoring application. We will also demonstrate the performance advantage gained using these monitoring methods. |
Audiernce Focus: | DBA |
Expertise: | Advanced |
Track: | Database |
Date: | Wednesday, April 16, 2008 |
Time: | 1:30 PM - 2:30 PM |