CA PT Upgrade job - DB Stats are locked error
We are in mid of CA Peopletools only upgrade job - this partiucular step is executing the ptupdtabstats sql script as part of upgrade in FSCM 9.2 DB environment., while execution we have got below error on stats statement, can we unlock stats or any ideas on this please?
It looks like object stats are locked, I am not sure on STATS details.
15:39:23 SQL> execute DBMS_STATS.GATHER_TABLE_STATS('SYSADM','PS_AP_ARC_DIST_L_H', estimate_percent=> dbms_stats.auto_sample_size, method_opt=> 'FOR ALL INDEXED COLUMNS SIZE 1', DEGREE=> DBMS_STATS.DEFAULT_DEGREE, cascade=>TRUE);
BEGIN DBMS_STATS.GATHER_TABLE_STATS('SYSADM','PS_AP_ARC_DIST_L_H', estimate_percent=> dbms_stats.auto_sample_size, method_opt=> 'FOR ALL INDEXED COLUMNS SIZE 1', DEGREE=> DBMS_STATS.DEFAULT_DEGREE, cascade=>TRUE); END;