Re: v$db_object_cache question

From: Yong Huang <yhuang_at_indigopool.com>
Date: Wed, 21 Feb 2001 13:57:31 -0600
Message-ID: <9716qb$bif$1@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 Wed Feb 21 2001 - 13:57:31 CST

Re: v$db_object_cache question - also