cpu shows 100% used

[bhavin asokan]

hi all,

i am having L class server with 2 numbers of 440MHz processor and 2GB memory.the system is running with hpux 11i & oracle 8i is used as the database.
my problem is that almost times the cpu is showing 100% used .the free memory is varying from 20MB to 60MB at this time.
the number of process varies from 90-600 (as per top).
what may be the problem,shall i have to set any kernel parameters for this.waiting your valuable suggestions,

regds,

[Geoff Wild]

CPU - not much you can do but add more?

Memory - check value:
kmtune -q dbc_max_pct

That is a percent - you want it to be between 350 MB to 650 MB of ram - in your case 17 to 32 (default is 50).

dbc_min_pct should be 5

Rgds...Geoff

[Fred Ruffet · Accepted solution]

Bhavin,

best is to bypass IO Cache for Oracle (Oracle has its own). If your datafiles are on dedicated FS, mount those FS with these options :
nodatainlog,mincache=direct,convosync=direct
This will avoid IO cache to grow, and use CPU/memory.

Regards,

Fred