what is the difference between lock and latch in oracle?
While locks permit shared and concurrent access, latches allow access to only a single process at a time and prevent other processes within Oracle from accessing that process while a latch is held by the process. Latches affect only data structures within the Oracle SGA, whereas locks apply to Oracle transactions.