查询数据库级的统计值的公开属性（PUBLISH） :true(为公开)，false(为私有)

SQL> SELECT DBMS_STATS.get_prefs('PUBLISH') FROM DUAL;

DBMS_STATS.GET_PREFS('PUBLISH'
--------------------------------------------------------------------------------
TRUE

查询表级的统计值的公开属性

SQL> SELECT DBMS_STATS.get_prefs('PUBLISH','SCOTT','EMP') FROM DUAL;

DBMS_STATS.GET_PREFS('PUBLISH'
--------------------------------------------------------------------------------
TRUE

设置表级的统计值PUBLISH属性为私有:

SQL> EXEC DBMS_STATS.set_table_prefs('SCOTT',tabname => 'EMP',pname => 'PUBLISH',pvalue => 'FALSE');

PL/SQL procedure successfully completed

SQL> exec dbms_stats.delete_table_stats(ownname => 'SCOTT',tabname => 'EMP');

PL/SQL procedure successfully completed

SQL> exec dbms_stats.gather_table_stats(ownname => 'SCOTT',tabname => 'EMP');

PL/SQL procedure successfully completed

SQL> SELECT TABLE_NAME,LAST_ANALYZED,NUM_ROWS FROM
2 USER_TABLES
3 WHERE TABLE_NAME='EMP';

TABLE_NAME LAST_ANALYZED NUM_ROWS
------------------------------ ------------- ----------

ITPub博客

ORACLE 11g新特性-统计值挂起

最新文章