查看/修改块大小
show parameter db_2k_c
alter system set db_2k_cache_size=4m;
建表空间
create tablespace test datafile '/home/oracle/t1/test01.dbf' size 10m blocksize 2k extent management local uniform size 128k segment space management auto;
建用户
Create user me identified by "123456" default tablespace test quota 2m on test;
Grant connect,resource to me;
 
建立一个表格。这个表格很有用。数据库系统会把分析的结果保存到这个表中。
@../rdbms/admin/utlchain.sql
建表
create table t (v char(2000))pctfree 50;
insert into t values('a');
commit
分析目的表格。
analyze table t list chained rows into chained_rows;
 
select count(1) from chained_rows;
 
select * from t where rowid in (select head_rowid from chained_rows);
 
 
SQL> select dbms_rowid.rowid_object(rowid) from t;
select dbms_rowid.rowid_relative_fno(rowid) from t;
select dbms_rowid.rowid_block_number(rowid) from t;
select dbms_rowid.rowid_row_number(rowid) from t;