Re: ORA-01037
From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 14 Nov 2000 02:21:18 GMT
Message-ID: <8uq7iq$d5$1_at_nnrp1.deja.com>
Date: Tue, 14 Nov 2000 02:21:18 GMT
Message-ID: <8uq7iq$d5$1_at_nnrp1.deja.com>
[Quoted] 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 - 03:21:18 CET