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 RecipeDefinition 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 RecipeToday 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 RecipeMany times Oracle DBA's are in a situation when the database is hung and does not seem to be responding. In some scenarios, state is such that you cannot even…
Read Full Recipe