Home » RDBMS Server » Server Administration » Finding number of transactions (10g)
Finding number of transactions [message #400476] Tue, 28 April 2009 06:09 Go to next message
anjum.suri
Messages: 14
Registered: February 2008
Junior Member
Hi All

Could anyone please tell me how can I find answers to below questions either by using AWR or SPREPORT or by any query?

1.) Is it possible to tell the average/estimated transaction count that takes place each day? e.g. during the working day 200 transactions take place on the database per day, say for 01/04/2009.



2.) Would it be possible to tell the number of transactions that take place per month (average/estimated). e.g March 2009

Thanks
Re: Finding number of transactions [message #400480 is a reply to message #400476] Tue, 28 April 2009 06:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_HIST_SYSSTAT
statistics "user commits" and "user rollbacks"

Regards
Michel
Re: Finding number of transactions [message #400494 is a reply to message #400476] Tue, 28 April 2009 08:20 Go to previous messageGo to next message
anjum.suri
Messages: 14
Registered: February 2008
Junior Member
Can we pull some meaningful information from below?

Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 14,227.82 2,496.83
Logical reads: 59,739.67 10,483.69
Block changes: 89.61 15.73
Physical reads: 30,010.32 5,266.50
Physical writes: 4.43 0.78
User calls: 165.42 29.03
Parses: 36.73 6.45
Hard parses: 7.48 1.31
Sorts: 7.65 1.34
Logons: 0.12 0.02
Executes: 36.46 6.40
Transactions: 5.70

% Blocks changed per Read: 0.15 Recursive Call %: 47.98
Rollback per transaction %: 0.65 Rows per Sort: 1550.58

Re: Finding number of transactions [message #400507 is a reply to message #400494] Tue, 28 April 2009 09:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
These are data from v$sysstat, you can find their history in the view I mentionned.

Regards
Michel
Re: Finding number of transactions [message #400531 is a reply to message #400507] Tue, 28 April 2009 10:28 Go to previous messageGo to next message
anjum.suri
Messages: 14
Registered: February 2008
Junior Member
if user commits and user rollback are added in awr report; then that gives u number of transactions
Re: Finding number of transactions [message #400533 is a reply to message #400531] Tue, 28 April 2009 10:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Correct.

Regards
Michel
Re: Finding number of transactions [message #401067 is a reply to message #400494] Fri, 01 May 2009 07:13 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Well, the bottom line:
Transactions: 5.70
tells you that during the period of the report, you averaged 5.7 transactions per second.

Converting this to a monthly figure is left as an excercise for the reader (hint - make sure you get a series of samples to let you get a reliable figure for the Transactions/second)
Previous Topic: Grant privilege
Next Topic: excessive archive log are generating by oracle
Goto Forum:
  


Current Time: Sun Dec 04 00:34:49 CST 2016

Total time taken to generate the page: 0.09552 seconds