Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250621180636\orcl_j001_16756_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250621180636\orcl_j001_16756_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:36413M/63366M, Ph+PgF:42833M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 16756, image: ORACLE.EXE (J001) *** 2025-06-21 18:06:37.022 *** SESSION ID:(209.58271) 2025-06-21 18:06:37.022 *** 2025-06-21 18:06:37.022 Process diagnostic dump for ORACLE.EXE (J001), OS id=16756, pid: 26, proc_ser: 83, sid: 209, sess_ser: 58271 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 16756 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.418529 sec, exc=0.418529 sec, total=0.418529 sec wait times: max=0.500000 sec, heur=2.421973 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.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.000011 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.500013 sec, exc=0.500013 sec, total=0.500013 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 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.499991 sec, exc=0.499991 sec, total=0.499991 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000013 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.503411 sec, exc=0.503411 sec, total=0.503411 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 58271 --------------------------------------------------- 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, 18:06:34 - 18:06:37] idle wait at each sample [session created at: 18:06:34] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-06-21 18:06:37.022 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 16756, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-21 17:57:29.260699 :A7C2F005:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 17:57:29.249 2025-06-21 17:57:29.260701 :A7C2F006:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=8812 pso_num=26 pso_serial#=74 2025-06-21 17:57:29.260828 :A7C2F007:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=8812 osp_idx=24 osp_ver=486359 osp_pg=0 (spawn #308599) 2025-06-21 17:57:29.260829 :A7C2F008: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 17:57:29.260829 :A7C2F009:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=217 time=3504392438 2025-06-21 17:57:29.260830 :A7C2F00A:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 17:57:29.260830 :A7C2F00B:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 17:57:29.260831 :A7C2F00C:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 17:57:29.260831 :A7C2F00D:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 17:57:29.260831 :A7C2F00E:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 17:57:29.261304 :A7C2F00F: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 17:57:59.382494 :A7C2FA33:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 17:58:29.342690 :A7C303E8:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 17:58:29.332 2025-06-21 17:58:29.342692 :A7C303E9:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15536 pso_num=26 pso_serial#=75 2025-06-21 17:58:29.342840 :A7C303EA:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=15536 osp_idx=24 osp_ver=486360 osp_pg=0 (spawn #308601) 2025-06-21 17:58:29.342840 :A7C303EB: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 17:58:29.342841 :A7C303EC:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=218 time=3504452532 2025-06-21 17:58:29.342841 :A7C303ED:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 17:58:29.342842 :A7C303EE:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 17:58:29.342842 :A7C303EF:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 17:58:29.342843 :A7C303F0:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 17:58:29.342843 :A7C303F1:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 17:58:29.343336 :A7C303F2: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 17:58:59.417867 :A7C30D95:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 17:59:29.451130 :A7C31764:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 17:59:29.440 2025-06-21 17:59:29.451132 :A7C31765:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16336 pso_num=26 pso_serial#=76 2025-06-21 17:59:29.451269 :A7C31766:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=16336 osp_idx=24 osp_ver=486361 osp_pg=0 (spawn #308603) 2025-06-21 17:59:29.451270 :A7C31767: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 17:59:29.451270 :A7C31768:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=219 time=3504512641 2025-06-21 17:59:29.451271 :A7C31769:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 17:59:29.451271 :A7C3176A:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 17:59:29.451272 :A7C3176B:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 17:59:29.451272 :A7C3176C:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 17:59:29.451272 :A7C3176D:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 17:59:29.451750 :A7C3176E: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 17:59:59.550136 :A7C3211B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 18:00:29.546417 :A7C32B5B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 18:00:29.535 2025-06-21 18:00:29.546419 :A7C32B5C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17820 pso_num=26 pso_serial#=77 2025-06-21 18:00:29.546558 :A7C32B5D:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=17820 osp_idx=24 osp_ver=486362 osp_pg=0 (spawn #308605) 2025-06-21 18:00:29.546559 :A7C32B5E: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 18:00:29.546560 :A7C32B5F:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=220 time=3504572735 2025-06-21 18:00:29.546561 :A7C32B60:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 18:00:29.546561 :A7C32B61:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 18:00:29.546562 :A7C32B62:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 18:00:29.546562 :A7C32B63:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 18:00:29.546562 :A7C32B64:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 18:00:29.547036 :A7C32B65: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 18:00:59.661284 :A7C337F7:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 18:01:29.630575 :A7C341A4:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 18:01:29.619 2025-06-21 18:01:29.630577 :A7C341A5:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11420 pso_num=26 pso_serial#=78 2025-06-21 18:01:29.630701 :A7C341A6:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=11420 osp_idx=24 osp_ver=486363 osp_pg=0 (spawn #308609) 2025-06-21 18:01:29.630701 :A7C341A7: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 18:01:29.630702 :A7C341A8:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=221 time=3504632813 2025-06-21 18:01:29.630702 :A7C341A9:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 18:01:29.630703 :A7C341AA:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 18:01:29.630703 :A7C341AB:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 18:01:29.630704 :A7C341AC:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 18:01:29.630704 :A7C341AD:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 18:01:29.631193 :A7C341AE: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 18:01:59.737499 :A7C34B52:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 18:02:29.692168 :A7C3550F:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 18:02:29.681 2025-06-21 18:02:29.692170 :A7C35510:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14940 pso_num=26 pso_serial#=79 2025-06-21 18:02:29.692307 :A7C35511:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=14940 osp_idx=24 osp_ver=486364 osp_pg=0 (spawn #308612) 2025-06-21 18:02:29.692308 :A7C35512: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 18:02:29.692309 :A7C35513:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=222 time=3504692875 2025-06-21 18:02:29.692309 :A7C35514:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 18:02:29.692309 :A7C35515:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 18:02:29.692310 :A7C35516:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 18:02:29.692310 :A7C35517:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 18:02:29.692311 :A7C35518:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 18:02:29.692800 :A7C35519: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 18:02:54.708481 :A7C35E25: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 18:03:24.776410 :A7C367E2:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 18:03:29.742978 :A7C369C3:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 18:03:29.732 2025-06-21 18:03:29.742980 :A7C369C4:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17492 pso_num=26 pso_serial#=80 2025-06-21 18:03:29.743111 :A7C369C5:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=17492 osp_idx=24 osp_ver=486365 osp_pg=0 (spawn #308614) 2025-06-21 18:03:29.743112 :A7C369C6: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 18:03:29.743113 :A7C369C7:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=223 time=3504752922 2025-06-21 18:03:29.743113 :A7C369C8:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 18:03:29.743114 :A7C369C9:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 18:03:29.743114 :A7C369CA:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 18:03:29.743114 :A7C369CB:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 18:03:29.743115 :A7C369CC:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 18:03:29.743657 :A7C369CD: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 18:03:59.841226 :A7C37391:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 18:04:29.834848 :A7C37D34:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 18:04:29.824 2025-06-21 18:04:29.834850 :A7C37D35:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16504 pso_num=26 pso_serial#=81 2025-06-21 18:04:29.834983 :A7C37D36:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=16504 osp_idx=24 osp_ver=486366 osp_pg=0 (spawn #308617) 2025-06-21 18:04:29.834984 :A7C37D37: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 18:04:29.834984 :A7C37D38:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=224 time=3504813016 2025-06-21 18:04:29.834985 :A7C37D39:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 18:04:29.834985 :A7C37D3A:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 18:04:29.834985 :A7C37D3B:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 18:04:29.834986 :A7C37D3C:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 18:04:29.834986 :A7C37D3D:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 18:04:29.835458 :A7C37D3E: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 18:04:59.922517 :A7C386DF:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 18:05:29.929672 :A7C390A5:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 18:05:29.918 2025-06-21 18:05:29.929674 :A7C390A6:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16600 pso_num=26 pso_serial#=82 2025-06-21 18:05:29.929805 :A7C390A7:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=16600 osp_idx=24 osp_ver=486367 osp_pg=0 (spawn #308619) 2025-06-21 18:05:29.929806 :A7C390A8: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 18:05:29.929806 :A7C390A9:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=225 time=3504873110 2025-06-21 18:05:29.929807 :A7C390AA:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 18:05:29.929807 :A7C390AB:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 18:05:29.929807 :A7C390AC:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 18:05:29.929808 :A7C390AD:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 18:05:29.929808 :A7C390AE:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 18:05:29.930284 :A7C390AF: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 18:06:00.008146 :A7C3A18D:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-06-21 18:06:30.021229 :A7C3AB4C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 06-21 18:06:30.010 2025-06-21 18:06:30.021231 :A7C3AB4D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16756 pso_num=26 pso_serial#=83 2025-06-21 18:06:30.021366 :A7C3AB4E:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=16756 osp_idx=24 osp_ver=486368 osp_pg=0 (spawn #308621) 2025-06-21 18:06:30.021367 :A7C3AB4F: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 18:06:30.021367 :A7C3AB50:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=226 time=3504933204 2025-06-21 18:06:30.021368 :A7C3AB51:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-06-21 18:06:30.021368 :A7C3AB52:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-06-21 18:06:30.021369 :A7C3AB53:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-06-21 18:06:30.021369 :A7C3AB54:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-21 18:06:30.021369 :A7C3AB55:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-21 18:06:30.021852 :A7C3AB56: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 18:06:32.867815 :A7C3ADA1: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 18:06:32.965926 :A7C3B0E7: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 18:06:32.965926*:A7C3B0F5:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000026FEC718 estart=1750500392 eid=16782761 ctx=0x000000077FD6A000 cwh=0x0000000026FE0068 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-06-21 18:06:32.965926*:A7C3B0F6:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000026FEC718 curCtx=0x0000000026FE8938 pubTabIdxCnt=0 2025-06-21 18:06:32.965926*:A7C3B0F7:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000026FEC718 2025-06-21 18:06:32.965926*:A7C3B0F8:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000026FEC718 2025-06-21 18:06:32.965926*:A7C3B0FB:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000026FEC718 curCtx=0x0000000026FE8938 xsc->flg4=65792 flags=2 2025-06-21 18:06:32.965926*:A7C3B0FC:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000026FEC718 2025-06-21 18:06:32.971099 :A7C3B105: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 18:06:32.971138 :A7C3B108:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-06-21 18:06:32.974950 :A7C3B118: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 18:06:33.081253 :A7C3B133: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 18:06:33.209723 :A7C3B13B: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 18:06:33.336207 :A7C3B143: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 18:06:34.455095 :A7C3B195: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 18:06:34.456058 :A7C3B19D: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 18:06:34.457794 :A7C3B1A5: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 18:06:34.459174 :A7C3B1AD: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 18:06:34.460557 :A7C3B1B5: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 18:06:34.463032 :A7C3B1BD: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 18:06:34.478826 :A7C3B1C5: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 18:06:34.479455 :A7C3B1CD: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 18:06:34.479967 :A7C3B1D5: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 18:06:34.480461 :A7C3B1DD: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 18:06:34.483127 :A7C3B1E5: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 18:06:34.484018 :A7C3B1ED:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 18:06:34.484769 :A7C3B1EE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 18:06:34.485554 :A7C3B1EF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 18:06:34.486001 :A7C3B1F0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 18:06:34.486008 :A7C3B1F1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 18:06:34.486547 :A7C3B1F2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 18:06:34.487033 :A7C3B1F3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 18:06:34.487304 :A7C3B1F4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 18:06:34.488357 :A7C3B1F5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 18:06:34.515605 :A7C3B202: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 18:06:34.515659 :A7C3B205:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 18:06:34.516543 :A7C3B20B: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 18:06:34.517387 :A7C3B213:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 18:06:34.517796 :A7C3B214: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 18:06:34.537845 :A7C3B224: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 18:06:34.537890 :A7C3B227:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 18:06:34.538786 :A7C3B22D: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 18:06:34.539719 :A7C3B235:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 18:06:34.540177 :A7C3B236: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 18:06:34.557658 :A7C3B246: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 18:06:34.557695 :A7C3B249:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 18:06:34.558592 :A7C3B250: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 18:06:34.559457 :A7C3B259:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 18:06:34.559660 :A7C3B264:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-06-21 18:06:34.559879 :A7C3B26B: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 18:06:34.579851 :A7C3B28B: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 18:06:34.579899 :A7C3B28E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 18:06:34.580734 :A7C3B294: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 18:06:34.581610 :A7C3B29C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-06-21 18:06:34.582099 :A7C3B29D: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 18:06:34.602832 :A7C3B2A5: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 18:06:34.602879 :A7C3B2A8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-06-21 18:06:34.603788 :A7C3B2AE: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 18:06:34.604283 :A7C3B2B6: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 18:06:34.604659 :A7C3B2BE: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 18:06:34.604904 :A7C3B2C6: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 18:06:34.605113 :A7C3B2CE: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 18:06:34.605272 :A7C3B2D6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-06-21 18:06:34.609873 :A7C3B2D7: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 18:06:34.609957 :A7C3B2DA: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 18:06:34.610024 :A7C3B2E7: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: 16756, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de