Re: Oracle 7 server performance

Hi Manohar,
My first guess is memory is getting scarce and the server is faulting all the time. Three instances on a system (you don't specify how much physical memory you have) usually is something of a disaster. In all three systems issue a select * from v$sga, sum the numbers you get and you will know the total sga. Oracle recommends the SGA should take maximum one third of physical memory excluding NT.

The only way to know what your performance is, is running utlbstat and ultestat in the %RDBMS%/admin directory. Please consult Oracle documentation for details.

Hth,
Sybrand Bakker, Oracle DBA

mthyagaraj_at_neural.com wrote:

> 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 Sat Jan 16 1999 - 00:05:23 CST