Database Administration (MOSC)

MOSC Banner

unable to run gather statistics in our database

edited Dec 28, 2009 8:50PM in Database Administration (MOSC) 2 commentsAnswered
Dear All,
Im  getting below error msg as while i running dbms_stats package.

SQL> EXEC DBMS_STATS.gather_database_stats;
BEGIN DBMS_STATS.gather_database_stats; END;

*
ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified
ORA-06512: at "SYS.DBMS_STATS", line 13591
ORA-06512: at "SYS.DBMS_STATS", line 13937
ORA-06512: at "SYS.DBMS_STATS", line 14081
ORA-06512: at "SYS.DBMS_STATS", line 14045
ORA-06512: at line 1

Pls help me.

Thanks,

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