ORA-06512 - When trying to end gathering of system stats
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?