set lines 120set pages 100set term offcol tablespace_name format a15col "SIZE(KB)" format a20col "USED(KB)" format a20col "FREE(KB)" format a20col "USED(%)" format 990.99select tablespace_name ,to_char(nvl(ddf.total_bytes / 1024, 0),'999,9…

col tablespace_name format a30col file_name format a30break on tablespace_nameselect tablespace_name ,' (表領域)' file_name ,sum(bytes) / 1024 / 1024 bytes_mb ,sum(bytes - nvl(c3,0)) / 1024 used_kb ,sum(nvl(c3,0)) / 1024 free_kb ,round*1 /…

col OWNER format a30col TABLE_NAME format a30col TABLESPACE_NAME format a30 select owner, table_name, tablespace_name, num_rows, avg_row_len, blocks, empty_blocks from dba_tables where owner = 'SYS';