Home » SQL & PL/SQL » SQL & PL/SQL » find the lock on particular date and time (oracle 10g,oracle 11g)
find the lock on particular date and time [message #572940] Tue, 18 December 2012 15:51 Go to next message
y.michaelholding
Messages: 5
Registered: December 2012
Junior Member
As we know, we can easily find out the locks which are currently active session.

Is any other way to find out locks on particular date and time using data dictionary?

For example,

we have to find whether TT_objects occured the lock or not on ON yesterday.


Thanks,
Michael

Report message to a moderator

Re: find the lock on particular date and time [message #572944 is a reply to message #572940] Tue, 18 December 2012 16:19 Go to previous messageGo to next message
BlackSwan
Messages: 20085
Registered: January 2009
Senior Member
>Is any other way to find out locks on particular date and time using data dictionary?
no

Report message to a moderator

Re: find the lock on particular date and time [message #572945 is a reply to message #572940] Tue, 18 December 2012 16:23 Go to previous messageGo to next message
ThomasG
Messages: 2881
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
No way that I know off. And I can't imagine there being a way, since locks happen all the time and logging them all would generate huge amounts of data.

Only when there are DEADlocks, then an error "ORA-00060: Deadlock detected" is generated in the alert.log

Report message to a moderator

Re: find the lock on particular date and time [message #572965 is a reply to message #572940] Wed, 19 December 2012 01:24 Go to previous message
Michel Cadot
Messages: 54125
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is one: you can dump the blocks, DML locks are in there.

Regards
Michel

Report message to a moderator

Previous Topic: oracle 11g issue
Next Topic: automate inserts from one schema to another
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 18 10:39:32 CDT 2013

Total time taken to generate the page: 0.10078 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.