Re: Huge Archive generation causing instance to hang
- From: Lei Zeng <leizeng2003@xxxxxxxxx>
- To: "dbaorapps@xxxxxxxxx" <dbaorapps@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "ora-apps-dba@xxxxxxxxxxxxx" <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Mon, 7 Jan 2013 22:42:16 -0800 (PST)
Would you please try DBspeed? It has a documented case study for this issue.
http://dbspeed.com/case_study/top_redo_generator.html
As long as you have AWR and ASH data collected, you can use DBspeed to help you
dig out the problem SQL statement which caused huge archived log generation.
DBspeed http://dbspeed.com/index.html One year free trial.
There are some case studies on the website. It can help you understand AWR and
ASH data.
Regards,
Lei
________________________________
From: Apps DBA <dbaorapps@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx; ora-apps-dba@xxxxxxxxxxxxx
Sent: Sunday, December 30, 2012 10:00 AM
Subject: Huge Archive generation causing instance to hang
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
