Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250629080356\orcl_m000_12572_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:36541M/63366M, Ph+PgF:42621M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 27 Windows thread id: 12572, image: ORACLE.EXE (M000) *** 2025-06-29 08:03:57.043 *** SESSION ID:(219.31611) 2025-06-29 08:03:57.043 *** 2025-06-29 08:03:57.043 Process diagnostic dump for ORACLE.EXE (M000), OS id=12572, pid: 27, proc_ser: 36, sid: 219, sess_ser: 31611 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.126170 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.126205 sec since last wait 0: waited for 'RMAN backup & recovery I/O' count=0x1, intr=0x0, timeout=0xffffffff wait_id=312 seq_num=313 snap_id=1 wait times: snap=0.000068 sec, exc=0.000068 sec, total=0.000068 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000008 sec of elapsed time 1: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x2, filetype=0x2 wait_id=311 seq_num=312 snap_id=1 wait times: snap=0.000096 sec, exc=0.000096 sec, total=0.000096 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000005 sec of elapsed time 2: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x2, filetype=0x2 wait_id=310 seq_num=311 snap_id=1 wait times: snap=0.000177 sec, exc=0.000177 sec, total=0.000177 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.034496 sec of elapsed time 3: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=309 seq_num=310 snap_id=1 wait times: snap=0.000187 sec, exc=0.000187 sec, total=0.000187 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000005 sec of elapsed time 4: waited for 'log file sequential read' log#=0x28b8, block#=0x0, blocks=0x0 wait_id=308 seq_num=309 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.017257 sec of elapsed time 5: waited for 'log file sequential read' log#=0x28b8, block#=0x0, blocks=0x0 wait_id=307 seq_num=308 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.000024 sec of elapsed time 6: waited for 'log file sequential read' log#=0x0, block#=0x800, blocks=0x800 wait_id=306 seq_num=307 snap_id=1 wait times: snap=0.000254 sec, exc=0.000254 sec, total=0.000254 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000027 sec of elapsed time 7: waited for 'log file sequential read' log#=0x28b8, block#=0x800, blocks=0x800 wait_id=305 seq_num=306 snap_id=1 wait times: snap=0.000202 sec, exc=0.000202 sec, total=0.000202 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000178 sec of elapsed time 8: waited for 'log file sequential read' log#=0x28b8, 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.000128 sec of elapsed time 9: waited for 'log file sequential read' log#=0x28b8, block#=0x2, blocks=0x7fe wait_id=303 seq_num=304 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.000169 sec of elapsed time Sampled Session History of session 219 serial 31611 --------------------------------------------------- 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:03:51 - 08:03:56] not in wait at each sample [1 sample, 08:03:50] idle wait at each sample [session created at: 08:03:51] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-06-29 08:03:57.043 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 27 (osid: 12572, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-29 08:03:51.747889 :AB20FC92: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-06-29 08:03:51.747913 :AB20FC95: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-06-29 08:03:51.785246 :AB20FCA7:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 5, nex 8 2025-06-29 08:03:51.785254 :AB20FCA8:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0081251c where: kdiwh22: kdifind 2025-06-29 08:03:51.788908 :AB20FCA9: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-06-29 08:03:51.851728 :AB20FCDD: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-06-29 08:03:51.892487 :AB20FCE5:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 6, nex 9 2025-06-29 08:03:51.892495 :AB20FCE6:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00808ed9 where: kddwh01: kdddel 2025-06-29 08:03:51.893655 :AB20FCE7: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-06-29 08:03:51.935479 :AB20FCFB: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-06-29 08:03:51.935510 :AB20FCFE: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-06-29 08:03:51.977212 :AB20FD10:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 7, nex 10 2025-06-29 08:03:51.977221 :AB20FD11:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0081312e where: kddwh01: kdddel 2025-06-29 08:03:51.977731 :AB20FD12: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-06-29 08:03:52.018959 :AB20FD1A: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-06-29 08:03:52.059702 :AB20FD22: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-06-29 08:03:52.061448 :AB20FD2A:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 8, nex 11 2025-06-29 08:03:52.061455 :AB20FD2B:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00815483 where: kddwh01: kdddel 2025-06-29 08:03:52.101487 :AB20FD2C: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-06-29 08:03:52.101517 :AB20FD2F: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-06-29 08:03:52.143528 :AB20FD41: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-06-29 08:03:52.145575 :AB20FD49:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 9, nex 12 2025-06-29 08:03:52.145584 :AB20FD4A:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00817ec0 where: kdiwh22: kdifind 2025-06-29 08:03:52.185771 :AB20FD4B: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-06-29 08:03:52.227153 :AB20FD53: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-06-29 08:03:52.230532 :AB20FD5B:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 10, nex 13 2025-06-29 08:03:52.230541 :AB20FD5C:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008109c6 where: kddwh01: kdddel 2025-06-29 08:03:52.268924 :AB20FD5D: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-06-29 08:03:52.310479 :AB20FD65: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-06-29 08:03:52.314461 :AB20FD6D:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 11, nex 14 2025-06-29 08:03:52.314469 :AB20FD6E:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00811e62 where: kddwh01: kdddel 2025-06-29 08:03:52.318899*:AB20FD6F:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028CBBCC0 estart=1751155431 eid=16777310 ctx=0x00000007738B9F78 cwh=0x0000000028C601B0 cpu=500000 buffg=96290 interb=0 r=0 rb=0 w=0 wb=0 2025-06-29 08:03:52.318899*:AB20FD70:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028CBBCC0 curCtx=0x0000000028C62158 pubTabIdxCnt=0 2025-06-29 08:03:52.318899*:AB20FD71:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028CBBCC0 2025-06-29 08:03:52.318899*:AB20FD72:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028CBBCC0 2025-06-29 08:03:52.352808 :AB20FD73: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-06-29 08:03:52.352837 :AB20FD76: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-06-29 08:03:52.394919 :AB20FD88: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-06-29 08:03:52.398806 :AB20FD90:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 12, nex 15 2025-06-29 08:03:52.398814 :AB20FD91:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f0f where: kddwh01: kdddel 2025-06-29 08:03:52.439133 :AB20FD92: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-06-29 08:03:52.439171 :AB20FD95: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-06-29 08:03:52.439689 :AB20FD9C: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-06-29 08:03:52.485054 :AB20FDA3: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-06-29 08:03:52.489642 :AB20FDAB:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 13, nex 16 2025-06-29 08:03:52.489652 :AB20FDAC:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f23 where: kddwh01: kdddel 2025-06-29 08:03:52.528991 :AB20FDAD: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-06-29 08:03:52.570301 :AB20FDB5: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-06-29 08:03:52.574981 :AB20FDBD:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 14, nex 17 2025-06-29 08:03:52.574989 :AB20FDBE:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f36 where: kddwh01: kdddel 2025-06-29 08:03:52.612310 :AB20FDBF: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-06-29 08:03:52.654040 :AB20FDCF: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-06-29 08:03:52.654069 :AB20FDD2: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-06-29 08:03:52.659180 :AB20FDE4:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 15, nex 18 2025-06-29 08:03:52.659188 :AB20FDE5:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f49 where: kddwh01: kdddel 2025-06-29 08:03:52.696632 :AB20FDE6: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-06-29 08:03:52.696662 :AB20FDE9: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-06-29 08:03:52.738511 :AB20FDFB: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-06-29 08:03:52.743149 :AB20FE03:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 16, nex 19 2025-06-29 08:03:52.743156 :AB20FE04:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f5c where: kddwh01: kdddel 2025-06-29 08:03:52.778908 :AB20FE05: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-06-29 08:03:52.780361 :AB20FE0B: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-06-29 08:03:52.780375 :AB20FE0C: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-06-29 08:03:52.782015 :AB20FE0F: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-06-29 08:03:52.782468 :AB20FE2A: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-06-29 08:03:52.782916 :AB20FE37: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-06-29 08:03:52.824699 :AB20FE49: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-06-29 08:03:52.830816 :AB20FE51:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 17, nex 20 2025-06-29 08:03:52.830825 :AB20FE52:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f6f where: kddwh01: kdddel 2025-06-29 08:03:52.866746 :AB20FE53: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-06-29 08:03:52.908718 :AB20FE5B: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-06-29 08:03:52.915605 :AB20FE6F:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 18, nex 21 2025-06-29 08:03:52.915613 :AB20FE70:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864b84 where: kddwh01: kdddel 2025-06-29 08:03:52.951376 :AB20FE71: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-06-29 08:03:52.993071 :AB20FE79: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-06-29 08:03:53.000296 :AB20FE81:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 19, nex 22 2025-06-29 08:03:53.000305 :AB20FE82:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864b97 where: kddwh01: kdddel 2025-06-29 08:03:53.035197 :AB20FE83: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-06-29 08:03:53.035231 :AB20FE86: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-06-29 08:03:53.077599 :AB20FEA3: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-06-29 08:03:53.084885 :AB20FEAB:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 20, nex 23 2025-06-29 08:03:53.084896 :AB20FEAC:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864baa where: kddwh01: kdddel 2025-06-29 08:03:53.119973 :AB20FEAD: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-06-29 08:03:53.161495 :AB20FEC3: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-06-29 08:03:53.161529 :AB20FEC6: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-06-29 08:03:53.169314 :AB20FED2:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 21, nex 24 2025-06-29 08:03:53.169323 :AB20FED3:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864bbd where: kddwh01: kdddel 2025-06-29 08:03:53.204036 :AB20FED4: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-06-29 08:03:53.246019 :AB20FEDC: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-06-29 08:03:53.254360 :AB20FEE4:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 22, nex 25 2025-06-29 08:03:53.254368 :AB20FEE5:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864bd1 where: kddwh01: kdddel 2025-06-29 08:03:53.288204 :AB20FEE6: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-06-29 08:03:53.329898 :AB20FEEE: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-06-29 08:03:53.329931 :AB20FEF1: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-06-29 08:03:53.338584 :AB20FF03:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 23, nex 26 2025-06-29 08:03:53.338593 :AB20FF04:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864be4 where: kddwh01: kdddel 2025-06-29 08:03:53.372695 :AB20FF05: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-06-29 08:03:53.372728 :AB20FF08: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-06-29 08:03:53.414447 :AB20FF0F: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-06-29 08:03:53.414477 :AB20FF12: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-06-29 08:03:53.422940 :AB20FF19:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 24, nex 27 2025-06-29 08:03:53.422949 :AB20FF1A:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864bf7 where: kddwh01: kdddel 2025-06-29 08:03:53.457090 :AB20FF1B: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-06-29 08:03:53.499027 :AB20FF23: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-06-29 08:03:53.507903 :AB20FF2B:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 25, nex 28 2025-06-29 08:03:53.507912 :AB20FF2C:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fa8c where: kddwh01: kdddel 2025-06-29 08:03:53.541298 :AB20FF2D: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-06-29 08:03:53.583081 :AB20FF35: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-06-29 08:03:53.592646 :AB20FF3D:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 26, nex 29 2025-06-29 08:03:53.592655 :AB20FF3E:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a3904 where: kdiwh22: kdifind 2025-06-29 08:03:53.625296 :AB20FF3F: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-06-29 08:03:53.625329 :AB20FF42: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-06-29 08:03:53.667765 :AB20FF7C: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-06-29 08:03:53.677191 :AB20FF84:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 27, nex 30 2025-06-29 08:03:53.677200 :AB20FF85:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fab2 where: kddwh01: kdddel 2025-06-29 08:03:53.709959 :AB20FF86: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-06-29 08:03:53.751667 :AB20FF8E: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-06-29 08:03:53.761726 :AB20FF96:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 28, nex 31 2025-06-29 08:03:53.761735 :AB20FF97:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a391a where: kdiwh22: kdifind 2025-06-29 08:03:53.793841 :AB20FF98: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-06-29 08:03:53.835373 :AB20FFA0: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-06-29 08:03:53.845862 :AB20FFA8:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 29, nex 32 2025-06-29 08:03:53.845870 :AB20FFA9:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fad9 where: kddwh01: kdddel 2025-06-29 08:03:53.877476 :AB20FFAA: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-06-29 08:03:53.919456 :AB20FFB2: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-06-29 08:03:53.930508 :AB20FFC6:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 30, nex 33 2025-06-29 08:03:53.930516 :AB20FFC7:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087faec where: kddwh01: kdddel 2025-06-29 08:03:53.961644 :AB20FFC8: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-06-29 08:03:53.961674 :AB20FFCB: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-06-29 08:03:54.003880 :AB20FFDD: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-06-29 08:03:54.014655 :AB20FFE5:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 31, nex 34 2025-06-29 08:03:54.014663 :AB20FFE6:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087faff where: kddwh01: kdddel 2025-06-29 08:03:54.046752 :AB21000A: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-06-29 08:03:54.046784 :AB21000D: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-06-29 08:03:54.089019 :AB21001F: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-06-29 08:03:54.089051 :AB210022: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-06-29 08:03:54.100149 :AB210034:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 32, nex 35 2025-06-29 08:03:54.100157 :AB210035:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a2794 where: kddwh01: kdddel 2025-06-29 08:03:54.131744 :AB210036: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-06-29 08:03:54.173589 :AB21003E: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-06-29 08:03:54.184717 :AB210046:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 33, nex 36 2025-06-29 08:03:54.184724 :AB210047:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008958f7 where: kdiwh22: kdifind 2025-06-29 08:03:54.215722 :AB210048: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-06-29 08:03:54.257310 :AB210050: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-06-29 08:03:54.269024 :AB210058:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 34, nex 37 2025-06-29 08:03:54.269035 :AB210059:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27ba where: kddwh01: kdddel 2025-06-29 08:03:54.299844 :AB21005A: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-06-29 08:03:54.329419*:AB210062:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028CBBCC0 estart=1751155431 eid=16777310 ctx=0x00000007738B9F78 cwh=0x0000000028C601B0 cpu=2015625 buffg=392330 interb=0 r=0 rb=0 w=0 wb=0 2025-06-29 08:03:54.329419*:AB210063:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028CBBCC0 2025-06-29 08:03:54.341707 :AB210064: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-06-29 08:03:54.341739 :AB210067: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-06-29 08:03:54.353850 :AB210084:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 35, nex 38 2025-06-29 08:03:54.353858 :AB210085:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27ce where: kddwh01: kdddel 2025-06-29 08:03:54.384343 :AB210086: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-06-29 08:03:54.425701 :AB21008E: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-06-29 08:03:54.437959 :AB210096:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 36, nex 39 2025-06-29 08:03:54.437967 :AB210097:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27e1 where: kddwh01: kdddel 2025-06-29 08:03:54.470562 :AB210098: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-06-29 08:03:54.515008 :AB2100A7: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-06-29 08:03:54.528254 :AB2100AF:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 37, nex 40 2025-06-29 08:03:54.528263 :AB2100B0:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27f4 where: kddwh01: kdddel 2025-06-29 08:03:54.558622 :AB2100B1: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-06-29 08:03:54.602656 :AB2100B9: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-06-29 08:03:54.615276 :AB2100D1:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 38, nex 41 2025-06-29 08:03:54.615284 :AB2100D2:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008c12b0 where: kddwh01: kdddel 2025-06-29 08:03:54.638332 :AB2100E6: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-06-29 08:03:54.639687 :AB2100EC: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-06-29 08:03:54.639702 :AB2100ED: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-06-29 08:03:54.641341 :AB2100F0: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-06-29 08:03:54.641699 :AB210108: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-06-29 08:03:54.657547*:AB210120:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028CBBCC0 curCtx=0x0000000028C62158 xsc->flg4=65792 flags=2 2025-06-29 08:03:54.657547*:AB210121:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028CBBCC0 2025-06-29 08:03:54.685723 :AB210122: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-06-29 08:03:54.699454 :AB21012A: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-06-29 08:03:56.925634*:AB21027D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028CE1768 curCtx=0x0000000028C62170 xsc->flg4=65792 flags=4 2025-06-29 08:03:56.925634*:AB21027E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028CE1768 2025-06-29 08:03:56.967728 :AB2102B1: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-06-29 08:03:57.010611 :AB2102C9: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: 12572, M000)