Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

What is difference between "Statement Cumulative Statistics" and "Statement Self Statistics" in reports generated by OraSrp t

VimalshuMar 13 2023 — edited Mar 15 2023

I have generated trace for single session in oracle database(Version 19c). Then used TKPROF and ORaSrp tool to read raw trace files. What I observed for same sql statement OraSrp tool gives two stats

  1. Statement Cumulative Statistics
  2. Statement Self Statistics.

So which stats, I have to refer for analysis and what is the difference between "Statement Cumulative Statistics" and "Statement Self Statistics". Also "Statement Self Statistics" is matching with TKPROF.
TKPROF: OraSrp:
OraSrp SQL Stats

Comments
Post Details
Added on Mar 13 2023
0 comments
116 views