Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250711220006\orcl_j001_14420_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:36423M/63366M, Ph+PgF:42490M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 14420, image: ORACLE.EXE (J001) *** 2025-07-11 22:00:06.153 *** SESSION ID:(209.35957) 2025-07-11 22:00:06.153 *** 2025-07-11 22:00:06.153 Process diagnostic dump for ORACLE.EXE (J001), OS id=14420, pid: 26, proc_ser: 212, sid: 209, sess_ser: 35957 ------------------------------------------------------------------------------- current sql: client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 14420 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.181537 sec, exc=0.181537 sec, total=0.181537 sec wait times: max=0.500000 sec, heur=1.678894 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=2 seq_num=3 snap_id=1 wait times: snap=0.510111 sec, exc=0.510111 sec, total=0.510111 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.499998 sec, exc=0.499998 sec, total=0.499998 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.487221 sec, exc=0.487221 sec, total=0.487221 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000000 sec of elapsed time Sampled Session History of session 209 serial 35957 --------------------------------------------------- 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 --------------------------------------------------- [2 samples, 22:00:04 - 22:00:06] idle wait at each sample [session created at: 22:00:04] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-11 22:00:06.153 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 14420, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-11 21:57:05.317090 :B0B77465: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-11 21:57:05.317286 :B0B7746C: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-11 21:57:05.318091 :B0B7746F:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:57:16.924189 :B0B7788F:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:57:16.915 2025-07-11 21:57:16.924191 :B0B77890:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=4288 pso_num=26 pso_serial#=196 2025-07-11 21:57:16.924325 :B0B77891:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=4288 (legacy spawn) 2025-07-11 21:57:16.930831 :B0B77892: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-11 21:57:16.930997 :B0B7789B: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-11 21:57:16.931809 :B0B7789C:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:57:19.887654 :B0B7795E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:57:19.880 2025-07-11 21:57:19.887656 :B0B7795F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12040 pso_num=26 pso_serial#=197 2025-07-11 21:57:19.887801 :B0B77960:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12040 (legacy spawn) 2025-07-11 21:57:19.894187 :B0B77961: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-11 21:57:19.894363 :B0B77966: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-11 21:57:19.895178 :B0B7796B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:57:38.533351 :B0B77F23:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:57:38.525 2025-07-11 21:57:38.533353 :B0B77F24:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16556 pso_num=26 pso_serial#=198 2025-07-11 21:57:38.533497 :B0B77F25:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=16556 (legacy spawn) 2025-07-11 21:57:38.540006 :B0B77F26: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-11 21:57:38.540183 :B0B77F2B: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-11 21:57:38.541053 :B0B77F30:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:57:38.549747 :B0B77F33:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:57:38.541 2025-07-11 21:57:38.549749 :B0B77F34:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11212 pso_num=26 pso_serial#=199 2025-07-11 21:57:38.549883 :B0B77F35:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=11212 (legacy spawn) 2025-07-11 21:57:38.556362 :B0B77F36: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-11 21:57:38.556523 :B0B77F3F: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-11 21:57:38.557317 :B0B77F40:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:57:41.684058 :B0B7803E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:57:41.671 2025-07-11 21:57:41.684060 :B0B7803F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14524 pso_num=26 pso_serial#=200 2025-07-11 21:57:41.684198 :B0B78040:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14524 (legacy spawn) 2025-07-11 21:57:41.690703 :B0B78041: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-11 21:57:41.690881 :B0B78046: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-11 21:57:41.691698 :B0B7804B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:57:41.700366 :B0B7804E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:57:41.686 2025-07-11 21:57:41.700367 :B0B7804F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=9700 pso_num=26 pso_serial#=201 2025-07-11 21:57:41.700499 :B0B78050:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=9700 (legacy spawn) 2025-07-11 21:57:41.719415 :B0B78074: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-11 21:57:41.719582 :B0B7807D: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-11 21:57:41.720461 :B0B7807E:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:58:17.992414 :B0B78CD8:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:58:17.983 2025-07-11 21:58:17.992416 :B0B78CD9:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17040 pso_num=26 pso_serial#=202 2025-07-11 21:58:17.992551 :B0B78CDA:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17040 (legacy spawn) 2025-07-11 21:58:17.998975 :B0B78CDB: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-11 21:58:17.999145 :B0B78CE4: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-11 21:58:17.999968 :B0B78CE5:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:58:18.008667 :B0B78CE8:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:58:17.999 2025-07-11 21:58:18.008669 :B0B78CE9:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17856 pso_num=26 pso_serial#=203 2025-07-11 21:58:18.008804 :B0B78CEA:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17856 (legacy spawn) 2025-07-11 21:58:18.015243 :B0B78CEB: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-11 21:58:18.015403 :B0B78CF4: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-11 21:58:18.016253 :B0B78CF5:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:58:22.090974 :B0B78E5A:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:58:22.083 2025-07-11 21:58:22.090976 :B0B78E5B:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=4540 pso_num=26 pso_serial#=204 2025-07-11 21:58:22.091105 :B0B78E5C:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=4540 (legacy spawn) 2025-07-11 21:58:22.097521 :B0B78E5D: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-11 21:58:22.097701 :B0B78E62: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-11 21:58:22.098585 :B0B78E67:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:58:25.245510 :B0B78F73:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:58:25.238 2025-07-11 21:58:25.245512 :B0B78F74:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12604 pso_num=26 pso_serial#=205 2025-07-11 21:58:25.245661 :B0B78F75:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12604 (legacy spawn) 2025-07-11 21:58:25.252369 :B0B78F76: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-11 21:58:25.252563 :B0B78F7B: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-11 21:58:25.253577 :B0B78F80:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:59:24.317387 :B0B7A23D:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:59:24.305 2025-07-11 21:59:24.317389 :B0B7A23E:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15440 pso_num=26 pso_serial#=206 2025-07-11 21:59:24.317527 :B0B7A23F:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=15440 (legacy spawn) 2025-07-11 21:59:24.323975 :B0B7A240: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-11 21:59:24.324136 :B0B7A249: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-11 21:59:24.324940 :B0B7A24A:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:59:27.391679 :B0B7A33C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:59:27.377 2025-07-11 21:59:27.391681 :B0B7A33D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15484 pso_num=26 pso_serial#=207 2025-07-11 21:59:27.391826 :B0B7A33E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=15484 (legacy spawn) 2025-07-11 21:59:27.412577 :B0B7A33F: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-11 21:59:27.412741 :B0B7A348: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-11 21:59:27.413544 :B0B7A349:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:59:27.422196 :B0B7A34C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:59:27.408 2025-07-11 21:59:27.422198 :B0B7A34D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=4248 pso_num=26 pso_serial#=208 2025-07-11 21:59:27.422340 :B0B7A34E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=4248 (legacy spawn) 2025-07-11 21:59:27.428756 :B0B7A34F: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-11 21:59:27.428959 :B0B7A358: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-11 21:59:27.429767 :B0B7A359:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:59:30.588767 :B0B7A43E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:59:30.576 2025-07-11 21:59:30.588769 :B0B7A43F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17772 pso_num=26 pso_serial#=209 2025-07-11 21:59:30.588904 :B0B7A440:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17772 (legacy spawn) 2025-07-11 21:59:30.595429 :B0B7A441: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-11 21:59:30.595602 :B0B7A44A: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-11 21:59:30.596393 :B0B7A44B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:59:30.604986 :B0B7A44E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:59:30.591 2025-07-11 21:59:30.604988 :B0B7A44F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=18376 pso_num=26 pso_serial#=210 2025-07-11 21:59:30.605122 :B0B7A450:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=18376 (legacy spawn) 2025-07-11 21:59:30.611566 :B0B7A451: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-11 21:59:30.611727 :B0B7A45A: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-11 21:59:30.612513 :B0B7A45B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 21:59:33.520189 :B0B7A551:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 21:59:33.512 2025-07-11 21:59:33.520191 :B0B7A552:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12284 pso_num=26 pso_serial#=211 2025-07-11 21:59:33.520328 :B0B7A553:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12284 (legacy spawn) 2025-07-11 21:59:33.526772 :B0B7A554: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-11 21:59:33.526968 :B0B7A55D: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-11 21:59:33.527767 :B0B7A55E:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-11 22:00:02.050562 :B0B7AFC1:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-11 22:00:02.039 2025-07-11 22:00:02.050565 :B0B7AFC2:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14420 pso_num=26 pso_serial#=212 2025-07-11 22:00:02.050692 :B0B7AFC3:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=14420 osp_idx=24 osp_ver=606092 osp_pg=0 (spawn #375822) 2025-07-11 22:00:02.050692 :B0B7AFC4: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-11 22:00:02.050693 :B0B7AFC5:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=42 time=951977939 2025-07-11 22:00:02.050693 :B0B7AFC6:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-07-11 22:00:02.050694 :B0B7AFC7:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-07-11 22:00:02.050694 :B0B7AFC8:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-07-11 22:00:02.050694 :B0B7AFC9:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-11 22:00:02.050695 :B0B7AFCA:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-11 22:00:02.051179 :B0B7AFCE: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-11 22:00:02.056431 :B0B7AFFF: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-11 22:00:02.056474 :B0B7B002:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-07-11 22:00:02.059734 :B0B7B01D: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-11 22:00:02.437880 :B0B7B35E: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-11 22:00:02.481233 :B0B7B366: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-11 22:00:02.496815 :B0B7B36E: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-11 22:00:02.553669 :B0B7B37E: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-11 22:00:02.685695 :B0B7B38E: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-11 22:00:02.800760 :B0B7B396: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-11 22:00:02.810731 :B0B7B39E: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-11 22:00:02.826042 :B0B7B3A6: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-11 22:00:02.841026 :B0B7B3AE: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-11 22:00:02.856890 :B0B7B3B6: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-11 22:00:02.866655 :B0B7B3BE: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-11 22:00:02.881880 :B0B7B3C6: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-11 22:00:02.891852 :B0B7B3CE: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-11 22:00:02.908374 :B0B7B3D6: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-11 22:00:02.918869 :B0B7B3DE: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-11 22:00:02.929038 :B0B7B3E6: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-11 22:00:02.944874 :B0B7B3EE: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-11 22:00:02.955281 :B0B7B3F6: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-11 22:00:02.972171 :B0B7B3FE: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-11 22:00:02.987773 :B0B7B406: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-11 22:00:03.003047 :B0B7B40E: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-11 22:00:03.018567 :B0B7B416: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-11 22:00:03.028641 :B0B7B41E: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-11 22:00:03.044331 :B0B7B426: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-11 22:00:03.054351 :B0B7B42E: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-11 22:00:03.063582 :B0B7B436: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-11 22:00:03.073615 :B0B7B44A: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-11 22:00:03.088627 :B0B7B475: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-11 22:00:03.095697 :B0B7B47D: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-11 22:00:03.110929 :B0B7B485: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-11 22:00:03.120096 :B0B7B48D: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-11 22:00:03.135582 :B0B7B495: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-11 22:00:03.150779 :B0B7B49D: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-11 22:00:03.160717 :B0B7B4A5: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-11 22:00:03.170527 :B0B7B4AD: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-11 22:00:03.185656 :B0B7B4B5: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-11 22:00:03.201014 :B0B7B4BD: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-11 22:00:03.210376 :B0B7B4C5: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-11 22:00:03.225508 :B0B7B4CD: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-11 22:00:03.237537 :B0B7B4D5: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-11 22:00:03.247678 :B0B7B4DD: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-11 22:00:03.257342 :B0B7B4E5: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-11 22:00:03.266823 :B0B7B4ED: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-11 22:00:03.282109 :B0B7B4F5: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-11 22:00:03.289661 :B0B7B4FD: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-11 22:00:03.297014 :B0B7B505: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-11 22:00:03.304378 :B0B7B50D: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-11 22:00:03.311783 :B0B7B515: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-11 22:00:03.319170 :B0B7B51D: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-11 22:00:03.326679 :B0B7B525: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-11 22:00:03.334266 :B0B7B52D: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-11 22:00:03.341656 :B0B7B535: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-11 22:00:03.798693*:B0B7B5AB:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000029A46918 estart=1752242402 eid=16777435 ctx=0x00000007831EA738 cwh=0x0000000029A70248 cpu=46875 buffg=57 interb=1040384 r=1 rb=1040384 w=0 wb=0 2025-07-11 22:00:03.798693*:B0B7B5AC:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000029A46918 curCtx=0x000000004DB5ED68 pubTabIdxCnt=0 2025-07-11 22:00:03.798693*:B0B7B5AD:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000029A46918 2025-07-11 22:00:03.798693*:B0B7B5AE:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000029A46918 2025-07-11 22:00:03.798693*:B0B7B5AF:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028BBC288 estart=1752242401 eid=16777325 ctx=0x000000079F654AA8 cwh=0x0000000028BB0158 cpu=1671875 buffg=141584 interb=31105024 r=1384 rb=26566656 w=24 wb=4538368 2025-07-11 22:00:03.798693*:B0B7B5B0:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028BBC288 curCtx=0x0000000029A48510 pubTabIdxCnt=0 2025-07-11 22:00:03.798693*:B0B7B5B1:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028BBC288 2025-07-11 22:00:03.798693*:B0B7B5B2:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028BBC288 2025-07-11 22:00:03.876830*:B0B7B649:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000029A46918 curCtx=0x000000004DB5ED68 xsc->flg4=65792 flags=1 2025-07-11 22:00:03.876830*:B0B7B64A:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000029A46918 2025-07-11 22:00:04.471719 :B0B7B7B0: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-11 22:00:04.472054 :B0B7B7B8: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-11 22:00:04.472054*:B0B7B7BD:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028BBC288 curCtx=0x0000000029A48510 xsc->flg4=65792 flags=2 2025-07-11 22:00:04.472054*:B0B7B7C0:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028BBC288 2025-07-11 22:00:04.472304 :B0B7B7C2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-07-11 22:00:04.476640 :B0B7B7C3: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-11 22:00:04.476715 :B0B7B7C6: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-11 22:00:04.476798 :B0B7B7D3: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: 14420, J001)