Originally posted by hrishy
The wait event si significant as revealed by the statspack report.
Significant? (Remember, something has to be in the "top five waits". If your db & application are brilliantly tuned, with all data & parsed SQL in buffers, log switches & control file writes are about the only things left to wait on! ) So my question stands - how long do you wait for a switch?