반응형
| Oracle Partition Table Fragmentation |
| 오라클 파티셔닝 테이블,인덱스 단편화를 확인합니다. |
파티션 테이블 기본구성(참고)
Oracle Partition TABLE 기본 구성
Oracle Partition TABLE 기본 구성 #테이블 스페이스 생성 CREATE TABLESPACE TEST DATAFILE '+ASM' SIZE 1G AUTOEXTEND ON; #유저생성 CREATE USER PCW IDENTIFIED BY 'oracle1' DEFAULT TABLESPACE TABLESPA..
datapyo.tistory.com
#FRAGMENT발생 DML
#단편화 발생 DML
begin /*+ 단편화 발생을 위한 테이블 DELETE UPDATE */
for i in 1 .. 100000
loop
UPDATE PCW.ORDERS_PT
SET
ORDER_MODE = ORDER_MODE ||dbms_random.string('W', 1),
CUSTOMER_ID = CUSTOMER_ID ||dbms_random.string('C', 1),
EMPLOYEE_ID = EMPLOYEE_ID ||dbms_random.string('P', 1)
WHERE ORDER_ID = (SELECT TRUNC(DBMS_RANDOM.VALUE(1,1200000)) FROM DUAL);
COMMIT;
DELETE from PCW.ORDERS_PT WHERE ORDER_ID = (SELECT TRUNC(DBMS_RANDOM.VALUE(1,1200000)) FROM DUAL);
COMMIT;
end loop;
end;
/
#FRAGMENT 확인 SQL
#단편화 확인 SQL
declare
l_fs1_bytes number;
l_fs2_bytes number;
l_fs3_bytes number;
l_fs4_bytes number;
l_fs1_blocks number;
l_fs2_blocks number;
l_fs3_blocks number;
l_fs4_blocks number;
l_full_bytes number;
l_full_blocks number;
l_unformatted_bytes number;
l_unformatted_blocks number;
begin
dbms_space.space_usage(
segment_owner => ' ', -- 1. Owner 입력
segment_name => ' ', -- 2. 테이블 이름 입력
segment_type => ' ', -- 3. 세그먼트 종류 입력 (여기서는 테이블)
fs1_bytes => l_fs1_bytes,
fs1_blocks => l_fs1_blocks,
fs2_bytes => l_fs2_bytes,
fs2_blocks => l_fs2_blocks,
fs3_bytes => l_fs3_bytes,
fs3_blocks => l_fs3_blocks,
fs4_bytes => l_fs4_bytes,
fs4_blocks => l_fs4_blocks,
full_bytes => l_full_bytes,
full_blocks => l_full_blocks,
unformatted_blocks => l_unformatted_blocks,
unformatted_bytes => l_unformatted_bytes
);
dbms_output.put_line(' FS1 Blocks = '||l_fs1_blocks||' Bytes = '||l_fs1_bytes);
dbms_output.put_line(' FS2 Blocks = '||l_fs2_blocks||' Bytes = '||l_fs2_bytes);
dbms_output.put_line(' FS3 Blocks = '||l_fs3_blocks||' Bytes = '||l_fs3_bytes);
dbms_output.put_line(' FS4 Blocks = '||l_fs4_blocks||' Bytes = '||l_fs4_bytes);
dbms_output.put_line('Full Blocks = '||l_full_blocks||'
Bytes = '||l_full_bytes);
end;
/
| #DML 발생 전 | #DML 발생 후 |
-------------------------[Start Time: 2021/11/17 17:03:50]----- SQL> PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 430 / 3522560 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 367 / 3006464 [Bytes] Unformatted Blocks / Bytes : 208 / 1703936 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 3014656 [Bytes] Est Segment_size : 5373952 [Bytes] Reorg Ratio : 35.94 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 429 / 3514368 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 368 / 3014656 [Bytes] Unformatted Blocks / Bytes : 208 / 1703936 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 3022848 [Bytes] Est Segment_size : 5365760 [Bytes] Reorg Ratio : 36.04 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 428 / 3506176 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 369 / 3022848 [Bytes] Unformatted Blocks / Bytes : 208 / 1703936 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 3031040 [Bytes] Est Segment_size : 5357568 [Bytes] Reorg Ratio : 36.13 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 427 / 3497984 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 370 / 3031040 [Bytes] Unformatted Blocks / Bytes : 208 / 1703936 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 3039232 [Bytes] Est Segment_size : 5349376 [Bytes] Reorg Ratio : 36.23 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 429 / 3514368 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 0 / 0 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 369 / 3022848 [Bytes] Unformatted Blocks / Bytes : 208 / 1703936 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 3022848 [Bytes] Est Segment_size : 5365760 [Bytes] Reorg Ratio : 36.04 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 1148 / 9404416 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 1041 / 8527872 [Bytes] Unformatted Blocks / Bytes : 832 / 6815744 [Bytes] Total_Blocks / Bytes : 3022 / 24756224 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 50 [409600] Bytes Cur Segmennt Size : 25165824 [Bytes] Segment Size(Below HWM) : 24756224 [Bytes] Est Return_size : 8536064 [Bytes] Est Segment_size : 16629760 [Bytes] Reorg Ratio : 33.92 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 430 / 3522560 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 0 / 0 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 368 / 3014656 [Bytes] Unformatted Blocks / Bytes : 208 / 1703936 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 3014656 [Bytes] Est Segment_size : 5373952 [Bytes] Reorg Ratio : 35.94 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 428 / 3506176 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 0 / 0 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 370 / 3031040 [Bytes] Unformatted Blocks / Bytes : 208 / 1703936 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 3031040 [Bytes] Est Segment_size : 5357568 [Bytes] Reorg Ratio : 36.13 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 0 / 0 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 0 / 0 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 350 / 2867200 [Bytes] Unformatted Blocks / Bytes : 656 / 5373952 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 2867200 [Bytes] Est Segment_size : 5521408 [Bytes] Reorg Ratio : 34.18 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 1145 / 9379840 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 1 / 8192 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 1043 / 8544256 [Bytes] Unformatted Blocks / Bytes : 832 / 6815744 [Bytes] Total_Blocks / Bytes : 3022 / 24756224 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 50 [409600] Bytes Cur Segmennt Size : 25165824 [Bytes] Segment Size(Below HWM) : 24756224 [Bytes] Est Return_size : 8560640 [Bytes] Est Segment_size : 16605184 [Bytes] Reorg Ratio : 34.02 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 1138 / 9322496 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 1051 / 8609792 [Bytes] Unformatted Blocks / Bytes : 832 / 6815744 [Bytes] Total_Blocks / Bytes : 3022 / 24756224 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 50 [409600] Bytes Cur Segmennt Size : 25165824 [Bytes] Segment Size(Below HWM) : 24756224 [Bytes] Est Return_size : 8617984 [Bytes] Est Segment_size : 16547840 [Bytes] Reorg Ratio : 34.24 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 430 / 3522560 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 0 / 0 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 368 / 3014656 [Bytes] Unformatted Blocks / Bytes : 208 / 1703936 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 3014656 [Bytes] Est Segment_size : 5373952 [Bytes] Reorg Ratio : 35.94 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 637 / 5218304 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 33 / 270336 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 270336 [Bytes] Est Segment_size : 6021120 [Bytes] Reorg Ratio : 4.3 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 213 / 1744896 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 173 / 1417216 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 110 / 901120 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 1417216 [Bytes] Est Segment_size : 2777088 [Bytes] Reorg Ratio : 33.79 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 212 / 1736704 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 174 / 1425408 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 110 / 901120 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 1425408 [Bytes] Est Segment_size : 2768896 [Bytes] Reorg Ratio : 33.98 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 212 / 1736704 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 174 / 1425408 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 110 / 901120 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 1425408 [Bytes] Est Segment_size : 2768896 [Bytes] Reorg Ratio : 33.98 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 211 / 1728512 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 159 / 1302528 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 1302528 [Bytes] Est Segment_size : 1843200 [Bytes] Reorg Ratio : 41.41 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 212 / 1736704 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 158 / 1294336 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 1294336 [Bytes] Est Segment_size : 1851392 [Bytes] Reorg Ratio : 41.15 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 213 / 1744896 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 157 / 1286144 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 1286144 [Bytes] Est Segment_size : 1859584 [Bytes] Reorg Ratio : 40.89 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 213 / 1744896 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 173 / 1417216 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 110 / 901120 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 1417216 [Bytes] Est Segment_size : 2777088 [Bytes] Reorg Ratio : 33.79 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 212 / 1736704 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 158 / 1294336 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 1294336 [Bytes] Est Segment_size : 1851392 [Bytes] Reorg Ratio : 41.15 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 10 / 81920 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 172 / 1409024 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 244 / 1998848 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 12 [98304] Bytes Cur Segmennt Size : 2097152 [Bytes] Segment Size(Below HWM) : 1998848 [Bytes] Est Return_size : 1409024 [Bytes] Est Segment_size : 688128 [Bytes] Reorg Ratio : 67.19 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 551 / 4513792 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 497 / 4071424 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 1126 / 9224192 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 26 [212992] Bytes Cur Segmennt Size : 9437184 [Bytes] Segment Size(Below HWM) : 9224192 [Bytes] Est Return_size : 4071424 [Bytes] Est Segment_size : 5365760 [Bytes] Reorg Ratio : 43.14 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 547 / 4481024 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 501 / 4104192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 1126 / 9224192 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 26 [212992] Bytes Cur Segmennt Size : 9437184 [Bytes] Segment Size(Below HWM) : 9224192 [Bytes] Est Return_size : 4104192 [Bytes] Est Segment_size : 5332992 [Bytes] Reorg Ratio : 43.49 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 552 / 4521984 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 496 / 4063232 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 1126 / 9224192 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 26 [212992] Bytes Cur Segmennt Size : 9437184 [Bytes] Segment Size(Below HWM) : 9224192 [Bytes] Est Return_size : 4063232 [Bytes] Est Segment_size : 5373952 [Bytes] Reorg Ratio : 43.06 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 629 / 5152768 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 41 / 335872 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 335872 [Bytes] Est Segment_size : 5955584 [Bytes] Reorg Ratio : 5.34 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 643 / 5267456 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 27 / 221184 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 221184 [Bytes] Est Segment_size : 6070272 [Bytes] Reorg Ratio : 3.52 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 641 / 5251072 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 29 / 237568 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 237568 [Bytes] Est Segment_size : 6053888 [Bytes] Reorg Ratio : 3.78 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 631 / 5169152 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 39 / 319488 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 319488 [Bytes] Est Segment_size : 5971968 [Bytes] Reorg Ratio : 5.08 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 638 / 5226496 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 32 / 262144 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 262144 [Bytes] Est Segment_size : 6029312 [Bytes] Reorg Ratio : 4.17 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 826 / 6766592 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 827 / 6774784 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 69 [565248] Bytes Cur Segmennt Size : 7340032 [Bytes] Segment Size(Below HWM) : 6774784 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 7331840 [Bytes] Reorg Ratio : .11 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 641 / 5251072 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 29 / 237568 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 237568 [Bytes] Est Segment_size : 6053888 [Bytes] Reorg Ratio : 3.78 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 633 / 5185536 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 37 / 303104 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 303104 [Bytes] Est Segment_size : 5988352 [Bytes] Reorg Ratio : 4.82 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 36 / 294912 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 256 / 2097152 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 2097152 [Bytes] Est Segment_size : 1048576 [Bytes] Reorg Ratio : 66.67 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1773 / 14524416 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 47 / 385024 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 1882 / 15417344 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 38 [311296] Bytes Cur Segmennt Size : 15728640 [Bytes] Segment Size(Below HWM) : 15417344 [Bytes] Est Return_size : 385024 [Bytes] Est Segment_size : 15343616 [Bytes] Reorg Ratio : 2.45 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1756 / 14385152 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 48 / 393216 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 1882 / 15417344 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 38 [311296] Bytes Cur Segmennt Size : 15728640 [Bytes] Segment Size(Below HWM) : 15417344 [Bytes] Est Return_size : 393216 [Bytes] Est Segment_size : 15335424 [Bytes] Reorg Ratio : 2.5 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1776 / 14548992 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 44 / 360448 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 1882 / 15417344 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 38 [311296] Bytes Cur Segmennt Size : 15728640 [Bytes] Segment Size(Below HWM) : 15417344 [Bytes] Est Return_size : 360448 [Bytes] Est Segment_size : 15368192 [Bytes] Reorg Ratio : 2.29 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 630 / 5160960 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 40 / 327680 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 327680 [Bytes] Est Segment_size : 5963776 [Bytes] Reorg Ratio : 5.21 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 644 / 5275648 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 26 / 212992 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 212992 [Bytes] Est Segment_size : 6078464 [Bytes] Reorg Ratio : 3.39 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 645 / 5283840 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 25 / 204800 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 204800 [Bytes] Est Segment_size : 6086656 [Bytes] Reorg Ratio : 3.26 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 630 / 5160960 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 40 / 327680 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 327680 [Bytes] Est Segment_size : 5963776 [Bytes] Reorg Ratio : 5.21 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 635 / 5201920 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 35 / 286720 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 286720 [Bytes] Est Segment_size : 6004736 [Bytes] Reorg Ratio : 4.56 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 622 / 5095424 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 16 / 131072 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 110 / 901120 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 131072 [Bytes] Est Segment_size : 6160384 [Bytes] Reorg Ratio : 2.08 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 634 / 5193728 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 36 / 294912 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 294912 [Bytes] Est Segment_size : 5996544 [Bytes] Reorg Ratio : 4.69 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 630 / 5160960 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 40 / 327680 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 327680 [Bytes] Est Segment_size : 5963776 [Bytes] Reorg Ratio : 5.21 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 39 / 319488 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 253 / 2072576 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 2072576 [Bytes] Est Segment_size : 1073152 [Bytes] Reorg Ratio : 65.89 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1762 / 14434304 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 42 / 344064 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 1882 / 15417344 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 38 [311296] Bytes Cur Segmennt Size : 15728640 [Bytes] Segment Size(Below HWM) : 15417344 [Bytes] Est Return_size : 344064 [Bytes] Est Segment_size : 15384576 [Bytes] Reorg Ratio : 2.19 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1770 / 14499840 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 50 / 409600 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 1882 / 15417344 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 38 [311296] Bytes Cur Segmennt Size : 15728640 [Bytes] Segment Size(Below HWM) : 15417344 [Bytes] Est Return_size : 409600 [Bytes] Est Segment_size : 15319040 [Bytes] Reorg Ratio : 2.6 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1759 / 14409728 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 45 / 368640 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 1882 / 15417344 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 38 [311296] Bytes Cur Segmennt Size : 15728640 [Bytes] Segment Size(Below HWM) : 15417344 [Bytes] Est Return_size : 368640 [Bytes] Est Segment_size : 15360000 [Bytes] Reorg Ratio : 2.34 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 311 / 2547712 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 312 / 2555904 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 72 [589824] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 2555904 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 3137536 [Bytes] Reorg Ratio : .26 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 310 / 2539520 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 311 / 2547712 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 73 [598016] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 2547712 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 3137536 [Bytes] Reorg Ratio : .26 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 309 / 2531328 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 310 / 2539520 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 74 [606208] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 2539520 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 3137536 [Bytes] Reorg Ratio : .26 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 309 / 2531328 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 310 / 2539520 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 74 [606208] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 2539520 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 3137536 [Bytes] Reorg Ratio : .26 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 309 / 2531328 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 310 / 2539520 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 74 [606208] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 2539520 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 3137536 [Bytes] Reorg Ratio : .26 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 310 / 2539520 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 311 / 2547712 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 73 [598016] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 2547712 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 3137536 [Bytes] Reorg Ratio : .26 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 310 / 2539520 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 311 / 2547712 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 73 [598016] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 2547712 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 3137536 [Bytes] Reorg Ratio : .26 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 309 / 2531328 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 310 / 2539520 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 74 [606208] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 2539520 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 3137536 [Bytes] Reorg Ratio : .26 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 0 / 0 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 1 / 8192 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 7 [57344] Bytes Cur Segmennt Size : 65536 [Bytes] Segment Size(Below HWM) : 8192 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 57344 [Bytes] Reorg Ratio : 12.5 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 824 / 6750208 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 825 / 6758400 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 71 [581632] Bytes Cur Segmennt Size : 7340032 [Bytes] Segment Size(Below HWM) : 6758400 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 7331840 [Bytes] Reorg Ratio : .11 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 819 / 6709248 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 1 / 8192 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 820 / 6717440 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 76 [622592] Bytes Cur Segmennt Size : 7340032 [Bytes] Segment Size(Below HWM) : 6717440 [Bytes] Est Return_size : 8192 [Bytes] Est Segment_size : 7331840 [Bytes] Reorg Ratio : .11 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_03 (INDEX) Full Blocks / Bytes (0% Free) : 12740 / 104366080 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 417 / 3416064 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 13157 / 107782144 [Bytes] Patition_name : none Meta and Not Used Block : 155 [1269760] Bytes Cur Segmennt Size : 109051904 [Bytes] Segment Size(Below HWM) : 107782144 [Bytes] Est Return_size : 3416064 [Bytes] Est Segment_size : 105635840 [Bytes] Reorg Ratio : 3.13 % ------------------------------------------------------------------------------------------ |
-------------------------[Start Time: 2021/11/22 11:18:01]----- SQL> PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 301 / 2465792 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 4 / 32768 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 216 /1769472 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 341 / 2793472 [Bytes] Unformatted Blocks / Bytes : 144 / 1179648 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 4595712 [Bytes] Est Segment_size : 3792896 [Bytes] Reorg Ratio : 54.79 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 289 / 2367488 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 5 / 40960 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 228 / 1867776 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 1 / 8192 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 339 / 2777088 [Bytes] Unformatted Blocks / Bytes : 144 / 1179648 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 4694016 [Bytes] Est Segment_size : 3694592 [Bytes] Reorg Ratio : 55.96 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 347 / 2842624 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 3 / 24576 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 162 / 1327104 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 1 / 8192 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 349 / 2859008 [Bytes] Unformatted Blocks / Bytes : 144 / 1179648 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 4218880 [Bytes] Est Segment_size : 4169728 [Bytes] Reorg Ratio : 50.29 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 293 / 2400256 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 5 / 40960 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 219 / 1794048 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 1 / 8192 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 344 / 2818048 [Bytes] Unformatted Blocks / Bytes : 144 / 1179648 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 4661248 [Bytes] Est Segment_size : 3727360 [Bytes] Reorg Ratio : 55.57 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 317 / 2596864 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 3 / 24576 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 198 / 1622016 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 344 / 2818048 [Bytes] Unformatted Blocks / Bytes : 144 / 1179648 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 4464640 [Bytes] Est Segment_size : 3923968 [Bytes] Reorg Ratio : 53.22 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 306 / 2506752 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 1 / 8192 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 213 / 1744896 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 342 / 2801664 [Bytes] Unformatted Blocks / Bytes : 144 / 1179648 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 4554752 [Bytes] Est Segment_size : 3833856 [Bytes] Reorg Ratio : 54.3 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 1138 / 9322496 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 7 / 57344 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 210 / 1720320 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 835 / 6840320 [Bytes] Unformatted Blocks / Bytes : 832 / 6815744 [Bytes] Total_Blocks / Bytes : 3022 / 24756224 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 50 [409600] Bytes Cur Segmennt Size : 25165824 [Bytes] Segment Size(Below HWM) : 24756224 [Bytes] Est Return_size : 8617984 [Bytes] Est Segment_size : 16547840 [Bytes] Reorg Ratio : 34.24 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 311 / 2547712 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 3 / 24576 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 206 / 1687552 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 1 / 8192 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 341 / 2793472 [Bytes] Unformatted Blocks / Bytes : 144 / 1179648 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 4513792 [Bytes] Est Segment_size : 3874816 [Bytes] Reorg Ratio : 53.81 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 310 / 2539520 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 4 / 32768 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 205 / 1679360 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 343 / 2809856 [Bytes] Unformatted Blocks / Bytes : 144 / 1179648 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 4521984 [Bytes] Est Segment_size : 3866624 [Bytes] Reorg Ratio : 53.91 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 110 / 901120 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 1 / 8192 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 0 / 0 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 367 / 3006464 [Bytes] Unformatted Blocks / Bytes : 528 / 4325376 [Bytes] Total_Blocks / Bytes : 1006 / 8241152 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 18 [147456] Bytes Cur Segmennt Size : 8388608 [Bytes] Segment Size(Below HWM) : 8241152 [Bytes] Est Return_size : 3014656 [Bytes] Est Segment_size : 5373952 [Bytes] Reorg Ratio : 35.94 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 1125 / 9216000 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 6 / 49152 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 225 / 1843200 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 2 / 16384 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 832 / 6815744 [Bytes] Unformatted Blocks / Bytes : 832 / 6815744 [Bytes] Total_Blocks / Bytes : 3022 / 24756224 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 50 [409600] Bytes Cur Segmennt Size : 25165824 [Bytes] Segment Size(Below HWM) : 24756224 [Bytes] Est Return_size : 8724480 [Bytes] Est Segment_size : 16441344 [Bytes] Reorg Ratio : 34.67 % ------------------------------------------------------------------------------------------ PCW.ORDERS_PT (TABLE PARTITION) Full Blocks / Bytes (0% Free) : 1121 / 9183232 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 11 / 90112 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 220 / 1802240 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 1 / 8192 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 837 / 6856704 [Bytes] Unformatted Blocks / Bytes : 832 / 6815744 [Bytes] Total_Blocks / Bytes : 3022 / 24756224 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 50 [409600] Bytes Cur Segmennt Size : 25165824 [Bytes] Segment Size(Below HWM) : 24756224 [Bytes] Est Return_size : 8757248 [Bytes] Est Segment_size : 16408576 [Bytes] Reorg Ratio : 34.8 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 681 / 5578752 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 67 / 548864 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 548864 [Bytes] Est Segment_size : 5742592 [Bytes] Reorg Ratio : 8.72 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 262 / 2146304 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 172 / 1409024 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 1409024 [Bytes] Est Segment_size : 2785280 [Bytes] Reorg Ratio : 33.59 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 261 / 2138112 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 173 / 1417216 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 1417216 [Bytes] Est Segment_size : 2777088 [Bytes] Reorg Ratio : 33.79 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 260 / 2129920 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 174 / 1425408 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 1425408 [Bytes] Est Segment_size : 2768896 [Bytes] Reorg Ratio : 33.98 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 261 / 2138112 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 109 / 892928 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 892928 [Bytes] Est Segment_size : 2252800 [Bytes] Reorg Ratio : 28.39 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 261 / 2138112 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 109 / 892928 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 892928 [Bytes] Est Segment_size : 2252800 [Bytes] Reorg Ratio : 28.39 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 262 / 2146304 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 108 / 884736 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 884736 [Bytes] Est Segment_size : 2260992 [Bytes] Reorg Ratio : 28.13 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 261 / 2138112 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 173 / 1417216 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 1417216 [Bytes] Est Segment_size : 2777088 [Bytes] Reorg Ratio : 33.79 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 261 / 2138112 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 109 / 892928 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 892928 [Bytes] Est Segment_size : 2252800 [Bytes] Reorg Ratio : 28.39 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 60 / 491520 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 122 / 999424 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 244 / 1998848 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 12 [98304] Bytes Cur Segmennt Size : 2097152 [Bytes] Segment Size(Below HWM) : 1998848 [Bytes] Est Return_size : 999424 [Bytes] Est Segment_size : 1097728 [Bytes] Reorg Ratio : 47.66 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 702 / 5750784 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 362 / 2965504 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 1126 / 9224192 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 26 [212992] Bytes Cur Segmennt Size : 9437184 [Bytes] Segment Size(Below HWM) : 9224192 [Bytes] Est Return_size : 2965504 [Bytes] Est Segment_size : 6471680 [Bytes] Reorg Ratio : 31.42 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 698 / 5718016 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 366 / 2998272 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 1126 / 9224192 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 26 [212992] Bytes Cur Segmennt Size : 9437184 [Bytes] Segment Size(Below HWM) : 9224192 [Bytes] Est Return_size : 2998272 [Bytes] Est Segment_size : 6438912 [Bytes] Reorg Ratio : 31.77 % ------------------------------------------------------------------------------------------ PCW.PX_ORDERS_PT (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 702 / 5750784 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 362 / 2965504 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 1126 / 9224192 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 26 [212992] Bytes Cur Segmennt Size : 9437184 [Bytes] Segment Size(Below HWM) : 9224192 [Bytes] Est Return_size : 2965504 [Bytes] Est Segment_size : 6471680 [Bytes] Reorg Ratio : 31.42 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 671 / 5496832 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 61 / 499712 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 16 / 131072 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 499712 [Bytes] Est Segment_size : 5791744 [Bytes] Reorg Ratio : 7.94 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 682 / 5586944 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 66 / 540672 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 540672 [Bytes] Est Segment_size : 5750784 [Bytes] Reorg Ratio : 8.59 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 676 / 5537792 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 72 / 589824 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 589824 [Bytes] Est Segment_size : 5701632 [Bytes] Reorg Ratio : 9.38 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 663 / 5431296 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 69 / 565248 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 16 / 131072 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 565248 [Bytes] Est Segment_size : 5726208 [Bytes] Reorg Ratio : 8.98 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1031 / 8445952 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 47 / 385024 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 1126 / 9224192 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 26 [212992] Bytes Cur Segmennt Size : 9437184 [Bytes] Segment Size(Below HWM) : 9224192 [Bytes] Est Return_size : 385024 [Bytes] Est Segment_size : 9052160 [Bytes] Reorg Ratio : 4.08 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 672 / 5505024 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 76 / 622592 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 622592 [Bytes] Est Segment_size : 5668864 [Bytes] Reorg Ratio : 9.9 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 680 / 5570560 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 68 / 557056 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 557056 [Bytes] Est Segment_size : 5734400 [Bytes] Reorg Ratio : 8.85 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 670 / 5488640 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 62 / 507904 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 16 / 131072 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 507904 [Bytes] Est Segment_size : 5783552 [Bytes] Reorg Ratio : 8.07 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 266 / 2179072 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 26 / 212992 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 212992 [Bytes] Est Segment_size : 2932736 [Bytes] Reorg Ratio : 6.77 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1901 / 15572992 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 45 / 368640 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 2008 / 16449536 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 40 [327680] Bytes Cur Segmennt Size : 16777216 [Bytes] Segment Size(Below HWM) : 16449536 [Bytes] Est Return_size : 368640 [Bytes] Est Segment_size : 16408576 [Bytes] Reorg Ratio : 2.2 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1902 / 15581184 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 58 / 475136 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 2008 / 16449536 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 40 [327680] Bytes Cur Segmennt Size : 16777216 [Bytes] Segment Size(Below HWM) : 16449536 [Bytes] Est Return_size : 475136 [Bytes] Est Segment_size : 16302080 [Bytes] Reorg Ratio : 2.83 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_01 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1908 / 15630336 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 38 / 311296 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 2008 / 16449536 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 40 [327680] Bytes Cur Segmennt Size : 16777216 [Bytes] Segment Size(Below HWM) : 16449536 [Bytes] Est Return_size : 311296 [Bytes] Est Segment_size : 16465920 [Bytes] Reorg Ratio : 1.86 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 663 / 5431296 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 69 / 565248 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 16 / 131072 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 565248 [Bytes] Est Segment_size : 5726208 [Bytes] Reorg Ratio : 8.98 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 679 / 5562368 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 69 / 565248 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 565248 [Bytes] Est Segment_size : 5726208 [Bytes] Reorg Ratio : 8.98 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 681 / 5578752 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 67 / 548864 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 548864 [Bytes] Est Segment_size : 5742592 [Bytes] Reorg Ratio : 8.72 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 661 / 5414912 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 71 / 581632 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 16 / 131072 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 581632 [Bytes] Est Segment_size : 5709824 [Bytes] Reorg Ratio : 9.24 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 669 / 5480448 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 63 / 516096 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 16 / 131072 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 516096 [Bytes] Est Segment_size : 5775360 [Bytes] Reorg Ratio : 8.2 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 657 / 5382144 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 75 / 614400 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 16 / 131072 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 614400 [Bytes] Est Segment_size : 5677056 [Bytes] Reorg Ratio : 9.77 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 670 / 5488640 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 78 / 638976 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 638976 [Bytes] Est Segment_size : 5652480 [Bytes] Reorg Ratio : 10.16 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 658 / 5390336 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 74 / 606208 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 16 / 131072 [Bytes] Total_Blocks / Bytes : 748 / 6127616 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 20 [163840] Bytes Cur Segmennt Size : 6291456 [Bytes] Segment Size(Below HWM) : 6127616 [Bytes] Est Return_size : 606208 [Bytes] Est Segment_size : 5685248 [Bytes] Reorg Ratio : 9.64 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 265 / 2170880 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 27 / 221184 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 78 / 638976 [Bytes] Total_Blocks / Bytes : 370 / 3031040 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 14 [114688] Bytes Cur Segmennt Size : 3145728 [Bytes] Segment Size(Below HWM) : 3031040 [Bytes] Est Return_size : 221184 [Bytes] Est Segment_size : 2924544 [Bytes] Reorg Ratio : 7.03 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1894 / 15515648 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 52 / 425984 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 2008 / 16449536 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 40 [327680] Bytes Cur Segmennt Size : 16777216 [Bytes] Segment Size(Below HWM) : 16449536 [Bytes] Est Return_size : 425984 [Bytes] Est Segment_size : 16351232 [Bytes] Reorg Ratio : 2.54 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1895 / 15523840 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 65 / 532480 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 2008 / 16449536 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 40 [327680] Bytes Cur Segmennt Size : 16777216 [Bytes] Segment Size(Below HWM) : 16449536 [Bytes] Est Return_size : 532480 [Bytes] Est Segment_size : 16244736 [Bytes] Reorg Ratio : 3.17 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_02 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1902 / 15581184 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 44 / 360448 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 62 / 507904 [Bytes] Total_Blocks / Bytes : 2008 / 16449536 [Bytes] Patition_name : PCW_202112 Meta and Not Used Block : 40 [327680] Bytes Cur Segmennt Size : 16777216 [Bytes] Segment Size(Below HWM) : 16449536 [Bytes] Est Return_size : 360448 [Bytes] Est Segment_size : 16416768 [Bytes] Reorg Ratio : 2.15 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 405 / 3317760 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 43 / 352256 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202101 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 352256 [Bytes] Est Segment_size : 3842048 [Bytes] Reorg Ratio : 8.4 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 395 / 3235840 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 53 / 434176 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202102 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 434176 [Bytes] Est Segment_size : 3760128 [Bytes] Reorg Ratio : 10.35 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 399 / 3268608 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 49 / 401408 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202103 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 401408 [Bytes] Est Segment_size : 3792896 [Bytes] Reorg Ratio : 9.57 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 395 / 3235840 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 53 / 434176 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202104 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 434176 [Bytes] Est Segment_size : 3760128 [Bytes] Reorg Ratio : 10.35 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 399 / 3268608 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 49 / 401408 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202105 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 401408 [Bytes] Est Segment_size : 3792896 [Bytes] Reorg Ratio : 9.57 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 400 / 3276800 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 48 / 393216 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202106 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 393216 [Bytes] Est Segment_size : 3801088 [Bytes] Reorg Ratio : 9.38 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 400 / 3276800 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 48 / 393216 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202107 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 393216 [Bytes] Est Segment_size : 3801088 [Bytes] Reorg Ratio : 9.38 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 398 / 3260416 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 50 / 409600 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 496 / 4063232 [Bytes] Patition_name : PCW_202108 Meta and Not Used Block : 16 [131072] Bytes Cur Segmennt Size : 4194304 [Bytes] Segment Size(Below HWM) : 4063232 [Bytes] Est Return_size : 409600 [Bytes] Est Segment_size : 3784704 [Bytes] Reorg Ratio : 9.77 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 114 / 933888 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 4 / 32768 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 0 / 0 [Bytes] Total_Blocks / Bytes : 118 / 966656 [Bytes] Patition_name : PCW_202109 Meta and Not Used Block : 10 [81920] Bytes Cur Segmennt Size : 1048576 [Bytes] Segment Size(Below HWM) : 966656 [Bytes] Est Return_size : 32768 [Bytes] Est Segment_size : 1015808 [Bytes] Reorg Ratio : 3.13 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1024 / 8388608 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 54 / 442368 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 1126 / 9224192 [Bytes] Patition_name : PCW_202110 Meta and Not Used Block : 26 [212992] Bytes Cur Segmennt Size : 9437184 [Bytes] Segment Size(Below HWM) : 9224192 [Bytes] Est Return_size : 442368 [Bytes] Est Segment_size : 8994816 [Bytes] Reorg Ratio : 4.69 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_04 (INDEX PARTITION) Full Blocks / Bytes (0% Free) : 1021 / 8364032 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 57 / 466944 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 48 / 393216 [Bytes] Total_Blocks / Bytes : 1126 / 9224192 [Bytes] Patition_name : PCW_202111 Meta and Not Used Block : 26 [212992] Bytes Cur Segmennt Size : 9437184 [Bytes] Segment Size(Below HWM) : 9224192 [Bytes] Est Return_size : 466944 [Bytes] Est Segment_size : 8970240 [Bytes] Reorg Ratio : 4.95 % ------------------------------------------------------------------------------------------ PCW.IX_ORDERS_PT_03 (INDEX) Full Blocks / Bytes (0% Free) : 13897 / 113844224 [Bytes] FS1 Blocks / Bytes (0% ~ 24% Free) : 0 / 0 [Bytes] FS2 Blocks / Bytes (25% ~ 49% Free) : 24 / 196608 [Bytes] FS3 Blocks / Bytes (50% ~ 74% Free) : 0 / 0 [Bytes] FS4 Blocks / Bytes (75% ~ 100% Free): 0 / 0 [Bytes] Unformatted Blocks / Bytes : 256 / 2097152 [Bytes] Total_Blocks / Bytes : 14177 / 116137984 [Bytes] Patition_name : none Meta and Not Used Block : 159 [1302528] Bytes Cur Segmennt Size : 117440512 [Bytes] Segment Size(Below HWM) : 116137984 [Bytes] Est Return_size : 196608 [Bytes] Est Segment_size : 117243904 [Bytes] Reorg Ratio : .17 % ------------------------------------------------------------------------------------------ |
| 종합의견 |
| 테이블 인덱스 관련하여 블록 단편화를 확인합니다. 오브젝트 단편화를 확인 후 리오그 작업에 대해 전략수립합니다. |
반응형
'Oracle > Oracle Admin' 카테고리의 다른 글
| Oracle Partition TABLE 기본 구성 (0) | 2022.02.16 |
|---|---|
| Oracle Controlfile 재 생성 오라클 구성 변경 (0) | 2021.12.20 |
| Oracle Partition Table SPLIT (파티션 스플릿) (0) | 2021.12.17 |
| Oracle Partition Table Shrink 및 Lock 확인 테스트 (0) | 2021.12.09 |
| Oracle Partition Table Index 기본 구성기준 및 SQL 실행계획 (0) | 2021.11.17 |
댓글