Re: Sync redo log waits

Your first thought should be to wonder what happened around 9:00 am for a couple of hours that did about 20 times the normal work. Did the overnight batch job get stuck and only start when someone got in in the morning.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings

Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543

• Original Message ----- From: "Saad Khan" <saad4u_at_gmail.com> To: <oracle-l_at_freelists.org> Sent: Tuesday, February 19, 2013 5:06 PM Subject: Sync redo log waits

| Hi Gurus,
| I'm writing regarding our prod environment with Oracle 11g (11.2.0.2) on
| 64-bit AIX 6.1 with storage on IBM XIV devices.
|
| The users have been complaining a very poor performance and all sorts of
| delays.
|
| DAY HOUR TOTAL
| --------------- ---- -----
| 2013-02-18 09 1
| 2013-02-18 10 1
| 2013-02-18 11 2
| *2013-02-19 09 18*
| *2013-02-19 10 18*
|

--
http://www.freelists.org/webpage/oracle-l