Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I have some questions about locks i

Status
Not open for further replies.

mm8294

MIS
Oct 12, 2001
73
US
I have some questions about locks in Oracle:

(1) Which statements or what kind of transactions will cause table level or row level locks?
(2) How do I check if a transaction causes table or row level locks on a table?
(3) Is there any way to explicitly specify the lock mode I want and overwrite the default?

I talked to a Informix DBA and he said he has 'page lock' problem and he will change it to 'row lock'. And suddenly I realized that need to do some research, too.

Thanks in advance.
 
If you look in the Oracle concepts manual, there is a chapter on locking and it has a wonderful matrix of the different kinds of locks that are available and what types of statements throw which type of lock.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top