Re: Import speed falls off at 2million rows
- From: Yong Huang <yong321@xxxxxxxxx>
- To: david.cheyne@xxxxxxxxx
- 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:
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
