Skip to Main Content
Forums

Oracle Database Discussions

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!

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
#database, #general-database-discussions-ideas, #oracle, #performance, #sql, #tuning
0 comments
367 views