Re: Obtain stats on packages and functions within packages

From: Yong Huang <>
Date: Thu, 27 Jan 2011 07:48:53 -0800 (PST)
Message-ID: <>


Other than sampling v$sql(*) views, or review AWR reports, you can audit on the table and package. For a package for instance, just type "audit execute on yourpackage". Later you query dba_audit_object (or dba_audit_trail). But this doesn't give you a way to query the execution times of a specific function inside a package.

If your audit_trail is still none, too bad. You could have set that to db or something. There shouldn't be any overhead if you never type "audit ..." command, but leaving it as (e.g.) db gives you convenience.

Yong Huang       

Received on Thu Jan 27 2011 - 09:48:53 CST

Original text of this message