Re: Oracle Performance problems

From: Martin Rapier <M.Rapier_at_shef.ac.uk>
Date: 3 Nov 1998 12:27:04 GMT
Message-ID: <71msqo$8sd$1@bignews.shef.ac.uk>

In article <363E0B79.E933CD24_at_inf.uniroma3.it>, orsano_at_inf.uniroma3.it says... {snip}

>When a performace problem occurs the server seems OK:
>I/O ok
>CPU idle 80%
>Cache hits about 99%

What about paging/swapping activity on the server? If the problem is load related I'd have a look at that, also the load on your shared servers & despatchers.

Cheers
Martin

--
Martin Rapier, Database Administrator
Corporate Information & Computing Services. University of Sheffield Tel 0114 222 1137 The opinions expressed here may be those of my employer, or they may not. http://rhino.shef.ac.uk:3001/mr-home/ Received on Tue Nov 03 1998 - 06:27:04 CST