HW enqueue contention with LOB

Definition Enqueues are local locks that serialize access to various resources. Enqueue wait event indicates a wait for a lock that is held by another session (or sessions) in an…

Read Full Recipe
454 views 3:54 pm 4 Comments

Shared Sub Pools

Today I will discuss about Shared pool subpools which have been introduced in release 9iR2 and higher (To be precise >9.2.0.5) and can be controlled by a hidden parameter "_kghdsidx_count…

Read Full Recipe
430 views 2:01 pm 2 Comments