91 积分	0 好友	3 主题

fixed tables的统计信息

1^#

发表于 2012-2-23 16:57:16 | 查看: 3708| 回复: 1

请问怎么查fixed tables的统计信息？

2^#

发表于 2012-2-23 21:39:14

ODM test:

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
BEGIN
DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
END;
SQL> select * from v$fixed_table where rownum<3;
NAME OBJECT_ID TYPE TABLE_NUM
------------------------------ ---------- ----- ----------
X$KQFTA 4294950912 TABLE 0
X$KQFVI 4294950913 TABLE 1
1* select * from tab_stats$ where obj#=4294950912
SQL> /
OBJ# CACHEDBLK CACHEHIT LOGICALREAD ROWCNT BLKCNT EMPCNT AVGSPC CHNCNT AVGRLN AVGSPC_FLB FLBCNT ANALYZETI SAMPLESIZE FLAGS SPARE1 SPARE2 SPARE3
---------- ---------- ---------- ----------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- --------- ---------- ---------- ---------- ---------- ----------
SPARE4
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SPARE5
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SPARE6
---------
4294950912 935 0 0 0 0 50 0 0 23-FEB-12 935 0

复制代码

		自动登录	找回密码
密码			注册