Home » RDBMS Server » Performance Tuning » Number of transactions
Number of transactions [message #170373] Wed, 03 May 2006 08:33 Go to next message
Messages: 6
Registered: February 2006
Location: Venezuela
Junior Member

Can anyone help me about how can i know or sumarize the amount of transactions ocurred in the Data Base?

Thanks in advance
Re: Number of transactions [message #170687 is a reply to message #170373] Thu, 04 May 2006 17:19 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Be careful about your definition of a transaction...

You should be able to count the commits & rollbacks using logminer. Try this to count the commits, rollbacks in a trace file.

From Oracle mag in 2000:

# Script to calculate # of commits and rollbacks from a trace file
# Takes trace file as input
# XCTEND rlbk=%d rd_only=%d
# ----------------------------------------------------------------------------
#  XCTEND      A transaction end marker.
#  rlbk        1 if a rollback was performed, 0 if no rollback (commit).
#  rd_only     1 if transaction was read only, 0 if changes occurred.
grep XCTEND $1  > /tmp/read.lst
commit=`grep XCTEND /tmp/read.lst | grep "rlbk=0, rd_only=0" | wc -l`
trans=`grep XCTEND /tmp/read.lst | wc -l`
rollback=`grep XCTEND /tmp/read.lst | grep "rlbk=1, rd_only=0" | wc -l`
echo " "
echo "Transactions"
echo "~~~~~~~~~~~~"
echo "Transaction Ends  $trans"
echo "Real Commits      $commit"
echo "Rollbacks         $rollback"
Previous Topic: performance problem while extracting the data
Next Topic: Query Tuning
Goto Forum:

Current Time: Sun May 26 22:16:11 CDT 2024