Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250719060010\orcl_j003_17148_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:36218M/63366M, Ph+PgF:42143M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 17148, image: ORACLE.EXE (J003) *** 2025-07-19 06:00:10.486 *** 2025-07-19 06:00:10.486 Process diagnostic dump for ORACLE.EXE (J003), OS id=17148, pid: 29, proc_ser: 135, 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-19 06:00:10.486 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 17148, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-19 00:04:40.857105 :B3DE7A2C:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 00:04:40.847 2025-07-19 00:04:40.857108 :B3DE7A2D:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18548 pso_num=29 pso_serial#=122 2025-07-19 00:04:40.857242 :B3DE7A2E:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18548 (legacy spawn) 2025-07-19 00:04:40.863776 :B3DE7A2F:db_trace:ksl2.c@14083:ksl_update_post_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-19 00:04:40.863940 :B3DE7A38: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-19 00:04:40.864776 :B3DE7A39:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 00:04:43.093054 :B3DE7AFA:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 00:04:43.080 2025-07-19 00:04:43.093056 :B3DE7AFB:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=1400 pso_num=29 pso_serial#=123 2025-07-19 00:04:43.093200 :B3DE7AFC:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=1400 (legacy spawn) 2025-07-19 00:04:43.099758 :B3DE7AFD:db_trace:ksl2.c@14083:ksl_update_post_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-19 00:04:43.099939 :B3DE7B06: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-19 00:04:43.100747 :B3DE7B07:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 00:04:43.109384 :B3DE7B0A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 00:04:43.096 2025-07-19 00:04:43.109386 :B3DE7B0B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19080 pso_num=29 pso_serial#=124 2025-07-19 00:04:43.109566 :B3DE7B0C:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19080 (legacy spawn) 2025-07-19 00:04:43.116039 :B3DE7B0D:db_trace:ksl2.c@14083:ksl_update_post_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-19 00:04:43.116223 :B3DE7B16: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-19 00:04:43.117035 :B3DE7B17:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 00:05:30.303322 :B3DE91CE:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 00:05:30.296 2025-07-19 00:05:30.303324 :B3DE91CF:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=16176 pso_num=29 pso_serial#=125 2025-07-19 00:05:30.303468 :B3DE91D0:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=16176 (legacy spawn) 2025-07-19 00:05:30.309993 :B3DE91D1:db_trace:ksl2.c@14083:ksl_update_post_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-19 00:05:30.404822 :B3DE91D4:db_trace:ksl2.c@14083:ksl_update_post_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-19 00:05:30.460271 :B3DE91D7: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-19 00:05:30.461235 :B3DE91E8:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 00:05:48.935829 :B3DE979E:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 00:05:48.926 2025-07-19 00:05:48.935831 :B3DE979F:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19300 pso_num=29 pso_serial#=126 2025-07-19 00:05:48.935969 :B3DE97A0:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19300 (legacy spawn) 2025-07-19 00:05:48.942416 :B3DE97A1:db_trace:ksl2.c@14083:ksl_update_post_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-19 00:05:48.942585 :B3DE97A6: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-19 00:05:48.943406 :B3DE97AB:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 00:05:52.610369 :B3DE98EA:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 00:05:52.595 2025-07-19 00:05:52.610371 :B3DE98EB:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=8228 pso_num=29 pso_serial#=127 2025-07-19 00:05:52.610507 :B3DE98EC:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=8228 (legacy spawn) 2025-07-19 00:05:52.617442 :B3DE98F0:db_trace:ksl2.c@14083:ksl_update_post_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-19 00:05:52.617623 :B3DE98F8: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-19 00:05:52.618465 :B3DE98FA:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 01:00:24.027402 :B3E2E722:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 01:00:24.013 2025-07-19 01:00:24.027404 :B3E2E723:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18400 pso_num=29 pso_serial#=128 2025-07-19 01:00:24.027559 :B3E2E724:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18400 (legacy spawn) 2025-07-19 01:00:24.034031 :B3E2E725:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:24.034206 :B3E2E72E: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-19 01:00:24.035013 :B3E2E72F:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 01:00:24.293582 :B3E2E732:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 01:00:24.279 2025-07-19 01:00:24.293583 :B3E2E733:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=9900 pso_num=29 pso_serial#=129 2025-07-19 01:00:24.293717 :B3E2E734:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=9900 (legacy spawn) 2025-07-19 01:00:24.300309 :B3E2E735:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:24.300488 :B3E2E73E: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-19 01:00:24.301345 :B3E2E73F:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 01:00:24.310332 :B3E2E742:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 01:00:24.295 2025-07-19 01:00:24.310334 :B3E2E743:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18776 pso_num=29 pso_serial#=130 2025-07-19 01:00:24.310531 :B3E2E744:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18776 (legacy spawn) 2025-07-19 01:00:24.317234 :B3E2E745:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:24.317403 :B3E2E74D: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-19 01:00:24.318245 :B3E2E74F:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 01:00:26.318631 :B3E2E80C:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 01:00:26.310 2025-07-19 01:00:26.318633 :B3E2E80D:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17700 pso_num=29 pso_serial#=131 2025-07-19 01:00:26.318771 :B3E2E80E:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=17700 (legacy spawn) 2025-07-19 01:00:26.325594 :B3E2E80F:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:26.325871 :B3E2E818: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-19 01:00:26.326841 :B3E2E819:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 01:00:27.493094 :B3E2E852:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 01:00:27.482 2025-07-19 01:00:27.493096 :B3E2E853:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19252 pso_num=29 pso_serial#=132 2025-07-19 01:00:27.493249 :B3E2E854:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19252 (legacy spawn) 2025-07-19 01:00:27.499813 :B3E2E855:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:27.499975 :B3E2E85A: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-19 01:00:27.500771 :B3E2E85F:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 01:00:27.509479 :B3E2E862:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 01:00:27.498 2025-07-19 01:00:27.509481 :B3E2E863:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=4056 pso_num=29 pso_serial#=133 2025-07-19 01:00:27.509616 :B3E2E864:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=4056 (legacy spawn) 2025-07-19 01:00:27.516169 :B3E2E865:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:27.516329 :B3E2E86E: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-19 01:00:27.517148 :B3E2E86F:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 01:00:28.910215 :B3E2EA4E:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 01:00:28.905 2025-07-19 01:00:28.910217 :B3E2EA4F:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=7464 pso_num=29 pso_serial#=134 2025-07-19 01:00:28.910357 :B3E2EA50:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=7464 osp_idx=27 osp_ver=14668 osp_pg=0 (spawn #399581) 2025-07-19 01:00:28.910358 :B3E2EA51: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-19 01:00:28.910359 :B3E2EA52:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=224 time=1567604798 2025-07-19 01:00:28.910360 :B3E2EA53:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-19 01:00:28.910360 :B3E2EA54:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-19 01:00:28.910360 :B3E2EA55:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-19 01:00:28.910361 :B3E2EA56:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-19 01:00:28.910361 :B3E2EA57:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-19 01:00:28.910847 :B3E2EA58: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-19 01:00:28.910894 :B3E2EA5E: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-19 01:00:28.915422 :B3E2EA71:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:28.938054 :B3E2EA79:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:28.953325 :B3E2EA81:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:28.984141 :B3E2EA89:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:28.987844 :B3E2EA91:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:28.991537 :B3E2EA99:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:28.995728 :B3E2EAA1:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:28.996853 :B3E2EAA9:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:30.233198*:B3E2EAE6:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002B533718 estart=1752858029 eid=16780037 ctx=0x0000000787AB4BF0 cwh=0x000000002B520410 cpu=15625 buffg=0 interb=0 r=0 rb=0 w=0 wb=0 2025-07-19 01:00:30.233198*:B3E2EAE7:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002B533718 curCtx=0x000000002DB8CEE0 pubTabIdxCnt=0 2025-07-19 01:00:30.233198*:B3E2EAE8:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002B533718 2025-07-19 01:00:30.233198*:B3E2EAE9:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002B533718 2025-07-19 01:00:30.233198*:B3E2EAEA:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002B533718 curCtx=0x000000002DB8CEE0 xsc->flg4=65792 flags=2 2025-07-19 01:00:30.233198*:B3E2EAEB:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002B533718 2025-07-19 01:00:30.247491 :B3E2EAEC:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:30.286664 :B3E2EAF4:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:30.287032 :B3E2EAFC:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:30.287318 :B3E2EB04:db_trace:ksl2.c@14083:ksl_update_post_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-19 01:00:30.287334 :B3E2EB07: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-19 01:00:30.287400 :B3E2EB17: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-19 01:00:30.290569 :B3E2EB21:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-19 06:00:01.940159 :B3FADDEF:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-19 06:00:01.929 2025-07-19 06:00:01.940161 :B3FADDF0:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17148 pso_num=29 pso_serial#=135 2025-07-19 06:00:01.940367 :B3FADDF6:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=17148 osp_idx=27 osp_ver=14669 osp_pg=0 (spawn #400276) 2025-07-19 06:00:01.940368 :B3FADDF7: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-19 06:00:01.940368 :B3FADDF8:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=225 time=1585577829 2025-07-19 06:00:01.940368 :B3FADDF9:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-19 06:00:01.940368 :B3FADDFA:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-19 06:00:01.940368 :B3FADDFB:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-19 06:00:01.940369 :B3FADDFC:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-19 06:00:01.940369 :B3FADDFD:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-19 06:00:01.940909 :B3FADDFE: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-19 06:00:01.945989 :B3FADE15:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.946035 :B3FADE1A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-07-19 06:00:01.964224 :B3FAE003:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.964595 :B3FAE00B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.964758 :B3FAE013:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.964911 :B3FAE01B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.965063 :B3FAE023:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.965208 :B3FAE02B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.965372 :B3FAE033:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.965527 :B3FAE03B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.965670 :B3FAE043:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.965807 :B3FAE04B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.965955 :B3FAE053:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.966104 :B3FAE05B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.966253 :B3FAE063:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.966396 :B3FAE06B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.966574 :B3FAE073:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.966724 :B3FAE07B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.966878 :B3FAE083:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.967029 :B3FAE08B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.967176 :B3FAE093:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.967338 :B3FAE09B:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.967530 :B3FAE0A3:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.967680 :B3FAE0AB:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.967830 :B3FAE0B3:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.967978 :B3FAE0BB:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.968133 :B3FAE0C3:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:01.988079 :B3FAE0CB:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:03.535598*:B3FAE409:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000325D3AD0 estart=1752876003 eid=20491565 ctx=0x0000000777968158 cwh=0x00000000326009C8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-07-19 06:00:03.535598*:B3FAE40A:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000325D3AD0 curCtx=0x000000004F0D7918 pubTabIdxCnt=0 2025-07-19 06:00:03.535598*:B3FAE40B:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000325D3AD0 2025-07-19 06:00:03.535598*:B3FAE40C:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000325D3AD0 2025-07-19 06:00:03.535598*:B3FAE40D:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003264B6F0 estart=1752876001 eid=16777461 ctx=0x000000077B54EAC8 cwh=0x0000000032600518 cpu=1343750 buffg=74427 interb=196608 r=24 rb=196608 w=0 wb=0 2025-07-19 06:00:03.535598*:B3FAE40E:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003264B6F0 curCtx=0x000000004EFB87D0 pubTabIdxCnt=0 2025-07-19 06:00:03.535598*:B3FAE40F:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003264B6F0 2025-07-19 06:00:03.535598*:B3FAE410:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003264B6F0 2025-07-19 06:00:03.535598*:B3FAE411:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000325D3AD0 curCtx=0x000000004F0D7918 xsc->flg4=65792 flags=1 2025-07-19 06:00:03.535598*:B3FAE412:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000325D3AD0 2025-07-19 06:00:03.644981*:B3FAE483:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003264B6F0 curCtx=0x000000004EFB87D0 xsc->flg4=65792 flags=2 2025-07-19 06:00:03.644981*:B3FAE484:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003264B6F0 2025-07-19 06:00:03.650803 :B3FAE485:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:03.672048 :B3FAE4CE:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:03.673880 :B3FAE4D6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-07-19 06:00:03.674068 :B3FAE4D7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-07-19 06:00:03.675048 :B3FAE4D8:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:03.675134 :B3FAE4DB:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:03.676018 :B3FAE4ED:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:03.677612 :B3FAE4F5:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:03.677893 :B3FAE4FD:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:03.738735*: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-19 06:00:03.738735*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-19 06:00:03.738735*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-19 06:00:03.769975*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-07-19 06:00:03.769975*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-07-19 06:00:03.769975*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-19 06:00:03.769975*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-19 06:00:03.836667 :B3FAE505:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:05.753050 :B3FAE5B9:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:05.753062 :B3FAE5BA:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0009.010.0001d3bd 2025-07-19 06:00:08.239771 :B3FAE789:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:08.241190 :B3FAE791:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:08.252310 :B3FAE799:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:08.279548 :B3FAE7A1:db_trace:ksl2.c@14083:ksl_update_post_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-19 06:00:09.448157 :B3FAE928:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:jslv.c:9203 2025-07-19 06:00:09.466194 :B3FAE929: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-19 06:00:09.467854 :B3FAE931: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: 17148, J003)