Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250523220009\orcl_j001_13748_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250523220009\orcl_j001_13748_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:37302M/63366M, Ph+PgF:44315M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 13748, image: ORACLE.EXE (J001) *** 2025-05-23 22:00:09.459 *** SESSION ID:(209.55805) 2025-05-23 22:00:09.459 *** 2025-05-23 22:00:09.459 Process diagnostic dump for ORACLE.EXE (J001), OS id=13748, pid: 26, proc_ser: 35, sid: 209, sess_ser: 55805 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 13748 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=10 seq_num=11 snap_id=1 wait times: snap=0.025537 sec, exc=0.025537 sec, total=0.025537 sec wait times: max=0.500000 sec, heur=5.022095 sec wait counts: calls=1 os=1 in_wait=1 iflags=0x5a8 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000008 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=9 seq_num=10 snap_id=1 wait times: snap=0.500000 sec, exc=0.500000 sec, total=0.500000 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 snap_id=1 wait times: snap=0.500116 sec, exc=0.500116 sec, total=0.500116 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=7 seq_num=8 snap_id=1 wait times: snap=0.500142 sec, exc=0.500142 sec, total=0.500142 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000015 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 snap_id=1 wait times: snap=0.500307 sec, exc=0.500307 sec, total=0.500307 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.499998 sec, exc=0.499998 sec, total=0.499998 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 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.000009 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 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.000009 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.510098 sec, exc=0.510098 sec, total=0.510098 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=1 seq_num=2 snap_id=1 wait times: snap=0.499998 sec, exc=0.499998 sec, total=0.499998 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.485814 sec, exc=0.485814 sec, total=0.485814 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 55805 --------------------------------------------------- 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 --------------------------------------------------- [6 samples, 22:00:04 - 22:00:09] idle wait at each sample [session created at: 22:00:04] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-05-23 22:00:09.459 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 13748, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-05-23 21:57:03.646164 :9B19000F:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=9744 (legacy spawn) 2025-05-23 21:57:03.652665 :9B190010: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-05-23 21:57:03.652828 :9B190019: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-05-23 21:57:03.653632 :9B19001A:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:57:18.679420 :9B1904AC:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:57:18.670 2025-05-23 21:57:18.679422 :9B1904AD:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12632 pso_num=26 pso_serial#=20 2025-05-23 21:57:18.679561 :9B1904AE:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12632 (legacy spawn) 2025-05-23 21:57:18.685981 :9B1904AF: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-05-23 21:57:18.686140 :9B1904B7: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-05-23 21:57:18.686946 :9B1904B8:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:57:22.620611 :9B1905B5:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:57:22.606 2025-05-23 21:57:22.620614 :9B1905B6:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13316 pso_num=26 pso_serial#=21 2025-05-23 21:57:22.620755 :9B1905B7:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13316 (legacy spawn) 2025-05-23 21:57:22.627156 :9B1905B8: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-05-23 21:57:22.627321 :9B1905BE: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-05-23 21:57:22.628123 :9B1905C2:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:57:22.646005 :9B1905C5:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:57:22.638 2025-05-23 21:57:22.646007 :9B1905C6:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10224 pso_num=26 pso_serial#=22 2025-05-23 21:57:22.646143 :9B1905C7:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10224 (legacy spawn) 2025-05-23 21:57:22.652620 :9B1905C8: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-05-23 21:57:22.652776 :9B1905D1: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-05-23 21:57:22.653585 :9B1905D2:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:57:25.916904 :9B1906C7:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:57:25.904 2025-05-23 21:57:25.916906 :9B1906C8:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12828 pso_num=26 pso_serial#=23 2025-05-23 21:57:25.917044 :9B1906C9:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12828 (legacy spawn) 2025-05-23 21:57:25.923599 :9B1906CA: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-05-23 21:57:25.923770 :9B1906CF: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-05-23 21:57:25.924588 :9B1906D4:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:57:25.933221 :9B1906D7:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:57:25.919 2025-05-23 21:57:25.933223 :9B1906D8:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13532 pso_num=26 pso_serial#=24 2025-05-23 21:57:25.933357 :9B1906D9:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13532 (legacy spawn) 2025-05-23 21:57:25.939843 :9B1906DA: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-05-23 21:57:25.940006 :9B1906E3: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-05-23 21:57:25.940806 :9B1906E4:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:58:02.118776 :9B191348:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:58:02.106 2025-05-23 21:58:02.118778 :9B191349:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13904 pso_num=26 pso_serial#=25 2025-05-23 21:58:02.118918 :9B19134A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13904 (legacy spawn) 2025-05-23 21:58:02.126016 :9B19136E: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-05-23 21:58:02.126177 :9B191377: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-05-23 21:58:02.126943 :9B191378:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:58:02.135646 :9B19137B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:58:02.122 2025-05-23 21:58:02.135649 :9B19137C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=2828 pso_num=26 pso_serial#=26 2025-05-23 21:58:02.135793 :9B19137D:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=2828 (legacy spawn) 2025-05-23 21:58:02.142256 :9B19137E: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-05-23 21:58:02.142413 :9B191387: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-05-23 21:58:02.143205 :9B191388:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:58:05.806798 :9B191475:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:58:05.798 2025-05-23 21:58:05.806800 :9B191476:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12084 pso_num=26 pso_serial#=27 2025-05-23 21:58:05.806932 :9B191477:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12084 (legacy spawn) 2025-05-23 21:58:05.813419 :9B191478: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-05-23 21:58:05.813602 :9B19147D: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-05-23 21:58:05.814421 :9B191482:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:58:26.908992 :9B191AD0:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:58:26.899 2025-05-23 21:58:26.908995 :9B191AD1:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12820 pso_num=26 pso_serial#=28 2025-05-23 21:58:26.909145 :9B191AD2:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12820 (legacy spawn) 2025-05-23 21:58:26.916118 :9B191AD3: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-05-23 21:58:26.916319 :9B191AD8: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-05-23 21:58:26.917182 :9B191ADD:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:59:08.007875 :9B192851:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:59:07.999 2025-05-23 21:59:08.007877 :9B192852:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12296 pso_num=26 pso_serial#=29 2025-05-23 21:59:08.008008 :9B192853:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12296 (legacy spawn) 2025-05-23 21:59:08.014466 :9B192854: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-05-23 21:59:08.014652 :9B19285D: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-05-23 21:59:08.015459 :9B19285E:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:59:10.507752 :9B192935:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:59:10.500 2025-05-23 21:59:10.507754 :9B192936:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12516 pso_num=26 pso_serial#=30 2025-05-23 21:59:10.507888 :9B192937:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12516 (legacy spawn) 2025-05-23 21:59:10.514291 :9B192938: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-05-23 21:59:10.514475 :9B19293F: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-05-23 21:59:10.515284 :9B192942:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:59:11.623124 :9B192974:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:59:11.609 2025-05-23 21:59:11.623126 :9B192975:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12012 pso_num=26 pso_serial#=31 2025-05-23 21:59:11.623265 :9B192976:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12012 (legacy spawn) 2025-05-23 21:59:11.629674 :9B192977: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-05-23 21:59:11.629843 :9B19297C: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-05-23 21:59:11.630669 :9B192981:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:59:11.639389 :9B192984:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:59:11.625 2025-05-23 21:59:11.639391 :9B192985:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14020 pso_num=26 pso_serial#=32 2025-05-23 21:59:11.639527 :9B192986:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14020 (legacy spawn) 2025-05-23 21:59:11.645991 :9B192987: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-05-23 21:59:11.646161 :9B19298F: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-05-23 21:59:11.646963 :9B192991:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:59:14.733541 :9B192A78:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:59:14.720 2025-05-23 21:59:14.733543 :9B192A79:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12720 pso_num=26 pso_serial#=33 2025-05-23 21:59:14.733681 :9B192A7A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12720 (legacy spawn) 2025-05-23 21:59:14.740224 :9B192A7B: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-05-23 21:59:14.740402 :9B192A80: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-05-23 21:59:14.741212 :9B192A85:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 21:59:14.749741 :9B192A88:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 21:59:14.736 2025-05-23 21:59:14.749743 :9B192A89:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11040 pso_num=26 pso_serial#=34 2025-05-23 21:59:14.749878 :9B192A8A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=11040 (legacy spawn) 2025-05-23 21:59:14.756334 :9B192A8B: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-05-23 21:59:14.756508 :9B192A94: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-05-23 21:59:14.757326 :9B192A95:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-23 22:00:02.059108 :9B193B4E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-23 22:00:02.048 2025-05-23 22:00:02.059110 :9B193B4F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13748 pso_num=26 pso_serial#=35 2025-05-23 22:00:02.059241 :9B193B50:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=13748 osp_idx=24 osp_ver=321590 osp_pg=0 (spawn #212501) 2025-05-23 22:00:02.059242 :9B193B51:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-23 22:00:02.059242 :9B193B52:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=226 time=1013374313 2025-05-23 22:00:02.059243 :9B193B53:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-05-23 22:00:02.059243 :9B193B54:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-05-23 22:00:02.059243 :9B193B55:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-05-23 22:00:02.059244 :9B193B56:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-23 22:00:02.059244 :9B193B57:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-23 22:00:02.059715 :9B193B58: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-05-23 22:00:02.064946 :9B193B80: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-05-23 22:00:02.064987 :9B193B83:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-05-23 22:00:02.068274 :9B193B9E: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-05-23 22:00:02.440662 :9B193FD8: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-05-23 22:00:02.484626 :9B193FE0: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-05-23 22:00:02.500271 :9B193FE8: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-05-23 22:00:02.557630 :9B194004: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-05-23 22:00:02.690371 :9B194014: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-05-23 22:00:02.804247 :9B19401C: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-05-23 22:00:02.813602 :9B194024: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-05-23 22:00:02.828219 :9B19402C: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-05-23 22:00:02.842584 :9B194034: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-05-23 22:00:02.857532 :9B19403C: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-05-23 22:00:02.866885 :9B194044: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-05-23 22:00:02.876313 :9B19404C: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-05-23 22:00:02.890854 :9B194054: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-05-23 22:00:02.905661 :9B19405C: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-05-23 22:00:02.915298 :9B194064: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-05-23 22:00:02.924710 :9B19406C: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-05-23 22:00:02.934334 :9B194074: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-05-23 22:00:02.949035 :9B19407C: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-05-23 22:00:02.964149 :9B194084: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-05-23 22:00:02.978936 :9B19408C: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-05-23 22:00:02.993555 :9B194094: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-05-23 22:00:03.008191 :9B19409C: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-05-23 22:00:03.017914 :9B1940A4: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-05-23 22:00:03.032397 :9B1940AC: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-05-23 22:00:03.042075 :9B1940B4: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-05-23 22:00:03.050784 :9B1940BC: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-05-23 22:00:03.065449 :9B1940C4: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-05-23 22:00:03.074429 :9B1940CC: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-05-23 22:00:03.089059 :9B1940D4: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-05-23 22:00:03.096037 :9B1940DC: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-05-23 22:00:03.105580 :9B1940E4: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-05-23 22:00:03.115039 :9B1940EC: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-05-23 22:00:03.124129 :9B1940F4: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-05-23 22:00:03.139029 :9B1940FC: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-05-23 22:00:03.153599 :9B194104: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-05-23 22:00:03.163039 :9B19410C: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-05-23 22:00:03.177632 :9B194114: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-05-23 22:00:03.191864 :9B19411C: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-05-23 22:00:03.206286 :9B194124: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-05-23 22:00:03.216059 :9B19412C: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-05-23 22:00:03.226752 :9B194134: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-05-23 22:00:03.236093 :9B19413C: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-05-23 22:00:03.245294 :9B194144: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-05-23 22:00:03.260298 :9B19414C: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-05-23 22:00:03.269714 :9B194154: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-05-23 22:00:03.277067 :9B19415C: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-05-23 22:00:03.284397 :9B194164: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-05-23 22:00:03.291873 :9B19416C: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-05-23 22:00:03.292452*:9B194187:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003F43A188 estart=1748008802 eid=16790446 ctx=0x0000000783637648 cwh=0x00000000291D0068 cpu=15625 buffg=16 interb=0 r=0 rb=0 w=0 wb=0 2025-05-23 22:00:03.292452*:9B194188:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003F43A188 curCtx=0x000000003F3FFEB8 pubTabIdxCnt=0 2025-05-23 22:00:03.292452*:9B194189:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003F43A188 2025-05-23 22:00:03.292452*:9B19418A:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003F43A188 2025-05-23 22:00:03.292452*:9B19418B:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000271EC288 estart=1748008801 eid=16777276 ctx=0x000000079F654AA8 cwh=0x00000000271E0158 cpu=1171875 buffg=85994 interb=24657920 r=1228 rb=22364160 w=12 wb=2293760 2025-05-23 22:00:03.292452*:9B19418C:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000271EC288 curCtx=0x000000003F3E0F00 pubTabIdxCnt=0 2025-05-23 22:00:03.292452*:9B19418D:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000271EC288 2025-05-23 22:00:03.292452*:9B19418E:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000271EC288 2025-05-23 22:00:03.292452*:9B194199:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003F43A188 curCtx=0x000000003F3FFEB8 xsc->flg4=65792 flags=0 2025-05-23 22:00:03.292452*:9B19419A:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003F43A188 2025-05-23 22:00:03.299307 :9B19419B: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-05-23 22:00:03.306712 :9B1941A3: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-05-23 22:00:03.314359 :9B1941AB: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-05-23 22:00:03.321841 :9B1941B3: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-05-23 22:00:03.329126 :9B1941BB: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-05-23 22:00:04.409723 :9B194415: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-05-23 22:00:04.412102 :9B19441D: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-05-23 22:00:04.412325 :9B194425: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-05-23 22:00:04.419825 :9B19442D: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-05-23 22:00:04.427180 :9B194435: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-05-23 22:00:04.435492 :9B19443D: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-05-23 22:00:04.435783 :9B194445: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-05-23 22:00:04.435783*:9B194448:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000271EC288 curCtx=0x000000003F3E0F00 xsc->flg4=65792 flags=2 2025-05-23 22:00:04.435783*:9B194449:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000271EC288 2025-05-23 22:00:04.436021 :9B19444F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-05-23 22:00:04.440353 :9B194450: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-05-23 22:00:04.440429 :9B194453: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-05-23 22:00:04.440505 :9B194460: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 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 26 (osid: 13748, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de