Re: How to find large_pool map in SGA?

  • From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • Date: Mon, 12 Feb 2007 12:43:20 -0500

Thanks Mark.
Unfortunately, it doesn't include any addresses just like X$KSMSS.

SQL> select * from X$KSMLS;

ADDR                   INDX    INST_ID   KSMSSLEN
KSMSSNAM                     KSMDSIDX
---------------- ---------- ---------- ---------- --------------------------
----------
0000002A97CDB3B0          0          1          0 free
memory                         0
0000002A97CDB3B0          1          1          0
miscellaneous                       0
0000002A97CDB3B0          2          1          0 free
memory                         1
0000002A97CDB3B0          3          1          0
miscellaneous                       1



On 2/12/07, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxxxxx> wrote:

 Alex,

Also, see X$KSMLS.

-Mark






--
Best regards,
Alex Gorbachev

The Pythian Group
Sr. Oracle DBA

http://www.pythian.com/blogs/author/alex/
http://blog.oracloid.com

Other related posts: