Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250623220005\orcl_j002_17232_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250623220005\orcl_j002_17232_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:36335M/63366M, Ph+PgF:42565M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 27 Windows thread id: 17232, image: ORACLE.EXE (J002) *** 2025-06-23 22:00:06.070 *** SESSION ID:(219.1111) 2025-06-23 22:00:06.070 *** 2025-06-23 22:00:06.070 Process diagnostic dump for ORACLE.EXE (J002), OS id=17232, pid: 27, proc_ser: 95, sid: 219, sess_ser: 1111 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 17232 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J002) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.422971 sec, exc=0.422971 sec, total=0.422971 sec wait times: max=0.500000 sec, heur=3.875709 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=6 seq_num=7 snap_id=1 wait times: snap=0.500007 sec, exc=0.500007 sec, total=0.500007 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.510092 sec, exc=0.510092 sec, total=0.510092 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=4 seq_num=5 snap_id=1 wait times: snap=0.499144 sec, exc=0.499144 sec, total=0.499144 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.453942 sec, exc=0.453942 sec, total=0.453942 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000018 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.500020 sec, exc=0.500020 sec, total=0.500020 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=1 seq_num=2 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.000010 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.489469 sec, exc=0.489469 sec, total=0.489469 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 219 serial 1111 --------------------------------------------------- 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 --------------------------------------------------- [4 samples, 22:00:02 - 22:00:06] idle wait at each sample [session created at: 22:00:02] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-06-23 22:00:06.070 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 27 (osid: 17232, J002) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-23 11:30:41.382882 :A8874B78:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=18056 (legacy spawn) 2025-06-23 11:30:41.389268 :A8874B79:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 11:30:41.389442 :A8874B7E:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 11:30:41.390226 :A8874B83:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 11:30:41.398989 :A8874B86:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 11:30:41.384 2025-06-23 11:30:41.398991 :A8874B87:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=18160 pso_num=27 pso_serial#=84 2025-06-23 11:30:41.399128 :A8874B88:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=18160 (legacy spawn) 2025-06-23 11:30:41.405515 :A8874B89:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 11:30:41.405686 :A8874B92:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 11:30:41.406500 :A8874B93:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 11:30:44.516552 :A8874C87:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 11:30:44.503 2025-06-23 11:30:44.516554 :A8874C88:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=18080 pso_num=27 pso_serial#=85 2025-06-23 11:30:44.516730 :A8874C89:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=18080 (legacy spawn) 2025-06-23 11:30:44.538868 :A8874C8A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 11:30:44.539036 :A8874C8F:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 11:30:44.539840 :A8874C94:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 11:30:44.548556 :A8874C97:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 11:30:44.534 2025-06-23 11:30:44.548557 :A8874C98:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=18288 pso_num=27 pso_serial#=86 2025-06-23 11:30:44.548701 :A8874C99:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=18288 (legacy spawn) 2025-06-23 11:30:44.555233 :A8874C9A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 11:30:44.555400 :A8874CA3:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 11:30:44.556201 :A8874CA4:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 15:27:16.955563 :A899D481:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 15:27:16.950 2025-06-23 15:27:16.955564 :A899D482:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=17560 pso_num=27 pso_serial#=87 2025-06-23 15:27:16.955692 :A899D483:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=17560 osp_idx=25 osp_ver=98780 osp_pg=0 (spawn #314935) 2025-06-23 15:27:16.955692 :A899D484:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-23 15:27:16.955693 :A899D485:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=86 time=3668180141 2025-06-23 15:27:16.955693 :A899D486:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-06-23 15:27:16.955693 :A899D487:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-06-23 15:27:16.955694 :A899D488:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-06-23 15:27:16.955694 :A899D489:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-23 15:27:16.955694 :A899D48A:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-23 15:27:16.956188 :A899D48B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-23 15:27:16.956233 :A899D491:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 15:27:16.975690 :A899D4CB:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 16:00:14.308955 :A89C6A06:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 16:00:14.301 2025-06-23 16:00:14.308957 :A89C6A07:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=15708 pso_num=27 pso_serial#=88 2025-06-23 16:00:14.309099 :A89C6A08:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=15708 (legacy spawn) 2025-06-23 16:00:14.315490 :A89C6A09:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:14.315661 :A89C6A12:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 16:00:14.316539 :A89C6A13:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 16:00:14.325306 :A89C6A16:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 16:00:14.316 2025-06-23 16:00:14.325308 :A89C6A17:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=13620 pso_num=27 pso_serial#=89 2025-06-23 16:00:14.325446 :A89C6A18:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=13620 (legacy spawn) 2025-06-23 16:00:14.332055 :A89C6A19:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:14.332214 :A89C6A22:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 16:00:14.333152 :A89C6A23:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 16:00:17.402808 :A89C6B16:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 16:00:17.389 2025-06-23 16:00:17.402810 :A89C6B17:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=18288 pso_num=27 pso_serial#=90 2025-06-23 16:00:17.402943 :A89C6B18:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=18288 (legacy spawn) 2025-06-23 16:00:17.409355 :A89C6B19:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:17.409384 :A89C6B1C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:17.409526 :A89C6B20:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 16:00:17.410303 :A89C6B30:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 16:00:17.428314 :A89C6B33:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 16:00:17.420 2025-06-23 16:00:17.428317 :A89C6B34:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=13744 pso_num=27 pso_serial#=91 2025-06-23 16:00:17.428461 :A89C6B35:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=13744 (legacy spawn) 2025-06-23 16:00:17.434895 :A89C6B36:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:17.435057 :A89C6B3F:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 16:00:17.435833 :A89C6B40:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 16:00:21.538749 :A89C6CCF:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 16:00:21.532 2025-06-23 16:00:21.538751 :A89C6CD0:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=12620 pso_num=27 pso_serial#=92 2025-06-23 16:00:21.538903 :A89C6CD1:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=12620 osp_idx=25 osp_ver=98785 osp_pg=0 (spawn #315011) 2025-06-23 16:00:21.538904 :A89C6CD2:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-23 16:00:21.538904 :A89C6CD3:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=87 time=3670164735 2025-06-23 16:00:21.538905 :A89C6CD4:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-06-23 16:00:21.538906 :A89C6CD5:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-06-23 16:00:21.538906 :A89C6CD6:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-06-23 16:00:21.538906 :A89C6CD7:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-23 16:00:21.538907 :A89C6CD8:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-23 16:00:21.539438 :A89C6CD9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-23 16:00:21.539486 :A89C6CDF:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 16:00:21.543952 :A89C6CF2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:21.569360 :A89C6CFA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:21.584604 :A89C6D02:db_trace:ktu.c@4871:ktuaex1r(): [10442:27:219] Extension usn 6, ext 0, nex 4 2025-06-23 16:00:21.584611 :A89C6D03:db_trace:ktusm.c@2117:ktusmasp(): [10445:27:219] des1:tsn:1 rdba:0x0081499a where: kdiwh22: kdifind 2025-06-23 16:00:21.585034 :A89C6D04:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:21.613799 :A89C6D0C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:21.617446 :A89C6D14:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:21.621032 :A89C6D1C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:21.625266 :A89C6D24:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:21.626417 :A89C6D2C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:22.798638*:A89C6D9A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028CB6FC8 estart=1750665621 eid=16779441 ctx=0x000000077BA4B1C8 cwh=0x0000000028CA05F0 cpu=546875 buffg=0 interb=0 r=0 rb=0 w=0 wb=0 2025-06-23 16:00:22.798638*:A89C6D9B:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028CB6FC8 curCtx=0x0000000028CEF5A0 pubTabIdxCnt=0 2025-06-23 16:00:22.798638*:A89C6D9C:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028CB6FC8 2025-06-23 16:00:22.798638*:A89C6D9D:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028CB6FC8 2025-06-23 16:00:22.798638*:A89C6D9E:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028CFF958 estart=1750665621 eid=16779428 ctx=0x0000000787AD5BF0 cwh=0x0000000028CA07D0 cpu=546875 buffg=0 interb=0 r=0 rb=0 w=0 wb=0 2025-06-23 16:00:22.798638*:A89C6D9F:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028CFF958 curCtx=0x0000000028CF1F08 pubTabIdxCnt=0 2025-06-23 16:00:22.798638*:A89C6DA0:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028CFF958 2025-06-23 16:00:22.798638*:A89C6DA1:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028CFF958 2025-06-23 16:00:22.798638*:A89C6DA2:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028CB6FC8 curCtx=0x0000000028CEF5A0 xsc->flg4=65792 flags=1 2025-06-23 16:00:22.798638*:A89C6DA3:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028CB6FC8 2025-06-23 16:00:22.798638*:A89C6DA4:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028CFF958 curCtx=0x0000000028CF1F08 xsc->flg4=65792 flags=2 2025-06-23 16:00:22.798638*:A89C6DA5:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028CFF958 2025-06-23 16:00:22.872869 :A89C6DA6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:22.907414 :A89C6DAE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:22.907751 :A89C6DB6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:22.908083 :A89C6DBE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:22.908112 :A89C6DC1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=18 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:22.911074 :A89C6DD9:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 16:00:27.282003 :A89C6FBE:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 16:00:27.273 2025-06-23 16:00:27.282005 :A89C6FBF:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=13244 pso_num=27 pso_serial#=93 2025-06-23 16:00:27.282141 :A89C6FC0:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=13244 (legacy spawn) 2025-06-23 16:00:27.288656 :A89C6FC1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 16:00:27.288818 :A89C6FC6:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 16:00:27.289653 :A89C6FCB:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 17:12:30.658607 :A8A21EEE:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 17:12:30.646 2025-06-23 17:12:30.658609 :A8A21EEF:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=16988 pso_num=27 pso_serial#=94 2025-06-23 17:12:30.658746 :A8A21EF0:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=16988 osp_idx=25 osp_ver=98787 osp_pg=0 (spawn #315180) 2025-06-23 17:12:30.658747 :A8A21EF1:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-23 17:12:30.658747 :A8A21EF2:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=88 time=3674493844 2025-06-23 17:12:30.658747 :A8A21EF3:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-06-23 17:12:30.658750 :A8A21EF4:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-06-23 17:12:30.658750 :A8A21EF5:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-06-23 17:12:30.658751 :A8A21EF6:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-23 17:12:30.658751 :A8A21EF7:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-23 17:12:30.659327 :A8A21EF8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-23 17:12:30.659387 :A8A21EFE:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 17:12:30.663532 :A8A21F17:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-06-23 17:12:30.663576 :A8A21F18:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-06-23 17:12:30.663840 :A8A21F19:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-06-23 17:12:30.663857 :A8A21F1A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-06-23 17:12:30.664075 :A8A21F1B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-06-23 17:12:30.664089 :A8A21F1C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-06-23 17:12:30.664305 :A8A21F1D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-06-23 17:12:30.664318 :A8A21F1E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-06-23 17:12:30.664531 :A8A21F1F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-06-23 17:12:30.664544 :A8A21F20:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-06-23 17:12:30.664747 :A8A21F21:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-06-23 17:12:30.664760 :A8A21F22:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-06-23 17:12:30.667184 :A8A21F23:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-06-23 22:00:02.062003 :A8B8BC6B:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 06-23 22:00:02.060 2025-06-23 22:00:02.062005 :A8B8BC6C:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=17232 pso_num=27 pso_serial#=95 2025-06-23 22:00:02.062159 :A8B8BC6D:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=17232 osp_idx=25 osp_ver=98788 osp_pg=0 (spawn #315844) 2025-06-23 22:00:02.062160 :A8B8BC6E:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-23 22:00:02.062161 :A8B8BC6F:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=89 time=3691745235 2025-06-23 22:00:02.062161 :A8B8BC70:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-06-23 22:00:02.062162 :A8B8BC71:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-06-23 22:00:02.062162 :A8B8BC72:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-06-23 22:00:02.062163 :A8B8BC73:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-23 22:00:02.062163 :A8B8BC74:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-23 22:00:02.062761 :A8B8BC7E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.067965 :A8B8BC9B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.068006 :A8B8BC9E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:jslv.c:9203 2025-06-23 22:00:02.081896 :A8B8BD38:KFNU:kfn.c@2200:kfnPrepareASM(): kfnPrepareASM force=0 state_kfnsg=0x7 2025-06-23 22:00:02.082484 :A8B8BD39:db_trace:kcc.c@13684:kccwbp(): [10021:27:219:1] 0115000000000000 0115000000000000 bc19120000000000 2025-06-23 22:00:02.084244 :A8B8BD4B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=15 loc='ksr2.h LINE:603 ID:ksrpublish' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.084307 :A8B8BD59:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=15 loc='ksr2.h LINE:607 ID:ksrmdone' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-23 22:00:02.084315 :A8B8BD5F:db_trace:ksb.c@6610:ksbcic_int(): [10254:27:219] KSBCIC: (USER) starting cic on opcode KSBCIRCO [1] with args (1 8397264 1) 2025-06-23 22:00:02.084320 :A8B8BD60:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.084347 :A8B8BD6D:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-23 22:00:02.085051 :A8B8BD78:db_trace:ksb.c@6610:ksbcic_int(): [10254:27:219] KSBCIC: (USER) starting cic on opcode KSBCICKP [2] with args (4 0 229285305) 2025-06-23 22:00:02.085055 :A8B8BD79:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.085080 :A8B8BD84:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-23 22:00:02.085088 :A8B8BD91:db_trace:ksb.c@6610:ksbcic_int(): [10254:27:219] KSBCIC: (USER) starting cic on opcode KSBCICKP [2] with args (6 65563 1) 2025-06-23 22:00:02.085091 :A8B8BD92:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.085119 :A8B8BD9E:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-23 22:00:02.085122 :A8B8BDAA:db_trace:ksb.c@6610:ksbcic_int(): [10254:27:219] KSBCIC: (USER) starting cic on opcode KSBCICKP [2] with args (1 2 65563) 2025-06-23 22:00:02.085126 :A8B8BDAB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.085200 :A8B8BDCC:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-23 22:00:02.085815 :A8B8BE8E:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=15 loc='ksq.h LINE:1877 ID:ksqrcl' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-23 22:00:02.085838 :A8B8BE95:KFNU:kfn.c@2200:kfnPrepareASM(): kfnPrepareASM force=0 state_kfnsg=0x7 2025-06-23 22:00:02.086797 :A8B8BE9A:db_trace:kcc.c@13684:kccwbp(): [10021:27:219:1] 0115000000000000 0115000000000000 bd19120000000000 2025-06-23 22:00:02.087269 :A8B8BE9B:db_trace:ksb.c@6610:ksbcic_int(): [10254:27:219] KSBCIC: (USER) starting cic on opcode KSBCIBBS [20] with args (2 0 229285305) 2025-06-23 22:00:02.087276 :A8B8BE9C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=15 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.087308 :A8B8BEA6:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=15 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-23 22:00:02.095934 :A8B8BF54:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:jslv.c:9203 2025-06-23 22:00:02.097722 :A8B8BF85:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.097779 :A8B8BF88:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.186070 :A8B8BFAA:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-23 22:00:02.188466 :A8B8BFAD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.188517 :A8B8BFB0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:jslv.c:9203 2025-06-23 22:00:02.191181 :A8B8BFB6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:jslv.c:9203 2025-06-23 22:00:02.194546 :A8B8BFB7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.194635 :A8B8BFBA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-06-23 22:00:02.194734 :A8B8BFC7:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-06-23 22:00:04.139003 :A8B8C3D8:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 27 (osid: 17232, J002)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de