Heavy load on the server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Heavy load on the server

  1. #1
    Join Date
    Apr 2002
    Posts
    291

    Heavy load on the server

    Hi All,
    We are running with Oracle 9.0.1.4 on RH linux 7.2. From yesterday onwards, Load on the server is just increasing heavily and at a point it reached to 19.95% and 100% of CPU Utilization. When i tried to track the processes running on the server, i could not find any of the SQL statement in TOAD or OEM using that SPID tracked in the TOP Session. Can any one help me please , how to find the machine name/IP address and its SQL text for that session, username, schemaname etc given an SPID. We had to restart the machine for twice. please help me ...

    Thanks in advance
    PNRDBA
    Share on Google+

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478
    If you have OEM, go to database>instance>sessions
    If not, then look here:

    http://www.think-forward.com/d_monitorscripts.htm
    Share on Google+

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

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