摘要：
1、查询表的统计信息SELECT A.TABLE_NAME, A.NUM_ROWS, A.BLOCKS, A.EMPTY_BLOCKS, A.AVG_SPACE, A.CHAIN_CNT, A.AVG_ROW_LEN, A.GLOBAL_STATS, A.USER_STATS, A.SAMPLE_SIZE, TO_CHAR(A.LAST_ANALYZED, 'YYYY-MM-DD HH24:MI:SS') FROM DBA_TABLES AWHERE OWNER = UPPER(NVL('&OWNER', USER)) AND TABLE_NAME = 阅读全文
posted @ 2012-05-22 09:56 徐正柱- 阅读(1732) 评论(0) 推荐(0) 编辑