Re: Import speed falls off at 2million rows

From: Yong Huang <>
Date: Fri, 13 Mar 2009 08:53:19 -0700 (PDT)
Message-ID: <>

> 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: exp trace=y
imp trace=y

Not sure when it started to exist. But it works in 10g and 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 Huang       

Received on Fri Mar 13 2009 - 10:53:19 CDT

Original text of this message