Re: Possible Oracle 9.2.0.7 performance issue with DBD::Oracle's column_info()
- From: scoles@xxxxxxxxxxx (John Scoles)
- Date: Tue, 2 May 2006 07:17:49 -0400
There are some critical patches for 9.2.0.7 . Have you installed them?
This might clean up your problem.
One other though have you rebuilt your DBD::Oracle with 9.2.0.7?
"Tobin Stelling" <tobin@xxxxxxxxxxxx> wrote in message
news:9525D0A6-3A4F-40C9-952D-CA6A58DE34D6@xxxxxxxxxxxxxxx
Hello,
My coworkers and I have a question regarding the SQL statement that
DBD::Oracle's column_info() function executes. We depend upon
column_info() to discover the data type of a large object column is
so we can bind it properly.
While this worked great for us in the past, when we upgraded to
Oracle 9.2.0.7 (from Oracle 9.2.0.1) we noticed significant
performance drops whenever this method was called. A data load test
with dbi profiler running showed that column_info()'s SQL accounts
for 78.33% of all dbi calls made during the test. If we hardcode the
bind statement's datatype, then the test runs much faster;
approximately at the same speed as unmodified code ran with Oracle
9.2.0.1.
Has anyone seen or experienced this issue before? Any thoughts or
comments would be appreciated. If there's any additional information
you need please let me know.
We are running version 1.16 of DBD-Oracle.
Thanks,
-Tobin
--
Tobin Stelling
Geospiza, Inc.
.
- References:
- Possible Oracle 9.2.0.7 performance issue with DBD::Oracle's column_info()
- From: Tobin Stelling
- Possible Oracle 9.2.0.7 performance issue with DBD::Oracle's column_info()
- Prev by Date: Re: How to bind to a LARGE array
- Next by Date: "closing dbh with active statement handles" warnings with DBD::SQLite
- Previous by thread: Possible Oracle 9.2.0.7 performance issue with DBD::Oracle's column_info()
- Next by thread: Re: Possible Oracle 9.2.0.7 performance issue with DBD::Oracle's column_info()
- Index(es):
Relevant Pages
|
