为什么 temp表空间显示的都是0? 可以从哪里可以查到呢?
select
substr(TBSP_NAME,1,16) TPNAME,
SUBSTR(TBSP_STATE,1,10) TB_STATE,
TBSP_PAGE_SIZE,
TBSP_TOTAL_SIZE_KB/1024||' M' as "总空间大小",
TBSP_USABLE_SIZE_KB/1024||' M' as "空闲空间大小",
TBSP_UTILIZATION_PERCENT,
DATA_PHYSICAL_READS,DATA_HIT_RATIO_PERCENT,INDEX_PHYSICAL_READS,INDEX_HIT_RATIO_PERCENT,
XDA_PHYSICAL_READS, XDA_HIT_RATIO_PERCENT
from sysibmadm.MON_TBSP_UTILIZATION;
------------------------------------------------------------------------------
select substr(TBSP_NAME,1,16) TPNAME, SUBSTR(TBSP_STATE,1,10) TB_STATE, TBSP_PAGE_SIZE, TBSP_TOTAL_SIZE_KB/1024||' M' as "总空间大小", TBSP_USABLE_SIZE_KB/1024||' M' as "空闲空间大小", TBSP_UTILIZATION_PERCENT, DATA_PHYSICAL_READS,DATA_HIT_RATIO_PERCENT,INDEX_PHYSICAL_READS,INDEX_HIT_RATIO_PERCENT, XDA_PHYSICAL_READS, XDA_HIT_RATIO_PERCENT from sysibmadm.MON_TBSP_UTILIZATION
TPNAME TB_STATE TBSP_PAGE_SIZE 总空间大小 空闲空间大小 TBSP_UTILIZATION_PERCENT DATA_PHYSICAL_READS DATA_HIT_RATIO_PERCENT INDEX_PHYSICAL_READS INDEX_HIT_RATIO_PERCENT XDA_PHYSICAL_READS XDA_HIT_RATIO_PERCENT
---------------- ---------- -------------------- ---------------------- ---------------------- ------------------------ -------------------- ---------------------- -------------------- ----------------------- -------------------- ---------------------
SYSCATSPACE NORMAL 8192 128 M 127 M 85.05 1738 97.78 2245 96.85 2 33.33
TEMPSPACE1 NORMAL 8192 0 M 0 M 100.00 6388 71.71 0 - 0 -
USERSPACE1 NORMAL 8192 32 M 31 M 2.36 34 5.55 0 - 0 -
AFCLC_TABLE NORMAL 8192 2976 M 2975 M 77.02 19267 99.61 2460 99.97 0 -
AFCLC_SMALL_TABL NORMAL 8192 32 M 31 M 3.93 35 84.64 0 100.00 0 -
SYSTOOLSPACE NORMAL 8192 32 M 31 M 5.27 52 99.92 29 99.83 0 -
SYSTOOLSTMPSPACE NORMAL 8192 0 M 0 M 100.00 0 100.00 0 - 0 -
为什么 temp表空间显示的都是0? 可以从哪里可以查到呢?