1)环境构建,使用笨拙的办法,不断insert,查询extent分配
SQL> insert into scott.e values(8,8,8,8);
SQL> insert into scott.e values(9,9,9,9);
SQL> insert into scott.e values(10,10,10,10);
SQL> insert into scott.e values(11,11,11,11);
SQL> insert into scott.e values(12,12,12,12);
SQL> r
1 select tablespace_name,file_id,extent_id,block_id,
2 bytes/1024 bytes_k,blocks from dba_extents
3 where owner='SCOTT' and segment_name='E'
4*
TABLESPACE_NAM FILE_ID EXTENT_ID BLOCK_ID BYTES_K BLOCKS
-------------- ---------- ---------- ---------- ---------- ----------
USERS 4 0 1768 64 8
USERS 4 1 1776 64 8
USERS 4 2 1784 64 8
USERS 4 3 3200 64 8 --终于新扩建一个区
SQL> select rowid from scott.e where id like '%12%';
ROWID
------------------
AAAS5RAAEAAAA