Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250620220008\orcl_j005_16968_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:36447M/63366M, Ph+PgF:42859M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 31 Windows thread id: 16968, image: ORACLE.EXE (J005) *** 2025-06-20 22:00:08.781 *** SESSION ID:(249.1097) 2025-06-20 22:00:08.781 *** 2025-06-20 22:00:08.781 Process diagnostic dump for ORACLE.EXE (J005), OS id=16968, pid: 31, proc_ser: 23, sid: 249, sess_ser: 1097 ------------------------------------------------------------------------------- current sql: client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 16968 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J005) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=16 seq_num=17 snap_id=1 wait times: snap=0.234003 sec, exc=0.234003 sec, total=0.234003 sec wait times: max=0.500000 sec, heur=8.233514 sec wait counts: calls=1 os=1 in_wait=1 iflags=0x5a8 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000007 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=15 seq_num=16 snap_id=1 wait times: snap=0.499999 sec, exc=0.499999 sec, total=0.499999 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=14 seq_num=15 snap_id=1 wait times: snap=0.505096 sec, exc=0.505096 sec, total=0.505096 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=13 seq_num=14 snap_id=1 wait times: snap=0.499999 sec, exc=0.499999 sec, total=0.499999 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=12 seq_num=13 snap_id=1 wait times: snap=0.499998 sec, exc=0.499998 sec, total=0.499998 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=11 seq_num=12 snap_id=1 wait times: snap=0.499994 sec, exc=0.499994 sec, total=0.499994 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=10 seq_num=11 snap_id=1 wait times: snap=0.499996 sec, exc=0.499996 sec, total=0.499996 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000013 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=9 seq_num=10 snap_id=1 wait times: snap=0.500000 sec, exc=0.500000 sec, total=0.500000 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 snap_id=1 wait times: snap=0.502072 sec, exc=0.502072 sec, total=0.502072 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.500003 sec, exc=0.500003 sec, total=0.500003 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 snap_id=1 wait times: snap=0.500001 sec, exc=0.500001 sec, total=0.500001 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time Sampled Session History of session 249 serial 1097 --------------------------------------------------- The sampled session history is constructed by sampling the target session every 1 second. The sampling process captures at each sample if the session is in a non-idle wait, an idle wait, or not in a wait. If the session is in a non-idle wait then one interval is shown for all the samples the session was in the same non-idle wait. If the session is in an idle wait or not in a wait for consecutive samples then one interval is shown for all the consecutive samples. Though we display these consecutive samples in a single interval the session may NOT be continuously idle or not in a wait (the sampling process does not know). The history is displayed in reverse chronological order. sample interval: 1 sec, max history 120 sec --------------------------------------------------- [9 samples, 22:00:00 - 22:00:08] idle wait at each sample [session created at: 22:00:00] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.016000 sec (max dump time=30.000000 sec) *** 2025-06-20 22:00:08.797 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 31 (osid: 16968, J005) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-17 22:00:02.060601 :A6128980:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-06-17 22:00:02.060601 :A6128981:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-17 22:00:02.060602 :A6128982:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-17 22:00:02.061157 :A6128987:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-17 22:00:32.128268 :A6129D96:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-17 23:59:18.158856 :A61BC4F9:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-17 23:59:18.147 2025-06-17 23:59:18.158858 :A61BC4FA:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=11196 pso_num=31 pso_serial#=10 2025-06-17 23:59:18.159049 :A61BC4FB:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=11196 (legacy spawn) 2025-06-17 23:59:18.172933 :A61BC4FC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-17 23:59:51.331140 :A61BD156:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-17 23:59:54.995460 :A61BD28C:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-17 23:59:54.995 2025-06-17 23:59:54.995462 :A61BD28D:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14676 pso_num=31 pso_serial#=11 2025-06-17 23:59:54.995610 :A61BD28E:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=14676 (legacy spawn) 2025-06-17 23:59:55.009827 :A61BD28F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-18 00:00:28.140324 :A61BDF1B:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-18 22:00:02.077079 :A68161D5:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-18 22:00:02.074 2025-06-18 22:00:02.077080 :A68161D6:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14940 pso_num=31 pso_serial#=12 2025-06-18 22:00:02.077222 :A68161D7:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=14940 osp_idx=29 osp_ver=521 osp_pg=0 (spawn #299156) 2025-06-18 22:00:02.077223 :A68161D8:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-18 22:00:02.077223 :A68161D9:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=164 time=3259745250 2025-06-18 22:00:02.077224 :A68161DA:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-06-18 22:00:02.077224 :A68161DB:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-06-18 22:00:02.077224 :A68161DC:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-06-18 22:00:02.077224 :A68161DD:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-18 22:00:02.077225 :A68161DE:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-18 22:00:02.077777 :A68161F0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-18 22:00:32.141750 :A6817662:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-18 23:59:08.002766 :A68AA01D:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-18 23:59:07.999 2025-06-18 23:59:08.002768 :A68AA01E:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=12796 pso_num=31 pso_serial#=13 2025-06-18 23:59:08.002915 :A68AA01F:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=12796 (legacy spawn) 2025-06-18 23:59:08.009426 :A68AA020:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-18 23:59:08.009600 :A68AA025:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-06-18 23:59:08.010400 :A68AA02A:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-18 23:59:08.019274 :A68AA050:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-18 23:59:08.015 2025-06-18 23:59:08.019276 :A68AA051:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14508 pso_num=31 pso_serial#=14 2025-06-18 23:59:08.019418 :A68AA052:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=14508 (legacy spawn) 2025-06-18 23:59:08.025954 :A68AA053:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-18 23:59:08.026126 :A68AA05B:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-06-18 23:59:08.026956 :A68AA05D:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-18 23:59:08.148471 :A68AA060:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-18 23:59:08.140 2025-06-18 23:59:08.148474 :A68AA061:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=16080 pso_num=31 pso_serial#=15 2025-06-18 23:59:08.148609 :A68AA062:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=16080 (legacy spawn) 2025-06-18 23:59:08.155160 :A68AA063:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-18 23:59:08.155335 :A68AA06C:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-06-18 23:59:08.156178 :A68AA06D:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-18 23:59:17.981963 :A68AA404:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-18 23:59:17.980 2025-06-18 23:59:17.981965 :A68AA405:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14424 pso_num=31 pso_serial#=16 2025-06-18 23:59:17.982108 :A68AA406:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=14424 (legacy spawn) 2025-06-18 23:59:17.996138 :A68AA407:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-18 23:59:51.338965 :A68AB053:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-18 23:59:54.895698 :A68AB19A:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-18 23:59:54.881 2025-06-18 23:59:54.895700 :A68AB19B:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17728 pso_num=31 pso_serial#=17 2025-06-18 23:59:54.895841 :A68AB19C:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17728 (legacy spawn) 2025-06-18 23:59:54.909996 :A68AB19D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 00:00:28.110033 :A68ABDC2:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-19 16:00:18.122361 :A6D63EC2:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-19 16:00:18.112 2025-06-19 16:00:18.122362 :A6D63EC3:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17424 pso_num=31 pso_serial#=18 2025-06-19 16:00:18.122480 :A6D63EC4:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=17424 osp_idx=29 osp_ver=527 osp_pg=0 (spawn #301657) 2025-06-19 16:00:18.122481 :A6D63EC5:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-19 16:00:18.122482 :A6D63EC6:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=165 time=3324561313 2025-06-19 16:00:18.122482 :A6D63EC7:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-06-19 16:00:18.122483 :A6D63EC8:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-06-19 16:00:18.122483 :A6D63EC9:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-06-19 16:00:18.122484 :A6D63ECA:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-19 16:00:18.122484 :A6D63ECB:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-19 16:00:18.122991 :A6D63ECC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-19 16:00:18.123036 :A6D63ED2:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-06-19 16:00:18.132263 :A6D63EE4:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-19 22:00:02.059161 :A6F2817B:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-19 22:00:02.057 2025-06-19 22:00:02.059162 :A6F2817C:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=16160 pso_num=31 pso_serial#=19 2025-06-19 22:00:02.059314 :A6F2821C:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=16160 osp_idx=29 osp_ver=528 osp_pg=0 (spawn #302489) 2025-06-19 22:00:02.059315 :A6F2821D:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-19 22:00:02.059316 :A6F2821E:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=166 time=3346145235 2025-06-19 22:00:02.059317 :A6F2821F:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-06-19 22:00:02.059317 :A6F28220:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-06-19 22:00:02.059318 :A6F28222:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-06-19 22:00:02.059318 :A6F28224:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-19 22:00:02.059319 :A6F28226:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-19 22:00:02.059911 :A6F28276:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.064870 :A6F282B5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.064902 :A6F282B8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:jslv.c:9203 2025-06-19 22:00:02.068511 :A6F282E2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.449174 :A6F285D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.492873 :A6F285DA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.508473 :A6F285E2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.565541 :A6F285F2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.697986 :A6F28602:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.812611 :A6F2860A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.822132 :A6F28612:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.837413 :A6F2861A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.852444 :A6F28622:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.868001 :A6F2862A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.877389 :A6F28632:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.887112 :A6F2863A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.902387 :A6F28642:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.917702 :A6F2864A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.927649 :A6F28652:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.937634 :A6F2865A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.952836 :A6F28662:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.962349 :A6F2866A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.977851 :A6F28672:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:02.993267 :A6F2867A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.008314 :A6F28682:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.023730 :A6F2868A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.033230 :A6F28692:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.049057 :A6F286A2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.058517 :A6F286AA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.068587 :A6F286B2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.090833 :A6F286BE:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] KSL POST RCVD poster=27 loc='ksq.h LINE:1877 ID:ksqrcl' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-19 22:00:03.103489 :A6F2870A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.119007 :A6F2874A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.129071 :A6F28752:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.136929 :A6F2876F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.146919 :A6F28777:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.163123 :A6F28798:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.179316 :A6F287B0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.192634 :A6F287DC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.202856 :A6F287E4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.218822 :A6F287EC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.234124 :A6F287F4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.249095 :A6F287FC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.258606 :A6F28804:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.268697 :A6F2880C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.278061 :A6F28814:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.287555 :A6F2881C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.302761 :A6F28824:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.312589 :A6F2882C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.320020 :A6F28834:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.327516 :A6F2883C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.334966 :A6F28844:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.342475 :A6F2884C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.349935 :A6F28854:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.357678 :A6F2885C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.365652 :A6F28864:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.373280 :A6F2886C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.380793 :A6F28882:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.388317 :A6F2888A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:03.713025*:A6F288BB:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000046676918 estart=1750341602 eid=16777391 ctx=0x00000007831EA738 cwh=0x00000000466A0248 cpu=328125 buffg=54922 interb=1556480 r=15 rb=892928 w=3 wb=663552 2025-06-19 22:00:03.713025*:A6F288BC:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000046676918 curCtx=0x00000000476EEBE0 pubTabIdxCnt=0 2025-06-19 22:00:03.713025*:A6F288BD:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000046676918 2025-06-19 22:00:03.713025*:A6F288BE:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000046676918 2025-06-19 22:00:03.713025*:A6F288BF:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000320AC288 estart=1750341601 eid=16777303 ctx=0x000000079F654AA8 cwh=0x00000000320A0158 cpu=1625000 buffg=141681 interb=29868032 r=1467 rb=26918912 w=15 wb=2949120 2025-06-19 22:00:03.713025*:A6F288C0:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000320AC288 curCtx=0x000000004779FFD0 pubTabIdxCnt=0 2025-06-19 22:00:03.713025*:A6F288C2:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000320AC288 2025-06-19 22:00:03.713025*:A6F288C3:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000320AC288 2025-06-19 22:00:03.931774*:A6F289AF:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000046676918 curCtx=0x00000000476EEBE0 xsc->flg4=65792 flags=1 2025-06-19 22:00:03.931774*:A6F289B0:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000046676918 2025-06-19 22:00:04.488414 :A6F28AC3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.498746 :A6F28ACB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.498991 :A6F28AD3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.506763 :A6F28ADB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.514212 :A6F28AE3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.521801 :A6F28AEB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.530164 :A6F28AF3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.530464 :A6F28AFB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.530464*:A6F28B03:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000320AC288 curCtx=0x000000004779FFD0 xsc->flg4=65792 flags=2 2025-06-19 22:00:04.530464*:A6F28B04:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000320AC288 2025-06-19 22:00:04.530719 :A6F28B05:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpop:jslv.c:9203 2025-06-19 22:00:04.535123 :A6F28B06:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.535200 :A6F28B09:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-06-19 22:00:04.535289 :A6F28B16:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-06-19 22:00:34.612782 :A6F29788:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-19 23:59:09.707051 :A6FBF14D:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-19 23:59:09.705 2025-06-19 23:59:09.707054 :A6FBF14E:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=16968 pso_num=31 pso_serial#=20 2025-06-19 23:59:09.707196 :A6FBF14F:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=16968 (legacy spawn) 2025-06-19 23:59:09.721344 :A6FBF150:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 23:59:42.927739 :A6FBFD21:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-19 23:59:46.349188 :A6FBFECA:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-19 23:59:46.340 2025-06-19 23:59:46.349190 :A6FBFECB:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=16720 pso_num=31 pso_serial#=21 2025-06-19 23:59:46.349336 :A6FBFECC:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=16720 (legacy spawn) 2025-06-19 23:59:46.355865 :A6FBFECD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-19 23:59:46.356063 :A6FBFED6:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-06-19 23:59:46.356923 :A6FBFED7:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-19 23:59:46.550285 :A6FBFF0D:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-19 23:59:46.543 2025-06-19 23:59:46.550288 :A6FBFF0E:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=15648 pso_num=31 pso_serial#=22 2025-06-19 23:59:46.550426 :A6FBFF0F:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=15648 (legacy spawn) 2025-06-19 23:59:46.564277 :A6FBFF10:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-20 00:00:19.752975 :A6FC0C50:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-06-20 22:00:00.561946 :A764B9A6:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 06-20 22:00:00.554 2025-06-20 22:00:00.561948 :A764B9A7:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=16968 pso_num=31 pso_serial#=23 2025-06-20 22:00:00.562087 :A764B9AB:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=16968 osp_idx=29 osp_ver=532 osp_pg=0 (spawn #305814) 2025-06-20 22:00:00.562088 :A764B9AC:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-20 22:00:00.562088 :A764B9AD:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=167 time=3432543750 2025-06-20 22:00:00.562089 :A764B9AE:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-06-20 22:00:00.562089 :A764B9AF:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-06-20 22:00:00.562090 :A764B9B0:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-06-20 22:00:00.562090 :A764B9B1:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-20 22:00:00.562091 :A764B9B2:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-20 22:00:00.562695 :A764B9B8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 31 (osid: 16968, J005)