Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: IO Limit within PL/SQL (Oracle 8i)
Though the action should probably read 'Rewrite the offending code
efficiently'
-- Niall Litchfield Oracle DBA Audit Commission UK "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:b7gcp7$k0fk$1_at_ID-152732.news.dfncis.de...Received on Tue Apr 15 2003 - 04:15:27 CDT
> "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
>
>
>
>