oradbakar
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment