Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250805082851\orcl_m000_20396_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:35714M/63366M, Ph+PgF:41261M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 22 Windows thread id: 20396, image: ORACLE.EXE (M000) *** 2025-08-05 08:28:51.891 *** SESSION ID:(177.25843) 2025-08-05 08:28:51.891 *** 2025-08-05 08:28:51.891 Process diagnostic dump for ORACLE.EXE (M000), OS id=20396, pid: 22, proc_ser: 8, sid: 177, sess_ser: 25843 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.474761 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.474801 sec since last wait 0: waited for 'RMAN backup & recovery I/O' count=0x1, intr=0x0, timeout=0xffffffff wait_id=327 seq_num=328 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.000008 sec of elapsed time 1: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x2, filetype=0x2 wait_id=326 seq_num=327 snap_id=1 wait times: snap=0.000123 sec, exc=0.000123 sec, total=0.000123 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=325 seq_num=326 snap_id=1 wait times: snap=0.000211 sec, exc=0.000211 sec, total=0.000211 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.038969 sec of elapsed time 3: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=324 seq_num=325 snap_id=1 wait times: snap=0.000049 sec, exc=0.000049 sec, total=0.000049 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000001 sec of elapsed time 4: waited for 'log file sequential read' log#=0x298e, block#=0x0, blocks=0x0 wait_id=323 seq_num=324 snap_id=1 wait times: snap=0.000000 sec, exc=0.000000 sec, total=0.000000 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 5: waited for 'log file sequential read' log#=0x298e, block#=0x0, blocks=0x0 wait_id=322 seq_num=323 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.000005 sec of elapsed time 6: waited for 'log file sequential read' log#=0x0, block#=0x2, blocks=0x7fe wait_id=321 seq_num=322 snap_id=1 wait times: snap=0.000267 sec, exc=0.000267 sec, total=0.000267 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time 7: waited for 'log file sequential read' log#=0x298e, block#=0x2, blocks=0x7fe wait_id=320 seq_num=321 snap_id=1 wait times: snap=0.000205 sec, exc=0.000205 sec, total=0.000205 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000143 sec of elapsed time 8: waited for 'log file sequential read' log#=0x0, block#=0x1, blocks=0x1 wait_id=319 seq_num=320 snap_id=1 wait times: snap=0.000045 sec, exc=0.000045 sec, total=0.000045 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000002 sec of elapsed time 9: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x0, filetype=0x3 wait_id=318 seq_num=319 snap_id=1 wait times: snap=0.000211 sec, exc=0.000211 sec, total=0.000211 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000129 sec of elapsed time Sampled Session History of session 177 serial 25843 --------------------------------------------------- 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:28:45 - 08:28:50] not in wait at each sample [1 sample, 08:28:44] idle wait at each sample [session created at: 08:28:45] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-05 08:28:51.891 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 22 (osid: 20396, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-05 08:28:46.223394 :BB97651B:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00808ec5 where: kdiwh22: kdifind 2025-08-05 08:28:46.259339 :BB97651C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.259378 :BB97651F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.304712 :BB976531:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.315318 :BB976539:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 7, nex 9 2025-08-05 08:28:46.315328 :BB97653A:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x0080feb8 where: kddwh01: kdddel 2025-08-05 08:28:46.349791 :BB97653B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.394175 :BB976543:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.406510 :BB97654B:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 8, nex 10 2025-08-05 08:28:46.406519 :BB97654C:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00815485 where: kddwh01: kdddel 2025-08-05 08:28:46.439695 :BB97654D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.485217 :BB976560:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.485247 :BB976563:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.498913 :BB976575:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 9, nex 11 2025-08-05 08:28:46.498922 :BB976576:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00813423 where: kddwh01: kdddel 2025-08-05 08:28:46.531890 :BB976577:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.531954 :BB97657D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.577763 :BB9765B7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.577802 :BB9765BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.592334 :BB9765CC:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 10, nex 12 2025-08-05 08:28:46.592344 :BB9765CD:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x0081ae80 where: kddwh01: kdddel 2025-08-05 08:28:46.624387 :BB9765CE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.624426 :BB9765D1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.667879 :BB9765E3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.672566*:BB9765EB:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000000FCDA968 estart=1754353725 eid=16777345 ctx=0x00000007738B9F78 cwh=0x000000000FC801B0 cpu=531250 buffg=95550 interb=0 r=0 rb=0 w=0 wb=0 2025-08-05 08:28:46.672566*:BB9765EC:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000000FCDA968 curCtx=0x000000000FD3FE68 pubTabIdxCnt=0 2025-08-05 08:28:46.672566*:BB9765ED:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000000FCDA968 2025-08-05 08:28:46.672566*:BB9765EE:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000000FCDA968 2025-08-05 08:28:46.680925 :BB9765EF:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 11, nex 13 2025-08-05 08:28:46.680934 :BB9765F0:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00811e64 where: kddwh01: kdddel 2025-08-05 08:28:46.711046 :BB9765F1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.753980 :BB9765F9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.767573 :BB976601:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 12, nex 14 2025-08-05 08:28:46.767581 :BB976602:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00825f11 where: kddwh01: kdddel 2025-08-05 08:28:46.797164 :BB976603:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.840839 :BB97660B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.840873 :BB97660E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.855272 :BB976620:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 13, nex 15 2025-08-05 08:28:46.855280 :BB976621:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00825f24 where: kddwh01: kdddel 2025-08-05 08:28:46.884874 :BB976622:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.927671 :BB97662A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:46.941858 :BB97663E:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 14, nex 16 2025-08-05 08:28:46.941867 :BB97663F:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00825f38 where: kddwh01: kdddel 2025-08-05 08:28:46.971077 :BB976640:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.013792 :BB976648:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.028373 :BB976650:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 15, nex 17 2025-08-05 08:28:47.028382 :BB976651:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00825f4b where: kddwh01: kdddel 2025-08-05 08:28:47.056859 :BB976652:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.056891 :BB976655:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.099753 :BB976667:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.099782 :BB97666A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.114440 :BB97667C:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 16, nex 18 2025-08-05 08:28:47.114448 :BB97667D:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00825f5e where: kddwh01: kdddel 2025-08-05 08:28:47.142966 :BB97667E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.185511 :BB97668E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.200540 :BB976696:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 17, nex 19 2025-08-05 08:28:47.200548 :BB976697:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00825f71 where: kddwh01: kdddel 2025-08-05 08:28:47.228416 :BB976698:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.271490 :BB9766A0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.271522 :BB9766A3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.287228 :BB9766B5:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 18, nex 20 2025-08-05 08:28:47.287237 :BB9766B6:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00864b86 where: kddwh01: kdddel 2025-08-05 08:28:47.289069 :BB9766B7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.290330 :BB9766BD:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-05 08:28:47.290343 :BB9766BE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.292046 :BB9766C1:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-05 08:28:47.292410 :BB9766DB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.335643 :BB9766F3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.376763 :BB9766FB:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 19, nex 21 2025-08-05 08:28:47.376771 :BB9766FC:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00864b99 where: kddwh01: kdddel 2025-08-05 08:28:47.378761 :BB9766FD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.421296 :BB976705:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.421331 :BB976708:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.462732 :BB97670F:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 20, nex 22 2025-08-05 08:28:47.462740 :BB976710:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00864bac where: kddwh01: kdddel 2025-08-05 08:28:47.464203 :BB976711:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.506574 :BB976719:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.506606 :BB97671C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.548384 :BB976723:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 21, nex 23 2025-08-05 08:28:47.548394 :BB976724:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00864bbf where: kddwh01: kdddel 2025-08-05 08:28:47.549278 :BB976725:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.591657 :BB97672D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.634015 :BB976735:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 22, nex 24 2025-08-05 08:28:47.634024 :BB976736:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00864bd3 where: kddwh01: kdddel 2025-08-05 08:28:47.634378 :BB976737:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.634405 :BB97673A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.677187 :BB97674C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.719470 :BB976754:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 23, nex 25 2025-08-05 08:28:47.719478 :BB976755:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00864be6 where: kddwh01: kdddel 2025-08-05 08:28:47.719891 :BB976756:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.762297 :BB97675E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.762327 :BB976761:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.805146 :BB976768:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 24, nex 26 2025-08-05 08:28:47.805154 :BB976769:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00864bf9 where: kddwh01: kdddel 2025-08-05 08:28:47.805241 :BB97676A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.847951 :BB976772:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.890556 :BB97677A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.891339 :BB976782:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 25, nex 27 2025-08-05 08:28:47.891347 :BB976783:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x0087fa8e where: kddwh01: kdddel 2025-08-05 08:28:47.933452 :BB976784:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.975983 :BB976798:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:47.977313 :BB9767AE:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 26, nex 28 2025-08-05 08:28:47.977321 :BB9767AF:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x0087faa1 where: kddwh01: kdddel 2025-08-05 08:28:48.019095 :BB9767BB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.061462 :BB9767C3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.063351 :BB9767CB:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 27, nex 29 2025-08-05 08:28:48.063358 :BB9767CC:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x0086aee6 where: kdiwh22: kdifind 2025-08-05 08:28:48.104377 :BB9767CD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.146446 :BB9767D5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.148992 :BB9767DD:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 28, nex 30 2025-08-05 08:28:48.148999 :BB9767DE:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x0087fac8 where: kddwh01: kdddel 2025-08-05 08:28:48.189133 :BB976807:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.231280 :BB97681A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.234249 :BB976822:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 29, nex 31 2025-08-05 08:28:48.234256 :BB976823:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x0087fadb where: kddwh01: kdddel 2025-08-05 08:28:48.274007 :BB976824:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.274041 :BB976827:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.317123 :BB97685C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.319836 :BB976864:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 30, nex 32 2025-08-05 08:28:48.319843 :BB976865:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x0087faee where: kddwh01: kdddel 2025-08-05 08:28:48.360001 :BB976866:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.360038 :BB976869:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.402743 :BB976870:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.402777 :BB976873:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.406353 :BB976885:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 31, nex 33 2025-08-05 08:28:48.406364 :BB976886:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x008a2783 where: kddwh01: kdddel 2025-08-05 08:28:48.450141 :BB9768A1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.496217 :BB9768A9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.499966 :BB9768B1:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 32, nex 34 2025-08-05 08:28:48.499976 :BB9768B2:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x008a2796 where: kddwh01: kdddel 2025-08-05 08:28:48.542951 :BB9768B3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.542983 :BB9768B6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.589753 :BB9768C8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.589790 :BB9768CB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.593630 :BB9768DD:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 33, nex 35 2025-08-05 08:28:48.593640 :BB9768DE:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x008a27a9 where: kddwh01: kdddel 2025-08-05 08:28:48.637170 :BB9768DF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.682557*:BB9768E7:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000000FCDA968 estart=1754353725 eid=16777345 ctx=0x00000007738B9F78 cwh=0x000000000FC801B0 cpu=2015625 buffg=382127 interb=0 r=0 rb=0 w=0 wb=0 2025-08-05 08:28:48.682557*:BB9768E8:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000000FCDA968 2025-08-05 08:28:48.683563 :BB9768E9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.687273 :BB9768F1:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 34, nex 36 2025-08-05 08:28:48.687281 :BB9768F2:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x008a27bc where: kddwh01: kdddel 2025-08-05 08:28:48.727053 :BB9768F3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.769596 :BB9768FB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.773794 :BB976903:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 35, nex 37 2025-08-05 08:28:48.773801 :BB976904:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x008c0022 where: kdiwh22: kdifind 2025-08-05 08:28:48.812642 :BB976905:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.855098 :BB97690D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.859783 :BB976915:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 36, nex 38 2025-08-05 08:28:48.859792 :BB976916:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x008a27e3 where: kddwh01: kdddel 2025-08-05 08:28:48.898112 :BB976917:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.898145 :BB97691A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:48.945760 :BB97697F:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 37, nex 39 2025-08-05 08:28:48.945767 :BB976980:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x008a27f6 where: kddwh01: kdddel 2025-08-05 08:28:49.000854 :BB9769A3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:49.000887 :BB9769A6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-05 08:28:49.038211 :BB9769AD:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 10, ext 38, nex 40 2025-08-05 08:28:49.038220 :BB9769AE:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x008c12db where: kddwh01: kdddel 2025-08-05 08:28:49.047337 :BB9769AF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:49.047368 :BB9769B2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:49.057568*:BB9769CC:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000000FCDA968 curCtx=0x000000000FD3FE68 xsc->flg4=65792 flags=2 2025-08-05 08:28:49.057568*:BB9769CD:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000000FCDA968 2025-08-05 08:28:49.093558 :BB9769CE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:49.111042 :BB9769D6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=16 loc='ksr2.h LINE:603 ID:ksrpublish' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.430053*:BB976B89:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000000FCDA4D8 curCtx=0x000000000FD3FE80 xsc->flg4=65792 flags=4 2025-08-05 08:28:51.430053*:BB976B8A:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000000FCDA4D8 2025-08-05 08:28:51.431250 :BB976B8B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.472264 :BB976BA7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.514433 :BB976BAF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.514458 :BB976BB2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.556662 :BB976BC4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.598932 :BB976C9D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.598967 :BB976CA0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.644362 :BB976DC5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.644389 :BB976DC8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.644922 :BB976DCF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.687445 :BB976DD6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.730035 :BB976DDE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.772501 :BB976DE6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-05 08:28:51.885321 :BB976E2F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] 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 22 (osid: 20396, M000)