Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250810100827\orcl_j001_20404_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250810100827\orcl_j001_20404_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:35606M/63366M, Ph+PgF:41084M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 20404, image: ORACLE.EXE (J001) *** 2025-08-10 10:08:27.230 *** SESSION ID:(193.54557) 2025-08-10 10:08:27.230 *** 2025-08-10 10:08:27.230 Process diagnostic dump for ORACLE.EXE (J001), OS id=20404, pid: 24, proc_ser: 112, sid: 193, sess_ser: 54557 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 20404 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.448865 sec, exc=0.448865 sec, total=0.448865 sec wait times: max=0.500000 sec, heur=2.448170 sec wait counts: calls=1 os=1 in_wait=1 iflags=0x5a8 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000009 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 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 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.499987 sec, exc=0.499987 sec, total=0.499987 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.500005 sec, exc=0.500005 sec, total=0.500005 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.499279 sec, exc=0.499279 sec, total=0.499279 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000000 sec of elapsed time Sampled Session History of session 193 serial 54557 --------------------------------------------------- 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, 10:08:24 - 10:08:27] idle wait at each sample [session created at: 10:08:24] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-10 10:08:27.230 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 20404, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-10 09:59:09.317392 :BDD079D6:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 09:59:09.317392 :BDD079D7:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 09:59:09.317944 :BDD079D8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 09:59:24.328580 :BDD07EDF:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-10 09:59:24.328612*:BDD07EE0:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000026B5BB58 estart=1754791163 eid=16999246 ctx=0x000000077BD98A08 cwh=0x0000000024D801B0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-08-10 09:59:24.328612*:BDD07EE1:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000026B5BB58 curCtx=0x0000000024D8F708 pubTabIdxCnt=0 2025-08-10 09:59:24.328612*:BDD07EE2:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000026B5BB58 2025-08-10 09:59:24.328612*:BDD07EE3:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000026B5BB58 2025-08-10 09:59:24.328612*:BDD07EE4:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000026B5BB58 curCtx=0x0000000024D8F708 xsc->flg4=65792 flags=2 2025-08-10 09:59:24.328612*:BDD07EE5:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000026B5BB58 2025-08-10 09:59:24.329402 :BDD07EE6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 09:59:24.334819 :BDD07EEE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 09:59:24.335860 :BDD07EF6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 09:59:24.335994 :BDD07EFF:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-10 09:59:54.389761 :BDD08872:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:00:09.419425 :BDD08D58:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:00:09.408 2025-08-10 10:00:09.419427 :BDD08D59:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=13804 pso_num=24 pso_serial#=103 2025-08-10 10:00:09.419557 :BDD08D5A:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=13804 osp_idx=22 osp_ver=703913 osp_pg=0 (spawn #474165) 2025-08-10 10:00:09.419558 :BDD08D5B:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:00:09.419559 :BDD08D5C:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=142 time=3500678720 2025-08-10 10:00:09.419559 :BDD08D5D:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:00:09.419559 :BDD08D5E:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:00:09.419560 :BDD08D5F:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:00:09.419560 :BDD08D60:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:00:09.419560 :BDD08D61:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:00:09.420047 :BDD08D62:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:00:39.504137 :BDD0978D:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:00:59.486809 :BDD09E78:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:00:59.482 2025-08-10 10:00:59.486811 :BDD09E79:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=10304 pso_num=24 pso_serial#=104 2025-08-10 10:00:59.486956 :BDD09E7A:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=10304 osp_idx=22 osp_ver=703914 osp_pg=0 (spawn #474167) 2025-08-10 10:00:59.486957 :BDD09E7B:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:00:59.486957 :BDD09E7C:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=143 time=3500728783 2025-08-10 10:00:59.486957 :BDD09E7D:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:00:59.486958 :BDD09E7E:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:00:59.486958 :BDD09E7F:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:00:59.486959 :BDD09E80:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:00:59.486959 :BDD09E81:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:00:59.487487 :BDD09E82:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.487533 :BDD09E88:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-10 10:00:59.495771 :BDD09E96:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.496945 :BDD09E9E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.497526 :BDD09EA6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.497978 :BDD09EAE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.498430 :BDD09EB6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.501054 :BDD09EBE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.502175 :BDD09EC6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.553277 :BDD09ECE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.554167 :BDD09ED6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.554393 :BDD09EDE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.554607 :BDD09EE6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:00:59.556532 :BDD09EEE:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:01:09.512761 :BDD0A22B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:01:09.501 2025-08-10 10:01:09.512763 :BDD0A22C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20644 pso_num=24 pso_serial#=105 2025-08-10 10:01:09.512903 :BDD0A22D:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=20644 osp_idx=22 osp_ver=703915 osp_pg=0 (spawn #474169) 2025-08-10 10:01:09.512904 :BDD0A22E:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:01:09.512904 :BDD0A22F:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=144 time=3500738814 2025-08-10 10:01:09.512904 :BDD0A230:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:01:09.512905 :BDD0A231:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:01:09.512905 :BDD0A232:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:01:09.512907 :BDD0A233:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:01:09.512908 :BDD0A234:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:01:09.513396 :BDD0A235:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:01:39.603909 :BDD0AC7B:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:02:09.586482 :BDD0B601:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:02:09.575 2025-08-10 10:02:09.586484 :BDD0B602:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21184 pso_num=24 pso_serial#=106 2025-08-10 10:02:09.586608 :BDD0B603:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=21184 osp_idx=22 osp_ver=703916 osp_pg=0 (spawn #474171) 2025-08-10 10:02:09.586608 :BDD0B604:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:02:09.586609 :BDD0B605:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=145 time=3500798892 2025-08-10 10:02:09.586609 :BDD0B606:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:02:09.586610 :BDD0B607:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:02:09.586610 :BDD0B608:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:02:09.586610 :BDD0B609:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:02:09.586611 :BDD0B60A:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:02:09.587073 :BDD0B60B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:02:39.649699 :BDD0BF80:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:03:09.659068 :BDD0C905:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:03:09.648 2025-08-10 10:03:09.659070 :BDD0C906:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16572 pso_num=24 pso_serial#=107 2025-08-10 10:03:09.659207 :BDD0C907:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=16572 osp_idx=22 osp_ver=703917 osp_pg=0 (spawn #474173) 2025-08-10 10:03:09.659209 :BDD0C908:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:03:09.659209 :BDD0C909:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=146 time=3500858954 2025-08-10 10:03:09.659210 :BDD0C90A:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:03:09.659210 :BDD0C90B:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:03:09.659210 :BDD0C90C:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:03:09.659211 :BDD0C90D:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:03:09.659211 :BDD0C90E:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:03:09.659704 :BDD0C90F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:03:39.726261 :BDD0D2A6:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:04:09.758002 :BDD0DC78:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:04:09.747 2025-08-10 10:04:09.758004 :BDD0DC79:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19700 pso_num=24 pso_serial#=108 2025-08-10 10:04:09.758182 :BDD0DC7A:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19700 osp_idx=22 osp_ver=703918 osp_pg=0 (spawn #474177) 2025-08-10 10:04:09.758183 :BDD0DC7B:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:04:09.758183 :BDD0DC7C:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=147 time=3500919064 2025-08-10 10:04:09.758184 :BDD0DC7D:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:04:09.758184 :BDD0DC7E:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:04:09.758185 :BDD0DC7F:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:04:09.758185 :BDD0DC80:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:04:09.758186 :BDD0DC81:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:04:09.758702 :BDD0DC82:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:04:39.844629 :BDD0E60E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:05:09.885336 :BDD0EF94:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:05:09.874 2025-08-10 10:05:09.885338 :BDD0EF95:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20932 pso_num=24 pso_serial#=109 2025-08-10 10:05:09.885472 :BDD0EF96:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=20932 osp_idx=22 osp_ver=703919 osp_pg=0 (spawn #474179) 2025-08-10 10:05:09.885472 :BDD0EF97:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:05:09.885473 :BDD0EF98:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=148 time=3500979189 2025-08-10 10:05:09.885473 :BDD0EF99:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:05:09.885473 :BDD0EF9A:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:05:09.885473 :BDD0EF9B:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:05:09.885474 :BDD0EF9C:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:05:09.885474 :BDD0EF9D:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:05:09.885939 :BDD0EF9E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:05:39.956542 :BDD0FA19:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:06:09.960124 :BDD108ED:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:06:09.949 2025-08-10 10:06:09.960126 :BDD108EE:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21384 pso_num=24 pso_serial#=110 2025-08-10 10:06:09.960263 :BDD108EF:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=21384 osp_idx=22 osp_ver=703920 osp_pg=0 (spawn #474181) 2025-08-10 10:06:09.960263 :BDD108F0:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:06:09.960264 :BDD108F1:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=149 time=3501039267 2025-08-10 10:06:09.960264 :BDD108F2:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:06:09.960264 :BDD108F3:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:06:09.960265 :BDD108F4:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:06:09.960265 :BDD108F5:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:06:09.960266 :BDD108F6:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:06:09.960791 :BDD108F7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:06:40.015258 :BDD11362:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:07:10.008706 :BDD11D2E:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:07:09.997 2025-08-10 10:07:10.008708 :BDD11D2F:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19212 pso_num=24 pso_serial#=111 2025-08-10 10:07:10.008843 :BDD11D30:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19212 osp_idx=22 osp_ver=703921 osp_pg=0 (spawn #474183) 2025-08-10 10:07:10.008844 :BDD11D31:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:07:10.008844 :BDD11D32:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=150 time=3501099314 2025-08-10 10:07:10.008845 :BDD11D33:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:07:10.008845 :BDD11D34:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:07:10.008845 :BDD11D35:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:07:10.008845 :BDD11D36:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:07:10.008846 :BDD11D37:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:07:10.009377 :BDD11D38:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:07:40.082188 :BDD126E2:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-10 10:08:10.076976 :BDD13068:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-10 10:08:10.065 2025-08-10 10:08:10.076978 :BDD13069:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20404 pso_num=24 pso_serial#=112 2025-08-10 10:08:10.077102 :BDD1306A:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=20404 osp_idx=22 osp_ver=703922 osp_pg=0 (spawn #474185) 2025-08-10 10:08:10.077103 :BDD1306B:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-10 10:08:10.077103 :BDD1306C:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=151 time=3501159376 2025-08-10 10:08:10.077103 :BDD1306D:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-10 10:08:10.077104 :BDD1306E:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-10 10:08:10.077104 :BDD1306F:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-10 10:08:10.077105 :BDD13070:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-10 10:08:10.077105 :BDD13071:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-10 10:08:10.077642 :BDD13072:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-10 10:08:23.078494 :BDD1360A:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-10 10:08:23.183892 :BDD1394A:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-10 10:08:23.183892*:BDD13959:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000026B6C718 estart=1754791703 eid=16785818 ctx=0x000000077FD6A000 cwh=0x0000000026B60068 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-08-10 10:08:23.183892*:BDD1395A:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000026B6C718 curCtx=0x0000000026B68938 pubTabIdxCnt=0 2025-08-10 10:08:23.183892*:BDD1395B:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000026B6C718 2025-08-10 10:08:23.183892*:BDD1395C:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000026B6C718 2025-08-10 10:08:23.183892*:BDD1395D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000026B6C718 curCtx=0x0000000026B68938 xsc->flg4=65792 flags=2 2025-08-10 10:08:23.183892*:BDD1395E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000026B6C718 2025-08-10 10:08:23.189404 :BDD13969:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:23.189449 :BDD1396C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:jslv.c:9203 2025-08-10 10:08:23.194859 :BDD1397C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:23.321618 :BDD13984:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:23.455708 :BDD1398C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:23.585221 :BDD13994:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.711692 :BDD139B2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.712673 :BDD139BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.731102 :BDD139C2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.731692 :BDD139CA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.732210 :BDD139D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.732703 :BDD139DA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.735401 :BDD139E2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.736299 :BDD139EA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 10:08:24.737118 :BDD139EB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 10:08:24.737877 :BDD139EC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 10:08:24.738284 :BDD139ED:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 10:08:24.738290 :BDD139EE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 10:08:24.738849 :BDD139EF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 10:08:24.739329 :BDD139F0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 10:08:24.739602 :BDD139F1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 10:08:24.740569 :BDD139F2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-10 10:08:24.773116 :BDD139F3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.773165 :BDD139F6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-10 10:08:24.774159 :BDD139FC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.774635 :BDD13A06:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.774957 :BDD13A0E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.775144 :BDD13A16:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.775289 :BDD13A1E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.775451 :BDD13A26:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:jslv.c:9203 2025-08-10 10:08:24.779497 :BDD13A27:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.779588 :BDD13A2A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-08-10 10:08:24.779688 :BDD13A37:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 24 (osid: 20404, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de