ADM10500E  Health indicator "Percentage of Sorts That Overflowed"
("db.spilled_sorts") breached the "upper" alarm threshold of "50 %" with value
"55 %" on "database" "carsdb.EVENTXML".  Calculation:
"((delta(db.sort_overflows,10))/(delta(db.total_sorts,10)+1)*100);" = "(((1085
- 1057) / ((62616 - 62566) + 1)) * 100)" = "55 %".  History (Timestamp, Value,
Formula): " (04/26/2008 09:00:11.810420, 0, (((1057 - 1057) / ((62588 - 62566)
+ 1)) * 100)), (04/26/2008 08:54:11.564008, 0, (((1057 - 1057) / ((62574 -
62566) + 1)) * 100)), (04/26/2008 08:48:11.358225, 0, (((1057 - 1057) / ((62574
- 62566) + 1)) * 100)), (04/26/2008 08:42:11.139735, 0, (((1057 - 1057) /
((62574 - 62566) + 1)) * 100)), (04/26/2008 08:36:11.948701, 0, (((1057 - 1057)
/ ((62574 - 62566) + 1)) * 100)), (04/26/2008 08:30:11.816159, 0, (((1057 -
1057) / ((62574 - 62566) + 1)) * 100)), (04/26/2008 08:24:11.536771, 0, (((1057
- 1057) / ((62573 - 62566) + 1)) * 100)), (04/26/2008 08:18:11.322738, 0,
(((1057 - 1057) / ((62573 - 62566) + 1)) * 100)), (04/26/2008 08:12:11.743056,
0, (((1057 - 1057) / ((62573 - 62566) + 1)) * 100))"

???????????????????????

Hello Pawan

From the CLP, you can obtain the Health indicator description and recommended actions by executing the following commands:

• GET RECOMMENDATIONS FOR HEALTH INDICATOR Health-Indicator-Short-Name
• GET DESCRIPTION FOR HEALTH INDICATOR Health-Indicator-Short-Name

Sorts that
overflow to disk can cause significant performance degradation. If this occurs,
an alert may be generated.

The indicator is calculated using
the formula:

(db.sort_overflowst - db.sort_overflowst-1) /
(db.total_sortst - db.total_sortst-1) * 100

Consider using the self-tuning memory feature to have
sort memory resources automatically allocated as required by the current workload.
If you have the self tuning memory feature enabled for the sort memory area,
you should configure this health indicator to disable threshold checking.