Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250608180849\orcl_j001_15856_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250608180849\orcl_j001_15856_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:36811M/63366M, Ph+PgF:43449M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 15856, image: ORACLE.EXE (J001) *** 2025-06-08 18:08:49.107 *** SESSION ID:(193.5183) 2025-06-08 18:08:49.107 *** 2025-06-08 18:08:49.107 Process diagnostic dump for ORACLE.EXE (J001), OS id=15856, pid: 24, proc_ser: 164, sid: 193, sess_ser: 5183 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 15856 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=12 seq_num=13 snap_id=1 wait times: snap=0.266345 sec, exc=0.266345 sec, total=0.266345 sec wait times: max=0.500000 sec, heur=6.261601 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.000013 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=11 seq_num=12 snap_id=1 wait times: snap=0.499965 sec, exc=0.499965 sec, total=0.499965 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000031 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=10 seq_num=11 snap_id=1 wait times: snap=0.500064 sec, exc=0.500064 sec, total=0.500064 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000069 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=9 seq_num=10 snap_id=1 wait times: snap=0.500007 sec, exc=0.500007 sec, total=0.500007 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 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 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.500112 sec, exc=0.500112 sec, total=0.500112 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 5: 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.000010 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.499997 sec, exc=0.499997 sec, total=0.499997 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=4 seq_num=5 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.000011 sec of elapsed time 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 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.000008 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.499983 sec, exc=0.499983 sec, total=0.499983 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time Sampled Session History of session 193 serial 5183 --------------------------------------------------- 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 --------------------------------------------------- [7 samples, 18:08:42 - 18:08:49] idle wait at each sample [session created at: 18:08:42] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-06-08 18:08:49.107 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 15856, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-08 17:59:32.559471 :A20CD1D0:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 17:59:32.559472 :A20CD1D1:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 17:59:32.559472 :A20CD1D2:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 17:59:32.559473 :A20CD1D3:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 17:59:32.559473 :A20CD1D4:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 17:59:32.559941 :A20CD1D5: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-06-08 18:00:02.673046 :A20CDB6F:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-08 18:00:32.669999 :A20CE556:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-08 18:00:32.658 2025-06-08 18:00:32.670001 :A20CE557:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=9988 pso_num=24 pso_serial#=156 2025-06-08 18:00:32.670146 :A20CE558:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=9988 osp_idx=22 osp_ver=375025 osp_pg=0 (spawn #265260) 2025-06-08 18:00:32.670147 :A20CE559:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-08 18:00:32.670147 :A20CE55A:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=145 time=2381375860 2025-06-08 18:00:32.670148 :A20CE55B:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 18:00:32.670148 :A20CE55C:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 18:00:32.670149 :A20CE55D:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 18:00:32.670149 :A20CE55E:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 18:00:32.670149 :A20CE55F:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 18:00:32.670709 :A20CE560: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-06-08 18:01:02.732899 :A20CF0C4:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-08 18:01:32.735311 :A20CFA74:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-08 18:01:32.724 2025-06-08 18:01:32.735313 :A20CFA75:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=14356 pso_num=24 pso_serial#=157 2025-06-08 18:01:32.735446 :A20CFA76:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=14356 osp_idx=22 osp_ver=375026 osp_pg=0 (spawn #265264) 2025-06-08 18:01:32.735446 :A20CFA77:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-08 18:01:32.735447 :A20CFA78:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=146 time=2381435922 2025-06-08 18:01:32.735448 :A20CFA79:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 18:01:32.735448 :A20CFA7A:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 18:01:32.735448 :A20CFA7B:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 18:01:32.735449 :A20CFA7C:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 18:01:32.735449 :A20CFA7D:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 18:01:32.735925 :A20CFA7E: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-06-08 18:02:02.794013 :A20D0498:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-08 18:02:32.828289 :A20D0E27:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-08 18:02:32.815 2025-06-08 18:02:32.828291 :A20D0E28:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16088 pso_num=24 pso_serial#=158 2025-06-08 18:02:32.828446 :A20D0E29:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=16088 osp_idx=22 osp_ver=375027 osp_pg=0 (spawn #265266) 2025-06-08 18:02:32.828447 :A20D0E2A:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-08 18:02:32.828447 :A20D0E2B:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=147 time=2381496016 2025-06-08 18:02:32.828447 :A20D0E2C:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 18:02:32.828448 :A20D0E2D:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 18:02:32.828448 :A20D0E2E:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 18:02:32.828448 :A20D0E2F:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 18:02:32.828449 :A20D0E30:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 18:02:32.828959 :A20D0E31: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-06-08 18:03:02.935801 :A20D17C8:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-08 18:03:32.924011 :A20D2124:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-08 18:03:32.913 2025-06-08 18:03:32.924013 :A20D2125:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16168 pso_num=24 pso_serial#=159 2025-06-08 18:03:32.924140 :A20D2126:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=16168 osp_idx=22 osp_ver=375028 osp_pg=0 (spawn #265268) 2025-06-08 18:03:32.924143 :A20D2127:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-08 18:03:32.924143 :A20D2128:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=148 time=2381556110 2025-06-08 18:03:32.924144 :A20D2129:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 18:03:32.924144 :A20D212A:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 18:03:32.924144 :A20D212B:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 18:03:32.924145 :A20D212C:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 18:03:32.924145 :A20D212D:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 18:03:32.924639 :A20D212E: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-06-08 18:04:03.032376 :A20D2B79:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-08 18:04:33.024050 :A20D3523:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-08 18:04:33.012 2025-06-08 18:04:33.024052 :A20D3524:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16208 pso_num=24 pso_serial#=160 2025-06-08 18:04:33.024182 :A20D3525:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=16208 osp_idx=22 osp_ver=375029 osp_pg=0 (spawn #265271) 2025-06-08 18:04:33.024183 :A20D3526:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-08 18:04:33.024183 :A20D3527:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=149 time=2381616204 2025-06-08 18:04:33.024184 :A20D3528:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 18:04:33.024184 :A20D3529:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 18:04:33.024184 :A20D352A:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 18:04:33.024185 :A20D352B:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 18:04:33.024185 :A20D352C:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 18:04:33.024675 :A20D352D: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-06-08 18:05:03.044555 :A20D3EDD:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-08 18:05:33.072979 :A20D49EF:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-08 18:05:33.061 2025-06-08 18:05:33.072981 :A20D49F0:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=8928 pso_num=24 pso_serial#=161 2025-06-08 18:05:33.073124 :A20D49F1:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=8928 osp_idx=22 osp_ver=375030 osp_pg=0 (spawn #265273) 2025-06-08 18:05:33.073125 :A20D49F2:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-08 18:05:33.073126 :A20D49F3:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=150 time=2381676250 2025-06-08 18:05:33.073126 :A20D49F4:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 18:05:33.073126 :A20D49F5:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 18:05:33.073127 :A20D49F6:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 18:05:33.073127 :A20D49F7:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 18:05:33.073127 :A20D49F8:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 18:05:33.073623 :A20D49F9: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-06-08 18:05:58.101213 :A20D5872: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-06-08 18:06:28.157957 :A20D623D:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-08 18:06:33.155437 :A20D63F8:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-08 18:06:33.144 2025-06-08 18:06:33.155439 :A20D63F9:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16292 pso_num=24 pso_serial#=162 2025-06-08 18:06:33.155571 :A20D63FA:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=16292 osp_idx=22 osp_ver=375031 osp_pg=0 (spawn #265276) 2025-06-08 18:06:33.155572 :A20D63FB:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-08 18:06:33.155572 :A20D63FC:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=151 time=2381736344 2025-06-08 18:06:33.155573 :A20D63FD:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 18:06:33.155573 :A20D63FE:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 18:06:33.155574 :A20D63FF:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 18:06:33.155574 :A20D6400:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 18:06:33.155574 :A20D6401:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 18:06:33.156040 :A20D6402: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-06-08 18:07:03.250074 :A20D6DC6:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-08 18:07:33.264734 :A20D7768:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-08 18:07:33.253 2025-06-08 18:07:33.264735 :A20D7769:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=14064 pso_num=24 pso_serial#=163 2025-06-08 18:07:33.264871 :A20D776A:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=14064 osp_idx=22 osp_ver=375032 osp_pg=0 (spawn #265278) 2025-06-08 18:07:33.264872 :A20D776B:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-08 18:07:33.264872 :A20D776C:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=152 time=2381796454 2025-06-08 18:07:33.264873 :A20D776D:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 18:07:33.264873 :A20D776E:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 18:07:33.264873 :A20D776F:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 18:07:33.264874 :A20D7770:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 18:07:33.264874 :A20D7771:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 18:07:33.265385 :A20D7772: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-06-08 18:08:03.366504 :A20D8105:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-08 18:08:33.384194 :A20D8AA8:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-08 18:08:33.380 2025-06-08 18:08:33.384196 :A20D8AA9:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=15856 pso_num=24 pso_serial#=164 2025-06-08 18:08:33.384391 :A20D8AAA:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=15856 osp_idx=22 osp_ver=375033 osp_pg=0 (spawn #265280) 2025-06-08 18:08:33.384392 :A20D8AAB:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-08 18:08:33.384392 :A20D8AAC:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=153 time=2381856563 2025-06-08 18:08:33.384393 :A20D8AAD:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-08 18:08:33.384393 :A20D8AAE:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-08 18:08:33.384394 :A20D8AAF:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-08 18:08:33.384394 :A20D8AB0:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-08 18:08:33.384394 :A20D8AB1:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-08 18:08:33.384889 :A20D8AB2: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-06-08 18:08:41.074597 :A20D8FAF: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-06-08 18:08:41.181797 :A20D92F8: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-06-08 18:08:41.181797*:A20D9307:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002475C718 estart=1749377320 eid=16781969 ctx=0x000000077FD6A000 cwh=0x0000000024750068 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-06-08 18:08:41.181797*:A20D9308:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002475C718 curCtx=0x0000000024758938 pubTabIdxCnt=0 2025-06-08 18:08:41.181797*:A20D9309:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002475C718 2025-06-08 18:08:41.181797*:A20D930A:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002475C718 2025-06-08 18:08:41.181797*:A20D930D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002475C718 curCtx=0x0000000024758938 xsc->flg4=65792 flags=2 2025-06-08 18:08:41.181797*:A20D930E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002475C718 2025-06-08 18:08:41.186899 :A20D9317: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-06-08 18:08:41.186942 :A20D931A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:jslv.c:9203 2025-06-08 18:08:41.190926 :A20D932A: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-06-08 18:08:41.286076 :A20D9332: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-06-08 18:08:41.415282 :A20D933A: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-06-08 18:08:41.546172 :A20D9342: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-06-08 18:08:42.675169 :A20D9356: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-06-08 18:08:42.676152 :A20D935E: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-06-08 18:08:42.677822 :A20D9366: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-06-08 18:08:42.679366 :A20D936E: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-06-08 18:08:42.681790 :A20D9376: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-06-08 18:08:42.683438 :A20D937E: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-06-08 18:08:42.699000 :A20D9386: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-06-08 18:08:42.699624 :A20D938E: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-06-08 18:08:42.700138 :A20D9396: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-06-08 18:08:42.700652 :A20D939E: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-06-08 18:08:42.703296 :A20D93A6: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-06-08 18:08:42.704185 :A20D93AE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-08 18:08:42.704938 :A20D93AF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-08 18:08:42.705683 :A20D93B0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-08 18:08:42.706075 :A20D93B1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-08 18:08:42.706080 :A20D93B2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-08 18:08:42.706620 :A20D93B3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-08 18:08:42.707145 :A20D93B4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-08 18:08:42.707422 :A20D93B5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-08 18:08:42.708469 :A20D93B6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-08 18:08:42.748483 :A20D93B7: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-06-08 18:08:42.748527 :A20D93BA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-08 18:08:42.749389 :A20D93C0: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-06-08 18:08:42.750220 :A20D93C8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-08 18:08:42.750643 :A20D93C9: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-06-08 18:08:42.770808 :A20D93D1: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-06-08 18:08:42.770858 :A20D93D4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-08 18:08:42.771743 :A20D93DA: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-06-08 18:08:42.772538 :A20D93E2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-08 18:08:42.772982 :A20D93E3: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-06-08 18:08:42.794587 :A20D93F7: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-06-08 18:08:42.794640 :A20D93FA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-08 18:08:42.794640*:A20D9400:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024797A60 estart=1749377322 eid=16778053 ctx=0x0000000773524750 cwh=0x0000000024750CA0 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-06-08 18:08:42.794640*:A20D9401:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024797A60 curCtx=0x0000000028BE2DF0 pubTabIdxCnt=0 2025-06-08 18:08:42.794640*:A20D9402:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024797A60 2025-06-08 18:08:42.794640*:A20D9403:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024797A60 2025-06-08 18:08:42.794640*:A20D9404:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024797A60 curCtx=0x0000000028BE2DF0 xsc->flg4=65792 flags=1 2025-06-08 18:08:42.794640*:A20D9405:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024797A60 2025-06-08 18:08:42.795632 :A20D9406: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-06-08 18:08:42.796510 :A20D940E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-08 18:08:42.796935 :A20D940F: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-06-08 18:08:42.817300 :A20D9450: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-06-08 18:08:42.817347 :A20D9453:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-08 18:08:42.818228 :A20D9459: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-06-08 18:08:42.819129 :A20D9461:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-08 18:08:42.819589 :A20D9462: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-06-08 18:08:42.837278 :A20D946A: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-06-08 18:08:42.837327 :A20D946D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-08 18:08:42.838253 :A20D9473: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-06-08 18:08:42.838690 :A20D947B: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-06-08 18:08:42.839037 :A20D9483: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-06-08 18:08:42.839205 :A20D948B: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-06-08 18:08:42.839338 :A20D9493: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-06-08 18:08:42.839477 :A20D949B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:jslv.c:9203 2025-06-08 18:08:42.843738 :A20D949C: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-06-08 18:08:42.843820 :A20D949F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-06-08 18:08:42.843905 :A20D94AC: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 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 24 (osid: 15856, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de