不经历风雨,怎么见彩虹

关键字：程序开发 应用软件 select alter

-- 检查无效对象 select object_name,object_type,owner from dba_objects where status='VALID'
--查找最高点和表的无用块 select blocks "HIGH WATER MARK",empty_blocks "UNUSED SAPCE" from dba_tables where table_name ='TBZY_FAREACCOUNT' AND OWNER='HIS_SERVER'
--查找用户的表空间 SELECT USERNAME FROM DBA_USERS WHERE DEFAULT_TABLESPACE ='SYSTEM' OR TEMPORARY_TABLESPACE='SYSTEM'
--数据库I/O大小的计算 db_block_size * db_fi……