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: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 4 Feb 2006 15:13:54 +0000 (UTC)
Message-ID: <ds2gbi$f0a$1@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 - 09:13:54 CST

Original text of this message

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