Resolving Shutdown Immediate Hang Situations
Many times Oracle DBA's are faced with a situation where shutting down the instance with shutdown immediate seems to take infinite time and gives a impression that the session is…
Read Full RecipeTag: Performance
Tracing Sessions with Event 10046
10046 Event is used to trace SQL statements (similar to sql_trace=true) with additional details depending on the tracing level which is specified. 10046 EVENT levels: 1 - Enable standard SQL_TRACE…
Read Full Recipe
Sign on Letter to Larry Ellison on AWR and ASH Licensing
While surfing across the blog's, I found this particular link, a compaign which is aimed at getting free access to the ASH and AWR reports. I believe most of us…
Read Full Recipe
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
Diagnostics For Database Hang
Many 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