Home » RDBMS Server » Server Administration » Locking problem
Locking problem [message #305205] Mon, 10 March 2008 02:49 Go to next message
ataufique
Messages: 79
Registered: November 2006
Member
Hi ,

I was having locking problem and was released , but we failed to
take the detail of what caused the locking.

Is it possible to get the info , the table locked, the query which caused the locking ....etc

I am monitoring my process by below query but i cant see any locking..
select object_name, o.object_id from user_objects o, v$locked_object l
where o.object_id = l.object_id

pls suggest.

Thanks in advance
Regards,
Re: Locking problem [message #305217 is a reply to message #305205] Mon, 10 March 2008 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Join with v$session and v$sql.

Regards
Michel
Re: Locking problem [message #305451 is a reply to message #305205] Mon, 10 March 2008 16:40 Go to previous messageGo to next message
shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada
Junior Member

hi,
you can only see locks while they last or shortly after.
one thing you can do, if you are not using some monitor tool to
hold history is to write some kind of batch job to grab this information every givven time into a table.
shlomi.
Re: Locking problem [message #305475 is a reply to message #305451] Mon, 10 March 2008 23:39 Go to previous message
ataufique
Messages: 79
Registered: November 2006
Member
Hi,

Thanks
Previous Topic: partitioning a non-partitioned table
Next Topic: How to Find the user tables that are not referenced by any DB object
Goto Forum:
  


Current Time: Tue Dec 06 06:38:02 CST 2016

Total time taken to generate the page: 0.09042 seconds