Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250507220010\orcl_j001_11580_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250507220010\orcl_j001_11580_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:37449M/63366M, Ph+PgF:44899M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 11580, image: ORACLE.EXE (J001) *** 2025-05-07 22:00:10.359 *** SESSION ID:(209.1027) 2025-05-07 22:00:10.359 *** 2025-05-07 22:00:10.359 Process diagnostic dump for ORACLE.EXE (J001), OS id=11580, pid: 26, proc_ser: 188, sid: 209, sess_ser: 1027 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 11580 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=11 seq_num=12 snap_id=1 wait times: snap=0.368675 sec, exc=0.368675 sec, total=0.368675 sec wait times: max=0.500000 sec, heur=5.875852 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.000010 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=10 seq_num=11 snap_id=1 wait times: snap=0.499990 sec, exc=0.499990 sec, total=0.499990 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=9 seq_num=10 snap_id=1 wait times: snap=0.500007 sec, exc=0.500007 sec, total=0.500007 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 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.000007 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.499997 sec, exc=0.499997 sec, total=0.499997 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 snap_id=1 wait times: snap=0.499995 sec, exc=0.499995 sec, total=0.499995 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.500105 sec, exc=0.500105 sec, total=0.500105 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=4 seq_num=5 snap_id=1 wait times: snap=0.510542 sec, exc=0.510542 sec, total=0.510542 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.500002 sec, exc=0.500002 sec, total=0.500002 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=2 seq_num=3 snap_id=1 wait times: snap=0.499973 sec, exc=0.499973 sec, total=0.499973 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.500163 sec, exc=0.500163 sec, total=0.500163 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000013 sec of elapsed time Sampled Session History of session 209 serial 1027 --------------------------------------------------- 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:10] 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-07 22:00:10.359 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 11580, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-05-07 21:57:16.018893 :9411B313:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=8032 pso_num=26 pso_serial#=173 2025-05-07 21:57:16.019038 :9411B314:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=8032 (legacy spawn) 2025-05-07 21:57:16.025510 :9411B315: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-07 21:57:16.025687 :9411B31E: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-07 21:57:16.026524 :9411B31F:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:58:15.274371 :9411C67A:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:58:15.266 2025-05-07 21:58:15.274373 :9411C67B:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10508 pso_num=26 pso_serial#=174 2025-05-07 21:58:15.274506 :9411C67C:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10508 (legacy spawn) 2025-05-07 21:58:15.280892 :9411C67D: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-07 21:58:15.281077 :9411C682: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-07 21:58:15.281848 :9411C687:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:58:15.290492 :9411C6B2:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:58:15.282 2025-05-07 21:58:15.290493 :9411C6B3:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=3616 pso_num=26 pso_serial#=175 2025-05-07 21:58:15.290626 :9411C6B4:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=3616 (legacy spawn) 2025-05-07 21:58:15.297075 :9411C6B5: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-07 21:58:15.297238 :9411C6BE: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-07 21:58:15.298040 :9411C6BF:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:58:16.520018 :9411C71B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:58:16.505 2025-05-07 21:58:16.520020 :9411C71C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11976 pso_num=26 pso_serial#=176 2025-05-07 21:58:16.520168 :9411C71D:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=11976 (legacy spawn) 2025-05-07 21:58:16.526670 :9411C71E: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-07 21:58:16.526849 :9411C727: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-07 21:58:16.527657 :9411C728:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:58:16.536356 :9411C72B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:58:16.521 2025-05-07 21:58:16.536358 :9411C72C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=8172 pso_num=26 pso_serial#=177 2025-05-07 21:58:16.536492 :9411C72D:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=8172 (legacy spawn) 2025-05-07 21:58:16.542952 :9411C740: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-07 21:58:16.543118 :9411C748: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-07 21:58:16.543935 :9411C74A:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:58:18.169332 :9411C7B0:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:58:18.161 2025-05-07 21:58:18.169334 :9411C7B1:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=9476 pso_num=26 pso_serial#=178 2025-05-07 21:58:18.169466 :9411C7B2:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=9476 (legacy spawn) 2025-05-07 21:58:18.175834 :9411C7B3: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-07 21:58:18.176018 :9411C7B8: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-07 21:58:18.176875 :9411C7BD:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:58:19.732014 :9411C86D:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:58:19.718 2025-05-07 21:58:19.732017 :9411C86E:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10284 pso_num=26 pso_serial#=179 2025-05-07 21:58:19.732169 :9411C86F:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10284 (legacy spawn) 2025-05-07 21:58:19.738812 :9411C870: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-07 21:58:19.738974 :9411C875: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-07 21:58:19.739776 :9411C87A:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:58:19.748323 :9411C87D:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:58:19.734 2025-05-07 21:58:19.748325 :9411C87E:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10960 pso_num=26 pso_serial#=180 2025-05-07 21:58:19.748455 :9411C87F:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10960 (legacy spawn) 2025-05-07 21:58:19.754999 :9411C880: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-07 21:58:19.755166 :9411C889: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-07 21:58:19.755954 :9411C88A:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:58:21.461462 :9411C8FB:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:58:21.453 2025-05-07 21:58:21.461464 :9411C8FC:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=8620 pso_num=26 pso_serial#=181 2025-05-07 21:58:21.461600 :9411C8FD:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=8620 (legacy spawn) 2025-05-07 21:58:21.467978 :9411C8FE: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-07 21:58:21.468152 :9411C907: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-07 21:58:21.468953 :9411C908:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:59:20.310691 :9411DCBA:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:59:20.302 2025-05-07 21:59:20.310693 :9411DCBB:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=6652 pso_num=26 pso_serial#=182 2025-05-07 21:59:20.310825 :9411DCBC:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=6652 (legacy spawn) 2025-05-07 21:59:20.317261 :9411DCBD: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-07 21:59:20.317452 :9411DCC6: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-07 21:59:20.318342 :9411DCC7:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:59:29.213878 :9411DF9D:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:59:29.200 2025-05-07 21:59:29.213880 :9411DF9E:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=9744 pso_num=26 pso_serial#=183 2025-05-07 21:59:29.214019 :9411DF9F:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=9744 (legacy spawn) 2025-05-07 21:59:29.220392 :9411DFA0: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-07 21:59:29.220562 :9411DFA6: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-07 21:59:29.221398 :9411DFAA:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:59:29.230028 :9411DFAD:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:59:29.215 2025-05-07 21:59:29.230030 :9411DFAE:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11012 pso_num=26 pso_serial#=184 2025-05-07 21:59:29.230183 :9411DFAF:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=11012 (legacy spawn) 2025-05-07 21:59:29.236617 :9411DFB0: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-07 21:59:29.236782 :9411DFB9: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-07 21:59:29.237605 :9411DFBA:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:59:29.399703 :9411DFBD:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:59:29.387 2025-05-07 21:59:29.399705 :9411DFBE:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=6972 pso_num=26 pso_serial#=185 2025-05-07 21:59:29.399841 :9411DFBF:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=6972 (legacy spawn) 2025-05-07 21:59:29.406433 :9411DFC0: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-07 21:59:29.406600 :9411DFC9: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-07 21:59:29.407404 :9411DFCA:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:59:32.316589 :9411E0B2:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:59:32.304 2025-05-07 21:59:32.316591 :9411E0B3:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=8792 pso_num=26 pso_serial#=186 2025-05-07 21:59:32.316725 :9411E0B4:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=8792 (legacy spawn) 2025-05-07 21:59:32.323166 :9411E0B5: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-07 21:59:32.323343 :9411E0BE: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-07 21:59:32.324158 :9411E0BF:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 21:59:32.342481 :9411E0C2:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 21:59:32.335 2025-05-07 21:59:32.342483 :9411E0C3:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=2804 pso_num=26 pso_serial#=187 2025-05-07 21:59:32.342617 :9411E0C4:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=2804 (legacy spawn) 2025-05-07 21:59:32.348984 :9411E0C5: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-07 21:59:32.349145 :9411E0CE: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-07 21:59:32.349935 :9411E0CF:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-07 22:00:02.055351 :9411EBE2:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-07 22:00:02.044 2025-05-07 22:00:02.055352 :9411EBE3:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11580 pso_num=26 pso_serial#=188 2025-05-07 22:00:02.055487 :9411EBE4:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=11580 osp_idx=24 osp_ver=228922 osp_pg=0 (spawn #158893) 2025-05-07 22:00:02.055488 :9411EBE5: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-07 22:00:02.055488 :9411EBE6:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=177 time=3925979218 2025-05-07 22:00:02.055488 :9411EBE7:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-05-07 22:00:02.055489 :9411EBE8:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-05-07 22:00:02.055489 :9411EBE9:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-05-07 22:00:02.055489 :9411EBEA:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-07 22:00:02.055490 :9411EBEB:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-07 22:00:02.055978 :9411EBEC: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-07 22:00:02.060962 :9411EC0A: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-07 22:00:02.061007 :9411EC0F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-05-07 22:00:02.064655 :9411EC32: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-07 22:00:02.439438 :9411EF53: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-07 22:00:02.483382 :9411EF5B: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-07 22:00:02.499337 :9411EF6B: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-07 22:00:02.556903 :9411EF73: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-07 22:00:02.690694 :9411F07C: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-07 22:00:02.804463 :9411F084: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-07 22:00:02.813668 :9411F08C: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-07 22:00:02.827993 :9411F094: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-07 22:00:02.842073 :9411F09C: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-07 22:00:02.856791 :9411F0A4: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-07 22:00:02.865976 :9411F0AC: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-07 22:00:02.875571 :9411F0B4: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-07 22:00:02.890075 :9411F0BC: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-07 22:00:02.904886 :9411F0C4: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-07 22:00:02.914254 :9411F0CC: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-07 22:00:02.923750 :9411F0D4: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-07 22:00:02.938198 :9411F0DC: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-07 22:00:02.947240 :9411F0E4: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-07 22:00:02.962129 :9411F0EC: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-07 22:00:02.976975 :9411F0F4: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-07 22:00:02.991323 :9411F0FC: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-07 22:00:02.998850 :9411F104: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-07 22:00:03.004142*:9411F10E:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003AD0A188 estart=1746626401 eid=16786930 ctx=0x0000000783637648 cwh=0x00000000291D0068 cpu=15625 buffg=486 interb=114688 r=7 rb=114688 w=0 wb=0 2025-05-07 22:00:03.004142*:9411F111:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003AD0A188 curCtx=0x000000003AC4EB08 pubTabIdxCnt=0 2025-05-07 22:00:03.004142*:9411F112:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003AD0A188 2025-05-07 22:00:03.004142*:9411F113:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003AD0A188 2025-05-07 22:00:03.004142*:9411F114:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000271EC288 estart=1746626401 eid=16777260 ctx=0x000000079F654AA8 cwh=0x00000000271E0158 cpu=921875 buffg=70847 interb=12894208 r=507 rb=10575872 w=12 wb=2318336 2025-05-07 22:00:03.004142*:9411F115:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000271EC288 curCtx=0x000000003AC0EF58 pubTabIdxCnt=0 2025-05-07 22:00:03.004142*:9411F116:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000271EC288 2025-05-07 22:00:03.004142*:9411F117:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000271EC288 2025-05-07 22:00:03.004142*:9411F118:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003AD0A188 curCtx=0x000000003AC4EB08 xsc->flg4=65792 flags=0 2025-05-07 22:00:03.004142*:9411F119:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003AD0A188 2025-05-07 22:00:03.013221 :9411F11A: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-07 22:00:03.022704 :9411F122: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-07 22:00:03.037032 :9411F12A: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-07 22:00:03.045734 :9411F132: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-07 22:00:03.055229 :9411F13A: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-07 22:00:03.069763 :9411F142: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-07 22:00:03.078730 :9411F14A: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-07 22:00:03.093002 :9411F152: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-07 22:00:03.101835 :9411F15A: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-07 22:00:03.111694 :9411F162: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-07 22:00:03.120844 :9411F16A: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-07 22:00:03.135676 :9411F172: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-07 22:00:03.149970 :9411F17A: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-07 22:00:03.159226 :9411F182: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-07 22:00:03.173277 :9411F18A: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-07 22:00:03.187832 :9411F192: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-07 22:00:03.196759 :9411F1A6: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-07 22:00:03.205790 :9411F1AE: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-07 22:00:03.219969 :9411F1B6: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-07 22:00:03.229834 :9411F1BE: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-07 22:00:03.238672 :9411F1C6: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-07 22:00:03.247813 :9411F1CE: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-07 22:00:03.262245 :9411F1D6: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-07 22:00:03.274289 :9411F1DE: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-07 22:00:03.283634 :9411F1E6: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-07 22:00:03.290630 :9411F1EE: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-07 22:00:03.297640 :9411F1F6: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-07 22:00:03.304803 :9411F1FE: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-07 22:00:03.311870 :9411F206: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-07 22:00:03.319478 :9411F20E: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-07 22:00:03.326752 :9411F216: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-07 22:00:03.334077 :9411F21E: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-07 22:00:03.341219 :9411F226: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-07 22:00:03.348360 :9411F22E: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-07 22:00:04.439035 :9411F515: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-07 22:00:04.441918 :9411F51D: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-07 22:00:04.442168 :9411F525: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-07 22:00:04.449586 :9411F52D: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-07 22:00:04.457142 :9411F535: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-07 22:00:04.464725 :9411F53D: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-07 22:00:04.472071 :9411F545: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-07 22:00:04.480299 :9411F558: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-07 22:00:04.480608 :9411F560: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-07 22:00:04.480608*:9411F563:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000271EC288 curCtx=0x000000003AC0EF58 xsc->flg4=65792 flags=2 2025-05-07 22:00:04.480608*:9411F564:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000271EC288 2025-05-07 22:00:04.480853 :9411F56A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-05-07 22:00:04.485277 :9411F56B: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-07 22:00:04.485367 :9411F56E: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-07 22:00:04.485477 :9411F57B: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: 11580, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de