Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250807220009\orcl_j003_17932_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:35668M/63366M, Ph+PgF:41190M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 17932, image: ORACLE.EXE (J003) *** 2025-08-07 22:00:09.897 *** 2025-08-07 22:00:09.897 Process diagnostic dump for ORACLE.EXE (J003), OS id=17932, pid: 29, proc_ser: 13, 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-08-07 22:00:09.897 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 17932, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-07 00:03:29.468711 :BC52F568:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21116 (legacy spawn) 2025-08-07 00:03:29.475218 :BC52F569: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-08-07 00:03:29.475396 :BC52F572: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-08-07 00:03:29.476219 :BC52F573:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:03:29.484891 :BC52F576:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:03:29.470 2025-08-07 00:03:29.484893 :BC52F577:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19996 pso_num=29 pso_serial#=253 2025-08-07 00:03:29.485052 :BC52F578:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19996 (legacy spawn) 2025-08-07 00:03:29.491526 :BC52F579: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-08-07 00:03:29.491711 :BC52F582: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-08-07 00:03:29.492509 :BC52F583:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:03:29.633273 :BC52F586:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:03:29.626 2025-08-07 00:03:29.633275 :BC52F587:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17932 pso_num=29 pso_serial#=254 2025-08-07 00:03:29.633412 :BC52F588:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=17932 (legacy spawn) 2025-08-07 00:03:29.639843 :BC52F589: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-08-07 00:03:29.640012 :BC52F592: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-08-07 00:03:29.640825 :BC52F593:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:03:32.581634 :BC52F683:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:03:32.568 2025-08-07 00:03:32.581635 :BC52F684:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=11764 pso_num=29 pso_serial#=255 2025-08-07 00:03:32.581783 :BC52F685:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=11764 (legacy spawn) 2025-08-07 00:03:32.588908 :BC52F686: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-08-07 00:03:32.589116 :BC52F68B: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-08-07 00:03:32.590010 :BC52F690:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:03:32.607675 :BC52F693:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:03:32.599 2025-08-07 00:03:32.607678 :BC52F694:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21208 pso_num=29 pso_serial#=1 2025-08-07 00:03:32.607824 :BC52F695:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21208 (legacy spawn) 2025-08-07 00:03:32.614691 :BC52F696: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-08-07 00:03:32.614862 :BC52F69F: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-08-07 00:03:32.615770 :BC52F6A0:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:04:26.397964 :BC530865:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:04:26.389 2025-08-07 00:04:26.397966 :BC530866:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18088 pso_num=29 pso_serial#=2 2025-08-07 00:04:26.398099 :BC530867:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18088 (legacy spawn) 2025-08-07 00:04:26.404555 :BC530868: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-08-07 00:04:26.404731 :BC530871: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-08-07 00:04:26.405568 :BC530872:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:04:37.722801 :BC530C04:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:04:37.713 2025-08-07 00:04:37.722803 :BC530C05:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19728 pso_num=29 pso_serial#=3 2025-08-07 00:04:37.722937 :BC530C06:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19728 (legacy spawn) 2025-08-07 00:04:37.729402 :BC530C07: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-08-07 00:04:37.729599 :BC530C0C: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-08-07 00:04:37.730463 :BC530C11:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:05:18.367612 :BC532086:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:05:18.353 2025-08-07 00:05:18.367614 :BC532087:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20328 pso_num=29 pso_serial#=4 2025-08-07 00:05:18.367764 :BC532088:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=20328 (legacy spawn) 2025-08-07 00:05:18.374683 :BC532089: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-08-07 00:05:18.374872 :BC532092: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-08-07 00:05:18.375801 :BC532093:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:05:18.392265 :BC532096:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:05:18.384 2025-08-07 00:05:18.392267 :BC532097:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20560 pso_num=29 pso_serial#=5 2025-08-07 00:05:18.392459 :BC532098:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=20560 (legacy spawn) 2025-08-07 00:05:18.399626 :BC532099: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-08-07 00:05:18.399806 :BC5320A2: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-08-07 00:05:18.400763 :BC5320A3:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:05:21.588254 :BC53218A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:05:21.574 2025-08-07 00:05:21.588256 :BC53218B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20168 pso_num=29 pso_serial#=6 2025-08-07 00:05:21.588400 :BC53218C:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=20168 (legacy spawn) 2025-08-07 00:05:21.595169 :BC53218D: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-08-07 00:05:21.595354 :BC532192: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-08-07 00:05:21.596231 :BC532197:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 00:05:21.605372 :BC53219A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 00:05:21.589 2025-08-07 00:05:21.605374 :BC53219B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21408 pso_num=29 pso_serial#=7 2025-08-07 00:05:21.605536 :BC53219C:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21408 (legacy spawn) 2025-08-07 00:05:21.612360 :BC53219D: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-08-07 00:05:21.612542 :BC5321A6: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-08-07 00:05:21.613405 :BC5321A7:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 01:00:11.426195 :BC575E43:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 01:00:11.421 2025-08-07 01:00:11.426197 :BC575E44:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17868 pso_num=29 pso_serial#=8 2025-08-07 01:00:11.426328 :BC575E45:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=17868 osp_idx=27 osp_ver=15562 osp_pg=0 (spawn #462906) 2025-08-07 01:00:11.426328 :BC575E46:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-07 01:00:11.426328 :BC575E47:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=170 time=3209080736 2025-08-07 01:00:11.426329 :BC575E48:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-07 01:00:11.426329 :BC575E49:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-07 01:00:11.426330 :BC575E4A:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-07 01:00:11.426330 :BC575E4B:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-07 01:00:11.426331 :BC575E4C:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-07 01:00:11.426826 :BC575E4D: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-08-07 01:00:11.426870 :BC575E54: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-08-07 01:00:11.431282 :BC575E66: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-08-07 01:00:11.455559 :BC575E6E: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-08-07 01:00:11.470669 :BC575E76: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-08-07 01:00:11.502252 :BC575E7E: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-08-07 01:00:11.506119 :BC575E86: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-08-07 01:00:11.509890 :BC575E8E: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-08-07 01:00:11.514153 :BC575E96: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-08-07 01:00:11.515300 :BC575E9E: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-08-07 01:00:12.738482 :BC575ED2: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-08-07 01:00:12.783369 :BC575EDA: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-08-07 01:00:12.783673 :BC575EE2: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-08-07 01:00:12.783947 :BC575EEA: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-08-07 01:00:12.783963 :BC575EED: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-08-07 01:00:12.784025 :BC575EFB: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-08-07 01:00:12.786594 :BC575F07:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 01:00:20.067456 :BC576287:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 01:00:20.057 2025-08-07 01:00:20.067458 :BC576288:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19536 pso_num=29 pso_serial#=9 2025-08-07 01:00:20.067593 :BC576289:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19536 (legacy spawn) 2025-08-07 01:00:20.074160 :BC57628A: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-08-07 01:00:20.074347 :BC57628F: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-08-07 01:00:20.075177 :BC576294:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 01:00:25.078416 :BC57645B:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 01:00:25.069 2025-08-07 01:00:25.078419 :BC57645C:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21044 pso_num=29 pso_serial#=10 2025-08-07 01:00:25.078562 :BC57645D:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21044 (legacy spawn) 2025-08-07 01:00:25.085371 :BC57645E: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-08-07 01:00:25.085530 :BC576463: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-08-07 01:00:25.086398 :BC576468:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 01:00:29.672185 :BC576614:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 01:00:29.657 2025-08-07 01:00:29.672187 :BC576615:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18808 pso_num=29 pso_serial#=11 2025-08-07 01:00:29.672329 :BC576616:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18808 (legacy spawn) 2025-08-07 01:00:29.693003 :BC576617: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-08-07 01:00:29.693174 :BC576620: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-08-07 01:00:29.693987 :BC576621:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 01:00:29.702797 :BC576624:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 01:00:29.688 2025-08-07 01:00:29.702799 :BC576625:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20688 pso_num=29 pso_serial#=12 2025-08-07 01:00:29.702937 :BC576626:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=20688 (legacy spawn) 2025-08-07 01:00:29.709359 :BC576627: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-08-07 01:00:29.709542 :BC576630: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-08-07 01:00:29.710345 :BC576631:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-07 22:00:02.055737 :BCB92B3A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-07 22:00:02.049 2025-08-07 22:00:02.055739 :BCB92B3B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17932 pso_num=29 pso_serial#=13 2025-08-07 22:00:02.055896 :BCB92B3E:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=17932 osp_idx=27 osp_ver=15567 osp_pg=0 (spawn #465814) 2025-08-07 22:00:02.055897 :BCB92B3F:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-07 22:00:02.055897 :BCB92B40:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=171 time=3284671361 2025-08-07 22:00:02.055898 :BCB92B41:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-07 22:00:02.055898 :BCB92B42:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-07 22:00:02.055899 :BCB92B43:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-07 22:00:02.055899 :BCB92B44:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-07 22:00:02.055900 :BCB92B45:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-07 22:00:02.056519 :BCB92B52: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-08-07 22:00:02.061557 :BCB92B6E: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-08-07 22:00:02.061596 :BCB92B71:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-08-07 22:00:02.079162 :BCB92D80: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-08-07 22:00:02.079429 :BCB92D88: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-08-07 22:00:02.079602 :BCB92D90: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-08-07 22:00:02.079771 :BCB92D98: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-08-07 22:00:02.080148 :BCB92DA0: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-08-07 22:00:02.080358 :BCB92DA8: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-08-07 22:00:02.080520 :BCB92DB0: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-08-07 22:00:02.080802 :BCB92DB8: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-08-07 22:00:02.081050 :BCB92DC0: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-08-07 22:00:02.081291 :BCB92DC8: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-08-07 22:00:02.081739 :BCB92DD0: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-08-07 22:00:02.082094 :BCB92DD8: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-08-07 22:00:02.082265 :BCB92DE0: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-08-07 22:00:02.082428 :BCB92DE8: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-08-07 22:00:02.082599 :BCB92DF0: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-08-07 22:00:02.109212 :BCB92DF8: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-08-07 22:00:03.111584*:BCB93086:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000325D3AD0 estart=1754575203 eid=21134913 ctx=0x0000000777968158 cwh=0x000000002DC20AB8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-08-07 22:00:03.111584*:BCB93087:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000325D3AD0 curCtx=0x000000005523C4B8 pubTabIdxCnt=0 2025-08-07 22:00:03.111584*:BCB93088:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000325D3AD0 2025-08-07 22:00:03.111584*:BCB93089:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000325D3AD0 2025-08-07 22:00:03.111584*:BCB9308A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003261AAF8 estart=1754575202 eid=16777504 ctx=0x000000077B54EAC8 cwh=0x000000002DC20608 cpu=828125 buffg=47451 interb=196608 r=24 rb=196608 w=0 wb=0 2025-08-07 22:00:03.111584*:BCB9308B:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003261AAF8 curCtx=0x0000000055051240 pubTabIdxCnt=0 2025-08-07 22:00:03.111584*:BCB9308C:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003261AAF8 2025-08-07 22:00:03.111584*:BCB9308D:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003261AAF8 2025-08-07 22:00:03.111584*:BCB9308E:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000325D3AD0 curCtx=0x000000005523C4B8 xsc->flg4=65792 flags=1 2025-08-07 22:00:03.111584*:BCB9308F:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000325D3AD0 2025-08-07 22:00:03.768044*:BCB93189:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003261AAF8 curCtx=0x0000000055051240 xsc->flg4=65792 flags=2 2025-08-07 22:00:03.768044*:BCB9318A:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003261AAF8 2025-08-07 22:00:03.769981 :BCB9318B: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-08-07 22:00:03.791941 :BCB931CD: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-08-07 22:00:03.794108 :BCB931D5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-08-07 22:00:03.794324 :BCB931D6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-08-07 22:00:03.795284 :BCB931D7: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-08-07 22:00:03.795414 :BCB931DC: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-08-07 22:00:03.796339 :BCB931EE: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-08-07 22:00:03.798055 :BCB931F6: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-08-07 22:00:03.798400 :BCB931FE: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-08-07 22:00:03.861813*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-08-07 22:00:03.861813*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-08-07 22:00:03.861813*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-08-07 22:00:03.861813*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-08-07 22:00:03.861813*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-08-07 22:00:03.861813*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-07 22:00:03.861813*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-08-07 22:00:03.939467 :BCB93296: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-08-07 22:00:05.846515 :BCB9342E: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-08-07 22:00:05.846526 :BCB9342F:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0007.019.0000c95c 2025-08-07 22:00:08.359591 :BCB935B1: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-08-07 22:00:08.361026 :BCB935B9: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-08-07 22:00:08.372845 :BCB935C1: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-08-07 22:00:08.401186 :BCB935C9: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-08-07 22:00:09.610760 :BCB936BA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:jslv.c:9203 2025-08-07 22:00:09.623700 :BCB936BB: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-08-07 22:00:09.625683 :BCB936C3: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: 17932, J003)