Re: Sync redo log waits
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Feb 2013 17:38:58 -0000
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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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*
|
--
//www.freelists.org/webpage/oracle-l
Other related posts:
