Re: Oracle 10g hangs intermittently waiting for I/O
Date: Sat, 16 May 2009 16:20:41 -0400
Outside of the oracle bugs (I assume you are researching the suitability/ applicability in your environment), have you looked into the any effect of CTAS statements. (By any chance, are these CTAS statements running in parallel ?)
Check if the CTAS running with parallel sessions is gobbling up your temp tablespace and making database processing come to a frozen/hang state.
http://www.freelists.org/webpage/oracle-l Received on Sat May 16 2009 - 15:20:41 CDT