How to find large_pool map in SGA?

Listers,

I need to identify memory chunks (addresses + sizes) within large pool where 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

--

http://www.freelists.org/webpage/oracle-l Received on Sun Feb 11 2007 - 11:37:31 CST