trace[Result_Cache] disk = highest

cmd.sql

alter session set events 'trace[Result_Cache] disk = highest';

trc.trc

Trace file /opt/oracle/diag/rdbms/ora19/ORA19/trace/ORA19_ora_25551_rc_20220123.12.38.15.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.11.0.0.0
Build label:    RDBMS_19.11.0.0.0DBRU_LINUX.X64_210412
ORACLE_HOME:    /opt/oracle/product/19c/dbhome_1
System name:    Linux
Node name:      4ce98707bd2b
Release:        3.10.0-1160.25.1.el7.x86_64
Version:        #1 SMP Wed Apr 28 21:49:45 UTC 2021
Machine:        x86_64
Instance name: ORA19
Redo thread mounted by this instance: 1
Oracle process number: 71
Unix process pid: 25551, image: oracle@4ce98707bd2b


*** 2022-01-23T12:38:15.951313+00:00 (PDB1(3))
*** SESSION ID:(868.45712) 2022-01-23T12:38:15.951388+00:00
*** CLIENT ID:() 2022-01-23T12:38:15.951402+00:00
*** SERVICE NAME:(pdb1) 2022-01-23T12:38:15.951413+00:00
*** MODULE NAME:(SQL*Plus) 2022-01-23T12:38:15.951426+00:00
*** ACTION NAME:() 2022-01-23T12:38:15.951438+00:00
*** CLIENT DRIVER:(SQL*PLUS) 2022-01-23T12:38:15.951449+00:00
*** CONTAINER ID:(3) 2022-01-23T12:38:15.951462+00:00


*** TRACE CONTINUED FROM FILE /opt/oracle/diag/rdbms/ora19/ORA19/trace/ORA19_ora_25551_END.trc ***


Found object number: (78347)2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@4470:qesrcCM_PreCmt_():
Pruning using bloom filter...

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@4486:qesrcCM_PreCmt_(): Object number (78347) has been pruned
2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@540:qesrc_ksqget_():
Enqueue gotten from qesrc.c@4295:qesrcTol_Lck()
type: (RC) operation: (GET) rval: (0x96a08510) parent: (transaction)
mode: (S) timeout: (5) scope: (Global) id1: (2) id2: (78347)

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@4535:qesrcCM_PreCmt_():
Invalidating DO's in the local cache

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@425:qesrc_kslgetsl_():
Latch gotten from qesrc.c@4540:qesrcCM_PreCmt_()
latch: (qesrcLca) operation: (GET) mode: (S)
type: (CAS(S)) succ: (Yes)

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@5523:qesrcDO_Invalidate():
Attempted to invalidate obn: (78347) with DO pointer: (0x138f3814)

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@499:qesrc_kslconx_():
Latch converted from qesrc.c@5536:qesrcDO_Invalidate()
latch: (qesrcLca) operation: (CONX) type: (CAS(S)) succ: (Yes)

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@757:qesrcEvent_qesrcRO_Invalidate_():
RO Invalidate from qesrc.c@5585:qesrcDO_Invalidate()
scn: (26800040) id1: (ddhd58sbdg4tq4arak4fxamag8)
id2: (cx4awgpsfxy8wbn1m64w2buk12) pdbid: (3)

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@784:qesrcEvent_qesrcDO_Invalidate_():
DO Invalidate from qesrc.c@4551:qesrcCM_PreCmt_()
remove dep: (TRUE) modeP: (X) scn: (26800099) obn: (78347) pdbid: (3)

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@475:qesrc_kslfre_():
Latch freed from qesrc.c@4561:qesrcCM_PreCmt_()
latch: (qesrcLca) operation: (FREE) type: (CAS(S))

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@4564:qesrcCM_PreCmt_():
Finished invalidating DO's in the local cache

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@425:qesrc_kslgetsl_():
Latch gotten from qesrc.c@4632:qesrcCM_PstCmt_()
latch: (qesrcLca) operation: (GET) mode: (S)
type: (CAS(S)) succ: (Yes)

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@5523:qesrcDO_Invalidate():
Attempted to invalidate obn: (78347) with DO pointer: (0x138f3990)

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@784:qesrcEvent_qesrcDO_Invalidate_():
DO Invalidate from qesrc.c@4641:qesrcCM_PstCmt_()
remove dep: (FALSE) modeP: (S) scn: (26800102) obn: (78347) pdbid: (3)

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@475:qesrc_kslfre_():
Latch freed from qesrc.c@4650:qesrcCM_PstCmt_()
latch: (qesrcLca) operation: (FREE) type: (CAS(S))

2022-01-23 12:38:15.951*:Result_Cache:qesrc.c@569:qesrc_ksqrls_():
Enqueue released from qesrc.c@4359:qesrcTol_Rls()
type: (RC) operation: (RLS) enq: (0x96a08510) parent: (transaction)
mode: (S) id1: (2) id2: (78347)