Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250726222249\orcl_m000_19156_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:36035M/63366M, Ph+PgF:41818M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 27 Windows thread id: 19156, image: ORACLE.EXE (M000) *** 2025-07-26 22:22:49.380 *** SESSION ID:(219.3297) 2025-07-26 22:22:49.380 *** 2025-07-26 22:22:49.380 Process diagnostic dump for ORACLE.EXE (M000), OS id=19156, pid: 27, proc_ser: 240, sid: 219, sess_ser: 3297 ------------------------------------------------------------------------------- current sql: Current Wait Stack: Not in wait; last wait ended 0.170010 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.170048 sec since last wait 0: waited for 'RMAN backup & recovery I/O' count=0x1, intr=0x0, timeout=0xffffffff wait_id=215 seq_num=216 snap_id=1 wait times: snap=0.000083 sec, exc=0.000083 sec, total=0.000083 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=214 seq_num=215 snap_id=1 wait times: snap=0.000132 sec, exc=0.000132 sec, total=0.000132 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000008 sec of elapsed time 2: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x2, filetype=0x2 wait_id=213 seq_num=214 snap_id=1 wait times: snap=0.000292 sec, exc=0.000292 sec, total=0.000292 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 1.327223 sec of elapsed time 3: waited for 'control file sequential read' file#=0x0, block#=0x20, blocks=0x1 wait_id=212 seq_num=213 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.000006 sec of elapsed time 4: waited for 'control file sequential read' file#=0x0, block#=0x17, blocks=0x1 wait_id=211 seq_num=212 snap_id=1 wait times: snap=0.000046 sec, exc=0.000046 sec, total=0.000046 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000008 sec of elapsed time 5: waited for 'control file sequential read' file#=0x0, block#=0x11, blocks=0x1 wait_id=210 seq_num=211 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.000004 sec of elapsed time 6: waited for 'control file sequential read' file#=0x0, block#=0xf, blocks=0x1 wait_id=209 seq_num=210 snap_id=1 wait times: snap=0.000052 sec, exc=0.000052 sec, total=0.000052 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000005 sec of elapsed time 7: waited for 'control file sequential read' file#=0x1, block#=0x1, blocks=0x1 wait_id=208 seq_num=209 snap_id=1 wait times: snap=0.000051 sec, exc=0.000051 sec, total=0.000051 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000008 sec of elapsed time 8: waited for 'control file sequential read' file#=0x0, block#=0x1, blocks=0x1 wait_id=207 seq_num=208 snap_id=1 wait times: snap=0.000087 sec, exc=0.000087 sec, total=0.000087 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time 9: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x1, filetype=0x1 wait_id=206 seq_num=207 snap_id=1 wait times: snap=0.000059 sec, exc=0.000059 sec, total=0.000059 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time Sampled Session History of session 219 serial 3297 --------------------------------------------------- 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 --------------------------------------------------- [5 samples, 22:22:44 - 22:22:48] not in wait at each sample [1 sample, 22:22:43] idle wait at each sample [session created at: 22:22:44] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-26 22:22:49.380 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 27 (osid: 19156, M000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-26 22:22:44.981750 :B76582F5: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-07-26 22:22:44.981782 :B76582F8: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-07-26 22:22:45.024488 :B765830A: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-07-26 22:22:45.050131 :B7658312:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 7, nex 9 2025-07-26 22:22:45.050139 :B7658313:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0081357a where: kdiwh22: kdifind 2025-07-26 22:22:45.067247 :B7658314: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-07-26 22:22:45.108798 :B765831C: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-07-26 22:22:45.135771 :B7658324:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 8, nex 10 2025-07-26 22:22:45.135780 :B7658325:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00810553 where: kdiwh22: kdifind 2025-07-26 22:22:45.150872 :B7658326: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-07-26 22:22:45.193055 :B765832E: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-07-26 22:22:45.221294 :B7658336:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 9, nex 11 2025-07-26 22:22:45.221302 :B7658337:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0081a24d where: kdiwh22: kdifind 2025-07-26 22:22:45.235537 :B7658338: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-07-26 22:22:45.235568 :B765833B: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-07-26 22:22:45.277944 :B7658342: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-07-26 22:22:45.307211 :B7658355:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 10, nex 12 2025-07-26 22:22:45.307219 :B7658356:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0081357f where: kdiwh22: kdifind 2025-07-26 22:22:45.320113 :B7658357: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-07-26 22:22:45.362014 :B765835F: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-07-26 22:22:45.362044 :B7658362: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-07-26 22:22:45.392183 :B7658374:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 11, nex 13 2025-07-26 22:22:45.392192 :B7658375:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00811dff where: kddwh01: kdddel 2025-07-26 22:22:45.404982 :B7658376: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-07-26 22:22:45.440410*:B765837E:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002996BDF0 estart=1753539764 eid=16777336 ctx=0x00000007738B9F78 cwh=0x00000000295E01B0 cpu=531250 buffg=101949 interb=0 r=0 rb=0 w=0 wb=0 2025-07-26 22:22:45.440410*:B765837F:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002996BDF0 curCtx=0x00000000299CFE68 pubTabIdxCnt=0 2025-07-26 22:22:45.440410*:B7658380:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002996BDF0 2025-07-26 22:22:45.440410*:B7658381:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002996BDF0 2025-07-26 22:22:45.447291 :B7658382: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-07-26 22:22:45.447320 :B7658385: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-07-26 22:22:45.477819 :B7658397:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 12, nex 14 2025-07-26 22:22:45.477828 :B7658398:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f0c where: kddwh01: kdddel 2025-07-26 22:22:45.490502 :B7658399: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-07-26 22:22:45.490531 :B765839C: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-07-26 22:22:45.533109 :B76583AE: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-07-26 22:22:45.563306 :B76583B6:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 13, nex 15 2025-07-26 22:22:45.563315 :B76583B7:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f1f where: kddwh01: kdddel 2025-07-26 22:22:45.575702 :B76583B8: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-07-26 22:22:45.618031 :B76583C0: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-07-26 22:22:45.618061 :B76583C3: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-07-26 22:22:45.618556 :B76583CA: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-07-26 22:22:45.648357 :B76583D1:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 14, nex 16 2025-07-26 22:22:45.648365 :B76583D2:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f32 where: kddwh01: kdddel 2025-07-26 22:22:45.660848 :B76583D3: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-07-26 22:22:45.703442 :B76583DB: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-07-26 22:22:45.734494 :B76583F6:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 15, nex 17 2025-07-26 22:22:45.734502 :B76583F7:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f45 where: kddwh01: kdddel 2025-07-26 22:22:45.746379 :B76583F8: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-07-26 22:22:45.791291 :B7658400: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-07-26 22:22:45.791331 :B7658403: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-07-26 22:22:45.825003 :B7658415:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 16, nex 18 2025-07-26 22:22:45.825013 :B7658416:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0081085e where: kdiwh22: kdifind 2025-07-26 22:22:45.838011 :B7658461: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-07-26 22:22:45.838052 :B7658464: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-07-26 22:22:45.884441 :B7658482: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-07-26 22:22:45.884483 :B7658485: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-07-26 22:22:45.895079 :B7658497: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-07-26 22:22:45.896267 :B765849D: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-07-26 22:22:45.896288 :B765849E: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-07-26 22:22:45.897934 :B76584A1: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-07-26 22:22:45.898387 :B76584BD: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-07-26 22:22:45.919588 :B76584D5:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 17, nex 19 2025-07-26 22:22:45.919596 :B76584D6:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f6c where: kddwh01: kdddel 2025-07-26 22:22:45.942001 :B76584D7: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-07-26 22:22:45.984212 :B76584DF: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-07-26 22:22:46.005633 :B76584E7:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 18, nex 20 2025-07-26 22:22:46.005641 :B76584E8:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00825f7f where: kddwh01: kdddel 2025-07-26 22:22:46.027441 :B76584E9: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-07-26 22:22:46.069955 :B76584F1: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-07-26 22:22:46.091758 :B76584F9:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 19, nex 21 2025-07-26 22:22:46.091766 :B76584FA:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a3908 where: kdiwh22: kdifind 2025-07-26 22:22:46.112783 :B76584FB: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-07-26 22:22:46.155173 :B7658503: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-07-26 22:22:46.177621 :B765850B:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 20, nex 22 2025-07-26 22:22:46.177629 :B765850C:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a3972 where: kdiwh22: kdifind 2025-07-26 22:22:46.198070 :B765850D: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-07-26 22:22:46.198100 :B7658510: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-07-26 22:22:46.240773 :B7658535: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-07-26 22:22:46.240803 :B7658538: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-07-26 22:22:46.263750 :B7658559:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 21, nex 23 2025-07-26 22:22:46.263757 :B765855A:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864bba where: kddwh01: kdddel 2025-07-26 22:22:46.297070 :B765855B: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-07-26 22:22:46.340469 :B7658563: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-07-26 22:22:46.340500 :B7658566: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-07-26 22:22:46.340996 :B765856D: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-07-26 22:22:46.351636 :B7658574:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 22, nex 24 2025-07-26 22:22:46.351644 :B7658575:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864bcd where: kddwh01: kdddel 2025-07-26 22:22:46.383951 :B7658576: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-07-26 22:22:46.426600 :B765857E: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-07-26 22:22:46.437761 :B7658586:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 23, nex 25 2025-07-26 22:22:46.437769 :B7658587:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864be1 where: kddwh01: kdddel 2025-07-26 22:22:46.469536 :B7658588: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-07-26 22:22:46.512039 :B7658590: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-07-26 22:22:46.512072 :B7658593: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-07-26 22:22:46.523497 :B76585A5:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 24, nex 26 2025-07-26 22:22:46.523505 :B76585A6:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x00864bf4 where: kddwh01: kdddel 2025-07-26 22:22:46.555314 :B76585A7: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-07-26 22:22:46.598286 :B76585D7: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-07-26 22:22:46.609831 :B76585DF:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 25, nex 27 2025-07-26 22:22:46.609839 :B76585E0:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fa89 where: kddwh01: kdddel 2025-07-26 22:22:46.641125 :B76585E1: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-07-26 22:22:46.641154 :B76585E4: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-07-26 22:22:46.684318 :B76585F6: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-07-26 22:22:46.695648 :B76585FE:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 26, nex 28 2025-07-26 22:22:46.695657 :B76585FF:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fa9c where: kddwh01: kdddel 2025-07-26 22:22:46.727050 :B7658600: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-07-26 22:22:46.769687 :B7658608: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-07-26 22:22:46.781627 :B7658610:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 27, nex 29 2025-07-26 22:22:46.781634 :B7658611:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087faaf where: kddwh01: kdddel 2025-07-26 22:22:46.815599 :B7658612: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-07-26 22:22:46.862182 :B7658626: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-07-26 22:22:46.876023 :B765862E:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 28, nex 30 2025-07-26 22:22:46.876034 :B765862F:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fac2 where: kddwh01: kdddel 2025-07-26 22:22:46.909312 :B7658630: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-07-26 22:22:46.955367 :B7658638: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-07-26 22:22:46.969706 :B7658640:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 29, nex 31 2025-07-26 22:22:46.969717 :B7658641:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fad5 where: kddwh01: kdddel 2025-07-26 22:22:47.002004 :B7658642: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-07-26 22:22:47.048205 :B765864A: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-07-26 22:22:47.062953 :B7658652:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 30, nex 32 2025-07-26 22:22:47.062963 :B7658653:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fae9 where: kddwh01: kdddel 2025-07-26 22:22:47.095097 :B7658654: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-07-26 22:22:47.140737 :B765867F: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-07-26 22:22:47.155756 :B7658687:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 31, nex 33 2025-07-26 22:22:47.155766 :B7658688:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0087fafc where: kddwh01: kdddel 2025-07-26 22:22:47.187320 :B7658689: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-07-26 22:22:47.233284 :B7658691: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-07-26 22:22:47.248710 :B7658699:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 32, nex 34 2025-07-26 22:22:47.248721 :B765869A:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a2791 where: kddwh01: kdddel 2025-07-26 22:22:47.279419 :B765869B: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-07-26 22:22:47.325393 :B76586A3: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-07-26 22:22:47.325435 :B76586A6: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-07-26 22:22:47.325976 :B76586AD: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-07-26 22:22:47.341761 :B76586BA:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 33, nex 35 2025-07-26 22:22:47.341771 :B76586BB:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27a4 where: kddwh01: kdddel 2025-07-26 22:22:47.372300 :B76586BC: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-07-26 22:22:47.372341 :B76586BF: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-07-26 22:22:47.418690 :B76586D1: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-07-26 22:22:47.434315 :B76586D9:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 34, nex 36 2025-07-26 22:22:47.434323 :B76586DA:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27b7 where: kddwh01: kdddel 2025-07-26 22:22:47.440047*:B76586DB:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002996BDF0 estart=1753539764 eid=16777336 ctx=0x00000007738B9F78 cwh=0x00000000295E01B0 cpu=2000000 buffg=373109 interb=0 r=0 rb=0 w=0 wb=0 2025-07-26 22:22:47.440047*:B76586DC:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002996BDF0 2025-07-26 22:22:47.462914 :B76586DD: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-07-26 22:22:47.505865 :B76586E5: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-07-26 22:22:47.505895 :B76586E8: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-07-26 22:22:47.506379 :B76586EF: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-07-26 22:22:47.521139 :B76586F6:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 35, nex 37 2025-07-26 22:22:47.521148 :B76586F7:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27ca where: kddwh01: kdddel 2025-07-26 22:22:47.549213 :B76586F8: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-07-26 22:22:47.591833 :B7658700: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-07-26 22:22:47.607115 :B7658708:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 36, nex 38 2025-07-26 22:22:47.607124 :B7658709:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27de where: kddwh01: kdddel 2025-07-26 22:22:47.634803 :B765870A: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-07-26 22:22:47.677054 :B7658712: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-07-26 22:22:47.677082 :B7658715: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-07-26 22:22:47.692655 :B765872F:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 37, nex 39 2025-07-26 22:22:47.692663 :B7658730:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008a27f1 where: kddwh01: kdddel 2025-07-26 22:22:47.720182 :B7658731: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-07-26 22:22:47.720215 :B7658734: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-07-26 22:22:47.765690 :B765873B: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-07-26 22:22:47.765720 :B765873E: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-07-26 22:22:47.781365 :B765874A:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 10, ext 38, nex 40 2025-07-26 22:22:47.781373 :B765874B:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x008c12a8 where: kddwh01: kdddel 2025-07-26 22:22:47.812160 :B765874C: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-07-26 22:22:47.833472 :B7658754: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-07-26 22:22:47.834718 :B765875A: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-07-26 22:22:47.834733 :B765875B: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-07-26 22:22:47.836371 :B765875E: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-07-26 22:22:47.836738 :B765877A: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-07-26 22:22:47.836738*:B7658792:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002996BDF0 curCtx=0x00000000299CFE68 xsc->flg4=65792 flags=2 2025-07-26 22:22:47.836738*:B7658793:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002996BDF0 2025-07-26 22:22:47.882536 :B76587A0: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-07-26 22:22:49.226934 :B76588E6: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-07-26 22:22:49.226958 :B76588E9: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-07-26 22:22:49.268203 :B76588FB: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-07-26 22:22:49.310374 :B7658917: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-07-26 22:22:49.310400 :B765891A: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-07-26 22:22:49.355872 :B765893E: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-07-26 22:22:49.355905 :B7658941: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: 19156, M000)