Re: Seeing what's pinned in the shared pool

Have a look at V$DB_OBJECT_CACHE. It contains a chaed flag in V7.1 and later.

Wayne Linton

Fuzzy wrote:
>
> People,
>
> I'm looking for a way to see the names of the objects pinned in the
> shared pool. The doco only suggests ways to count hit ratios for
> what's there, without actually naming the objects.
>
> Any help would be much appreciated.
>
> Ciao
> Fuzzy
> :-)
Received on Sat Jul 19 1997 - 00:00:00 CDT