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.
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: 22690
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

query V$LOCK
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: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way unless you yourself try to lock each and every row the user might have locked.

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


Current Time: Fri Aug 22 15:40:56 CDT 2014

Total time taken to generate the page: 0.17289 seconds