Excessive disk reads, hash join, parallel, Insert as select

From: <Laimutis.Nedzinskas_at_seb.lt>
Date: Fri, 24 May 2013 14:24:54 +0300
Message-ID: <OF924A8992.2C00FE25-ONC2257B75.003E2B29-C2257B75.003EB546_at_seb.lt>



Hi
One more try (i.e. cry) for help:

11.2.0.3 db does insert as select from 10.2.0.4 db. The plan is hash join (normally it reads 200GB and completes) and parallel degreee 4.
However, time and again the statement goes into infinite processing and gets killed with 6TB of data read from disks (data source is V$SQL and DBA_HIST_SQLSTATS)
Any ideas, bug references ?
My best guess - hash join grace algorithm (http://en.wikipedia.org/wiki/Hash_join) overpartitions...

Thank you in advance, Laimis N

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 24 2013 - 13:24:54 CEST

Original text of this message