Re: Obtain stats on packages and functions within packages

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       

--
http://www.freelists.org/webpage/oracle-l