RE: reading the SGA from my own program
- From: Tanel Poder <tanel.poder.003@xxxxxxx>
- To: mark.powell@xxxxxxx, "'Oracle Discussion List'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 22 Aug 2006 01:20:37 +0800
Also there are many interesting structures in SGA which the X$ tables just
don't reveal in Oracle ;)
Tanel.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Powell, Mark D
Sent: Tuesday, August 22, 2006 01:02
To: Oracle Discussion List
Subject: RE: reading the SGA from my own program
The primary point of directly reading shared memory is that by doing so you
bypass Oracle. So when the entire instance hangs and will not grant new
connections you can go around the problem and see what is happening (or not
happening as the case may be). You also avoid the latching overhead
required for accessing the shared memory structures via Oracle. True, you
may see some inconsistent data, but you will see it.
HTH -- Mark D Powell --
Other related posts:
