Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> x$ constructs and memory
I was sitting on a mountain here in Colorado, pondering Oracle
optimization and an interesting scenario crossed my feeble mind.
As I began to ponder this (I asked the resident marmot, but he
must be a SQL*Server expert...), I came up with several
questions.
Where in memory (sga or other) do the x$ constructs reside?
Some of them are 'populated' by reading file-based structures
(control file, datafile headers, undo segments). Does this
information reside in memory or is it loaded each time the x$
construct is accessed?
What happens when these x$constructs begin to consume large
amounts of memory? Is there an upper bound?
Daniel Fink
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: Daniel.Fink_at_Sun.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Mon Sep 29 2003 - 10:10:03 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
- text/x-vcard attachment: Card for Daniel Fink