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: TKPROF Snippet OraSrp:

OraSrp SQL Stats


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.