Home » SQL & PL/SQL » SQL & PL/SQL » how to determine a lock
how to determine a lock [message #198794] Wed, 18 October 2006 10:00 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
is there any settings/dictionary in oracle where I can see the lock setting. whether a table level lock or row level lock?

I think the default is row level lock, but I am not quite sure.
Can someone help.
Re: how to determine a lock [message #198795 is a reply to message #198794] Wed, 18 October 2006 10:03 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://orafaq.com/node/854
Re: how to determine a lock [message #198798 is a reply to message #198794] Wed, 18 October 2006 10:11 Go to previous message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member
Thanks for the quick response. And it's great help.
Great link. Gives me lot of useful information related my question.
Previous Topic: ORA-00937Group by / avg problem
Next Topic: funtion to count characters
Goto Forum:
  


Current Time: Sat Aug 19 10:02:30 CDT 2017

Total time taken to generate the page: 0.06861 seconds