OraFAQ Forum: Enterprise Manager » How to Find the user who has Locked a Table ?

Home » RDBMS Server » Enterprise Manager » How to Find the user who has Locked a Table ?

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

How to Find the user who has Locked a Table ? [message #182189]

Thu, 13 July 2006 08:54

vivekanandaan
Messages: 8
Registered: July 2006

Junior Member

Hi,

We have a Multi user software which locks a table frequently.

We use to the OEM and look for the user and ask them to exit the session.

Is there any SQL query which can find who is locking the table ?

Urgent Plz.

Regards

R.Vivek

Report message to a moderator

Re: How to Find the user who has Locked a Table ? [message #182192 is a reply to message #182189]

Thu, 13 July 2006 09:04

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

See "Display database locks and latches (with tables names, etc)" and "Another lock monitor script" at http://www.orafaq.com/scripts/

Report message to a moderator

Re: How to Find the user who has Locked a Table ? [message #183196 is a reply to message #182189]

Wed, 19 July 2006 21:21

vivekanandaan
Messages: 8
Registered: July 2006

Junior Member

Hi Frank,

The Scripts are totally confusing as i don't have any DBA knowledge.

Could you just give me a sql statement.

Regards

R.Vivek

Report message to a moderator

Previous Topic:	Help plz
Next Topic:	Basic Enterprise manager question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 10:40:48 CDT 2024