Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250804220009\orcl_j003_20460_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:35738M/63366M, Ph+PgF:41327M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 20460, image: ORACLE.EXE (J003) *** 2025-08-04 22:00:09.427 *** 2025-08-04 22:00:09.427 Process diagnostic dump for ORACLE.EXE (J003), OS id=20460, pid: 29, proc_ser: 163, 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-04 22:00:09.427 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 20460, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-04 00:05:16.594915 :BAFD1144: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-04 00:05:16.595714 :BAFD1148:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 00:05:16.604343 :BAFD114B:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 00:05:16.590 2025-08-04 00:05:16.604345 :BAFD114C:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=4800 pso_num=29 pso_serial#=151 2025-08-04 00:05:16.604489 :BAFD114D:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=4800 (legacy spawn) 2025-08-04 00:05:16.610989 :BAFD114E:db_trace:ksl2.c@14083:ksl_update_post_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-04 00:05:16.611153 :BAFD1157: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-04 00:05:16.611948 :BAFD1158:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 00:05:18.077390 :BAFD11B7:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 00:05:18.069 2025-08-04 00:05:18.077392 :BAFD11B8:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19544 pso_num=29 pso_serial#=152 2025-08-04 00:05:18.077536 :BAFD11B9:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19544 (legacy spawn) 2025-08-04 00:05:18.083996 :BAFD11BA:db_trace:ksl2.c@14083:ksl_update_post_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-04 00:05:18.084170 :BAFD11BF: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-04 00:05:18.084983 :BAFD11C4:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 00:05:30.738683 :BAFD1755:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 00:05:30.729 2025-08-04 00:05:30.738685 :BAFD1756:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18616 pso_num=29 pso_serial#=153 2025-08-04 00:05:30.738824 :BAFD1757:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18616 (legacy spawn) 2025-08-04 00:05:30.745356 :BAFD1758:db_trace:ksl2.c@14083:ksl_update_post_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-04 00:05:30.745519 :BAFD175E: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-04 00:05:30.746334 :BAFD1762:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 01:00:04.217975 :BB0168F4:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 01:00:04.210 2025-08-04 01:00:04.217977 :BB0168F5:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19000 pso_num=29 pso_serial#=154 2025-08-04 01:00:04.218110 :BB0168F6:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19000 (legacy spawn) 2025-08-04 01:00:04.224582 :BB0168F7:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:04.224765 :BB0168FC: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-04 01:00:04.225591 :BB016902:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 01:00:13.695948 :BB016EB0:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 01:00:13.682 2025-08-04 01:00:13.695950 :BB016EB1:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17492 pso_num=29 pso_serial#=155 2025-08-04 01:00:13.696111 :BB016EB2:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=17492 (legacy spawn) 2025-08-04 01:00:13.703487 :BB016EB3:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:13.703698 :BB016EB8: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-04 01:00:13.704617 :BB016EBD:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 01:00:15.062743 :BB016F41:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 01:00:15.057 2025-08-04 01:00:15.062745 :BB016F42:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=6376 pso_num=29 pso_serial#=156 2025-08-04 01:00:15.062879 :BB016F43:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=6376 osp_idx=27 osp_ver=15455 osp_pg=0 (spawn #452909) 2025-08-04 01:00:15.062880 :BB016F44: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-04 01:00:15.062880 :BB016F45:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=151 time=2949884361 2025-08-04 01:00:15.062881 :BB016F46:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-04 01:00:15.062881 :BB016F47:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-04 01:00:15.062882 :BB016F48:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-04 01:00:15.062882 :BB016F49:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-04 01:00:15.062884 :BB016F4A:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-04 01:00:15.063382 :BB016F4B: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-04 01:00:15.063432 :BB016F51: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-04 01:00:15.071779 :BB016F60:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 01:00:20.479880 :BB017114:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 01:00:20.479 2025-08-04 01:00:20.479883 :BB017115:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20392 pso_num=29 pso_serial#=157 2025-08-04 01:00:20.480060 :BB017116:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=20392 (legacy spawn) 2025-08-04 01:00:20.487422 :BB017117:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:20.487635 :BB017120: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-04 01:00:20.488490 :BB017121:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 01:00:20.520255 :BB017124:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 01:00:20.511 2025-08-04 01:00:20.520256 :BB017125:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18468 pso_num=29 pso_serial#=158 2025-08-04 01:00:20.520396 :BB017126:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18468 (legacy spawn) 2025-08-04 01:00:20.527036 :BB017127:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:20.527200 :BB017130: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-04 01:00:20.528075 :BB017131:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 01:00:23.762081 :BB017226:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 01:00:23.748 2025-08-04 01:00:23.762083 :BB017227:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18460 pso_num=29 pso_serial#=159 2025-08-04 01:00:23.762220 :BB017228:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18460 (legacy spawn) 2025-08-04 01:00:23.768726 :BB017229:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:23.768909 :BB01722E: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-04 01:00:23.769749 :BB017233:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 01:00:23.778740 :BB017236:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 01:00:23.764 2025-08-04 01:00:23.778742 :BB017237:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19272 pso_num=29 pso_serial#=160 2025-08-04 01:00:23.778888 :BB017238:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19272 (legacy spawn) 2025-08-04 01:00:23.800101 :BB017239:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:23.800272 :BB017242: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-04 01:00:23.801137 :BB017243:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 01:00:34.468774 :BB01764B:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 01:00:34.456 2025-08-04 01:00:34.468777 :BB01764C:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=12636 pso_num=29 pso_serial#=161 2025-08-04 01:00:34.468915 :BB01764D:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=12636 osp_idx=27 osp_ver=15460 osp_pg=0 (spawn #452911) 2025-08-04 01:00:34.468916 :BB01764E: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-04 01:00:34.468916 :BB01764F:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=152 time=2949903767 2025-08-04 01:00:34.468917 :BB017650:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-04 01:00:34.468917 :BB017651:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-04 01:00:34.468917 :BB017652:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-04 01:00:34.468918 :BB017653:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-04 01:00:34.468918 :BB017654:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-04 01:00:34.469426 :BB017655: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-04 01:00:34.469470 :BB01765B: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-04 01:00:34.476814 :BB017669:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.477901 :BB017671:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.478476 :BB017679:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.478939 :BB017681:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.479371 :BB017689:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.481849 :BB017691:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.482941 :BB017699:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.533937 :BB0176A1:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.534905 :BB0176A9:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.535149 :BB0176B1:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.535411 :BB0176B9:db_trace:ksl2.c@14083:ksl_update_post_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-04 01:00:34.537125 :BB0176C1:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 16:00:21.431627 :BB48F692:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 16:00:21.424 2025-08-04 16:00:21.431629 :BB48F693:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=16472 pso_num=29 pso_serial#=162 2025-08-04 16:00:21.431771 :BB48F694:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=16472 osp_idx=27 osp_ver=15461 osp_pg=0 (spawn #454995) 2025-08-04 16:00:21.431771 :BB48F695: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-04 16:00:21.431772 :BB48F696:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=153 time=3003890736 2025-08-04 16:00:21.431772 :BB48F697:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-04 16:00:21.431773 :BB48F698:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-04 16:00:21.431773 :BB48F699:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-04 16:00:21.431773 :BB48F69A:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-04 16:00:21.431774 :BB48F69B:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-04 16:00:21.432328 :BB48F69C: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-04 16:00:21.432372 :BB48F6A2: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-04 16:00:21.439630 :BB48F6B0:db_trace:ksl2.c@14083:ksl_update_post_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-04 16:00:21.440788 :BB48F6B8:db_trace:ksl2.c@14083:ksl_update_post_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-04 16:00:21.495779 :BB48F6C0:db_trace:ksl2.c@14083:ksl_update_post_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-04 16:00:21.496672 :BB48F6C8:db_trace:ksl2.c@14083:ksl_update_post_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-04 16:00:21.496921 :BB48F6D0:db_trace:ksl2.c@14083:ksl_update_post_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-04 16:00:21.497139 :BB48F6D8:db_trace:ksl2.c@14083:ksl_update_post_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-04 16:00:21.498825 :BB48F6E0:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-04 22:00:01.445787 :BB65650B:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-04 22:00:01.433 2025-08-04 22:00:01.445788 :BB65650C:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20460 pso_num=29 pso_serial#=163 2025-08-04 22:00:01.445924 :BB656512:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=20460 osp_idx=27 osp_ver=15462 osp_pg=0 (spawn #455827) 2025-08-04 22:00:01.445925 :BB656513: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-04 22:00:01.445925 :BB656514:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=154 time=3025470751 2025-08-04 22:00:01.445926 :BB656515:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-04 22:00:01.445926 :BB656516:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-04 22:00:01.445927 :BB656517:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-04 22:00:01.445927 :BB656518:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-04 22:00:01.445927 :BB656519:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-04 22:00:01.446476 :BB65651A: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-04 22:00:01.451170 :BB656537:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.451206 :BB65653A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-08-04 22:00:01.469161 :BB6566FC:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.469468 :BB656704:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.469774 :BB65670C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.469935 :BB656714:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.470104 :BB65671C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.470266 :BB656724:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.470433 :BB65672C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.470585 :BB656734:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.470735 :BB65673C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.470911 :BB656744:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.471071 :BB65674C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.471222 :BB656754:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.471369 :BB65675C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.471523 :BB656764:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.471693 :BB65676C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.471848 :BB656774:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.471998 :BB65677C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.472353 :BB656784:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.472535 :BB65678C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.472691 :BB656794:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.472851 :BB65679C:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.473280 :BB6567A4:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.473454 :BB6567AC:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.473608 :BB6567B4:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.473859 :BB6567BC:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.474106 :BB6567C4:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.474353 :BB6567CC:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.474880 :BB6567D4:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:01.477778 :BB6567E0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-08-04 22:00:01.501292 :BB6567F0:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:03.146809*:BB656AFA:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002DBBAAF8 estart=1754316001 eid=16777501 ctx=0x000000077B54EAC8 cwh=0x000000002B460608 cpu=1453125 buffg=78979 interb=196608 r=24 rb=196608 w=0 wb=0 2025-08-04 22:00:03.146809*:BB656AFB:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002DBBAAF8 curCtx=0x0000000054281240 pubTabIdxCnt=0 2025-08-04 22:00:03.146809*:BB656AFC:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002DBBAAF8 2025-08-04 22:00:03.146809*:BB656AFD:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002DBBAAF8 2025-08-04 22:00:03.162448*:BB656AFE:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002DBBAAF8 curCtx=0x0000000054281240 xsc->flg4=65792 flags=2 2025-08-04 22:00:03.162448*:BB656AFF:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002DBBAAF8 2025-08-04 22:00:03.162904 :BB656B00:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:03.183041 :BB656B08:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:03.184883 :BB656B10:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-08-04 22:00:03.185071 :BB656B11:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-08-04 22:00:03.185931 :BB656B12:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:03.186014 :BB656B15:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:03.186902 :BB656B27:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:03.188383 :BB656B2F:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:03.188653 :BB656B37:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:03.240570*: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-04 22:00:03.256187*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-08-04 22:00:03.256187*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-08-04 22:00:03.256187*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-08-04 22:00:03.256187*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-08-04 22:00:03.256187*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-04 22:00:03.256187*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-08-04 22:00:03.332208 :BB656C10:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:05.226025 :BB656E73:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:05.226039 :BB656E74:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0004.009.0000c6fd 2025-08-04 22:00:07.767255 :BB65700B:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:07.768602 :BB657013:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:07.779473 :BB65701B:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:07.807056 :BB657023:db_trace:ksl2.c@14083:ksl_update_post_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-04 22:00:09.006902 :BB65712B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:jslv.c:9203 2025-08-04 22:00:09.020041 :BB65712C: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-04 22:00:09.020721 :BB657134: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: 20460, J003)