Home » RDBMS Server » Security » To find out whic row is locked by the particular user (2 Merged) (Windows)
To find out whic row is locked by the particular user (2 Merged) [message #507374] Sat, 14 May 2011 11:59 Go to next message
abhaybansal
Messages: 1
Registered: May 2011
Location: Panchkula
Junior Member
Hii All,

I am new to DBA domain,

please help me to find out that if the user has locked some row in
the database how to findout the rowid or the row which is locked by that particular USER.

Report message to a moderator

Re: To find out whic row is locked by the particular user [message #507378 is a reply to message #507374] Sat, 14 May 2011 12:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

query V$LOCK

Report message to a moderator

Re: To find out whic row is locked by the particular user (2 Merged) [message #507384 is a reply to message #507374] Sat, 14 May 2011 13:36 Go to previous message
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No way unless you yourself try to lock each and every row the user might have locked.

Regards
Michel

Report message to a moderator

Previous Topic: Oracle BECOME USER
Next Topic: Oracle Audit Design
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 04 21:47:17 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.