Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250707220007\orcl_j001_9276_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250707220007\orcl_j001_9276_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:36640M/63366M, Ph+PgF:42679M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 9276, image: ORACLE.EXE (J001) *** 2025-07-07 22:00:07.244 *** SESSION ID:(209.42233) 2025-07-07 22:00:07.244 *** 2025-07-07 22:00:07.244 Process diagnostic dump for ORACLE.EXE (J001), OS id=9276, pid: 26, proc_ser: 185, sid: 209, sess_ser: 42233 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 9276 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 snap_id=1 wait times: snap=0.248293 sec, exc=0.248293 sec, total=0.248293 sec wait times: max=0.500000 sec, heur=4.049259 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.000013 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.499997 sec, exc=0.499997 sec, total=0.499997 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000006 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 snap_id=1 wait times: snap=0.499999 sec, exc=0.499999 sec, total=0.499999 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.502090 sec, exc=0.502090 sec, total=0.502090 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 snap_id=1 wait times: snap=0.500004 sec, exc=0.500004 sec, total=0.500004 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000006 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.499996 sec, exc=0.499996 sec, total=0.499996 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.499145 sec, exc=0.499145 sec, total=0.499145 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000005 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.313351 sec, exc=0.313351 sec, total=0.313351 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.486316 sec, exc=0.486316 sec, total=0.486316 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 209 serial 42233 --------------------------------------------------- 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 --------------------------------------------------- [5 samples, 22:00:03 - 22:00:07] idle wait at each sample [session created at: 22:00:03] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-07 22:00:07.244 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 9276, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-07 21:57:43.726148 :AEEF31B8:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:57:50.498154 :AEEF33BB:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:57:50.484 2025-07-07 21:57:50.498155 :AEEF33BC:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=8400 pso_num=26 pso_serial#=169 2025-07-07 21:57:50.498294 :AEEF33BD:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=8400 (legacy spawn) 2025-07-07 21:57:50.504786 :AEEF33BE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:57:50.504960 :AEEF33C3:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:57:50.505748 :AEEF33C8:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:57:50.514390 :AEEF33CB:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:57:50.499 2025-07-07 21:57:50.514393 :AEEF33CC:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11328 pso_num=26 pso_serial#=170 2025-07-07 21:57:50.514554 :AEEF33D5:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=11328 (legacy spawn) 2025-07-07 21:57:50.521025 :AEEF33DB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:57:50.521187 :AEEF33E4:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:57:50.521968 :AEEF33E5:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:57:53.595759 :AEEF34CB:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:57:53.582 2025-07-07 21:57:53.595761 :AEEF34CC:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10888 pso_num=26 pso_serial#=171 2025-07-07 21:57:53.595896 :AEEF34CD:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10888 (legacy spawn) 2025-07-07 21:57:53.602396 :AEEF34CE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:57:53.602564 :AEEF34D3:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:57:53.603357 :AEEF34D8:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:57:53.612052 :AEEF34DB:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:57:53.597 2025-07-07 21:57:53.612054 :AEEF34DC:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=18292 pso_num=26 pso_serial#=172 2025-07-07 21:57:53.612193 :AEEF34DD:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=18292 (legacy spawn) 2025-07-07 21:57:53.618633 :AEEF34DE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:57:53.618803 :AEEF34E7:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:57:53.619620 :AEEF34E8:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:58:09.539664 :AEEF39AF:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:58:09.531 2025-07-07 21:58:09.539666 :AEEF39B0:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=7532 pso_num=26 pso_serial#=173 2025-07-07 21:58:09.539803 :AEEF39B1:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=7532 (legacy spawn) 2025-07-07 21:58:09.546384 :AEEF39B2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:58:09.546571 :AEEF39BA:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:58:09.547354 :AEEF39BC:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:58:26.800584 :AEEF3FAF:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:58:26.797 2025-07-07 21:58:26.800588 :AEEF3FB0:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16504 pso_num=26 pso_serial#=174 2025-07-07 21:58:26.800737 :AEEF3FB1:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=16504 (legacy spawn) 2025-07-07 21:58:26.807598 :AEEF3FB2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:58:26.807792 :AEEF3FB7:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:58:26.808652 :AEEF3FBC:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:58:26.818022 :AEEF3FBF:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:58:26.813 2025-07-07 21:58:26.818024 :AEEF3FC0:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=3592 pso_num=26 pso_serial#=175 2025-07-07 21:58:26.818209 :AEEF3FC1:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=3592 (legacy spawn) 2025-07-07 21:58:26.825140 :AEEF3FC2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:58:26.825329 :AEEF3FCB:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:58:26.826234 :AEEF3FCC:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:58:29.893432 :AEEF40BF:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:58:29.880 2025-07-07 21:58:29.893434 :AEEF40C0:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=18320 pso_num=26 pso_serial#=176 2025-07-07 21:58:29.893574 :AEEF40C1:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=18320 (legacy spawn) 2025-07-07 21:58:29.900072 :AEEF40C2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:58:29.900247 :AEEF40C7:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:58:29.901078 :AEEF40CC:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:58:29.909722 :AEEF40CF:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:58:29.895 2025-07-07 21:58:29.909724 :AEEF40D0:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17796 pso_num=26 pso_serial#=177 2025-07-07 21:58:29.909864 :AEEF40D1:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17796 (legacy spawn) 2025-07-07 21:58:29.916795 :AEEF40D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:58:29.916963 :AEEF40DB:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:58:29.917764 :AEEF40DC:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:58:43.550632 :AEEF4526:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:58:43.550 2025-07-07 21:58:43.550633 :AEEF4527:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13896 pso_num=26 pso_serial#=178 2025-07-07 21:58:43.550724 :AEEF4528:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13896 (legacy spawn) 2025-07-07 21:58:43.556780 :AEEF4529:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:58:43.556948 :AEEF452F:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:58:43.557754 :AEEF4533:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:59:17.037844 :AEEF508A:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:59:17.024 2025-07-07 21:59:17.037847 :AEEF508B:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13928 pso_num=26 pso_serial#=179 2025-07-07 21:59:17.037986 :AEEF508C:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13928 (legacy spawn) 2025-07-07 21:59:17.044773 :AEEF508D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:59:17.044950 :AEEF5092:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:59:17.045791 :AEEF5097:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:59:17.751894 :AEEF50B0:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:59:17.743 2025-07-07 21:59:17.751896 :AEEF50B1:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=9248 pso_num=26 pso_serial#=180 2025-07-07 21:59:17.752033 :AEEF50B2:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=9248 (legacy spawn) 2025-07-07 21:59:17.758600 :AEEF50B3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:59:17.758771 :AEEF50BC:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:59:17.759569 :AEEF50BD:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:59:39.799592 :AEEF575B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:59:39.785 2025-07-07 21:59:39.799594 :AEEF575C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=9288 pso_num=26 pso_serial#=181 2025-07-07 21:59:39.799728 :AEEF575D:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=9288 (legacy spawn) 2025-07-07 21:59:39.806163 :AEEF575E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:59:39.806337 :AEEF5767:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:59:39.807102 :AEEF5768:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:59:39.815870 :AEEF576B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:59:39.816 2025-07-07 21:59:39.815872 :AEEF576C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15356 pso_num=26 pso_serial#=182 2025-07-07 21:59:39.816011 :AEEF576D:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=15356 (legacy spawn) 2025-07-07 21:59:39.822558 :AEEF576E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:59:39.822724 :AEEF5777:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:59:39.823521 :AEEF5778:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:59:43.019530 :AEEF58A7:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:59:43.008 2025-07-07 21:59:43.019532 :AEEF58A8:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16196 pso_num=26 pso_serial#=183 2025-07-07 21:59:43.019688 :AEEF58A9:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=16196 (legacy spawn) 2025-07-07 21:59:43.026541 :AEEF58AA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:59:43.026717 :AEEF58B3:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:59:43.027562 :AEEF58B4:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 21:59:43.036594 :AEEF58B7:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 21:59:43.024 2025-07-07 21:59:43.036596 :AEEF58B8:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17732 pso_num=26 pso_serial#=184 2025-07-07 21:59:43.036749 :AEEF58B9:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17732 (legacy spawn) 2025-07-07 21:59:43.043558 :AEEF58BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 21:59:43.043750 :AEEF58C3:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 21:59:43.044595 :AEEF58C4:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-07 22:00:00.736362 :AEEF5FDE:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-07 22:00:00.725 2025-07-07 22:00:00.736364 :AEEF5FDF:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=9276 pso_num=26 pso_serial#=185 2025-07-07 22:00:00.736574 :AEEF5FE0:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=9276 osp_idx=24 osp_ver=576485 osp_pg=0 (spawn #362510) 2025-07-07 22:00:00.736574 :AEEF5FE1:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-07 22:00:00.736575 :AEEF5FE2:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=197 time=606376626 2025-07-07 22:00:00.736576 :AEEF5FE3:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-07-07 22:00:00.736577 :AEEF5FE4:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-07-07 22:00:00.736578 :AEEF5FE5:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-07-07 22:00:00.736578 :AEEF5FE6:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-07 22:00:00.736578 :AEEF5FE7:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-07 22:00:00.737149 :AEEF5FEB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-07 22:00:00.742330 :AEEF6006:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:00.742388 :AEEF600B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-07-07 22:00:00.746064 :AEEF603C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.132415 :AEEF63B0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.186437 :AEEF63C0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.201928 :AEEF63C8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.259237 :AEEF63D0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.391615 :AEEF63E0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.506220 :AEEF640E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.516087 :AEEF6416:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.530430 :AEEF641E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.542576 :AEEF6426:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.558448 :AEEF642E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.568234 :AEEF6436:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.577992 :AEEF643E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.593464 :AEEF6446:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.609106 :AEEF644E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.619025 :AEEF6456:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.628828 :AEEF645E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.638014 :AEEF6466:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.653270 :AEEF646E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.669204 :AEEF6476:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.685161 :AEEF6498:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.700491 :AEEF64A0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.715632 :AEEF64A8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.725523 :AEEF64B0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.741000 :AEEF64B8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.750353 :AEEF64C0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.760409 :AEEF64C8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.776137 :AEEF64D0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.785404 :AEEF64D8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.794638 :AEEF64E0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.809848 :AEEF64E8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.817097 :AEEF64F0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.827310 :AEEF64F8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.843111 :AEEF6500:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.858616 :AEEF6508:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.868092 :AEEF6510:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.878131 :AEEF6518:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.893789 :AEEF6520:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.909456 :AEEF6528:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.921856 :AEEF653C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.937185 :AEEF6567:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.947321 :AEEF656F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.956829 :AEEF6577:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.966129 :AEEF657F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.981340 :AEEF6587:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.990841 :AEEF658F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:01.998229 :AEEF6597:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:02.005526 :AEEF659F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:02.012840 :AEEF65A7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:02.020258 :AEEF65AF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:02.027716 :AEEF65B7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:02.035316 :AEEF65BF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:02.042875 :AEEF65C7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:02.050229 :AEEF65CF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:02.099801*:AEEF65E1:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000029A46918 estart=1751896801 eid=16777427 ctx=0x00000007831EA738 cwh=0x0000000029A70248 cpu=46875 buffg=11288 interb=114688 r=7 rb=114688 w=0 wb=0 2025-07-07 22:00:02.099801*:AEEF65E2:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000029A46918 curCtx=0x000000004C649DA0 pubTabIdxCnt=0 2025-07-07 22:00:02.099801*:AEEF65E3:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000029A46918 2025-07-07 22:00:02.099801*:AEEF65E4:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000029A46918 2025-07-07 22:00:02.099801*:AEEF65E5:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028BBC288 estart=1751896800 eid=16777321 ctx=0x000000079F654AA8 cwh=0x0000000028BB0158 cpu=1328125 buffg=98304 interb=27508736 r=1403 rb=25223168 w=12 wb=2285568 2025-07-07 22:00:02.099801*:AEEF65E6:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028BBC288 curCtx=0x000000004CB2EF58 pubTabIdxCnt=0 2025-07-07 22:00:02.099801*:AEEF65E7:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028BBC288 2025-07-07 22:00:02.099801*:AEEF65E8:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028BBC288 2025-07-07 22:00:02.599809*:AEEF6773:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000029A46918 curCtx=0x000000004C649DA0 xsc->flg4=65792 flags=1 2025-07-07 22:00:02.599809*:AEEF6774:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000029A46918 2025-07-07 22:00:03.193439 :AEEF6794:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:03.193811 :AEEF679C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:03.193811*:AEEF67A4:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028BBC288 curCtx=0x000000004CB2EF58 xsc->flg4=65792 flags=2 2025-07-07 22:00:03.193811*:AEEF67A5:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028BBC288 2025-07-07 22:00:03.194097 :AEEF67A6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-07-07 22:00:03.198667 :AEEF67A7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-07 22:00:03.198752 :AEEF67AA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-07-07 22:00:03.198835 :AEEF67B7:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-07-07 22:00:04.008040 :AEEF6823:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] 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 26 (osid: 9276, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de