Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250904221956\orcl_j001_24524_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250904221956\orcl_j001_24524_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:35061M/63366M, Ph+PgF:39923M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 24524, image: ORACLE.EXE (J001) *** 2025-09-04 22:19:56.149 *** SESSION ID:(193.51709) 2025-09-04 22:19:56.149 *** 2025-09-04 22:19:56.149 Process diagnostic dump for ORACLE.EXE (J001), OS id=24524, pid: 24, proc_ser: 172, sid: 193, sess_ser: 51709 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 24524 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=48 seq_num=49 snap_id=1 wait times: snap=0.234740 sec, exc=0.234740 sec, total=0.234740 sec wait times: max=0.500000 sec, heur=24.343763 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.000016 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=47 seq_num=48 snap_id=1 wait times: snap=0.499941 sec, exc=0.499941 sec, total=0.499941 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000077 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=46 seq_num=47 snap_id=1 wait times: snap=0.499991 sec, exc=0.499991 sec, total=0.499991 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000014 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=45 seq_num=46 snap_id=1 wait times: snap=0.499986 sec, exc=0.499986 sec, total=0.499986 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000017 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=44 seq_num=45 snap_id=1 wait times: snap=0.499987 sec, exc=0.499987 sec, total=0.499987 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000020 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=43 seq_num=44 snap_id=1 wait times: snap=0.510106 sec, exc=0.510106 sec, total=0.510106 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000016 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=42 seq_num=43 snap_id=1 wait times: snap=0.499988 sec, exc=0.499988 sec, total=0.499988 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=41 seq_num=42 snap_id=1 wait times: snap=0.499950 sec, exc=0.499950 sec, total=0.499950 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000060 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=40 seq_num=41 snap_id=1 wait times: snap=0.510068 sec, exc=0.510068 sec, total=0.510068 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000027 sec of elapsed time 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=39 seq_num=40 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.000019 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=38 seq_num=39 snap_id=1 wait times: snap=0.499995 sec, exc=0.499995 sec, total=0.499995 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000013 sec of elapsed time Sampled Session History of session 193 serial 51709 --------------------------------------------------- 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 --------------------------------------------------- [25 samples, 22:19:31 - 22:19:56] idle wait at each sample [session created at: 22:19:31] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-09-04 22:19:56.149 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 24524, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-09-04 22:06:30.615230 :C90CFA08:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=16 time=1409241908 2025-09-04 22:06:30.615231 :C90CFA09:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:06:30.615231 :C90CFA0A:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:06:30.615232 :C90CFA0B:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:06:30.615232 :C90CFA0C:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:06:30.615232 :C90CFA0D:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:06:30.615709 :C90CFA0E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:07:00.680014 :C90D0519:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:07:30.693425 :C90D0F2F:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:07:30.682 2025-09-04 22:07:30.693426 :C90D0F30:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=23252 pso_num=24 pso_serial#=160 2025-09-04 22:07:30.693548 :C90D0F31:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=23252 osp_idx=22 osp_ver=843544 osp_pg=0 (spawn #559171) 2025-09-04 22:07:30.693549 :C90D0F32:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:07:30.693549 :C90D0F33:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=17 time=1409301987 2025-09-04 22:07:30.693549 :C90D0F34:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:07:30.693549 :C90D0F35:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:07:30.693550 :C90D0F36:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:07:30.693550 :C90D0F37:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:07:30.693550 :C90D0F38:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:07:30.694040 :C90D0F39:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:08:00.808023 :C90D1972:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:08:30.797543 :C90D236F:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:08:30.786 2025-09-04 22:08:30.797546 :C90D2370:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=23752 pso_num=24 pso_serial#=161 2025-09-04 22:08:30.797683 :C90D2371:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=23752 osp_idx=22 osp_ver=843545 osp_pg=0 (spawn #559173) 2025-09-04 22:08:30.797683 :C90D2372:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:08:30.797684 :C90D2373:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=18 time=1409362096 2025-09-04 22:08:30.797684 :C90D2374:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:08:30.797684 :C90D2375:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:08:30.797685 :C90D2376:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:08:30.797685 :C90D2377:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:08:30.797685 :C90D2378:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:08:30.798169 :C90D2379:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:09:00.870581 :C90D2DD0:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:09:30.865677 :C90D37C0:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:09:30.854 2025-09-04 22:09:30.865679 :C90D37C1:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=24420 pso_num=24 pso_serial#=162 2025-09-04 22:09:30.865801 :C90D37C2:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=24420 osp_idx=22 osp_ver=843546 osp_pg=0 (spawn #559176) 2025-09-04 22:09:30.865802 :C90D37C3:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:09:30.865803 :C90D37C4:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=19 time=1409422158 2025-09-04 22:09:30.865803 :C90D37C5:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:09:30.865803 :C90D37C6:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:09:30.865804 :C90D37C7:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:09:30.865804 :C90D37C8:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:09:30.865804 :C90D37C9:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:09:30.866291 :C90D37CA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:10:00.987803 :C90D420F:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:10:30.983876 :C90D4FF1:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:10:30.972 2025-09-04 22:10:30.983879 :C90D4FF2:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=22272 pso_num=24 pso_serial#=163 2025-09-04 22:10:30.984015 :C90D4FF3:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=22272 osp_idx=22 osp_ver=843547 osp_pg=0 (spawn #559178) 2025-09-04 22:10:30.984016 :C90D4FF4:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:10:30.984016 :C90D4FF5:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=20 time=1409482283 2025-09-04 22:10:30.984017 :C90D4FF6:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:10:30.984017 :C90D4FF7:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:10:30.984018 :C90D4FF8:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:10:30.984018 :C90D4FF9:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:10:30.984018 :C90D4FFA:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:10:30.984512 :C90D4FFB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:11:01.028219 :C90D5A37:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:11:31.062461 :C90D6461:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:11:31.048 2025-09-04 22:11:31.062462 :C90D6462:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=22692 pso_num=24 pso_serial#=164 2025-09-04 22:11:31.062587 :C90D6463:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=22692 osp_idx=22 osp_ver=843548 osp_pg=0 (spawn #559180) 2025-09-04 22:11:31.062587 :C90D6464:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:11:31.062588 :C90D6465:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=21 time=1409542362 2025-09-04 22:11:31.062588 :C90D6466:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:11:31.062588 :C90D6467:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:11:31.062589 :C90D6468:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:11:31.062589 :C90D6469:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:11:31.062589 :C90D646A:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:11:31.062983 :C90D646E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:12:01.162308 :C90D6F08:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:12:31.184965 :C90D7932:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:12:31.173 2025-09-04 22:12:31.184967 :C90D7933:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=22456 pso_num=24 pso_serial#=165 2025-09-04 22:12:31.185083 :C90D7934:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=22456 osp_idx=22 osp_ver=843549 osp_pg=0 (spawn #559183) 2025-09-04 22:12:31.185084 :C90D7935:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:12:31.185085 :C90D7936:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=22 time=1409602487 2025-09-04 22:12:31.185085 :C90D7937:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:12:31.185086 :C90D7938:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:12:31.185086 :C90D7939:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:12:31.185086 :C90D793A:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:12:31.185087 :C90D793B:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:12:31.185598 :C90D793C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:13:01.271253 :C90D833C:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:13:31.271293 :C90D8D53:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:13:31.260 2025-09-04 22:13:31.271295 :C90D8D54:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=23460 pso_num=24 pso_serial#=166 2025-09-04 22:13:31.271416 :C90D8D55:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=23460 osp_idx=22 osp_ver=843550 osp_pg=0 (spawn #559185) 2025-09-04 22:13:31.271416 :C90D8D56:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:13:31.271417 :C90D8D57:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=23 time=1409662565 2025-09-04 22:13:31.271418 :C90D8D58:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:13:31.271418 :C90D8D59:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:13:31.271419 :C90D8D5A:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:13:31.271419 :C90D8D5B:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:13:31.271419 :C90D8D5C:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:13:31.271916 :C90D8D5D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:14:01.372937 :C90D97B9:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:14:16.335174 :C90D9CDC:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:14:16.323 2025-09-04 22:14:16.335175 :C90D9CDD:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21700 pso_num=24 pso_serial#=167 2025-09-04 22:14:16.335306 :C90D9CDE:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=21700 osp_idx=22 osp_ver=843551 osp_pg=0 (spawn #559188) 2025-09-04 22:14:16.335307 :C90D9CDF:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:14:16.335307 :C90D9CE0:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=24 time=1409707627 2025-09-04 22:14:16.335308 :C90D9CE1:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:14:16.335308 :C90D9CE2:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:14:16.335308 :C90D9CE3:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:14:16.335309 :C90D9CE4:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:14:16.335309 :C90D9CE5:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:14:16.335811 :C90D9CE6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:14:31.347386 :C90DA203:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-09-04 22:14:31.347422*:C90DA206:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D4BB58 estart=1756995270 eid=17039721 ctx=0x000000077BD98A08 cwh=0x00000000232801B0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-09-04 22:14:31.347422*:C90DA207:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024D4BB58 curCtx=0x000000002328F708 pubTabIdxCnt=0 2025-09-04 22:14:31.347422*:C90DA208:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024D4BB58 2025-09-04 22:14:31.347422*:C90DA209:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024D4BB58 2025-09-04 22:14:31.347422*:C90DA20A:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024D4BB58 curCtx=0x000000002328F708 xsc->flg4=65792 flags=2 2025-09-04 22:14:31.347422*:C90DA20B:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024D4BB58 2025-09-04 22:14:31.347989 :C90DA20C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-04 22:14:31.362580 :C90DA214:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-09-04 22:14:31.362667 :C90DA215:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-09-04 22:14:31.363499 :C90DA216:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-09-04 22:14:31.363841 :C90DA217:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-04 22:14:31.363884 :C90DA21A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-09-04 22:14:31.371850 :C90DA220:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-04 22:14:31.371922 :C90DA223:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-09-04 22:14:31.371960 :C90DA224:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-09-04 22:14:31.372309 :C90DA22A:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-09-04 22:14:31.372659 :C90DA22B:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-09-04 22:14:31.372846 :C90DA22C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-09-04 22:14:31.373074 :C90DA22D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-04 22:14:31.373100 :C90DA230:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-09-04 22:14:31.374737 :C90DA236:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-09-04 22:14:31.374973 :C90DA237:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-04 22:14:31.375006 :C90DA23A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-09-04 22:14:31.375963 :C90DA240:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-04 22:14:31.376071 :C90DA249:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-09-04 22:15:01.451672 :C90DAC0D:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:15:31.449832 :C90DB690:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:15:31.438 2025-09-04 22:15:31.449834 :C90DB691:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=22040 pso_num=24 pso_serial#=168 2025-09-04 22:15:31.449953 :C90DB692:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=22040 osp_idx=22 osp_ver=843552 osp_pg=0 (spawn #559190) 2025-09-04 22:15:31.449954 :C90DB693:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:15:31.449954 :C90DB694:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=25 time=1409782752 2025-09-04 22:15:31.449955 :C90DB695:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:15:31.449955 :C90DB696:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:15:31.449956 :C90DB697:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:15:31.449956 :C90DB698:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:15:31.449956 :C90DB699:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:15:31.450424 :C90DB69A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:16:01.545393 :C90DC0BA:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:16:31.565167 :C90DCAC5:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:16:31.553 2025-09-04 22:16:31.565169 :C90DCAC6:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=23432 pso_num=24 pso_serial#=169 2025-09-04 22:16:31.565283 :C90DCAC7:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=23432 osp_idx=22 osp_ver=843553 osp_pg=0 (spawn #559192) 2025-09-04 22:16:31.565283 :C90DCAC8:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:16:31.565284 :C90DCAC9:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=26 time=1409842862 2025-09-04 22:16:31.565284 :C90DCACA:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:16:31.565284 :C90DCACB:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:16:31.565285 :C90DCACC:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:16:31.565285 :C90DCACD:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:16:31.565285 :C90DCACE:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:16:31.565742 :C90DCACF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:17:01.668158 :C90DD5D1:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:17:31.651451 :C90DDF9C:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:17:31.639 2025-09-04 22:17:31.651454 :C90DDF9D:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=17016 pso_num=24 pso_serial#=170 2025-09-04 22:17:31.651583 :C90DDF9E:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=17016 osp_idx=22 osp_ver=843554 osp_pg=0 (spawn #559194) 2025-09-04 22:17:31.651585 :C90DDF9F:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:17:31.651585 :C90DDFA0:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=27 time=1409902955 2025-09-04 22:17:31.651586 :C90DDFA1:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:17:31.651586 :C90DDFA2:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:17:31.651587 :C90DDFA3:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:17:31.651587 :C90DDFA4:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:17:31.651588 :C90DDFA5:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:17:31.652107 :C90DDFA6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:18:01.744906 :C90DE9E0:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:18:31.735586 :C90DF3E7:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:18:31.724 2025-09-04 22:18:31.735589 :C90DF3E8:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19244 pso_num=24 pso_serial#=171 2025-09-04 22:18:31.735728 :C90DF3E9:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19244 osp_idx=22 osp_ver=843555 osp_pg=0 (spawn #559196) 2025-09-04 22:18:31.735729 :C90DF3EA:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:18:31.735729 :C90DF3EB:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=28 time=1409963033 2025-09-04 22:18:31.735729 :C90DF3EC:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:18:31.735729 :C90DF3ED:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:18:31.735730 :C90DF3EE:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:18:31.735730 :C90DF3EF:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:18:31.735731 :C90DF3F0:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:18:31.736255 :C90DF3F1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-09-04 22:19:01.818158 :C90DFE5E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-09-04 22:19:31.804601 :C90E088F:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 09-04 22:19:31.793 2025-09-04 22:19:31.804603 :C90E0890:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=24524 pso_num=24 pso_serial#=172 2025-09-04 22:19:31.804734 :C90E0891:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=24524 osp_idx=22 osp_ver=843556 osp_pg=0 (spawn #559199) 2025-09-04 22:19:31.804735 :C90E0892:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-04 22:19:31.804735 :C90E0893:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=29 time=1410023096 2025-09-04 22:19:31.804736 :C90E0894:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-09-04 22:19:31.804736 :C90E0895:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-09-04 22:19:31.804737 :C90E0896:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-09-04 22:19:31.804737 :C90E0897:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-04 22:19:31.804738 :C90E0898:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-04 22:19:31.805246 :C90E0899:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] 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 24 (osid: 24524, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de