If you're still running HPUX 10.x, I'm guessing that it's also an older machine? It's probably not a memory issue, since SQL*Plus won't store the 38K rows in memory. There's some memory use, but it's more for buffering.
On your HP box, fire up "top" in another window while re-running that query. Is SQL*Plus at the top and/or your CPU at 100%? Just a guess that your Winders client is just beefier than the HP... Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: John-Thomas Beadles [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 03, 2002 10:11 AM > To: [EMAIL PROTECTED] > Subject: FW: Performance problem with DBI, DBD-Oracle8 > > > Forgot to copy my response to the list... > > -----Original Message----- > From: Beadles, John-Thomas [RICH1:2795:EXCH] > > The PC is running Win2k, perl 5.6.1, dbi 1.28, dbd-oracle 1.80 > > The UNIX machine is running HPUX10, with Perl v5.6.0, dbi > 1.14, dbd-oracle - > can't tell, don't have access to the module > > > > -----Original Message----- > From: Joe Raube [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 03, 2002 8:41 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: Performance problem with DBI, DBD-Oracle8 > > > Are the versions of perl, dbi, dbd, and the Oracle client the > same on both > machines? > > What OS is running on each machine? > > -Joe > >
