SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

STATSPACK Report - Top SQL

matt_gloverAug 21 2007 — edited Sep 5 2007

Within the "Top SQL" sections of the STATSPACK report,

                                                     CPU      Elapsd
 Physical Reads  Executions  Reads per Exec %Total Time (s)  Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
         94,709            1       94,709.0    3.6     2.00     20.11   73184811
Module: C:\CSDC\amanda446\amanda.exe
SELECT Folder.FolderYear, Folder.CopyFlag, Folder.FolderSequence
, Folder.FolderSection,   Folder.FolderRevision, Folder.FolderTy
pe, Folder.FolderRSN, Folder.PropertyRSN,   Folder.InDate, Folde
r.FinalDate, Folder.FolderDescription, Folder.IssueDate,   Folde
r.ExpiryDate, Folder.StatusCode, Folder.IssueUser, Folder.SubCod

is there a way to have the report list the entire query, instead of a snippet? I am trying to track down where in my application this SQL runs and the rest of the query would be quite helpful in doing so.

I'm running 9.2.0.8.0.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2007

Added on Aug 21 2007

5 comments

1,053 views