SQL Performance (MOSC)

MOSC Banner

Where to get the lock state of table's statistics ?

edited Jul 6, 2016 10:17AM in SQL Performance (MOSC) 4 commentsAnswered ✓


SQL> BEGIN dbms_stats.gather_table_stats(ownname=>'AD',tabname=>'CA_BILL_BUSI_REC_201212',estimate_percent=>10); END;

*
ERROR at line 1:
ORA-20005: object statistics are locked (stattype = ALL)
ORA-06512: at "SYS.DBMS_STATS", line 23829
ORA-06512: at "SYS.DBMS_STATS", line 23880
ORA-06512: at line 1

Later i use force=>true to make it work

Which dictionary tables save the information whether table's statistics being locked or not ?

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