361: Advanced Session Performance Monitoring via the SGA

Speakers:

Jonah Harris, EnterpriseDB Corporation Biography

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.

Track: Database - RDBMS Internals

Product Line: 10g,11g

Expertise: Advanced

Prerequisites: Basic understanding of Oracle architecture and performance data.

Objective 1: SGA Architecture

Objective 2: X$ Table C Structures

Objective 3: Collecting Session and Statement Level Performance Data

Session: 361

Date: Wednesday, April 16, 2008

Time: 1:30 PM - 2:30 PM

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.
Track:	Database - RDBMS Internals
Product Line:	10g,11g
Expertise:	Advanced
Prerequisites:	Basic understanding of Oracle architecture and performance data.
Objective 1:	SGA Architecture
Objective 2:	X$ Table C Structures
Objective 3:	Collecting Session and Statement Level Performance Data
Session:	361
Date:	Wednesday, April 16, 2008
Time:	1:30 PM - 2:30 PM