Guys,
Our database usuage is average 89%, my database is running 9.2.0.5
with 1 GB RAM and SGA is 471 MB,
There are around 130 connections. Is my SGA setting correct(Solaris 8 64 bit
m/c). Any ideas to reduce the CPU.

# sar -u 5 5

SunOS mnhmdb 5.8 Generic_117000-01 sun4u 12/30/04

00:14:32 %usr %sys %wio %idle
00:14:37 88 12 0 0
00:14:42 90 10 0 0
00:14:47 91 8 0 0
00:14:52 92 7 0 1
00:14:57 84 10 0 6

Average 89 10 0 1

SQL> show sga

Total System Global Area 471304888 bytes
Fixed Size 731832 bytes
Variable Size 436207616 bytes
Database Buffers 33554432 bytes
Redo Buffers 811008 bytes


Regards,
Kishore
****************************************************************************
This communication contains information, which is confidential and may also
be privileged. It is for the exclusive use of the intended recipient(s). If
you are not the intended recipient(s), please note that any distribution,
printing, copying or use of this communication or the information in it is
strictly prohibited. If you have received this communication in error,
please notify the sender immediately and then destroy any copies of it.
****************************************************************************

Oracle LazyDBA home page