So, what does V$SGASTAT say, how much space in shared pool did you consume, how much do you have left? What does STATSPACK say about the maximum shared pool consumption? On 03/11/2004 01:07:20 AM, George Leonard wrote: > Hi all, weird thing, the developers is executing pretty big queries via > java. Sometimes on some of the queries they get this error, if they take > the SQL and execute it via sqlplus immediate it works no errors. > > java.sql.SQLException: ORA-04031: unable to allocate 1553024 bytes of > shared memory ("shared pool","select (isoyear * 100) + > iso...","Typecheck heap","qry_text : qcpisqt") > > George > > ________________________________________________ > > George Leonard > Oracle Database Administrator > Dimension Data (Pty) Ltd > (Reg. No. 1987/006597/07) > Tel: (+27 11) 575 0573 > Fax: (+27 11) 576 0573 > E-mail:george.leonard@xxxxxxxxxxxxx > Web: http://www.didata.co.za > > You Have The Obligation to Inform One Honestly of the risk, And As a > Person > You Are Committed to Educate Yourself to the Total Risk In Any Activity! > Once Informed & Totally Aware of the Risk, > Every Fool Has the Right to Kill or Injure Themselves as They See Fit! > > > > > ?This e-mail is sent on the Terms and Conditions that can be accessed by > Clicking on this link http://www.vodacom.net/legal/email.asp " > -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------