Re: ORA-01037
From: MS <ora_dba_2000_at_yahoo.com>
Date: Tue, 14 Nov 2000 16:21:05 -0600
Message-ID: <3A11BAD1.4F3701E9_at_yahoo.com>
Date: Tue, 14 Nov 2000 16:21:05 -0600
Message-ID: <3A11BAD1.4F3701E9_at_yahoo.com>
Alex:
Thanks, I'll try that...
MS
Alex Filonov wrote:
> In article <3A106691.9EFA866F_at_yahoo.com>,
> MS <ora_dba_2000_at_yahoo.com> wrote:
> > Can any one please help me resolve the cause of this error:
> > Oracle doc provides the foll soln for this:
> >
> > Cause: An attempt was made to process a complex SQL statement that
> > consumed all available memory of the cursor.
> > Action: Simplify the complex SQL statement.
> >
> > Is re-writing the query the only option ?
> > MS
> >
> >
>
> Try to increase shared_pool_size
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 14 2000 - 23:21:05 CET