Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Unanswered: Health snapshot --Alarm

    Hi all,

    When I ran the command get health snapshot for database on cap

    I get this indicator state as Alarm.
    Can someone tell me how to solve this? Thanks in advance


    Indicator Name = db.max_sort_shrmem_util
    Value = 0
    Unit = %
    Evaluation timestamp = 02/05/2008 20:00:28.113691
    Alert state = Alarm


    Then I ran the cmd get recommendations on healt snapshot...

    Problem:

    Indicator Name = db.max_sort_shrmem_util
    Value = 0
    Evaluation timestamp = 02/05/2008 20:00:28
    Alert state = Alarm
    Additional information = The high watermark for shared sort memory is "0". "99"% of the time the sort heap allocation is less than or equal to "246". The sort heap (sortheap) database configuration parameter is set to "256". The high watermark for private sort memory is "685".

    Recommendations:

    Recommendation: Decrease shared sort heap threshold.
    Rank: 1


    But when I look at the db parms

    Sort heap thres for shared sorts (4KB) (SHEAPTHRES_SHR) = (SHEAPTHRES)

    does this mean its value is 0?

    Thank you all once again...

  2. #2
    Join Date
    Apr 2010
    Posts
    1
    Did you get an answer?
    I have the same problem.
    Best regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •