PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center