Re: Array Processing

From: Dan <danm_at_aeimusic.com>
Date: Mon, 05 Oct 1998 12:13:56 -0700
Message-ID: <36191A74.53400B0@aeimusic.com>

> I have a weird problem and I don't know if I it can be solved by
> changing a parameter in INIT.ORA or it's an ORACLE bug! Consulting
> Oracle might give us a clue.
>
> To be specific, I'm doing an array fetch. If I run it to fetch 100
> rows at a time, no error is generated. If I run it for 500 rows at a
> time, I get the following error:
>
> ORA-03113: end-of-file on communication channel

I have run into this problem running DSQL on VM (Oracle 7.1.4 and 7.1.6) with very large databases. The problem was fixed by increasing the size of the SGA.

Daniel A. Morgan Received on Mon Oct 05 1998 - 14:13:56 CDT