Originally posted by marist89
The condition may be exacerbated by your big redo log buffer. [/B]
I hear conflicting information on REDO BUFFER SIZE. Unfortunatly it's not something you can change on the fly!
Why would you consider it big? Is it too big? And what effect is that having?
Disk IO is quite high - I've got Spotlight so can produce purdy pictures... These are BEFORE during normal operations. I'll snap some more when I run a CTAS test.



I would love to put a trace on the main system, just a little wary of the impact it would have. It's not something you can switch on and off quickly when using MTS. From my testing on the test machine, the traces will keep going while MTS keeps the connection and only creates the trace file(s) several hours later.
It's an option - but I'll want to think about it...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Guy Wicks
Database Manager
The British Library