My Oracle Support Banner

MMON Slave's "Auto-Flush Slave Action" Task Encounters ORA-07445 [ktsla_ins_chunk_main()+22] (Doc ID 2973709.1)

Last updated on OCTOBER 09, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.18.0.0.0 and later
Information in this document applies to any platform.

Symptoms

MMON Slave process acts "Auto-Flush Slave Action", ORA-07445 [ktsla_ins_chunk_main()+22] error occurs.

*** SERVICE NAME:(SYS$BACKGROUND) 2023-09-07T16:00:05.595852+08:00
*** MODULE NAME:(MMON_SLAVE) 2023-09-07T16:00:05.595857+08:00
*** ACTION NAME:(Auto-Flush Slave Action) 2023-09-07T16:00:05.595862+08:00
*** CLIENT DRIVER:(SERVER) 2023-09-07T16:00:05.595867+08:00
*** CONTAINER ID:(1) 2023-09-07T16:00:05.595872+08:00

[TOC00001]
ORA-07445: exception encountered: core dump [ktsla_ins_chunk_main()+22] [SIGSEGV] [ADDR:0x7FFE82AC89B0] [PC:0x22810B6] [Address not mapped to object] []
[TOC00001-END]

[TOC00004]
----- Current SQL Statement for this session (sql_id=batfd9dwfcb0g) -----
INSERT INTO  wrh$_sqltext    (sql_id, dbid, sql_text,     command_type, snap_id, con_dbid, per_pdb)  SELECT    sqlid_kewrstx, :dbid, sqlfulltext_kewrstx,    cmdtype_kewrstx, :lah_snap_id, con_dbid_kewrstx, con_id  FROM x$kewrtsqltext   sqltxt  WHERE  (1 = 1)  AND ( sqltxt.con_id < 4099  )
[TOC00004-END]

[06]: ktsla_ins_chunk_main [Space]<-- Signaling
[07]: ktsla_split_ins_chunk [Space]
[08]: ktsla_split_chunk [Space]
[09]: ktsla_split_chunk_main [Space]
[10]: ktsla_fsb_best_fit_gsp [Space]
[11]: ktsla_fsb_gsp [Space]
[12]: ktsla_hbb_gsp [Space]
[13]: ktsla_hbb_gsp_main [Space]
[14]: ktsla_gsp_split [Space]
[15]: ktsla_cfsgsp_main [Space]
[16]: ktslagsp [Space]
[17]: ktsla_alloc_fsgr [Space]
[18]: ktsla_alloc_fsg [Space]
[19]: ktsla_ins_chunk [Space]
[20]: ktsla_ins_chunk_main [Space]
[21]: ktsl_pua_cfs_disp [Space]
[22]: ktsl_fill_dispenser_main_1 [Space]
[23]: ktsl_fill_dispenser_main [Space]
[24]: ktsl_dispenser_bkg_actions [Space]
[25]: ktsl_disp_gsp_driver_int [Space]
[26]: ktslagsp [Space]
[27]: ktslagsp_main [Space]
[28]: kdliAllocCache [LOB_INODE]
[29]: kdliAllocBlocks [LOB_INODE]
[30]: kdliAllocChunks [LOB_INODE]
[31]: kdliWriteInit [LOB_INODE]
[32]: kdliWriteV [LOB_INODE]
[33]: kdli_fwritev [LOB_INODE]
[34]: kdlxNXWrite [LOB_KDLX]
[35]: kdlx_write [LOB_KDLX]
[36]: kdlxdup_write1 [LOB_KDLXDUP]
[37]: kdlwWriteCallbackOld_pga [LOB_KDLW]
[38]: kdlw_write [LOB_KDLW]
[39]: kdld_write [Data]
[40]: kdla_write [LOB_KDLA]
[41]: kdlf_write [Data]
[42]: kdlfCopyBF2SF [Data]
[43]: kdlf_copy [Data]
[44]: koklCopyInt [LOB_Default]
[45]: kokliclo [LOB_Default]
[46]: koklcre [LOB_API]
[47]: kokleva [LOB_API]
[48]: evaopn2 []
[49]: qesltcEvalOutofLineCols [SQL_Execution]

Instance restart doesn't work, patch 33901904 doesn't help as well.

Changes

Applied 19.18 DBRU.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.