Re: Oracle 10g hangs intermittently waiting for I/O

From: Rajeev Prabhakar <>
Date: Sat, 16 May 2009 16:20:41 -0400
Message-ID: <>


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.

-- Received on Sat May 16 2009 - 15:20:41 CDT

Original text of this message