Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250623080020\orcl_m000_13916_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:36340M/63366M, Ph+PgF:42568M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 13916, image: ORACLE.EXE (M000) *** 2025-06-23 08:00:20.732 *** SESSION ID:(209.1159) 2025-06-23 08:00:20.732 *** 2025-06-23 08:00:20.732 Process diagnostic dump for ORACLE.EXE (M000), OS id=13916, pid: 26, proc_ser: 188, sid: 209, sess_ser: 1159 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.128861 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.128886 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.000066 sec, exc=0.000066 sec, total=0.000066 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=311 seq_num=312 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.000004 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.000208 sec, exc=0.000208 sec, total=0.000208 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.036952 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.000168 sec, exc=0.000168 sec, total=0.000168 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#=0x2893, block#=0x0, blocks=0x0 wait_id=308 seq_num=309 snap_id=1 wait times: snap=0.000005 sec, exc=0.000005 sec, total=0.000005 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.016429 sec of elapsed time 5: waited for 'log file sequential read' log#=0x2893, block#=0x0, blocks=0x0 wait_id=307 seq_num=308 snap_id=1 wait times: snap=0.000014 sec, exc=0.000014 sec, total=0.000014 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.021548 sec of elapsed time 6: waited for 'log file sequential read' log#=0x0, block#=0x15000, blocks=0x800 wait_id=306 seq_num=307 snap_id=1 wait times: snap=0.000367 sec, exc=0.000367 sec, total=0.000367 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.172281 sec of elapsed time 7: waited for 'log file sequential read' log#=0x2893, block#=0x800, blocks=0x800 wait_id=305 seq_num=306 snap_id=1 wait times: snap=0.000200 sec, exc=0.000200 sec, total=0.000200 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000191 sec of elapsed time 8: waited for 'log file sequential read' log#=0x2893, block#=0x0, blocks=0x0 wait_id=304 seq_num=305 snap_id=1 wait times: snap=0.000002 sec, exc=0.000002 sec, total=0.000002 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000124 sec of elapsed time 9: waited for 'log file sequential read' log#=0x2893, block#=0x2, blocks=0x7fe wait_id=303 seq_num=304 snap_id=1 wait times: snap=0.000194 sec, exc=0.000194 sec, total=0.000194 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000159 sec of elapsed time Sampled Session History of session 209 serial 1159 --------------------------------------------------- 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 --------------------------------------------------- [7 samples, 08:00:14 - 08:00:20] not in wait at each sample [1 sample, 08:00:13] idle wait at each sample [session created at: 08:00:14] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-06-23 08:00:20.732 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 13916, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-23 08:00:15.386301 :A8768B19: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-06-23 08:00:15.427919 :A8768B21: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-06-23 08:00:15.427950 :A8768B24: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-06-23 08:00:15.467279 :A8768B36:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 5, nex 9 2025-06-23 08:00:15.467287 :A8768B37:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0080f16a where: kddwh01: kdddel 2025-06-23 08:00:15.470542 :A8768B38: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-06-23 08:00:15.470574 :A8768B3B: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-06-23 08:00:15.511739 :A8768B4D: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-06-23 08:00:15.511768 :A8768B50: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-06-23 08:00:15.550865 :A8768B62:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 6, nex 10 2025-06-23 08:00:15.550873 :A8768B63:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00817ec1 where: kdiwh22: kdifind 2025-06-23 08:00:15.553507 :A8768B64: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-06-23 08:00:15.553536 :A8768B67: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-06-23 08:00:15.595273 :A8768B79: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-06-23 08:00:15.638615 :A8768B8D:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 7, nex 11 2025-06-23 08:00:15.638626 :A8768B8E:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0081057e where: kddwh01: kdddel 2025-06-23 08:00:15.640421 :A8768B8F: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-06-23 08:00:15.640453 :A8768B92: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-06-23 08:00:15.684948 :A8768BA4: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-06-23 08:00:15.684981 :A8768BA7: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-06-23 08:00:15.726136 :A8768BB9:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 8, nex 12 2025-06-23 08:00:15.726144 :A8768BBA:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0081660c where: kdiwh22: kdifind 2025-06-23 08:00:15.727651 :A8768BBB: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-06-23 08:00:15.727680 :A8768BBE: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-06-23 08:00:15.769308 :A8768BC5: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-06-23 08:00:15.810990 :A8768BCD:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 9, nex 13 2025-06-23 08:00:15.810998 :A8768BCE:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0081ae87 where: kddwh01: kdddel 2025-06-23 08:00:15.811304 :A8768BCF: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-06-23 08:00:15.852953 :A8768BD7: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-06-23 08:00:15.852987 :A8768BDA: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-06-23 08:00:15.873058*:A8768BEC:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000027B11EA8 estart=1750636814 eid=16777304 ctx=0x00000007738B9F78 cwh=0x0000000027A801B0 cpu=515625 buffg=98854 interb=0 r=0 rb=0 w=0 wb=0 2025-06-23 08:00:15.873058*:A8768BED:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000027B11EA8 curCtx=0x0000000028B9FE68 pubTabIdxCnt=0 2025-06-23 08:00:15.873058*:A8768BEE:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000027B11EA8 2025-06-23 08:00:15.873058*:A8768BEF:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000027B11EA8 2025-06-23 08:00:15.895567 :A8768BF0:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 10, nex 14 2025-06-23 08:00:15.895574 :A8768BF1:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f05 where: kddwh01: kdddel 2025-06-23 08:00:15.895992 :A8768BF2: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-06-23 08:00:15.937971 :A8768BFA: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-06-23 08:00:15.979734 :A8768C02: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-06-23 08:00:15.980348 :A8768C0A:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 11, nex 15 2025-06-23 08:00:15.980355 :A8768C0B:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f18 where: kddwh01: kdddel 2025-06-23 08:00:16.022148 :A8768C0C: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-06-23 08:00:16.063958 :A8768C14: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-06-23 08:00:16.065046 :A8768C1C:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 12, nex 16 2025-06-23 08:00:16.065053 :A8768C1D:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f2b where: kddwh01: kdddel 2025-06-23 08:00:16.106134 :A8768C1E: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-06-23 08:00:16.106165 :A8768C21: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-06-23 08:00:16.106687 :A8768C28: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-06-23 08:00:16.148874 :A8768C2F: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-06-23 08:00:16.150010 :A8768C37:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 13, nex 17 2025-06-23 08:00:16.150017 :A8768C38:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f3f where: kddwh01: kdddel 2025-06-23 08:00:16.191435 :A8768C39: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-06-23 08:00:16.233544 :A8768C69: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-06-23 08:00:16.235124 :A8768C71:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 14, nex 18 2025-06-23 08:00:16.235131 :A8768C72:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f52 where: kddwh01: kdddel 2025-06-23 08:00:16.275807 :A8768C73: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-06-23 08:00:16.317625 :A8768C83: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-06-23 08:00:16.319803 :A8768C8B:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 15, nex 19 2025-06-23 08:00:16.319810 :A8768C8C:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f65 where: kddwh01: kdddel 2025-06-23 08:00:16.360027 :A8768C8D: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-06-23 08:00:16.360056 :A8768C90: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-06-23 08:00:16.402460 :A8768CA2: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-06-23 08:00:16.404873 :A8768CAA:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 16, nex 20 2025-06-23 08:00:16.404880 :A8768CAB:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00825f78 where: kddwh01: kdddel 2025-06-23 08:00:16.442830 :A8768CAC: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-06-23 08:00:16.444223 :A8768CB2: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-06-23 08:00:16.444239 :A8768CB3: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-06-23 08:00:16.445966 :A8768CB6: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-06-23 08:00:16.446369 :A8768CD3: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-06-23 08:00:16.489140 :A8768CEB: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-06-23 08:00:16.494075 :A8768CF3:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 17, nex 21 2025-06-23 08:00:16.494083 :A8768CF4:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864b8d where: kddwh01: kdddel 2025-06-23 08:00:16.531463 :A8768CF5: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-06-23 08:00:16.573715 :A8768CFD: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-06-23 08:00:16.573746 :A8768D00: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-06-23 08:00:16.579287 :A8768D12:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 18, nex 22 2025-06-23 08:00:16.579295 :A8768D13:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864ba0 where: kddwh01: kdddel 2025-06-23 08:00:16.617094 :A8768D14: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-06-23 08:00:16.659636 :A8768D28: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-06-23 08:00:16.665084 :A8768D30:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 19, nex 23 2025-06-23 08:00:16.665091 :A8768D31:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0086aeb0 where: kdiwh22: kdifind 2025-06-23 08:00:16.701743 :A8768D32: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-06-23 08:00:16.743765 :A8768D3A: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-06-23 08:00:16.749743 :A8768D42:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 20, nex 24 2025-06-23 08:00:16.749751 :A8768D43:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bc6 where: kddwh01: kdddel 2025-06-23 08:00:16.786077 :A8768D44: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-06-23 08:00:16.827790 :A8768D4C: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-06-23 08:00:16.827822 :A8768D4F: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-06-23 08:00:16.834265 :A8768D61:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 21, nex 25 2025-06-23 08:00:16.834273 :A8768D62:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bda where: kddwh01: kdddel 2025-06-23 08:00:16.870435 :A8768D63: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-06-23 08:00:16.870464 :A8768D66: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-06-23 08:00:16.912940 :A8768D78: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-06-23 08:00:16.918891 :A8768D80:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 22, nex 26 2025-06-23 08:00:16.918899 :A8768D81:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x00864bed where: kddwh01: kdddel 2025-06-23 08:00:16.955360 :A8768D82: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-06-23 08:00:16.997500 :A8768D8A: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-06-23 08:00:16.997534 :A8768D8D: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-06-23 08:00:17.003820 :A8768D94:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 23, nex 27 2025-06-23 08:00:17.003829 :A8768D95:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fa82 where: kddwh01: kdddel 2025-06-23 08:00:17.039944 :A8768D9E: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-06-23 08:00:17.039964 :A8768DA1: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-06-23 08:00:17.040520 :A8768DAD: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-06-23 08:00:17.082674 :A8768DCA: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-06-23 08:00:17.088992 :A8768DD2:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 24, nex 28 2025-06-23 08:00:17.089000 :A8768DD3:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fa95 where: kddwh01: kdddel 2025-06-23 08:00:17.125089 :A8768DDF: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-06-23 08:00:17.166779 :A8768DE7: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-06-23 08:00:17.173579 :A8768DEF:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 25, nex 29 2025-06-23 08:00:17.173587 :A8768DF0:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0086aec4 where: kdiwh22: kdifind 2025-06-23 08:00:17.209001 :A8768E01: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-06-23 08:00:17.209034 :A8768E04: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-06-23 08:00:17.250762 :A8768E10: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-06-23 08:00:17.258159 :A8768E18:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 26, nex 30 2025-06-23 08:00:17.258175 :A8768E19:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fabb where: kddwh01: kdddel 2025-06-23 08:00:17.292946 :A8768E1A: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-06-23 08:00:17.334617 :A8768E22: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-06-23 08:00:17.342563 :A8768E2A:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 27, nex 31 2025-06-23 08:00:17.342571 :A8768E2B:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0086d90e where: kdiwh22: kdifind 2025-06-23 08:00:17.376658 :A8768E2C: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-06-23 08:00:17.418300 :A8768E34: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-06-23 08:00:17.418333 :A8768E37: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-06-23 08:00:17.426679 :A8768E49:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 28, nex 32 2025-06-23 08:00:17.426687 :A8768E4A:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087fae2 where: kddwh01: kdddel 2025-06-23 08:00:17.460962 :A8768E4B: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-06-23 08:00:17.502603 :A8768E53: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-06-23 08:00:17.510943 :A8768E5B:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 29, nex 33 2025-06-23 08:00:17.510951 :A8768E5C:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x0087faf5 where: kddwh01: kdddel 2025-06-23 08:00:17.544893 :A8768E5D: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-06-23 08:00:17.586563 :A8768E88: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-06-23 08:00:17.595403 :A8768E90:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 30, nex 34 2025-06-23 08:00:17.595411 :A8768E91:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a278a where: kddwh01: kdddel 2025-06-23 08:00:17.633664 :A8768E9A: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-06-23 08:00:17.633693 :A8768E9D: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-06-23 08:00:17.692292 :A8768EB3: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-06-23 08:00:17.704950 :A8768EBB:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 31, nex 35 2025-06-23 08:00:17.704961 :A8768EBC:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a279d where: kddwh01: kdddel 2025-06-23 08:00:17.751371 :A8768EBD: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-06-23 08:00:17.751411 :A8768EC0: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-06-23 08:00:17.751922 :A8768EC7: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-06-23 08:00:17.810435 :A8768ED3: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-06-23 08:00:17.810474 :A8768ED6: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-06-23 08:00:17.823366 :A8768EE8:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 32, nex 36 2025-06-23 08:00:17.823378 :A8768EE9:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27b0 where: kddwh01: kdddel 2025-06-23 08:00:17.870656 :A8768EFD: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-06-23 08:00:17.870699 :A8768F00: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-06-23 08:00:17.883059*:A8768F12:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000027B11EA8 estart=1750636814 eid=16777304 ctx=0x00000007738B9F78 cwh=0x0000000027A801B0 cpu=2015625 buffg=377424 interb=0 r=0 rb=0 w=0 wb=0 2025-06-23 08:00:17.883059*:A8768F13:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000027B11EA8 2025-06-23 08:00:17.929721 :A8768F14: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-06-23 08:00:17.929763 :A8768F17: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-06-23 08:00:17.939313 :A8768F29:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 33, nex 37 2025-06-23 08:00:17.939321 :A8768F2A:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27c3 where: kddwh01: kdddel 2025-06-23 08:00:17.972815 :A8768F2B: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-06-23 08:00:17.972844 :A8768F2E: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-06-23 08:00:17.973360 :A8768F35: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-06-23 08:00:18.015202 :A8768F3C: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-06-23 08:00:18.024125 :A8768F44:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 34, nex 38 2025-06-23 08:00:18.024133 :A8768F45:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27d7 where: kddwh01: kdddel 2025-06-23 08:00:18.057397 :A8768F46: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-06-23 08:00:18.057428 :A8768F49: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-06-23 08:00:18.099315 :A8768F50: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-06-23 08:00:18.108485 :A8768F58:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 35, nex 39 2025-06-23 08:00:18.108496 :A8768F59:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27ea where: kddwh01: kdddel 2025-06-23 08:00:18.141466 :A8768F5A: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-06-23 08:00:18.183054 :A8768F6D: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-06-23 08:00:18.192502 :A8768F75:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 36, nex 40 2025-06-23 08:00:18.192510 :A8768F76:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008a27fd where: kddwh01: kdddel 2025-06-23 08:00:18.227809 :A8768F77: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-06-23 08:00:18.273479 :A8768F87: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-06-23 08:00:18.273680*:A8768F8F:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000027B11EA8 curCtx=0x0000000028B9FE68 xsc->flg4=65792 flags=2 2025-06-23 08:00:18.273680*:A8768F90:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000027B11EA8 2025-06-23 08:00:18.285682 :A8768F91:db_trace:ktu.c@4871:ktuaex1r(): [10442:26:209] Extension usn 10, ext 37, nex 41 2025-06-23 08:00:18.285691 :A8768F92:db_trace:ktusm.c@2117:ktusmasp(): [10445:26:209] des1:tsn:1 rdba:0x008160f0 where: kdiwh22: kdifind 2025-06-23 08:00:18.323334 :A8768F93: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-06-23 08:00:20.623675*:A876918D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000027B11B48 curCtx=0x0000000028B9FE80 xsc->flg4=65792 flags=4 2025-06-23 08:00:20.623675*:A876918E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000027B11B48 2025-06-23 08:00:20.736917 :A8769227: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-06-23 08:00:20.736952 :A876922A: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-06-23 08:00:20.737556 :A8769232: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 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 26 (osid: 13916, M000)