Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: x$ constructs and memory

RE: x$ constructs and memory

From: Robson, Peter <>
Date: Mon, 29 Sep 2003 07:24:46 -0800
Message-ID: <>

Dan -

I think you are in grave danger of forgetting the point of sitting on the top of mountains....

Either that or your Colorado mountains have nothing on our variety from the NW Highlands of Scotland... (grin!)


> -----Original Message-----
> From: Daniel Fink [mailto:Daniel.Fink_at_Sun.COM]
> Sent: Monday, September 29, 2003 4:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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

This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the
BGS. .                  

Please see the official ORACLE-L FAQ:
Author: Robson, Peter

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Sep 29 2003 - 10:24:46 CDT

Original text of this message