Joe, This may very well be getting off topic for this list. I just needed to check with y'all to see if there was anything in the DBI I was missing that would impact. "No" is an appropriate answer. Should I drop the list off replies?
Anyway, here are the answers to your questions - The PC (query finishes in 20 secs) - is a single processor Dell laptop, 800MHz CPU, 256 mb RAM - sqlplus doesn't like -v, -? shows: SQL*Plus: Release 8.1.6.0.0 - Production on Thu Oct 3 10:27:34 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. The UNIX server (query finishes in 20 min) - is an HP L class server, dual 440MHz CPUs, 512 mb RAM - I have access to the server stats, the CPU isn't loaded, but the HD has been getting thrashed. Overall usage is low, though. - Other stuff is running, but this machine is a development server, not production. - sqlplus doesn't like -v, but -? shows SQL*Plus: Release 8.1.6.0.0 - Production on Thu Oct 3 10:32:08 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. The remote database - is a HP V class server, 16 450MHz CPUs, 2GB RAM -----Original Message----- From: Joe Raube [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 10:09 AM To: Beadles, John-Thomas [RICH1:2795:EXCH]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Performance problem with DBI, DBD-Oracle8 Then I don't believe this is a dbi issue; most likely a difference in configuration at the Oracle client or OS level. Where does the database reside (what machine) ? What is the configuration of each machine as far as CPU, memory, etc? Does the Unix machine have anything else running on it? What is the output of 'sqlplus -v' on each machine? This is getting off-topic for this DBI list, I believe.
