prasad go to ML and search for : Shared pool fragmentation and dbms_shared_pool package
Deepak --- Prasad BAV <[EMAIL PROTECTED]> wrote: > Hi List, > > We are using Oracle 8.1.7 on Windows 2000. System > RAM > is 3GB. We are using 1.5GB of SGA. System is 1GHz > processor. > > We are getting sometimes problem with the error > ORA-04030. Our DBA says this is the problem because > of > bug with Oracle 8.1.7 in Windows 2000 with CLOB > datatype. We have developed our application with lot > of CLOB usage. > > Is that true? Do we have an alternative to avoid > that > error? Or do we have to change the data type? Please > suggest us. > > Thanks in advance, > > Regards, > > Prasad BAV. > > __________________________________________________ > Do You Yahoo!? > Find a job, post your resume. > http://careers.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Prasad BAV > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __________________________________________________ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
