DBMS_STATS options
Howdy all you politically correct boys and girls;
Is there any way to run dbms_stats at the schema level and omit a few HUGE partitioned tables.
What we have now is a script that analyzes all of the tables for this schema, this works fine BUT.. we are adding another 40 or so tables to this schema and now have to keep updating this script.
Essentially we would like to avoid this and just have the flexability to analyze the monster tables at other times.
I do not see any options online, a simple WHERE clause would work if it existed.
HP/UX 11
Oracle 9.2.0.6
I remember when this place was cool.
Reply With Quote