Re: Export very slow - fixed by analyzing SYS
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: lucdemanche@xxxxxxxxx
- Date: Thu, 3 Mar 2005 14:03:58 -0500
> 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@xxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
