Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250717220010\orcl_j003_17404_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:36265M/63366M, Ph+PgF:42215M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 17404, image: ORACLE.EXE (J003) *** 2025-07-17 22:00:10.206 *** 2025-07-17 22:00:10.206 Process diagnostic dump for ORACLE.EXE (J003), OS id=17404, pid: 29, proc_ser: 37, sid: ------------------------------------------------------------------------------- Skipping session state dump because target process has no session. ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-17 22:00:10.206 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 17404, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-17 01:00:05.425289 :B2FC9B61:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-17 01:00:05.425289 :B2FC9B62:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-17 01:00:05.425289 :B2FC9B63:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-17 01:00:05.425290 :B2FC9B64:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-17 01:00:05.425789 :B2FC9B65: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-07-17 01:00:05.425834 :B2FC9B6C: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-07-17 01:00:05.430363 :B2FC9B7E: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-07-17 01:00:05.455650 :B2FC9B86:db_trace:ksb.c@6610:ksbcic_int(): [10254:29:233] KSBCIC: (USER) starting cic on opcode KSBCIRCO [1] with args (1 4286463005 8504296) 2025-07-17 01:00:05.455658 :B2FC9B87:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-17 01:00:05.455714 :B2FC9B8F:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-07-17 01:00:05.455752 :B2FC9B9F: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-07-17 01:00:05.470699 :B2FC9BA7: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-07-17 01:00:05.501524 :B2FC9BC2: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-07-17 01:00:05.505143 :B2FC9BCA: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-07-17 01:00:05.508816 :B2FC9BD2: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-07-17 01:00:05.513027 :B2FC9BDA: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-07-17 01:00:05.514164 :B2FC9BE2: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-07-17 01:00:06.760984 :B2FC9C11: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-07-17 01:00:06.800146 :B2FC9C19: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-07-17 01:00:06.800459 :B2FC9C21: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-07-17 01:00:06.800730 :B2FC9C29: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-07-17 01:00:06.800747 :B2FC9C2C: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-07-17 01:00:06.800830 :B2FC9C3E: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-07-17 01:00:06.804546 :B2FC9C46:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 01:00:08.317143 :B2FC9D3A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 01:00:08.305 2025-07-17 01:00:08.317145 :B2FC9D3B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18912 pso_num=29 pso_serial#=27 2025-07-17 01:00:08.317289 :B2FC9D3C:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18912 (legacy spawn) 2025-07-17 01:00:08.323781 :B2FC9D3D: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-07-17 01:00:08.323950 :B2FC9D42: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-07-17 01:00:08.324746 :B2FC9D47:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 01:00:08.333511 :B2FC9D4A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 01:00:08.320 2025-07-17 01:00:08.333513 :B2FC9D4B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=11176 pso_num=29 pso_serial#=28 2025-07-17 01:00:08.333647 :B2FC9D4C:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=11176 (legacy spawn) 2025-07-17 01:00:08.340174 :B2FC9D4D: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-07-17 01:00:08.340346 :B2FC9D56: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-07-17 01:00:08.341180 :B2FC9D57:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 01:00:11.406738 :B2FC9E47:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 01:00:11.393 2025-07-17 01:00:11.406740 :B2FC9E48:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=9904 pso_num=29 pso_serial#=29 2025-07-17 01:00:11.406914 :B2FC9E49:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=9904 (legacy spawn) 2025-07-17 01:00:11.413422 :B2FC9E6C: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-07-17 01:00:11.413594 :B2FC9E71: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-07-17 01:00:11.414436 :B2FC9E76:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 01:00:11.423157 :B2FC9E79:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 01:00:11.409 2025-07-17 01:00:11.423159 :B2FC9E7A:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18704 pso_num=29 pso_serial#=30 2025-07-17 01:00:11.423297 :B2FC9E7B:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18704 (legacy spawn) 2025-07-17 01:00:11.441859 :B2FC9E9F: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-07-17 01:00:11.442031 :B2FC9EA8: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-07-17 01:00:11.442894 :B2FC9EA9:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 01:00:14.488713 :B2FC9F91:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 01:00:14.476 2025-07-17 01:00:14.488715 :B2FC9F92:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=16340 pso_num=29 pso_serial#=31 2025-07-17 01:00:14.488853 :B2FC9F93:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=16340 (legacy spawn) 2025-07-17 01:00:14.495347 :B2FC9F94: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-07-17 01:00:14.495531 :B2FC9F99: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-07-17 01:00:14.496279 :B2FC9F9E:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 01:00:14.505086 :B2FC9FA1:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 01:00:14.491 2025-07-17 01:00:14.505088 :B2FC9FA2:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19232 pso_num=29 pso_serial#=32 2025-07-17 01:00:14.505225 :B2FC9FA3:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19232 (legacy spawn) 2025-07-17 01:00:14.511747 :B2FC9FB7: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-07-17 01:00:14.511917 :B2FC9FC0: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-07-17 01:00:14.512772 :B2FC9FC1:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 01:00:19.336785 :B2FCA132:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 01:00:19.329 2025-07-17 01:00:19.336787 :B2FCA133:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18436 pso_num=29 pso_serial#=33 2025-07-17 01:00:19.336920 :B2FCA134:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18436 (legacy spawn) 2025-07-17 01:00:19.343391 :B2FCA135: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-07-17 01:00:19.343588 :B2FCA13A: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-07-17 01:00:19.344396 :B2FCA13F:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 16:00:06.186606 :B343BF7E:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 16:00:06.173 2025-07-17 16:00:06.186608 :B343BF7F:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=13716 pso_num=29 pso_serial#=34 2025-07-17 16:00:06.186740 :B343BF80:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=13716 (legacy spawn) 2025-07-17 16:00:06.193218 :B343BF81: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-07-17 16:00:06.193552 :B343BF8A: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-07-17 16:00:06.194339 :B343BF8B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 16:00:06.202923 :B343BF8E:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 16:00:06.189 2025-07-17 16:00:06.202926 :B343BF8F:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=13284 pso_num=29 pso_serial#=35 2025-07-17 16:00:06.203064 :B343BF90:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=13284 (legacy spawn) 2025-07-17 16:00:06.209556 :B343BF91: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-07-17 16:00:06.209732 :B343BF9A: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-07-17 16:00:06.210558 :B343BF9B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 16:00:07.333072 :B343C017:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 16:00:07.329 2025-07-17 16:00:07.333074 :B343C018:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17416 pso_num=29 pso_serial#=36 2025-07-17 16:00:07.333203 :B343C019:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=17416 osp_idx=27 osp_ver=14570 osp_pg=0 (spawn #395006) 2025-07-17 16:00:07.333204 :B343C01A:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-17 16:00:07.333205 :B343C01B:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=210 time=1448783220 2025-07-17 16:00:07.333205 :B343C01C:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-17 16:00:07.333206 :B343C01D:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-17 16:00:07.333206 :B343C01E:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-17 16:00:07.333207 :B343C01F:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-17 16:00:07.333207 :B343C020:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-17 16:00:07.333762 :B343C021: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-07-17 16:00:07.333808 :B343C027: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-07-17 16:00:07.336300 :B343C035: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-07-17 16:00:07.341317 :B343C03D: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-07-17 16:00:07.342396 :B343C045: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-07-17 16:00:07.342884 :B343C04D: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-07-17 16:00:07.343328 :B343C055: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-07-17 16:00:07.343761 :B343C05D: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-07-17 16:00:07.346340 :B343C065: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-07-17 16:00:07.347405 :B343C06D: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-07-17 16:00:07.396584 :B343C075: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-07-17 16:00:07.397450 :B343C07D: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-07-17 16:00:07.397680 :B343C085: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-07-17 16:00:07.397921 :B343C08D: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-07-17 16:00:07.399822 :B343C095:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-17 22:00:02.051204 :B36078DB:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-17 22:00:02.040 2025-07-17 22:00:02.051205 :B36078DC:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17404 pso_num=29 pso_serial#=37 2025-07-17 22:00:02.051332 :B36078E0:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=17404 osp_idx=27 osp_ver=14571 osp_pg=0 (spawn #395828) 2025-07-17 22:00:02.051333 :B36078E1:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-17 22:00:02.051333 :B36078E2:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=211 time=1470377939 2025-07-17 22:00:02.051334 :B36078E3:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-17 22:00:02.051334 :B36078E4:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-17 22:00:02.051335 :B36078E5:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-17 22:00:02.051335 :B36078E6:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-17 22:00:02.051335 :B36078E7:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-17 22:00:02.051848 :B36078EE: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-07-17 22:00:02.056771 :B3607905: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-07-17 22:00:02.056808 :B3607908:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-07-17 22:00:02.074280 :B3607AD1: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-07-17 22:00:02.074467 :B3607AD9: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-07-17 22:00:02.074651 :B3607AE1: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-07-17 22:00:02.074826 :B3607AE9: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-07-17 22:00:02.075001 :B3607AF1: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-07-17 22:00:02.075163 :B3607AF9: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-07-17 22:00:02.075315 :B3607B01: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-07-17 22:00:02.075469 :B3607B09: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-07-17 22:00:02.075623 :B3607B11: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-07-17 22:00:02.075779 :B3607B19: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-07-17 22:00:02.075928 :B3607B21: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-07-17 22:00:02.076079 :B3607B29: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-07-17 22:00:02.076268 :B3607B31: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-07-17 22:00:02.076425 :B3607B39: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-07-17 22:00:02.076585 :B3607B41: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-07-17 22:00:02.076740 :B3607B49: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-07-17 22:00:02.077090 :B3607B51: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-07-17 22:00:02.077344 :B3607B59: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-07-17 22:00:02.077518 :B3607B61: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-07-17 22:00:02.077792 :B3607B69: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-07-17 22:00:02.078044 :B3607B71: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-07-17 22:00:02.078292 :B3607B79: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-07-17 22:00:02.078924 :B3607B81: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-07-17 22:00:02.079149 :B3607B89: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-07-17 22:00:02.079419 :B3607B91: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-07-17 22:00:02.079575 :B3607B99: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-07-17 22:00:02.079733 :B3607BA1: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-07-17 22:00:02.079890 :B3607BA9: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-07-17 22:00:02.106181 :B3607BB1: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-07-17 22:00:03.107054*:B3607D1C:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000325D3AD0 estart=1752760803 eid=20454653 ctx=0x0000000777968158 cwh=0x000000002B560AB8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-07-17 22:00:03.107054*:B3607D1D:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000325D3AD0 curCtx=0x000000004F11C4B8 pubTabIdxCnt=0 2025-07-17 22:00:03.107054*:B3607D1E:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000325D3AD0 2025-07-17 22:00:03.107054*:B3607D1F:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000325D3AD0 2025-07-17 22:00:03.107054*:B3607D20:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003260AAF8 estart=1752760802 eid=16777459 ctx=0x000000077B54EAC8 cwh=0x000000002B560608 cpu=828125 buffg=46736 interb=196608 r=24 rb=196608 w=0 wb=0 2025-07-17 22:00:03.107054*:B3607D21:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003260AAF8 curCtx=0x000000004EF31240 pubTabIdxCnt=0 2025-07-17 22:00:03.107054*:B3607D22:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003260AAF8 2025-07-17 22:00:03.107054*:B3607D23:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003260AAF8 2025-07-17 22:00:03.107054*:B3607D24:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000325D3AD0 curCtx=0x000000004F11C4B8 xsc->flg4=65792 flags=1 2025-07-17 22:00:03.107054*:B3607D25:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000325D3AD0 2025-07-17 22:00:03.764208 :B3607E4A:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 8, ext 1, nex 3 2025-07-17 22:00:03.764217 :B3607E4B:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00815e03 where: kdiwh22: kdifind 2025-07-17 22:00:03.764217*:B3607E64:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003260AAF8 curCtx=0x000000004EF31240 xsc->flg4=65792 flags=2 2025-07-17 22:00:03.764217*:B3607E65:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003260AAF8 2025-07-17 22:00:03.768681 :B3607E66: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-07-17 22:00:03.788917 :B3607E6E: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-07-17 22:00:03.790745 :B3607E86:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-07-17 22:00:03.790942 :B3607E8F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-07-17 22:00:03.791882 :B3607E98: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-07-17 22:00:03.791963 :B3607E9B: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-07-17 22:00:03.792812 :B3607EAD: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-07-17 22:00:03.794275 :B3607EBD: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-07-17 22:00:03.794535 :B3607EC5: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-07-17 22:00:03.857936*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-07-17 22:00:03.857936*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-17 22:00:03.857936*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-17 22:00:03.857936*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-07-17 22:00:03.857936*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-07-17 22:00:03.857936*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-17 22:00:03.857936*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-17 22:00:03.935837 :B3607F6F: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-07-17 22:00:05.813155 :B36080E7: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-07-17 22:00:05.813167 :B36080E8:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0008.01b.0000cf2d 2025-07-17 22:00:08.271969 :B36082AC: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-07-17 22:00:08.273404 :B36082B4: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-07-17 22:00:08.284340 :B36082BC: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-07-17 22:00:08.311293 :B36082C4: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-07-17 22:00:09.457791 :B360839A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:jslv.c:9203 2025-07-17 22:00:09.468119 :B360839B: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-07-17 22:00:09.469673 :B36083A3:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 29 (osid: 17404, J003)