Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: v$db_object_cache question - also
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 Wed Feb 21 2001 - 13:57:31 CST
![]() |
![]() |