Database load

[mooks]

Currently the Oracle database version 8.1.5 sits on a HP-UX server.

The number of session set for the database is 5000. However when they are about 120 sessions running, the database connection gets critical and becomes very slow. Any idea please?

[pando]

high cpu usage is not that bad it´s bad when you have waits

[efrijters]

I read in the documentation that you must start worrying when your cpu's are constantly over 90% usage.

Try to create a STATSPACK-report or a report from "Oracle Expert" if you have this module.

You'll get a good view on your waits and bottlenecks.

HTH

[mooks]

Hi

How to determine is the CPU usage is more than 90%?

I do not have Oracle Expert, so any ways to check on the waits to determine the bottleneck please?

[mooks]

Hi

The io waits in the server do not seems to be very high, it is still consider critical or normal?

HP-UX app1 B.11.00 U 9000/800 02/26/04

%usr %sys %wio %idle
56 21 17 6
59 22 16 3
69 29 1 1
73 26 1 1
69 26 4 1

Average
65 25 8 2