Very Computer

by **Fuzz** » Fri, 11 Jul 1997 04:00:00

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
:-)

by **Jurij Mod** » Fri, 11 Jul 1997 04:00:00

On Thu, 10 Jul 1997 01:13:50 GMT,

>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.

You can use supplied package DBMS_SHARED_POOL. Its procedure
SIZES(minsize) will list all objects residing in shared pool that are
larger than specified minimal size in kilobytes.

From SQL*Plus:

BEGIN
DBMS_SHARED_POOL.SIZES(0);
END;
/

will list all objects (packages, functions, procedures, cursors,
triggers, .....) currently held in your shared pool.

Since this procedure use DBMS_OUTPUT to display data, don't forget to
set SERVEROUTPUT ON with sufficient output buffer size.

Quote:>Ciao
>Fuzzy
>:-)

Regards,
============================================================
Jurij Modic Republic of Slovenia

============================================================
The above opinions are mine and do not represent any official
standpoints of my employer

by **Nathan Hugh** » Fri, 11 Jul 1997 04:00:00

>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.

There's a dbms package procedure that will give you teh names of all
objects of size > x in teh shared pool - the output of this has
a kept column. Don't remember off hand the name of the package -
but look at $ORACLE_HOME/rdbms/admin/dbmspool.sql for the details.

--
/(o\ Nathan D. Hughes

by **Wayne Linto** » Mon, 14 Jul 1997 04:00:00

have a look at view V$DB_OBJECT_CACHE. In ORACLE7 V7.1 and later there
is a field that indicates if the package is pinned.

Wayne Linton
Shell Canada Ltd.

by **Fuzz** » Tue, 15 Jul 1997 04:00:00

On Sun, 13 Jul 1997 23:53:28 -0600, Wayne Linton

>have a look at view V$DB_OBJECT_CACHE. In ORACLE7 V7.1 and later there
>is a field that indicates if the package is pinned.

>Wayne Linton
>Shell Canada Ltd.

Thanks Wayne, that was exactly what I was after.

Happy hacking
Fuzzy
:-)

by **Wayne Linto** » Sun, 20 Jul 1997 04:00:00

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

Wayne Linton

> 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
> :-)

Very Computer

Seeing what's pinned in the shared pool

Seeing what's pinned in the shared pool

Seeing what's pinned in the shared pool

Seeing what's pinned in the shared pool

Seeing what's pinned in the shared pool

Seeing what's pinned in the shared pool

Seeing what's pinned in the shared pool