OraFAQ Forum: Server Administration » How many transaction taken place in given time

Home » RDBMS Server » Server Administration » How many transaction taken place in given time (oracle 12c Windows 2012)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How many transaction taken place in given time [message #679649]

Thu, 12 March 2020 05:55

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi,

Is there any way to find out how many transaction done between any given time.

Thanks and regards
M.krish

Report message to a moderator

Re: How many transaction taken place in given time [message #679652 is a reply to message #679649]

Thu, 12 March 2020 07:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

count the number of COMMIT

Report message to a moderator

Re: How many transaction taken place in given time [message #679657 is a reply to message #679649]

Thu, 12 March 2020 08:02

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

muthukrish104 wrote on Thu, 12 March 2020 05:55

Hi,

Is there any way to find out how many transaction done between any given time.

Thanks and regards
M.krish

This sounds like you are looking for some pre-conceived technical solution to an unknown (to us) business problem.
Before finding out "how many transaction done between any given time" I'd want to know what that business problem is, so that I could evaluate if the proposed solution is even valid (or best) for the given business problem.

In short, what will you do with that number if/when you get it?

Report message to a moderator

Re: How many transaction taken place in given time [message #679662 is a reply to message #679649]

Thu, 12 March 2020 11:28

John Watson
Messages: 8960
Registered: January 2010
Location: Global Village

Senior Member

muthukrish104 wrote on Thu, 12 March 2020 10:55

Hi,

Is there any way to find out how many transaction done between any given time.

Thanks and regards
M.krish

This is in your statspack (or AWR if you have licence) reports.

Report message to a moderator

Re: How many transaction taken place in given time [message #679691 is a reply to message #679662]

Tue, 17 March 2020 06:02

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi All,

Thanks for the solution.

I just wanted to know the fact, how to calculate it, not related to any business.

Hi John,

In what format the number of commits written in STATSPACK?

There is nothing count available in COMMIT keyword.

Kindly tell me.

Regards
M.krish

Report message to a moderator

Re: How many transaction taken place in given time [message #679694 is a reply to message #679691]

Tue, 17 March 2020 07:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://docs.oracle.com/cd/B16240_01/doc/doc.102/e16282/oracle_database_help/oracle_database_instance_throughput_commits_pt.html

Report message to a moderator

Re: How many transaction taken place in given time [message #679696 is a reply to message #679691]

Tue, 17 March 2020 08:20

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

muthukrish104 wrote on Tue, 17 March 2020 06:02

Hi All,

Thanks for the solution.

I just wanted to know the fact, how to calculate it, not related to any business.

While I can certainly understand intellectual curiosity (it has driven most of my IT career), there are some things that aren't worth perusing unless you have an actual problem to solve. Even if you had the number, it would be pretty much meaningless. Not all transactions are created equal. Some are commiting a simple, single-row UPDATE, and others are committing an insert of a million rows.

Report message to a moderator

Previous Topic:	Calculating the size of the depending on the AUTOEXTENSIBALE
Next Topic:	how to use catcon with username parameters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 06:52:22 CST 2024