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
- Statement Cumulative Statistics
- 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.