Performance Tuning Guidelines for Siebel CRM Application on Oracle Database (Doc ID 2077227.2)
I would like to implement the new statistics on Siebel database Oracle v12.1.0.2 with coe_siebel_stats.sql .
Just to be clear I need to:
1- delete statistics on SIEBEL schema;
2- take BASELINE statistics with script coe_siebel_stats.sql;
3- Implement daily run of NORMAL statistics with script coe_siebel_stats.sql
Is it possibile to run faster the point 2 take BASELINE statistics with script coe_siebel_stats.sql (in parallel or something other?) because in my environment this job take about 40 hours, it's too time for a switch off of SIEBEL.
regards,
Mario