performance problem with dbd oracle

From: Tim To (tto_at_redback.com)
Date: 04/15/04 

To: <dbi-users@perl.org>
Date: Thu, 15 Apr 2004 10:52:54 -0700

Hi,
How can I improve performance when using oracle dbd? We have an urgent
performance problem where inserting data into an Oracle 9i database using
DBI/DBD oracle is at least five times slower than stright sql using sqlplus.
Any suggestion is appreciated.

DBD::oracle 1.15
DBI 1.4
PERL 5.8.0
running on solaris 9
Oracle 9.2.0.1

Thanks,
Tim To

Relevant Pages

  • Re: Question about "PL/SQL lock timer" event in Statspack
    ... I am using Statspack to investigate a performance problem in my ... In a moment that the database doesn't present ... Senior Oracle DBA ...
    (comp.databases.oracle.server)
  • Re: Slow SQL_Statement
    ... > I have a great performance problem on an Oracle 9.2.0.1 Server... ... > Only Four rows but about two days of processing time. ... from account); ...
    (comp.databases.oracle.server)
  • RE: performance problem with dbd oracle
    ... Sure the network issue exists...look at your $data_source var. ... oracle Solaris and we didn't see the performance problem with that combo. ... > executes it with one request. ...
    (perl.dbi.users)
  • RE: performance problem with dbd oracle
    ... performance problem with dbd oracle ... algorithm that Oracle uses to identify sql statement in the library cache. ... Bind variables a very inportant. ...
    (perl.dbi.users)
  • RE: performance problem with dbd oracle
    ... > Array BioPharma, Inc. ... performance problem with dbd oracle ...
    (perl.dbi.users)