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.
(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.