Re: maximum open cursors exceeded

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/11/14
Message-ID: <64gu8t$ig7$1@news00.btx.dtag.de>#1/1

jennifer wrote:
>
> Looking for a fix or some sort of workaround.
> When trying to delete from a table I receive this error:
>
> ORA-01000: maximum open cursors exceeded
>
> Has anyone else encountered this?
>
> Thanks,
> jennifer

Hi,

check for the value of 'open_cursors ' in your iniorcl.ora-file. Also check oracle's oparation system related docs for the range this value can take and it's interference with SGA-size.

-- 
Regards

Matthias Gresz    :-)

Received on Fri Nov 14 1997 - 00:00:00 CST