Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250805082851\orcl_j000_19064_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:35714M/63366M, Ph+PgF:41261M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 19064, image: ORACLE.EXE (J000) *** 2025-08-05 08:28:51.906 *** SESSION ID:(193.61399) 2025-08-05 08:28:51.906 *** 2025-08-05 08:28:51.906 Process diagnostic dump for ORACLE.EXE (J000), OS id=19064, pid: 24, proc_ser: 39, sid: 193, sess_ser: 61399 ------------------------------------------------------------------------------- current sql: client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 19064 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.448949 sec, exc=0.448949 sec, total=0.448949 sec wait times: max=0.500000 sec, heur=2.950817 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.000009 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 snap_id=1 wait times: snap=0.510100 sec, exc=0.510100 sec, total=0.510100 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 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.000010 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.499990 sec, exc=0.499990 sec, total=0.499990 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 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.000010 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.491735 sec, exc=0.491735 sec, total=0.491735 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 193 serial 61399 --------------------------------------------------- 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, 08:28:48 - 08:28:51] idle wait at each sample [session created at: 08:28:48] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-05 08:28:51.906 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 19064, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-05 08:13:47.719090 :BB9602F8:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:13:47.719090 :BB9602F9:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:13:47.719685 :BB9602FA: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-08-05 08:14:17.808996 :BB960CE5:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:14:47.826026 :BB961695:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:14:47.815 2025-08-05 08:14:47.826028 :BB961696:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20352 pso_num=24 pso_serial#=25 2025-08-05 08:14:47.826161 :BB961697:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=20352 osp_idx=22 osp_ver=678590 osp_pg=0 (spawn #457250) 2025-08-05 08:14:47.826161 :BB961698:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:14:47.826162 :BB961699:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=8 time=3062357126 2025-08-05 08:14:47.826162 :BB96169A:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:14:47.826163 :BB96169B:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:14:47.826163 :BB96169C:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:14:47.826163 :BB96169D:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:14:47.826164 :BB96169E:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:14:47.826658 :BB96169F: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-08-05 08:15:17.906899 :BB962149:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:15:47.893452 :BB962B58:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:15:47.882 2025-08-05 08:15:47.893456 :BB962B59:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19232 pso_num=24 pso_serial#=26 2025-08-05 08:15:47.893599 :BB962B5A:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19232 osp_idx=22 osp_ver=678591 osp_pg=0 (spawn #457252) 2025-08-05 08:15:47.893600 :BB962B5B:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:15:47.893600 :BB962B5C:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=9 time=3062417189 2025-08-05 08:15:47.893600 :BB962B5D:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:15:47.893601 :BB962B5E:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:15:47.893601 :BB962B5F:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:15:47.893602 :BB962B60:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:15:47.893602 :BB962B61:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:15:47.894117 :BB962B62: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-08-05 08:16:17.953393 :BB96355C:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:16:47.962369 :BB963F49:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:16:47.951 2025-08-05 08:16:47.962371 :BB963F4A:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20112 pso_num=24 pso_serial#=27 2025-08-05 08:16:47.962508 :BB963F4B:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=20112 osp_idx=22 osp_ver=678592 osp_pg=0 (spawn #457254) 2025-08-05 08:16:47.962509 :BB963F4C:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:16:47.962509 :BB963F4D:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=10 time=3062477267 2025-08-05 08:16:47.962510 :BB963F4E:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:16:47.962510 :BB963F4F:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:16:47.962510 :BB963F50:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:16:47.962511 :BB963F51:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:16:47.962511 :BB963F52:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:16:47.962987 :BB963F53: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-08-05 08:17:18.049676 :BB9648F6:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:17:48.033923 :BB9652FC:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:17:48.023 2025-08-05 08:17:48.033925 :BB9652FD:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18744 pso_num=24 pso_serial#=28 2025-08-05 08:17:48.034054 :BB9652FE:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=18744 osp_idx=22 osp_ver=678593 osp_pg=0 (spawn #457256) 2025-08-05 08:17:48.034055 :BB9652FF:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:17:48.034055 :BB965300:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=11 time=3062537329 2025-08-05 08:17:48.034056 :BB965301:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:17:48.034056 :BB965302:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:17:48.034057 :BB965303:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:17:48.034057 :BB965304:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:17:48.034057 :BB965305:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:17:48.034573 :BB965306: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-08-05 08:18:18.109296 :BB965D57:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:18:48.104698 :BB966762:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:18:48.093 2025-08-05 08:18:48.104701 :BB966763:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=6372 pso_num=24 pso_serial#=29 2025-08-05 08:18:48.104840 :BB966764:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=6372 osp_idx=22 osp_ver=678594 osp_pg=0 (spawn #457258) 2025-08-05 08:18:48.104840 :BB966765:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:18:48.104841 :BB966766:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=12 time=3062597408 2025-08-05 08:18:48.104841 :BB966767:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:18:48.104841 :BB966768:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:18:48.104842 :BB966769:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:18:48.104842 :BB96676A:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:18:48.104842 :BB96676B:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:18:48.105324 :BB96676C: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-08-05 08:19:03.097969 :BB966C67: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-08-05 08:19:33.166029 :BB96764D:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:19:48.163075 :BB967B3B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:19:48.152 2025-08-05 08:19:48.163076 :BB967B3C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16748 pso_num=24 pso_serial#=30 2025-08-05 08:19:48.163211 :BB967B3D:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=16748 osp_idx=22 osp_ver=678595 osp_pg=0 (spawn #457261) 2025-08-05 08:19:48.163212 :BB967B3E:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:19:48.163212 :BB967B3F:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=13 time=3062657470 2025-08-05 08:19:48.163213 :BB967B40:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:19:48.163213 :BB967B41:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:19:48.163213 :BB967B42:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:19:48.163214 :BB967B43:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:19:48.163214 :BB967B44:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:19:48.163684 :BB967B45: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-08-05 08:20:18.248424 :BB96856F:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:20:48.245731 :BB968F4C:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:20:48.234 2025-08-05 08:20:48.245733 :BB968F4D:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18448 pso_num=24 pso_serial#=31 2025-08-05 08:20:48.245867 :BB968F4E:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=18448 osp_idx=22 osp_ver=678596 osp_pg=0 (spawn #457263) 2025-08-05 08:20:48.245868 :BB968F4F:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:20:48.245868 :BB968F50:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=14 time=3062717548 2025-08-05 08:20:48.245869 :BB968F51:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:20:48.245869 :BB968F52:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:20:48.245869 :BB968F53:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:20:48.245870 :BB968F54:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:20:48.245870 :BB968F55:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:20:48.246365 :BB968F56: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-08-05 08:21:18.317274 :BB969944:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:21:48.355401 :BB96A33A:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:21:48.345 2025-08-05 08:21:48.355403 :BB96A33B:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18368 pso_num=24 pso_serial#=32 2025-08-05 08:21:48.355542 :BB96A33C:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=18368 osp_idx=22 osp_ver=678597 osp_pg=0 (spawn #457265) 2025-08-05 08:21:48.355543 :BB96A33D:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:21:48.355544 :BB96A33E:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=15 time=3062777658 2025-08-05 08:21:48.355544 :BB96A33F:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:21:48.355545 :BB96A340:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:21:48.355545 :BB96A341:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:21:48.355545 :BB96A342:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:21:48.355546 :BB96A343:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:21:48.356033 :BB96A344: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-08-05 08:22:18.439290 :BB96AD1C:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:22:48.429458 :BB96B79C:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:22:48.418 2025-08-05 08:22:48.429460 :BB96B79D:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=11076 pso_num=24 pso_serial#=33 2025-08-05 08:22:48.429582 :BB96B79E:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=11076 osp_idx=22 osp_ver=678598 osp_pg=0 (spawn #457267) 2025-08-05 08:22:48.429583 :BB96B79F:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:22:48.429583 :BB96B7A0:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=16 time=3062837736 2025-08-05 08:22:48.429583 :BB96B7A1:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:22:48.429584 :BB96B7A2:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:22:48.429584 :BB96B7A3:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:22:48.429584 :BB96B7A4:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:22:48.429585 :BB96B7A5:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:22:48.430084 :BB96B7A6: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-08-05 08:23:18.512773 :BB96C191:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:23:48.507973 :BB96CBD5:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:23:48.497 2025-08-05 08:23:48.507975 :BB96CBD6:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18536 pso_num=24 pso_serial#=34 2025-08-05 08:23:48.508107 :BB96CBD7:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=18536 osp_idx=22 osp_ver=678599 osp_pg=0 (spawn #457271) 2025-08-05 08:23:48.508108 :BB96CBD8:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:23:48.508108 :BB96CBD9:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=17 time=3062897814 2025-08-05 08:23:48.508109 :BB96CBDA:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:23:48.508109 :BB96CBDB:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:23:48.508109 :BB96CBDC:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:23:48.508110 :BB96CBDD:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:23:48.508110 :BB96CBDE:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:23:48.508604 :BB96CBDF: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-08-05 08:24:18.575518 :BB96D5C3:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:24:48.590974 :BB96DFD2:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:24:48.579 2025-08-05 08:24:48.590976 :BB96DFD3:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19808 pso_num=24 pso_serial#=35 2025-08-05 08:24:48.591108 :BB96DFD4:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19808 osp_idx=22 osp_ver=678600 osp_pg=0 (spawn #457273) 2025-08-05 08:24:48.591108 :BB96DFD5:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:24:48.591108 :BB96DFD6:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=18 time=3062957892 2025-08-05 08:24:48.591109 :BB96DFD7:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:24:48.591109 :BB96DFD8:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:24:48.591109 :BB96DFD9:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:24:48.591110 :BB96DFDA:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:24:48.591110 :BB96DFDB:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:24:48.591586 :BB96DFDC: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-08-05 08:25:18.666238 :BB96EA88:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:25:48.668912 :BB96F418:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:25:48.657 2025-08-05 08:25:48.668914 :BB96F419:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=6128 pso_num=24 pso_serial#=36 2025-08-05 08:25:48.669045 :BB96F41A:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=6128 osp_idx=22 osp_ver=678601 osp_pg=0 (spawn #457275) 2025-08-05 08:25:48.669045 :BB96F41B:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:25:48.669046 :BB96F41C:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=19 time=3063017970 2025-08-05 08:25:48.669046 :BB96F41D:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:25:48.669046 :BB96F41E:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:25:48.669047 :BB96F41F:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:25:48.669047 :BB96F420:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:25:48.669047 :BB96F421:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:25:48.669548 :BB96F422: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-08-05 08:26:18.767627 :BB96FE1F:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:26:48.766702 :BB970809:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:26:48.755 2025-08-05 08:26:48.766705 :BB97080A:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18352 pso_num=24 pso_serial#=37 2025-08-05 08:26:48.766826 :BB97080B:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=18352 osp_idx=22 osp_ver=678602 osp_pg=0 (spawn #457277) 2025-08-05 08:26:48.766826 :BB97080C:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:26:48.766827 :BB97080D:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=20 time=3063078064 2025-08-05 08:26:48.766827 :BB97080E:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:26:48.766827 :BB97080F:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:26:48.766828 :BB970810:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:26:48.766828 :BB970811:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:26:48.766829 :BB970812:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:26:48.767326 :BB970813: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-08-05 08:27:18.869295 :BB97120E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:27:48.871796 :BB971C12:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:27:48.860 2025-08-05 08:27:48.871798 :BB971C13:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=9092 pso_num=24 pso_serial#=38 2025-08-05 08:27:48.871926 :BB971C14:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=9092 osp_idx=22 osp_ver=678603 osp_pg=0 (spawn #457279) 2025-08-05 08:27:48.871926 :BB971C15:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:27:48.871927 :BB971C16:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=21 time=3063138173 2025-08-05 08:27:48.871927 :BB971C17:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:27:48.871927 :BB971C18:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:27:48.871928 :BB971C19:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:27:48.871928 :BB971C1A:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:27:48.871928 :BB971C1B:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:27:48.872455 :BB971C1C: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-08-05 08:28:18.960045 :BB972679:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-05 08:28:48.938546 :BB976944:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-05 08:28:48.933 2025-08-05 08:28:48.938548 :BB976945:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19064 pso_num=24 pso_serial#=39 2025-08-05 08:28:48.938685 :BB976946:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19064 osp_idx=22 osp_ver=678604 osp_pg=0 (spawn #457281) 2025-08-05 08:28:48.938686 :BB976947:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-05 08:28:48.938686 :BB976948:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=22 time=3063198251 2025-08-05 08:28:48.938686 :BB976949:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-05 08:28:48.938687 :BB97694A:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-05 08:28:48.938687 :BB97694B:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-05 08:28:48.938687 :BB97694C:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-05 08:28:48.938688 :BB97694D:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-05 08:28:48.939187 :BB97694E: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-08-05 08:28:48.939796 :BB976963: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-08-05 08:28:48.950976 :BB97698D:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-05 08:28:48.951428 :BB97698E:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-08-05 08:28:48.953791 :BB97698F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-05 08:28:48.954118 :BB976990: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-08-05 08:28:48.954153 :BB976993:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-05 08:28:48.955087 :BB976999: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-08-05 08:28:48.955207 :BB9769A2: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: 19064, J000)