Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250908222147\orcl_m000_20404_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:34940M/63366M, Ph+PgF:39702M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 28 Windows thread id: 20404, image: ORACLE.EXE (M000) *** 2025-09-08 22:21:47.190 *** SESSION ID:(225.24329) 2025-09-08 22:21:47.190 *** 2025-09-08 22:21:47.190 Process diagnostic dump for ORACLE.EXE (M000), OS id=20404, pid: 28, proc_ser: 39, sid: 225, sess_ser: 24329 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.273760 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.273786 sec since last wait 0: waited for 'RMAN backup & recovery I/O' count=0x1, intr=0x0, timeout=0xffffffff wait_id=213 seq_num=214 snap_id=1 wait times: snap=0.000092 sec, exc=0.000092 sec, total=0.000092 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000009 sec of elapsed time 1: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x2, filetype=0x2 wait_id=212 seq_num=213 snap_id=1 wait times: snap=0.000144 sec, exc=0.000144 sec, total=0.000144 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000008 sec of elapsed time 2: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x2, filetype=0x2 wait_id=211 seq_num=212 snap_id=1 wait times: snap=0.000289 sec, exc=0.000289 sec, total=0.000289 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 1.325571 sec of elapsed time 3: waited for 'control file sequential read' file#=0x0, block#=0x20, blocks=0x1 wait_id=210 seq_num=211 snap_id=1 wait times: snap=0.000048 sec, exc=0.000048 sec, total=0.000048 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000005 sec of elapsed time 4: waited for 'control file sequential read' file#=0x0, block#=0x17, blocks=0x1 wait_id=209 seq_num=210 snap_id=1 wait times: snap=0.000046 sec, exc=0.000046 sec, total=0.000046 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000009 sec of elapsed time 5: waited for 'control file sequential read' file#=0x0, block#=0x12, blocks=0x1 wait_id=208 seq_num=209 snap_id=1 wait times: snap=0.000048 sec, exc=0.000048 sec, total=0.000048 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 6: waited for 'control file sequential read' file#=0x0, block#=0x10, blocks=0x1 wait_id=207 seq_num=208 snap_id=1 wait times: snap=0.000047 sec, exc=0.000047 sec, total=0.000047 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000006 sec of elapsed time 7: waited for 'control file sequential read' file#=0x1, block#=0x1, blocks=0x1 wait_id=206 seq_num=207 snap_id=1 wait times: snap=0.000053 sec, exc=0.000053 sec, total=0.000053 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000009 sec of elapsed time 8: waited for 'control file sequential read' file#=0x0, block#=0x1, blocks=0x1 wait_id=205 seq_num=206 snap_id=1 wait times: snap=0.000083 sec, exc=0.000083 sec, total=0.000083 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 9: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x1, filetype=0x1 wait_id=204 seq_num=205 snap_id=1 wait times: snap=0.000053 sec, exc=0.000053 sec, total=0.000053 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time Sampled Session History of session 225 serial 24329 --------------------------------------------------- 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 --------------------------------------------------- [5 samples, 22:21:42 - 22:21:46] not in wait at each sample [1 sample, 22:21:41] idle wait at each sample [session created at: 22:21:41] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-09-08 22:21:47.190 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 28 (osid: 20404, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-09-08 22:21:42.449500 :CAD48470:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.452110 :CAD48478:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 5, nex 6 2025-09-08 22:21:42.452117 :CAD48479:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00812172 where: kdiwh22: kdifind 2025-09-08 22:21:42.490975 :CAD4847A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.491006 :CAD4847D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] 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-09-08 22:21:42.559657 :CAD48484:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.559689 :CAD48487:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.567293 :CAD48499:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 6, nex 7 2025-09-08 22:21:42.567301 :CAD4849A:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x008021d8 where: kddwh01: kdddel 2025-09-08 22:21:42.603238 :CAD4849B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.646121 :CAD484A3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.653919 :CAD484AB:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 7, nex 8 2025-09-08 22:21:42.653931 :CAD484AC:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0080f16d where: kddwh01: kdddel 2025-09-08 22:21:42.688636 :CAD484AD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.688671 :CAD484B0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.733618 :CAD484C2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.743157 :CAD484CA:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 8, nex 9 2025-09-08 22:21:42.743167 :CAD484CB:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0080f207 where: kdiwh22: kdifind 2025-09-08 22:21:42.779050 :CAD484CC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.824859 :CAD484D4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.830048*:CAD484DC:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000029960EF8 estart=1757341301 eid=16777378 ctx=0x00000007738B9F78 cwh=0x00000000292A01B0 cpu=296875 buffg=54135 interb=0 r=0 rb=0 w=0 wb=0 2025-09-08 22:21:42.830048*:CAD484DD:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000029960EF8 curCtx=0x000000002994FE68 pubTabIdxCnt=0 2025-09-08 22:21:42.830048*:CAD484DE:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000029960EF8 2025-09-08 22:21:42.830048*:CAD484DF:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000029960EF8 2025-09-08 22:21:42.835885 :CAD484E0:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 9, nex 10 2025-09-08 22:21:42.835894 :CAD484E1:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x008118d0 where: kddwh01: kdddel 2025-09-08 22:21:42.870775 :CAD484E2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.916744 :CAD484EA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:42.929003 :CAD484F2:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 10, nex 11 2025-09-08 22:21:42.929013 :CAD484F3:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00816fb5 where: kddwh01: kdddel 2025-09-08 22:21:42.963109 :CAD484F4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.009129 :CAD484FC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.022476 :CAD48504:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 11, nex 12 2025-09-08 22:21:43.022489 :CAD48505:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00811dfa where: kddwh01: kdddel 2025-09-08 22:21:43.055809 :CAD48506:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.102577 :CAD4850E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.116565 :CAD48516:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 12, nex 13 2025-09-08 22:21:43.116574 :CAD48517:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00825f08 where: kddwh01: kdddel 2025-09-08 22:21:43.149463 :CAD48518:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.195824 :CAD48520:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.210638 :CAD48528:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 13, nex 14 2025-09-08 22:21:43.210649 :CAD48529:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00825f1b where: kddwh01: kdddel 2025-09-08 22:21:43.242895 :CAD4852A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.289470 :CAD48532:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.289511 :CAD48535:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.304715 :CAD48555:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 14, nex 15 2025-09-08 22:21:43.304727 :CAD48556:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00825f2e where: kddwh01: kdddel 2025-09-08 22:21:43.337248 :CAD48557:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.383785 :CAD4856B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.399161 :CAD48573:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 15, nex 16 2025-09-08 22:21:43.399170 :CAD48574:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00825f41 where: kddwh01: kdddel 2025-09-08 22:21:43.429690 :CAD48575:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.472616 :CAD4857D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.487073 :CAD48585:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 16, nex 17 2025-09-08 22:21:43.487081 :CAD48586:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00825f54 where: kddwh01: kdddel 2025-09-08 22:21:43.515596 :CAD48587:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.557839 :CAD4858F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.573034 :CAD4859F:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 17, nex 18 2025-09-08 22:21:43.573042 :CAD485A0:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00825f67 where: kddwh01: kdddel 2025-09-08 22:21:43.600814 :CAD485A1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.643437 :CAD485A9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.643463 :CAD485AC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.659334 :CAD485BE:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 18, nex 19 2025-09-08 22:21:43.659342 :CAD485BF:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00825f7a where: kddwh01: kdddel 2025-09-08 22:21:43.687306 :CAD485C0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.704190 :CAD485C8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.705475 :CAD485CE:db_trace:ksl2.c@12699:ksliwat(): [10005:28:225] 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-09-08 22:21:43.705489 :CAD485CF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.707109 :CAD485D2:db_trace:ksl2.c@12699:ksliwat(): [10005:28:225] 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-09-08 22:21:43.707577 :CAD485EF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.749657 :CAD48607:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 19, nex 20 2025-09-08 22:21:43.749665 :CAD48608:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00864b90 where: kddwh01: kdddel 2025-09-08 22:21:43.751471 :CAD48609:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.751500 :CAD4860C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.794655 :CAD4861E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.794685 :CAD48621:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.836195 :CAD4865B:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 20, nex 21 2025-09-08 22:21:43.836204 :CAD4865C:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00864ba3 where: kddwh01: kdddel 2025-09-08 22:21:43.838212 :CAD4865D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.880827 :CAD48665:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.922234 :CAD4866D:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 21, nex 22 2025-09-08 22:21:43.922243 :CAD4866E:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00864bb6 where: kddwh01: kdddel 2025-09-08 22:21:43.923913 :CAD4866F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:43.966544 :CAD48677:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.008641 :CAD4867F:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 22, nex 23 2025-09-08 22:21:44.008649 :CAD48680:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00864bc9 where: kddwh01: kdddel 2025-09-08 22:21:44.009713 :CAD48681:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.009746 :CAD48684:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] 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-09-08 22:21:44.052690 :CAD4868B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.095175 :CAD48693:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 23, nex 24 2025-09-08 22:21:44.095183 :CAD48694:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00864bdc where: kddwh01: kdddel 2025-09-08 22:21:44.095839 :CAD48695:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.138690 :CAD4869D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.138721 :CAD486A0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] 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-09-08 22:21:44.181359 :CAD486A7:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 24, nex 25 2025-09-08 22:21:44.181367 :CAD486A8:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x00864bef where: kddwh01: kdddel 2025-09-08 22:21:44.181657 :CAD486A9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.224580 :CAD486B1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.224612 :CAD486B4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] 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-09-08 22:21:44.267519 :CAD486BB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.268082 :CAD486C3:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 25, nex 26 2025-09-08 22:21:44.268090 :CAD486C4:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0087fa84 where: kddwh01: kdddel 2025-09-08 22:21:44.310809 :CAD486C5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.353850 :CAD486CD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.354861 :CAD486D5:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 26, nex 27 2025-09-08 22:21:44.354868 :CAD486D6:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0087fa98 where: kddwh01: kdddel 2025-09-08 22:21:44.396919 :CAD48706:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.440366 :CAD48723:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.441907 :CAD4872B:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 27, nex 28 2025-09-08 22:21:44.441916 :CAD4872C:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0087faab where: kddwh01: kdddel 2025-09-08 22:21:44.485455 :CAD4872D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.485488 :CAD48730:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.531127 :CAD48742:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.532707 :CAD4874A:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 28, nex 29 2025-09-08 22:21:44.532715 :CAD4874B:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0086aef0 where: kdiwh22: kdifind 2025-09-08 22:21:44.576246 :CAD4876D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.621981 :CAD48785:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 29, nex 30 2025-09-08 22:21:44.621990 :CAD48786:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0087fad1 where: kddwh01: kdddel 2025-09-08 22:21:44.676045 :CAD487BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.708518 :CAD487E5:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 30, nex 31 2025-09-08 22:21:44.708526 :CAD487E6:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0087fae4 where: kddwh01: kdddel 2025-09-08 22:21:44.718899 :CAD487E7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.718928 :CAD487EA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.719448 :CAD487F1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] 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-09-08 22:21:44.765015 :CAD487F8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.801162 :CAD48800:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 31, nex 32 2025-09-08 22:21:44.801171 :CAD48801:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0087faf7 where: kddwh01: kdddel 2025-09-08 22:21:44.812631 :CAD48802:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.829665*:CAD4880A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000029960EF8 estart=1757341301 eid=16777378 ctx=0x00000007738B9F78 cwh=0x00000000292A01B0 cpu=1984375 buffg=371211 interb=0 r=0 rb=0 w=0 wb=0 2025-09-08 22:21:44.829665*:CAD4880B:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000029960EF8 2025-09-08 22:21:44.859496 :CAD4880C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.895795 :CAD48814:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 32, nex 33 2025-09-08 22:21:44.895804 :CAD48815:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x008a278c where: kddwh01: kdddel 2025-09-08 22:21:44.906570 :CAD48816:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.953188 :CAD4881E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:44.990284 :CAD48826:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 33, nex 34 2025-09-08 22:21:44.990294 :CAD48827:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x008a27a0 where: kddwh01: kdddel 2025-09-08 22:21:45.000317 :CAD48828:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.047153 :CAD48830:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.084689 :CAD48838:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 34, nex 35 2025-09-08 22:21:45.084698 :CAD48839:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x008a27b3 where: kddwh01: kdddel 2025-09-08 22:21:45.094349 :CAD4883A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.140918 :CAD48842:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.140958 :CAD48845:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.179565 :CAD48857:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 35, nex 36 2025-09-08 22:21:45.179574 :CAD48858:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x008a27c6 where: kddwh01: kdddel 2025-09-08 22:21:45.189014 :CAD48859:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.235737 :CAD48861:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.274013 :CAD48869:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 36, nex 37 2025-09-08 22:21:45.274022 :CAD4886A:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x008a27d9 where: kddwh01: kdddel 2025-09-08 22:21:45.282709 :CAD4886B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.329437 :CAD48873:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.329476 :CAD48876:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.367976 :CAD48894:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 37, nex 38 2025-09-08 22:21:45.367986 :CAD48895:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x008a27ec where: kddwh01: kdddel 2025-09-08 22:21:45.377027 :CAD48896:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.423522 :CAD4889E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.466311 :CAD488A6:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 38, nex 39 2025-09-08 22:21:45.466321 :CAD488A7:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x008c129e where: kddwh01: kdddel 2025-09-08 22:21:45.475286 :CAD488A8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.475324 :CAD488AB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.526120 :CAD488BD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.548425*:CAD488CD:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000029960EF8 curCtx=0x000000002994FE68 xsc->flg4=65792 flags=2 2025-09-08 22:21:45.548425*:CAD488CE:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000029960EF8 2025-09-08 22:21:45.567606 :CAD488CF:db_trace:ktu.c@4871:ktuaex1r(): [10442:28:225] Extension usn 10, ext 39, nex 40 2025-09-08 22:21:45.567616 :CAD488D0:db_trace:ktusm.c@2117:ktusmasp(): [10445:28:225] des1:tsn:1 rdba:0x0080039e where: kddwh01: kdddel 2025-09-08 22:21:45.576407 :CAD488D1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:45.596136 :CAD488D9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=16 loc='ksr2.h LINE:603 ID:ksrpublish' id1=0 id2=0 name= type=0 2025-09-08 22:21:46.931848 :CAD48B7A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:46.931871 :CAD48B7D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:46.973364 :CAD48BA3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:46.973387 :CAD48BA6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:47.016451 :CAD48BB8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:47.058898 :CAD48BC0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:47.082593 :CAD48C4F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:47.082640 :CAD48C52:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:47.142388 :CAD48DBD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:47.142410 :CAD48DC0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-08 22:21:47.185664 :CAD48DE6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:28:225] 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 28 (osid: 20404, M000)