The Necessary Ingredients
Oracle SGA is nothing more than a large and rapidly changing piece of memory structure in the eyes of an external program. From here on we will show you how to access the X$KSUSECST structure externally. The X$KSUSECST structure provides the information for the V$SESSION_WAIT view. The program needs to have the following information before it can successfully access the SGA contents:
The shared memory identifier (shmid), also known as the SGA ID
The SGA base address
The starting address of X$KSUSECST
The record size ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
