Hi Michael,
yes, the statistic "user commits" tells you how often a commit was issued.
But be careful - not every commit necessarily results in a "redo synch writes"
and is waiting on "log file sync". For example this happens due to
PL/SQL optimization and running commits in PL/SQL loop (single database call).
Take the other two statistics always into account.
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
Michael Calisi <oracle455@xxxxxxxxx> hat am 30. September 2015 um 17:14
geschrieben:
Need to confirm the number of times my database commits I have a few metrics
but want to be sure they are correct. Asking where can I find how
many commits are being done.
Is this telling me we did 22,696 commits during this period?
AWR
Statistic Total per Second
per Trans
user commits 22,696 12.4
0.6
