Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250808080018\orcl_m000_15780_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:35640M/63366M, Ph+PgF:41131M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 27 Windows thread id: 15780, image: ORACLE.EXE (M000) *** 2025-08-08 08:00:18.563 *** SESSION ID:(219.35595) 2025-08-08 08:00:18.563 *** 2025-08-08 08:00:18.563 Process diagnostic dump for ORACLE.EXE (M000), OS id=15780, pid: 27, proc_ser: 141, sid: 219, sess_ser: 35595 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.107992 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.108018 sec since last wait 0: waited for 'RMAN backup & recovery I/O' count=0x1, intr=0x0, timeout=0xffffffff wait_id=297 seq_num=298 snap_id=1 wait times: snap=0.000072 sec, exc=0.000072 sec, total=0.000072 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000006 sec of elapsed time 1: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x2, filetype=0x2 wait_id=296 seq_num=297 snap_id=1 wait times: snap=0.000117 sec, exc=0.000117 sec, total=0.000117 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=295 seq_num=296 snap_id=1 wait times: snap=0.000189 sec, exc=0.000189 sec, total=0.000189 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.037016 sec of elapsed time 3: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=294 seq_num=295 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.000001 sec of elapsed time 4: waited for 'log file sequential read' log#=0x29a0, block#=0x0, blocks=0x0 wait_id=293 seq_num=294 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.000015 sec of elapsed time 5: waited for 'log file sequential read' log#=0x29a0, block#=0x0, blocks=0x0 wait_id=292 seq_num=293 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.000005 sec of elapsed time 6: waited for 'log file sequential read' log#=0x0, block#=0x2, blocks=0x7fe wait_id=291 seq_num=292 snap_id=1 wait times: snap=0.000262 sec, exc=0.000262 sec, total=0.000262 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 7: waited for 'log file sequential read' log#=0x29a0, block#=0x2, blocks=0x7fe wait_id=290 seq_num=291 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.000133 sec of elapsed time 8: waited for 'log file sequential read' log#=0x0, block#=0x1, blocks=0x1 wait_id=289 seq_num=290 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=288 seq_num=289 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.000125 sec of elapsed time Sampled Session History of session 219 serial 35595 --------------------------------------------------- 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:00:12 - 08:00:18] not in wait at each sample [1 sample, 08:00:11] idle wait at each sample [session created at: 08:00:12] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-08 08:00:18.563 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 27 (osid: 15780, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-08 08:00:12.972818 :BCE86D4C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.013575 :BCE86D60:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.023783 :BCE86D68:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 4, nex 6 2025-08-08 08:00:13.023791 :BCE86D69:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0080f62e where: kddwh01: kdddel 2025-08-08 08:00:13.054294 :BCE86D6A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.054325 :BCE86D6D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-08 08:00:13.094648 :BCE86D79:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.094682 :BCE86D7C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.111202 :BCE86D8E:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 5, nex 7 2025-08-08 08:00:13.111210 :BCE86D8F:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0081250a where: kddwh01: kdddel 2025-08-08 08:00:13.161889 :BCE86D90:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.204054 :BCE86D98:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.221957 :BCE86DA0:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 6, nex 8 2025-08-08 08:00:13.221965 :BCE86DA1:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00811f44 where: kdiwh22: kdifind 2025-08-08 08:00:13.246730 :BCE86DA2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.291400 :BCE86DAA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.312011 :BCE86DB2:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 7, nex 9 2025-08-08 08:00:13.312021 :BCE86DB3:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0080feba where: kddwh01: kdddel 2025-08-08 08:00:13.336363 :BCE86DB4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.380373 :BCE86DC9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.402360 :BCE86DD1:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 8, nex 10 2025-08-08 08:00:13.402369 :BCE86DD2:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00810579 where: kddwh01: kdddel 2025-08-08 08:00:13.425713 :BCE86DD3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.469675 :BCE86DDB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.491574 :BCE86DE3:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 9, nex 11 2025-08-08 08:00:13.491583 :BCE86DE4:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00813426 where: kddwh01: kdddel 2025-08-08 08:00:13.511996 :BCE86DE5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.553770 :BCE86DED:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.576858 :BCE86DF5:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 10, nex 12 2025-08-08 08:00:13.576867 :BCE86DF6:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0081ae82 where: kddwh01: kdddel 2025-08-08 08:00:13.595946 :BCE86DFB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.638034 :BCE86E03:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.638065 :BCE86E06:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-08 08:00:13.662092 :BCE86E0D:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 11, nex 13 2025-08-08 08:00:13.662099 :BCE86E0E:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00811e66 where: kddwh01: kdddel 2025-08-08 08:00:13.681315 :BCE86E0F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.723500 :BCE86E17:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.748002 :BCE86E1F:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 12, nex 14 2025-08-08 08:00:13.748011 :BCE86E20:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f14 where: kddwh01: kdddel 2025-08-08 08:00:13.766308 :BCE86E21:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.808322 :BCE86E29:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.808355 :BCE86E2C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.833075 :BCE86E3E:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 13, nex 15 2025-08-08 08:00:13.833083 :BCE86E3F:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f27 where: kddwh01: kdddel 2025-08-08 08:00:13.851143 :BCE86E40:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.892952 :BCE86E48:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.917988 :BCE86E50:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 14, nex 16 2025-08-08 08:00:13.917997 :BCE86E51:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00811a4b where: kdiwh22: kdifind 2025-08-08 08:00:13.935511 :BCE86E52:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:13.977818 :BCE86E5A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.003293 :BCE86E6E:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 15, nex 17 2025-08-08 08:00:14.003301 :BCE86E6F:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f4d where: kddwh01: kdddel 2025-08-08 08:00:14.020550 :BCE86E70:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.062316 :BCE86E78:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.087991 :BCE86E80:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 16, nex 18 2025-08-08 08:00:14.087999 :BCE86E81:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f60 where: kddwh01: kdddel 2025-08-08 08:00:14.104289 :BCE86E82:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.104320 :BCE86E85:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.108929*:BCE86E97:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000290BA968 estart=1754611213 eid=16777348 ctx=0x00000007738B9F78 cwh=0x00000000290601B0 cpu=984375 buffg=186061 interb=0 r=0 rb=0 w=0 wb=0 2025-08-08 08:00:14.108929*:BCE86E98:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000290BA968 curCtx=0x0000000029062158 pubTabIdxCnt=0 2025-08-08 08:00:14.108929*:BCE86E99:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000290BA968 2025-08-08 08:00:14.108929*:BCE86E9A:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000290BA968 2025-08-08 08:00:14.146823 :BCE86E9B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.173084 :BCE86EA3:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 17, nex 19 2025-08-08 08:00:14.173092 :BCE86EA4:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f73 where: kddwh01: kdddel 2025-08-08 08:00:14.189535 :BCE86EB0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.232135 :BCE86EC0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.259186 :BCE86EC8:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 18, nex 20 2025-08-08 08:00:14.259194 :BCE86EC9:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864b88 where: kddwh01: kdddel 2025-08-08 08:00:14.275176 :BCE86ECA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.317079 :BCE86EED:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.343638 :BCE86EF5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.344954 :BCE86EFB:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-08 08:00:14.344968 :BCE86EFC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.346617 :BCE86EFF:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-08 08:00:14.347126 :BCE86F24:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.347871 :BCE86F3C:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 19, nex 21 2025-08-08 08:00:14.347877 :BCE86F3D:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864b9b where: kddwh01: kdddel 2025-08-08 08:00:14.390291 :BCE86F3E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.432882 :BCE86F59:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.433763 :BCE86F61:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 20, nex 22 2025-08-08 08:00:14.433771 :BCE86F62:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864baf where: kddwh01: kdddel 2025-08-08 08:00:14.475437 :BCE86F8B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.475467 :BCE86F8E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.518120 :BCE86FA0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.519099 :BCE86FA8:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 21, nex 23 2025-08-08 08:00:14.519106 :BCE86FA9:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864bc2 where: kddwh01: kdddel 2025-08-08 08:00:14.560814 :BCE86FAA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.603219 :BCE86FB2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.603252 :BCE86FB5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-08 08:00:14.604519 :BCE86FBC:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 22, nex 24 2025-08-08 08:00:14.604526 :BCE86FBD:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864bd5 where: kddwh01: kdddel 2025-08-08 08:00:14.645750 :BCE86FBE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.645780 :BCE86FC1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.646273 :BCE86FC8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-08 08:00:14.688733 :BCE86FCF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.688760 :BCE86FD2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.689254 :BCE86FDA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-08 08:00:14.689974 :BCE86FE6:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 23, nex 25 2025-08-08 08:00:14.689983 :BCE86FE7:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864be8 where: kddwh01: kdddel 2025-08-08 08:00:14.731799 :BCE86FE8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.731832 :BCE86FEB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.774683 :BCE86FFD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.775313 :BCE87005:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 24, nex 26 2025-08-08 08:00:14.775320 :BCE87006:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864bfb where: kddwh01: kdddel 2025-08-08 08:00:14.818086 :BCE87007:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.860811 :BCE8700F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.861918 :BCE87017:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 25, nex 27 2025-08-08 08:00:14.861925 :BCE87018:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fa90 where: kddwh01: kdddel 2025-08-08 08:00:14.904049 :BCE87019:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.946162 :BCE87021:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:14.946194 :BCE87024:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-08 08:00:14.947838 :BCE8702B:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 26, nex 28 2025-08-08 08:00:14.947845 :BCE8702C:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087faa4 where: kddwh01: kdddel 2025-08-08 08:00:14.988839 :BCE8702D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.034302 :BCE87041:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.034339 :BCE87044:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.036739 :BCE87056:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 27, nex 29 2025-08-08 08:00:15.036749 :BCE87057:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fab7 where: kddwh01: kdddel 2025-08-08 08:00:15.081477 :BCE87058:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.127732 :BCE87060:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.127773 :BCE87063:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.130219 :BCE87075:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 28, nex 30 2025-08-08 08:00:15.130229 :BCE87076:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087faca where: kddwh01: kdddel 2025-08-08 08:00:15.174650 :BCE87077:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.220970 :BCE8707F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.223337 :BCE87087:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 29, nex 31 2025-08-08 08:00:15.223350 :BCE87088:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fadd where: kddwh01: kdddel 2025-08-08 08:00:15.267870 :BCE87089:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.313270 :BCE870B4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.315830 :BCE870BC:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 30, nex 32 2025-08-08 08:00:15.315838 :BCE870BD:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087faf0 where: kddwh01: kdddel 2025-08-08 08:00:15.356108 :BCE870C9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.398575 :BCE870D1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.401510 :BCE870D9:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 31, nex 33 2025-08-08 08:00:15.401518 :BCE870DA:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a2785 where: kddwh01: kdddel 2025-08-08 08:00:15.441327 :BCE870DB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.483650 :BCE870E3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.483675 :BCE870E6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.487184 :BCE870F8:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 32, nex 34 2025-08-08 08:00:15.487191 :BCE870F9:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a2798 where: kddwh01: kdddel 2025-08-08 08:00:15.526648 :BCE870FA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.526680 :BCE870FD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-08 08:00:15.568707 :BCE87104:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.572260 :BCE8710C:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 33, nex 35 2025-08-08 08:00:15.572268 :BCE8710D:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27ac where: kddwh01: kdddel 2025-08-08 08:00:15.611433 :BCE8710E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.611461 :BCE87111:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.653957 :BCE87123:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.657583 :BCE8712B:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 34, nex 36 2025-08-08 08:00:15.657591 :BCE8712C:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27bf where: kddwh01: kdddel 2025-08-08 08:00:15.696580 :BCE8712D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.738723 :BCE87135:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.738753 :BCE87138:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.742865 :BCE8714A:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 35, nex 37 2025-08-08 08:00:15.742873 :BCE8714B:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27d2 where: kddwh01: kdddel 2025-08-08 08:00:15.781713 :BCE8714C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.823894 :BCE87154:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.827921 :BCE8715C:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 36, nex 38 2025-08-08 08:00:15.827929 :BCE8715D:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27e5 where: kddwh01: kdddel 2025-08-08 08:00:15.866293 :BCE8718C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.866324 :BCE8718F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-08 08:00:15.908189 :BCE8719B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:15.912604 :BCE871A3:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 37, nex 39 2025-08-08 08:00:15.912612 :BCE871A4:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27f8 where: kddwh01: kdddel 2025-08-08 08:00:15.954635 :BCE871A5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:16.002767 :BCE871AD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:16.007890 :BCE871B5:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 38, nex 40 2025-08-08 08:00:16.007900 :BCE871B6:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008c12e1 where: kddwh01: kdddel 2025-08-08 08:00:16.015524*:BCE871C3:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000290BA968 curCtx=0x0000000029062158 xsc->flg4=65792 flags=2 2025-08-08 08:00:16.015524*:BCE871C4:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000290BA968 2025-08-08 08:00:16.050234 :BCE871C5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:16.070902 :BCE871CD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=16 loc='ksr2.h LINE:603 ID:ksrpublish' id1=0 id2=0 name= type=0 2025-08-08 08:00:18.476622*:BCE8751A:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000290BA4D8 curCtx=0x0000000029062170 xsc->flg4=65792 flags=4 2025-08-08 08:00:18.476622*:BCE8751B:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000290BA4D8 2025-08-08 08:00:18.518816 :BCE87543:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:18.518840 :BCE87546:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:18.562074 :BCE8756C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-08 08:00:18.562100 :BCE8756F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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 27 (osid: 15780, M000)