DB스토리

--Migration S SCOTT> select sum(blocks) from user_extents 2 where segment_name='TM'; SUM(BLOCKS) ----------- 512 S SCOTT> select count(*) from tm; COUNT(*) ---------- 200000 S SCOTT> update tm set data='123456789012345678901234567890'; 200000 행이 갱신되었습니다. S SCOTT> select sum(blocks) from user_extents 2 where segment_name='TM'; SUM(BLOCKS) ----------- 2048 --Row Chaining S SCOTT> analyze table tm ..