Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250515220008\orcl_j001_11936_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250515220008\orcl_j001_11936_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:37399M/63366M, Ph+PgF:44661M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 11936, image: ORACLE.EXE (J001) *** 2025-05-15 22:00:08.934 *** SESSION ID:(209.27949) 2025-05-15 22:00:08.934 *** 2025-05-15 22:00:08.934 Process diagnostic dump for ORACLE.EXE (J001), OS id=11936, pid: 26, proc_ser: 141, sid: 209, sess_ser: 27949 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 11936 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=12 seq_num=13 snap_id=1 wait times: snap=0.413547 sec, exc=0.413547 sec, total=0.413547 sec wait times: max=0.500000 sec, heur=6.266865 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.000007 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=11 seq_num=12 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 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=10 seq_num=11 snap_id=1 wait times: snap=0.499999 sec, exc=0.499999 sec, total=0.499999 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=9 seq_num=10 snap_id=1 wait times: snap=0.504576 sec, exc=0.504576 sec, total=0.504576 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000015 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=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.000011 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.499999 sec, exc=0.499999 sec, total=0.499999 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 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.000015 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.499993 sec, exc=0.499993 sec, total=0.499993 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 snap_id=1 wait times: snap=0.500006 sec, exc=0.500006 sec, total=0.500006 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.508194 sec, exc=0.508194 sec, total=0.508194 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000005 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.355741 sec, exc=0.355741 sec, total=0.355741 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time Sampled Session History of session 209 serial 27949 --------------------------------------------------- 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 --------------------------------------------------- [7 samples, 22:00:02 - 22:00:08] idle wait at each sample [session created at: 22:00:02] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-05-15 22:00:08.934 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 11936, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-05-15 21:57:08.860293 :9791EEC3:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=9944 (legacy spawn) 2025-05-15 21:57:08.866807 :9791EEC4:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:57:08.866980 :9791EEC9: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-15 21:57:08.867805 :9791EECE:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:57:15.036903 :9791F0B1:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:57:15.027 2025-05-15 21:57:15.036906 :9791F0B2:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10492 pso_num=26 pso_serial#=127 2025-05-15 21:57:15.037051 :9791F0B3:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10492 (legacy spawn) 2025-05-15 21:57:15.043776 :9791F0B4:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:57:15.043951 :9791F0B9: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-15 21:57:15.044797 :9791F0BE:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:57:19.009797 :9791F214:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:57:18.996 2025-05-15 21:57:19.009799 :9791F215:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=9584 pso_num=26 pso_serial#=128 2025-05-15 21:57:19.009935 :9791F216:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=9584 (legacy spawn) 2025-05-15 21:57:19.016340 :9791F217:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:57:19.016518 :9791F21C: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-15 21:57:19.017315 :9791F221:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:57:19.025892 :9791F224:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:57:19.011 2025-05-15 21:57:19.025894 :9791F225:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=9580 pso_num=26 pso_serial#=129 2025-05-15 21:57:19.026031 :9791F226:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=9580 (legacy spawn) 2025-05-15 21:57:19.032478 :9791F227:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:57:19.032642 :9791F22E: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-15 21:57:19.033449 :9791F231:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:57:22.122611 :9791F32C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:57:22.110 2025-05-15 21:57:22.122612 :9791F32D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12104 pso_num=26 pso_serial#=130 2025-05-15 21:57:22.122749 :9791F32E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12104 (legacy spawn) 2025-05-15 21:57:22.129192 :9791F32F:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:57:22.129383 :9791F334: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-15 21:57:22.130204 :9791F339:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:57:22.138836 :9791F33C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:57:22.125 2025-05-15 21:57:22.138838 :9791F33D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=4460 pso_num=26 pso_serial#=131 2025-05-15 21:57:22.138968 :9791F33E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=4460 (legacy spawn) 2025-05-15 21:57:22.145487 :9791F33F:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:57:22.145661 :9791F348: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-15 21:57:22.146436 :9791F349:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:57:28.434599 :9791F53C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:57:28.426 2025-05-15 21:57:28.434602 :9791F53D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11568 pso_num=26 pso_serial#=132 2025-05-15 21:57:28.434738 :9791F53E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=11568 (legacy spawn) 2025-05-15 21:57:28.461336 :9791F53F:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:57:28.461511 :9791F544: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-15 21:57:28.462343 :9791F549:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:58:02.581088 :979200E9:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:58:02.572 2025-05-15 21:58:02.581091 :979200EA:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11976 pso_num=26 pso_serial#=133 2025-05-15 21:58:02.581224 :979200EB:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=11976 (legacy spawn) 2025-05-15 21:58:02.587774 :979200EC:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:58:02.587957 :979200F1: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-15 21:58:02.588736 :979200F6:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:58:11.074894 :979203A9:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:58:11.066 2025-05-15 21:58:11.074896 :979203AA:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13272 pso_num=26 pso_serial#=134 2025-05-15 21:58:11.075026 :979203AB:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13272 (legacy spawn) 2025-05-15 21:58:11.081471 :979203AC:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:58:11.081642 :979203B1: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-15 21:58:11.082532 :979203C1:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:59:08.489585 :979216A0:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:59:08.486 2025-05-15 21:59:08.489587 :979216A1:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=5912 pso_num=26 pso_serial#=135 2025-05-15 21:59:08.489729 :979216A2:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=5912 (legacy spawn) 2025-05-15 21:59:08.496106 :979216A3:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:59:08.496142 :979216A6:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:59:08.496304 :979216A9: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-15 21:59:08.497092 :979216BA:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:59:08.505820 :979216BD:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:59:08.502 2025-05-15 21:59:08.505822 :979216BE:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12136 pso_num=26 pso_serial#=136 2025-05-15 21:59:08.505958 :979216BF:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12136 (legacy spawn) 2025-05-15 21:59:08.522426 :979216C0:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:59:08.522585 :979216C9: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-15 21:59:08.523392 :979216CA:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:59:10.896719 :9792175C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:59:10.887 2025-05-15 21:59:10.896721 :9792175D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=4696 pso_num=26 pso_serial#=137 2025-05-15 21:59:10.896856 :9792175E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=4696 (legacy spawn) 2025-05-15 21:59:10.903342 :9792175F:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:59:10.903514 :97921764: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-15 21:59:10.904402 :97921769:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:59:11.619432 :979217D5:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:59:11.606 2025-05-15 21:59:11.619434 :979217D6:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13132 pso_num=26 pso_serial#=138 2025-05-15 21:59:11.619570 :979217D7:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13132 (legacy spawn) 2025-05-15 21:59:11.626105 :979217D8:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:59:11.626281 :979217E1: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-15 21:59:11.627134 :979217E2:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:59:11.636125 :979217E5:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:59:11.622 2025-05-15 21:59:11.636127 :979217E6:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12360 pso_num=26 pso_serial#=139 2025-05-15 21:59:11.636268 :979217E7:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12360 (legacy spawn) 2025-05-15 21:59:11.642830 :979217E8:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:59:11.643022 :979217F0: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-15 21:59:11.643858 :979217F2:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 21:59:13.285528 :97921872:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 21:59:13.277 2025-05-15 21:59:13.285530 :97921873:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=7792 pso_num=26 pso_serial#=140 2025-05-15 21:59:13.285666 :97921874:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=7792 (legacy spawn) 2025-05-15 21:59:13.292077 :97921875:db_trace:ksl2.c@14083:ksl_update_post_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-15 21:59:13.292253 :9792187A: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-15 21:59:13.293112 :9792187F:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-15 22:00:00.723110 :97922987:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-15 22:00:00.712 2025-05-15 22:00:00.723113 :97922988:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11936 pso_num=26 pso_serial#=141 2025-05-15 22:00:00.723301 :97922989:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=11936 osp_idx=24 osp_ver=275030 osp_pg=0 (spawn #185823) 2025-05-15 22:00:00.723302 :9792298A: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-15 22:00:00.723302 :9792298B:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=90 time=322210594 2025-05-15 22:00:00.723303 :9792298C:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-05-15 22:00:00.723303 :9792298D:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-05-15 22:00:00.723303 :9792298E:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-05-15 22:00:00.723304 :9792298F:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-15 22:00:00.723304 :97922990:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-15 22:00:00.723800 :97922991: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-15 22:00:00.728826 :979229B0:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:00.728871 :979229B3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-05-15 22:00:00.733647 :979229CF:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=28 loc='kcb2.h LINE:3844 ID:kcbzww' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-05-15 22:00:00.969748 :97922F4D:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:01.169868 :97922F6A:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:01.301528 :97922F8A:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.415233 :979231BA:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.416228 :979231C2:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.420338 :979231CA:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.422865 :979231D2:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.424335 :979231DA:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.427554 :979231E2:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.429050 :979231EA:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.433500 :979231F2:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.451686 :979231FA:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.452337 :97923202:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.452879 :9792320A:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.453389 :97923212:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.456093 :9792321A:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.457001 :97923222:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.457807 :97923223:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.458604 :97923224:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.459038 :97923225:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.459045 :97923226:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.459636 :97923227:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.460146 :97923228:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.460454 :97923229:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.461566 :9792322A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.503464 :97923233:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.503518 :97923236:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.504497 :9792323C:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.505399 :97923244:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.505835 :97923245:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.525915 :97923284:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.525967 :97923287:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.526899 :9792328D:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.538798 :97923295:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.539336 :97923296:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.559615 :9792329E:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.559666 :979232A1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.560582 :979232A7:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.561435 :979232AF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.561874 :979232B0:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.579448 :979232B8:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.579500 :979232BB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.580381 :979232C1:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.581276 :979232C9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.581886 :979232CA:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.603699 :979232D2:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.603751 :979232D5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.604665 :979232DB:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.605550 :979232E3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.606035 :979232E4:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.625818 :979232EC:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.625866 :979232EF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.626728 :979232F5:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.628059*:97923303:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000291A0188 estart=1747317601 eid=16777331 ctx=0x000000077F5E50D8 cwh=0x000000002B4FBC80 cpu=15625 buffg=18 interb=0 r=0 rb=0 w=0 wb=0 2025-05-15 22:00:02.628059*:97923308:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000291A0188 curCtx=0x000000002B507B40 pubTabIdxCnt=0 2025-05-15 22:00:02.628059*:9792330B:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000291A0188 2025-05-15 22:00:02.628059*:9792330E:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000291A0188 2025-05-15 22:00:02.628059*:97923334:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000291A0188 curCtx=0x000000002B507B40 xsc->flg4=65792 flags=1 2025-05-15 22:00:02.628059*:97923335:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000291A0188 2025-05-15 22:00:02.638537 :9792333A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:psdpgi.c:2235 2025-05-15 22:00:02.639046 :9792333B:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.665841 :9792334D:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.665888 :97923350:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:psdpgi.c:2235 2025-05-15 22:00:02.666763 :97923356:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.667165 :9792335E:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.667513 :97923366:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.667719 :9792336E:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.667851 :97923376:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.668009 :9792337E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-05-15 22:00:02.671832 :9792337F:db_trace:ksl2.c@14083:ksl_update_post_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-15 22:00:02.671914 :97923382: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-15 22:00:02.671987 :9792338E: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-15 22:00:04.014930 :97923517:db_trace:ksl2.c@12699:ksliwat(): [10005:26:209] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 26 (osid: 11936, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de