Help needed in customizing the dbms_stats for a large data warehouse
Hi All,
I need some help on implementing a custom approach for taking the stats. THe reason is due to ETL jobs and some which need the updated stats from other tables while running.
I have decided to put in place a custorm job that does Oracle owned objects daily and for all user objects do it during/after the ETL is completed.
My doubts are:
1. To set the Oracle only stats:
I do not need to disable the presently running SYS.GATHER_STATS_JOB. I just need to execute the following from sql-plus(once only)
exec dbms_stats.set_param('autostats_target','oracle');--THis to enable the job for only Oracle owned.
I need some help on implementing a custom approach for taking the stats. THe reason is due to ETL jobs and some which need the updated stats from other tables while running.
I have decided to put in place a custorm job that does Oracle owned objects daily and for all user objects do it during/after the ETL is completed.
My doubts are:
1. To set the Oracle only stats:
I do not need to disable the presently running SYS.GATHER_STATS_JOB. I just need to execute the following from sql-plus(once only)
exec dbms_stats.set_param('autostats_target','oracle');--THis to enable the job for only Oracle owned.
0