Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: x$ksmsp
Already searched that site and found no descriptions of what the various
values for KSMCHCLS mean.
"Anton Buijs" <aammbuijs_at_hetnet.nl> wrote in message
news:eaBybuvNBHA.72_at_net037s.hetnet.nl...
> Check www.ixora.com.au
>
> Chuck Hamilton <chuck_hamilton_at_yahoo.com> schreef in berichtnieuws
> 9n8acd$5tt08$1_at_ID-85580.news.dfncis.de...
> > I'm trying to determine what is the largest free (or freeable) chunk of
> > memory in the shared pool from the x$ksmsp table. Problem is I can't
find
> > any documentation for the columns and what the class and comment values
> > mean. Would the following query give me what I want?
> >
> > select max(ksmchsiz)
> > from x$ksmsp
> > where ksmchcls like '%free%';
> >
> > If you can point me to a source that tells what the following mean I'd
> > appreciate it too.
> >
> > KSMCHCLS
> > =========
> > R-free
> > R-freea
> > free
> > freeabl
> > perm
> > recr
> >
> > Thanks in advance.
> >
> > --
> > Chuck Hamilton
> > chuck_hamilton_at_yahoo.com
> >
> > "Do not be deceived, God is not mocked; for whatever a man sows, this he
> > will also reap. (Gal 6:7 NASB)
> >
> >
> >
> >
>
>
Received on Thu Sep 06 2001 - 13:51:19 CDT