You should have asked a grizzly bear. They're much wiser
then marmots and they don't
run away that easily. Also, when you see a
grizzly bear 100ft away from you and realize
that you only have a camera with
you, then you begin to understand that there are bigger
worries in this world
then the location of database structures.
What a grizzly would tell you is
that, according to my sources, those tables are stored
in the "misc"
area of shared pool, which can easily be seen when selected * from
V$SGASTAT.
Here is what a grizzly would have in
mind:
POOL
NAME
BYTES
----------- -------------------------- ----------
shared pool 1M
buffer
2098176
shared pool KGLS
heap
4102928
shared pool PX
subheap
76920
shared pool
parameters
32796
shared pool free
memory
101833708
shared pool PL/SQL
DIANA
1028660
shared pool
FileOpenBlock
3476816
shared pool PL/SQL
MPCODE
547852
shared pool library
cache
30858108
shared pool
miscellaneous
11656764
shared pool pl/sql
source
2708
--
Mladen Gogala
Oracle DBA
>
-----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
>
Behalf Of Daniel Fink
> Sent: Monday, September 29, 2003 11:10 AM
>
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
>
Title: Message
Note:
This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mistransmission. If
you receive this message in error, please immediately delete it and all
copies of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Wang Trading
LLC and any of its subsidiaries each reserve the right to
monitor all e-mail communications through its networks. Any views
expressed in this message are those of the individual sender, except where the
message states otherwise and the sender is authorized to state them to be the
views of any such entity.
- x$ constructs and memory Daniel Fink
- RE: x$ constructs and memory Robson, Peter
- RE: x$ constructs and memory Hately, Mike (LogicaCMG)
- RE: x$ constructs and memory Mladen Gogala
- RE: x$ constructs and memory Orr, Steve
- RE: x$ constructs and memory Stephane Faroult
- Re: x$ constructs and memory Tanel Poder
- RE: x$ constructs and memory Orr, Steve
- RE: x$ constructs and memory Mladen Gogala
- Re: x$ constructs and memory Tanel Poder
- Re: x$ constructs and memory Tanel Poder
- RE: x$ constructs and memory Mladen Gogala
- Re: x$ constructs and memory K Gopalakrishnan
- Re: RE: x$ constructs and memory rgaffuri