Re: Import speed falls off at 2million rows
Date: Fri, 13 Mar 2009 08:53:19 -0700 (PDT)
> or can you enable sqltrace on this import process to see why
> it is slowing down ?
Speaking of SQL trace on an import, you set trace=y:
Not sure when it started to exist. But it works in 10g and 126.96.36.199. Not available for data pump, where you have to create a logon trigger temporarily to set sql_trace.
But if you need bind variables or wait events, trace=y doesn't work.
Yong HuangReceived on Fri Mar 13 2009 - 10:53:19 CDT