Re: ASH report - missing blocking session info

From: Saibabu Devabhaktuni <>
Date: Wed, 23 Jan 2013 23:11:56 -0800 (PST)
Message-ID: <>

As you have said it yourself if blocking session is idle, it won't be captured in ASH. By default only one out of every 10 ASH samples make it AWR dba_hist_active_sess_history view. If you have archive logs available for that time, you can use logminer and query by the blocking session from ASH in v$logmnr_contents view. Even though actual DML statement is not captured in logminer but the corresponding change record and when each DML was executed can be identified.


Received on Thu Jan 24 2013 - 08:11:56 CET

Original text of this message