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.
SAP Knowledge Base Article - Preview