Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to find large_pool map in SGA?

Re: How to find large_pool map in SGA?

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Mon, 12 Feb 2007 12:43:20 -0500
Message-ID: <c2213f680702120943r72761410l154170bb4c32024f@mail.gmail.com>


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_at_il.proquest.com> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 12 2007 - 11:43:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US