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 (See ORA-04031.ora-code.com): 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@(protected)
> 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@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
