Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250810080119\orcl_m002_21036_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250810080119\orcl_m002_21036_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:35584M/63366M, Ph+PgF:41000M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 21036, image: ORACLE.EXE (M002) *** 2025-08-10 08:01:20.035 *** SESSION ID:(233.31563) 2025-08-10 08:01:20.035 *** 2025-08-10 08:01:20.035 Process diagnostic dump for ORACLE.EXE (M002), OS id=21036, pid: 29, proc_ser: 163, sid: 233, sess_ser: 31563 ------------------------------------------------------------------------------- current sql: <none> Current Wait Stack: 0: waiting for 'db file sequential read' file#=0x2, block#=0x4b92, blocks=0x1 wait_id=1569 seq_num=1570 snap_id=1 wait times: snap=0.000076 sec, exc=0.000076 sec, total=0.000076 sec wait times: max=infinite, heur=0.000076 sec wait counts: calls=0 os=0 in_wait=1 iflags=0x5a0 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000003 sec since last wait 0: waited for 'db file sequential read' file#=0x2, block#=0x4b92, blocks=0x1 wait_id=1569 seq_num=1570 snap_id=1 wait times: snap=0.000139 sec, exc=0.000139 sec, total=0.000139 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000387 sec of elapsed time 1: waited for 'db file sequential read' file#=0x2, block#=0x4b7a, blocks=0x1 wait_id=1568 seq_num=1569 snap_id=1 wait times: snap=0.005047 sec, exc=0.005047 sec, total=0.005047 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000154 sec of elapsed time 2: waited for 'db file sequential read' file#=0x2, block#=0x4b5a, blocks=0x1 wait_id=1567 seq_num=1568 snap_id=1 wait times: snap=0.000112 sec, exc=0.000112 sec, total=0.000112 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000249 sec of elapsed time 3: waited for 'db file sequential read' file#=0x2, block#=0x4b3a, blocks=0x1 wait_id=1566 seq_num=1567 snap_id=1 wait times: snap=0.001944 sec, exc=0.001944 sec, total=0.001944 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000139 sec of elapsed time 4: waited for 'db file sequential read' file#=0x2, block#=0x4b2a, blocks=0x1 wait_id=1565 seq_num=1566 snap_id=1 wait times: snap=0.000050 sec, exc=0.000050 sec, total=0.000050 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000155 sec of elapsed time 5: waited for 'db file sequential read' file#=0x2, block#=0x4b12, blocks=0x1 wait_id=1564 seq_num=1565 snap_id=1 wait times: snap=0.000054 sec, exc=0.000054 sec, total=0.000054 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000287 sec of elapsed time 6: waited for 'db file sequential read' file#=0x2, block#=0x4afa, blocks=0x1 wait_id=1563 seq_num=1564 snap_id=1 wait times: snap=0.001738 sec, exc=0.001738 sec, total=0.001738 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000158 sec of elapsed time 7: waited for 'db file sequential read' file#=0x2, block#=0x4a22, blocks=0x1 wait_id=1562 seq_num=1563 snap_id=1 wait times: snap=0.000128 sec, exc=0.000128 sec, total=0.000128 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000163 sec of elapsed time 8: waited for 'db file sequential read' file#=0x2, block#=0x4a0a, blocks=0x1 wait_id=1561 seq_num=1562 snap_id=1 wait times: snap=0.000050 sec, exc=0.000050 sec, total=0.000050 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000183 sec of elapsed time 9: waited for 'db file sequential read' file#=0x2, block#=0x4a52, blocks=0x1 wait_id=1570 seq_num=1571 snap_id=1 wait times: snap=0.000088 sec, exc=0.000088 sec, total=0.000088 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000164 sec of elapsed time Sampled Session History of session 233 serial 31563 --------------------------------------------------- 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 --------------------------------------------------- [1 sample, 08:01:20] idle wait at each sample [session created at: 08:01:19] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-10 08:01:20.035 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 21036, M002) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-10 06:00:02.057178 :BDBDAF49:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 06:00:02.057784 :BDBDAF58:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.062834 :BDBDAF6E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.062871 :BDBDAF71:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-08-10 06:00:02.080793 :BDBDB16A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.081084 :BDBDB172:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.081284 :BDBDB17A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.081439 :BDBDB182:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.081676 :BDBDB18A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.081827 :BDBDB192:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.081983 :BDBDB19A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.082127 :BDBDB1A2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.082274 :BDBDB1AA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.082418 :BDBDB1B2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.082563 :BDBDB1BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.082907 :BDBDB1C2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.083052 :BDBDB1CA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.083199 :BDBDB1D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.083338 :BDBDB1DA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.083477 :BDBDB1E2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:02.103845 :BDBDB1EA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:03.336060*:BDBDB3F2:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000030183AD0 estart=1754776803 eid=21243785 ctx=0x0000000777968158 cwh=0x00000000301B09C8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-08-10 06:00:03.336060*:BDBDB3F4:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000030183AD0 curCtx=0x00000000561C7918 pubTabIdxCnt=0 2025-08-10 06:00:03.336060*:BDBDB3F5:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000030183AD0 2025-08-10 06:00:03.336060*:BDBDB3F7:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000030183AD0 2025-08-10 06:00:03.336060*:BDBDB3F8:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000301FB6F0 estart=1754776801 eid=16777511 ctx=0x000000077B54EAC8 cwh=0x00000000301B0518 cpu=1031250 buffg=59179 interb=196608 r=24 rb=196608 w=0 wb=0 2025-08-10 06:00:03.336060*:BDBDB3FC:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000301FB6F0 curCtx=0x00000000560A87D0 pubTabIdxCnt=0 2025-08-10 06:00:03.336060*:BDBDB3FD:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000301FB6F0 2025-08-10 06:00:03.336060*:BDBDB3FE:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000301FB6F0 2025-08-10 06:00:03.336060*:BDBDB3FF:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000030183AD0 curCtx=0x00000000561C7918 xsc->flg4=65792 flags=1 2025-08-10 06:00:03.336060*:BDBDB400:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000030183AD0 2025-08-10 06:00:03.757950*:BDBDB52D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000301FB6F0 curCtx=0x00000000560A87D0 xsc->flg4=65792 flags=2 2025-08-10 06:00:03.757950*:BDBDB52E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000301FB6F0 2025-08-10 06:00:03.760776 :BDBDB52F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:03.780762 :BDBDB537:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:03.782719 :BDBDB53F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-08-10 06:00:03.782900 :BDBDB540:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-08-10 06:00:03.783765 :BDBDB541:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:03.783854 :BDBDB544:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:03.784677 :BDBDB556:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:03.786258 :BDBDB55E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:03.786537 :BDBDB566:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:03.836067*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-08-10 06:00:03.851691*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-08-10 06:00:03.851691*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-08-10 06:00:03.851691*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-08-10 06:00:03.851691*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-08-10 06:00:03.851691*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-10 06:00:03.851691*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-08-10 06:00:03.918475 :BDBDB596:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:05.792013 :BDBDB676:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:05.792024 :BDBDB677:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0009.014.0001d806 2025-08-10 06:00:08.168837 :BDBDB7FE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:08.173023 :BDBDB806:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:08.184203 :BDBDB80E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:08.212287 :BDBDB816:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:09.357816 :BDBDB913:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:jslv.c:9203 2025-08-10 06:00:09.370482 :BDBDB914:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:0] KSL POST SENT postee=59 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:09.372054 :BDBDB91C:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-10 06:00:17.421590 :BDBDBC3E:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-10 06:00:17.413 2025-08-10 06:00:17.421591 :BDBDBC3F:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19244 pso_num=29 pso_serial#=156 2025-08-10 06:00:17.421736 :BDBDBC40:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19244 (legacy spawn) 2025-08-10 06:00:17.429088 :BDBDBC41:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:17.429258 :BDBDBC46:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-10 06:00:17.430041 :BDBDBC4B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-10 06:00:29.277299 :BDBDC000:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-10 06:00:29.272 2025-08-10 06:00:29.277300 :BDBDC001:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20316 pso_num=29 pso_serial#=157 2025-08-10 06:00:29.277440 :BDBDC002:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=20316 osp_idx=27 osp_ver=15711 osp_pg=0 (spawn #473606) 2025-08-10 06:00:29.277441 :BDBDC003:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 06:00:29.277441 :BDBDC004:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=199 time=3486298579 2025-08-10 06:00:29.277441 :BDBDC005:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 06:00:29.277442 :BDBDC006:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 06:00:29.277442 :BDBDC007:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 06:00:29.277443 :BDBDC008:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 06:00:29.277443 :BDBDC009:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 06:00:29.277940 :BDBDC00A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.277983 :BDBDC010:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] KSL POST RCVD poster=18 loc='ksv2.h LINE:1639 ID:ksvpst: run' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-10 06:00:29.282390 :BDBDC023:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.305601 :BDBDC037:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.313099 :BDBDC03F:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 4, ext 1, nex 2 2025-08-10 06:00:29.313107 :BDBDC040:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00815f56 where: kdiwh22: kdifind 2025-08-10 06:00:29.316735 :BDBDC041:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 4, ext 2, nex 3 2025-08-10 06:00:29.316742 :BDBDC042:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00815f58 where: kdiwh22: kdifind 2025-08-10 06:00:29.319554 :BDBDC043:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.319563 :BDBDC044:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0004.011.0000c779 2025-08-10 06:00:29.319848 :BDBDC04C:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 4, ext 3, nex 4 2025-08-10 06:00:29.319854 :BDBDC04D:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00815f5d where: kdiwh133: kdisdelete 2025-08-10 06:00:29.322884 :BDBDC04E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.355142 :BDBDC056:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.358859 :BDBDC05E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.362639 :BDBDC066:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.367061 :BDBDC06E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.368174 :BDBDC076:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.372459 :BDBDC07E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.372476 :BDBDC07F:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0004.014.0000c778 2025-08-10 06:00:29.372790 :BDBDC087:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 4, ext 4, nex 5 2025-08-10 06:00:29.372796 :BDBDC088:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00817b88 where: ktspbwh1: ktspfsrch 2025-08-10 06:00:29.391727 :BDBDC089:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.391740 :BDBDC08A:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0004.007.0000c76d 2025-08-10 06:00:29.391915 :BDBDC08D:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 4, ext 5, nex 6 2025-08-10 06:00:29.391920 :BDBDC08E:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x0081aeda where: ktspbwh1: ktspfsrch 2025-08-10 06:00:29.408237 :BDBDC094:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.408251 :BDBDC095:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0004.00f.0000c76f 2025-08-10 06:00:29.408478 :BDBDC09D:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 4, ext 6, nex 7 2025-08-10 06:00:29.408485 :BDBDC09E:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x0080fb32 where: kdiwh187: kdisprobe 2025-08-10 06:00:29.416274 :BDBDC09F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:29.416285 :BDBDC0A0:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0004.013.0000c772 2025-08-10 06:00:29.416549 :BDBDC0A8:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 4, ext 7, nex 8 2025-08-10 06:00:29.416555 :BDBDC0A9:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00817dc6 where: ktspbwh1: ktspfsrch 2025-08-10 06:00:29.427036 :BDBDC0AA:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 4, ext 8, nex 9 2025-08-10 06:00:29.427042 :BDBDC0AB:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x0080fba2 where: ktswh76: ktsxadd 2025-08-10 06:00:29.989645 :BDBDC0AC:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 4, ext 9, nex 10 2025-08-10 06:00:29.989653 :BDBDC0AD:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00817d8d where: kdiwh22: kdifind 2025-08-10 06:00:30.413641*:BDBDC0CD:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000325F04C0 estart=1754776829 eid=16780590 ctx=0x000000077BA4B1C8 cwh=0x000000002B4208C0 cpu=421875 buffg=0 interb=0 r=0 rb=0 w=0 wb=0 2025-08-10 06:00:30.413641*:BDBDC0CE:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000325F04C0 curCtx=0x00000000325FF168 pubTabIdxCnt=0 2025-08-10 06:00:30.413641*:BDBDC0CF:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000325F04C0 2025-08-10 06:00:30.413641*:BDBDC0D0:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000325F04C0 2025-08-10 06:00:30.413641*:BDBDC0D1:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002B4330A8 estart=1754776829 eid=16780570 ctx=0x0000000787AD5BF0 cwh=0x000000002B420410 cpu=421875 buffg=0 interb=0 r=0 rb=0 w=0 wb=0 2025-08-10 06:00:30.413641*:BDBDC0D2:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002B4330A8 curCtx=0x00000000325F1460 pubTabIdxCnt=0 2025-08-10 06:00:30.413641*:BDBDC0D3:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002B4330A8 2025-08-10 06:00:30.413641*:BDBDC0D4:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002B4330A8 2025-08-10 06:00:30.540741*:BDBDC0D5:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000325F04C0 curCtx=0x00000000325FF168 xsc->flg4=65792 flags=1 2025-08-10 06:00:30.540741*:BDBDC0D6:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000325F04C0 2025-08-10 06:00:30.540741*:BDBDC0D7:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002B4330A8 curCtx=0x00000000325F1460 xsc->flg4=65792 flags=2 2025-08-10 06:00:30.540741*:BDBDC0D8:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002B4330A8 2025-08-10 06:00:30.615168 :BDBDC0D9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:30.688952 :BDBDC0E1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:30.689371 :BDBDC0E9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:30.689648 :BDBDC0F1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:30.689665 :BDBDC0F4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 06:00:30.689730 :BDBDC102:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-10 06:00:30.692832 :BDBDC10C:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-10 08:01:15.898878 :BDC73D46:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-10 08:01:15.884 2025-08-10 08:01:15.898879 :BDC73D47:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19464 pso_num=29 pso_serial#=158 2025-08-10 08:01:15.899019 :BDC73D48:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19464 (legacy spawn) 2025-08-10 08:01:15.905489 :BDC73D49:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 08:01:15.906021 :BDC73D52:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-10 08:01:15.906877 :BDC73D53:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-10 08:01:15.915676 :BDC73D56:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-10 08:01:15.916 2025-08-10 08:01:15.915678 :BDC73D57:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21084 pso_num=29 pso_serial#=159 2025-08-10 08:01:15.915813 :BDC73D58:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21084 (legacy spawn) 2025-08-10 08:01:15.922388 :BDC73D59:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 08:01:15.922718 :BDC73D62:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-10 08:01:15.923551 :BDC73D63:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-10 08:01:17.103673 :BDC73F9C:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-10 08:01:17.103 2025-08-10 08:01:17.103675 :BDC73F9D:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=4764 pso_num=29 pso_serial#=160 2025-08-10 08:01:17.103836 :BDC73F9E:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=4764 osp_idx=27 osp_ver=15714 osp_pg=0 (spawn #473889) 2025-08-10 08:01:17.103837 :BDC73F9F:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 08:01:17.103837 :BDC73FA0:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=200 time=3493546392 2025-08-10 08:01:17.103838 :BDC73FA1:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 08:01:17.103838 :BDC73FA2:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 08:01:17.103838 :BDC73FA3:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 08:01:17.103839 :BDC73FA4:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 08:01:17.103839 :BDC73FA5:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 08:01:17.104786 :BDC73FA6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 08:01:17.104834 :BDC73FAC:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] KSL POST RCVD poster=18 loc='ksv2.h LINE:1639 ID:ksvpst: run' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-10 08:01:17.205527 :BDC73FDE:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-10 08:01:19.128658 :BDC7406E:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-10 08:01:19.113 2025-08-10 08:01:19.128661 :BDC7406F:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21236 pso_num=29 pso_serial#=161 2025-08-10 08:01:19.128811 :BDC74070:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21236 (legacy spawn) 2025-08-10 08:01:19.135938 :BDC74071:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 08:01:19.136096 :BDC7407A:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-10 08:01:19.137062 :BDC7407B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-10 08:01:19.146209 :BDC7407E:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-10 08:01:19.144 2025-08-10 08:01:19.146211 :BDC7407F:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19156 pso_num=29 pso_serial#=162 2025-08-10 08:01:19.146353 :BDC74080:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19156 (legacy spawn) 2025-08-10 08:01:19.153429 :BDC74081:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 08:01:19.153600 :BDC7408A:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-10 08:01:19.154457 :BDC7408B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-10 08:01:19.342653 :BDC740CF:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-10 08:01:19.332 2025-08-10 08:01:19.342655 :BDC740D0:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21036 pso_num=29 pso_serial#=163 2025-08-10 08:01:19.342792 :BDC740D1:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=21036 osp_idx=27 osp_ver=15717 osp_pg=0 (spawn #473891) 2025-08-10 08:01:19.342792 :BDC740D2:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 08:01:19.342793 :BDC740D3:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=201 time=3493548642 2025-08-10 08:01:19.342793 :BDC740D4:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 08:01:19.342795 :BDC740D5:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 08:01:19.342795 :BDC740D6:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 08:01:19.342796 :BDC740D7:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 08:01:19.342796 :BDC740D8:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 08:01:19.343315 :BDC740D9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 08:01:19.343360 :BDC740DF:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] KSL POST RCVD poster=18 loc='ksv2.h LINE:1639 ID:ksvpst: run' id1=0 id2=0 name= type=0 fac#=0 facpost=1 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 29 (osid: 21036, M002)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de