Oracle基础知识

1、查看表空间的名称及大小 set linesize 140; set pages 200; column tablespace_name format a30; select tablespace_name,min_extents,max_extents,pct_increase,status from dba_tablespaces; select tablespace_name,initial_extent,next_extent,contents,logging,extent_management,allocation_type from dba_tables