-
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.
David Knight
OCP DBA 8i, 9i, 10g
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|