Oracle 7 server performance

From: <mthyagaraj_at_neural.com>
Date: Fri, 15 Jan 1999 21:42:12 GMT
Message-ID: <77ocni$hi$1@nnrp1.dejanews.com>

I encounter server %processor time maxing out during long retrievals, like an end-of year report in the range of 14,000 records and more. Ideas on probable causes and solutions, anyone? Our server is NT based, 366 Mhz with 12Gb disk space partitioned into three drives. We are running four instances. Is this the result of inadequate SGA?

Thank you ,
Manohar Thyagaraj,
Project Engineer,
Neural Applications Corporation

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 15 1999 - 15:42:12 CST