Admin 2. 11장 Managing Storage (실제 저장공간,t/s)
--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 ..
DataBase/Oracle
2012. 10. 18. 17:39