Re: Oracle 10g hangs intermittently waiting for I/O
- From: Rajeev Prabhakar <rprabha01@xxxxxxxxx>
- To: Paweł Kotlarz <pkotla@xxxxxx>
- Date: Sat, 16 May 2009 16:20:41 -0400
Pawel,
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.
-Rajeev
--
//www.freelists.org/webpage/oracle-l
Other related posts:
