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 -- //www.freelists.org/webpage/oracle-l