By default, Oracle manages locking, taking care of concurrency locks for you. Oracle provides a method to lock
a whole table, but there is no explicit "select for update" syntax to lock individual rows within a table.
Here is a good link for understanding Oracle locking mechanisms and how to use the stats$enqueuestat table to view locks.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.