Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250830081717\orcl_m000_12820_bucket.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Windows NT Version V6.2 CPU : 32 - type 8664, 16 Physical Cores Process Affinity : 0x0x0000000000000000 Memory (Avail/Total): Ph:35105M/63366M, Ph+PgF:40065M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 12820, image: ORACLE.EXE (M000) *** 2025-08-30 08:17:17.182 *** SESSION ID:(193.63959) 2025-08-30 08:17:17.182 *** 2025-08-30 08:17:17.182 Process diagnostic dump for ORACLE.EXE (M000), OS id=12820, pid: 24, proc_ser: 10, sid: 193, sess_ser: 63959 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.569191 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.569217 sec since last wait 0: waited for 'RMAN backup & recovery I/O' count=0x1, intr=0x0, timeout=0xffffffff wait_id=329 seq_num=330 snap_id=1 wait times: snap=0.000065 sec, exc=0.000065 sec, total=0.000065 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000007 sec of elapsed time 1: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x2, filetype=0x2 wait_id=328 seq_num=329 snap_id=1 wait times: snap=0.000119 sec, exc=0.000119 sec, total=0.000119 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 2: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x2, filetype=0x2 wait_id=327 seq_num=328 snap_id=1 wait times: snap=0.000209 sec, exc=0.000209 sec, total=0.000209 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.035640 sec of elapsed time 3: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=326 seq_num=327 snap_id=1 wait times: snap=0.000050 sec, exc=0.000050 sec, total=0.000050 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000001 sec of elapsed time 4: waited for 'log file sequential read' log#=0x2a20, block#=0x0, blocks=0x0 wait_id=325 seq_num=326 snap_id=1 wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 5: waited for 'log file sequential read' log#=0x2a20, block#=0x0, blocks=0x0 wait_id=324 seq_num=325 snap_id=1 wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000006 sec of elapsed time 6: waited for 'log file sequential read' log#=0x0, block#=0x2, blocks=0x7fe wait_id=323 seq_num=324 snap_id=1 wait times: snap=0.000270 sec, exc=0.000270 sec, total=0.000270 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 7: waited for 'log file sequential read' log#=0x2a20, block#=0x2, blocks=0x7fe wait_id=322 seq_num=323 snap_id=1 wait times: snap=0.000200 sec, exc=0.000200 sec, total=0.000200 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000142 sec of elapsed time 8: waited for 'log file sequential read' log#=0x0, block#=0x1, blocks=0x1 wait_id=321 seq_num=322 snap_id=1 wait times: snap=0.000044 sec, exc=0.000044 sec, total=0.000044 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time 9: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x0, filetype=0x3 wait_id=320 seq_num=321 snap_id=1 wait times: snap=0.000204 sec, exc=0.000204 sec, total=0.000204 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000128 sec of elapsed time Sampled Session History of session 193 serial 63959 --------------------------------------------------- The sampled session history is constructed by sampling the target session every 1 second. The sampling process captures at each sample if the session is in a non-idle wait, an idle wait, or not in a wait. If the session is in a non-idle wait then one interval is shown for all the samples the session was in the same non-idle wait. If the session is in an idle wait or not in a wait for consecutive samples then one interval is shown for all the consecutive samples. Though we display these consecutive samples in a single interval the session may NOT be continuously idle or not in a wait (the sampling process does not know). The history is displayed in reverse chronological order. sample interval: 1 sec, max history 120 sec --------------------------------------------------- [6 samples, 08:17:11 - 08:17:16] not in wait at each sample [1 sample, 08:17:10] idle wait at each sample [session created at: 08:17:10] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-30 08:17:17.182 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 12820, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-30 08:17:11.438394 :C6914661:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.447408 :C6914669:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 8, nex 10 2025-08-30 08:17:11.447416 :C691466A:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0080feb8 where: kddwh01: kdddel 2025-08-30 08:17:11.480822 :C691466B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.522427 :C6914673:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.522456 :C6914676:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.533130 :C6914688:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 9, nex 11 2025-08-30 08:17:11.533138 :C6914689:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00815485 where: kddwh01: kdddel 2025-08-30 08:17:11.565579 :C691468A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.565611 :C691468D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.607948 :C6914699:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.619257 :C69146A1:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 10, nex 12 2025-08-30 08:17:11.619265 :C69146A2:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00813423 where: kddwh01: kdddel 2025-08-30 08:17:11.650747 :C69146A3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.693339 :C69146D3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.706240 :C69146DB:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 11, nex 13 2025-08-30 08:17:11.706248 :C69146DC:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008021b8 where: kdiwh22: kdifind 2025-08-30 08:17:11.736383 :C69146DD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.778678 :C69146E5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.792071 :C69146ED:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 12, nex 14 2025-08-30 08:17:11.792079 :C69146EE:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00811e64 where: kddwh01: kdddel 2025-08-30 08:17:11.821808 :C69146EF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.864730 :C69146F7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.878744 :C69146FF:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 13, nex 15 2025-08-30 08:17:11.878753 :C6914700:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00825f11 where: kddwh01: kdddel 2025-08-30 08:17:11.892543*:C6914701:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D95128 estart=1756513030 eid=16777369 ctx=0x00000007738B9F78 cwh=0x00000000232801B0 cpu=609375 buffg=116297 interb=0 r=0 rb=0 w=0 wb=0 2025-08-30 08:17:11.892543*:C6914702:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024D95128 curCtx=0x0000000023282158 pubTabIdxCnt=0 2025-08-30 08:17:11.892543*:C6914703:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024D95128 2025-08-30 08:17:11.892543*:C6914704:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024D95128 2025-08-30 08:17:11.907748 :C6914705:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.950404 :C691470D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.950433 :C6914710:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:11.964776 :C6914722:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 14, nex 16 2025-08-30 08:17:11.964784 :C6914723:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00825f24 where: kddwh01: kdddel 2025-08-30 08:17:11.993728 :C6914724:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.036119 :C691472C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.050605 :C6914734:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 15, nex 17 2025-08-30 08:17:12.050613 :C6914735:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00825f37 where: kddwh01: kdddel 2025-08-30 08:17:12.079272 :C6914736:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.121976 :C691473E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.137054 :C6914746:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 16, nex 18 2025-08-30 08:17:12.137062 :C6914747:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00825f4a where: kddwh01: kdddel 2025-08-30 08:17:12.165289 :C6914748:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.207862 :C6914750:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.207892 :C6914753:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.208375 :C691475C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.223339 :C6914769:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 17, nex 19 2025-08-30 08:17:12.223348 :C691476A:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00825f5e where: kddwh01: kdddel 2025-08-30 08:17:12.251079 :C691476B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.293664 :C6914773:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.309623 :C6914787:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 18, nex 20 2025-08-30 08:17:12.309632 :C6914788:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00825f71 where: kddwh01: kdddel 2025-08-30 08:17:12.336860 :C6914789:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.336892 :C691478C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.354055 :C6914793:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.355304 :C6914799:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-30 08:17:12.355320 :C691479A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.356965 :C691479D:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-30 08:17:12.357394 :C69147BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.357811 :C69147C7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.399472 :C69147D9:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 19, nex 21 2025-08-30 08:17:12.399481 :C69147DA:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864b86 where: kddwh01: kdddel 2025-08-30 08:17:12.401184 :C69147DB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.444224 :C69147E3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.486228 :C69147EB:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 20, nex 22 2025-08-30 08:17:12.486236 :C69147EC:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864b99 where: kddwh01: kdddel 2025-08-30 08:17:12.487454 :C69147ED:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.531417 :C69147F5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.575944 :C69147FD:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 21, nex 23 2025-08-30 08:17:12.575954 :C69147FE:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864bac where: kddwh01: kdddel 2025-08-30 08:17:12.576716 :C69147FF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.621874 :C6914807:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.621905 :C691480A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.666459 :C691481C:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 22, nex 24 2025-08-30 08:17:12.666468 :C691481D:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864bbf where: kddwh01: kdddel 2025-08-30 08:17:12.667182 :C691481E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.781117 :C6914846:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 23, nex 25 2025-08-30 08:17:12.781132 :C6914847:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864bd3 where: kddwh01: kdddel 2025-08-30 08:17:12.789063 :C6914848:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.849007 :C6914850:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.891049 :C6914858:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 24, nex 26 2025-08-30 08:17:12.891057 :C6914859:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864be6 where: kddwh01: kdddel 2025-08-30 08:17:12.896421 :C691485A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.896453 :C691485D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.939145 :C6914864:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.977586 :C6914898:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 25, nex 27 2025-08-30 08:17:12.977595 :C6914899:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864bf9 where: kddwh01: kdddel 2025-08-30 08:17:12.982670 :C691489A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:12.982701 :C691489D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.026611 :C69148AF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.065011 :C69148C9:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 26, nex 28 2025-08-30 08:17:13.065019 :C69148CA:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087fa8e where: kddwh01: kdddel 2025-08-30 08:17:13.069980 :C69148CB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.112790 :C69148D3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.151473 :C69148DB:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 27, nex 29 2025-08-30 08:17:13.151481 :C69148DC:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087faa1 where: kddwh01: kdddel 2025-08-30 08:17:13.155933 :C69148DD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.198843 :C69148F8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.198873 :C69148FB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.238121 :C691490D:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 28, nex 30 2025-08-30 08:17:13.238129 :C691490E:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a3909 where: kdiwh22: kdifind 2025-08-30 08:17:13.242635 :C691490F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.285479 :C6914917:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.324780 :C691492B:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 29, nex 31 2025-08-30 08:17:13.324788 :C691492C:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087fac7 where: kddwh01: kdddel 2025-08-30 08:17:13.328592 :C691492D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.371507 :C6914935:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.411221 :C691493D:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 30, nex 32 2025-08-30 08:17:13.411230 :C691493E:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087fadb where: kddwh01: kdddel 2025-08-30 08:17:13.414668 :C691493F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.457747 :C691496A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.457774 :C691496D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.458269 :C6914974:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.497985 :C691497B:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 31, nex 33 2025-08-30 08:17:13.497993 :C691497C:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087faee where: kddwh01: kdddel 2025-08-30 08:17:13.501575 :C691497D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.544335 :C6914985:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.584510 :C691498D:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 32, nex 34 2025-08-30 08:17:13.584519 :C691498E:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a2783 where: kddwh01: kdddel 2025-08-30 08:17:13.587664 :C691498F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.587693 :C6914992:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.630878 :C69149A4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.671093 :C69149AC:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 33, nex 35 2025-08-30 08:17:13.671103 :C69149AD:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a2796 where: kddwh01: kdddel 2025-08-30 08:17:13.673989 :C69149C6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.718378 :C69149CE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.763199 :C69149D6:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 34, nex 36 2025-08-30 08:17:13.763208 :C69149D7:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a27a9 where: kddwh01: kdddel 2025-08-30 08:17:13.765884 :C69149D8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.812542 :C69149E0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.857583 :C69149E8:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 35, nex 37 2025-08-30 08:17:13.857593 :C69149E9:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a27bc where: kddwh01: kdddel 2025-08-30 08:17:13.859420 :C69149EA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.892414*:C69149F2:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D95128 estart=1756513030 eid=16777369 ctx=0x00000007738B9F78 cwh=0x00000000232801B0 cpu=2000000 buffg=368345 interb=0 r=0 rb=0 w=0 wb=0 2025-08-30 08:17:13.892414*:C69149F3:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024D95128 2025-08-30 08:17:13.904260 :C69149F4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.946269 :C69149FC:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 36, nex 38 2025-08-30 08:17:13.946277 :C69149FD:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008c0022 where: kdiwh22: kdifind 2025-08-30 08:17:13.947525 :C69149FE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.990415 :C6914A11:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:13.990446 :C6914A14:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:14.032858 :C6914A26:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 37, nex 39 2025-08-30 08:17:14.032866 :C6914A27:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a27e3 where: kddwh01: kdddel 2025-08-30 08:17:14.034064 :C6914A28:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:14.076376 :C6914A30:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:14.118226 :C6914A38:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 38, nex 40 2025-08-30 08:17:14.118233 :C6914A39:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a27f6 where: kddwh01: kdddel 2025-08-30 08:17:14.119155 :C6914A3A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:14.119186 :C6914A3D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:14.165670 :C6914A4F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:14.211254 :C6914A5F:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 10, ext 39, nex 41 2025-08-30 08:17:14.211263 :C6914A60:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008c12db where: kddwh01: kdddel 2025-08-30 08:17:14.212310 :C6914A61:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:14.236179*:C6914A69:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024D95128 curCtx=0x0000000023282158 xsc->flg4=65792 flags=2 2025-08-30 08:17:14.236179*:C6914A6A:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024D95128 2025-08-30 08:17:14.258450 :C6914A6B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:14.258488 :C6914A6E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-30 08:17:14.306469 :C6914A81:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=16 loc='ksr2.h LINE:603 ID:ksrpublish' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.621930*:C691502B:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024D9A048 curCtx=0x0000000023282170 xsc->flg4=65792 flags=4 2025-08-30 08:17:16.621930*:C691502C:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024D9A048 2025-08-30 08:17:16.623052 :C691502D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.663840 :C6915049:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.663866 :C691504C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.664328 :C6915053:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.706627 :C6915073:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.749012 :C691507B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.768940 :C6915129:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.769039 :C691512C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.769365 :C6915133:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.820506 :C69152D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.820539 :C69152D5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.863783 :C69152E7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.906290 :C69152EF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.906315 :C69152F2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.949411 :C6915304:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:16.991915 :C691530C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:17.034587 :C691531F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:17.076855 :C6915327:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:17.119170 :C691533F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-30 08:17:17.162057 :C6915358:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 24 (osid: 12820, M000)