Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to find large_pool map in SGA?
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-lReceived on Mon Feb 12 2007 - 11:43:20 CST
![]() |
![]() |