Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250812220009\orcl_j003_316_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:35538M/63366M, Ph+PgF:40944M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 316, image: ORACLE.EXE (J003) *** 2025-08-12 22:00:09.805 *** 2025-08-12 22:00:09.805 Process diagnostic dump for ORACLE.EXE (J003), OS id=316, pid: 29, proc_ser: 235, 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-12 22:00:09.805 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 316, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-11 23:59:46.863996 :BE80EA24:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=20764 (legacy spawn) 2025-08-11 23:59:46.878070 :BE80EA25:db_trace:ksl2.c@14083:ksl_update_post_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-11 23:59:50.115445 :BE80EB41:db_trace:ksl2.c@14083:ksl_update_post_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-11 23:59:50.115472 :BE80EB44:db_trace:ksl2.c@14083:ksl_update_post_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-11 23:59:50.115622 :BE80EB47: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-11 23:59:50.116906 :BE80EB58:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-11 23:59:50.380251 :BE80EB85:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-11 23:59:50.380 2025-08-11 23:59:50.380253 :BE80EB86:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20876 pso_num=29 pso_serial#=223 2025-08-11 23:59:50.380395 :BE80EB87:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=20876 (legacy spawn) 2025-08-11 23:59:50.395282 :BE80EB88:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:23.553507 :BE80F682:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 00:00:50.312256 :BE81022C:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 00:00:50.303 2025-08-12 00:00:50.312258 :BE81022D:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21064 pso_num=29 pso_serial#=224 2025-08-12 00:00:50.312394 :BE81022E:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=21064 osp_idx=27 osp_ver=15778 osp_pg=0 (spawn #479442) 2025-08-12 00:00:50.312394 :BE81022F: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-12 00:00:50.312395 :BE810230:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=222 time=3637519611 2025-08-12 00:00:50.312395 :BE810231:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-12 00:00:50.312396 :BE810232:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-12 00:00:50.312396 :BE810233:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-12 00:00:50.312396 :BE810234:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-12 00:00:50.312397 :BE810235:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-12 00:00:50.312889 :BE810236: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-12 00:00:50.312932 :BE81023C: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-12 00:00:50.320423 :BE81024A:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.321497 :BE810252:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.322114 :BE81025A:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.322602 :BE810262:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.323048 :BE81026A:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.325493 :BE810272:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.326632 :BE81027A:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.377826 :BE810282:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.378703 :BE81028A:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.378928 :BE810292:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.379140 :BE81029A:db_trace:ksl2.c@14083:ksl_update_post_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-12 00:00:50.381103 :BE8102A2:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:12.132406 :BE8590F2:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:12.123 2025-08-12 01:00:12.132409 :BE8590F3:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20220 pso_num=29 pso_serial#=225 2025-08-12 01:00:12.132545 :BE8590F4:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=20220 (legacy spawn) 2025-08-12 01:00:12.139031 :BE8590F5:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:12.139200 :BE8590FD: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-12 01:00:12.140155 :BE85910C:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:13.975412 :BE8591B0:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:13.962 2025-08-12 01:00:13.975414 :BE8591B1:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=9904 pso_num=29 pso_serial#=226 2025-08-12 01:00:13.975561 :BE8591B2:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=9904 (legacy spawn) 2025-08-12 01:00:13.981974 :BE8591B3:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:13.982168 :BE8591B8: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-12 01:00:13.982949 :BE8591BD:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:14.002375 :BE8591C0:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:13.993 2025-08-12 01:00:14.002377 :BE8591C1:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21272 pso_num=29 pso_serial#=227 2025-08-12 01:00:14.002511 :BE8591C2:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21272 (legacy spawn) 2025-08-12 01:00:14.008977 :BE8591C3:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:14.009151 :BE8591CB: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-12 01:00:14.009992 :BE8591CD:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:19.777712 :BE85939B:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:19.763 2025-08-12 01:00:19.777713 :BE85939C:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=13152 pso_num=29 pso_serial#=228 2025-08-12 01:00:19.777850 :BE85939D:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=13152 (legacy spawn) 2025-08-12 01:00:19.784394 :BE85939E:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:19.784578 :BE8593A3: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-12 01:00:19.785399 :BE8593A7:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:19.794155 :BE8593AA:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:19.794 2025-08-12 01:00:19.794158 :BE8593AB:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21380 pso_num=29 pso_serial#=229 2025-08-12 01:00:19.794315 :BE8593AC:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21380 (legacy spawn) 2025-08-12 01:00:19.800702 :BE8593AD:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:19.800872 :BE8593B6: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-12 01:00:19.801707 :BE8593B7:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:22.866354 :BE8594BB:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:22.852 2025-08-12 01:00:22.866355 :BE8594BC:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21228 pso_num=29 pso_serial#=230 2025-08-12 01:00:22.866492 :BE8594BD:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=21228 (legacy spawn) 2025-08-12 01:00:22.872963 :BE8594BE:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:22.873142 :BE8594C4: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-12 01:00:22.873921 :BE8594C8:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:22.882787 :BE8594CB:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:22.868 2025-08-12 01:00:22.882789 :BE8594CC:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=10356 pso_num=29 pso_serial#=231 2025-08-12 01:00:22.882926 :BE8594CD:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=10356 (legacy spawn) 2025-08-12 01:00:22.889322 :BE8594CE:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:22.889352 :BE8594D1:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:22.889515 :BE8594D8: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-12 01:00:22.890303 :BE8594E5:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:23.018339 :BE8594E8:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:23.008 2025-08-12 01:00:23.018342 :BE8594E9:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=20772 pso_num=29 pso_serial#=232 2025-08-12 01:00:23.018477 :BE8594EA:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=20772 (legacy spawn) 2025-08-12 01:00:23.042080 :BE8594EB:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:23.042254 :BE8594F0: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-12 01:00:23.043150 :BE8594F5:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:57.131073 :BE85A1BA:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:57.119 2025-08-12 01:00:57.131075 :BE85A1BB:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19380 pso_num=29 pso_serial#=233 2025-08-12 01:00:57.131209 :BE85A1BC:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19380 (legacy spawn) 2025-08-12 01:00:57.137793 :BE85A1BD:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:57.138083 :BE85A1C6: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-12 01:00:57.138888 :BE85A1C7:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 01:00:58.132144 :BE85A28F:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 01:00:58.119 2025-08-12 01:00:58.132146 :BE85A290:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=21348 pso_num=29 pso_serial#=234 2025-08-12 01:00:58.132288 :BE85A291:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=21348 osp_idx=27 osp_ver=15788 osp_pg=0 (spawn #479581) 2025-08-12 01:00:58.132288 :BE85A292: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-12 01:00:58.132288 :BE85A293:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=223 time=3641127423 2025-08-12 01:00:58.132289 :BE85A294:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-12 01:00:58.132289 :BE85A295:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-12 01:00:58.132289 :BE85A296:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-12 01:00:58.132291 :BE85A297:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-12 01:00:58.132291 :BE85A298:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-12 01:00:58.132806 :BE85A299: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-12 01:00:58.132852 :BE85A29F: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-12 01:00:58.140722 :BE85A2AD:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.141866 :BE85A2B5:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.142543 :BE85A2BD:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.143039 :BE85A2C5:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.143487 :BE85A2CD:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.145997 :BE85A2D5:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.147183 :BE85A2DD:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.199205 :BE85A2E5:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.200155 :BE85A2ED:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.200416 :BE85A2F5:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.200630 :BE85A2FD:db_trace:ksl2.c@14083:ksl_update_post_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-12 01:00:58.202685 :BE85A305:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-08-12 22:00:02.057579 :BEE79637:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 08-12 22:00:02.051 2025-08-12 22:00:02.057580 :BEE79638:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=316 pso_num=29 pso_serial#=235 2025-08-12 22:00:02.057711 :BEE7963B:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=316 osp_idx=27 osp_ver=15789 osp_pg=0 (spawn #482486) 2025-08-12 22:00:02.057711 :BEE7963C: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-12 22:00:02.057712 :BEE7963D:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=224 time=3716671361 2025-08-12 22:00:02.057712 :BEE7963E:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-08-12 22:00:02.057713 :BEE7963F:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-08-12 22:00:02.057713 :BEE79640:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-08-12 22:00:02.057714 :BEE79641:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-12 22:00:02.057714 :BEE79642:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-12 22:00:02.058207 :BEE79648: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-12 22:00:02.063132 :BEE79667:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.063166 :BEE7966A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-08-12 22:00:02.081170 :BEE7987C:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.081373 :BEE79884:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.081544 :BEE7988C:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.081706 :BEE79894:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.081879 :BEE7989C:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.082097 :BEE798A4:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.082340 :BEE798AC:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.082524 :BEE798AF:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.082675 :BEE798C1:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.082849 :BEE798C9:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.083001 :BEE798D1:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.083157 :BEE798D9:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.083306 :BEE798E1:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.083456 :BEE798E9:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.083704 :BEE798F1:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.083893 :BEE798F9:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.084345 :BEE79901:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:02.111835 :BEE79909:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:03.149333*:BEE79B07:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000325D3AD0 estart=1755007203 eid=21332244 ctx=0x0000000777968158 cwh=0x00000000561E0158 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-08-12 22:00:03.149333*:BEE79B08:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000325D3AD0 curCtx=0x00000000560E1BF8 pubTabIdxCnt=0 2025-08-12 22:00:03.149333*:BEE79B09:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000325D3AD0 2025-08-12 22:00:03.149333*:BEE79B0A:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000325D3AD0 2025-08-12 22:00:03.149333*:BEE79B0B:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003264B6F0 estart=1755007202 eid=16777517 ctx=0x000000077B54EAC8 cwh=0x0000000032640068 cpu=843750 buffg=48130 interb=196608 r=24 rb=196608 w=0 wb=0 2025-08-12 22:00:03.149333*:BEE79B0C:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003264B6F0 curCtx=0x00000000560D7FD8 pubTabIdxCnt=0 2025-08-12 22:00:03.149333*:BEE79B0D:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003264B6F0 2025-08-12 22:00:03.149333*:BEE79B0E:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003264B6F0 2025-08-12 22:00:03.149333*:BEE79B0F:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000325D3AD0 curCtx=0x00000000560E1BF8 xsc->flg4=65792 flags=1 2025-08-12 22:00:03.149333*:BEE79B10:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000325D3AD0 2025-08-12 22:00:03.771537 :BEE79C0E: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-12 22:00:03.775361 :BEE79C31:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 7, ext 1, nex 4 2025-08-12 22:00:03.775367 :BEE79C32:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x008191c2 where: kdiwh22: kdifind 2025-08-12 22:00:03.775367*:BEE79C3E:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003264B6F0 curCtx=0x00000000560D7FD8 xsc->flg4=65792 flags=2 2025-08-12 22:00:03.775367*:BEE79C3F:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003264B6F0 2025-08-12 22:00:03.779472 :BEE79C40:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:03.799639 :BEE79C4E:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:03.801513 :BEE79C56:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-08-12 22:00:03.801703 :BEE79C57:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-08-12 22:00:03.802668 :BEE79C58:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:03.802770 :BEE79C5B:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:03.803686 :BEE79C6D:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:03.805160 :BEE79C75:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:03.805437 :BEE79C7D:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:03.868111*: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-12 22:00:03.868111*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-08-12 22:00:03.868111*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-08-12 22:00:03.868111*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-08-12 22:00:03.868111*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-08-12 22:00:03.868111*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-12 22:00:03.868111*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-08-12 22:00:03.936723 :BEE79D07:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:05.819216 :BEE79E9A:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:05.819231 :BEE79E9B:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0008.00c.0000d183 2025-08-12 22:00:08.285709 :BEE7A023:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:08.287092 :BEE7A02B:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:08.297733 :BEE7A033:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:08.325636 :BEE7A03B:db_trace:ksl2.c@14083:ksl_update_post_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-12 22:00:09.529211 :BEE7A120:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:jslv.c:9203 2025-08-12 22:00:09.539772 :BEE7A121: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-12 22:00:09.540281 :BEE7A129: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: 316, J003)