Rich, Boy, been a while since I've done this - Top shows nowhere near 100%. User CPU hit about 0.2%, sqlplus was 30% while the query was actually running.
-----Original Message----- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 10:30 AM To: Beadles, John-Thomas [RICH1:2795:EXCH]; [EMAIL PROTECTED] Subject: RE: Performance problem with DBI, DBD-Oracle8 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
