반응형
DB2 메모리 사용 현황
SELECT max (MAX_MEM) AS max_max,
max (CUR_MEM) AS max_cur,
max (PEAK_MEM) AS max_peak,
avg (MAX_MEM) AS avg_max,
avg (CUR_MEM) AS avg_cur,
avg (PEAK_MEM) AS avg_peak
FROM dba.MON_INST_MEM
WHERE DATE BETWEEN TO_DATE('20150714000000','YYYYMMDDHH24MISS') AND TO_DATE('20150720235959','YYYYMMDDHH24MISS')
반응형
'IT 자료' 카테고리의 다른 글
DB2 트리거 예제 (0) | 2015.07.28 |
---|---|
DB2 트랜젝션 로그 확인하기 (0) | 2015.07.23 |
[DB2] sqlstate=40001 reason code 68 (0) | 2015.06.18 |
Input not sanitized (0) | 2015.06.16 |
DB2 SQLSTATE=23505 (0) | 2015.06.09 |