Re: Error in executing submitted job

Hi,

ORA-02394 exceeded session limit on I/O usage, logging off Cause: An attempt was made to exceed the maximum I/O allowed by the LOGICAL_READS_PER_SESSION clause of the user profile. Action: If this happens often, ask the database administrator to increase the LOGICAL_READS_PER_SESSION limit of the user profile.

        Peter.

Motley Crue wrote:

> Hi,
> After I've submitted a job via the package dbms_job, there's an error
> encountered during the execution of the job which is recorded in the snp log
> files that says:
>
> ORA-12012: error on auto execute of job 6
> ORA-02394: exceeded session limit on IO usage, you are being logged off
>
> I've no problems when I run the job interactively using dbms_job.run. Is there
> something that I've missed out? I'm using Oracle 8.0.3 on Solaris 2.5.1 . TIA.
>
> --
> Choon Leong
Received on Fri Apr 17 1998 - 05:44:15 CDT