Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: IO Limit within PL/SQL (Oracle 8i)
"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
![]() |
![]() |