"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message
news:1173971933.027823.32750_at_l77g2000hsb.googlegroups.com...
> On Mar 14, 6:48 pm, NetComrade <netcomradeNS..._at_bookexchange.net>
> wrote:
>> We had a server where a job hang. We killed it, but no new job would
>> start. Increasing job_queue_processes would not help. Querying
>> dba_jobs_running would hang.
>>
>> Version is 9.2.0.7 running on RH 4 AMD x64
>>
>> Any clue?
>>
>> Job was hanging on "single-task message"
>> Restart of the db got jobs working again.
>> .......
>> We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc)
>> remove NSPAM to email
>
> Sounds like the old "please contact oracle support" scenario.
>
>
Or even search metalink for jobs not running or something like that.
I do recall a recent 10g gather_system_stats job not running that metalink
provided me a solution for.
Is it broken (select job, what, broken from dba_jobs;).
Received on Thu Mar 15 2007 - 15:50:44 CDT
