Partition Storage — 7 : Revisiting HWM – 2 (again)

Revisiting the previous test case, but with a larger AVG_ROW_LEN SQL> create table part_table_large(id_column number(6), data_col_1 varchar2(100), data_col_2 varchar2(100)) partition by range (id_column) (partition p_100 values less than (101), partition p_200 values less than (201), partition p_300 values less than (301), partition p_400 values less than (401), partition p_max values less than (maxvalue))/ 2 3 4 5 6 7 8 9 Table created.SQL> SQL> insert into part_table_large values (51,rpad('String',75,'X'), rpad('Another',60,'Y')) 2 3 SQL> /1 row created.SQL> SQL> commit;Commit complete.SQL> SQL> declare cntr number; begin cntr := 0; while cntr < 100000 loop insert into part_table_large values (25, rpad('String',75,'X'), rpad('Another',60,'Y')); commit; cntr := cntr + 1; end loop;end; 2 3 4 5 6 7 8 9 10 11 12 13 14 /PL/SQL procedure successfully completed.SQL> commit;Commit complete.SQL> SQL> declare cntr number; begin cntr := 0; while cntr < 500001 loop insert into part_table_large values (45, rpad('String',75,'X'), rpad('Another',60,'Y')); commit; cntr := cntr