Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250906060008\orcl_j001_21748_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250906060008\orcl_j001_21748_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:35010M/63366M, Ph+PgF:39851M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 21748, image: ORACLE.EXE (J001) *** 2025-09-06 06:00:08.985 *** SESSION ID:(209.35403) 2025-09-06 06:00:08.985 *** 2025-09-06 06:00:08.985 Process diagnostic dump for ORACLE.EXE (J001), OS id=21748, pid: 26, proc_ser: 181, sid: 209, sess_ser: 35403 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 21748 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.401330 sec, exc=0.401330 sec, total=0.401330 sec wait times: max=0.500000 sec, heur=5.901976 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.000008 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.503164 sec, exc=0.503164 sec, total=0.503164 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.500010 sec, exc=0.500010 sec, total=0.500010 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.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.000013 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.500001 sec, exc=0.500001 sec, total=0.500001 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 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.499996 sec, exc=0.499996 sec, total=0.499996 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.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.500092 sec, exc=0.500092 sec, total=0.500092 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000016 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.500028 sec, exc=0.500028 sec, total=0.500028 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 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.500003 sec, exc=0.500003 sec, total=0.500003 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 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.502937 sec, exc=0.502937 sec, total=0.502937 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 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.499989 sec, exc=0.499989 sec, total=0.499989 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time Sampled Session History of session 209 serial 35403 --------------------------------------------------- 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, 06:00:03 - 06:00:08] idle wait at each sample [session created at: 06:00:03] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-09-06 06:00:08.985 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 21748, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-09-06 05:57:35.721026 :C9A4218B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:57:35.729887 :C9A4218E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:57:35.726 2025-09-06 05:57:35.729889 :C9A4218F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=22836 pso_num=26 pso_serial#=165 2025-09-06 05:57:35.730032 :C9A42190:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=22836 (legacy spawn) 2025-09-06 05:57:35.736500 :C9A42191:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:57:35.736668 :C9A4219A: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-09-06 05:57:35.737450 :C9A4219B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:57:38.886667 :C9A42288:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:57:38.871 2025-09-06 05:57:38.886669 :C9A42289:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=22724 pso_num=26 pso_serial#=166 2025-09-06 05:57:38.886810 :C9A4228A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=22724 (legacy spawn) 2025-09-06 05:57:38.905247 :C9A4228B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:57:38.905463 :C9A42290: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-09-06 05:57:38.906430 :C9A42295:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:57:38.916024 :C9A42298:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:57:38.903 2025-09-06 05:57:38.916026 :C9A42299:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=20088 pso_num=26 pso_serial#=167 2025-09-06 05:57:38.916184 :C9A4229A:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=20088 (legacy spawn) 2025-09-06 05:57:38.923363 :C9A4229B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:57:38.923541 :C9A422A4: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-09-06 05:57:38.924503 :C9A422A5:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:58:12.212623 :C9A42D57:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:58:12.205 2025-09-06 05:58:12.212625 :C9A42D58:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=19060 pso_num=26 pso_serial#=168 2025-09-06 05:58:12.212762 :C9A42D59:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=19060 (legacy spawn) 2025-09-06 05:58:12.219255 :C9A42D5A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:58:12.219433 :C9A42D5F: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-09-06 05:58:12.220241 :C9A42D64:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:58:12.228986 :C9A42D67:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:58:12.221 2025-09-06 05:58:12.228988 :C9A42D68:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=24256 pso_num=26 pso_serial#=169 2025-09-06 05:58:12.229122 :C9A42D69:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=24256 (legacy spawn) 2025-09-06 05:58:12.235643 :C9A42D6A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:58:12.235803 :C9A42D73: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-09-06 05:58:12.236624 :C9A42D74:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:58:15.384632 :C9A42E73:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:58:15.372 2025-09-06 05:58:15.384635 :C9A42E74:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=21212 pso_num=26 pso_serial#=170 2025-09-06 05:58:15.384774 :C9A42E75:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=21212 (legacy spawn) 2025-09-06 05:58:15.391314 :C9A42E76:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:58:15.391344 :C9A42E79:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:58:15.391510 :C9A42E7C: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-09-06 05:58:15.392309 :C9A42E8D:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:58:15.400981 :C9A42E90:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:58:15.387 2025-09-06 05:58:15.400983 :C9A42E91:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=18812 pso_num=26 pso_serial#=171 2025-09-06 05:58:15.401121 :C9A42E92:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=18812 (legacy spawn) 2025-09-06 05:58:15.420145 :C9A42E93:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:58:15.420322 :C9A42E9C: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-09-06 05:58:15.421273 :C9A42E9D:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:58:23.535356 :C9A4314F:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:58:23.527 2025-09-06 05:58:23.535358 :C9A43150:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=6364 pso_num=26 pso_serial#=172 2025-09-06 05:58:23.535494 :C9A43151:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=6364 (legacy spawn) 2025-09-06 05:58:23.542025 :C9A43152:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:58:23.542200 :C9A43157: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-09-06 05:58:23.543066 :C9A4315C:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:58:26.030417 :C9A43241:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:58:26.022 2025-09-06 05:58:26.030419 :C9A43242:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=10356 pso_num=26 pso_serial#=173 2025-09-06 05:58:26.030560 :C9A43243:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=10356 (legacy spawn) 2025-09-06 05:58:26.037107 :C9A43244:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:58:26.037282 :C9A43249: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-09-06 05:58:26.038098 :C9A4324E:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:58:31.758672 :C9A433A9:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:58:31.746 2025-09-06 05:58:31.758674 :C9A433AA:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=19388 pso_num=26 pso_serial#=174 2025-09-06 05:58:31.758809 :C9A433AB:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=19388 (legacy spawn) 2025-09-06 05:58:31.765313 :C9A433AC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:58:31.765489 :C9A433B1: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-09-06 05:58:31.766266 :C9A433B6:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:59:24.902801 :C9A44503:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:59:24.888 2025-09-06 05:59:24.902803 :C9A44504:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=24036 pso_num=26 pso_serial#=175 2025-09-06 05:59:24.902938 :C9A44505:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=24036 (legacy spawn) 2025-09-06 05:59:24.909425 :C9A44506:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:59:24.909598 :C9A4450F: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-09-06 05:59:24.910486 :C9A44510:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:59:24.919169 :C9A44513:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:59:24.904 2025-09-06 05:59:24.919172 :C9A44514:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=22916 pso_num=26 pso_serial#=176 2025-09-06 05:59:24.919307 :C9A44515:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=22916 (legacy spawn) 2025-09-06 05:59:24.925828 :C9A44516:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:59:24.925997 :C9A4451F: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-09-06 05:59:24.926795 :C9A44520:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:59:25.693784 :C9A4453C:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:59:25.685 2025-09-06 05:59:25.693786 :C9A4453D:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=21876 pso_num=26 pso_serial#=177 2025-09-06 05:59:25.693928 :C9A4453E:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=21876 (legacy spawn) 2025-09-06 05:59:25.700460 :C9A4453F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:59:25.700633 :C9A44544: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-09-06 05:59:25.701493 :C9A44549:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:59:28.120113 :C9A44622:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:59:28.117 2025-09-06 05:59:28.120115 :C9A44623:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=14152 pso_num=26 pso_serial#=178 2025-09-06 05:59:28.120253 :C9A44624:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=14152 (legacy spawn) 2025-09-06 05:59:28.126719 :C9A44625:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:59:28.126891 :C9A4462E: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-09-06 05:59:28.127706 :C9A4462F:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:59:28.136520 :C9A44632:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:59:28.133 2025-09-06 05:59:28.136522 :C9A44633:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=23944 pso_num=26 pso_serial#=179 2025-09-06 05:59:28.136666 :C9A44634:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=23944 (legacy spawn) 2025-09-06 05:59:28.143124 :C9A44635:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:59:28.143302 :C9A4463E: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-09-06 05:59:28.144140 :C9A4463F:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 05:59:33.777390 :C9A447D5:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 05:59:33.767 2025-09-06 05:59:33.777392 :C9A447D6:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=21856 pso_num=26 pso_serial#=180 2025-09-06 05:59:33.777528 :C9A447D7:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=21856 (legacy spawn) 2025-09-06 05:59:33.783978 :C9A447D8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 05:59:33.784168 :C9A447DD: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-09-06 05:59:33.784952 :C9A447E2:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-06 06:00:00.572768 :C9A451D5:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-06 06:00:00.562 2025-09-06 06:00:00.572769 :C9A451D6:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=21748 pso_num=26 pso_serial#=181 2025-09-06 06:00:00.572903 :C9A451D7:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=21748 osp_idx=24 osp_ver=802166 osp_pg=0 (spawn #563600) 2025-09-06 06:00:00.572904 :C9A451D8:db_trace:kso.c@4099:ksonfy(): [10420:26:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-09-06 06:00:00.572904 :C9A451D9:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=8 time=1524051877 2025-09-06 06:00:00.572905 :C9A451DA:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-09-06 06:00:00.572905 :C9A451DB:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-09-06 06:00:00.572906 :C9A451DC:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-09-06 06:00:00.572906 :C9A451DD:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-06 06:00:00.572907 :C9A451DE:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-06 06:00:00.573376 :C9A451DF: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-09-06 06:00:00.578558 :C9A45207:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:00.578596 :C9A4520A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-09-06 06:00:00.581898 :C9A45225:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:00.961502 :C9A455B7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.007595 :C9A455BF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.024538 :C9A455C7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.082588 :C9A455D7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.216289 :C9A455FF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.331947 :C9A45607:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.342029 :C9A4560F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.358098 :C9A45617:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.373580 :C9A4561F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.389886 :C9A45627:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.399757 :C9A4562F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.410035 :C9A45637:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.427033 :C9A4563F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.443951 :C9A45647:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.455021 :C9A4564F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.465892 :C9A45657:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.482805 :C9A4565F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.493249 :C9A45667:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.510468 :C9A4566F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.526875 :C9A45677:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.543173 :C9A4567F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.558983 :C9A45687:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.569103 :C9A4568F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.579501 :C9A45697:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.595306 :C9A4569F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.604983 :C9A456A7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.615388 :C9A456AF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.631561 :C9A456B7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.641164 :C9A456BF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.656979 :C9A456C7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.664247 :C9A456CF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.674646 :C9A456D7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.690848 :C9A456DF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.706888 :C9A456E7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.716613 :C9A456EF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.726988 :C9A45703:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.742882 :C9A4570B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.759068 :C9A45713:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.769118 :C9A4571B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.785005 :C9A45723:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.795252 :C9A4572B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.806162 :C9A45733:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.816593 :C9A4573B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.829308 :C9A45743:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.846079 :C9A4574B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.856604 :C9A45753:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.864487 :C9A4575B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.872417 :C9A45763:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.880359 :C9A4576B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.888214 :C9A45773:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.896036 :C9A4577B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.904157 :C9A45783:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.912203 :C9A4578B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:01.920164 :C9A45793:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:02.280654*:C9A4588A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000299C6918 estart=1757109601 eid=16777549 ctx=0x00000007831EA738 cwh=0x00000000299F0248 cpu=359375 buffg=54964 interb=2301952 r=15 rb=892928 w=6 wb=1409024 2025-09-06 06:00:02.280654*:C9A4588B:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000299C6918 curCtx=0x000000005D5ECC88 pubTabIdxCnt=0 2025-09-06 06:00:02.280654*:C9A4588D:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000299C6918 2025-09-06 06:00:02.280654*:C9A4588E:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000299C6918 2025-09-06 06:00:02.280654*:C9A4588F:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028BBC288 estart=1757109600 eid=16777382 ctx=0x000000079F654AA8 cwh=0x0000000028BB0158 cpu=1656250 buffg=142146 interb=30138368 r=1439 rb=26451968 w=18 wb=3686400 2025-09-06 06:00:02.280654*:C9A45890:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028BBC288 curCtx=0x00000000299C8510 pubTabIdxCnt=0 2025-09-06 06:00:02.280654*:C9A45891:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028BBC288 2025-09-06 06:00:02.280654*:C9A45892:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028BBC288 2025-09-06 06:00:02.468162*:C9A45961:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000299C6918 curCtx=0x000000005D5ECC88 xsc->flg4=65792 flags=1 2025-09-06 06:00:02.468162*:C9A45962:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000299C6918 2025-09-06 06:00:03.080407 :C9A45977:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:03.080754 :C9A4597F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:03.080754*:C9A45985:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028BBC288 curCtx=0x00000000299C8510 xsc->flg4=65792 flags=2 2025-09-06 06:00:03.080754*:C9A45988:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028BBC288 2025-09-06 06:00:03.081024 :C9A45989:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-09-06 06:00:03.085673 :C9A4598A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:26:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-09-06 06:00:03.085759 :C9A4598D: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-09-06 06:00:03.085848 :C9A4599A: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: 21748, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de