Re: x$ksmsp

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 6 Sep 2001 20:02:40 +0100
Message-ID: <999803006.4031.0.nnrp-07.9e984b29@news.demon.co.uk>

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.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Chuck Hamilton wrote in message <9n8gj9$61bur$1_at_ID-85580.news.dfncis.de>...


>Already searched that site and found no descriptions of what the various

>values for KSMCHCLS mean.

>

Received on Thu Sep 06 2001 - 14:02:40 CDT