Huge Archive generation causing instance to hang
From: Apps DBA <dbaorapps_at_gmail.com>
Date: Sun, 30 Dec 2012 23:30:32 +0530
Message-ID: <CAHvOz+zTxvoyk-UwR571qv0S963zuwYgOg_uQHHo1040fcbQYw_at_mail.gmail.com>
Hi Gurus,
I am a newbie in reading AWR and concluding the issue lies at some point. Would require your advice in knowing where the issue lies during my production hung due to high archive generation today? Basically, redo generation bumped up caused the alerting mechanism to fail resulting in instances hung state. Please help me in understanding and analyzing the AWR report.
Date: Sun, 30 Dec 2012 23:30:32 +0530
Message-ID: <CAHvOz+zTxvoyk-UwR571qv0S963zuwYgOg_uQHHo1040fcbQYw_at_mail.gmail.com>
Hi Gurus,
I am a newbie in reading AWR and concluding the issue lies at some point. Would require your advice in knowing where the issue lies during my production hung due to high archive generation today? Basically, redo generation bumped up caused the alerting mechanism to fail resulting in instances hung state. Please help me in understanding and analyzing the AWR report.
Thanks,
RK
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Dec 30 2012 - 19:00:32 CET