Home » RDBMS Server » Server Administration » How many transaction taken place in given time (oracle 12c Windows 2012)
How many transaction taken place in given time [message #679649] Thu, 12 March 2020 05:55 Go to next message
muthukrish104
Messages: 73
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
Re: How many transaction taken place in given time [message #679652 is a reply to message #679649] Thu, 12 March 2020 07:14 Go to previous messageGo to next message
BlackSwan
Messages: 26706
Registered: January 2009
Location: SoCal
Senior Member
count the number of COMMIT
Re: How many transaction taken place in given time [message #679657 is a reply to message #679649] Thu, 12 March 2020 08:02 Go to previous messageGo to next message
EdStevens
Messages: 1206
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?
Re: How many transaction taken place in given time [message #679662 is a reply to message #679649] Thu, 12 March 2020 11:28 Go to previous messageGo to next message
John Watson
Messages: 8268
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.
Re: How many transaction taken place in given time [message #679691 is a reply to message #679662] Tue, 17 March 2020 06:02 Go to previous messageGo to next message
muthukrish104
Messages: 73
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

Re: How many transaction taken place in given time [message #679694 is a reply to message #679691] Tue, 17 March 2020 07:53 Go to previous messageGo to next message
BlackSwan
Messages: 26706
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
Re: How many transaction taken place in given time [message #679696 is a reply to message #679691] Tue, 17 March 2020 08:20 Go to previous message
EdStevens
Messages: 1206
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.
Previous Topic: Calculating the size of the depending on the AUTOEXTENSIBALE
Next Topic: how to use catcon with username parameters
Goto Forum:
  


Current Time: Sat May 30 20:38:31 CDT 2020