Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250509082424\orcl_m000_4864_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:37507M/63366M, Ph+PgF:44908M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 4864, image: ORACLE.EXE (M000) *** 2025-05-09 08:24:24.896 *** SESSION ID:(209.20195) 2025-05-09 08:24:24.896 *** 2025-05-09 08:24:24.896 Process diagnostic dump for ORACLE.EXE (M000), OS id=4864, pid: 26, proc_ser: 62, sid: 209, sess_ser: 20195 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.102253 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.102278 sec since last wait 0: waited for 'log file switch completion' =0x0, =0x0, =0x0 wait_id=302 seq_num=303 snap_id=1 wait times: snap=0.001888 sec, exc=0.001888 sec, total=0.001888 sec wait times: max=infinite wait counts: calls=2 os=2 occurred after 0.019955 sec of elapsed time 1: waited for 'RMAN backup & recovery I/O' count=0x1, intr=0x0, timeout=0xffffffff wait_id=301 seq_num=302 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 2: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x2, filetype=0x2 wait_id=300 seq_num=301 snap_id=1 wait times: snap=0.000122 sec, exc=0.000122 sec, total=0.000122 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time 3: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x2, filetype=0x2 wait_id=299 seq_num=300 snap_id=1 wait times: snap=0.000183 sec, exc=0.000183 sec, total=0.000183 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.033448 sec of elapsed time 4: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=298 seq_num=299 snap_id=1 wait times: snap=0.000192 sec, exc=0.000192 sec, total=0.000192 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#=0x278d, block#=0x0, blocks=0x0 wait_id=297 seq_num=298 snap_id=1 wait times: snap=0.000004 sec, exc=0.000004 sec, total=0.000004 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.020345 sec of elapsed time 6: waited for 'log file sequential read' log#=0x278d, block#=0x0, blocks=0x0 wait_id=296 seq_num=297 snap_id=1 wait times: snap=0.000016 sec, exc=0.000016 sec, total=0.000016 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.013013 sec of elapsed time 7: waited for 'log file sequential read' log#=0x0, block#=0x15000, blocks=0x800 wait_id=295 seq_num=296 snap_id=1 wait times: snap=0.000312 sec, exc=0.000312 sec, total=0.000312 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000013 sec of elapsed time 8: waited for 'log file sequential read' log#=0x0, block#=0x14800, blocks=0x800 wait_id=294 seq_num=295 snap_id=1 wait times: snap=0.005477 sec, exc=0.005477 sec, total=0.005477 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000112 sec of elapsed time 9: waited for 'log file sequential read' log#=0x0, block#=0x14000, blocks=0x800 wait_id=293 seq_num=294 snap_id=1 wait times: snap=0.000361 sec, exc=0.000361 sec, total=0.000361 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.171547 sec of elapsed time Sampled Session History of session 209 serial 20195 --------------------------------------------------- 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:24:19 - 08:24:24] not in wait at each sample [1 sample, 08:24:18] idle wait at each sample [session created at: 08:24:18] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-05-09 08:24:24.896 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 4864, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-05-09 08:24:19.463300 :94B41221:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.463330 :94B41224:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.463814 :94B4122B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.480125 :94B41232:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 18, nex 19 2025-05-09 08:24:19.480133 :94B41233:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00812530 where: kddwh01: kdddel 2025-05-09 08:24:19.503861 :94B41234:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.562325 :94B41248:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.583365 :94B41250:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 19, nex 20 2025-05-09 08:24:19.583373 :94B41251:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008021db where: kddwh01: kdddel 2025-05-09 08:24:19.603916 :94B41252:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.645151 :94B4125A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.667036 :94B41262:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 20, nex 21 2025-05-09 08:24:19.667044 :94B41263:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00813129 where: kddwh01: kdddel 2025-05-09 08:24:19.686309 :94B41264:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.726659 :94B4126C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.726692 :94B4126F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.749921 :94B41276:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 21, nex 22 2025-05-09 08:24:19.749929 :94B41277:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00814226 where: kddwh01: kdddel 2025-05-09 08:24:19.767473 :94B41278:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.767505 :94B4127B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.808325 :94B41282:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.808355 :94B41285:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.832746 :94B41297:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 22, nex 23 2025-05-09 08:24:19.832754 :94B41298:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0081357f where: kdiwh22: kdifind 2025-05-09 08:24:19.850106 :94B41299:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.891235 :94B412A1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.916657 :94B412A9:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 23, nex 24 2025-05-09 08:24:19.916665 :94B412AA:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008109c1 where: kddwh01: kdddel 2025-05-09 08:24:19.932612 :94B412AB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.932644 :94B412AE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:19.975675 :94B412C0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.003577 :94B412C8:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 24, nex 25 2025-05-09 08:24:20.003587 :94B412C9:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00811dfe where: kddwh01: kdddel 2025-05-09 08:24:20.020277 :94B412CA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.065181 :94B412D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.093609 :94B412DA:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 25, nex 26 2025-05-09 08:24:20.093619 :94B412DB:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f0b where: kddwh01: kdddel 2025-05-09 08:24:20.109904 :94B41302:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.109937 :94B41305:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.154590 :94B41317:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.183295 :94B4131F:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 26, nex 27 2025-05-09 08:24:20.183304 :94B41320:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f1e where: kddwh01: kdddel 2025-05-09 08:24:20.199410 :94B41321:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.243569 :94B41334:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.272396 :94B4133C:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 27, nex 28 2025-05-09 08:24:20.272406 :94B4133D:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f31 where: kddwh01: kdddel 2025-05-09 08:24:20.287998 :94B4133E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.332152 :94B41346:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.362044 :94B4134E:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 28, nex 29 2025-05-09 08:24:20.362055 :94B4134F:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f44 where: kddwh01: kdddel 2025-05-09 08:24:20.377183 :94B41350:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.404450*:94B41368:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000272EA968 estart=1746750259 eid=16777261 ctx=0x00000007738B9F78 cwh=0x00000000272901B0 cpu=859375 buffg=165577 interb=0 r=0 rb=0 w=0 wb=0 2025-05-09 08:24:20.404450*:94B41369:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000272EA968 curCtx=0x0000000028C1FE68 pubTabIdxCnt=0 2025-05-09 08:24:20.404450*:94B4136C:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000272EA968 2025-05-09 08:24:20.404450*:94B41376:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000272EA968 2025-05-09 08:24:20.421742 :94B41379:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.451657 :94B41381:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 29, nex 30 2025-05-09 08:24:20.451666 :94B41382:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f57 where: kddwh01: kdddel 2025-05-09 08:24:20.466037 :94B41383:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.509944 :94B4138B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.540800 :94B413A7:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 30, nex 31 2025-05-09 08:24:20.540809 :94B413A8:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f6a where: kddwh01: kdddel 2025-05-09 08:24:20.554691 :94B413A9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.598976 :94B413B1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.630671 :94B413B9:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 31, nex 32 2025-05-09 08:24:20.630681 :94B413BA:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f7d where: kddwh01: kdddel 2025-05-09 08:24:20.643939 :94B413BB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.689001 :94B413C3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.693251 :94B413CB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.694390 :94B413D1:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-05-09 08:24:20.694409 :94B413D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.696056 :94B413D5:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-05-09 08:24:20.696447 :94B413F1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.722705 :94B41409:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 32, nex 33 2025-05-09 08:24:20.722713 :94B4140A:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864b93 where: kddwh01: kdddel 2025-05-09 08:24:20.739035 :94B4140B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.780587 :94B41413:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.806483 :94B4141B:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 33, nex 34 2025-05-09 08:24:20.806491 :94B4141C:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864ba6 where: kddwh01: kdddel 2025-05-09 08:24:20.822295 :94B4141D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.863663 :94B41425:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.890080 :94B4142D:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 34, nex 35 2025-05-09 08:24:20.890088 :94B4142E:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a391e where: kdiwh22: kdifind 2025-05-09 08:24:20.905260 :94B4142F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.946660 :94B41437:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:20.973613 :94B4143F:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 35, nex 36 2025-05-09 08:24:20.973624 :94B41440:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bcc where: kddwh01: kdddel 2025-05-09 08:24:20.989535 :94B41441:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.034131 :94B41449:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.063595 :94B41451:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 36, nex 37 2025-05-09 08:24:21.063605 :94B41452:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bdf where: kddwh01: kdddel 2025-05-09 08:24:21.078959 :94B41453:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.123668 :94B4145B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.153801 :94B41463:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 37, nex 38 2025-05-09 08:24:21.153810 :94B41464:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bf2 where: kddwh01: kdddel 2025-05-09 08:24:21.168909 :94B41465:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.213473 :94B4146D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.243990 :94B41475:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 38, nex 39 2025-05-09 08:24:21.243999 :94B41476:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fa87 where: kddwh01: kdddel 2025-05-09 08:24:21.258860 :94B41477:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.303457 :94B4147F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.334332 :94B414AF:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 39, nex 40 2025-05-09 08:24:21.334342 :94B414B0:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fa9b where: kddwh01: kdddel 2025-05-09 08:24:21.348575 :94B414B1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.348615 :94B414B4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.393886 :94B414C6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.424956 :94B414CE:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 40, nex 41 2025-05-09 08:24:21.424965 :94B414CF:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087faae where: kddwh01: kdddel 2025-05-09 08:24:21.438867 :94B414D0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.483422 :94B414D8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.483456 :94B414DB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.514719 :94B414ED:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 41, nex 42 2025-05-09 08:24:21.514728 :94B414EE:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fac1 where: kddwh01: kdddel 2025-05-09 08:24:21.528671 :94B414EF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.573205 :94B41503:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.603012 :94B4150B:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 42, nex 43 2025-05-09 08:24:21.603020 :94B4150C:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fad4 where: kddwh01: kdddel 2025-05-09 08:24:21.615494 :94B4150D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.657146 :94B41515:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.687139 :94B4151D:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 43, nex 44 2025-05-09 08:24:21.687146 :94B4151E:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fae7 where: kddwh01: kdddel 2025-05-09 08:24:21.699219 :94B4151F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.740806 :94B4154A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.770896 :94B41552:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 44, nex 45 2025-05-09 08:24:21.770905 :94B41553:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fafa where: kddwh01: kdddel 2025-05-09 08:24:21.782613 :94B41554:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.824147 :94B4156F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.854742 :94B41577:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 45, nex 46 2025-05-09 08:24:21.854751 :94B41578:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008958d8 where: kdiwh22: kdifind 2025-05-09 08:24:21.865871 :94B41579:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.907357 :94B4158C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.907390 :94B4158F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.938450 :94B415A1:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 46, nex 47 2025-05-09 08:24:21.938460 :94B415A2:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27a3 where: kddwh01: kdddel 2025-05-09 08:24:21.949612 :94B415A3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.949647 :94B415A6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-05-09 08:24:21.991014 :94B415AD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.024736 :94B415B5:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 47, nex 48 2025-05-09 08:24:22.024746 :94B415B6:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27b6 where: kddwh01: kdddel 2025-05-09 08:24:22.036057 :94B415B7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.036360 :94B415BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.081131 :94B415CC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.114300 :94B415D4:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 48, nex 49 2025-05-09 08:24:22.114310 :94B415D5:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27c9 where: kddwh01: kdddel 2025-05-09 08:24:22.125666 :94B415D6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.125699 :94B415D9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.170720 :94B415EB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.204334 :94B415F3:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 49, nex 50 2025-05-09 08:24:22.204343 :94B415F4:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27dc where: kddwh01: kdddel 2025-05-09 08:24:22.215641 :94B415F5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.260304 :94B415FD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.260343 :94B41600:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.294048 :94B41612:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 50, nex 51 2025-05-09 08:24:22.294058 :94B41613:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27f0 where: kddwh01: kdddel 2025-05-09 08:24:22.305341 :94B41614:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.305381 :94B41617:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.350030 :94B41629:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.385249 :94B41631:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 51, nex 52 2025-05-09 08:24:22.385259 :94B41632:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008c12a6 where: kddwh01: kdddel 2025-05-09 08:24:22.396727 :94B41633:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.396769 :94B41636:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.406536*:94B41648:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000272EA968 estart=1746750259 eid=16777261 ctx=0x00000007738B9F78 cwh=0x00000000272901B0 cpu=2000000 buffg=377346 interb=0 r=0 rb=0 w=0 wb=0 2025-05-09 08:24:22.406536*:94B41649:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000272EA968 2025-05-09 08:24:22.445647 :94B4164A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:22.445647*:94B4165A:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000272EA968 curCtx=0x0000000028C1FE68 xsc->flg4=65792 flags=2 2025-05-09 08:24:22.445647*:94B4165B:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000272EA968 2025-05-09 08:24:22.479664 :94B4165C:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 8, ext 52, nex 53 2025-05-09 08:24:22.479674 :94B4165D:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00812b89 where: kdiwh22: kdifind 2025-05-09 08:24:22.493350 :94B4165E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=16 loc='ksr2.h LINE:603 ID:ksrpublish' id1=0 id2=0 name= type=0 2025-05-09 08:24:24.790944*:94B417F7:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000272EA4D8 curCtx=0x0000000028C1FE80 xsc->flg4=65792 flags=4 2025-05-09 08:24:24.790944*:94B417F8:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000272EA4D8 2025-05-09 08:24:24.803375 :94B41818:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:24.803583 :94B4181A:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-05-09 08:24:24.805265 :94B4181F:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-05-09 08:24:24.805564 :94B41838:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:24.848083 :94B41869:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-05-09 08:24:24.890707 :94B41890:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 26 (osid: 4864, M000)