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:
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-lReceived on Fri May 24 2013 - 13:24:54 CEST