Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Execution Statistics for SPs, SFs, Packages and SQLs by schema objects
> And your Oracle installation has a version number?
10.1.0.4.0
> Have you licensed diagnostic pack?
yes
The issue here is that I can find the Top 5 SQL, SPs, SFs and Packages from the ADDM report. However, I do not know how I can get a hold of the number of executions of SQLs, SPs, SFs and Packages within a begin date/time and end date/time.
Regards,
Stephen Lee
Received on Mon Nov 21 2005 - 22:16:32 CST