CONSUMING 95% CPU

[rkodag]

Hi DBA'S

Pls help me server consuming and showing CPU 95%, pls help me for that , how to fix this the version ooracle 8.1.6 os =NT
pls send reply as possible as soon

wating for your reply

rakesh
DBA

[dknight]

One long term fix would be to set up profiles for your users and limit the amount of resources each can use.

Good luck.

[rohitsn]

Hi,
U can create profiles and assign to the users.In a profile u can limit how much CPU to be utilised by a call,a session,sessions per user etc.
U create a profile with the follwing command
sql> create profile developer
limit
sessions_per_user 3
cpu_per_call 6000/100 (hunderdts of a second)
cpu_per_Session 6000/100
idle_time 30
connect_time 60;

sql> alter user scott
profile developer;

Before assign the profile make a change to the init.ora file and bounce back the database.
RESOURCE_LIMIT=true

In case of any help please be free to ask me at rohitsn@altavista.com

Regards.
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[tamilselvan]

Use Database Resource Manager for better controlling CPU utilization.