Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250904220009\orcl_j003_24232_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:35038M/63366M, Ph+PgF:39917M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 24232, image: ORACLE.EXE (J003) *** 2025-09-04 22:00:09.528 *** 2025-09-04 22:00:09.528 Process diagnostic dump for ORACLE.EXE (J003), OS id=24232, pid: 29, proc_ser: 97, 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-09-04 22:00:09.528 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 24232, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-09-04 00:05:41.641292 :C8A43882: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-09-04 00:05:41.642142 :C8A43883:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 00:05:43.684064 :C8A438F4:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 00:05:43.669 2025-09-04 00:05:43.684066 :C8A438F5:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21176 pso_num=29 pso_serial#=86 2025-09-04 00:05:43.684212 :C8A438F6:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21176 (legacy spawn) 2025-09-04 00:05:43.691064 :C8A438F7: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-09-04 00:05:43.691255 :C8A438FC: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-09-04 00:05:43.692123 :C8A43901:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 00:05:43.701422 :C8A43904:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 00:05:43.701 2025-09-04 00:05:43.701424 :C8A43905:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=23216 pso_num=29 pso_serial#=87 2025-09-04 00:05:43.701557 :C8A43906:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=23216 (legacy spawn) 2025-09-04 00:05:43.708430 :C8A43907: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-09-04 00:05:43.708618 :C8A43910: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-09-04 00:05:43.709564 :C8A43911:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 00:05:45.149009 :C8A43AAB:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 00:05:45.138 2025-09-04 00:05:45.149012 :C8A43AAC:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=14024 pso_num=29 pso_serial#=88 2025-09-04 00:05:45.149148 :C8A43AAD:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=14024 (legacy spawn) 2025-09-04 00:05:45.155636 :C8A43AAE: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-09-04 00:05:45.155807 :C8A43AB3: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-09-04 00:05:45.156609 :C8A43AB8:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 01:00:11.787464 :C8A88A34:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 01:00:11.785 2025-09-04 01:00:11.787466 :C8A88A35:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18748 pso_num=29 pso_serial#=89 2025-09-04 01:00:11.787611 :C8A88A36:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18748 (legacy spawn) 2025-09-04 01:00:11.794101 :C8A88A37: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-09-04 01:00:11.794274 :C8A88A40: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-09-04 01:00:11.795084 :C8A88A41:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 01:00:11.803872 :C8A88A50:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 01:00:11.800 2025-09-04 01:00:11.803874 :C8A88A51:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=22436 pso_num=29 pso_serial#=90 2025-09-04 01:00:11.804019 :C8A88A52:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=22436 (legacy spawn) 2025-09-04 01:00:11.810485 :C8A88A53: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-09-04 01:00:11.810656 :C8A88A5B: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-09-04 01:00:11.811471 :C8A88A5C:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 01:00:14.885877 :C8A88B77:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 01:00:14.873 2025-09-04 01:00:14.885880 :C8A88B78:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=22976 pso_num=29 pso_serial#=91 2025-09-04 01:00:14.886017 :C8A88B79:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=22976 (legacy spawn) 2025-09-04 01:00:14.892534 :C8A88B7A: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-09-04 01:00:14.892705 :C8A88B83: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-09-04 01:00:14.893543 :C8A88B84:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 01:00:14.912157 :C8A88B87:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 01:00:14.904 2025-09-04 01:00:14.912159 :C8A88B88:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=4160 pso_num=29 pso_serial#=92 2025-09-04 01:00:14.912293 :C8A88B89:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=4160 (legacy spawn) 2025-09-04 01:00:14.918762 :C8A88B8A: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-09-04 01:00:14.918926 :C8A88B93: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-09-04 01:00:14.919844 :C8A88B94:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 01:00:19.165339 :C8A88CF9:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 01:00:19.156 2025-09-04 01:00:19.165341 :C8A88CFA:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=22760 pso_num=29 pso_serial#=93 2025-09-04 01:00:19.165511 :C8A88CFB:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=22760 (legacy spawn) 2025-09-04 01:00:19.171966 :C8A88CFC: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-09-04 01:00:19.172129 :C8A88D01: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-09-04 01:00:19.172994 :C8A88D06:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 01:00:25.805679 :C8A88F1A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 01:00:25.797 2025-09-04 01:00:25.805681 :C8A88F1B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=24544 pso_num=29 pso_serial#=94 2025-09-04 01:00:25.805819 :C8A88F1C:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=24544 (legacy spawn) 2025-09-04 01:00:25.812401 :C8A88F1D: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-09-04 01:00:25.812636 :C8A88F25: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-09-04 01:00:25.813505 :C8A88F27:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 01:00:26.458323 :C8A88F63:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 01:00:26.453 2025-09-04 01:00:26.458325 :C8A88F64:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21492 pso_num=29 pso_serial#=95 2025-09-04 01:00:26.458463 :C8A88F65:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=21492 osp_idx=27 osp_ver=16924 osp_pg=0 (spawn #556240) 2025-09-04 01:00:26.458464 :C8A88F66:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 01:00:26.458465 :C8A88F67:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=114 time=1333277768 2025-09-04 01:00:26.458465 :C8A88F68:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 01:00:26.458465 :C8A88F69:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 01:00:26.458466 :C8A88F6A:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 01:00:26.458466 :C8A88F6B:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 01:00:26.458466 :C8A88F6C:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 01:00:26.458975 :C8A88F6D: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-09-04 01:00:26.459025 :C8A88F73: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-09-04 01:00:26.463599 :C8A88F86: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-09-04 01:00:26.488278 :C8A88F8E: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-09-04 01:00:26.502835 :C8A88F96: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-09-04 01:00:26.537254 :C8A88F9E: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-09-04 01:00:26.541161 :C8A88FA6: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-09-04 01:00:26.541491 :C8A88FAE: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-09-04 01:00:26.545293 :C8A88FB6: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-09-04 01:00:26.548016 :C8A88FBE: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-09-04 01:00:26.549716 :C8A88FC6: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-09-04 01:00:26.550893 :C8A88FCE: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-09-04 01:00:26.554621 :C8A88FD6: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-09-04 01:00:27.783291 :C8A89039: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-09-04 01:00:27.827476 :C8A89041: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-09-04 01:00:27.827764 :C8A89049: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-09-04 01:00:27.828034 :C8A89051: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-09-04 01:00:27.828069 :C8A89055: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-09-04 01:00:27.828116 :C8A8905F:db_trace:kcrfw.c@4522:kcrf_commit_force(): [10021:29:233:13] 0000000000000000 2025-09-04 01:00:27.831181 :C8A89078:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 16:00:14.221826 :C8F017E9:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 16:00:14.214 2025-09-04 16:00:14.221829 :C8F017EA:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19064 pso_num=29 pso_serial#=96 2025-09-04 16:00:14.221986 :C8F017EB:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=19064 osp_idx=27 osp_ver=16925 osp_pg=0 (spawn #558317) 2025-09-04 16:00:14.221986 :C8F017EC:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 16:00:14.221987 :C8F017ED:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=115 time=1387265502 2025-09-04 16:00:14.221987 :C8F017EE:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 16:00:14.221987 :C8F017EF:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 16:00:14.221988 :C8F017F0:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 16:00:14.221988 :C8F017F1:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 16:00:14.221989 :C8F017F2:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 16:00:14.222524 :C8F017F3: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-09-04 16:00:14.222571 :C8F017F9: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-09-04 16:00:14.230712 :C8F01807: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-09-04 16:00:14.231866 :C8F0180F: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-09-04 16:00:14.232436 :C8F01817: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-09-04 16:00:14.232904 :C8F0181F: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-09-04 16:00:14.233334 :C8F01827: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-09-04 16:00:14.235985 :C8F0182F: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-09-04 16:00:14.237151 :C8F01837: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-09-04 16:00:14.289322 :C8F0184B: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-09-04 16:00:14.290264 :C8F01853: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-09-04 16:00:14.290510 :C8F0185B: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-09-04 16:00:14.290727 :C8F01863: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-09-04 16:00:14.292718 :C8F0186B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-09-04 22:00:02.041864 :C90C615E:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 09-04 22:00:02.035 2025-09-04 22:00:02.041865 :C90C615F:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=24232 pso_num=29 pso_serial#=97 2025-09-04 22:00:02.042000 :C90C6164:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=24232 osp_idx=27 osp_ver=16926 osp_pg=0 (spawn #559151) 2025-09-04 22:00:02.042001 :C90C6165:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:00:02.042002 :C90C6166:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=116 time=1408853346 2025-09-04 22:00:02.042002 :C90C6167:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:00:02.042003 :C90C6168:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:00:02.042003 :C90C6169:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:00:02.042004 :C90C616A:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:00:02.042005 :C90C616B:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:00:02.042507 :C90C6171: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-09-04 22:00:02.047433 :C90C6190: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-09-04 22:00:02.047471 :C90C6195:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-09-04 22:00:02.065575 :C90C636C: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-09-04 22:00:02.065783 :C90C6374: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-09-04 22:00:02.065956 :C90C637C: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-09-04 22:00:02.066111 :C90C6384: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-09-04 22:00:02.066275 :C90C638C: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-09-04 22:00:02.066457 :C90C6394: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-09-04 22:00:02.066634 :C90C639C: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-09-04 22:00:02.066783 :C90C63A4: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-09-04 22:00:02.066942 :C90C63AC: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-09-04 22:00:02.067093 :C90C63B4: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-09-04 22:00:02.067254 :C90C63BC: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-09-04 22:00:02.067400 :C90C63C4: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-09-04 22:00:02.067591 :C90C63CC: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-09-04 22:00:02.067863 :C90C63D4: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-09-04 22:00:02.068036 :C90C63DC: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-09-04 22:00:02.068196 :C90C63E4: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-09-04 22:00:02.068356 :C90C63EC: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-09-04 22:00:02.068507 :C90C63F4: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-09-04 22:00:02.068673 :C90C63FC: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-09-04 22:00:02.068885 :C90C6404: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-09-04 22:00:02.069049 :C90C640C: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-09-04 22:00:02.069209 :C90C6414: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-09-04 22:00:02.069361 :C90C641C: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-09-04 22:00:02.069994 :C90C6424: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-09-04 22:00:02.070226 :C90C642C: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-09-04 22:00:02.096827 :C90C6434: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-09-04 22:00:03.473406*:C90C66DA:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000031233AD0 estart=1756994402 eid=22046753 ctx=0x0000000777968158 cwh=0x000000005CE90158 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-09-04 22:00:03.473406*:C90C66DB:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000031233AD0 curCtx=0x000000005CD91BF8 pubTabIdxCnt=0 2025-09-04 22:00:03.473406*:C90C66DC:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000031233AD0 2025-09-04 22:00:03.473406*:C90C66DD:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000031233AD0 2025-09-04 22:00:03.473406*:C90C66DE:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000312AB6F0 estart=1756994401 eid=16777564 ctx=0x000000077B54EAC8 cwh=0x00000000312A0068 cpu=1187500 buffg=65697 interb=196608 r=24 rb=196608 w=0 wb=0 2025-09-04 22:00:03.473406*:C90C66DF:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000312AB6F0 curCtx=0x000000005CD87FD8 pubTabIdxCnt=0 2025-09-04 22:00:03.473406*:C90C66E0:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000312AB6F0 2025-09-04 22:00:03.473406*:C90C66E1:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000312AB6F0 2025-09-04 22:00:03.473406*:C90C66E2:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000031233AD0 curCtx=0x000000005CD91BF8 xsc->flg4=65792 flags=1 2025-09-04 22:00:03.473406*:C90C66E3:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000031233AD0 2025-09-04 22:00:03.754653*:C90C6724:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000312AB6F0 curCtx=0x000000005CD87FD8 xsc->flg4=65792 flags=2 2025-09-04 22:00:03.754653*:C90C6725:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000312AB6F0 2025-09-04 22:00:03.760594 :C90C6726: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-09-04 22:00:03.783927 :C90C675F: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-09-04 22:00:03.786415 :C90C6767:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-09-04 22:00:03.786681 :C90C6768:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-09-04 22:00:03.787770 :C90C6769: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-09-04 22:00:03.787898 :C90C676C: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-09-04 22:00:03.789111 :C90C677E: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-09-04 22:00:03.791213 :C90C6786: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-09-04 22:00:03.791603 :C90C678E: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-09-04 22:00:03.848413*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-09-04 22:00:03.848413*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-09-04 22:00:03.848413*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-09-04 22:00:03.864031*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-09-04 22:00:03.864031*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-09-04 22:00:03.864031*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-09-04 22:00:03.864031*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-09-04 22:00:03.941608 :C90C681A: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-09-04 22:00:05.822464 :C90C6996: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-09-04 22:00:05.822476 :C90C6997:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0008.007.0000d380 2025-09-04 22:00:08.197839 :C90C6B19: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-09-04 22:00:08.202217 :C90C6B23: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-09-04 22:00:08.213170 :C90C6B31: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-09-04 22:00:08.243384 :C90C6B45: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-09-04 22:00:09.335409 :C90C6C3C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:jslv.c:9203 2025-09-04 22:00:09.347486 :C90C6C3D: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-09-04 22:00:09.349012 :C90C6C45: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: 24232, J003)