On Mon, 2004-10-18 at 10:16, BAXTER, LINCOLN A wrote:
> Most people with experience with Oracle know that opening oracle connections
> is SLOW!
>
Really? I've never noticed. Unless I'm connecting to a
database over a slow WAN.
Here's a connection time to a database on a laptop through
an 811
On 2004-10-21 12:01:11 -0600, Reidy, Ron wrote:
> The statement was "Call commit (even if you have done only selects)
> ...". This was what I was referring to.
Ah, ok. I missed that remark in parentheses - sorry.
hp
--
_ | Peter J. Holzer | Shooting the users in the foot is ba
Thank you to all.
Your responsiveness was amazing and the responses very helpful.
If anyone has any other comments or ideas, please email them to me directly.
If I come across any new developments or solutions, I will forward
them to Tim, unless he prefers otherwise.
I may post to the Oracle-L ma
It's time to end this thread now - or take it to an Oracle
specific mailing list like oracle-l.
Thanks.
Tim.
To: [EMAIL PROTECTED]
Subject: Re: Slow connection to Oracle 9i
On 2004-10-21 08:51:04 -0600, Reidy, Ron wrote:
> My comments are below ...
>
> -
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>
>
> -Original Message-
> From: Peter J.
04 9:10 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Slow connection to Oracle 9i
>
>
> [Rearranged quotes for better readability]
>
> On 2004-10-19 08:23:53 -0600, Reidy, Ron wrote:
> > BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED]:
> >> Ok, then if you use Apache
My comments are below ...
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Peter J. Holzer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 9:10 AM
To: [EMAIL PROTECTED]
Subject: Re: Slow connection to Oracle 9i
[Rearranged quotes for
[Rearranged quotes for better readability]
On 2004-10-19 08:23:53 -0600, Reidy, Ron wrote:
> BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED]:
>> Ok, then if you use Apache and mod_perl this should be easy... just open
>> connection if you don't have it (or you get and error on it), and keep it
>> arou
Commit is not to improve the performance of a single thread. It is to
complete a transaction (i.e. set of SQL either is comitted or rolled
back, no partial). Doing so also minimizes contention with other
threads.
Bong Tumanut
DBA
--- "Reidy, Ron" <[EMAIL PROTECTED]> wrote:
> Hmm...
>
> I strong
riginal Message-
From: Henri Asseily [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 5:12 PM
To: '[EMAIL PROTECTED]'; Jesse, Rich
Subject: Re: Slow connection to Oracle 9i
I have a DBIx::HA (High Availability) module on CPAN, but I'm readying
a next version real soon now t
]
Sent: Tuesday, October 19, 2004 10:39 AM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
Hmm...
I strongly disagree. To quote from Steve Adam's website
(http://www.ixora.com.au/newsletter/2001_09.htm)...
Over committed
Many applications commit
-Original Message-
From: BAXTER, LINCOLN A
Sent: Tuesday, October 19, 2004 10:27 AM
To: 'Reidy, Ron'
Subject: RE: Slow connection to Oracle 9i
Actually it is CHEAP compared to a rollback, you have to reset your
transaction state.
Commit is the cheapest thing you can do in O
9, 2004 8:27 AM
To: Reidy, Ron
Subject: RE: Slow connection to Oracle 9i
Actually it is CHEAP compared to a rollback, you have to reset your
transaction state.
Commit is the cheapest thing you can do in Oracle.
The MOST expensive thing to do is Rollback. Believe me we know, from
empirical experie
Message-
From: BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 3:05 PM
To: 'Paul Appleby'
Cc: '[EMAIL PROTECTED]'
Subject: RE: Slow connection to Oracle 9i
Ok, then if you use Apache and mod_perl this should be easy... just open
connection if you d
On 2004-10-18 11:48:11 -0600, Reidy, Ron wrote:
> Maybe Oracle does not think it is a problem, but I (and lots of
> others) would disagree. These issues are correctable.
>
> In the case of slow logins, it depends on what is being done when the
> connection is made. When making connections that a
On 2004-10-18 19:57:07 -0400, Paul Appleby wrote:
> My CGI application will be called by different visitors to the web
> site at different times, but they all connect to the same database
> using the same connection variables, i.e. the same user/password.
> Are you saying the first visitor to t
: Paul Appleby; BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
H...one thing I thought of is to check the validity of the handle, in
case the Oracle instance bounces (i.e. The Oracle instance is available,
but the persistent connection no longer exists). Does
OH... Col!
-Original Message-
From: Henri Asseily [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 5:12 PM
To: '[EMAIL PROTECTED]'; Jesse, Rich
Subject: Re: Slow connection to Oracle 9i
I have a DBIx::HA (High Availability) module on CPAN, but I'm readying
PROTECTED]
Sent: Monday, October 18, 2004 4:39 PM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
My CGI application will be called by different users at different
times. Are you saying the first user's connection can be left open
for all the other us
s not a recreational drug.
Lincoln
-Original Message-
From: Paul Appleby [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 4:54 PM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
No. Each user will be using the same application that logs in to the
Paul Appleby wrote:
Try measuring the time it takes to connect with SqlPlus by using
You mean DBI? (I already sent the result for sqlplus.)
"Time::HiRes" with the variables $time1 and $time2 both set to
gettimeofday() and the the length of time set to $time2-$time1, as follows:
$time1=gettimeofd
Lincoln
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 12:06 PM
To: Paul Appleby
Cc: [EMAIL PROTECTED]
Subject: Re: Slow connection to Oracle 9i
On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote:
DBD::Oracle::dr::load_dbnames is only cal
n the client side. That is why,
> >> >for instance, Websphere caches pooled connections in the java world.
> >> >
> >> >Lincoln
> >> >
> >> >
> >> >-Original Message-
> >> >From: Tim Bunce [mailt
world.
>
>Lincoln
>
>
>-Original Message-
>From: Tim Bunce [mailto:[EMAIL PROTECTED]
>Sent: Monday, October 18, 2004 12:06 PM
>To: Paul Appleby
>Cc: [EMAIL PROTECTED]
>Subject: Re: Slow connection to Oracle 9i
>
>
>On Mon, Oct 18, 2
, October 18, 2004 12:06 PM
>To: Paul Appleby
>Cc: [EMAIL PROTECTED]
>Subject: Re: Slow connection to Oracle 9i
>
>
>On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote:
>>
>> >DBD::Oracle::dr::load_dbnames is only called by data_sources()
>> >s
s transactions.
> >This is true regardless of the language on the client side. That is why,
> >for instance, Websphere caches pooled connections in the java world.
> >
> >Lincoln
> >
> >
> >-Original Message-
> >From: Tim Bunce [mailto:[EMAIL P
istrator
[EMAIL PROTECTED] QuadTech, Sussex, WI USA
-Original Message-
From: Jesse, Rich [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 3:51 PM
To: Paul Appleby; BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
Perhaps this'll help:
http://
Appleby; BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
Perhaps this'll help:
http://perl.apache.org/docs/1.0/guide/performance.html#Persistent_DB_Connections
There's a link on that site to "Tim Bunce's Advanced DBI talk", but it retu
connection to Oracle 9i
My CGI application will be called by different users at different
times. Are you saying the first user's connection can be left open
for all the other users? How?
Paul
>Most people with experience with Oracle know that opening oracle connections
>is SLOW!
>
&g
n the database can make a BIG difference ... talk to
your dba's)
Lincoln
-Original Message-
From: Paul Appleby [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 4:39 PM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
My CGI application will
istrator
[EMAIL PROTECTED] QuadTech, Sussex, WI USA
-Original Message-
From: Paul Appleby [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 3:39 PM
To: BAXTER, LINCOLN A
Cc: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
My CGI application will be called by different users
,
for instance, Websphere caches pooled connections in the java world.
Lincoln
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 12:06 PM
To: Paul Appleby
Cc: [EMAIL PROTECTED]
Subject: Re: Slow connection to Oracle 9i
On Mon, Oct 18, 2004 at 10:38
tisfied, open a TAR with Oracle support.
>
> -
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.
>
>
> -Original Message-
> From: BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED]
> Sent: Monday, October 18, 2004 11:17 AM
> To: [EMAIL PROTECTED]
a TAR with Oracle support.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: BAXTER, LINCOLN A [mailto:[EMAIL PROTECTED]
Sent: Monday, October 18, 2004 11:17 AM
To: [EMAIL PROTECTED]
Subject: RE: Slow connection to Oracle 9i
Most people with experience
Steffan,
Try measuring the time it takes to connect with SqlPlus by using
"Time::HiRes" with the variables $time1 and $time2 both set to
gettimeofday() and the the length of time set to $time2-$time1, as
follows:
$time1=gettimeofday();
your code runs here;
$time2=gettimeofday();
print $time2-$t
, 2004 12:06 PM
To: Paul Appleby
Cc: [EMAIL PROTECTED]
Subject: Re: Slow connection to Oracle 9i
On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote:
>
> >DBD::Oracle::dr::load_dbnames is only called by data_sources()
> >so don't call data_sources() unless you re
On Mon, Oct 18, 2004 at 10:38:23AM -0400, Paul Appleby wrote:
>
> >DBD::Oracle::dr::load_dbnames is only called by data_sources()
> >so don't call data_sources() unless you really need to.
>
> I really do need to call data_sources() but the time it takes to
> retrieve data, as shown above, usin
Tim,
It is 3 to 4 times longer than retrieving data from a MySQL database.
Only 3 to 4 times longer than retrieving data from a MySQL?
You're lucky, it's often longer! :)
That was 3 to 4 times longer using the data from "d:DProf".
But it's 20 times longer using "Time::HiRes" to measure the time
Well, do you know what cause that delay? Between an Oracle client and
Database Server?
- Original Message -
From: "Steffen Goeldner" <[EMAIL PROTECTED]>
To: "Paul Appleby" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, October 18, 2004 11
Paul Appleby wrote:
> I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to
> connect to a local Oracle 9i database
[...]
> Why is the connection time so long and how can I shorten it?
[...]
> It takes 2.9342188835144 seconds to connect to the database.
How long does it take with
On Sun, Oct 17, 2004 at 09:06:56PM -0400, Paul Appleby wrote:
> I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to connect to a
> local Oracle 9i database table and retrieve the data in the three small fields of
> its only two records.
>
> Why is the connection time so long an
I have a simple Perl 5.6 test script that uses DBI and DBD::Oracle to connect to a
local Oracle 9i database table and retrieve the data in the three small fields of its
only two records.
Why is the connection time so long and how can I shorten it? It is 3 to 4 times longer
than retrieving data
42 matches
Mail list logo