Re: 9i parallel query is slower than 8i

hi,

we have same problem in our DB.

if table has chained/migrated rows then oracle parallel process use db file sequential read instead of direct path read in 9i.

if table recreated then there is no diffrence between 8i and 9i.

regards.

AK

--
Posted via http://dbforums.com