Re: How to find large_pool map in SGA?
- From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 11 Feb 2007 14:50:22 -0500
Found the answer. If one is interested - "heapdump level 32" would do it.
On 2/11/07, Alex Gorbachev <gorbyx@xxxxxxxxx> wrote:
Listers,
I need to identify memory chunks (addresses + sizes) within large poolwhere
certain areas are located.
I know how to do it with shared pool areas. The total area size is in
X$KSMSS and chunks are in X$KSMSP:
SQL> select * from x$ksmss where KSMSSNAM = 'sql area';
ADDR INDX INST_ID KSMSSLEN KSMSSNAM
KSMDSIDX
-------- ---------- ---------- ---------- --------------------------
----------
B70F8C88 2 1 0 sql
area 0
B70F8C88 19 1 12365696 sql
area 1
SQL> select * from x$ksmsp where KSMCHCOM = 'sql area' and rownum <= 10;
ADDR INDX INST_ID KSMCHIDX KSMCHDUR KSMCHCOM
KSMCHPTR KSMCHSIZ KSMCHCLS KSMCHTYP KSMCHPAR
-------- ---------- ---------- ---------- ---------- ----------------
-------- ---------- -------- ---------- --------
B6DF9B0C 0 1 1 4 sql area
35FFF000 4096 recr 4095 363E9E3C
B6DF9AD4 1 1 1 4 sql area
35FFE000 4096 freeabl 0 36291BE4
B6DF9A64 3 1 1 4 sql area
35FFCBD0 4096 recr 4095 363FC11C
B6DF9A2C 4 1 1 4 sql area
35FFBBD0 4096 recr 4095 363EDD0C
B6DF99F4 5 1 1 4 sql area
35FFABD0 4096 recr 4095 3636B8BC
B6DF98A4 11 1 1 4 sql area
35FF87A0 4096 recr 4095 363F34FC
B6DF986C 12 1 1 4 sql area
35FF77A0 4096 freeabl 0 363E95DC
B6DF971C 18 1 1 4 sql area
35FF5308 4096 recr 4095 3638906C
B6DF96E4 19 1 1 4 sql area
35FF4308 4096 freeabl 0 3638906C
B6DF9674 21 1 1 4 sql area
35FF2ED8 4096 freeabl 0 3636B8BC
10 rows selected.
Unfortunately, I cannot find any X$ table for large pool that is similar
to x$ksmsp. Large pool is managed differently than shared pool and has no
LRU list for example. However, I would still expect to find large pool map
somewhere. I tried to find something in X$KSMMEM but I couldn't identify
there what I'm looking for.
Any suggestions are greatly appreciated.
TIA,
Alex
--
Best regards,
Alex Gorbachev
The Pythian Group
Sr. Oracle DBA
http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
--
Best regards,
Alex Gorbachev
The Pythian Group
Sr. Oracle DBA
http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com
Other related posts: