Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250723220009\orcl_j003_18156_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:36072M/63366M, Ph+PgF:41911M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 18156, image: ORACLE.EXE (J003) *** 2025-07-23 22:00:09.450 *** 2025-07-23 22:00:09.450 Process diagnostic dump for ORACLE.EXE (J003), OS id=18156, pid: 29, proc_ser: 117, 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-23 22:00:09.450 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 18156, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-23 00:05:33.065223 :B5A91C70:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=6356 (legacy spawn) 2025-07-23 00:05:33.071797 :B5A91C71: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-23 00:05:33.071970 :B5A91C7A: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-23 00:05:33.072772 :B5A91C7B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 00:05:33.081446 :B5A91C7E:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 00:05:33.068 2025-07-23 00:05:33.081448 :B5A91C7F:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=10908 pso_num=29 pso_serial#=107 2025-07-23 00:05:33.081582 :B5A91C80:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=10908 (legacy spawn) 2025-07-23 00:05:33.088013 :B5A91C81: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-23 00:05:33.088173 :B5A91C8A: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-23 00:05:33.088993 :B5A91C8B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 00:05:38.913590 :B5A91E66:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 00:05:38.900 2025-07-23 00:05:38.913592 :B5A91E67:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=15280 pso_num=29 pso_serial#=108 2025-07-23 00:05:38.913789 :B5A91E68:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=15280 (legacy spawn) 2025-07-23 00:05:38.920228 :B5A91E69: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-23 00:05:38.920411 :B5A91E6F: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-23 00:05:38.932929 :B5A91E73:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 00:05:51.638583 :B5A9223A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 00:05:51.629 2025-07-23 00:05:51.638585 :B5A9223B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19120 pso_num=29 pso_serial#=109 2025-07-23 00:05:51.638731 :B5A9223C:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19120 (legacy spawn) 2025-07-23 00:05:51.645650 :B5A9223D: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-23 00:05:51.645838 :B5A92242: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-23 00:05:51.646766 :B5A92247:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 01:00:04.343059 :B5AD5DC0:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 01:00:04.334 2025-07-23 01:00:04.343061 :B5AD5DC1:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18288 pso_num=29 pso_serial#=110 2025-07-23 01:00:04.343198 :B5AD5DC2:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18288 (legacy spawn) 2025-07-23 01:00:04.349700 :B5AD5DC3: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-23 01:00:04.349868 :B5AD5DC8: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-23 01:00:04.350708 :B5AD5DCD:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 01:00:05.192265 :B5AD5DDC:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 01:00:05.178 2025-07-23 01:00:05.192267 :B5AD5DDD:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19152 pso_num=29 pso_serial#=111 2025-07-23 01:00:05.192406 :B5AD5DDE:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19152 (legacy spawn) 2025-07-23 01:00:05.199141 :B5AD5DDF: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-23 01:00:05.199329 :B5AD5DE8: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-23 01:00:05.200186 :B5AD5DE9:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 01:00:05.209236 :B5AD5DEC:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 01:00:05.194 2025-07-23 01:00:05.209238 :B5AD5DED:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=10556 pso_num=29 pso_serial#=112 2025-07-23 01:00:05.209370 :B5AD5DEE:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=10556 (legacy spawn) 2025-07-23 01:00:05.216002 :B5AD5DEF: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-23 01:00:05.216166 :B5AD5DF8: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-23 01:00:05.216986 :B5AD5DF9:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 01:00:12.592207 :B5AD60A9:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 01:00:12.587 2025-07-23 01:00:12.592208 :B5AD60AA:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17836 pso_num=29 pso_serial#=113 2025-07-23 01:00:12.592347 :B5AD60AB:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=17836 osp_idx=27 osp_ver=14902 osp_pg=0 (spawn #412907) 2025-07-23 01:00:12.592348 :B5AD60AC: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-23 01:00:12.592349 :B5AD60AD:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=11 time=1913188486 2025-07-23 01:00:12.592349 :B5AD60AE:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-23 01:00:12.592349 :B5AD60AF:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-23 01:00:12.592350 :B5AD60B0:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-23 01:00:12.592350 :B5AD60B1:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-23 01:00:12.592350 :B5AD60B2:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-23 01:00:12.592849 :B5AD60B3: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-23 01:00:12.592892 :B5AD60B9: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-23 01:00:12.597338 :B5AD60CC: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-23 01:00:12.620345 :B5AD60D4: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-23 01:00:12.635586 :B5AD60DC: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-23 01:00:12.665569 :B5AD60E4: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-23 01:00:12.669191 :B5AD60EC: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-23 01:00:12.669559 :B5AD60F4: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-23 01:00:12.673313 :B5AD60FC: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-23 01:00:12.675996 :B5AD6104: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-23 01:00:12.677838 :B5AD610C: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-23 01:00:12.678873 :B5AD6114: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-23 01:00:12.682629 :B5AD611C: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-23 01:00:13.933115 :B5AD613D: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-23 01:00:13.974461 :B5AD6145: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-23 01:00:13.974820 :B5AD614D: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-23 01:00:13.975102 :B5AD6155: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-23 01:00:13.975118 :B5AD6158: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-23 01:00:13.975183 :B5AD6166: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-23 01:00:13.978520 :B5AD6172:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 01:00:26.932799 :B5AD65EB:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 01:00:26.924 2025-07-23 01:00:26.932801 :B5AD65EC:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17152 pso_num=29 pso_serial#=114 2025-07-23 01:00:26.932944 :B5AD65ED:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=17152 (legacy spawn) 2025-07-23 01:00:26.960067 :B5AD65EE: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-23 01:00:26.960238 :B5AD65F7: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-23 01:00:26.961075 :B5AD65F8:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 01:00:27.041599 :B5AD65FB:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 01:00:27.033 2025-07-23 01:00:27.041601 :B5AD65FC:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18240 pso_num=29 pso_serial#=115 2025-07-23 01:00:27.041733 :B5AD65FD:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18240 (legacy spawn) 2025-07-23 01:00:27.048150 :B5AD65FE: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-23 01:00:27.048322 :B5AD6606: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-23 01:00:27.049165 :B5AD6608:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 16:00:12.581083 :B5F36715:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 16:00:12.566 2025-07-23 16:00:12.581085 :B5F36716:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=16220 pso_num=29 pso_serial#=116 2025-07-23 16:00:12.581235 :B5F36717:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=16220 osp_idx=27 osp_ver=14905 osp_pg=0 (spawn #414986) 2025-07-23 16:00:12.581236 :B5F36718: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-23 16:00:12.581237 :B5F36719:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=12 time=1967188470 2025-07-23 16:00:12.581237 :B5F3671A:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-23 16:00:12.581238 :B5F3671B:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-23 16:00:12.581238 :B5F3671C:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-23 16:00:12.581238 :B5F3671D:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-23 16:00:12.581238 :B5F3671E:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-23 16:00:12.581821 :B5F3671F: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-23 16:00:12.581861 :B5F36725: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-23 16:00:12.589003 :B5F36733: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-23 16:00:12.590124 :B5F3673B: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-23 16:00:12.590702 :B5F36743: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-23 16:00:12.591173 :B5F3674B: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-23 16:00:12.591606 :B5F36753: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-23 16:00:12.594117 :B5F3675B: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-23 16:00:12.595227 :B5F36763: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-23 16:00:12.644658 :B5F3676B: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-23 16:00:12.645545 :B5F36773: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-23 16:00:12.645777 :B5F3677B: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-23 16:00:12.645992 :B5F36783: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-23 16:00:12.647851 :B5F3678B:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-23 22:00:01.788686 :B60FA143:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-23 22:00:01.776 2025-07-23 22:00:01.788687 :B60FA144:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18156 pso_num=29 pso_serial#=117 2025-07-23 22:00:01.788802 :B60FA14A:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=18156 osp_idx=27 osp_ver=14906 osp_pg=0 (spawn #415818) 2025-07-23 22:00:01.788803 :B60FA14B: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-23 22:00:01.788803 :B60FA14C:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=13 time=1988777673 2025-07-23 22:00:01.788804 :B60FA14D:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-23 22:00:01.788804 :B60FA14E:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-23 22:00:01.788805 :B60FA14F:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-23 22:00:01.788805 :B60FA150:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-23 22:00:01.788806 :B60FA151:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-23 22:00:01.789305 :B60FA152: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-23 22:00:01.794246 :B60FA169: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-23 22:00:01.794285 :B60FA16C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-07-23 22:00:01.811489 :B60FA355: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-23 22:00:01.811678 :B60FA35D: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-23 22:00:01.811844 :B60FA365: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-23 22:00:01.812007 :B60FA36D: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-23 22:00:01.812174 :B60FA375: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-23 22:00:01.812345 :B60FA37D: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-23 22:00:01.812516 :B60FA385: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-23 22:00:01.812669 :B60FA38D: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-23 22:00:01.812818 :B60FA395: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-23 22:00:01.812973 :B60FA39D: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-23 22:00:01.813132 :B60FA3A5: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-23 22:00:01.813292 :B60FA3AD: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-23 22:00:01.813463 :B60FA3B5: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-23 22:00:01.813772 :B60FA3BD: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-23 22:00:01.813939 :B60FA3C5: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-23 22:00:01.814102 :B60FA3CD: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-23 22:00:01.814267 :B60FA3D5: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-23 22:00:01.814444 :B60FA3DD: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-23 22:00:01.814604 :B60FA3E5: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-23 22:00:01.814767 :B60FA3ED: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-23 22:00:01.814922 :B60FA3F5: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-23 22:00:01.815079 :B60FA3FD: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-23 22:00:01.815231 :B60FA405: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-23 22:00:01.815860 :B60FA40D: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-23 22:00:01.843054 :B60FA415: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-23 22:00:03.010807*:B60FA616:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000325D3AD0 estart=1753279203 eid=20668929 ctx=0x0000000777968158 cwh=0x00000000510A0158 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-07-23 22:00:03.010807*:B60FA617:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000325D3AD0 curCtx=0x0000000050FA1BF8 pubTabIdxCnt=0 2025-07-23 22:00:03.010807*:B60FA618:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000325D3AD0 2025-07-23 22:00:03.010807*:B60FA619:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000325D3AD0 2025-07-23 22:00:03.010807*:B60FA61A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003265B6F0 estart=1753279201 eid=16777473 ctx=0x000000077B54EAC8 cwh=0x0000000032650068 cpu=1000000 buffg=55649 interb=196608 r=24 rb=196608 w=0 wb=0 2025-07-23 22:00:03.010807*:B60FA61B:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003265B6F0 curCtx=0x0000000050F97FD8 pubTabIdxCnt=0 2025-07-23 22:00:03.010807*:B60FA61C:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003265B6F0 2025-07-23 22:00:03.010807*:B60FA61D:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003265B6F0 2025-07-23 22:00:03.010807*:B60FA61E:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000325D3AD0 curCtx=0x0000000050FA1BF8 xsc->flg4=65792 flags=1 2025-07-23 22:00:03.010807*:B60FA61F:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000325D3AD0 2025-07-23 22:00:03.483889 :B60FA730:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 9, ext 1, nex 2 2025-07-23 22:00:03.483896 :B60FA731:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00815e03 where: kdiwh22: kdifind 2025-07-23 22:00:03.483896*:B60FA732:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003265B6F0 curCtx=0x0000000050F97FD8 xsc->flg4=65792 flags=2 2025-07-23 22:00:03.483896*:B60FA733:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003265B6F0 2025-07-23 22:00:03.492106 :B60FA734: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-23 22:00:03.512380 :B60FA76C: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-23 22:00:03.514204 :B60FA775:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-07-23 22:00:03.514388 :B60FA776:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-07-23 22:00:03.515265 :B60FA777: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-23 22:00:03.515348 :B60FA77A: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-23 22:00:03.516288 :B60FA78C: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-23 22:00:03.517709 :B60FA794: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-23 22:00:03.518016 :B60FA79C: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-23 22:00:03.573325*: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-23 22:00:03.573325*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-23 22:00:03.573325*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-23 22:00:03.620192*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-07-23 22:00:03.620192*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-07-23 22:00:03.620192*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-23 22:00:03.620192*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-23 22:00:03.687656 :B60FA847: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-23 22:00:05.608202 :B60FA95B: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-23 22:00:05.608215 :B60FA95C:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0008.00e.0000cfba 2025-07-23 22:00:07.995678 :B60FAB82: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-23 22:00:07.997064 :B60FAB8A: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-23 22:00:08.001869 :B60FAB92:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 3, ext 0, nex 2 2025-07-23 22:00:08.001879 :B60FAB93:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00800357 where: kduwh01: kdusru 2025-07-23 22:00:08.007854 :B60FAB94: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-23 22:00:08.034523 :B60FAB9C: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-23 22:00:09.184573 :B60FACAC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:jslv.c:9203 2025-07-23 22:00:09.195626 :B60FACAD: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-23 22:00:09.196018 :B60FACB5: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: 18156, J003)