OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Locking problem

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

Locking problem [message #305205]

Mon, 10 March 2008 02:49

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,

Report message to a moderator

Re: Locking problem [message #305217 is a reply to message #305205]

Mon, 10 March 2008 03:18

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Join with v$session and v$sql.

Regards
Michel

Report message to a moderator

Re: Locking problem [message #305451 is a reply to message #305205]

Mon, 10 March 2008 16:40

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.

Report message to a moderator

Re: Locking problem [message #305475 is a reply to message #305451]

Mon, 10 March 2008 23:39

ataufique
Messages: 79
Registered: November 2006

Member

Hi,

Thanks

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 19:56:01 CDT 2024