Saturday, September 18, 2010

How to gather stats for schema?

ALTER SESSION SET SORT_AREA_SIZE = 2107152000;

ALTER SESSION SET db_file_multiblock_read_count = 256;

execute SYS.DBMS_STATS.GATHER_SCHEMA_STATS (OWNNAME=>'SCOTT', CASCADE=>TRUE);

No comments:

Post a Comment