i. Preventing other transactions from updating the same row
ii. Unlike other databases, it’s not costy for Oracle to have many Locks
TM Lock: Preventing others from modifying the table structure while I am updating its data
Exclusive DDL Lock: When I am DDLing something (create/drop/alter, etc.), you cannot DDL it or DML it.
Share DDL Lock: When I am DDLing somthing lightly(create index, etc.), you cannot DDL it, but you can DML it.
Breakable parse locks: ….
Latch: To protect objects — Whatever, do use "BIND Variables".
Manual Locking: …