RE: Help with Shared Pool Problem

I know the reason for the Shared pool filling up is because the programs
do not use bind variables.

My question was, why do the old SQL statements not get aged out and free
up space for new statements?

Ron

-----Original Message-----
From: shaharul.anuar@xxxxxxxxxxxxxxxx
[mailto:shaharul.anuar@xxxxxxxxxxxxxxxx]=20
Sent: Thursday, October 14, 2004 8:06 AM
To: Smith, Ron L.; oracle-l-bounce@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Help with Shared Pool Problem



Hi Ron,

Have u ran SQL trace on particular session doing large data load? Looks
like that piece of SQL is not using bind variables. If no bind values,
same SQL will be treated as new piece of code and has to be hard parsed
each time.

Shaharul


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Sent: 10/14/2004 1:55 PM
Subject: Help with Shared Pool Problem

Can someone tell me why I keep running out of shared pool space?  If old
SQL statements are supposed to be aged out or written over
automatically, how can I run out of space?  This is happening from time
to time in several databases.  It appears it happens when large data
loads are running.

Ron


Important Notice!!
If you are not the intended recipient of this e-mail message, any use, =
=3D
distribution or copying of the message is prohibited. Please let me know
immediately by return e-mail if you have received =3D this message by
mistake, then delete the e-mail message. Thank you.
--
http://www.freelists.org/webpage/oracle-l

This e-mail and any attachments are confidential and may also be legally
privileged and/or copyright material of Intec Telecom Systems PLC (or
its affiliated companies). If you are not an intended or authorised
recipient of this e-mail or have received it in error, please delete it
immediately and notify the sender by e-mail. In such a case, reading,
reproducing, printing or further dissemination of this e-mail or its
contents is strictly prohibited and may be unlawful.=20

Intec Telecom Systems PLC does not represent or warrant that an
attachment hereto is free from computer viruses or other defects. The
opinions expressed in this e-mail and any attachments may be those of
the author and are not necessarily those of Intec Telecom Systems PLC.



Important Notice!!
If you are not the intended recipient of this e-mail message, any use, =
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received =
this message by mistake, then delete the e-mail message.
Thank you.
--
http://www.freelists.org/webpage/oracle-l

Other related posts: