Re: can u help me with this ?

From: Daniel <delj_at_flash.net>
Date: Thu, 20 Jan 2000 20:28:07 GMT
Message-ID: <rdKh4.6598$V84.375096@news.flash.net>

Did you stop and restart your Oracle instance after changing the parameter? If so, is there a possibility that your system is out of memory?

Daniel
Austin, TX

"Parvinder Singh" <parora_at_questone.com> wrote in message news:388756C0.AE6FAF66_at_questone.com...
> Hi all
>
> I got the following error on execution of a pretty long query
>
> from ms1_tab
> *
> ERROR at line 2:
> ORA-01037: maximum cursor memory exceeded
>
> Infact the query size was larger than this ...when we executed a
> larger query than this (around 9000 bytes) it gave me this error
>
> ORA-04031: unable to allocate 24 bytes of shared memory ("shared
> pool","select pd_id,mkt_id from ms1...","sql area","logdef : apaclg")
>
>
> I also tried increasing the shared pool area by setting the
> SHARED_POOL_SIZE to 200mb
> but still i am getting the same error
>
> do i need to look at some other parameters too ??plz help
>
> Thanks & Regards
> ~Parvinder
>
>
>
>
Received on Thu Jan 20 2000 - 14:28:07 CST