Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Export very slow - fixed by analyzing SYS
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 03 2005 - 14:02:39 CST