SAP Knowledge Base Article - Preview

3288669 - Dictionary statistics update fails with ORA-03113

Symptom

Oracle dictionary statistics update hang and failed with error ORA-03113:

BR0301E SQL error -3113 at location stats_oradict_collect-5, SQL statement:
'BEGIN DBMS_STATS.GATHER_FIXED_OBJECTS_STATS (NO_INVALIDATE => FALSE); END;'
ORA-03113: end-of-file on communication channel
Process ID: 66060734
Session ID: 786 Serial number: 30528
BR1313E Collection of Oracle dictionary statistics failed
BR0280I BRCONNECT time stamp: 2023-01-07 15:56:27
BR0301E SQL error -3114 at location stats_system_collect-1, SQL statement:
'SELECT LINE FROM SAP_SDBAD WHERE BEG = '00000000000002' AND FUNCT = 'STD' AND POS = '0000''
ORA-03114: not connected to ORACLE
BR0994E Collection of system statistics failed

alert log shows error ORA-07445:

ORA-07445: exception encountered: core dump [ktfs_imcf_getnext_bm()+128] [SIGSEGV] [ADDR:0x80B38F0000004051] [PC:0x108F9C760] [Address not mapped to object] []


Read more...

Environment

Oracle on SAP

Product

SAP NetWeaver all versions

Keywords

DBMS_STATS, dictionary statistics,GATHER_FIXED_OBJECTS_STATS ,SYSAUX, ORA-07445,ktfs_imcf_getnext_bm , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.