Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> DBMS_JOBS
I am having trouble getting dbms_job entries to execute. I have several
dbms_job entries which receive error in the alert.log file. The database is
Oracle version 8.0.5 running on UNIX Solaris 2.7. The test dbms_job is a
simple insert of sysdate and user into a temporary table. The error is
"ORA-02394: exceeded session limit on IO usage, you are being logged off".
The user which created the job does not have a limit on the user profile
parameter LOGICAL_READ_PER_SESSION. JOB_QUEUE_PROCESSES has been manipulated
from values of 3 to 10 with no success. I can execute successfully the
dbms_job by performing the dbms_job.run command; however, the SNP background
process continues to fail.
Can anyone point me in a direction to resolve this problem?
Thanks.
David Mauzey
ppoONE.com
a MedicalControl Company
(214) 267-3410
dmj_at_ppoone.com
Received on Tue Aug 15 2000 - 11:43:53 CDT