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

This message: [ Message body ]
Next message: Yong Huang: "Re: source of package invalidation"
Previous message: Yong Huang: "Re: session_cached_cursors"
Maybe in reply to: David Cheyne: "Import speed falls off at 2million rows"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message