I think the JDBC driver has connection pooling also, but not session
pooling. OCCI might have both. But I haven't checked.
OCCI is AFAIK just an OO wrapper around OCI so it should have every
functionality that OCI has.
Tanel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
Bellow, Bambi scribbled on the wall in glitter crayon:
To extrapolate, then, do you think that Neanderthals(at a cranial
capacity of over 1700 cc) would have been using Oracle 11h, or do you
think they would have prefered OODBMSs?
i think they'd are smart enough to use what works best for
I think that Neanderthals are in the damagement and would prefer the
best looking salesperson which also happens to agree with their view,
formed by reading Computerworld. As for the cranial capacity, it's the
same thing as with the silicon based CPUs: most of capacity is vasted
doing unnecessary
:
Subject:Re: connection pooling from an application server to oracle
I think that Neanderthals are in the damagement and would prefer the
best looking salesperson which also happens to agree with their view,
formed by reading Computerworld. As for the cranial capacity, it's the
same
Correction... Homo sapiens does not have the largest brain in the animal
kingdom. Elephants have larger brains and sperm whale brains weigh in at
a whopping 20 pounds. So this is not necessarily a case where size
matters, it's the spirit within that makes the difference. Of course the
size of the
Steve, you're a genuine cornucopia of almost useful information.
I stand corrected. Sperm whales have larger brain then humans,
which makes them smart enough to forgo Java. Legend has it that
they are using a whale version of perl, based on whistling.
(This is the place to insert I'm a believer
To extrapolate, then, do you think that Neanderthals(at a cranial capacity
of over 1700 cc) would have been using Oracle 11h, or do you think they
would have prefered OODBMSs?
-Original Message-
Sent: Tuesday, December 16, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L
On
This is very normal in Application Server case. We use Tuxedo and in our
case when server starts, it creates more than 30 connections to each Oracle
database regardless of whether you any applications actually uses it or not.
Client communicates with server through soap, each operation is
Ryan,
This is becoming for normal. There are a lot of software pieces that do
connection pooling - basically, everybody is plaing in everbody else's
space.
I have a couple of projects where the app-server does the connection
pooling. One using Dcom and the other IBM WebSphere.
From your point
doesnt this force you to commit after every single DML statement?
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/12/15 Mon AM 08:36:09 EST
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
CC: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: connection pooling from an application server
you to commit after every single DML statement?
From: Mercadante, Thomas F [EMAIL PROTECTED]
Date: 2003/12/15 Mon AM 08:36:09 EST
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
CC: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: connection pooling from an application server to
oracle
]
Date: 2003/12/15 Mon AM 09:04:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE: connection pooling from an application server to oracle
nope. the application server watches the connections and
transactions
the main problem is it's very hard to do a 10046
of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE: connection pooling from an application server to
oracle
nope. the application server watches the connections and
transactions
the main problem is it's very hard to do a 10046 trace on a session
with connection pooling going
ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE: connection pooling from an application server to oracle
nope. the application server watches the connections and
transactions
the main problem is it's very hard to do a 10046 trace on a session
with connection pooling going on, as a user
At 05:59 AM 12/15/2003, [EMAIL PROTECTED] wrote:
The software engineers here are using an application server with
connection pooling to connect to our oracle instances.
They are doing it with a dedicated connection to Oracle. No MTS.
This concerns me. how do you handle transaction control in
To: '[EMAIL PROTECTED]'
[EMAIL PROTECTED]
CC: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: connection pooling from an
application server to oracle
Ryan,
This is becoming for normal. There are a lot of
software pieces that do
connection pooling - basically, everybody is
plaing
Such app server side connection pooling is a nightmare for a DBA.
Http pages ([aj]sp junk,php,mod_plsql,mod_perl using Apache::DBI) will
each open one connection per page, as well as most CGI scripts (Adam von Nieda's
exquisite oracle tool on http://www.oracletool.com is what comes to mind).
If
Ryan
It depends on the application. For most applications the app. server
connection pooling works satisfactorily (with grumbling from the DBA). For
other applications that isn't good enough. An example might be a
high-security financial application where you must trace each connection and
But Mladen, sooner or later, somebody is going to wise-up and catch you in
your attempt at passing the blame. When this happens to me, I quote to
80-20 rule. 80% gain in application thruput is brought thru Sql tuning (or
rewrite). If they say The database is slow, I say Show me the sql that
is
Well said, Thomas! The longer I'm a DBA the more I find that having the
right reply (like your example) is than necessarily being able to provide a
thorough technical explanation they won't understand anyway. Obviously I
still want to have the technical understanding. Thanks for sharing.
Dennis
On 12/15/2003 10:54:27 AM, Mercadante, Thomas F wrote:
But Mladen, sooner or later, somebody is going to wise-up and catch you in
your attempt at passing the blame. When this happens to me, I quote to
80-20 rule. 80% gain in application thruput is brought thru Sql tuning (or
rewrite). If
Mladen,
Tread lightly on the "solar flares" my friend.
Last time we had some severe flares, 2 of my client sites lost their air conditioning units, which resulted in media failures. Hadn't had any air conditioning outages in at least 3 years at sites. Just a strange (circumstantial) coincidence,
Duly noted. I guess that Saddam Hussein related excuses will no longer
work, either. I'll have to thoroughly comb my book of excuses.
On 12/15/2003 01:54:35 PM, Paul Drake wrote:
Mladen,
Tread lightly on the solar flares my friend.
Last time we had some severe flares, 2 of my client sites
Mladen,
Probably, something is very wrong with application design.
With iPlanet, it looks like this:
Application invokes bean, pumpkin or servlet which has something to do
with oracle. The app server pooling mechanism will allocate one of the
already established dedicated server connections,
I can imagin single call to allocate more than one connection if more than
one transaction contexts required for this call (although, smartest app
servers and the best databases can optimize even this transaction can be
suspended and then resumed after another transaction commits), but it
From 9i on, application servers can actually make use of the connection
pooling and session pooling features within OCI instead of implementing
their own.
An interesting concept is how the 9i OCI API separates the notion of
session pooling from connection pooling. You can have multiple
I didn't reply to Vadim because I'm not a developer and I have no idea how appservers
work.
You say that as of 9i application servers can use OCCI multiplexing. Isn't that
dependendent
on a particular app server? I was talking about iPlanet 6.5 because that is the last
version that
I have some
I agree that the implementation of a connection pool is dependent on the
app server, which for various reasons, might choose not to use the
connection pool inherent in the programming interface, whether it's OCI
or JDBC. One reason may be that the app server already has its own
connection
28 matches
Mail list logo