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 very slow - fixed by analyzing SYS

RE: Export very slow - fixed by analyzing SYS

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Thu, 3 Mar 2005 21:14:24 +0100
Message-Id: <20050303201447.AF18080113E4@smtp-out1.tiscali.nl>


in that case, there is no reason why you shouldn't gather statistics on the SYS schema...
kind regards,

Lex.  



Visit my website at http://www.naturaljoin.nl

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Luc Demanche
Sent: Thursday, March 03, 2005 20:05
To: Paul Drake
Cc: oracle-l_at_freelists.org
Subject: Re: Export very slow - fixed by analyzing SYS

Sorry,

Oracle 9.2.0.4 on Windows 2000

On Thu, 3 Mar 2005 14:03:58 -0500, Paul Drake <bdbafh_at_gmail.com> wrote:
> > What should I do ?
>
> post the oracle version number, for starters.
>
> -bdbafh
>
> ---filler text to get by lameness filter--- ---filler text to get by
> lameness filter--- ---filler text to get by lameness filter---
>
>
> On Thu, 3 Mar 2005 13:59:24 -0500, Luc Demanche <lucdemanche_at_gmail.com> wrote:
> > Hi gurus,
>
> > Since I switched my OPTIMIZER_MODE from choose to first_row, my
> > export process was very very slow ....
>
> > My export process was waiting on views like sys.exu9pdt ... I
> > decided then to get statistics on SYS objects .
>
> > After that, my export flies, it so fast.
>
> > Since ever, we say that we should not analyze SYS or SYSTEM objects. ....
> > What should I do ?
>
> > Thanks
> > Luc
>
> > Luc Demanche
> > Oracle DBA
> > (514) 867-9977
>
> --
> #/etc/init.d/init.cssd stop
> # f=ma, divide by 1, convert to moles.
>

--
Luc Demanche
Oracle DBA
(514) 867-9977
--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 03 2005 - 15:18:03 CST

Original text of this message

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