SQL Performance (MOSC)

MOSC Banner

ORA-06512 - When trying to end gathering of system stats

edited Jul 2, 2016 5:01AM in SQL Performance (MOSC) 5 commentsAnswered

Hi

We have a 11.2.0.4 database

we started collecting system stats on it few hours ago --> EXEC DBMS_STATS.gather_system_stats('start');

Now when we try to end this, we are getting this error

SQL> show user

USER is "SYS"

SQL> exec DBMS_STATS.GATHER_SYSTEM_STATS('stop');

BEGIN DBMS_STATS.GATHER_SYSTEM_STATS('stop'); END;

*

ERROR at line 1:

ORA-01426: numeric overflow

ORA-06512: at "SYS.DBMS_STATS", line 27727

ORA-06512: at line 1

Can someone please let us know as to what could be wrong here and IF the system stats are still being computed in the database since after starting it we are unable to stop it?

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