Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> FW: 10g sqlldr and PARALLELism
Roger,
Try setting SKIP_INDEX_MAINTENANCE from its default of FALSE to TRUE. Each parallel job might be attempting to maintain indexes simultaneously (which would result in queueing to run sequentially).
Create a procedure/script to rebuild indexes once at the end, after all loads have completed successfully.
Hope this helps...
-Tim
on 1/19/05 4:09 PM, Tanel P=F5der at tanel.poder.003_at_mail.ee wrote:
> Hi,
>=20
> Given your server, I assume that your IO is fast enough for these paralle=
l
> loads as well?
>=20
>=20
>=20
>=20 >> I am running Oracle 10g on an IBM P690 with AIX. For a particular job I >> load 8GB using sqlldr, direct=3Dyes in two hours. I wanted to speed this >> up, so I broke the job up into four jobs, each loading 2GB each with the >> parallel=3Dtrue option turned on. These four jobs now take six hours >> each. Why is there a time increase? >>=20 >> I can't find a parameter that will solve the apparent contention that is >> going on. >>=20 >> Any ideas where I may be going wrong? >>=20 >> Thanks ... Roger
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jan 22 2005 - 22:00:11 CST
![]() |
![]() |