What release of 9i it is? Rel 1 or Rel 2?

I have used sqlldr reasonably extensively in almost all versions since
5.x; I am surprised to know this.

What was the criteria you used for Comparing?

Anyway, are you loading into the same table structures in the Same
server?
If so are there any extra indexes?
Did you verify what other processes were running?

Provide more info.

HTH
GovindanK


On Fri, 27 Aug 2004 15:19:28 -0700, "Udi"
<oracledba-ezmlmshield-x91083087.[Email address protected] said:
> Trace - we run on 8.1.7 and like it, and tested 9i and found it slower,
> and didn't like it.
>
> However, Oracle pretty much forces you to upgrade if you want to maintain
> support. If you have any words of wisdom on speed problems with 9i - we
> would be very interested.
>
> Thanks,
>
> Udi
>
>
>
>
>
>
> "Trace R Jones " <oracledba-ezmlmshield-x58888608.[Email address
> protected]
> 08/27/2004 05:29 AM
>
>
> To: "LazyDBA Discussion" <[Email address protected]
> cc:
> Subject: sql loader taking longer in 9i than 8i
>
>
>
>
>
>
> We have two versions of the same database. SQL Loader in 9i is taking
> much
> LONGER than in the 8i database. We've ruled out network issues already.
> Anyone have any ideas?
>
> TRJ
>
>
>


Oracle LazyDBA home page