IT 자료

DB2 메모리 사용 현황

성곤 2015. 7. 21. 14:05
반응형

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')
 


반응형