Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: v$db_object_cache question - also
But there are many versios in the cache (of the same SQL), and they all have a different value for sharable_mem...
"Yong Huang" <yhuang_at_indigopool.com> wrote in message
news:9716qb$bif$1_at_news.sinet.slb.com...
> I can't help much. But I noticed that you really have only one version of
> the identical SQL in library cache SQL area. Check v$sqlarea and you see
> only one line for that SQL. The shareable_mem is a sum of all your
> shareable_mem in v$db_object_cache.
>
> Yong Huang
> yhuang_at_indigopool.com
>
> andrew_webby at hotmail <spam_at_no.thanks.com> wrote in message
> news:982777522.22933.0.nnrp-08.c30bdde2_at_news.demon.co.uk...
> > as an addition to that, there is a comment - again, identical - tagged
on
at
> > the end of the sql. Just mentioning in case that makes a difference ;-)
> >
> >
>
>
Received on Thu Feb 22 2001 - 04:03:07 CST