Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250714220008\orcl_j001_15736_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250714220008\orcl_j001_15736_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:36318M/63366M, Ph+PgF:42287M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 15736, image: ORACLE.EXE (J001) *** 2025-07-14 22:00:08.486 *** SESSION ID:(209.58435) 2025-07-14 22:00:08.486 *** 2025-07-14 22:00:08.486 Process diagnostic dump for ORACLE.EXE (J001), OS id=15736, pid: 26, proc_ser: 190, sid: 209, sess_ser: 58435 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 15736 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) 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.446886 sec, exc=0.446886 sec, total=0.446886 sec wait times: max=0.500000 sec, heur=3.940956 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.000011 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.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.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.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.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.499992 sec, exc=0.499992 sec, total=0.499992 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.500009 sec, exc=0.500009 sec, total=0.500009 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 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.500111 sec, exc=0.500111 sec, total=0.500111 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 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.500003 sec, exc=0.500003 sec, total=0.500003 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=0 seq_num=1 snap_id=1 wait times: snap=0.493897 sec, exc=0.493897 sec, total=0.493897 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 58435 --------------------------------------------------- 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:04 - 22:00:08] 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-07-14 22:00:08.486 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 15736, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-14 21:56:24.519976 :B20B4482:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:57:09.500807 :B20B534B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:57:09.491 2025-07-14 21:57:09.500809 :B20B534C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=16664 pso_num=26 pso_serial#=174 2025-07-14 21:57:09.500944 :B20B534D:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=16664 (legacy spawn) 2025-07-14 21:57:09.507474 :B20B534E: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-14 21:57:09.507658 :B20B5353: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-14 21:57:09.508433 :B20B5358:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:57:17.393231 :B20B55BD:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:57:17.380 2025-07-14 21:57:17.393233 :B20B55BE:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17148 pso_num=26 pso_serial#=175 2025-07-14 21:57:17.393367 :B20B55BF:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17148 (legacy spawn) 2025-07-14 21:57:17.399830 :B20B55C0: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-14 21:57:17.400009 :B20B55C5: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-14 21:57:17.400821 :B20B55CA:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:57:33.990298 :B20B5B07:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:57:33.976 2025-07-14 21:57:33.990300 :B20B5B08:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15056 pso_num=26 pso_serial#=176 2025-07-14 21:57:33.990432 :B20B5B09:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=15056 (legacy spawn) 2025-07-14 21:57:33.996909 :B20B5B0A: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-14 21:57:33.997081 :B20B5B0F: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-14 21:57:33.997851 :B20B5B14:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:57:34.006558 :B20B5B17:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:57:33.992 2025-07-14 21:57:34.006560 :B20B5B18:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15184 pso_num=26 pso_serial#=177 2025-07-14 21:57:34.006701 :B20B5B19:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=15184 (legacy spawn) 2025-07-14 21:57:34.013542 :B20B5B1D: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-14 21:57:34.013703 :B20B5B26: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-14 21:57:34.014493 :B20B5B27:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:58:10.228705 :B20B676A:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:58:10.214 2025-07-14 21:58:10.228707 :B20B676B:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14600 pso_num=26 pso_serial#=178 2025-07-14 21:58:10.228849 :B20B676C:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14600 (legacy spawn) 2025-07-14 21:58:10.235428 :B20B676D: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-14 21:58:10.235458 :B20B6770: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-14 21:58:10.235600 :B20B6773: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-14 21:58:10.236422 :B20B6784:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:58:10.252467 :B20B6787:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:58:10.245 2025-07-14 21:58:10.252469 :B20B6788:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12980 pso_num=26 pso_serial#=179 2025-07-14 21:58:10.252607 :B20B6789:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12980 (legacy spawn) 2025-07-14 21:58:10.259061 :B20B678A: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-14 21:58:10.259242 :B20B6793: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-14 21:58:10.260026 :B20B6794:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:58:13.409374 :B20B687E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:58:13.396 2025-07-14 21:58:13.409376 :B20B687F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14320 pso_num=26 pso_serial#=180 2025-07-14 21:58:13.409527 :B20B6880:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14320 (legacy spawn) 2025-07-14 21:58:13.416227 :B20B6881: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-14 21:58:13.416408 :B20B6886: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-14 21:58:13.417262 :B20B688B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:58:13.426230 :B20B688E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:58:13.411 2025-07-14 21:58:13.426233 :B20B688F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11076 pso_num=26 pso_serial#=181 2025-07-14 21:58:13.426373 :B20B6890:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=11076 (legacy spawn) 2025-07-14 21:58:13.433186 :B20B6891: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-14 21:58:13.433368 :B20B689A: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-14 21:58:13.434256 :B20B689B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:58:17.637208 :B20B69C2:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:58:17.624 2025-07-14 21:58:17.637210 :B20B69C3:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=4428 pso_num=26 pso_serial#=182 2025-07-14 21:58:17.637347 :B20B69C4:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=4428 (legacy spawn) 2025-07-14 21:58:17.643721 :B20B69C5: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-14 21:58:17.643894 :B20B69CB: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-14 21:58:17.644658 :B20B69CF:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:58:19.601056 :B20B6ABB:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:58:19.593 2025-07-14 21:58:19.601058 :B20B6ABC:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=4288 pso_num=26 pso_serial#=183 2025-07-14 21:58:19.601200 :B20B6ABD:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=4288 (legacy spawn) 2025-07-14 21:58:19.607679 :B20B6ABE: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-14 21:58:19.607855 :B20B6AC7: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-14 21:58:19.608709 :B20B6AC8:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:59:21.753764 :B20B7ECE:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:59:21.741 2025-07-14 21:59:21.753766 :B20B7ECF:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17304 pso_num=26 pso_serial#=184 2025-07-14 21:59:21.753903 :B20B7ED0:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17304 (legacy spawn) 2025-07-14 21:59:21.760475 :B20B7ED1: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-14 21:59:21.760669 :B20B7ED6: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-14 21:59:21.761509 :B20B7EDB:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:59:22.879861 :B20B7F59:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:59:22.866 2025-07-14 21:59:22.879863 :B20B7F5A:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12936 pso_num=26 pso_serial#=185 2025-07-14 21:59:22.879996 :B20B7F5B:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12936 (legacy spawn) 2025-07-14 21:59:22.886428 :B20B7F5C: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-14 21:59:22.886613 :B20B7F65: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-14 21:59:22.887416 :B20B7F66:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:59:22.904460 :B20B7F69:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:59:22.897 2025-07-14 21:59:22.904462 :B20B7F6A:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=17720 pso_num=26 pso_serial#=186 2025-07-14 21:59:22.904609 :B20B7F6B:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=17720 (legacy spawn) 2025-07-14 21:59:22.911078 :B20B7F6C: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-14 21:59:22.911241 :B20B7F75: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-14 21:59:22.912035 :B20B7F76:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:59:25.933316 :B20B8068:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:59:25.925 2025-07-14 21:59:25.933318 :B20B8069:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13480 pso_num=26 pso_serial#=187 2025-07-14 21:59:25.933458 :B20B806A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13480 (legacy spawn) 2025-07-14 21:59:25.939989 :B20B806B: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-14 21:59:25.940163 :B20B8074: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-14 21:59:25.940966 :B20B8075:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:59:26.015800 :B20B8078:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:59:26.003 2025-07-14 21:59:26.015802 :B20B8079:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=1484 pso_num=26 pso_serial#=188 2025-07-14 21:59:26.015940 :B20B807A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=1484 (legacy spawn) 2025-07-14 21:59:26.022861 :B20B807B: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-14 21:59:26.023031 :B20B8083: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-14 21:59:26.023821 :B20B8084:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 21:59:26.032426 :B20B8087:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 21:59:26.018 2025-07-14 21:59:26.032427 :B20B8088:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=280 pso_num=26 pso_serial#=189 2025-07-14 21:59:26.032565 :B20B8089:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=280 (legacy spawn) 2025-07-14 21:59:26.039025 :B20B808A: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-14 21:59:26.039200 :B20B8092: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-14 21:59:26.040020 :B20B8094:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-07-14 22:00:02.043645 :B20B8D72:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 07-14 22:00:02.033 2025-07-14 22:00:02.043648 :B20B8D73:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15736 pso_num=26 pso_serial#=190 2025-07-14 22:00:02.043787 :B20B8D74:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=15736 osp_idx=24 osp_ver=617290 osp_pg=0 (spawn #385833) 2025-07-14 22:00:02.043788 :B20B8D75: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-14 22:00:02.043788 :B20B8D76:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=85 time=1211177939 2025-07-14 22:00:02.043789 :B20B8D77:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-07-14 22:00:02.043789 :B20B8D78:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-07-14 22:00:02.043789 :B20B8D79:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-07-14 22:00:02.043790 :B20B8D7A:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-14 22:00:02.043790 :B20B8D7B:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-14 22:00:02.044284 :B20B8D7D: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-14 22:00:02.049388 :B20B8DA4: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-14 22:00:02.049430 :B20B8DA7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-07-14 22:00:02.052856 :B20B8DC2: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-14 22:00:02.433930 :B20B90F9: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-14 22:00:02.478404 :B20B9101: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-14 22:00:02.494374 :B20B9111: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-14 22:00:02.552539 :B20B9139: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-14 22:00:02.686487 :B20B9149: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-14 22:00:02.807511 :B20B9151: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-14 22:00:02.817217 :B20B9159: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-14 22:00:02.832890 :B20B9161: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-14 22:00:02.848132 :B20B9175: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-14 22:00:02.864009 :B20B917D: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-14 22:00:02.873638 :B20B9185: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-14 22:00:02.883541 :B20B918D: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-14 22:00:02.898943 :B20B9195: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-14 22:00:02.914680 :B20B919D: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-14 22:00:02.924946 :B20B91A5: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-14 22:00:02.934979 :B20B91AD: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-14 22:00:02.950351 :B20B91B5: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-14 22:00:02.960025 :B20B91BD: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-14 22:00:02.976356 :B20B91C5: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-14 22:00:02.992740 :B20B91CD: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-14 22:00:03.009080 :B20B91D5: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-14 22:00:03.016983 :B20B91DD: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-14 22:00:03.033171 :B20B91E5: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-14 22:00:03.043479 :B20B91ED: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-14 22:00:03.059549 :B20B91F5: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-14 22:00:03.070206 :B20B91FD: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-14 22:00:03.080285 :B20B9205: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-14 22:00:03.091081 :B20B920D: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-14 22:00:03.107178 :B20B9215: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-14 22:00:03.116861 :B20B921D: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-14 22:00:03.132379 :B20B9225: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-14 22:00:03.148543 :B20B922D: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-14 22:00:03.164208 :B20B9235: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-14 22:00:03.174089 :B20B923D: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-14 22:00:03.184139 :B20B9245: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-14 22:00:03.194303 :B20B924D: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-14 22:00:03.209955 :B20B927D: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-14 22:00:03.225873 :B20B9285: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-14 22:00:03.241660 :B20B928D: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-14 22:00:03.252187 :B20B9295: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-14 22:00:03.261875 :B20B929D: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-14 22:00:03.271660 :B20B92A5: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-14 22:00:03.281484 :B20B92AD: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-14 22:00:03.293800 :B20B92B5: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-14 22:00:03.309790 :B20B92BD: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-14 22:00:03.319712 :B20B92C5: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-14 22:00:03.327266 :B20B92CD: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-14 22:00:03.335017 :B20B92D5: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-14 22:00:03.342576 :B20B92DD: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-14 22:00:03.350238 :B20B92E5: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-14 22:00:03.358078 :B20B92ED: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-14 22:00:03.366035 :B20B92F5: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-14 22:00:03.373675 :B20B92FD: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-14 22:00:03.579501*:B20B9332:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000029A46918 estart=1752501602 eid=16777441 ctx=0x00000007831EA738 cwh=0x0000000029A70248 cpu=203125 buffg=40495 interb=163840 r=10 rb=163840 w=0 wb=0 2025-07-14 22:00:03.579501*:B20B9333:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000029A46918 curCtx=0x000000004E4DFD60 pubTabIdxCnt=0 2025-07-14 22:00:03.579501*:B20B9334:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000029A46918 2025-07-14 22:00:03.579501*:B20B9335:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000029A46918 2025-07-14 22:00:03.579501*:B20B9336:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028BBC288 estart=1752501601 eid=16777328 ctx=0x000000079F654AA8 cwh=0x0000000028BB0158 cpu=1515625 buffg=127639 interb=27590656 r=1406 rb=25288704 w=12 wb=2301952 2025-07-14 22:00:03.579501*:B20B9337:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028BBC288 curCtx=0x000000004EC91DD0 pubTabIdxCnt=0 2025-07-14 22:00:03.579501*:B20B9338:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028BBC288 2025-07-14 22:00:03.579501*:B20B9339:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028BBC288 2025-07-14 22:00:03.923684*:B20B945D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000029A46918 curCtx=0x000000004E4DFD60 xsc->flg4=65792 flags=1 2025-07-14 22:00:03.923684*:B20B945E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000029A46918 2025-07-14 22:00:04.540874 :B20B9641: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-14 22:00:04.541279 :B20B9649: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-14 22:00:04.541279*:B20B9651:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028BBC288 curCtx=0x000000004EC91DD0 xsc->flg4=65792 flags=2 2025-07-14 22:00:04.541279*:B20B9652:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028BBC288 2025-07-14 22:00:04.541561 :B20B9653:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-07-14 22:00:04.546536 :B20B9654: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-14 22:00:04.546632 :B20B9657: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-14 22:00:04.546712 :B20B9664: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: 15736, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de