dbms_stats.gather_system_stats errors to stop

Over the weekend I upgraded two databases to 11.2.0.3, Upgrade was successful.

I ran dbms_stats.gather_system_stats to gather system statistics on both the database.
After two days I wanted to stop it.


On one database it errors

oracle@proddb[PRD1]$ sy

SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 11 07:50:01 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> execute 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 27218
ORA-06512: at line 1


SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
oracle@proddb[PRD1]$


On the other database it went fine and stopped
oracle@proddb[OWB]$ sy

SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 11 07:50:29 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options

SQL> execute dbms_stats.gather_system_stats('stop');

PL/SQL procedure successfully completed.

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
oracle@proddb[OWB]$






A lot of analysis was done with Oracle Support but in the end I found a simple workaround start and stop again worked;



SQL> execute dbms_stats.gather_system_stats('start');

PL/SQL procedure successfully completed.

SQL> execute dbms_stats.gather_system_stats('stop');

PL/SQL procedure successfully completed.

SQL>


Oracle Support has filed a defect for this tool.

Exalytic vs Hana the big fight starts

It all started with the latest presentation that Oracle made on Exalytic and these two slides are responsible for it.

Post presentation the discussion started on the internet.

http://www.pcworld.com/businesscenter/article/254779/saps_sikka_fires_back_against_oracles_falsehoods_about_hana.html


It is good to see how Oracle and SAP are moving ahead.

SAP has a free trail platform that runs on HANA , take a look at it https://bi.ondemand.com , there are lots of limitation and also some performance issues but not sure that it is from Business Object or the underlying HANA database.

Oracle is yet to open the cloud platform which is said to run on Exadata and Exalogic , not sure if Exalytic is an offering in their cloud.