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