Re: ASH report - missing blocking session info
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Wed, 23 Jan 2013 23:11:56 -0800 (PST)
Message-ID: <1359011516.71062.YahooMailNeo_at_web161304.mail.bf1.yahoo.com>
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.
Date: Wed, 23 Jan 2013 23:11:56 -0800 (PST)
Message-ID: <1359011516.71062.YahooMailNeo_at_web161304.mail.bf1.yahoo.com>
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.
Thanks,
Sai
http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 24 2013 - 08:11:56 CET