Oracle GENEREL

Question 1

Where to view the locks in oracle database?

Answer 1

$lock
62) What are locks?
locks are low level serialisation mechanism called end queues in oracle which protects the database of data changes

Question 2

hat latches?

Answer 2

latches are typically a kind of locks but held for very short time to protect the memory structures of the instance

Question 3

Where does Oracle latch or lock occurs?

Answer 3

Oracle latch occurs in the memory structures i.e, in instance ex:buffer latch,redolog latch,shared pool latch
ORacle lock occurs at block level to protect the integrity of the data as the data stored in the block only ex: row lock,table lock etc