RE: reading the SGA from my own program

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Tue, 22 Aug 2006 01:20:37 +0800
Message-id: <009501c6c546$1e337830$6401a8c0@windows01>

Also there are many interesting structures in SGA which the X$ tables just don't reveal in Oracle ;)

Tanel.

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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 --

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Aug 21 2006 - 12:20:37 CDT