CONSUMING 95% CPU
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: CONSUMING 95% CPU

  1. #1
    Join Date
    Mar 2001
    Posts
    5
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    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

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    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
  •  



Click Here to Expand Forum to Full Width