Re: package size

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 22 Sep 2005 18:54:26 GMT
Message-ID: <C5DYe.1389$xc4.999@newssvr13.news.prodigy.com>

Sybrand Bakker wrote:

> On Thu, 22 Sep 2005 17:12:23 GMT, bigToeHereNO_SPAMM_at_hotmail.com
> (bigToe) wrote:
>
>

>>We are investigating pinning packages in the shared pool.  I don't
>>think I can use the DBMS_SHARED_POOL.SIZES procedure to give me sizes
>>of all our packages.  Is there another way to do this?

>
>
> dba_objects.compiled_size, IIRC
>
> --
> Sybrand Bakker, Senior Oracle DBA

Looking it up, one assumes you meant

DBA_OBJECT_SIZE (lists the sizes, in bytes, of various PL/SQL objects)

which I didn't know about until now, so thanks for pointing it out.

-Mark Bole Received on Thu Sep 22 2005 - 13:54:26 CDT