Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250807220006\orcl_j001_20732_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250807220006\orcl_j001_20732_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:35661M/63366M, Ph+PgF:41177M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 27 Windows thread id: 20732, image: ORACLE.EXE (J001) *** 2025-08-07 22:00:06.428 *** SESSION ID:(219.30717) 2025-08-07 22:00:06.428 *** 2025-08-07 22:00:06.428 Process diagnostic dump for ORACLE.EXE (J001), OS id=20732, pid: 27, proc_ser: 12, sid: 219, sess_ser: 30717 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 20732 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.376152 sec, exc=0.376152 sec, total=0.376152 sec wait times: max=0.500000 sec, heur=1.878598 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.000011 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.500157 sec, exc=0.500157 sec, total=0.500157 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.502902 sec, exc=0.502902 sec, total=0.502902 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.499356 sec, exc=0.499356 sec, total=0.499356 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 219 serial 30717 --------------------------------------------------- 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 --------------------------------------------------- [2 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-08-07 22:00:06.428 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 27 (osid: 20732, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-07 21:56:15.100145 :BCB8DF16:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:56:15.119559 :BCB8DF19:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:56:15.110 2025-08-07 21:56:15.119561 :BCB8DF1A:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=18148 pso_num=27 pso_serial#=251 2025-08-07 21:56:15.119696 :BCB8DF1B:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=18148 (legacy spawn) 2025-08-07 21:56:15.126049 :BCB8DF2F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:56:15.126205 :BCB8DF35:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:56:15.126983 :BCB8DF39:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:56:30.341040 :BCB8E417:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:56:30.332 2025-08-07 21:56:30.341042 :BCB8E418:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20424 pso_num=27 pso_serial#=252 2025-08-07 21:56:30.341184 :BCB8E419:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=20424 (legacy spawn) 2025-08-07 21:56:30.348029 :BCB8E41A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:56:30.348231 :BCB8E41F:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:56:30.349099 :BCB8E424:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:57:07.219092 :BCB8F042:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:57:07.210 2025-08-07 21:57:07.219094 :BCB8F043:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20784 pso_num=27 pso_serial#=253 2025-08-07 21:57:07.219233 :BCB8F044:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=20784 (legacy spawn) 2025-08-07 21:57:07.225687 :BCB8F045:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:57:07.225863 :BCB8F04E:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:57:07.226703 :BCB8F04F:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:57:09.443836 :BCB8F0FE:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:57:09.429 2025-08-07 21:57:09.443839 :BCB8F0FF:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20156 pso_num=27 pso_serial#=254 2025-08-07 21:57:09.443981 :BCB8F100:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=20156 (legacy spawn) 2025-08-07 21:57:09.450443 :BCB8F101:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:57:09.450618 :BCB8F106:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:57:09.451433 :BCB8F10B:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:57:09.460073 :BCB8F10E:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:57:09.445 2025-08-07 21:57:09.460075 :BCB8F10F:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=19316 pso_num=27 pso_serial#=255 2025-08-07 21:57:09.460233 :BCB8F110:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=19316 (legacy spawn) 2025-08-07 21:57:09.466689 :BCB8F111:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:57:09.466852 :BCB8F11A:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:57:09.467661 :BCB8F11B:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:57:11.313709 :BCB8F1D6:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:57:11.304 2025-08-07 21:57:11.313711 :BCB8F1D7:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=19728 pso_num=27 pso_serial#=1 2025-08-07 21:57:11.313903 :BCB8F1D8:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=19728 (legacy spawn) 2025-08-07 21:57:11.320852 :BCB8F1D9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:57:11.321028 :BCB8F1DE:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:57:11.321899 :BCB8F1E3:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:57:12.676653 :BCB8F222:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:57:12.664 2025-08-07 21:57:12.676655 :BCB8F223:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=19440 pso_num=27 pso_serial#=2 2025-08-07 21:57:12.676795 :BCB8F224:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=19440 (legacy spawn) 2025-08-07 21:57:12.683342 :BCB8F225:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:57:12.683518 :BCB8F22A:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:57:12.684341 :BCB8F22F:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:57:12.693232 :BCB8F232:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:57:12.679 2025-08-07 21:57:12.693234 :BCB8F233:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20852 pso_num=27 pso_serial#=3 2025-08-07 21:57:12.693382 :BCB8F234:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=20852 (legacy spawn) 2025-08-07 21:57:12.700118 :BCB8F235:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:57:12.700297 :BCB8F23E:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:57:12.701169 :BCB8F23F:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:57:32.495273 :BCB8F854:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:57:32.482 2025-08-07 21:57:32.495276 :BCB8F855:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20148 pso_num=27 pso_serial#=4 2025-08-07 21:57:32.495414 :BCB8F856:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=20148 (legacy spawn) 2025-08-07 21:57:32.515250 :BCB8F857:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:57:32.515425 :BCB8F85C:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:57:32.516271 :BCB8F861:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:58:19.618139 :BCB9075C:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:58:19.609 2025-08-07 21:58:19.618141 :BCB9075D:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20764 pso_num=27 pso_serial#=5 2025-08-07 21:58:19.618301 :BCB9075E:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=20764 (legacy spawn) 2025-08-07 21:58:19.624804 :BCB9075F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:58:19.625010 :BCB90768:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:58:19.625830 :BCB90769:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:58:21.983831 :BCB90819:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:58:21.969 2025-08-07 21:58:21.983833 :BCB9081A:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20292 pso_num=27 pso_serial#=6 2025-08-07 21:58:21.983979 :BCB9081B:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=20292 (legacy spawn) 2025-08-07 21:58:21.990439 :BCB9081C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:58:21.990611 :BCB90825:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:58:21.991414 :BCB90826:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:58:22.000147 :BCB90829:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:58:21.985 2025-08-07 21:58:22.000149 :BCB9082A:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=19836 pso_num=27 pso_serial#=7 2025-08-07 21:58:22.000317 :BCB9082B:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=19836 (legacy spawn) 2025-08-07 21:58:22.006790 :BCB9082C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:58:22.006959 :BCB90835:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:58:22.007739 :BCB90836:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:58:25.175346 :BCB90937:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:58:25.161 2025-08-07 21:58:25.175348 :BCB90938:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=11328 pso_num=27 pso_serial#=8 2025-08-07 21:58:25.175484 :BCB90939:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=11328 (legacy spawn) 2025-08-07 21:58:25.181943 :BCB9093A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:58:25.182140 :BCB90943:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:58:25.182911 :BCB90944:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:58:25.191597 :BCB90947:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:58:25.177 2025-08-07 21:58:25.191600 :BCB90948:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=2696 pso_num=27 pso_serial#=9 2025-08-07 21:58:25.191736 :BCB90949:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=2696 (legacy spawn) 2025-08-07 21:58:25.543819 :BCB90976:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:58:25.543994 :BCB9097F:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:58:25.544862 :BCB90980:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:59:05.734476 :BCB91695:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:59:05.725 2025-08-07 21:59:05.734478 :BCB91696:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=15304 pso_num=27 pso_serial#=10 2025-08-07 21:59:05.734634 :BCB91697:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=15304 (legacy spawn) 2025-08-07 21:59:05.741539 :BCB91698:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:59:05.741727 :BCB916A1:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:59:05.742619 :BCB916A2:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 21:59:27.719676 :BCB91DA5:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 21:59:27.710 2025-08-07 21:59:27.719678 :BCB91DA6:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=19060 pso_num=27 pso_serial#=11 2025-08-07 21:59:27.719820 :BCB91DA7:db_trace:kso.c@4070:ksonfy(): [10420:27:0] kso: new process: pid=19060 (legacy spawn) 2025-08-07 21:59:27.726390 :BCB91DA8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 21:59:27.726556 :BCB91DAD:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-07 21:59:27.727357 :BCB91DB2:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-07 22:00:02.044675 :BCB92AE2:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-07 22:00:02.034 2025-08-07 22:00:02.044677 :BCB92AE3:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20732 pso_num=27 pso_serial#=12 2025-08-07 22:00:02.044812 :BCB92AE4:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=20732 osp_idx=25 osp_ver=244565 osp_pg=0 (spawn #465812) 2025-08-07 22:00:02.044813 :BCB92AE5:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-07 22:00:02.044813 :BCB92AE6:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=235 time=3284671345 2025-08-07 22:00:02.044814 :BCB92AE7:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-07 22:00:02.044814 :BCB92AE8:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-07 22:00:02.044815 :BCB92AE9:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-07 22:00:02.044816 :BCB92AEA:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-07 22:00:02.044816 :BCB92AEB:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-07 22:00:02.045321 :BCB92AF5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.050283 :BCB92B14:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.050323 :BCB92B17:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:jslv.c:9203 2025-08-07 22:00:02.053787 :BCB92B32:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.441504 :BCB92E40:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.485328 :BCB92E6C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.501072 :BCB92E74:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.558857 :BCB92E8F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.691888 :BCB92EC7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.806655 :BCB92ECF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.816355 :BCB92ED7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.832062 :BCB92EDF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.847645 :BCB92EE7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.863705 :BCB92EEF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.873377 :BCB92EF7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.888762 :BCB92EFF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.898407 :BCB92F07:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.914223 :BCB92F0F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.924072 :BCB92F1F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.933893 :BCB92F3A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.949718 :BCB92F6C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.959469 :BCB92F94:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.975788 :BCB9300A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:02.992509 :BCB9302E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.008305 :BCB93036:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.015742 :BCB9303E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.031424 :BCB93046:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.041132 :BCB9304E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.056675 :BCB93056:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.066700 :BCB9305E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.076012 :BCB93066:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.091791 :BCB9306E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.100901 :BCB93076:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.110191 :BCB9307E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.111584*:BCB93090:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000055A6A188 estart=1754575202 eid=16805922 ctx=0x0000000783637648 cwh=0x000000002B510068 cpu=15625 buffg=461 interb=0 r=0 rb=0 w=0 wb=0 2025-08-07 22:00:03.111584*:BCB93091:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000055A6A188 curCtx=0x00000000559BFEB8 pubTabIdxCnt=0 2025-08-07 22:00:03.111584*:BCB93092:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000055A6A188 2025-08-07 22:00:03.111584*:BCB93093:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000055A6A188 2025-08-07 22:00:03.111584*:BCB93094:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028FFC288 estart=1754575201 eid=16777352 ctx=0x000000079F654AA8 cwh=0x0000000028FF0158 cpu=1046875 buffg=75237 interb=16449536 r=724 rb=14131200 w=12 wb=2318336 2025-08-07 22:00:03.111584*:BCB93095:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028FFC288 curCtx=0x00000000559BEFE0 pubTabIdxCnt=0 2025-08-07 22:00:03.111584*:BCB93096:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028FFC288 2025-08-07 22:00:03.111584*:BCB93097:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028FFC288 2025-08-07 22:00:03.111584*:BCB93098:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000055A6A188 curCtx=0x00000000559BFEB8 xsc->flg4=65792 flags=0 2025-08-07 22:00:03.111584*:BCB93099:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000055A6A188 2025-08-07 22:00:03.125773 :BCB9309A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.141702 :BCB930A2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.157294 :BCB930AA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.167403 :BCB930B2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.177494 :BCB930BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.193548 :BCB930C2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.210051 :BCB930CA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.220160 :BCB930D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.235854 :BCB930DA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.246175 :BCB930E2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.256050 :BCB930EA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.268344 :BCB930F2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.277784 :BCB930FA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.287425 :BCB93102:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.303510 :BCB9310A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.313482 :BCB93112:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.321065 :BCB93126:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.328820 :BCB9312E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.336504 :BCB93136:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.344231 :BCB9313E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.352006 :BCB93146:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.359689 :BCB9314E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.367228 :BCB93156:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:03.374863 :BCB9315E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:04.536935 :BCB93366:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:04.537262 :BCB9336E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:04.537262*:BCB93372:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028FFC288 curCtx=0x00000000559BEFE0 xsc->flg4=65792 flags=2 2025-08-07 22:00:04.537262*:BCB93376:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028FFC288 2025-08-07 22:00:04.537519 :BCB93378:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:jslv.c:9203 2025-08-07 22:00:04.539229 :BCB93379:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:04.542201 :BCB93381:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-07 22:00:04.542281 :BCB93384:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-08-07 22:00:04.542357 :BCB93391:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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 27 (osid: 20732, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de