Re: IO Limit within PL/SQL (Oracle 8i)

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Tue, 15 Apr 2003 09:34:38 +0200
Message-ID: <b7gcp7$k0fk$1@ID-152732.news.dfncis.de>

"abc" <abc_at_abc.com.au> schrieb im Newsbeitrag news:b7g8us$g62$1_at_mws-stat-syd.cdn.telstra.com.au...
> HI,
>
> I am running into err_num: -2395 Message: ORA-02395: exceeded call limit
on
> IO usage
> in the middle of my PL/SQL - between 2 SQLs.
>
> Does anyone know how to reset the IO once after 1 SQL completed.
>
> Thanks
>
>

Maybe it is not only a PL/SQL issue: Reading the manual:

ORA-02395 exceeded call limit on IO usage

Cause: An attempt was made to exceed the maximum I/O for a call, a parse, execute, or fetch, allowed by the LOGICAL_READS_PER_CALL clause of the user profile.

Action: If this happens often, ask the database administrator to increase the LOGICAL_READS_PER_CALL limit of the user profile.

hth, Jan Received on Tue Apr 15 2003 - 02:34:38 CDT