SQL*Plus hogging processor utilization!!

From: Dave Morse <dmorse_at_nospam.cinergy.com>
Date: Fri, 17 Jul 1998 10:05:49 -0500
Message-ID: <6onp97$1t6$1@news.iquest.net>

Is there anyway to release SQL*Plus's control of the processor when executing a large query? I'm running SQL*Plus 3.2.2.0.2 (with Oracle 7.3.3) on Windows NT 4.0 (sp3), and whenever I execute a large query (that may take 20 minutes), my processor utilization skyrockets and stays at 100% until the query finishes (hence affecting the performance of my machine).

Any configuration ideas (through "Options, Environment")?

Thanks in advance!

(To reply, please take the 'nospam' out of the cinergy address - dmorse_at_cinergy.com)

Dave Morse
Consultant - InfoTech Consulting, Inc.
dmorse_at_cinergy.com
dmorse_at_iquest.net Received on Fri Jul 17 1998 - 10:05:49 CDT