Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250821080948\orcl_m000_19940_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:35326M/63366M, Ph+PgF:40524M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 19940, image: ORACLE.EXE (M000) *** 2025-08-21 08:09:49.026 *** SESSION ID:(193.63687) 2025-08-21 08:09:49.026 *** 2025-08-21 08:09:49.026 Process diagnostic dump for ORACLE.EXE (M000), OS id=19940, pid: 24, proc_ser: 115, sid: 193, sess_ser: 63687 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.124840 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.124866 sec since last wait 0: waited for 'RMAN backup & recovery I/O' count=0x1, intr=0x0, timeout=0xffffffff wait_id=309 seq_num=310 snap_id=1 wait times: snap=0.000078 sec, exc=0.000078 sec, total=0.000078 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=308 seq_num=309 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.000004 sec of elapsed time 2: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x2, filetype=0x2 wait_id=307 seq_num=308 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.037437 sec of elapsed time 3: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=306 seq_num=307 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.000001 sec of elapsed time 4: waited for 'log file sequential read' log#=0x29ea, block#=0x0, blocks=0x0 wait_id=305 seq_num=306 snap_id=1 wait times: snap=0.000000 sec, exc=0.000000 sec, total=0.000000 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time 5: waited for 'log file sequential read' log#=0x29ea, block#=0x0, blocks=0x0 wait_id=304 seq_num=305 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 6: waited for 'log file sequential read' log#=0x0, block#=0x2, blocks=0x7fe wait_id=303 seq_num=304 snap_id=1 wait times: snap=0.000264 sec, exc=0.000264 sec, total=0.000264 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000002 sec of elapsed time 7: waited for 'log file sequential read' log#=0x29ea, block#=0x2, blocks=0x7fe wait_id=302 seq_num=303 snap_id=1 wait times: snap=0.000198 sec, exc=0.000198 sec, total=0.000198 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000135 sec of elapsed time 8: waited for 'log file sequential read' log#=0x0, block#=0x1, blocks=0x1 wait_id=301 seq_num=302 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.000003 sec of elapsed time 9: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x0, filetype=0x3 wait_id=300 seq_num=301 snap_id=1 wait times: snap=0.000195 sec, exc=0.000195 sec, total=0.000195 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000120 sec of elapsed time Sampled Session History of session 193 serial 63687 --------------------------------------------------- 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:09:43 - 08:09:48] not in wait at each sample [1 sample, 08:09:42] idle wait at each sample [session created at: 08:09:42] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-21 08:09:49.026 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 19940, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-21 08:09:43.704090 :C29C3338: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-21 08:09:43.704122 :C29C333B: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-21 08:09:43.771638 :C29C3347: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-21 08:09:43.792521 :C29C334F:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 19, nex 20 2025-08-21 08:09:43.792529 :C29C3350:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008021db where: kddwh01: kdddel 2025-08-21 08:09:43.814209 :C29C3351: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-21 08:09:43.856628 :C29C3359: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-21 08:09:43.878033 :C29C3361:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 20, nex 21 2025-08-21 08:09:43.878040 :C29C3362:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00813129 where: kddwh01: kdddel 2025-08-21 08:09:43.898855 :C29C338B: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-21 08:09:43.940270 :C29C3393: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-21 08:09:43.940299 :C29C3396: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-21 08:09:43.963468 :C29C33A8:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 21, nex 22 2025-08-21 08:09:43.963475 :C29C33A9:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00814226 where: kddwh01: kdddel 2025-08-21 08:09:43.982634 :C29C33AA: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-21 08:09:43.982666 :C29C33AD: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-21 08:09:44.024510 :C29C33B4: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-21 08:09:44.048487 :C29C33BC:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 22, nex 23 2025-08-21 08:09:44.048495 :C29C33BD:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0080f21e where: kdiwh22: kdifind 2025-08-21 08:09:44.066905 :C29C33D1: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-21 08:09:44.109124 :C29C33D9: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-21 08:09:44.109156 :C29C33DC: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-21 08:09:44.134506 :C29C33EE:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 23, nex 24 2025-08-21 08:09:44.134514 :C29C33EF:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00815982 where: kdiwh22: kdifind 2025-08-21 08:09:44.151912 :C29C33F0: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-21 08:09:44.194118 :C29C33F8: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-21 08:09:44.219723 :C29C340C:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 24, nex 25 2025-08-21 08:09:44.219731 :C29C340D:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00811dfd where: kddwh01: kdddel 2025-08-21 08:09:44.236460 :C29C340E: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-21 08:09:44.278859 :C29C3416: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-21 08:09:44.305154 :C29C341E:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 25, nex 26 2025-08-21 08:09:44.305162 :C29C341F:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00829709 where: kdiwh22: kdifind 2025-08-21 08:09:44.321282 :C29C3420: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-21 08:09:44.363570 :C29C3428: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-21 08:09:44.390704 :C29C3430:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 26, nex 27 2025-08-21 08:09:44.390712 :C29C3431:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00811f71 where: kdiwh22: kdifind 2025-08-21 08:09:44.406408 :C29C3432: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-21 08:09:44.406441 :C29C3435: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-21 08:09:44.449158 :C29C343C: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-21 08:09:44.476623 :C29C3444:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 27, nex 28 2025-08-21 08:09:44.476631 :C29C3445:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0082a689 where: kdiwh22: kdifind 2025-08-21 08:09:44.491724 :C29C3446: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-21 08:09:44.534075 :C29C344E: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-21 08:09:44.562288 :C29C3456:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 28, nex 29 2025-08-21 08:09:44.562297 :C29C3457:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00829702 where: kdiwh22: kdifind 2025-08-21 08:09:44.576961 :C29C3458: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-21 08:09:44.600852*:C29C3460:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D5A968 estart=1755734983 eid=16777360 ctx=0x00000007738B9F78 cwh=0x00000000232801B0 cpu=859375 buffg=164890 interb=0 r=0 rb=0 w=0 wb=0 2025-08-21 08:09:44.600852*:C29C3461:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024D5A968 curCtx=0x0000000026B4FE68 pubTabIdxCnt=0 2025-08-21 08:09:44.600852*:C29C3462:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024D5A968 2025-08-21 08:09:44.600852*:C29C3463:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024D5A968 2025-08-21 08:09:44.619881 :C29C3464: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-21 08:09:44.648394 :C29C346C:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 29, nex 30 2025-08-21 08:09:44.648403 :C29C346D:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00825f57 where: kddwh01: kdddel 2025-08-21 08:09:44.662368 :C29C346E: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-21 08:09:44.704481 :C29C3476: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-21 08:09:44.704512 :C29C3479: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-21 08:09:44.733621 :C29C3493:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 30, nex 31 2025-08-21 08:09:44.733629 :C29C3494:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00825f6a where: kddwh01: kdddel 2025-08-21 08:09:44.747635 :C29C3495: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-21 08:09:44.790218 :C29C349D: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-21 08:09:44.819868 :C29C34A5:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 31, nex 32 2025-08-21 08:09:44.819876 :C29C34A6:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00825f7d where: kddwh01: kdddel 2025-08-21 08:09:44.833204 :C29C34A7: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-21 08:09:44.876095 :C29C34AF: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-21 08:09:44.882554 :C29C34B7: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-21 08:09:44.883687 :C29C34BD: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-21 08:09:44.883700 :C29C34BE: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-21 08:09:44.885344 :C29C34C1: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-21 08:09:44.885720 :C29C34DD: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-21 08:09:44.908961 :C29C34F5:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 32, nex 33 2025-08-21 08:09:44.908970 :C29C34F6:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864b92 where: kddwh01: kdddel 2025-08-21 08:09:44.928786 :C29C34F7: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-21 08:09:44.971290 :C29C3527: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-21 08:09:44.994715 :C29C3553:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 33, nex 34 2025-08-21 08:09:44.994723 :C29C3554:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864ba5 where: kddwh01: kdddel 2025-08-21 08:09:45.013962 :C29C3555: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-21 08:09:45.013993 :C29C3558: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-21 08:09:45.014519 :C29C355F: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-21 08:09:45.056777 :C29C3566: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-21 08:09:45.080302 :C29C356E:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 34, nex 35 2025-08-21 08:09:45.080310 :C29C356F:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864bb9 where: kddwh01: kdddel 2025-08-21 08:09:45.099355 :C29C3570: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-21 08:09:45.099387 :C29C3573: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-21 08:09:45.141649 :C29C357A: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-21 08:09:45.165639 :C29C3582:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 35, nex 36 2025-08-21 08:09:45.165647 :C29C3583:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864bcc where: kddwh01: kdddel 2025-08-21 08:09:45.184499 :C29C3584: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-21 08:09:45.184528 :C29C3587: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-21 08:09:45.227362 :C29C35A5: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-21 08:09:45.227395 :C29C35A8: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-21 08:09:45.251544 :C29C35BA:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 36, nex 37 2025-08-21 08:09:45.251557 :C29C35BB:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864bdf where: kddwh01: kdddel 2025-08-21 08:09:45.270989 :C29C35BC: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-21 08:09:45.313409 :C29C35C4: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-21 08:09:45.337454 :C29C35CC:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 37, nex 38 2025-08-21 08:09:45.337462 :C29C35CD:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x00864bf2 where: kddwh01: kdddel 2025-08-21 08:09:45.357269 :C29C35CE: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-21 08:09:45.357307 :C29C35D1: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-21 08:09:45.404644 :C29C35E3: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-21 08:09:45.430731 :C29C35EB:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 38, nex 39 2025-08-21 08:09:45.430741 :C29C35EC:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087fa87 where: kddwh01: kdddel 2025-08-21 08:09:45.452016 :C29C35ED: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-21 08:09:45.452060 :C29C35F0: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-21 08:09:45.499314 :C29C3602: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-21 08:09:45.526262 :C29C360A:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 39, nex 40 2025-08-21 08:09:45.526273 :C29C360B:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087fa9a where: kddwh01: kdddel 2025-08-21 08:09:45.548315 :C29C360C: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-21 08:09:45.548359 :C29C360F: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-21 08:09:45.597728 :C29C3621: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-21 08:09:45.623980 :C29C3629:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 40, nex 41 2025-08-21 08:09:45.623991 :C29C362A:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087faae where: kddwh01: kdddel 2025-08-21 08:09:45.643240 :C29C362B: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-21 08:09:45.686006 :C29C3633: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-21 08:09:45.686037 :C29C3636: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-21 08:09:45.710750 :C29C3648:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 41, nex 42 2025-08-21 08:09:45.710758 :C29C3649:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087fac1 where: kddwh01: kdddel 2025-08-21 08:09:45.729628 :C29C364A: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-21 08:09:45.729658 :C29C364D: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-21 08:09:45.772190 :C29C3654: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-21 08:09:45.796914 :C29C365C:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 42, nex 43 2025-08-21 08:09:45.796923 :C29C365D:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087fad4 where: kddwh01: kdddel 2025-08-21 08:09:45.814983 :C29C3681: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-21 08:09:45.857264 :C29C3689: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-21 08:09:45.857293 :C29C368C: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-21 08:09:45.882476 :C29C369E:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 43, nex 44 2025-08-21 08:09:45.882488 :C29C369F:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087fae7 where: kddwh01: kdddel 2025-08-21 08:09:45.900945 :C29C36A0: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-21 08:09:45.900978 :C29C36A3: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-21 08:09:45.944205 :C29C36B5: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-21 08:09:45.944236 :C29C36B8: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-21 08:09:45.944730 :C29C36BF: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-21 08:09:45.968719 :C29C36C6:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 44, nex 45 2025-08-21 08:09:45.968727 :C29C36C7:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x0087fafa where: kddwh01: kdddel 2025-08-21 08:09:45.987597 :C29C36C8: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-21 08:09:46.030149 :C29C36D0: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-21 08:09:46.054853 :C29C36D8:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 45, nex 46 2025-08-21 08:09:46.054861 :C29C36D9:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008958d0 where: kdiwh22: kdifind 2025-08-21 08:09:46.072989 :C29C36DA: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-21 08:09:46.073021 :C29C36DD: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-21 08:09:46.115787 :C29C36EF: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-21 08:09:46.140642 :C29C3702:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 46, nex 47 2025-08-21 08:09:46.140650 :C29C3703:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a27a3 where: kddwh01: kdddel 2025-08-21 08:09:46.158781 :C29C3704: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-21 08:09:46.201323 :C29C3718: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-21 08:09:46.226942 :C29C3720:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 47, nex 48 2025-08-21 08:09:46.226950 :C29C3721:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a27b6 where: kddwh01: kdddel 2025-08-21 08:09:46.244246 :C29C3722: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-21 08:09:46.286914 :C29C372A: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-21 08:09:46.312906 :C29C3732:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 48, nex 49 2025-08-21 08:09:46.312915 :C29C3733:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a27c9 where: kddwh01: kdddel 2025-08-21 08:09:46.329904 :C29C3734: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-21 08:09:46.373157 :C29C373C: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-21 08:09:46.373199 :C29C373F: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-21 08:09:46.402032 :C29C3751:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 49, nex 50 2025-08-21 08:09:46.402041 :C29C3752:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a27dc where: kddwh01: kdddel 2025-08-21 08:09:46.420179 :C29C3753: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-21 08:09:46.466507 :C29C3768: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-21 08:09:46.495377 :C29C3770:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 50, nex 51 2025-08-21 08:09:46.495386 :C29C3771:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008a27ef where: kddwh01: kdddel 2025-08-21 08:09:46.513137 :C29C3772: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-21 08:09:46.559456 :C29C377A: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-21 08:09:46.592598 :C29C3782:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 51, nex 52 2025-08-21 08:09:46.592610 :C29C3783:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008c12a6 where: kddwh01: kdddel 2025-08-21 08:09:46.601807*:C29C3784:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D5A968 estart=1755734983 eid=16777360 ctx=0x00000007738B9F78 cwh=0x00000000232801B0 cpu=2000000 buffg=375523 interb=0 r=0 rb=0 w=0 wb=0 2025-08-21 08:09:46.601807*:C29C3785:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024D5A968 2025-08-21 08:09:46.609692 :C29C3786: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-21 08:09:46.671235 :C29C378E: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-21 08:09:46.671235*:C29C379E:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024D5A968 curCtx=0x0000000026B4FE68 xsc->flg4=65792 flags=2 2025-08-21 08:09:46.671235*:C29C379F:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024D5A968 2025-08-21 08:09:46.710871 :C29C37A0:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 1, ext 52, nex 53 2025-08-21 08:09:46.710882 :C29C37A1:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008160f4 where: kdiwh22: kdifind 2025-08-21 08:09:46.727983 :C29C37A2: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-21 08:09:48.909597*:C29C3951:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024D5A4D8 curCtx=0x0000000026B4FE80 xsc->flg4=65792 flags=4 2025-08-21 08:09:48.909597*:C29C3952:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024D5A4D8 2025-08-21 08:09:48.910779 :C29C3953: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-21 08:09:48.951958 :C29C3979: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-21 08:09:48.951980 :C29C397C: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-21 08:09:48.995441 :C29C39A2: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: 19940, M000)