dbms_stats.gather_schema_stats - via scheduler
I have RAC database and we run a automated dbms_stats.gather_schema_stats job that runs every night via job scheduler.
We are planning to move one of our NON RAC database into RAC as an additional SCHEMA to the RAC DB.
This new schema has different requirement. We gather stats on temporary, stage and recent partitions table during production data load. Also, in this load, we make some indexes unusable to be ready for next day's load.
We don't want to gather stats on some of these new schema' tables during nightly dbms_stats.gather_schema_stats that runs via job scheduler because it affect our data load and reports performance negatively and will complaint about unusable indexes.
We are planning to move one of our NON RAC database into RAC as an additional SCHEMA to the RAC DB.
This new schema has different requirement. We gather stats on temporary, stage and recent partitions table during production data load. Also, in this load, we make some indexes unusable to be ready for next day's load.
We don't want to gather stats on some of these new schema' tables during nightly dbms_stats.gather_schema_stats that runs via job scheduler because it affect our data load and reports performance negatively and will complaint about unusable indexes.
0