Re: Import speed falls off at 2million rows

From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 13 Mar 2009 08:53:19 -0700 (PDT)
Message-ID: <100382.67729.qm_at_web80602.mail.mud.yahoo.com>


> 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 9.2.0.8. 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       

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 13 2009 - 10:53:19 CDT

Original text of this message