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
Printable View
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
One long term fix would be to set up profiles for your users and limit the amount of resources each can use.
Good luck.
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
Use Database Resource Manager for better controlling CPU utilization.