Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Export very slow - fixed by analyzing SYS

Export very slow - fixed by analyzing SYS

From: Luc Demanche <lucdemanche_at_gmail.com>
Date: Thu, 3 Mar 2005 13:59:24 -0500
Message-ID: <4b36877205030310595379c026@mail.gmail.com>


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-l
Received on Thu Mar 03 2005 - 14:02:39 CST

Original text of this message

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