Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250621220707\orcl_j001_17888_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250621220707\orcl_j001_17888_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:36400M/63366M, Ph+PgF:42697M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 17888, image: ORACLE.EXE (J001) *** 2025-06-21 22:07:07.418 *** SESSION ID:(209.58779) 2025-06-21 22:07:07.418 *** 2025-06-21 22:07:07.418 Process diagnostic dump for ORACLE.EXE (J001), OS id=17888, pid: 26, proc_ser: 69, sid: 209, sess_ser: 58779 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 17888 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 snap_id=1 wait times: snap=0.180195 sec, exc=0.180195 sec, total=0.180195 sec wait times: max=0.500000 sec, heur=2.171422 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=3 seq_num=4 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.000012 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.499993 sec, exc=0.499993 sec, total=0.499993 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 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.000007 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.491194 sec, exc=0.491194 sec, total=0.491194 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000000 sec of elapsed time Sampled Session History of session 209 serial 58779 --------------------------------------------------- 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 --------------------------------------------------- [3 samples, 22:07:05 - 22:07:07] idle wait at each sample [session created at: 22:07:05] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-06-21 22:07:07.418 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 17888, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-21 21:57:51.279100 :A7D5ABEE:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=16748 osp_idx=24 osp_ver=486600 osp_pg=0 (spawn #309157) 2025-06-21 21:57:51.279100 :A7D5ABEF:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 21:57:51.279100 :A7D5ABF0:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=201 time=3518814469 2025-06-21 21:57:51.279101 :A7D5ABF1:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 21:57:51.279101 :A7D5ABF2:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 21:57:51.279101 :A7D5ABF3:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 21:57:51.279102 :A7D5ABF4:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 21:57:51.279102 :A7D5ABF5:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 21:57:51.279565 :A7D5ABF6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 21:58:21.384711 :A7D5B671:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 21:58:51.389700 :A7D5C02E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 21:58:51.379 2025-06-21 21:58:51.389702 :A7D5C02F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13976 pso_num=26 pso_serial#=61 2025-06-21 21:58:51.389837 :A7D5C030:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=13976 osp_idx=24 osp_ver=486601 osp_pg=0 (spawn #309159) 2025-06-21 21:58:51.389838 :A7D5C031:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 21:58:51.389838 :A7D5C032:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=202 time=3518874579 2025-06-21 21:58:51.389839 :A7D5C033:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 21:58:51.389839 :A7D5C034:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 21:58:51.389839 :A7D5C035:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 21:58:51.389840 :A7D5C036:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 21:58:51.389840 :A7D5C037:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 21:58:51.390316 :A7D5C038:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 21:59:21.500797 :A7D5CA14:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 21:59:51.500938 :A7D5D3CB:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 21:59:51.490 2025-06-21 21:59:51.500941 :A7D5D3CC:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17316 pso_num=26 pso_serial#=62 2025-06-21 21:59:51.501073 :A7D5D3CD:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=17316 osp_idx=24 osp_ver=486602 osp_pg=0 (spawn #309161) 2025-06-21 21:59:51.501075 :A7D5D3CE:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 21:59:51.501075 :A7D5D3CF:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=203 time=3518934688 2025-06-21 21:59:51.501076 :A7D5D3D0:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 21:59:51.501076 :A7D5D3D1:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 21:59:51.501076 :A7D5D3D2:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 21:59:51.501077 :A7D5D3D3:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 21:59:51.501077 :A7D5D3D4:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 21:59:51.501551 :A7D5D3D5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 22:00:04.005313 :A7D5D8FC:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] 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-21 22:00:34.093742 :A7D5E305:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 22:00:51.596592 :A7D5E8AA:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 22:00:51.586 2025-06-21 22:00:51.596593 :A7D5E8AB:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=18004 pso_num=26 pso_serial#=63 2025-06-21 22:00:51.596733 :A7D5E8AC:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=18004 osp_idx=24 osp_ver=486603 osp_pg=0 (spawn #309165) 2025-06-21 22:00:51.596734 :A7D5E8AD:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 22:00:51.596734 :A7D5E8AE:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=204 time=3518994782 2025-06-21 22:00:51.596735 :A7D5E8AF:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 22:00:51.596735 :A7D5E8B0:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 22:00:51.596736 :A7D5E8B1:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 22:00:51.596736 :A7D5E8B2:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 22:00:51.596737 :A7D5E8B3:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 22:00:51.597347 :A7D5E8BC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 22:01:21.682311 :A7D5F3B5:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 22:01:51.705100 :A7D5FD6D:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 22:01:51.693 2025-06-21 22:01:51.705102 :A7D5FD6E:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13904 pso_num=26 pso_serial#=64 2025-06-21 22:01:51.705230 :A7D5FD6F:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=13904 osp_idx=24 osp_ver=486604 osp_pg=0 (spawn #309167) 2025-06-21 22:01:51.705231 :A7D5FD70:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 22:01:51.705231 :A7D5FD71:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=205 time=3519054891 2025-06-21 22:01:51.705232 :A7D5FD72:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 22:01:51.705232 :A7D5FD73:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 22:01:51.705232 :A7D5FD74:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 22:01:51.705233 :A7D5FD75:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 22:01:51.705233 :A7D5FD76:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 22:01:51.705740 :A7D5FD77:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 22:02:21.788429 :A7D6077B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 22:02:51.759833 :A7D61117:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 22:02:51.749 2025-06-21 22:02:51.759835 :A7D61118:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17840 pso_num=26 pso_serial#=65 2025-06-21 22:02:51.759974 :A7D61119:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=17840 osp_idx=24 osp_ver=486605 osp_pg=0 (spawn #309170) 2025-06-21 22:02:51.759974 :A7D6111A:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 22:02:51.759975 :A7D6111B:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=206 time=3519114938 2025-06-21 22:02:51.759975 :A7D6111C:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 22:02:51.759976 :A7D6111D:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 22:02:51.759976 :A7D6111E:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 22:02:51.759976 :A7D6111F:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 22:02:51.759977 :A7D61120:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 22:02:51.760463 :A7D61121:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 22:03:16.791380 :A7D619D8:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] 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-21 22:03:46.875162 :A7D62367:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 22:03:51.858979 :A7D62551:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 22:03:51.848 2025-06-21 22:03:51.858981 :A7D62552:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17628 pso_num=26 pso_serial#=66 2025-06-21 22:03:51.859120 :A7D62553:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=17628 osp_idx=24 osp_ver=486606 osp_pg=0 (spawn #309172) 2025-06-21 22:03:51.859121 :A7D62554:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 22:03:51.859121 :A7D62555:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=207 time=3519175047 2025-06-21 22:03:51.859122 :A7D62556:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 22:03:51.859122 :A7D62557:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 22:03:51.859123 :A7D62558:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 22:03:51.859123 :A7D62559:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 22:03:51.859123 :A7D6255A:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 22:03:51.859589 :A7D6255B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 22:04:21.930413 :A7D62F2A:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 22:04:51.973019 :A7D63915:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 22:04:51.970 2025-06-21 22:04:51.973021 :A7D63916:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=7588 pso_num=26 pso_serial#=67 2025-06-21 22:04:51.973156 :A7D63917:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=7588 osp_idx=24 osp_ver=486607 osp_pg=0 (spawn #309175) 2025-06-21 22:04:51.973158 :A7D63918:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 22:04:51.973159 :A7D63919:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=208 time=3519235157 2025-06-21 22:04:51.973160 :A7D6391A:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 22:04:51.973160 :A7D6391B:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 22:04:51.973160 :A7D6391C:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 22:04:51.973161 :A7D6391D:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 22:04:51.973161 :A7D6391E:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 22:04:51.973622 :A7D6391F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 22:05:22.032801 :A7D64B60:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 22:05:52.062343 :A7D65509:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 22:05:52.051 2025-06-21 22:05:52.062345 :A7D6550A:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15712 pso_num=26 pso_serial#=68 2025-06-21 22:05:52.062490 :A7D6550B:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=15712 osp_idx=24 osp_ver=486608 osp_pg=0 (spawn #309177) 2025-06-21 22:05:52.062491 :A7D6550C:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 22:05:52.062491 :A7D6550D:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=209 time=3519295250 2025-06-21 22:05:52.062492 :A7D6550E:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 22:05:52.062492 :A7D6550F:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 22:05:52.062493 :A7D65510:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 22:05:52.062493 :A7D65511:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 22:05:52.062493 :A7D65512:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 22:05:52.062985 :A7D65513:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 22:06:22.171227 :A7D66052:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 22:06:52.161984 :A7D66A1A:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 22:06:52.151 2025-06-21 22:06:52.161986 :A7D66A1B:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17888 pso_num=26 pso_serial#=69 2025-06-21 22:06:52.162116 :A7D66A1C:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=17888 osp_idx=24 osp_ver=486609 osp_pg=0 (spawn #309179) 2025-06-21 22:06:52.162116 :A7D66A1D:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-21 22:06:52.162117 :A7D66A1E:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=210 time=3519355344 2025-06-21 22:06:52.162117 :A7D66A1F:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 22:06:52.162118 :A7D66A20:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 22:06:52.162118 :A7D66A21:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 22:06:52.162118 :A7D66A22:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 22:06:52.162119 :A7D66A23:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 22:06:52.162610 :A7D66A24:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-21 22:07:03.482762 :A7D66F25:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] 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-21 22:07:03.580724 :A7D66FD7:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] 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-21 22:07:03.580724*:A7D66FE6:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000275EC718 estart=1750514822 eid=16782772 ctx=0x000000077FD6A000 cwh=0x00000000275E0068 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-06-21 22:07:03.580724*:A7D66FE7:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000275EC718 curCtx=0x00000000275E8938 pubTabIdxCnt=0 2025-06-21 22:07:03.580724*:A7D66FE8:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000275EC718 2025-06-21 22:07:03.580724*:A7D66FE9:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000275EC718 2025-06-21 22:07:03.580724*:A7D66FEA:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000275EC718 curCtx=0x00000000275E8938 xsc->flg4=65792 flags=2 2025-06-21 22:07:03.580724*:A7D66FEB:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000275EC718 2025-06-21 22:07:03.585991 :A7D66FF6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:03.586031 :A7D66FF9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-06-21 22:07:03.589958 :A7D67009:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:03.696565 :A7D67011:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:03.825329 :A7D67036:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:03.952894 :A7D6703E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.080268 :A7D67086:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.081261 :A7D6708E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.082923 :A7D67096:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.084490 :A7D6709E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.085958 :A7D670A6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.089987 :A7D670AE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.104781 :A7D670B6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.105492 :A7D670BE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.106042 :A7D670C6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.106539 :A7D670CE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.109197 :A7D670D6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.110104 :A7D670DE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 22:07:05.110870 :A7D670DF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 22:07:05.111627 :A7D670E0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 22:07:05.112075 :A7D670E1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 22:07:05.112083 :A7D670E2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 22:07:05.112707 :A7D670E3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 22:07:05.113223 :A7D670E4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 22:07:05.113540 :A7D670E5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 22:07:05.114605 :A7D670E6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 22:07:05.143748 :A7D670E7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.143793 :A7D670EA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 22:07:05.144636 :A7D670F0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.145481 :A7D670F8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 22:07:05.145904 :A7D670F9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.166188 :A7D67101:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.166241 :A7D67104:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 22:07:05.167220 :A7D6710A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.168074 :A7D67112:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 22:07:05.168533 :A7D67113:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.185956 :A7D67125:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.186008 :A7D67128:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 22:07:05.186995 :A7D6712E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.187887 :A7D67136:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 22:07:05.188562 :A7D67137:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.210592 :A7D67176:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.210656 :A7D67179:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 22:07:05.211736 :A7D6717F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.225129 :A7D67187:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 22:07:05.225679 :A7D67188:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.244663 :A7D67190:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.244727 :A7D67193:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 22:07:05.245755 :A7D67199:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.246319 :A7D671A1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.246744 :A7D671A9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.246951 :A7D671B1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.247094 :A7D671B9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.247269 :A7D671C1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-06-21 22:07:05.248738 :A7D671C2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.252207 :A7D671CA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.252318 :A7D671CD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-06-21 22:07:05.252393 :A7D671DA:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] 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 26 (osid: 17888, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de