📋Steps in this guide1/1

Gather stats for schema

Begin dbms_stats.gather_schema_stats( ownname => 'SCOTT', --- schema name options => 'GATHER AUTO', estimate_percent => dbms_stats.auto_sample_size, method_opt => 'for all columns size repeat', degree => 24 ); END; /

oracle configurationintermediate

by OracleDba

15 views

Gather stats for schema

Code/Command (click line numbers to comment):

Begin
dbms_stats.gather_schema_stats(
ownname => 'SCOTT', --- schema name
options => 'GATHER AUTO',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all columns size repeat',
degree => 24
);
END;
/

Comments (0)

Please to add comments

No comments yet. Be the first to comment!