2007-11-3 11:38
dianzi011sh
请帮忙分析table space 参数,谢谢
看起来一些ts已经100%使用,正常吗?
Tablespace Configuration:
Address Id Type Content PageSz ExtentSz Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name
0x52868A80 0 SMS Any 4096 32 0 1 1 On 1 0 31 SYSCATSPACE
0x5286B250 1 SMS SysTmp 4096 32 0 1 1 On 1 0 31 TEMPSPACE1
0x40D3A0D0 2 SMS Any 4096 32 0 1 1 On 1 0 31 USERSPACE1
0x40D3A720 3 DMS Any 8192 32 0 2 2 On 2 0 31 SPC_TBS
0x40D3AD70 4 DMS Any 8192 32 0 2 2 On 2 0 31 SPC_IX_TBS
0x40D3B670 5 DMS Any 8192 32 0 2 2 On 2 0 31 SPC_RIX_TBS
0x40D320D0 6 DMS Any 8192 32 0 2 2 On 6 0 31 SPC_RTBS
0x40D32F10 7 SMS SysTmp 8192 32 0 2 2 On 1 0 31 TEMPSPACE2
0x40D33560 8 SMS Any 4096 32 0 1 1 On 1 0 31 SYSTOOLSPACE
0x5286E060 9 SMS UsrTmp 4096 32 0 1 1 On 1 0 31 SYSTOOLSTMPSPACE
Tablespace Statistics:
Address Id TotPages UsablePgs UsedPgs PndFreePgs FreePgs HWM State MinRecTime NQuiescers
0x52868A80 0 15303 15303 15303 0 0 0 0x00000000 0 0
0x5286B250 1 1 1 1 0 0 0 0x00000000 0 0
0x40D3A0D0 2 230 230 230 0 0 0 0x00000000 1155030526 0
0x40D3A720 3 1310720 1310656 948000 0 362656 948000 0x00000000 1164337899 0
0x40D3AD70 4 262144 262080 158912 0 103168 158912 0x00000000 0 0
0x40D3B670 5 32768 32704 17888 0 14816 17888 0x00000000 0 0
0x40D320D0 6 98304 98112 70816 0 27296 70816 0x00000000 1157180278 0
0x40D32F10 7 1 1 1 0 0 0 0x00000000 1108698503 0
0x40D33560 8 101 101 101 0 0 0 0x00000000 1169629342 0
0x5286E060 9 1 1 1 0 0 0 0x00000000 1147432093 0