Now, now, JL, you've confused me. Is the use of one or the other by DBCA indication of the choice reflecting "better" or "worse?" Anyway, I thought that the choice of tools in Oracle products reflected one product area manager owing another product area manager a favor and tortuous computations regarding the internal compensation model. ;) mwf -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jonathan Lewis Sent: Friday, June 18, 2004 5:59 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: system statistics in 10g If dbms_scheduler is better than dbms_job, why does DBCA use dbms_job and not dbms_schedule to do the hourly task to gather stats ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated May 1st ----- Original Message ----- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Thursday, June 17, 2004 6:42 PM Subject: RE: system statistics in 10g : my two euro cents: : in 10g, it is better to use DBMS_SCHEDULER than to use DBMS_JOBS ... : : Kind regards, : Lex. : : --------------------------------------------- : visit my website at http://www.naturaljoin.nl : --------------------------------------------- : ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------