DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: need help in writing script

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    I have the following output. I want to write a script to check for
    1. waits > 0 on all rowsand Ratio > .0. if true then send email.
    =========================
    ROLLBACK SEGMENT CONTENTION
    =========================

    If any ratio is > .01 then more rollback segments are needed

    NAME WAITS GETS Ratio
    ------------------------------ ---------- ---------- ---------
    SYSTEM 0 209 .00000
    RB0 0 199 .00000
    RB1 0 923 .00000
    RB2 0 199 .00000
    RB3 0 199 .00000
    RB_BIG 0 199 .00000
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Script for which platform?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    thanks sam. i already wrote it.
    "High Salaries = Happiness = Project Success."

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