Have you tried a TOP command, sorted by CPU usage? Try this and see if you can identify the culprit(s).

-----Original Message-----
From: Kishore A
[mailto:oracledba-ezmlmshield-x83129054.[Email address protected]
Sent: Thursday, December 30, 2004 12:14 AM
To: LazyDBA Discussion
Subject: High CPU Usuage


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.
****************************************************************************


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page