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

Home -> Community -> Usenet -> c.d.o.server -> Re: pb with Occi

Re: pb with Occi

From: Sylvestre <Sylvestre_at_world.com>
Date: Sun, 5 Feb 2006 01:40:50 +0100
Message-ID: <43e5499f$0$27921$626a54ce@news.free.fr>


Thank you Jonathan,
yes I think connection pool is too small, I will investigate in this area.

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> a écrit dans le message de news:
ds2gbi$f0a$1_at_nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...
>
>
> "Sylvestre" <Sylvestre_at_world.com> wrote in
> message
> news:43e48f0f$0$27904$626a54ce_at_news.free.fr...
>> Hello
>>
>> My customer use an application write in C++
>> with OCCI interface for oracle
>> access, they use a connection pool of four
>> connections and before each sql request
>> they connect using createconnection() method.
>> When running a statspack report
>> on this db, I get a very low Execute to Parse %
>> ratio, a very low "SQL with execution>1"
>> it seems that the sql is not cached although
>> they use bind variable in request.
>> in the top sql, i get two request wich seem to
>> be executed at each connection, one
>> alter session...wich modify a lot of lns
>> parameter, and one "select to_char(sysdate...)
>> from dual.
>> I put a "after logoff" trigger on the db and
>> get around 1500 event by minute.
>> User complain about a slowing of the db.
>> So I don't know if the occi interface is well
>> used by this app, any comment appreciated.
>>
>> Thank you
>>
>>
>
> Creating a connection is expensive, and
> serialized;
> they are doing the wrong thing. They need to
> work
> out how to create a connection pool, and keep an
> appropriate number of connections live all the
> time.
>
> Unfortunately I don't know how you do this in
> OCCI.
>
>
> --
> Regards
>
> Jonathan Lewis
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
> Cost Based Oracle: Fundamentals
>
> http://www.jlcomp.demon.co.uk/appearances.html
> Public Appearances - schedule updated 2nd Feb
> 2006
>
>
Received on Sat Feb 04 2006 - 18:40:50 CST

Original text of this message

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