column db_block_size new_value blksz noprint select value db_block_size from v$parameter where name='db_block_size'; column tablespace_name format a16; column file_name format a60; set linesize 160; select file_name,round(bytes/(1024*1024),0) total_space,autoextensible,increment_by*&blksz/(1024*1024) as incement,maxbytes/(1024*1024) as maxsize from dba_data_files order by tablespace_name;
狠一点的用 rowid 看占用了多少个 block
select value db_block_size from v$parameter where name='db_block_size';
column tablespace_name format a16;
column file_name format a60;
set linesize 160;
select file_name,round(bytes/(1024*1024),0) total_space,autoextensible,increment_by*&blksz/(1024*1024) as incement,maxbytes/(1024*1024) as maxsize from dba_data_files order by tablespace_name;
tab1中有100万条记录,tab2中有200万条记录,tab3中有300万条记录,需要查看tab2表的200万记录占用的物理空间。