Oracle provides automatic (implicit) locking and manual (explicit) locking
-
Automatic locking - locking is performed automatically and requires no user action
-
depending on the action requested, implicit locking occurs for SQL statements as necessary
-
Row-level locking and table-level locking
-
One or more Oracle lock managers maintain locks
-
Two general types of locks - exclusive locks and shared locks
-
Manual locking - explicitly issued locks by a user on certain resources
-
override default locking
-
can be at either row-level or table-level
-
can be either exclusive or shared
|
