OraFAQ Forum: Networking and Gateways » CPU Utilization is high.

Home » RDBMS Server » Networking and Gateways » CPU Utilization is high.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CPU Utilization is high. [message #66718]

Mon, 18 November 2002 08:31

Munish
Messages: 21
Registered: November 2001

Junior Member

Hi,
My Oracle Server is running on NT machine. And my applications various pluggin servers are connected with that. But every time the CPU Utilization is nearly 100%. And only Oracle.exe is taking 90% CPU time.Would anybody please help me on that.My SGA Size And memeory structures are perfect.And the CPU Utilization was also normal just 2-3 days back.Worked with all the options. Like rebuilding indexes, checking tablespace space.Cannot able to trace the problem.
Please help me out.

Thanks a lot.
Regards,
Munish

Report message to a moderator

Re: CPU Utilization is high. [message #66719 is a reply to message #66718]

Mon, 18 November 2002 11:28

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

There are many factors for the cause of 100% CPU utilizition.
The most encountered one is due to SMON.
did you check which oracle thread, is creating the probleM?
SMON does the cleanup every 5 minutes or so.
so if there is something happening in DB that makes
SMON unhappy, SMON will take its own time to  the COALESCE THE FREE EXTENTS.
so look, how the TEMP tablespaces are utilized etc.

Report message to a moderator

Previous Topic:	Moving System Parameter File Elsewhere
Next Topic:	edit tnsnames.ora by script

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 15:55:18 CDT 2025