Re: ORA-04031: error ..how to solve this ??

>I have got this following query which when executed in SQL Plus gives
>the following error.
>
>SQL> select pd_id,mkt_id
> 2 from ms1_tab
> 3 where pd_id in(0,1,2,3,4,5,6,7,8,9,10,11,
> 4 12,13,14,15,16,17,18,19,20,21,22,23,
> 5 24,25,26,27,28,29,30,31,32,33,34,35,
> 6 36,37,38,39,40,41,42,43,44,45,46,47,
> 7 48,49,50,51,52,53,54,55,56,57,58,60,
> 8 61,62,63,64,65,66,67,68,69,70,71,72,
> 9 73,74,75,76,77,78,79,80,81,82,83,84,
> 10 85,86,87,88,89,90,91,92,93,94,95,96,
> 11 97,98,99,100,101,102,103,104,105,106,107,108,
> 12 109,110,111,112,113,114,115,116,117,118,119,120,
> 13 121,122,123,124,125,126,127,128,129,130,131,132,
> 14 133,134,135,136,137,138,139,140,141,142,143,144,
> 15 145,146,147,148,149,150,151,152,153,154,155,156,
> 16 157,158,159,160,161,162,163,164,165,166,167,168,
> 17 169,170,171,172,173,174,175,176,177,178,179,180,
> 18 181,182,183,184,185,186,187,188,189,190,191,192,
> 19 193,194,195,196,197,198,199,2,201,202,203,204,
> 20 205,206,207,208,209,210,211,212,213,214,215,216,
> 21 217,218,219,220,221,222,223,224,225)
> 22 and mkt_id in
> 23 (0,1,2,3,4,5,6,7,8,9,10,11,
> 24 12,13,14,15,16,17,18,19,20,21,22,23,
> 25 24,25,26,28,29,31,32,33,34,35,36,37,
> 26 38,39,40,41,42,43,44,45,46,47,48,49,
> 27 50,51,52,53,54,55,56,57,58,59,60,61,
> 28 62,63,64,65,66)
> 29 ;
>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 us 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")
>
>
>We also increased the shared pool area to by setting the
>SHARED_POOL_SIZE to 200mb
>but still we are getting the same error
>
>Kindly help
>
>Thanks & Regards
>~Parvinder

Try this for formats sake:
select pd_id,mkt_id
from ms1_tab
where pd_id between 0 and 225 and

         mkt_id between 0 and 66; Received on Thu Jan 20 2000 - 13:10:23 CST