Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250506082202\orcl_m000_10372_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:37457M/63366M, Ph+PgF:44933M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 10372, image: ORACLE.EXE (M000) *** 2025-05-06 08:22:02.309 *** SESSION ID:(209.43933) 2025-05-06 08:22:02.309 *** 2025-05-06 08:22:02.309 Process diagnostic dump for ORACLE.EXE (M000), OS id=10372, pid: 26, proc_ser: 94, sid: 209, sess_ser: 43933 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.191975 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.192000 sec since last wait 0: waited for 'RMAN backup & recovery I/O' count=0x1, intr=0x0, timeout=0xffffffff wait_id=310 seq_num=311 snap_id=1 wait times: snap=0.000064 sec, exc=0.000064 sec, total=0.000064 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=309 seq_num=310 snap_id=1 wait times: snap=0.000120 sec, exc=0.000120 sec, total=0.000120 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time 2: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x2, filetype=0x2 wait_id=308 seq_num=309 snap_id=1 wait times: snap=0.000236 sec, exc=0.000236 sec, total=0.000236 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.033328 sec of elapsed time 3: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=307 seq_num=308 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.000001 sec of elapsed time 4: waited for 'log file sequential read' log#=0x277c, block#=0x0, blocks=0x0 wait_id=306 seq_num=307 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#=0x277c, block#=0x0, blocks=0x0 wait_id=305 seq_num=306 snap_id=1 wait times: snap=0.000002 sec, exc=0.000002 sec, total=0.000002 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000008 sec of elapsed time 6: waited for 'log file sequential read' log#=0x0, block#=0x2, blocks=0x7fe wait_id=304 seq_num=305 snap_id=1 wait times: snap=0.000274 sec, exc=0.000274 sec, total=0.000274 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time 7: waited for 'log file sequential read' log#=0x277c, block#=0x2, blocks=0x7fe wait_id=303 seq_num=304 snap_id=1 wait times: snap=0.000188 sec, exc=0.000188 sec, total=0.000188 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000153 sec of elapsed time 8: waited for 'log file sequential read' log#=0x0, block#=0x1, blocks=0x1 wait_id=302 seq_num=303 snap_id=1 wait times: snap=0.000043 sec, exc=0.000043 sec, total=0.000043 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000002 sec of elapsed time 9: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x0, filetype=0x3 wait_id=301 seq_num=302 snap_id=1 wait times: snap=0.000190 sec, exc=0.000190 sec, total=0.000190 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000104 sec of elapsed time Sampled Session History of session 209 serial 43933 --------------------------------------------------- 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:21:57 - 08:22:02] not in wait at each sample [1 sample, 08:21:56] idle wait at each sample [session created at: 08:21:56] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-05-06 08:22:02.309 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 10372, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-05-06 08:21:57.117917 :936144F8:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 6, nex 8 2025-05-06 08:21:57.117925 :936144F9:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00816fad where: kdiwh22: kdifind 2025-05-06 08:21:57.168698 :9361450D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.209939 :93614521:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.220169 :93614529:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 7, nex 9 2025-05-06 08:21:57.220177 :9361452A:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00815987 where: kdiwh22: kdifind 2025-05-06 08:21:57.251314 :9361452B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.291952 :93614533:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.291983 :93614536:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] 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-05-06 08:21:57.303233 :9361453D:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 8, nex 10 2025-05-06 08:21:57.303241 :9361453E:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0080feb9 where: kddwh01: kdddel 2025-05-06 08:21:57.332659 :9361453F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.372692 :93614547:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.372725 :9361454A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.385526 :9361455C:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 9, nex 11 2025-05-06 08:21:57.385534 :9361455D:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0080fe9f where: kdiwh22: kdifind 2025-05-06 08:21:57.414317 :9361455E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.455146 :93614566:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.468570 :9361456E:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 10, nex 12 2025-05-06 08:21:57.468577 :9361456F:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00813424 where: kddwh01: kdddel 2025-05-06 08:21:57.496432 :93614570:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.496466 :93614573:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] 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-05-06 08:21:57.536936 :9361457A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.551726 :93614582:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 11, nex 13 2025-05-06 08:21:57.551734 :93614583:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0081ae81 where: kddwh01: kdddel 2025-05-06 08:21:57.577762 :93614584:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.618491 :9361458C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.633881 :93614594:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 12, nex 14 2025-05-06 08:21:57.633892 :93614595:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00811e65 where: kddwh01: kdddel 2025-05-06 08:21:57.660373 :93614596:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.660407 :93614599:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.702024 :936145AB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.717656 :936145B3:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 13, nex 15 2025-05-06 08:21:57.717664 :936145B4:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f12 where: kddwh01: kdddel 2025-05-06 08:21:57.743677 :936145B5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.743705 :936145B8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] 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-05-06 08:21:57.801636 :936145CF:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 14, nex 16 2025-05-06 08:21:57.801645 :936145D0:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f25 where: kddwh01: kdddel 2025-05-06 08:21:57.814203 :936145D1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.855088 :936145D9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.884725 :936145E1:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 15, nex 17 2025-05-06 08:21:57.884733 :936145E2:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00829729 where: kdiwh22: kdifind 2025-05-06 08:21:57.896483 :936145E3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.937509 :936145EB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:57.967542 :936145F3:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 16, nex 18 2025-05-06 08:21:57.967550 :936145F4:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f4b where: kddwh01: kdddel 2025-05-06 08:21:57.978740 :936145F5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.019637 :936145FD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.019666 :93614600:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] 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-05-06 08:21:58.050156 :93614607:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 17, nex 19 2025-05-06 08:21:58.050164 :93614608:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f5f where: kddwh01: kdddel 2025-05-06 08:21:58.060687 :93614609:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.101427 :93614611:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.101459 :93614614:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.132809 :9361462E:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 18, nex 20 2025-05-06 08:21:58.132817 :9361462F:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f72 where: kddwh01: kdddel 2025-05-06 08:21:58.143464 :93614630:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.143491 :93614633:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.185011 :93614645:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.185042 :93614648:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.216336 :93614666:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 19, nex 21 2025-05-06 08:21:58.216343 :93614667:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864b87 where: kddwh01: kdddel 2025-05-06 08:21:58.227172 :93614668:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.242237 :93614670:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.243472 :93614676:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] 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-05-06 08:21:58.243485 :93614677:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.245204 :9361467A:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] 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-05-06 08:21:58.245638 :93614696:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.267732*:936146AE:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024E1A968 estart=1746490916 eid=16777258 ctx=0x00000007738B9F78 cwh=0x0000000024DC01B0 cpu=1125000 buffg=223479 interb=0 r=0 rb=0 w=0 wb=0 2025-05-06 08:21:58.267732*:936146AF:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024E1A968 curCtx=0x0000000026B4FE68 pubTabIdxCnt=0 2025-05-06 08:21:58.267732*:936146B0:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024E1A968 2025-05-06 08:21:58.267732*:936146B1:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024E1A968 2025-05-06 08:21:58.287229 :936146B2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.287263 :936146B5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] 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-05-06 08:21:58.302930 :936146BC:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 20, nex 22 2025-05-06 08:21:58.302937 :936146BD:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864b9a where: kddwh01: kdddel 2025-05-06 08:21:58.328629 :936146BE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.369564 :936146C6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.369595 :936146C9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.385795 :936146DB:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 21, nex 23 2025-05-06 08:21:58.385803 :936146DC:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bad where: kddwh01: kdddel 2025-05-06 08:21:58.411744 :936146DD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.411774 :936146E0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.453195 :936146F2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.468891 :936146FA:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 22, nex 24 2025-05-06 08:21:58.468900 :936146FB:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bc0 where: kddwh01: kdddel 2025-05-06 08:21:58.494846 :936146FC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.494876 :936146FF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.536530 :93614711:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.536560 :93614714:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] 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-05-06 08:21:58.552026 :9361471B:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 23, nex 25 2025-05-06 08:21:58.552035 :9361471C:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bd3 where: kddwh01: kdddel 2025-05-06 08:21:58.577847 :9361471D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.577878 :93614720:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.619573 :93614732:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.619606 :93614735:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] 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-05-06 08:21:58.635273 :9361473C:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 24, nex 26 2025-05-06 08:21:58.635281 :9361473D:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864be7 where: kddwh01: kdddel 2025-05-06 08:21:58.661412 :9361473E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.661441 :93614741:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.703024 :93614753:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.718512 :9361475B:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 25, nex 27 2025-05-06 08:21:58.718520 :9361475C:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bfa where: kddwh01: kdddel 2025-05-06 08:21:58.744953 :9361475D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.786323 :93614765:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.802144 :93614778:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 26, nex 28 2025-05-06 08:21:58.802152 :93614779:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fa8f where: kddwh01: kdddel 2025-05-06 08:21:58.827749 :9361477A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.827783 :9361477D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.869603 :9361478F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.869638 :93614792:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.885584 :936147A4:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 27, nex 29 2025-05-06 08:21:58.885592 :936147A5:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087faa2 where: kddwh01: kdddel 2025-05-06 08:21:58.911559 :936147A6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.911592 :936147A9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.953365 :936147BB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:58.968756 :936147C3:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 28, nex 30 2025-05-06 08:21:58.968764 :936147C4:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fab5 where: kddwh01: kdddel 2025-05-06 08:21:58.994930 :936147C5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.036086 :936147CD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.051979 :936147D5:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 29, nex 31 2025-05-06 08:21:59.051987 :936147D6:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fac8 where: kddwh01: kdddel 2025-05-06 08:21:59.077330 :936147D7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.077363 :936147DA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] 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-05-06 08:21:59.118300 :936147E1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.134961 :936147E9:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 30, nex 32 2025-05-06 08:21:59.134971 :936147EA:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fadc where: kddwh01: kdddel 2025-05-06 08:21:59.160089 :936147EB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.201225 :936147F3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.218152 :93614807:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 31, nex 33 2025-05-06 08:21:59.218160 :93614808:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087faef where: kddwh01: kdddel 2025-05-06 08:21:59.242991 :93614809:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.284437 :93614811:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.301697 :93614819:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 32, nex 34 2025-05-06 08:21:59.301706 :9361481A:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a2784 where: kddwh01: kdddel 2025-05-06 08:21:59.325993 :9361481B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.367092 :93614846:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.384955 :9361484E:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 33, nex 35 2025-05-06 08:21:59.384963 :9361484F:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a2797 where: kddwh01: kdddel 2025-05-06 08:21:59.408434 :93614850:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.449590 :93614858:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.467763 :93614860:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 34, nex 36 2025-05-06 08:21:59.467771 :93614861:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27aa where: kddwh01: kdddel 2025-05-06 08:21:59.490987 :9361488E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.491018 :93614891:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.532461 :936148A3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.532491 :936148A6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.550865 :936148B8:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 35, nex 37 2025-05-06 08:21:59.550873 :936148B9:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27bd where: kddwh01: kdddel 2025-05-06 08:21:59.574634 :936148BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.615643 :936148C2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.634017 :936148CA:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 36, nex 38 2025-05-06 08:21:59.634025 :936148CB:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008c002b where: kdiwh22: kdifind 2025-05-06 08:21:59.657171 :936148CC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.698052 :9361490C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.717072 :9361493C:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 37, nex 39 2025-05-06 08:21:59.717083 :9361493D:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27e4 where: kddwh01: kdddel 2025-05-06 08:21:59.739725 :9361493E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.780490 :93614946:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.780520 :93614949:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.799549 :9361495B:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 38, nex 40 2025-05-06 08:21:59.799558 :9361495C:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27f7 where: kddwh01: kdddel 2025-05-06 08:21:59.822246 :9361495D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.864845 :93614965:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.887257 :9361496D:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 39, nex 41 2025-05-06 08:21:59.887265 :9361496E:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008c12de where: kddwh01: kdddel 2025-05-06 08:21:59.910128 :9361496F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:21:59.910128*:9361497F:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024E1A968 curCtx=0x0000000026B4FE68 xsc->flg4=65792 flags=2 2025-05-06 08:21:59.910128*:93614980:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024E1A968 2025-05-06 08:21:59.952738 :93614981:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=16 loc='ksr2.h LINE:603 ID:ksrpublish' id1=0 id2=0 name= type=0 2025-05-06 08:22:02.132439*:93614A8E:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024E1A4D8 curCtx=0x0000000026B4FE80 xsc->flg4=65792 flags=4 2025-05-06 08:22:02.132439*:93614A8F:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024E1A4D8 2025-05-06 08:22:02.133626 :93614A90:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:22:02.133651 :93614A93:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:22:02.174754 :93614AB9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:22:02.217419 :93614ACF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:22:02.259938 :93614AEC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:22:02.302373 :93614B08:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:22:02.302396 :93614B0B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-06 08:22:02.302880 :93614B13:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] 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 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 26 (osid: 10372, M000)