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 811g
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 bad.
[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
around.
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
: 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 and mod_perl this should be easy... just
open connection if you don't have it (or you get
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. Holzer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October
It's time to end this thread now - or take it to an Oracle
specific mailing list like oracle-l.
Thanks.
Tim.
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
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:
-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
same schema. But the users are all
]
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 users? How?
Paul
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
a next version
To: 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
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 the
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 are
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 don't have it (or you
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 experience.
The reason
-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 Oracle
]
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 more
-
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 that will take care
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 strongly
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 and
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
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:34 AM
Subject: Re: Slow connection to Oracle 9i
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 it
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, using
, 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 really need to.
I really do
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
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
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
,
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:23AM
] 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 at different
times
on 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 be called
. That is why,
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
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 returns a 500.
Tim???
Rich
Rich
] 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://perl.apache.org/docs/1.0/guide
, 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
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 really need to.
I really do need to call data_sources() but the time it takes to
retrieve data
:[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 called by data_sources()
so don't call
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
: [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 really need to.
I really do need to call data_sources() but the time
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
