Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250826220006\orcl_j004_23136_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:35166M/63366M, Ph+PgF:40208M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 30 Windows thread id: 23136, image: ORACLE.EXE (J004) *** 2025-08-26 22:00:07.076 *** SESSION ID:(241.4295) 2025-08-26 22:00:07.076 *** 2025-08-26 22:00:07.076 Process diagnostic dump for ORACLE.EXE (J004), OS id=23136, pid: 30, proc_ser: 221, sid: 241, sess_ser: 4295 ------------------------------------------------------------------------------- current sql: client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 23136 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J004) 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.281015 sec, exc=0.281015 sec, total=0.281015 sec wait times: max=0.500000 sec, heur=3.781101 sec wait counts: calls=1 os=1 in_wait=1 iflags=0x5a8 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000009 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 snap_id=1 wait times: snap=0.499991 sec, exc=0.499991 sec, total=0.499991 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000017 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.499978 sec, exc=0.499978 sec, total=0.499978 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000017 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.505108 sec, exc=0.505108 sec, total=0.505108 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 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.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 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 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.000009 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.500005 sec, exc=0.500005 sec, total=0.500005 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.494936 sec, exc=0.494936 sec, total=0.494936 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 241 serial 4295 --------------------------------------------------- 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:03 - 22:00:07] idle wait at each sample [session created at: 22:00:03] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.015000 sec (max dump time=30.000000 sec) *** 2025-08-26 22:00:07.092 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 30 (osid: 23136, J004) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-25 22:00:03.305827 :C49FA7FB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.306779 :C49FA803:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpus:psdpgi.c:2235 2025-08-25 22:00:03.307286 :C49FA804:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.325201 :C49FA80C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.325251 :C49FA80F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpop:psdpgi.c:2235 2025-08-25 22:00:03.326190 :C49FA815:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.337847 :C49FA81D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpus:psdpgi.c:2235 2025-08-25 22:00:03.338414 :C49FA81E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.356836 :C49FA826:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.356891 :C49FA829:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpop:psdpgi.c:2235 2025-08-25 22:00:03.357796 :C49FA82F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.358681 :C49FA837:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpus:psdpgi.c:2235 2025-08-25 22:00:03.359120 :C49FA838:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.382234 :C49FA84A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.382318 :C49FA84D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpop:psdpgi.c:2235 2025-08-25 22:00:03.383437 :C49FA853:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.384420 :C49FA85B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpus:psdpgi.c:2235 2025-08-25 22:00:03.384853 :C49FA85C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.406662 :C49FA864:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.406724 :C49FA867:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpop:psdpgi.c:2235 2025-08-25 22:00:03.407756 :C49FA86D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.408280 :C49FA875:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.408700 :C49FA87D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.408916 :C49FA885:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.409062 :C49FA88D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.409269 :C49FA895:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpop:jslv.c:9203 2025-08-25 22:00:03.413422 :C49FA896:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 22:00:03.413533 :C49FA899:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-08-25 22:00:33.483709 :C49FB5E0:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:01.625512 :C4A8DD06:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:01.623 2025-08-25 23:59:01.625514 :C4A8DD07:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=20016 pso_num=30 pso_serial#=210 2025-08-25 23:59:01.625654 :C4A8DD08:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=20016 (legacy spawn) 2025-08-25 23:59:01.632276 :C4A8DD09:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 23:59:01.632475 :C4A8DD11:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-25 23:59:01.633371 :C4A8DD13:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:02.669318 :C4A8DD80:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:02.655 2025-08-25 23:59:02.669320 :C4A8DD81:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=22644 pso_num=30 pso_serial#=211 2025-08-25 23:59:02.669460 :C4A8DD82:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=22644 (legacy spawn) 2025-08-25 23:59:02.675960 :C4A8DD83:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 23:59:02.676151 :C4A8DD88:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-25 23:59:02.677004 :C4A8DD8D:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:02.695170 :C4A8DD90:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:02.686 2025-08-25 23:59:02.695172 :C4A8DD91:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=19788 pso_num=30 pso_serial#=212 2025-08-25 23:59:02.695314 :C4A8DD92:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=19788 (legacy spawn) 2025-08-25 23:59:02.701918 :C4A8DD93:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 23:59:02.702086 :C4A8DD9C:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-25 23:59:02.702944 :C4A8DD9D:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:05.513924 :C4A8DEAA:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:05.505 2025-08-25 23:59:05.513927 :C4A8DEAB:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=22300 pso_num=30 pso_serial#=213 2025-08-25 23:59:05.514063 :C4A8DEAC:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=22300 (legacy spawn) 2025-08-25 23:59:05.529749 :C4A8DEAD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 23:59:38.830474 :C4A8EB66:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:38.967920 :C4A8EB75:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:38.952 2025-08-25 23:59:38.967922 :C4A8EB76:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=17416 pso_num=30 pso_serial#=214 2025-08-25 23:59:38.968056 :C4A8EB77:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=17416 (legacy spawn) 2025-08-25 23:59:38.974590 :C4A8EB78:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 23:59:38.974761 :C4A8EB81:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-25 23:59:38.975542 :C4A8EB82:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:38.984422 :C4A8EB85:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:38.984 2025-08-25 23:59:38.984424 :C4A8EB86:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=23540 pso_num=30 pso_serial#=215 2025-08-25 23:59:38.984562 :C4A8EB87:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=23540 (legacy spawn) 2025-08-25 23:59:38.991033 :C4A8EB88:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 23:59:38.991200 :C4A8EB91:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-25 23:59:38.992032 :C4A8EB92:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:41.982917 :C4A8ECA6:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:41.974 2025-08-25 23:59:41.982919 :C4A8ECA7:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=22896 pso_num=30 pso_serial#=216 2025-08-25 23:59:41.983078 :C4A8ECA8:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=22896 (legacy spawn) 2025-08-25 23:59:42.010578 :C4A8ECA9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 23:59:42.010776 :C4A8ECB2:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-25 23:59:42.011748 :C4A8ECB3:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:42.254910 :C4A8ECE5:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:42.240 2025-08-25 23:59:42.254913 :C4A8ECE6:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=16632 pso_num=30 pso_serial#=217 2025-08-25 23:59:42.255071 :C4A8ECE7:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=16632 (legacy spawn) 2025-08-25 23:59:42.262594 :C4A8ECE8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 23:59:42.262782 :C4A8ECF0:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-25 23:59:42.263811 :C4A8ECF2:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:42.273686 :C4A8ECF5:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:42.271 2025-08-25 23:59:42.273689 :C4A8ECF6:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=23296 pso_num=30 pso_serial#=218 2025-08-25 23:59:42.273850 :C4A8ECF7:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=23296 (legacy spawn) 2025-08-25 23:59:42.281306 :C4A8ECF8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-25 23:59:42.281510 :C4A8ED00:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-25 23:59:42.282591 :C4A8ED02:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-25 23:59:42.540624 :C4A8ED05:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-25 23:59:42.537 2025-08-25 23:59:42.540626 :C4A8ED06:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=23000 pso_num=30 pso_serial#=219 2025-08-25 23:59:42.540764 :C4A8ED07:db_trace:kso.c@4070:ksonfy(): [10420:30:0] kso: new process: pid=23000 (legacy spawn) 2025-08-25 23:59:42.555333 :C4A8ED08:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 00:00:15.768356 :C4A8F8DE:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-26 11:00:54.409969 :C4DC2FD8:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-26 11:00:54.398 2025-08-26 11:00:54.409971 :C4DC2FD9:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=23068 pso_num=30 pso_serial#=220 2025-08-26 11:00:54.410102 :C4DC2FDA:db_trace:kso.c@4093:ksonfy(): [10420:30:0] kso: new process: pid=23068 osp_idx=28 osp_ver=2004 osp_pg=0 (spawn #527641) 2025-08-26 11:00:54.410103 :C4DC2FDB:db_trace:kso.c@4099:ksonfy(): [10420:30:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-26 11:00:54.410103 :C4DC2FDC:db_trace:kso.c@4103:ksonfy(): [10420:30:0] kso: new process: pso_index=30 reservation=10 time=591709143 2025-08-26 11:00:54.410104 :C4DC2FDD:db_trace:kso.c@4109:ksonfy(): [10420:30:0] kso: spawn diagnostics: queue time=0 secs 2025-08-26 11:00:54.410104 :C4DC2FDE:db_trace:kso.c@4111:ksonfy(): [10420:30:0] kso: spawn diagnostics: fork time=0 secs 2025-08-26 11:00:54.410104 :C4DC2FDF:db_trace:kso.c@4113:ksonfy(): [10420:30:0] kso: spawn diagnostics: exec time=0 secs 2025-08-26 11:00:54.410105 :C4DC2FE0:db_trace:kso.c@4115:ksonfy(): [10420:30:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-26 11:00:54.410106 :C4DC2FE1:db_trace:kso.c@4117:ksonfy(): [10420:30:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-26 11:00:54.411280 :C4DC2FE2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-26 11:00:54.411339 :C4DC2FE8:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] KSL POST RCVD poster=18 loc='ksv2.h LINE:1639 ID:ksvpst: run' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-26 11:00:54.419813 :C4DC2FFA:db_trace:kst.c@698:kstpsodel(): [10280:30:0] kst: process state object about to be deleted 2025-08-26 22:00:00.788716 :C50EFA44:db_trace:kst.c@673:kstipg(): [10280:30:0] kst: process state object created on 08-26 22:00:00.786 2025-08-26 22:00:00.788717 :C50EFA45:db_trace:kst.c@679:kstipg(): [10280:30:0] kst: process info: ospid=23136 pso_num=30 pso_serial#=221 2025-08-26 22:00:00.788901 :C50EFA46:db_trace:kso.c@4093:ksonfy(): [10420:30:0] kso: new process: pid=23136 osp_idx=28 osp_ver=2005 osp_pg=0 (spawn #529163) 2025-08-26 22:00:00.788902 :C50EFA47:db_trace:kso.c@4099:ksonfy(): [10420:30:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-26 22:00:00.788903 :C50EFA48:db_trace:kso.c@4103:ksonfy(): [10420:30:0] kso: new process: pso_index=30 reservation=11 time=631255518 2025-08-26 22:00:00.788904 :C50EFA49:db_trace:kso.c@4109:ksonfy(): [10420:30:0] kso: spawn diagnostics: queue time=0 secs 2025-08-26 22:00:00.788905 :C50EFA4A:db_trace:kso.c@4111:ksonfy(): [10420:30:0] kso: spawn diagnostics: fork time=0 secs 2025-08-26 22:00:00.788906 :C50EFA4B:db_trace:kso.c@4113:ksonfy(): [10420:30:0] kso: spawn diagnostics: exec time=0 secs 2025-08-26 22:00:00.788908 :C50EFA4C:db_trace:kso.c@4115:ksonfy(): [10420:30:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-26 22:00:00.788909 :C50EFA4D:db_trace:kso.c@4117:ksonfy(): [10420:30:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-26 22:00:00.789570 :C50EFA57:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-26 22:00:00.794652 :C50EFA9A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:00.794679 :C50EFA9D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpus:jslv.c:9203 2025-08-26 22:00:00.798908 :C50EFAC0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.181874 :C50EFC78:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.225804 :C50EFC88:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.241892 :C50EFC90:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.299876 :C50EFC98:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.433250 :C50EFCA8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.547858 :C50EFCB0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.557530 :C50EFCB8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.573741 :C50EFCC0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.589551 :C50EFCD6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.606055 :C50EFD08:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.615816 :C50EFD10:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.631902 :C50EFD18:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.641738 :C50EFD20:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.658038 :C50EFD28:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.668037 :C50EFD30:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.678019 :C50EFD38:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.694031 :C50EFD40:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.703719 :C50EFD48:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.720279 :C50EFD50:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.736979 :C50EFD64:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.752816 :C50EFD6C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.761533 :C50EFD74:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.777978 :C50EFD7C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.788086 :C50EFD84:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.804507 :C50EFD8C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.813881 :C50EFD94:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.824097 :C50EFD9C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.832641 :C50EFDA4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.848847 :C50EFDAC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.858344 :C50EFDB4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.874344 :C50EFDBC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.884564 :C50EFDC4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.901066 :C50EFDCC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.916856 :C50EFDD4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.926550 :C50EFDDC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.936317 :C50EFDE4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.952390 :C50EFDEC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.968186 :C50EFDF4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.980696 :C50EFDFC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:01.996534 :C50EFE04:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.006916 :C50EFE0C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.016361 :C50EFE14:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.026130 :C50EFE1C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.035679 :C50EFE24:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.051965 :C50EFE2C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.061885 :C50EFE34:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.069092 :C50EFE3C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.076445 :C50EFE44:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.084036 :C50EFE4C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.091584 :C50EFE54:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.099505 :C50EFE5C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.107952 :C50EFE64:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.117298 :C50EFE6C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.126665 :C50EFE74:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:02.334031*:C50EFE86:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003271A158 estart=1756216801 eid=16777527 ctx=0x00000007831EA738 cwh=0x0000000032760248 cpu=203125 buffg=41668 interb=163840 r=10 rb=163840 w=0 wb=0 2025-08-26 22:00:02.334031*:C50EFE87:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003271A158 curCtx=0x000000005A7D7C98 pubTabIdxCnt=0 2025-08-26 22:00:02.334031*:C50EFE88:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003271A158 2025-08-26 22:00:02.334031*:C50EFE89:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003271A158 2025-08-26 22:00:02.334031*:C50EFE8A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000002DD4C288 estart=1756216800 eid=16777371 ctx=0x000000079F654AA8 cwh=0x000000002DD40158 cpu=1484375 buffg=129346 interb=28049408 r=1434 rb=25747456 w=12 wb=2301952 2025-08-26 22:00:02.334031*:C50EFE8B:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000002DD4C288 curCtx=0x000000005A8C1BD8 pubTabIdxCnt=0 2025-08-26 22:00:02.334031*:C50EFE8C:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000002DD4C288 2025-08-26 22:00:02.334031*:C50EFE8D:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000002DD4C288 2025-08-26 22:00:02.679890*:C50EFFF5:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003271A158 curCtx=0x000000005A7D7C98 xsc->flg4=65792 flags=1 2025-08-26 22:00:02.679890*:C50EFFF6:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003271A158 2025-08-26 22:00:03.297596 :C50F0014:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:03.297935 :C50F001C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:03.297935*:C50F001F:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000002DD4C288 curCtx=0x000000005A8C1BD8 xsc->flg4=65792 flags=2 2025-08-26 22:00:03.297935*:C50F0020:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000002DD4C288 2025-08-26 22:00:03.298206 :C50F0026:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:30:241] atxpop:jslv.c:9203 2025-08-26 22:00:03.302553 :C50F0027:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-26 22:00:03.302634 :C50F002A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:30:241] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-08-26 22:00:03.302717 :C50F0037:db_trace:ksl2.c@12699:ksliwat(): [10005:30:241] 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 30 (osid: 23136, J004)