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