SELECT
HOST,
PORT,
CASE WHEN (((SUM(FREE_SIZE) / SUM(ALLOCATED_SIZE)) > 0.30)
AND SUM(ALLOCATED_SIZE) > TO_DECIMAL(10)*1024*1024*1024)
THEN 'TRUE'
ELSE 'FALSE'
END "Row store Reorganization Recommended",
TO_DECIMAL( SUM(FREE_SIZE)*100 / SUM(ALLOCATED_SIZE),
10,
2) "Free Space Ratio in %",
TO_DECIMAL( SUM(ALLOCATED_SIZE)/1048576,
10,
2) "Allocated Size in MB",
TO_DECIMAL( SUM(FREE_SIZE)/1048576,
10,
2) "Free Size in MB"
FROM M_RS_MEMORY
WHERE ( CATEGORY = 'TABLE'
OR CATEGORY = 'CATALOG' )
AND PORT LIKE '%03'
GROUP BY HOST,
PORT
;
'IT > SAP' 카테고리의 다른 글
SAP Solution Manager SSO (0) | 2015.12.30 |
---|---|
1911102 - Solution Manager application logs reorganization (0) | 2015.12.30 |
Install and Configuration SAProuter via SNC (0) | 2015.07.29 |
Using hdbalm (0) | 2015.02.10 |
Uninstall SAP HANA Plugins (0) | 2015.01.27 |