Have you checked number of queues lately?
Kind Regards,
Hatzistavrou Yannis -----Original Message-----
Hello List, I am running into weird dbms_job issue. I have a dbms_job to collect perfstat every 1 hour , job was running fine for last 8-9 months without any issue. For last 3 days job is stopping every night around 2 AM. I am not seeing any trace file, any logs in alert file. Any idea what is cuasing this. Below is the output from dba_jobs. We are on 9202 AIX 5L.
JOB LAST_DATE
NEXT_DATE
THIS_DATE B
FAILURES TOTAL_TIME DISCLAIMER: |
- dbms_job issue. Avnish.Rastogi
- RE: dbms_job issue. Venu Gopal
- RE: dbms_job issue. Igor Neyman
- RE: dbms_job issue. Avnish.Rastogi
- RE: dbms_job issue. Jamadagni, Rajendra
- RE: dbms_job issue. Avnish.Rastogi
- Re: dbms_job issue. Stephane Faroult
- Hatzistavrou John