Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250722220009\orcl_j005_16496_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250722220009\orcl_j005_16496_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:36100M/63366M, Ph+PgF:41944M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 31 Windows thread id: 16496, image: ORACLE.EXE (J005) *** 2025-07-22 22:00:09.467 *** SESSION ID:(249.1473) 2025-07-22 22:00:09.467 *** 2025-07-22 22:00:09.467 Process diagnostic dump for ORACLE.EXE (J005), OS id=16496, pid: 31, proc_ser: 207, sid: 249, sess_ser: 1473 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 16496 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J005) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=16 seq_num=17 snap_id=1 wait times: snap=0.346608 sec, exc=0.346608 sec, total=0.346608 sec wait times: max=0.500000 sec, heur=8.383131 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.000010 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=15 seq_num=16 snap_id=1 wait times: snap=0.510108 sec, exc=0.510108 sec, total=0.510108 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=14 seq_num=15 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.000011 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=13 seq_num=14 snap_id=1 wait times: snap=0.499995 sec, exc=0.499995 sec, total=0.499995 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=12 seq_num=13 snap_id=1 wait times: snap=0.500000 sec, exc=0.500000 sec, total=0.500000 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=11 seq_num=12 snap_id=1 wait times: snap=0.499995 sec, exc=0.499995 sec, total=0.499995 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=10 seq_num=11 snap_id=1 wait times: snap=0.499988 sec, exc=0.499988 sec, total=0.499988 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000016 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=9 seq_num=10 snap_id=1 wait times: snap=0.510163 sec, exc=0.510163 sec, total=0.510163 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 snap_id=1 wait times: snap=0.510114 sec, exc=0.510114 sec, total=0.510114 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.499996 sec, exc=0.499996 sec, total=0.499996 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 snap_id=1 wait times: snap=0.499997 sec, exc=0.499997 sec, total=0.499997 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time Sampled Session History of session 249 serial 1473 --------------------------------------------------- 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 --------------------------------------------------- [9 samples, 22:00:01 - 22:00:09] idle wait at each sample [session created at: 22:00:01] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-22 22:00:09.467 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 31 (osid: 16496, J005) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-18 23:59:52.315841 :B3DE1182:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=9724 pso_num=31 pso_serial#=193 2025-07-18 23:59:52.315979 :B3DE1183:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=9724 (legacy spawn) 2025-07-18 23:59:52.322610 :B3DE119C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-18 23:59:52.322791 :B3DE11A1:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-18 23:59:52.323601 :B3DE11A6:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-18 23:59:52.332396 :B3DE11A9:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-18 23:59:52.318 2025-07-18 23:59:52.332398 :B3DE11AA:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=4728 pso_num=31 pso_serial#=194 2025-07-18 23:59:52.332537 :B3DE11AB:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=4728 (legacy spawn) 2025-07-18 23:59:52.339132 :B3DE11AC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-18 23:59:52.339294 :B3DE11B5:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-18 23:59:52.340103 :B3DE11B6:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-18 23:59:54.787949 :B3DE129F:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-18 23:59:54.787 2025-07-18 23:59:54.787950 :B3DE12A0:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=9144 pso_num=31 pso_serial#=195 2025-07-18 23:59:54.788096 :B3DE12A1:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=9144 (legacy spawn) 2025-07-18 23:59:54.803014 :B3DE12A2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-19 00:00:28.115037 :B3DE2193:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-19 06:00:01.952150 :B3FADF94:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-19 06:00:01.944 2025-07-19 06:00:01.952151 :B3FADF95:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18800 pso_num=31 pso_serial#=196 2025-07-19 06:00:01.952299 :B3FADF96:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=18800 osp_idx=29 osp_ver=705 osp_pg=0 (spawn #400278) 2025-07-19 06:00:01.952300 :B3FADF97:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-19 06:00:01.952300 :B3FADF98:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=213 time=1585577845 2025-07-19 06:00:01.952301 :B3FADF99:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-19 06:00:01.952302 :B3FADF9A:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-19 06:00:01.952302 :B3FADF9B:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-19 06:00:01.952302 :B3FADF9C:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-19 06:00:01.952303 :B3FADF9D:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-19 06:00:01.952933 :B3FADF9E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-19 06:00:32.019779 :B3FAF1B9:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-19 23:59:10.004707 :B451FD6A:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-19 23:59:09.997 2025-07-19 23:59:10.004709 :B451FD6B:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18600 pso_num=31 pso_serial#=197 2025-07-19 23:59:10.004863 :B451FD6C:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=18600 (legacy spawn) 2025-07-19 23:59:10.020010 :B451FD6D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-19 23:59:43.377639 :B4520A04:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-19 23:59:46.988924 :B4520BB9:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-19 23:59:46.982 2025-07-19 23:59:46.988926 :B4520BBA:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18544 pso_num=31 pso_serial#=198 2025-07-19 23:59:46.989072 :B4520BBB:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=18544 (legacy spawn) 2025-07-19 23:59:47.003954 :B4520BBC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 00:00:20.137950 :B4521756:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-20 06:00:02.053530 :B46EB5DD:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-20 06:00:02.050 2025-07-20 06:00:02.053532 :B46EB5DE:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17836 pso_num=31 pso_serial#=199 2025-07-20 06:00:02.053649 :B46EB5DF:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=17836 osp_idx=29 osp_ver=708 osp_pg=0 (spawn #403612) 2025-07-20 06:00:02.053649 :B46EB5E0:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-20 06:00:02.053650 :B46EB5E1:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=214 time=1671977939 2025-07-20 06:00:02.053650 :B46EB5E2:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-20 06:00:02.053651 :B46EB5E3:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-20 06:00:02.053651 :B46EB5E4:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-20 06:00:02.053651 :B46EB5E5:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-20 06:00:02.053652 :B46EB5E6:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-20 06:00:02.054151 :B46EB5FB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-20 06:00:32.152036 :B46EC9CA:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-20 23:59:10.079826 :B4C47388:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-20 23:59:10.065 2025-07-20 23:59:10.079828 :B4C47389:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17996 pso_num=31 pso_serial#=200 2025-07-20 23:59:10.079968 :B4C4738A:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17996 (legacy spawn) 2025-07-20 23:59:10.094802 :B4C4738B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 23:59:43.245808 :B4C47F3C:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-20 23:59:44.548329 :B4C47FA9:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-20 23:59:44.540 2025-07-20 23:59:44.548331 :B4C47FAA:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=16028 pso_num=31 pso_serial#=201 2025-07-20 23:59:44.548475 :B4C47FAB:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=16028 (legacy spawn) 2025-07-20 23:59:44.555043 :B4C47FAC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 23:59:44.555211 :B4C47FB1:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-20 23:59:44.556047 :B4C47FB6:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-20 23:59:47.408832 :B4C480A3:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-20 23:59:47.398 2025-07-20 23:59:47.408834 :B4C480A4:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17152 pso_num=31 pso_serial#=202 2025-07-20 23:59:47.408965 :B4C480A5:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17152 (legacy spawn) 2025-07-20 23:59:47.423844 :B4C480CE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 00:00:20.456870 :B4C48C8B:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-21 22:00:00.543725 :B52BDBF6:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-21 22:00:00.540 2025-07-21 22:00:00.543726 :B52BDBF7:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=11428 pso_num=31 pso_serial#=203 2025-07-21 22:00:00.543876 :B52BDBF8:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=11428 osp_idx=29 osp_ver=712 osp_pg=0 (spawn #409161) 2025-07-21 22:00:00.543877 :B52BDBF9:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-21 22:00:00.543878 :B52BDBFA:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=215 time=1815976423 2025-07-21 22:00:00.543878 :B52BDBFB:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-21 22:00:00.543878 :B52BDBFC:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-21 22:00:00.543879 :B52BDBFD:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-21 22:00:00.543879 :B52BDBFE:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-21 22:00:00.543879 :B52BDBFF:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-21 22:00:00.544453 :B52BDC00:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.549592 :B52BDC3A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.549616 :B52BDC3D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:jslv.c:9203 2025-07-21 22:00:00.567297 :B52BDD2B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.567497 :B52BDD63:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.567667 :B52BDD6E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.567867 :B52BDD7A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568035 :B52BDD88:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568184 :B52BDD8B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568354 :B52BDDA8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568581 :B52BDDF5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568735 :B52BDE41:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569029 :B52BDEF5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569185 :B52BDF27:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569347 :B52BDF73:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569510 :B52BDFD4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569656 :B52BDFE2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569804 :B52BDFEA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569953 :B52BDFF3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570109 :B52BDFFB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570251 :B52BE012:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570444 :B52BE02E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570667 :B52BE04B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] 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-07-21 22:00:00.570691 :B52BE04F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570813 :B52BE078:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] 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-07-21 22:00:00.570835 :B52BE07A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570990 :B52BE08C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.575833 :B52BE0AB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] 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-07-21 22:00:00.582665 :B52BE0C0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] 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-07-21 22:00:00.592234 :B52BE0D0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:01.696344*:B52BE26D:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000342A3AD0 estart=1753106401 eid=20637785 ctx=0x0000000777968158 cwh=0x00000000342D09C8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-07-21 22:00:01.696344*:B52BE26E:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000342A3AD0 curCtx=0x00000000507A7918 pubTabIdxCnt=0 2025-07-21 22:00:01.696344*:B52BE26F:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000342A3AD0 2025-07-21 22:00:01.696344*:B52BE270:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000342A3AD0 2025-07-21 22:00:01.696344*:B52BE271:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003431B6F0 estart=1753106400 eid=16777471 ctx=0x000000077B54EAC8 cwh=0x00000000342D0518 cpu=906250 buffg=51822 interb=196608 r=24 rb=196608 w=0 wb=0 2025-07-21 22:00:01.696344*:B52BE272:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003431B6F0 curCtx=0x00000000320487D0 pubTabIdxCnt=0 2025-07-21 22:00:01.696344*:B52BE273:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003431B6F0 2025-07-21 22:00:01.696344*:B52BE274:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003431B6F0 2025-07-21 22:00:01.696344*:B52BE275:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000342A3AD0 curCtx=0x00000000507A7918 xsc->flg4=65792 flags=1 2025-07-21 22:00:01.696344*:B52BE276:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000342A3AD0 2025-07-21 22:00:02.245706*:B52BE43D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003431B6F0 curCtx=0x00000000320487D0 xsc->flg4=65792 flags=2 2025-07-21 22:00:02.245706*:B52BE43E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003431B6F0 2025-07-21 22:00:02.259281 :B52BE43F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.280082 :B52BE4A0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.282457 :B52BE4A8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:psdpgi.c:2235 2025-07-21 22:00:02.282652 :B52BE4A9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpop:psdpgi.c:2235 2025-07-21 22:00:02.283539 :B52BE4AA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.283644 :B52BE4AD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.284492 :B52BE4BF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.286053 :B52BE4C7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.286353 :B52BE4CF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-21 22:00:02.433322 :B52BE4D7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:04.315842 :B52BE610:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:04.315855 :B52BE611:db_trace:ktur.c@3079:ktuabt(): [10444:31:249] ABORT TRANSACTION - xid: 0x0009.01f.0001d439 2025-07-21 22:00:06.712608 :B52BE824:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:06.716752 :B52BE82C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:06.727928 :B52BE834:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:06.755056 :B52BE83C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:07.838010 :B52BE8FD:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpop:jslv.c:9203 2025-07-21 22:00:07.848947 :B52BE8FE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:0] KSL POST SENT postee=59 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:07.850701 :B52BE906:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-21 22:00:22.841570 :B52BEE63:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-21 22:00:22.836 2025-07-21 22:00:22.841572 :B52BEE64:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18996 pso_num=31 pso_serial#=204 2025-07-21 22:00:22.841717 :B52BEE65:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=18996 osp_idx=29 osp_ver=713 osp_pg=0 (spawn #409164) 2025-07-21 22:00:22.841718 :B52BEE66:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-21 22:00:22.841718 :B52BEE67:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=216 time=1815998736 2025-07-21 22:00:22.841719 :B52BEE68:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-21 22:00:22.841719 :B52BEE69:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-21 22:00:22.841720 :B52BEE6A:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-21 22:00:22.841720 :B52BEE6B:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-21 22:00:22.841720 :B52BEE6C:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-21 22:00:22.843083 :B52BEE6D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-21 22:00:22.843133 :B52BEE74:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] KSL POST RCVD poster=18 loc='ksv2.h LINE:1639 ID:ksvpst: run' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-07-21 22:00:22.851286 :B52BEE82:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-21 22:00:27.521082 :B52BF027:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-21 22:00:27.513 2025-07-21 22:00:27.521083 :B52BF028:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=15780 pso_num=31 pso_serial#=205 2025-07-21 22:00:27.521232 :B52BF029:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=15780 (legacy spawn) 2025-07-21 22:00:27.527892 :B52BF02A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:27.528079 :B52BF02F:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-21 22:00:27.528900 :B52BF034:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-21 23:59:11.995594 :B5361BCE:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-21 23:59:11.983 2025-07-21 23:59:11.995596 :B5361BCF:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17272 pso_num=31 pso_serial#=206 2025-07-21 23:59:11.995707 :B5361BD0:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=17272 osp_idx=29 osp_ver=715 osp_pg=0 (spawn #409442) 2025-07-21 23:59:11.995708 :B5361BD1:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-21 23:59:11.995709 :B5361BD2:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=217 time=1823127876 2025-07-21 23:59:11.995709 :B5361BD3:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-21 23:59:11.995709 :B5361BD4:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-21 23:59:11.995710 :B5361BD5:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-21 23:59:11.995710 :B5361BD6:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-21 23:59:11.995710 :B5361BD7:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-21 23:59:11.996276 :B5361BD8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-21 23:59:37.031528 :B5362594:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-07-22 00:00:07.111636 :B5363066:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-22 22:00:01.085824 :B59EA303:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-22 22:00:01.083 2025-07-22 22:00:01.085826 :B59EA304:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=16496 pso_num=31 pso_serial#=207 2025-07-22 22:00:01.085963 :B59EA312:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=16496 osp_idx=29 osp_ver=716 osp_pg=0 (spawn #412487) 2025-07-22 22:00:01.085964 :B59EA313:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-22 22:00:01.085965 :B59EA314:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=218 time=1902376970 2025-07-22 22:00:01.085965 :B59EA315:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-22 22:00:01.085966 :B59EA316:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-22 22:00:01.085966 :B59EA317:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-22 22:00:01.085967 :B59EA318:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-22 22:00:01.085967 :B59EA319:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-22 22:00:01.086516 :B59EA31E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 31 (osid: 16496, J005)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de