Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250803060008\orcl_j001_20212_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250803060008\orcl_j001_20212_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:35795M/63366M, Ph+PgF:41424M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 25 Windows thread id: 20212, image: ORACLE.EXE (J001) *** 2025-08-03 06:00:08.758 *** SESSION ID:(201.39805) 2025-08-03 06:00:08.758 *** 2025-08-03 06:00:08.758 Process diagnostic dump for ORACLE.EXE (J001), OS id=20212, pid: 25, proc_ser: 22, sid: 201, sess_ser: 39805 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 20212 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) 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.381850 sec, exc=0.381850 sec, total=0.381850 sec wait times: max=0.500000 sec, heur=8.387312 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.000007 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.499981 sec, exc=0.499981 sec, total=0.499981 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000017 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.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.000015 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.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.000013 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.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 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=11 seq_num=12 snap_id=1 wait times: snap=0.504581 sec, exc=0.504581 sec, total=0.504581 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 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.499967 sec, exc=0.499967 sec, total=0.499967 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000017 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.500022 sec, exc=0.500022 sec, total=0.500022 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 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.500006 sec, exc=0.500006 sec, total=0.500006 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.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.000012 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.500001 sec, exc=0.500001 sec, total=0.500001 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 sec of elapsed time Sampled Session History of session 201 serial 39805 --------------------------------------------------- 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, 06:00:00 - 06:00:08] idle wait at each sample [session created at: 06:00:00] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-03 06:00:08.758 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 25 (osid: 20212, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-03 05:49:04.347004 :BAA50FC3:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:49:34.369869 :BAA519E4:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:49:34.358 2025-08-03 05:49:34.369871 :BAA519E5:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=20316 pso_num=25 pso_serial#=12 2025-08-03 05:49:34.370024 :BAA519E6:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=20316 osp_idx=23 osp_ver=225799 osp_pg=0 (spawn #450232) 2025-08-03 05:49:34.370025 :BAA519E7: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-03 05:49:34.370025 :BAA519E8:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=150 time=2880843673 2025-08-03 05:49:34.370026 :BAA519E9:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:49:34.370026 :BAA519EA:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:49:34.370027 :BAA519EB:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:49:34.370027 :BAA519EC:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:49:34.370027 :BAA519ED:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:49:34.370570 :BAA519EE: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-03 05:50:04.454850 :BAA52441:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:50:34.437411 :BAA52E19:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:50:34.426 2025-08-03 05:50:34.437414 :BAA52E1A:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=18512 pso_num=25 pso_serial#=13 2025-08-03 05:50:34.437547 :BAA52E1B:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=18512 osp_idx=23 osp_ver=225800 osp_pg=0 (spawn #450234) 2025-08-03 05:50:34.437548 :BAA52E1C: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-03 05:50:34.437549 :BAA52E1D:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=151 time=2880903736 2025-08-03 05:50:34.437550 :BAA52E1E:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:50:34.437551 :BAA52E1F:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:50:34.437551 :BAA52E20:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:50:34.437551 :BAA52E21:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:50:34.437551 :BAA52E22:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:50:34.438111 :BAA52E23: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-03 05:51:04.522432 :BAA537FE:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:51:34.525564 :BAA541F9:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:51:34.514 2025-08-03 05:51:34.525566 :BAA541FA:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=16476 pso_num=25 pso_serial#=14 2025-08-03 05:51:34.525702 :BAA541FB:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=16476 osp_idx=23 osp_ver=225801 osp_pg=0 (spawn #450236) 2025-08-03 05:51:34.525703 :BAA541FC: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-03 05:51:34.525703 :BAA541FD:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=152 time=2880963829 2025-08-03 05:51:34.525704 :BAA541FE:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:51:34.525704 :BAA541FF:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:51:34.525704 :BAA54200:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:51:34.525704 :BAA54201:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:51:34.525705 :BAA54202:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:51:34.526182 :BAA54203: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-03 05:52:04.578815 :BAA54C43:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:52:34.590645 :BAA55637:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:52:34.579 2025-08-03 05:52:34.590647 :BAA55638:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=18232 pso_num=25 pso_serial#=15 2025-08-03 05:52:34.590785 :BAA55639:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=18232 osp_idx=23 osp_ver=225802 osp_pg=0 (spawn #450238) 2025-08-03 05:52:34.590785 :BAA5563A: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-03 05:52:34.590786 :BAA5563B:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=153 time=2881023892 2025-08-03 05:52:34.590787 :BAA5563C:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:52:34.590787 :BAA5563D:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:52:34.590787 :BAA5563E:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:52:34.590788 :BAA5563F:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:52:34.590788 :BAA55640:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:52:34.591280 :BAA55641: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-03 05:53:04.671786 :BAA56035:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:53:34.686688 :BAA56A40:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:53:34.675 2025-08-03 05:53:34.686691 :BAA56A41:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=19784 pso_num=25 pso_serial#=16 2025-08-03 05:53:34.686820 :BAA56A42:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=19784 osp_idx=23 osp_ver=225803 osp_pg=0 (spawn #450240) 2025-08-03 05:53:34.686821 :BAA56A43: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-03 05:53:34.686822 :BAA56A44:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=154 time=2881083986 2025-08-03 05:53:34.686822 :BAA56A45:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:53:34.686822 :BAA56A46:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:53:34.686823 :BAA56A47:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:53:34.686823 :BAA56A48:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:53:34.686824 :BAA56A49:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:53:34.687361 :BAA56A4A: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-03 05:54:04.799941 :BAA5742F:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:54:34.811534 :BAA57E54:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:54:34.800 2025-08-03 05:54:34.811536 :BAA57E55:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=18948 pso_num=25 pso_serial#=17 2025-08-03 05:54:34.811648 :BAA57E56:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=18948 osp_idx=23 osp_ver=225804 osp_pg=0 (spawn #450242) 2025-08-03 05:54:34.811649 :BAA57E57: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-03 05:54:34.811649 :BAA57E58:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=155 time=2881144111 2025-08-03 05:54:34.811650 :BAA57E59:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:54:34.811650 :BAA57E5A:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:54:34.811650 :BAA57E5B:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:54:34.811650 :BAA57E5C:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:54:34.811651 :BAA57E5D:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:54:34.812132 :BAA57E5E: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-03 05:54:49.813633 :BAA58380: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-03 05:54:49.813663*:BAA58381:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000026BDBB58 estart=1754171688 eid=16987870 ctx=0x000000077BD98A08 cwh=0x0000000026B901B0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-08-03 05:54:49.813663*:BAA58382:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000026BDBB58 curCtx=0x0000000026B9F708 pubTabIdxCnt=0 2025-08-03 05:54:49.813663*:BAA58383:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000026BDBB58 2025-08-03 05:54:49.813663*:BAA58384:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000026BDBB58 2025-08-03 05:54:49.813663*:BAA58385:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000026BDBB58 curCtx=0x0000000026B9F708 xsc->flg4=65792 flags=2 2025-08-03 05:54:49.813663*:BAA58386:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000026BDBB58 2025-08-03 05:54:49.814288 :BAA58387: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-03 05:54:49.819794 :BAA5838F: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-03 05:54:49.820808 :BAA58397: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-03 05:54:49.820948 :BAA583A0: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-03 05:55:19.915278 :BAA58D8B:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:55:34.896225 :BAA59268:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:55:34.884 2025-08-03 05:55:34.896227 :BAA59269:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=19872 pso_num=25 pso_serial#=18 2025-08-03 05:55:34.896341 :BAA5926A:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=19872 osp_idx=23 osp_ver=225805 osp_pg=0 (spawn #450244) 2025-08-03 05:55:34.896342 :BAA5926B: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-03 05:55:34.896342 :BAA5926C:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=156 time=2881204189 2025-08-03 05:55:34.896343 :BAA5926D:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:55:34.896343 :BAA5926E:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:55:34.896343 :BAA5926F:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:55:34.896344 :BAA59270:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:55:34.896344 :BAA59271:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:55:34.896832 :BAA59272: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-03 05:56:04.981767 :BAA59C6C:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:56:34.981156 :BAA5A661:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:56:34.970 2025-08-03 05:56:34.981158 :BAA5A662:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=19904 pso_num=25 pso_serial#=19 2025-08-03 05:56:34.981276 :BAA5A663:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=19904 osp_idx=23 osp_ver=225806 osp_pg=0 (spawn #450246) 2025-08-03 05:56:34.981277 :BAA5A664: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-03 05:56:34.981277 :BAA5A665:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=157 time=2881264283 2025-08-03 05:56:34.981278 :BAA5A666:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:56:34.981278 :BAA5A667:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:56:34.981278 :BAA5A668:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:56:34.981279 :BAA5A669:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:56:34.981279 :BAA5A66A:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:56:34.981780 :BAA5A66B: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-03 05:57:05.068760 :BAA5B143:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:57:35.073082 :BAA5BB39:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:57:35.061 2025-08-03 05:57:35.073084 :BAA5BB3A:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=19396 pso_num=25 pso_serial#=20 2025-08-03 05:57:35.073199 :BAA5BB3B:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=19396 osp_idx=23 osp_ver=225807 osp_pg=0 (spawn #450248) 2025-08-03 05:57:35.073199 :BAA5BB3C: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-03 05:57:35.073200 :BAA5BB3D:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=158 time=2881324376 2025-08-03 05:57:35.073200 :BAA5BB3E:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:57:35.073200 :BAA5BB3F:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:57:35.073201 :BAA5BB40:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:57:35.073201 :BAA5BB41:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:57:35.073201 :BAA5BB42:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:57:35.073707 :BAA5BB43: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-03 05:58:05.179535 :BAA5C522:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:58:35.117218 :BAA5CEF8:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:58:35.105 2025-08-03 05:58:35.117220 :BAA5CEF9:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=20464 pso_num=25 pso_serial#=21 2025-08-03 05:58:35.117344 :BAA5CEFA:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=20464 osp_idx=23 osp_ver=225808 osp_pg=0 (spawn #450251) 2025-08-03 05:58:35.117345 :BAA5CEFB: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-03 05:58:35.117346 :BAA5CEFC:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=159 time=2881384423 2025-08-03 05:58:35.117346 :BAA5CEFD:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:58:35.117346 :BAA5CEFE:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:58:35.117347 :BAA5CEFF:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:58:35.117347 :BAA5CF00:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:58:35.117347 :BAA5CF01:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:58:35.117857 :BAA5CF02: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-03 05:59:05.198775 :BAA5D8D9:db_trace:kst.c@698:kstpsodel(): [10280:25:0] kst: process state object about to be deleted 2025-08-03 05:59:35.199800 :BAA5E2FA:db_trace:kst.c@673:kstipg(): [10280:25:0] kst: process state object created on 08-03 05:59:35.188 2025-08-03 05:59:35.199802 :BAA5E2FB:db_trace:kst.c@679:kstipg(): [10280:25:0] kst: process info: ospid=20212 pso_num=25 pso_serial#=22 2025-08-03 05:59:35.199921 :BAA5E2FC:db_trace:kso.c@4093:ksonfy(): [10420:25:0] kso: new process: pid=20212 osp_idx=23 osp_ver=225809 osp_pg=0 (spawn #450253) 2025-08-03 05:59:35.199922 :BAA5E2FD: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-03 05:59:35.199923 :BAA5E2FE:db_trace:kso.c@4103:ksonfy(): [10420:25:0] kso: new process: pso_index=25 reservation=160 time=2881444501 2025-08-03 05:59:35.199923 :BAA5E2FF:db_trace:kso.c@4109:ksonfy(): [10420:25:0] kso: spawn diagnostics: queue time=0 secs 2025-08-03 05:59:35.199924 :BAA5E300:db_trace:kso.c@4111:ksonfy(): [10420:25:0] kso: spawn diagnostics: fork time=0 secs 2025-08-03 05:59:35.199924 :BAA5E301:db_trace:kso.c@4113:ksonfy(): [10420:25:0] kso: spawn diagnostics: exec time=0 secs 2025-08-03 05:59:35.199924 :BAA5E302:db_trace:kso.c@4115:ksonfy(): [10420:25:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-03 05:59:35.199925 :BAA5E303:db_trace:kso.c@4117:ksonfy(): [10420:25:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-03 05:59:35.200459 :BAA5E304: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-03 06:00:00.243702 :BAA5ED17: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-03 06:00:00.243702*:BAA5ED25:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000026BEB898 estart=1754171999 eid=16785373 ctx=0x000000077FD6A000 cwh=0x0000000026BE0068 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-08-03 06:00:00.243702*:BAA5ED26:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000026BEB898 curCtx=0x0000000026BE7AB8 pubTabIdxCnt=0 2025-08-03 06:00:00.243702*:BAA5ED27:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000026BEB898 2025-08-03 06:00:00.243702*:BAA5ED28:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000026BEB898 2025-08-03 06:00:00.243702*:BAA5ED29:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000026BEB898 curCtx=0x0000000026BE7AB8 xsc->flg4=65792 flags=2 2025-08-03 06:00:00.243702*:BAA5ED2A:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000026BEB898 2025-08-03 06:00:00.249297 :BAA5ED35: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-03 06:00:00.249342 :BAA5ED38:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:25:201] atxpus:jslv.c:9203 2025-08-03 06:00:00.254552 :BAA5ED62:KFNU:kfn.c@2200:kfnPrepareASM(): kfnPrepareASM force=0 state_kfnsg=0x7 2025-08-03 06:00:00.255136 :BAA5ED63:db_trace:kcc.c@13684:kccwbp(): [10021:25:201:1] 0115000000000000 0115000000000000 176a120000000000 2025-08-03 06:00:00.257000 :BAA5ED8C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=15 loc='ksr2.h LINE:603 ID:ksrpublish' id1=0 id2=0 name= type=0 2025-08-03 06:00:00.257094 :BAA5ED9A:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] KSL POST RCVD poster=15 loc='ksr2.h LINE:607 ID:ksrmdone' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-03 06:00:00.257103 :BAA5EDA0:db_trace:ksb.c@6610:ksbcic_int(): [10254:25:201] KSBCIC: (USER) starting cic on opcode KSBCIRCO [1] with args (1 8397264 1) 2025-08-03 06:00:00.257108 :BAA5EDA1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-03 06:00:00.257138 :BAA5EDAE:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-03 06:00:00.257941 :BAA5EDB9:db_trace:ksb.c@6610:ksbcic_int(): [10254:25:201] KSBCIC: (USER) starting cic on opcode KSBCICKP [2] with args (4 0 233286434) 2025-08-03 06:00:00.257945 :BAA5EDBA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-03 06:00:00.257966 :BAA5EDC6:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-03 06:00:00.257974 :BAA5EDD2:db_trace:ksb.c@6610:ksbcic_int(): [10254:25:201] KSBCIC: (USER) starting cic on opcode KSBCICKP [2] with args (6 65561 1) 2025-08-03 06:00:00.257978 :BAA5EDD3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-03 06:00:00.258007 :BAA5EDDF:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-03 06:00:00.258010 :BAA5EDE5:db_trace:ksb.c@6610:ksbcic_int(): [10254:25:201] KSBCIC: (USER) starting cic on opcode KSBCICKP [2] with args (1 2 65561) 2025-08-03 06:00:00.258013 :BAA5EDEA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-03 06:00:00.258051 :BAA5EE0E:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-03 06:00:00.258773 :BAA5EECC:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] KSL POST RCVD poster=15 loc='ksq.h LINE:1877 ID:ksqrcl' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-03 06:00:00.258787 :BAA5EECD:KFNU:kfn.c@2200:kfnPrepareASM(): kfnPrepareASM force=0 state_kfnsg=0x7 2025-08-03 06:00:00.259602 :BAA5EED4:db_trace:kcc.c@13684:kccwbp(): [10021:25:201:1] 0115000000000000 0115000000000000 186a120000000000 2025-08-03 06:00:00.259999 :BAA5EED5:db_trace:ksb.c@6610:ksbcic_int(): [10254:25:201] KSBCIC: (USER) starting cic on opcode KSBCIBBS [20] with args (2 0 233286434) 2025-08-03 06:00:00.260007 :BAA5EED6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-03 06:00:00.260041 :BAA5EEE1:db_trace:ksl2.c@12699:ksliwat(): [10005:25:201] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-03 06:00:00.268707 :BAA5EF4B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:25:201] atxpop:jslv.c:9203 2025-08-03 06:00:00.270471 :BAA5EF54: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-03 06:00:00.270517 :BAA5EF57:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-08-03 06:00:00.270586 :BAA5EF64: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-03 06:00:00.368387 :BAA5F083: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-03 06:00:00.370399 :BAA5F084: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-03 06:00:00.370434 :BAA5F087:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:25:201] atxpus:jslv.c:9203 2025-08-03 06:00:00.372918 :BAA5F08D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:25:201] atxpop:jslv.c:9203 2025-08-03 06:00:00.376129 :BAA5F08E: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-03 06:00:00.376203 :BAA5F091:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:25:201] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-08-03 06:00:00.376292 :BAA5F09E: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 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 25 (osid: 20212, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de