Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Execution Statistics for SPs, SFs, Packages and SQLs by schema objects

Re: Execution Statistics for SPs, SFs, Packages and SQLs by schema objects

From: <slee328_at_gmail.com>
Date: 21 Nov 2005 20:16:32 -0800
Message-ID: <1132632992.364019.24170@o13g2000cwo.googlegroups.com>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US