DBA Hub

📋Steps in this guide1/1

Get statistics preference setting

Setting Publish preference

oracle configurationintermediate
by OracleDba
13 views
1

Get statistics preference setting

Setting Publish preference Check the publish preference status --- FOR INDEX

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
exec dbms_stats.set_table_prefs('SCOTT','EMP','PUBLISH','FALSE');
select dbms_stats.get_prefs('PUBLISH', 'SCOTT','EMP') FROM DUAL;
Similarly for schema also use as below:
select dbms_stats.get_prefs('PUBLISH', 'SCOTT') from dual
exec dbms_stats.SET_SCHEMA_PREFS('DBATEST','PUBLISH','FALSE');
SET_INDEX_STATS
GET_INDEX_STATS
-- FOR DATABASE
SET_DATABASE_PREFS

Comments (0)

Please to add comments

No comments yet. Be the first to comment!