Re: finding in use program

On Mar 5, 8:02 am, "okys" <elmas..._at_gmail.com> wrote:
> hi,
>
> i wonder how can i find which pl/sql package is in use at the moment.
>
> thanks in advance.

Look at v$db_object_cache where the object_type = 'PACKAGE'. The pins columns count > 0 means the package is in use.

See the Oracle version# Reference Manual for information on the view.

HTH -- Mark D Powell -- Received on Mon Mar 05 2007 - 08:18:18 CST