Problem with dbms_stats.gather_schema_stats execution.
Posted on 2015-01-22
I have a job running for more than 2 weeks and it does not finish. It is the first time i run it in our production database.
It was created with the sys user and the database size is 2TB.
When it runs in the QA and Dev databases it takes like 4 days. QA and DEV are 1.6 TB, they do not have updated production data.
A) is there something wrong with my commands ?
B) is there a way split it to specific tables or to make it run faster ?
dbms_stats.gather_schema_stats(OWNNAME=>'APP_USER_SCHEMA',estimate_percent=>100,method_opt=>'FOR ALL COLUMNS SIZE AUTO',cascade=>TRUE,degree=>DBMS_STATS.AUTO_DEGREE);