Job Queue Process use lots of memory

From: sealo <seahalo_at_gmail.com>
Date: 4 Jan 2007 18:30:02 -0800
Message-ID: <1167964202.236591.38480@11g2000cwr.googlegroups.com>

Hello,
Now the ORACLE was often down every one week. But this issue had not happened before. And checking the system monitor log, it shows that the memory was used up.

And, according to the alert log, it shows that the oracle was dead because
* kkjcre1p: unable to spawn jobq slave process * Except this, there are no abnormal log in the log.

And I check the current running status, the process ora_j000 have already used 240M memory, and the usgae was still increasing.

I also check the DBA_Jobs, all the jobs are in normal status, no break.

I guess, the memory was used up by the ora_j000. Could you give me something method to find the root cause?

Environment

ORACLE Release 10.1.0.2.0
Linux: 2.4.20 Received on Thu Jan 04 2007 - 20:30:02 CST