Re: Export very slow - fixed by analyzing SYS

> 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.
--
http://www.freelists.org/webpage/oracle-l