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