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
One long term fix would be to set up profiles for your users and limit the amount of resources each can use.
OCP DBA 8i, 9i, 10g
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
cpu_per_call 6000/100 (hunderdts of a second)
sql> alter user scott
Before assign the profile make a change to the init.ora file and bounce back the database.
In case of any help please be free to ask me at email@example.com
Rohit Nirkhe,Oracle DBA,OCP 8i
Use Database Resource Manager for better controlling CPU utilization.
Click Here to Expand Forum to Full Width