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

Home -> Community -> Usenet -> c.d.o.misc -> Re: OCCI setString occupies memory

Re: OCCI setString occupies memory

From: KM <KM_at_nospam.nospam.com>
Date: Fri, 29 Sep 2006 10:54:24 +0530
Message-ID: <ip2Tg.49$Vc1.38@news.oracle.com>


chilabot_at_gmail.com wrote:
> How can I prevent OCCI from occupy more and more memory when calling
> Statement::setXXX? I am using Oracle 9i. I have read about disabling
> statement caching, because this caching is what's making setXXX and
> registerOutParam occupy more and more memory. But in 9i I can't disable
> statement caching. I don't want to terminate my statement and create
> one every time i want to executeUpdate an sql string. That is
> inneficient.
> Can anyone help me?
>

It is not clear when you say "occupy more and more memory". Post some sample code here and specify at what points you see memory growing and when it is being cleared.
Make sure you mention the exact OCCI version.

-KM Received on Fri Sep 29 2006 - 00:24:24 CDT

Original text of this message

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