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
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.