Re: Huge Archive generation causing instance to hang
From: GG <grzegorzof_at_interia.pl>
Date: Mon, 31 Dec 2012 15:11:21 +0100
Message-ID: <50E19D09.4080308_at_interia.pl>
W dniu 2012-12-30 19:00, Apps DBA pisze:
> 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.
>
Hi,
Date: Mon, 31 Dec 2012 15:11:21 +0100
Message-ID: <50E19D09.4080308_at_interia.pl>
W dniu 2012-12-30 19:00, Apps DBA pisze:
> 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.
>
Hi,
there are many ways to find out what is messing with redo : 1. for persisting problems use snapper
|_at_snapper out,gather=s,*sinclude=%redo_size%* 10 1*"select sid from v$session"
2. Use Logminer and mine Your redo/arch, look for DMLs .
Regards
GregG
*|
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 31 2012 - 15:11:21 CET