Oracle10g: default jobs

Hi,

Oracle10g 10.1.0.3.0 (64 bit)
AIX 5.3L ML01 (64 bit)

The following jobs are created by default in 10g - during db creation GATHER_STATS_JOB
PURGE_LOG Questions:
1. I would like to know the EXACT SQL code for these two jobs? (What is actually being executed).

I checked $ORACLE_HOME/rdbms/admin and all I could find is the following. One of the script says gather_database_stats_job_proc is for INTERNAL use only.

• from catmwin.sql
• Create gather stats program. BEGIN dbms_scheduler.create_program( program_name=>'gather_stats_prog', program_type=>'STORED_PROCEDURE', program_action=>'dbms_stats.gather_database_stats_job_proc', number_of_arguments=>0, enabled=>TRUE, comments=>'gather statistics maintenance program'); EXCEPTION when others then if sqlcode = -27477 then NULL; else raise; end if; END; /
• from catsch.sql
• Create purge log program. BEGIN dbms_scheduler.create_program( program_name=>'purge_log_prog', program_type=>'STORED_PROCEDURE', program_action=>'dbms_scheduler.auto_purge', number_of_arguments=>0, enabled=>TRUE, comments=>'purge log program'); exception when others then if sqlcode = -27477 then NULL; else raise; end if; END; /

Thanks for any pointers.
wagen Received on Tue Jul 19 2005 - 10:20:22 CDT