How to deal with the problem of space surge caused by Oracle scheduling jobs

This article mainly introduces "how to deal with the space surge problem caused by Oracle scheduling jobs". In daily operation, I believe many people have doubts about how to deal with the space surge problem caused by Oracle scheduling jobs. I have consulted all kinds of materials and sorted out simple and easy operation methods. I hope to help you answer the doubts about "how to deal with the space surge problem caused by Oracle scheduling jobs"! Next, please follow the small series to learn together!

1. Description of the problem

Received a call from a customer telling him that the database disk directory space has grown particularly fast recently and will be full in 1-2 days. After contacting the customer to analyze the database, it is found that the reason for the sharp increase in space is mainly caused by the large amount of trace files generated by job tasks. Looking at the trace file information, it is found that DBMS_SCHEDULE schedules ORACLE_APEX_MAIL_QUEUE, which is scheduled once every 5 minutes.

2. Solution

View the scheduling status and related information of the job

SQL> select owner,job_name,state,start_date from dba_scheduler_jobs where job_name='ORACLE_APEX_MAIL_QUEUE'; OWNER--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------JOB_NAME STATE START_DATE-------------------------------------------------- -------------------- ---------------------------------------------------------------------------APEX_040200ORACLE_APEX_MAIL_QUEUE SCHEDULED 07-JUL-14 06.29.55.278873 AM -07:00

Disable the job schedule.

SQL> exec dbms_scheduler.disable('APEX_040200.ORACLE_APEX_MAIL_QUEUE'); PL/SQL procedure successfully completed.SQL> select owner,job_name,state,start_date from dba_scheduler_jobs where job_name='ORACLE_APEX_MAIL_QUEUE'; OWNER--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------JOB_NAME STATE START_DATE-------------------------------------------------- -------------------- ---------------------------------------------------------------------------APEX_040200ORACLE_APEX_MAIL_QUEUE DISABLED 07-JUL-14 06.29.55.278873 AM -07:00 SQL> At this point, the study on "How to deal with the space surge problem caused by Oracle scheduling jobs" is over. I hope you can solve your doubts. Theory and practice can better match to help you learn, go and try it! If you want to continue learning more relevant knowledge, please continue to pay attention to the website, Xiaobian will continue to strive to bring more practical articles for everyone!