Home » RDBMS Server » Server Administration » Concurrency
Concurrency [message #441705] Tue, 02 February 2010 17:02 Go to next message
BigByte
Messages: 2
Registered: February 2010
Junior Member
is an audit on concurrency?
Re: Concurrency [message #441706 is a reply to message #441705] Tue, 02 February 2010 17:04 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
BigByte wrote on Tue, 02 February 2010 15:02
is an audit on concurrency?

I don't understand this question.
Please clarify

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Concurrency [message #441707 is a reply to message #441706] Tue, 02 February 2010 17:09 Go to previous messageGo to next message
BigByte
Messages: 2
Registered: February 2010
Junior Member
I try to explain ... I can see all the concurrency with locks that have been there every few hours?
Re: Concurrency [message #441709 is a reply to message #441707] Tue, 02 February 2010 17:17 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
BigByte wrote on Tue, 02 February 2010 15:09
I try to explain ... I can see all the concurrency with locks that have been there every few hours?


It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

There are many types of locks.

How would an independent observer conclude you question has been correctly answered?

post SQL that would show "concurrency with locks" that exist NOW.
Re: Concurrency [message #441732 is a reply to message #441707] Tue, 02 February 2010 22:49 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I can see all the concurrency with locks that have been there every few hours?

Query v$lock

Regards
Michel
Previous Topic: one schema vs multiple schema
Next Topic: server dows automatically after every half an hour or 15 min.
Goto Forum:
  


Current Time: Sun Dec 11 02:18:01 CST 2016

Total time taken to generate the page: 0.08578 seconds