Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Thu Mar 03 2005 - 14:09:00 CST