Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250530220006\orcl_j001_14664_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250530220006\orcl_j001_14664_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:37248M/63366M, Ph+PgF:44150M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 14664, image: ORACLE.EXE (J001) *** 2025-05-30 22:00:06.583 *** SESSION ID:(209.6311) 2025-05-30 22:00:06.583 *** 2025-05-30 22:00:06.583 Process diagnostic dump for ORACLE.EXE (J001), OS id=14664, pid: 26, proc_ser: 217, sid: 209, sess_ser: 6311 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 14664 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 snap_id=1 wait times: snap=0.195599 sec, exc=0.195599 sec, total=0.195599 sec wait times: max=0.500000 sec, heur=2.205144 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=3 seq_num=4 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.000012 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 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.000008 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.500000 sec, exc=0.500000 sec, total=0.500000 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.509515 sec, exc=0.509515 sec, total=0.509515 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000000 sec of elapsed time Sampled Session History of session 209 serial 6311 --------------------------------------------------- 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 --------------------------------------------------- [3 samples, 22:00:04 - 22:00:06] 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-30 22:00:06.583 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 14664, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-05-30 21:57:25.371680 :9E2B9FFF:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:57:25.371861 :9E2BA004: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-30 21:57:25.372652 :9E2BA009:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:57:25.391872 :9E2BA00C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:57:25.383 2025-05-30 21:57:25.391874 :9E2BA00D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10700 pso_num=26 pso_serial#=202 2025-05-30 21:57:25.392012 :9E2BA00E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10700 (legacy spawn) 2025-05-30 21:57:25.398448 :9E2BA00F:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:57:25.398632 :9E2BA018: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-30 21:57:25.399432 :9E2BA019:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:57:38.065898 :9E2BA40C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:57:38.053 2025-05-30 21:57:38.065900 :9E2BA40D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12756 pso_num=26 pso_serial#=203 2025-05-30 21:57:38.066040 :9E2BA40E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12756 (legacy spawn) 2025-05-30 21:57:38.072562 :9E2BA40F:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:57:38.072734 :9E2BA414: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-30 21:57:38.073539 :9E2BA419:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:57:46.602156 :9E2BA6A1:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:57:46.593 2025-05-30 21:57:46.602158 :9E2BA6A2:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10512 pso_num=26 pso_serial#=204 2025-05-30 21:57:46.602295 :9E2BA6A3:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10512 (legacy spawn) 2025-05-30 21:57:46.608687 :9E2BA6A4:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:57:46.608898 :9E2BA6A9: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-30 21:57:46.609725 :9E2BA6AE:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:58:22.409168 :9E2BB29B:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:58:22.401 2025-05-30 21:58:22.409170 :9E2BB29C:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=13812 pso_num=26 pso_serial#=205 2025-05-30 21:58:22.409308 :9E2BB29D:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=13812 (legacy spawn) 2025-05-30 21:58:22.415698 :9E2BB29E:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:58:22.415863 :9E2BB2A3: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-30 21:58:22.416672 :9E2BB2A8:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:58:34.867133 :9E2BB68A:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:58:34.864 2025-05-30 21:58:34.867135 :9E2BB68B:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14916 pso_num=26 pso_serial#=206 2025-05-30 21:58:34.867273 :9E2BB68C:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14916 (legacy spawn) 2025-05-30 21:58:34.873730 :9E2BB68D:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:58:34.873912 :9E2BB692: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-30 21:58:34.874717 :9E2BB697:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:58:34.883392 :9E2BB69A:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:58:34.879 2025-05-30 21:58:34.883394 :9E2BB69B:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10388 pso_num=26 pso_serial#=207 2025-05-30 21:58:34.883527 :9E2BB69C:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10388 (legacy spawn) 2025-05-30 21:58:34.890015 :9E2BB69D:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:58:34.890178 :9E2BB6A6: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-30 21:58:34.890957 :9E2BB6A7:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:58:37.975668 :9E2BB7B0:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:58:37.962 2025-05-30 21:58:37.975670 :9E2BB7B1:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14968 pso_num=26 pso_serial#=208 2025-05-30 21:58:37.975814 :9E2BB7B2:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14968 (legacy spawn) 2025-05-30 21:58:37.982352 :9E2BB7B3:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:58:37.982521 :9E2BB7B8: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-30 21:58:37.983310 :9E2BB7BD:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:58:38.001100 :9E2BB7C0:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:58:37.993 2025-05-30 21:58:38.001101 :9E2BB7C1:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=11564 pso_num=26 pso_serial#=209 2025-05-30 21:58:38.001235 :9E2BB7C2:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=11564 (legacy spawn) 2025-05-30 21:58:38.007677 :9E2BB7C3:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:58:38.007837 :9E2BB7CC: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-30 21:58:38.008623 :9E2BB7CD:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:58:40.251790 :9E2BB879:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:58:40.251 2025-05-30 21:58:40.251792 :9E2BB87A:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14740 pso_num=26 pso_serial#=210 2025-05-30 21:58:40.251933 :9E2BB87B:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14740 (legacy spawn) 2025-05-30 21:58:40.258398 :9E2BB87C:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:58:40.258577 :9E2BB881: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-30 21:58:40.259383 :9E2BB886:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:59:29.077382 :9E2BC849:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:59:29.069 2025-05-30 21:59:29.077384 :9E2BC84A:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10856 pso_num=26 pso_serial#=211 2025-05-30 21:59:29.077520 :9E2BC84B:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10856 (legacy spawn) 2025-05-30 21:59:29.084080 :9E2BC84C:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:59:29.084244 :9E2BC851: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-30 21:59:29.085062 :9E2BC856:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:59:42.426161 :9E2BCC46:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:59:42.413 2025-05-30 21:59:42.426163 :9E2BCC47:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14872 pso_num=26 pso_serial#=212 2025-05-30 21:59:42.426351 :9E2BCC48:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14872 (legacy spawn) 2025-05-30 21:59:42.432851 :9E2BCC49:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:59:42.433039 :9E2BCC51: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-30 21:59:42.433850 :9E2BCC53:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:59:47.460003 :9E2BCE14:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:59:47.446 2025-05-30 21:59:47.460005 :9E2BCE15:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=12232 pso_num=26 pso_serial#=213 2025-05-30 21:59:47.460147 :9E2BCE16:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=12232 (legacy spawn) 2025-05-30 21:59:47.466632 :9E2BCE17:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:59:47.466664 :9E2BCE1A:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:59:47.466834 :9E2BCE1D: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-30 21:59:47.467605 :9E2BCE2E:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:59:47.476233 :9E2BCE31:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:59:47.461 2025-05-30 21:59:47.476236 :9E2BCE32:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=15036 pso_num=26 pso_serial#=214 2025-05-30 21:59:47.476365 :9E2BCE33:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=15036 (legacy spawn) 2025-05-30 21:59:47.482823 :9E2BCE34:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:59:47.482984 :9E2BCE3D: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-30 21:59:47.483766 :9E2BCE3E:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:59:50.734520 :9E2BCF2C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:59:50.721 2025-05-30 21:59:50.734522 :9E2BCF2D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14868 pso_num=26 pso_serial#=215 2025-05-30 21:59:50.734663 :9E2BCF2E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14868 (legacy spawn) 2025-05-30 21:59:50.741182 :9E2BCF2F:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:59:50.741355 :9E2BCF34: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-30 21:59:50.742165 :9E2BCF39:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 21:59:50.761485 :9E2BCF3C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 21:59:50.753 2025-05-30 21:59:50.761487 :9E2BCF3D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=1880 pso_num=26 pso_serial#=216 2025-05-30 21:59:50.761630 :9E2BCF3E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=1880 (legacy spawn) 2025-05-30 21:59:50.768203 :9E2BCF3F:db_trace:ksl2.c@14083:ksl_update_post_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-30 21:59:50.768371 :9E2BCF48: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-30 21:59:50.769216 :9E2BCF49:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-05-30 22:00:01.972094 :9E2BD465:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 05-30 22:00:01.960 2025-05-30 22:00:01.972096 :9E2BD466:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14664 pso_num=26 pso_serial#=217 2025-05-30 22:00:01.972227 :9E2BD467:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=14664 osp_idx=24 osp_ver=362317 osp_pg=0 (spawn #235807) 2025-05-30 22:00:01.972227 :9E2BD468: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-30 22:00:01.972228 :9E2BD469:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=170 time=1618160610 2025-05-30 22:00:01.972228 :9E2BD46A:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-05-30 22:00:01.972228 :9E2BD46B:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-05-30 22:00:01.972229 :9E2BD46C:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-05-30 22:00:01.972229 :9E2BD46D:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-30 22:00:01.972229 :9E2BD46E:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-30 22:00:01.972710 :9E2BD46F: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-30 22:00:01.977895 :9E2BD48F:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:01.977936 :9E2BD492:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-05-30 22:00:01.981294 :9E2BD4B5:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.362454 :9E2BD816:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.406019 :9E2BD81E:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.421781 :9E2BD826:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.478753 :9E2BD836:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.610934 :9E2BD846:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.725092 :9E2BD84E:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.734663 :9E2BD856:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.749794 :9E2BD85E:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.764429 :9E2BD866:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.779622 :9E2BD86E:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.789011 :9E2BD876:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.798368 :9E2BD87E:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.813131 :9E2BD886:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.827995 :9E2BD88E:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.837629 :9E2BD896:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.846943 :9E2BD89E:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.861583 :9E2BD8A6:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.870991 :9E2BD8AE:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.886209 :9E2BD8B6:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.901267 :9E2BD8BE:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.916028 :9E2BD8C6:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.930949 :9E2BD8DA:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.940641 :9E2BD8E2:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.955568 :9E2BD8EA:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.964641 :9E2BD8F2:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.974308 :9E2BD8FA:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.989239 :9E2BD902:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:02.998785 :9E2BD90A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.007895 :9E2BD912:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.022626 :9E2BD91A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.029691 :9E2BD922:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.039458 :9E2BD92A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.054375 :9E2BD932:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.069405 :9E2BD93A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.079382 :9E2BD945:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.088984 :9E2BD95A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.103994 :9E2BD962:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.119267 :9E2BD96A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.129195 :9E2BD972:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.139174 :9E2BD97A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.154421 :9E2BD995:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.164455 :9E2BD99D:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.174132 :9E2BD9A5:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.189756 :9E2BD9AD:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.199398 :9E2BD9B5:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.206661 :9E2BD9BD:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.214209 :9E2BD9C5:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.221914 :9E2BD9CD:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.229601 :9E2BD9D5:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.237461 :9E2BD9DD:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.245954 :9E2BD9E5:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.253869 :9E2BD9ED:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.261642 :9E2BD9F5:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:03.460790*:9E2BDA07:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000291D6918 estart=1748613602 eid=16777351 ctx=0x00000007831EA738 cwh=0x0000000029200248 cpu=203125 buffg=42402 interb=163840 r=10 rb=163840 w=0 wb=0 2025-05-30 22:00:03.460790*:9E2BDA08:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000291D6918 curCtx=0x0000000040FCDD48 pubTabIdxCnt=0 2025-05-30 22:00:03.460790*:9E2BDA09:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000291D6918 2025-05-30 22:00:03.460790*:9E2BDA0A:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000291D6918 2025-05-30 22:00:03.460790*:9E2BDA0B:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000271EC288 estart=1748613601 eid=16777283 ctx=0x000000079F654AA8 cwh=0x00000000271E0158 cpu=1453125 buffg=129296 interb=27590656 r=1406 rb=25288704 w=12 wb=2301952 2025-05-30 22:00:03.460790*:9E2BDA0C:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000271EC288 curCtx=0x0000000040F51DD0 pubTabIdxCnt=0 2025-05-30 22:00:03.460790*:9E2BDA0D:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000271EC288 2025-05-30 22:00:03.460790*:9E2BDA0E:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000271EC288 2025-05-30 22:00:03.803987*:9E2BDB2A:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000291D6918 curCtx=0x0000000040FCDD48 xsc->flg4=65792 flags=1 2025-05-30 22:00:03.803987*:9E2BDB2B:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000291D6918 2025-05-30 22:00:04.347480 :9E2BDC6A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:04.349934 :9E2BDC72:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:04.350171 :9E2BDC7A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:04.357860 :9E2BDC82:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:04.365226 :9E2BDC8A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:04.373478 :9E2BDC92:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:04.373823 :9E2BDC9A:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:04.373823*:9E2BDCA1:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000271EC288 curCtx=0x0000000040F51DD0 xsc->flg4=65792 flags=2 2025-05-30 22:00:04.373823*:9E2BDCA2:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000271EC288 2025-05-30 22:00:04.374083 :9E2BDCA3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-05-30 22:00:04.378456 :9E2BDCA4:db_trace:ksl2.c@14083:ksl_update_post_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-30 22:00:04.378543 :9E2BDCA7: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-30 22:00:04.378624 :9E2BDCB4: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: 14664, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de