interesting problem with runaway processes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: interesting problem with runaway processes

  1. #1
    Join Date
    Nov 2002
    Location
    Columbia, sc
    Posts
    9

    interesting problem with runaway processes

    I have an interesting problem I would like some help in explaining....

    Environment--
    Oracle 8.0.5 EE
    MP-RAS

    Problem--

    The situation is like this; I had 4 MTS processes that were utilizing 100% of the cpu time on the machine for about 6 hours this afternoon. These four processes were the same user ( application login ) running the same sql statement. Each process had a high number of waits, db file sequential read values and no actual i/o activity ( as seen by sar -d ).

    I would greatly appreciate any insight anyone can give me to help me understand what might have caused this to occur. I should be able to post any additional information that you think is needed.

  2. #2
    Join Date
    Nov 2002
    Location
    India
    Posts
    4
    Hi there,

    High db_sequential reads might not always lead to poorly TUNED/written SQL, but it might be worth it to make sure that the SQL in picture is using proper indexes and Stuff.

    Meanwhile making sure that it is not waiting on anything else(doubly sure) would be a good idea. Can you post the o/o of select * from v$session_wait ??

    Since its MTS, make sure SGA is sized properly ('cos SORT area is allocated from SGA for MTS...)

    -Cheers
    -Thanks
    Ram

  3. #3
    Join Date
    Nov 2002
    Location
    Columbia, sc
    Posts
    9
    I have attached the contents of v$session_wait - it is quite large.

    select * from v$session_wait order by sid;

    Any help is greatly appreciated.

    Thanks,

    John
    Attached Files Attached Files

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