Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Export w/ rows=N taking hours......

Re: Export w/ rows=N taking hours......

From: LiShan Cheng <exriscer_at_gmail.com>
Date: Sun, 19 Mar 2006 17:14:50 +0100
Message-ID: <6e9345580603190814p22a31f3fvf891830eb1a6a61a@mail.gmail.com>


I guess so since you are reading the dictionary even you set statistics to none.

cheers

LSC On 3/19/06, The Human Fly <sjaffarhussain_at_gmail.com> wrote:
>
> Just curious to know.
> Does this happens even when setting 'statistics' parameter to 'none'
> in the export?
>
>
> On 3/17/06, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
> >
> > Hi Mark,
> >
> > See Metalink 181072.1 for a couple alternative solutions: 1) remove
> > FIRST_ROWS from init.ora or 2) create a logon trigger to set
> > optimizer_goal=choose for your exp user.
> >
> > Regards,
> > Brandon
> >
> >
> >
> > Privileged/Confidential Information may be contained in this message or
> > attachments hereto. Please advise immediately if you or your employer do
> not
> > consent to Internet email for messages of this kind. Opinions,
> conclusions
> > and other information in this message that do not relate to the official
> > business of this company shall be understood as neither given nor
> endorsed
> > by it.
>
>
> --
> Best Regards,
> Syed Jaffar Hussain
> 8i,9i & 10g, OCP DBA
> Banque Saudi Fransi,
> Saudi Arabia
> http://jaffardba.blogspot.com/
>
> ----------------------------------------------------------------------------------
> "Winners don't do different things. They do things differently."
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Mar 19 2006 - 10:14:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US