pscbo_stats question regarding error message in pscbo_log
We are upgrading HR Peoplesoft to 9.1 PT 8.54. We had pscbo_stats v1, in the database originally from the earlier HR Peoplesoft 9.0 database.
We ran the new v3 pscbo.sql. When we run the pscbo stats command to generate stats ( exec pscbo_stats.gather_schema_stats ) we get error message in the pscbo_log:
The error is: Please execute: EXEC DBMS_AUTO_TASK_ADMIN.DISABLE('auto optimizer stats collection', NULL, NULL);'
I do not see the above command in the documentation!
We have done the following step in the implementation guide:
SET SERVEROUT ON TRIMS ON LINES 1000;
SPO pscbo_stats-alter_autostats.log