Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: can u help me with this ?

Re: can u help me with this ?

From: SKurosky <skurosky_at_aol.com>
Date: 20 Jan 2000 21:18:57 GMT
Message-ID: <20000120161857.03553.00000415@ng-bd1.aol.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
>
>
>I responded to this in the other forum also.
select pd_id,mkt_id
from ms1_lab
where pd_id between ? and ? AND

         mkt_id between ? and ?
>
>
>
>
>
>
>
Received on Thu Jan 20 2000 - 15:18:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US