Re: x$ksmsp

From Jonathan Lewis's post earlier in this thread...

"In that case, you need Steve's book: p.93-94

    free - intuitively obvious
    recr - contains objects that can be dumped

            and recreated if required.
    perm - persistent objects, cannot be dumped     freeable - normally needed for the duration of a call

            or session, but could be dumped.  Cannot
            be recreated if dumped.

    R-free:
    R-freeable

        as for free and freeable, but in the reserved
        section of the shared pool."

BTW the "Steve" he's referring to is Stever Adams. His book seems to be the definitive work on Oracle internals. It's available on Amazon at http://www.amazon.com/exec/obidos/ASIN/156592598X/qid=1000218089/sr=1-2/ref= sc_b_2/103-0347679-1107836

• Original Message ----- From: "Ron Reidy" <ron_at_indra.com> Newsgroups: comp.databases.oracle.server Sent: Tuesday, September 11, 2001 1:56 AM Subject: x$ksmsp

> Can anyone point me to, or tell me what the values of x$ksmsp.ksmchcls
> mean and what they could tell me about the shared pool?
>
> Thanks.
> --
> Ron Reidy
> Oracle DBA
> Reidy Consulting, L.L.C.