Hi All
May I know what is best interval to exec dbms_stats.gather_schema_stats on a
instance with 300 tables that updated everyday.
By the way, Anybody has any detailed command reference for dbms_stats. I am
not sure for the following such as degree?
execute dbms_stats.gather_schema_stats
recipients of list ORACLE-L
Hi All
May I know what is best interval to exec dbms_stats.gather_schema_stats on a
instance with 300 tables that updated everyday.
By the way, Anybody has any detailed command reference for dbms_stats. I am
not sure for the following such as degree?
execute
, 2003 4:10 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: dbms_stats.gather_schema_stats
Hi All
May I know what is best interval to exec
dbms_stats.gather_schema_stats on a
instance with 300 tables that updated everyday.
By the way, Anybody has any detailed command reference
owned by DBADMIN), in the
sys.dba_tab_modifications is not decreasing:
execute dbms_stats.gather_schema_stats ('DBADMIN',
NULL, FALSE, 'FOR ALL COLUMNS SIZE 1', NULL,
'DEFAULT', TRUE, NULL, NULL, 'GATHER STALE',
'LIST');
Here is a sample output from the
sys.dba_tab_modifications table
the following script nightly, the number of tables (all owned by DBADMIN), in the sys.dba_tab_modifications is not decreasing:
execute dbms_stats.gather_schema_stats ('DBADMIN', NULL, FALSE, 'FOR ALL COLUMNS SIZE 1', NULL, 'DEFAULT', TRUE, NULL, NULL, 'GATHER STALE', 'LIST');
Here is a sample output from
