- 论坛徽章:
- 0
|
近日发现数据库的健康中心 ,出现了下面的警告 long term shared sort memory utilization 具体的描述是:
DESCRIPTION:
Sorting is considered healthy if there is sufficient heap space in which
to perform sorting and sorts do not overflow unnecessarily. This indicator
tracks an over-configured shared sort heap, looking to see if there are
resources that can be freed for use somewhere else in DB2. An alert may
be generated when the percentage usage is low. The indicator is calculated
using the formula: (db.max_shr_sort_mem / SHEAPTHRES_SHR)*100.
不知道那个参数需要 需要调整, 望兄弟们指点一二,-- |
|