📋Steps in this guide1/1

Enable incremental stats collection

-- Check the status of incremental pref

oracle configurationintermediate

by OracleDba

13 views

Enable incremental stats collection

-- Check the status of incremental pref -- Enable incremental stats collection -- Check the pref again:

Code/Command (click line numbers to comment):

select dbms_stats.get_prefs('INCREMENTAL', tabname=>'EMPLOYEE',ownname=>'SCOTT') from dual;
FALSE
SQL> exec DBMS_STATS.SET_TABLE_PREFS('SCOTT','EMPLOYEE','INCREMENTAL','TRUE');
PL/SQL procedure successfully completed.
select dbms_stats.get_prefs('INCREMENTAL', tabname=>'EMPLOYEE',ownname=>'SCOTT') from dual;
TRUE

Comments (0)

Please to add comments

No comments yet. Be the first to comment!