Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250720060009\orcl_j001_17528_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250720060009\orcl_j001_17528_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:36175M/63366M, Ph+PgF:42086M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 17528, image: ORACLE.EXE (J001) *** 2025-07-20 06:00:10.022 *** SESSION ID:(209.58149) 2025-07-20 06:00:10.022 *** 2025-07-20 06:00:10.022 Process diagnostic dump for ORACLE.EXE (J001), OS id=17528, pid: 26, proc_ser: 140, sid: 209, sess_ser: 58149 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 17528 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=11 seq_num=12 snap_id=1 wait times: snap=0.009555 sec, exc=0.009555 sec, total=0.009555 sec wait times: max=0.500000 sec, heur=5.519154 sec wait counts: calls=1 os=1 in_wait=1 iflags=0x5a8 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000010 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=10 seq_num=11 snap_id=1 wait times: snap=0.499989 sec, exc=0.499989 sec, total=0.499989 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=9 seq_num=10 snap_id=1 wait times: snap=0.500000 sec, exc=0.500000 sec, total=0.500000 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 snap_id=1 wait times: snap=0.510099 sec, exc=0.510099 sec, total=0.510099 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.499997 sec, exc=0.499997 sec, total=0.499997 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 snap_id=1 wait times: snap=0.499997 sec, exc=0.499997 sec, total=0.499997 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.499978 sec, exc=0.499978 sec, total=0.499978 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000017 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 snap_id=1 wait times: snap=0.505113 sec, exc=0.505113 sec, total=0.505113 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.499984 sec, exc=0.499984 sec, total=0.499984 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000013 sec of elapsed time 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.502111 sec, exc=0.502111 sec, total=0.502111 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.499992 sec, exc=0.499992 sec, total=0.499992 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000013 sec of elapsed time Sampled Session History of session 209 serial 58149 --------------------------------------------------- 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, 06:00:04 - 06:00:10] idle wait at each sample [session created at: 06:00:04] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-20 06:00:10.022 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 17528, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-20 05:57:29.108077 :B46E80A6:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:57:40.434711 :B46E8408:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:57:40.424 2025-07-20 05:57:40.434713 :B46E8409:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=7196 pso_num=26 pso_serial#=124 2025-07-20 05:57:40.434846 :B46E840A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=7196 (legacy spawn) 2025-07-20 05:57:40.441555 :B46E840B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:57:40.441752 :B46E8410:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:57:40.442605 :B46E8415:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:57:40.938412 :B46E842B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:57:40.924 2025-07-20 05:57:40.938414 :B46E842C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=1312 pso_num=26 pso_serial#=125 2025-07-20 05:57:40.938551 :B46E842D:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=1312 (legacy spawn) 2025-07-20 05:57:40.945026 :B46E842E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:57:40.945194 :B46E8437:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:57:40.945962 :B46E8438:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:57:40.954614 :B46E843B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:57:40.940 2025-07-20 05:57:40.954616 :B46E843C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16512 pso_num=26 pso_serial#=126 2025-07-20 05:57:40.954749 :B46E843D:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=16512 (legacy spawn) 2025-07-20 05:57:40.961245 :B46E843E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:57:40.961409 :B46E8447:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:57:40.962234 :B46E8448:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:57:44.094595 :B46E8532:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:57:44.080 2025-07-20 05:57:44.094598 :B46E8533:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15780 pso_num=26 pso_serial#=127 2025-07-20 05:57:44.094743 :B46E8534:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=15780 (legacy spawn) 2025-07-20 05:57:44.101447 :B46E8558:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:57:44.101633 :B46E8561:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:57:44.102471 :B46E8562:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:57:44.111387 :B46E8565:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:57:44.096 2025-07-20 05:57:44.111389 :B46E8566:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=18388 pso_num=26 pso_serial#=128 2025-07-20 05:57:44.111530 :B46E8567:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=18388 (legacy spawn) 2025-07-20 05:57:44.118056 :B46E8568:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:57:44.118214 :B46E8571:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:57:44.119064 :B46E8572:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:58:14.653319 :B46E912E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:58:14.644 2025-07-20 05:58:14.653322 :B46E912F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16700 pso_num=26 pso_serial#=129 2025-07-20 05:58:14.653459 :B46E9130:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=16700 (legacy spawn) 2025-07-20 05:58:14.660134 :B46E9131:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:58:14.660303 :B46E9136:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:58:14.661120 :B46E913B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:58:17.409639 :B46E9220:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:58:17.394 2025-07-20 05:58:17.409641 :B46E9221:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17940 pso_num=26 pso_serial#=130 2025-07-20 05:58:17.409784 :B46E9222:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17940 (legacy spawn) 2025-07-20 05:58:17.416278 :B46E9223:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:58:17.416443 :B46E922C:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:58:17.417247 :B46E922D:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:58:17.425987 :B46E9230:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:58:17.426 2025-07-20 05:58:17.425990 :B46E9231:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=19376 pso_num=26 pso_serial#=131 2025-07-20 05:58:17.426142 :B46E9232:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=19376 (legacy spawn) 2025-07-20 05:58:17.432648 :B46E9233:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:58:17.432815 :B46E923C:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:58:17.433618 :B46E923D:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:58:20.597125 :B46E9338:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:58:20.583 2025-07-20 05:58:20.597128 :B46E9339:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16476 pso_num=26 pso_serial#=132 2025-07-20 05:58:20.597266 :B46E933A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=16476 (legacy spawn) 2025-07-20 05:58:20.603899 :B46E933B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:58:20.604082 :B46E9344:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:58:20.604922 :B46E9345:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:58:20.613666 :B46E9348:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:58:20.599 2025-07-20 05:58:20.613668 :B46E9349:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16984 pso_num=26 pso_serial#=133 2025-07-20 05:58:20.613802 :B46E934A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=16984 (legacy spawn) 2025-07-20 05:58:20.620292 :B46E934B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:58:20.620462 :B46E9353:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:58:20.621296 :B46E9355:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:59:22.834833 :B46EA6D1:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:59:22.825 2025-07-20 05:59:22.834836 :B46EA6D2:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17544 pso_num=26 pso_serial#=134 2025-07-20 05:59:22.834994 :B46EA6D3:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17544 (legacy spawn) 2025-07-20 05:59:22.841473 :B46EA6E7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:59:22.841639 :B46EA6F0:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:59:22.842434 :B46EA6F1:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:59:29.988543 :B46EA93C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:59:29.974 2025-07-20 05:59:29.988545 :B46EA93D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=1100 pso_num=26 pso_serial#=135 2025-07-20 05:59:29.988685 :B46EA93E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=1100 (legacy spawn) 2025-07-20 05:59:29.995142 :B46EA93F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:59:29.995309 :B46EA945:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:59:29.996101 :B46EA949:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:59:30.004830 :B46EA94C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:59:29.989 2025-07-20 05:59:30.004832 :B46EA94D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16632 pso_num=26 pso_serial#=136 2025-07-20 05:59:30.005003 :B46EA94E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=16632 (legacy spawn) 2025-07-20 05:59:30.011441 :B46EA94F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:59:30.011600 :B46EA958:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:59:30.012420 :B46EA959:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:59:33.278446 :B46EAA3D:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:59:33.265 2025-07-20 05:59:33.278450 :B46EAA3E:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13528 pso_num=26 pso_serial#=137 2025-07-20 05:59:33.278588 :B46EAA3F:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13528 (legacy spawn) 2025-07-20 05:59:33.285072 :B46EAA40:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:59:33.285243 :B46EAA45:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:59:33.286063 :B46EAA4A:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:59:33.294757 :B46EAA4D:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:59:33.281 2025-07-20 05:59:33.294759 :B46EAA4E:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14788 pso_num=26 pso_serial#=138 2025-07-20 05:59:33.294896 :B46EAA4F:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14788 (legacy spawn) 2025-07-20 05:59:33.301296 :B46EAA50:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:59:33.301454 :B46EAA59:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:59:33.302268 :B46EAA5A:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 05:59:33.523847 :B46EAA69:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 05:59:33.515 2025-07-20 05:59:33.523850 :B46EAA6A:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13728 pso_num=26 pso_serial#=139 2025-07-20 05:59:33.524002 :B46EAA6B:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13728 (legacy spawn) 2025-07-20 05:59:33.530856 :B46EAA6C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 05:59:33.531030 :B46EAA74:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 05:59:33.531884 :B46EAA76:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-20 06:00:02.030627 :B46EB4E1:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-20 06:00:02.019 2025-07-20 06:00:02.030629 :B46EB4E2:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17528 pso_num=26 pso_serial#=140 2025-07-20 06:00:02.030761 :B46EB4E3:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=17528 osp_idx=24 osp_ver=649880 osp_pg=0 (spawn #403608) 2025-07-20 06:00:02.030762 :B46EB4E4:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-20 06:00:02.030763 :B46EB4E5:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=249 time=1671977923 2025-07-20 06:00:02.030763 :B46EB4E6:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-07-20 06:00:02.030764 :B46EB4E7:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-07-20 06:00:02.030764 :B46EB4E8:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-07-20 06:00:02.030764 :B46EB4E9:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-20 06:00:02.030765 :B46EB4EA:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-20 06:00:02.031257 :B46EB4EB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.036393 :B46EB513:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.036436 :B46EB516:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-07-20 06:00:02.039902 :B46EB531:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.421597 :B46EB883:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.464975 :B46EB8C1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.480746 :B46EB8C9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.537718 :B46EB8F9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.669736 :B46EB90D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.783535 :B46EB915:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.793649 :B46EB91D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.809025 :B46EB925:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.824309 :B46EB92D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.840022 :B46EB935:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.849932 :B46EB93D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.865104 :B46EB945:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.874715 :B46EB94D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.890112 :B46EB955:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.900448 :B46EB95D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.910042 :B46EB965:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.925431 :B46EB96D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.934754 :B46EB975:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.950431 :B46EB97D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.966049 :B46EB985:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.981500 :B46EB98D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:02.989148 :B46EB995:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.004537 :B46EB99D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.014487 :B46EB9A5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.029877 :B46EB9AD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.039184 :B46EB9B5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.049392 :B46EB9BD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.059417 :B46EB9C5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.074937 :B46EB9CD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.084280 :B46EB9D5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.099578 :B46EB9DD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.116207 :B46EB9E5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.132807 :B46EB9ED:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.143124 :B46EB9F5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.152271 :B46EB9FD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.167675 :B46EBA05:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.183530 :B46EBA0D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.193865 :B46EBA15:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.206089 :B46EBA1D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.221333 :B46EBA25:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.231665 :B46EBA2D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.241165 :B46EBA35:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.251018 :B46EBA3D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.260575 :B46EBA45:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.276153 :B46EBA4D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.285726 :B46EBA55:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.292993 :B46EBA5D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.300323 :B46EBA65:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.307910 :B46EBA6D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.315326 :B46EBA75:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.322992 :B46EBA7D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.330538 :B46EBA85:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.338065 :B46EBA8D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.345433 :B46EBA95:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:03.863537*:B46EBBF1:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000029A46918 estart=1752962402 eid=16777453 ctx=0x00000007831EA738 cwh=0x0000000029A70248 cpu=93750 buffg=137 interb=1622016 r=2 rb=1622016 w=0 wb=0 2025-07-20 06:00:03.863537*:B46EBBF2:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000029A46918 curCtx=0x0000000050931600 pubTabIdxCnt=0 2025-07-20 06:00:03.863537*:B46EBBF3:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000029A46918 2025-07-20 06:00:03.863537*:B46EBBF4:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000029A46918 2025-07-20 06:00:03.863537*:B46EBBF5:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028BBC288 estart=1752962401 eid=16777334 ctx=0x000000079F654AA8 cwh=0x0000000028BB0158 cpu=1765625 buffg=143204 interb=32686080 r=1441 rb=28098560 w=24 wb=4587520 2025-07-20 06:00:03.863537*:B46EBBF6:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028BBC288 curCtx=0x000000005087BEC8 pubTabIdxCnt=0 2025-07-20 06:00:03.863537*:B46EBBF7:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028BBC288 2025-07-20 06:00:03.863537*:B46EBBF8:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028BBC288 2025-07-20 06:00:03.894774*:B46EBBFD:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000029A46918 curCtx=0x0000000050931600 xsc->flg4=65792 flags=1 2025-07-20 06:00:03.894774*:B46EBBFE:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000029A46918 2025-07-20 06:00:04.498784 :B46EBC5B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:04.499138 :B46EBC63:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:04.499138*:B46EBC6B:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028BBC288 curCtx=0x000000005087BEC8 xsc->flg4=65792 flags=2 2025-07-20 06:00:04.499138*:B46EBC6C:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028BBC288 2025-07-20 06:00:04.499400 :B46EBC6D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-07-20 06:00:04.504029 :B46EBC6E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 06:00:04.504115 :B46EBC71:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-07-20 06:00:04.504202 :B46EBC81:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 26 (osid: 17528, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de