Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Help with Shared Pool Problem

Re: Help with Shared Pool Problem

From: Ganesh Raja <ganesh.raja_at_gmail.com>
Date: Thu, 14 Oct 2004 14:02:30 +0100
Message-ID: <f754edf04101406023d5a80f7@mail.gmail.com>


Seems to me that u are not using Bind variables ...

~
Ganesh

On Thu, 14 Oct 2004 07:55:25 -0500, Smith, Ron L. <rlsmith_at_kmg.com> wrote:
> 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, =
> 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
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 14 2004 - 08:06:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US