Scheduled task job in Oracle 10 GB

There are many automatically executed jobs in Oracle10g. For example, AUTO_SPACE_ADVISOR_JOB and GATHER_STATS_JOB

And so on. These automatically executed jobs will consume a certain amount of system resources while facilitating us. If you do not perform any of these automatic tasks

If you have some knowledge about the time and functions of the task, these automatic tasks will become a "mine" in your system ". Maybe it will be exploding that day.

The following SQL gives us a simple understanding of scheduled tasks and execution time in the system. This makes it easy for us to reasonably use

Scheduled tasks. Especially in case of system exceptions, it is important to check whether these scheduled tasks are at fault.

SQL> SELECT OWNER,
2 JOB_NAME,
3 to_char (last_start_date, 'yyyy-mm-dd hh24: mi: ss') last_start_date,
4 to_char (next_run_date, 'yyyy-mm-dd hh24: mi: ss') next_run_date,
5 PROGRAM_NAME,
6 JOB_TYPE,
7 JOB_ACTION
8 FROM DBA_SCHEDULER_JOBS;

SQL> SELECT log_id,
2 job_name,
3 to_char (REQ_START_DATE, 'yyyy-mm-dd hh24: mi: ss') REQ_START_DATE,
4 to_char (Actual_Start_Date, 'yyyy-mm-dd hh24: mi: ss') Actual_Start_Date,
5 to_char (log_date, 'yyyy-mm-dd hh24: mi: ss') log_date,
6 status,
7 SESSION_ID
8 FROM dba_scheduler_job_run_details
9 order by LOG_DATE DESC;