Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250820080902\orcl_j001_18624_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250820080902\orcl_j001_18624_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:35343M/63366M, Ph+PgF:40544M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 25 Windows thread id: 18624, image: ORACLE.EXE (J001) *** 2025-08-20 08:09:02.178 *** SESSION ID:(201.18631) 2025-08-20 08:09:02.178 *** 2025-08-20 08:09:02.178 Process diagnostic dump for ORACLE.EXE (J001), OS id=18624, pid: 25, proc_ser: 80, sid: 201, sess_ser: 18631 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 18624 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=26 seq_num=27 snap_id=1 wait times: snap=0.285125 sec, exc=0.285125 sec, total=0.285125 sec wait times: max=0.500000 sec, heur=13.320723 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.000008 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=25 seq_num=26 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.000010 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=24 seq_num=25 snap_id=1 wait times: snap=0.500010 sec, exc=0.500010 sec, total=0.500010 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=23 seq_num=24 snap_id=1 wait times: snap=0.499986 sec, exc=0.499986 sec, total=0.499986 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=22 seq_num=23 snap_id=1 wait times: snap=0.510119 sec, exc=0.510119 sec, total=0.510119 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=21 seq_num=22 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.000009 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=20 seq_num=21 snap_id=1 wait times: snap=0.499993 sec, exc=0.499993 sec, total=0.499993 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=19 seq_num=20 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.000008 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=18 seq_num=19 snap_id=1 wait times: snap=0.510107 sec, exc=0.510107 sec, total=0.510107 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=17 seq_num=18 snap_id=1 wait times: snap=0.499994 sec, exc=0.499994 sec, total=0.499994 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=16 seq_num=17 snap_id=1 wait times: snap=0.510091 sec, exc=0.510091 sec, total=0.510091 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time Sampled Session History of session 201 serial 18631 --------------------------------------------------- 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 --------------------------------------------------- [14 samples, 08:08:48 - 08:09:02] idle wait at each sample [session created at: 08:08:48] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-20 08:09:02.178 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 25 (osid: 18624, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-20 07:56:47.865600 :C22AEAFE:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=20784 pso_num=25 pso_serial#=67 2025-08-20 07:56:47.865738 :C22AEAFF:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=20784 osp_idx=23 osp_ver=246509 osp_pg=0 (spawn #507202) 2025-08-20 07:56:47.865739 :C22AEB00:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 07:56:47.865739 :C22AEB01:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=224 time=62309877 2025-08-20 07:56:47.865739 :C22AEB02:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 07:56:47.865740 :C22AEB03:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 07:56:47.865740 :C22AEB04:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 07:56:47.865740 :C22AEB05:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 07:56:47.865741 :C22AEB06:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 07:56:47.866240 :C22AEB07:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 07:57:17.957126 :C22AF517:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 07:57:47.922830 :C22AFEBC:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 07:57:47.911 2025-08-20 07:57:47.922832 :C22AFEBD:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=10744 pso_num=25 pso_serial#=68 2025-08-20 07:57:47.922967 :C22AFEBE:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=10744 osp_idx=23 osp_ver=246510 osp_pg=0 (spawn #507204) 2025-08-20 07:57:47.922968 :C22AFEBF:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 07:57:47.922968 :C22AFEC0:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=225 time=62369924 2025-08-20 07:57:47.922969 :C22AFEC1:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 07:57:47.922969 :C22AFEC2:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 07:57:47.922970 :C22AFEC3:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 07:57:47.922970 :C22AFEC4:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 07:57:47.922970 :C22AFEC5:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 07:57:47.923450 :C22AFEC6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 07:58:17.961667 :C22B089D:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 07:58:47.972200 :C22B1255:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 07:58:47.961 2025-08-20 07:58:47.972202 :C22B1256:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=19440 pso_num=25 pso_serial#=69 2025-08-20 07:58:47.972382 :C22B1257:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=19440 osp_idx=23 osp_ver=246511 osp_pg=0 (spawn #507206) 2025-08-20 07:58:47.972383 :C22B1258:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 07:58:47.972383 :C22B1259:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=226 time=62429971 2025-08-20 07:58:47.972383 :C22B125A:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 07:58:47.972384 :C22B125B:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 07:58:47.972384 :C22B125C:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 07:58:47.972385 :C22B125D:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 07:58:47.972385 :C22B125E:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 07:58:47.972889 :C22B125F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 07:59:18.072503 :C22B1CD0:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 07:59:48.046487 :C22B269D:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 07:59:48.042 2025-08-20 07:59:48.046489 :C22B269E:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=20908 pso_num=25 pso_serial#=70 2025-08-20 07:59:48.046623 :C22B269F:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=20908 osp_idx=23 osp_ver=246512 osp_pg=0 (spawn #507208) 2025-08-20 07:59:48.046623 :C22B26A0:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 07:59:48.046624 :C22B26A1:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=227 time=62490049 2025-08-20 07:59:48.046624 :C22B26A2:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 07:59:48.046625 :C22B26A3:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 07:59:48.046625 :C22B26A4:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 07:59:48.046626 :C22B26A5:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 07:59:48.046626 :C22B26A6:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 07:59:48.047171 :C22B26A7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:00:18.140790 :C22B304C:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:00:39.748019 :C22B37A3:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:00:39.737 2025-08-20 08:00:39.748021 :C22B37A4:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=16084 pso_num=25 pso_serial#=71 2025-08-20 08:00:39.748147 :C22B37A5:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=16084 osp_idx=23 osp_ver=246513 osp_pg=0 (spawn #507210) 2025-08-20 08:00:39.748148 :C22B37A6:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:00:39.748148 :C22B37A7:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=228 time=62541752 2025-08-20 08:00:39.748149 :C22B37A8:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:00:39.748150 :C22B37A9:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:00:39.748150 :C22B37AA:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:00:39.748150 :C22B37AB:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:00:39.748151 :C22B37AC:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:00:39.748638 :C22B37B1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:00:39.748683 :C22B37B7:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] 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-08-20 08:00:39.753265 :C22B37D1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:39.775587 :C22B37FB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:39.790841 :C22B3803:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:39.823169 :C22B3811:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:39.826887 :C22B3819:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:39.830519 :C22B3821:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:39.834624 :C22B3829:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:39.835681 :C22B3831:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:41.056238 :C22B3889:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:41.100489 :C22B3891:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:41.100816 :C22B3899:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:41.101093 :C22B38A1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:41.101110 :C22B38A4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=18 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:00:41.101173 :C22B38B0:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] 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-08-20 08:00:41.104541 :C22B38BE:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:00:48.133640 :C22B3B7E:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:00:48.123 2025-08-20 08:00:48.133643 :C22B3B7F:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=18492 pso_num=25 pso_serial#=72 2025-08-20 08:00:48.133787 :C22B3B80:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=18492 osp_idx=23 osp_ver=246514 osp_pg=0 (spawn #507214) 2025-08-20 08:00:48.133788 :C22B3B81:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:00:48.133788 :C22B3B82:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=229 time=62550143 2025-08-20 08:00:48.133788 :C22B3B83:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:00:48.133788 :C22B3B84:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:00:48.133789 :C22B3B85:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:00:48.133789 :C22B3B86:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:00:48.133790 :C22B3B87:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:00:48.134278 :C22B3B88:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:01:03.141388 :C22B40EE:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] 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-20 08:01:03.141421*:C22B40F0:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000026BDBB58 estart=1755648062 eid=17014982 ctx=0x000000077BD98A08 cwh=0x0000000026B901B0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-08-20 08:01:03.141421*:C22B40F1:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000026BDBB58 curCtx=0x0000000026B9F708 pubTabIdxCnt=0 2025-08-20 08:01:03.141421*:C22B40F2:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000026BDBB58 2025-08-20 08:01:03.141421*:C22B40F3:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000026BDBB58 2025-08-20 08:01:03.141421*:C22B40F4:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000026BDBB58 curCtx=0x0000000026B9F708 xsc->flg4=65792 flags=2 2025-08-20 08:01:03.141421*:C22B40F5:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000026BDBB58 2025-08-20 08:01:03.142015 :C22B40F6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:01:03.147495 :C22B40FE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:01:03.148473 :C22B4106:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-20 08:01:03.148611 :C22B410F:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] 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-08-20 08:01:33.216438 :C22B4AB5:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:01:48.230453 :C22B4FCD:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:01:48.219 2025-08-20 08:01:48.230455 :C22B4FCE:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=21812 pso_num=25 pso_serial#=73 2025-08-20 08:01:48.230592 :C22B4FCF:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=21812 osp_idx=23 osp_ver=246515 osp_pg=0 (spawn #507216) 2025-08-20 08:01:48.230592 :C22B4FD0:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:01:48.230593 :C22B4FD1:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=230 time=62610237 2025-08-20 08:01:48.230593 :C22B4FD2:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:01:48.230593 :C22B4FD3:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:01:48.230593 :C22B4FD4:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:01:48.230594 :C22B4FD5:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:01:48.230594 :C22B4FD6:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:01:48.231090 :C22B4FD7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:02:18.308907 :C22B5999:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:02:48.316470 :C22B6373:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:02:48.305 2025-08-20 08:02:48.316473 :C22B6374:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=19020 pso_num=25 pso_serial#=74 2025-08-20 08:02:48.316596 :C22B6375:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=19020 osp_idx=23 osp_ver=246516 osp_pg=0 (spawn #507218) 2025-08-20 08:02:48.316598 :C22B6376:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:02:48.316598 :C22B6377:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=231 time=62670315 2025-08-20 08:02:48.316599 :C22B6378:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:02:48.316599 :C22B6379:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:02:48.316599 :C22B637A:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:02:48.316599 :C22B637B:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:02:48.316600 :C22B637C:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:02:48.317072 :C22B637D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:03:18.383733 :C22B6D40:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:03:48.393254 :C22B771D:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:03:48.382 2025-08-20 08:03:48.393256 :C22B771E:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=19820 pso_num=25 pso_serial#=75 2025-08-20 08:03:48.393373 :C22B771F:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=19820 osp_idx=23 osp_ver=246517 osp_pg=0 (spawn #507220) 2025-08-20 08:03:48.393373 :C22B7720:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:03:48.393374 :C22B7721:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=232 time=62730393 2025-08-20 08:03:48.393374 :C22B7722:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:03:48.393374 :C22B7723:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:03:48.393375 :C22B7724:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:03:48.393375 :C22B7725:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:03:48.393375 :C22B7726:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:03:48.393836 :C22B7727:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:04:18.497319 :C22B8163:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:04:48.489152 :C22B8AFB:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:04:48.478 2025-08-20 08:04:48.489154 :C22B8AFC:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=20392 pso_num=25 pso_serial#=76 2025-08-20 08:04:48.489288 :C22B8AFD:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=20392 osp_idx=23 osp_ver=246518 osp_pg=0 (spawn #507223) 2025-08-20 08:04:48.489289 :C22B8AFE:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:04:48.489289 :C22B8AFF:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=233 time=62790487 2025-08-20 08:04:48.489290 :C22B8B00:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:04:48.489290 :C22B8B01:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:04:48.489290 :C22B8B02:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:04:48.489291 :C22B8B03:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:04:48.489291 :C22B8B04:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:04:48.489783 :C22B8B05:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:05:18.557605 :C22B94B9:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:05:48.567545 :C22BA38A:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:05:48.556 2025-08-20 08:05:48.567547 :C22BA38B:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=21912 pso_num=25 pso_serial#=77 2025-08-20 08:05:48.567677 :C22BA38C:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=21912 osp_idx=23 osp_ver=246519 osp_pg=0 (spawn #507225) 2025-08-20 08:05:48.567678 :C22BA38D:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:05:48.567678 :C22BA38E:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=234 time=62850565 2025-08-20 08:05:48.567679 :C22BA38F:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:05:48.567679 :C22BA390:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:05:48.567680 :C22BA391:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:05:48.567680 :C22BA392:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:05:48.567680 :C22BA393:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:05:48.568182 :C22BA394:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:06:18.657018 :C22BAE06:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:06:48.677426 :C22BB7C7:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:06:48.666 2025-08-20 08:06:48.677428 :C22BB7C8:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=21948 pso_num=25 pso_serial#=78 2025-08-20 08:06:48.677565 :C22BB7C9:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=21948 osp_idx=23 osp_ver=246520 osp_pg=0 (spawn #507227) 2025-08-20 08:06:48.677566 :C22BB7CA:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:06:48.677566 :C22BB7CB:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=235 time=62910674 2025-08-20 08:06:48.677566 :C22BB7CC:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:06:48.677567 :C22BB7CD:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:06:48.677567 :C22BB7CE:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:06:48.677567 :C22BB7CF:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:06:48.677568 :C22BB7D0:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:06:48.678043 :C22BB7D1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:07:18.738769 :C22BC19E:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:07:48.757935 :C22BCB44:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:07:48.746 2025-08-20 08:07:48.757937 :C22BCB45:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=21392 pso_num=25 pso_serial#=79 2025-08-20 08:07:48.758063 :C22BCB46:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=21392 osp_idx=23 osp_ver=246521 osp_pg=0 (spawn #507229) 2025-08-20 08:07:48.758064 :C22BCB47:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:07:48.758064 :C22BCB48:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=236 time=62970768 2025-08-20 08:07:48.758065 :C22BCB49:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:07:48.758065 :C22BCB4A:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:07:48.758065 :C22BCB4B:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:07:48.758065 :C22BCB4C:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:07:48.758066 :C22BCB4D:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:07:48.758549 :C22BCB4E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-20 08:08:18.870022 :C22BD4FB:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-20 08:08:48.860092 :C22BE16C:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-20 08:08:48.849 2025-08-20 08:08:48.860095 :C22BE16D:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=18624 pso_num=25 pso_serial#=80 2025-08-20 08:08:48.860225 :C22BE16E:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=18624 osp_idx=23 osp_ver=246522 osp_pg=0 (spawn #507231) 2025-08-20 08:08:48.860226 :C22BE16F:db_trace:kso.c@4099:ksonfy(): [10420:25:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-20 08:08:48.860226 :C22BE170:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=237 time=63030862 2025-08-20 08:08:48.860227 :C22BE171:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-20 08:08:48.860227 :C22BE172:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-20 08:08:48.860228 :C22BE173:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-20 08:08:48.860228 :C22BE174:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-20 08:08:48.860228 :C22BE175:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-20 08:08:48.860716 :C22BE176:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] 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 25 (osid: 18624, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de