Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250914060008\orcl_j001_23728_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250914060008\orcl_j001_23728_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:34753M/63366M, Ph+PgF:39359M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 26 Windows thread id: 23728, image: ORACLE.EXE (J001) *** 2025-09-14 06:00:08.746 *** SESSION ID:(209.54619) 2025-09-14 06:00:08.746 *** 2025-09-14 06:00:08.746 Process diagnostic dump for ORACLE.EXE (J001), OS id=23728, pid: 26, proc_ser: 126, sid: 209, sess_ser: 54619 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 23728 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J001) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 snap_id=1 wait times: snap=0.183767 sec, exc=0.183767 sec, total=0.183767 sec wait times: max=0.500000 sec, heur=4.185565 sec wait counts: calls=1 os=1 in_wait=1 iflags=0x5a8 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000010 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.500152 sec, exc=0.500152 sec, total=0.500152 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000014 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 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.000011 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.499959 sec, exc=0.499959 sec, total=0.499959 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000017 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 snap_id=1 wait times: snap=0.500031 sec, exc=0.500031 sec, total=0.500031 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=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.000010 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.500189 sec, exc=0.500189 sec, total=0.500189 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.509219 sec, exc=0.509219 sec, total=0.509219 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.492165 sec, exc=0.492165 sec, total=0.492165 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 54619 --------------------------------------------------- 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 --------------------------------------------------- [5 samples, 06:00:04 - 06:00:08] idle wait at each sample [session created at: 06:00:04] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-09-14 06:00:08.746 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 26 (osid: 23728, J001) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-09-14 05:56:36.646436 :CD2C7DE5:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:56:39.708218 :CD2C7ED8:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:56:39.699 2025-09-14 05:56:39.708220 :CD2C7ED9:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=23104 pso_num=26 pso_serial#=110 2025-09-14 05:56:39.708372 :CD2C7EDA:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=23104 (legacy spawn) 2025-09-14 05:56:39.715261 :CD2C7EDB:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:56:39.715452 :CD2C7EE0: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-14 05:56:39.716395 :CD2C7EE5:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:57:41.865834 :CD2C9339:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:57:41.857 2025-09-14 05:57:41.865836 :CD2C933A:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=23608 pso_num=26 pso_serial#=111 2025-09-14 05:57:41.865979 :CD2C933B:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=23608 (legacy spawn) 2025-09-14 05:57:41.872933 :CD2C933C:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:57:41.873111 :CD2C9341: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-14 05:57:41.874012 :CD2C9346:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:57:44.324926 :CD2C9430:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:57:44.315 2025-09-14 05:57:44.324928 :CD2C9431:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=25332 pso_num=26 pso_serial#=112 2025-09-14 05:57:44.325077 :CD2C9432:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=25332 (legacy spawn) 2025-09-14 05:57:44.331963 :CD2C9433:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:57:44.332139 :CD2C9438: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-14 05:57:44.333031 :CD2C943D:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:57:46.220355 :CD2C9499:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:57:46.205 2025-09-14 05:57:46.220357 :CD2C949A:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=24900 pso_num=26 pso_serial#=113 2025-09-14 05:57:46.220491 :CD2C949B:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=24900 (legacy spawn) 2025-09-14 05:57:46.226923 :CD2C949C:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:57:46.227102 :CD2C94A1: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-14 05:57:46.227876 :CD2C94A6:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:57:46.236749 :CD2C94A9:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:57:46.221 2025-09-14 05:57:46.236752 :CD2C94AA:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=24728 pso_num=26 pso_serial#=114 2025-09-14 05:57:46.236905 :CD2C94AB:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=24728 (legacy spawn) 2025-09-14 05:57:46.243452 :CD2C94AC:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:57:46.243616 :CD2C94B5: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-14 05:57:46.244417 :CD2C94B6:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:57:49.291503 :CD2C95A7:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:57:49.278 2025-09-14 05:57:49.291505 :CD2C95A8:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=25316 pso_num=26 pso_serial#=115 2025-09-14 05:57:49.291642 :CD2C95A9:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=25316 (legacy spawn) 2025-09-14 05:57:49.298102 :CD2C95AA:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:57:49.298286 :CD2C95AF: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-14 05:57:49.299113 :CD2C95B4:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:57:49.307766 :CD2C95B7:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:57:49.294 2025-09-14 05:57:49.307769 :CD2C95B8:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=22408 pso_num=26 pso_serial#=116 2025-09-14 05:57:49.307911 :CD2C95B9:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=22408 (legacy spawn) 2025-09-14 05:57:49.314466 :CD2C95BA:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:57:49.314631 :CD2C95C3: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-14 05:57:49.315439 :CD2C95C4:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:58:25.588104 :CD2CA1D1:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:58:25.575 2025-09-14 05:58:25.588107 :CD2CA1D2:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=24464 pso_num=26 pso_serial#=117 2025-09-14 05:58:25.588254 :CD2CA1D3:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=24464 (legacy spawn) 2025-09-14 05:58:25.594774 :CD2CA1D4:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:58:25.594946 :CD2CA1D9: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-14 05:58:25.595739 :CD2CA1DE:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:58:25.604481 :CD2CA1E1:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:58:25.590 2025-09-14 05:58:25.604483 :CD2CA1E2:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=23680 pso_num=26 pso_serial#=118 2025-09-14 05:58:25.604619 :CD2CA1E3:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=23680 (legacy spawn) 2025-09-14 05:58:25.611136 :CD2CA1E4:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:58:25.611309 :CD2CA1ED: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-14 05:58:25.612135 :CD2CA1EE:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:58:44.034254 :CD2CA782:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:58:44.025 2025-09-14 05:58:44.034256 :CD2CA783:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=23376 pso_num=26 pso_serial#=119 2025-09-14 05:58:44.034409 :CD2CA784:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=23376 (legacy spawn) 2025-09-14 05:58:44.041427 :CD2CA785:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:58:44.041613 :CD2CA78A: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-14 05:58:44.042517 :CD2CA78F:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:58:52.625782 :CD2CAA4E:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:58:52.616 2025-09-14 05:58:52.625784 :CD2CAA4F:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=24380 pso_num=26 pso_serial#=120 2025-09-14 05:58:52.625926 :CD2CAA50:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=24380 (legacy spawn) 2025-09-14 05:58:52.632468 :CD2CAA51:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:58:52.632638 :CD2CAA56: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-14 05:58:52.633447 :CD2CAA5B:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:59:26.715496 :CD2CB583:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:59:26.706 2025-09-14 05:59:26.715498 :CD2CB584:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=20960 pso_num=26 pso_serial#=121 2025-09-14 05:59:26.715639 :CD2CB585:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=20960 (legacy spawn) 2025-09-14 05:59:26.722124 :CD2CB586:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:59:26.722306 :CD2CB58B: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-14 05:59:26.723116 :CD2CB590:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:59:34.979282 :CD2CB893:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:59:34.979 2025-09-14 05:59:34.979284 :CD2CB894:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=25180 pso_num=26 pso_serial#=122 2025-09-14 05:59:34.979438 :CD2CB895:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=25180 (legacy spawn) 2025-09-14 05:59:34.986228 :CD2CB896:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:59:34.986419 :CD2CB89F: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-14 05:59:34.987309 :CD2CB8A0:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:59:34.996714 :CD2CB8A3:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:59:34.995 2025-09-14 05:59:34.996716 :CD2CB8A4:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=25240 pso_num=26 pso_serial#=123 2025-09-14 05:59:34.996865 :CD2CB8A5:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=25240 (legacy spawn) 2025-09-14 05:59:35.003866 :CD2CB8A6:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:59:35.004053 :CD2CB8AD: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-14 05:59:35.004974 :CD2CB8B0:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:59:38.180338 :CD2CB996:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:59:38.167 2025-09-14 05:59:38.180339 :CD2CB997:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=21620 pso_num=26 pso_serial#=124 2025-09-14 05:59:38.180474 :CD2CB998:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=21620 (legacy spawn) 2025-09-14 05:59:38.187056 :CD2CB999:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:59:38.187231 :CD2CB99E: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-14 05:59:38.188045 :CD2CB9A3:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 05:59:38.196681 :CD2CB9A6:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 05:59:38.182 2025-09-14 05:59:38.196683 :CD2CB9A7:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=22084 pso_num=26 pso_serial#=125 2025-09-14 05:59:38.196820 :CD2CB9A8:db_trace:kso.c@4070:ksonfy(): [10420:26:0] kso: new process: pid=22084 (legacy spawn) 2025-09-14 05:59:38.203308 :CD2CB9A9:db_trace:ksl2.c@14083:ksl_update_post_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-14 05:59:38.203473 :CD2CB9B2: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-14 05:59:38.204266 :CD2CB9B3:db_trace:kst.c@698:kstpsodel(): [10280:26:0] kst: process state object about to be deleted 2025-09-14 06:00:02.057423 :CD2CC285:db_trace:kst.c@673:kstipg(): [10280:26:0] kst: process state object created on 09-14 06:00:02.046 2025-09-14 06:00:02.057425 :CD2CC286:db_trace:kst.c@679:kstipg(): [10280:26:0] kst: process info: ospid=23728 pso_num=26 pso_serial#=126 2025-09-14 06:00:02.057564 :CD2CC287:db_trace:kso.c@4093:ksonfy(): [10420:26:0] kso: new process: pid=23728 osp_idx=24 osp_ver=844441 osp_pg=0 (spawn #590283) 2025-09-14 06:00:02.057565 :CD2CC288: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-14 06:00:02.057565 :CD2CC289:db_trace:kso.c@4103:ksonfy(): [10420:26:0] kso: new process: pso_index=26 reservation=34 time=2215253362 2025-09-14 06:00:02.057565 :CD2CC28A:db_trace:kso.c@4109:ksonfy(): [10420:26:0] kso: spawn diagnostics: queue time=0 secs 2025-09-14 06:00:02.057566 :CD2CC28B:db_trace:kso.c@4111:ksonfy(): [10420:26:0] kso: spawn diagnostics: fork time=0 secs 2025-09-14 06:00:02.057566 :CD2CC28C:db_trace:kso.c@4113:ksonfy(): [10420:26:0] kso: spawn diagnostics: exec time=0 secs 2025-09-14 06:00:02.057566 :CD2CC28D:db_trace:kso.c@4115:ksonfy(): [10420:26:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-09-14 06:00:02.057567 :CD2CC28E:db_trace:kso.c@4117:ksonfy(): [10420:26:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-09-14 06:00:02.058068 :CD2CC28F: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-14 06:00:02.063109 :CD2CC2AF:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.063147 :CD2CC2B2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpus:jslv.c:9203 2025-09-14 06:00:02.066614 :CD2CC2D5:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.448742 :CD2CC633:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.491763 :CD2CC643:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.507394 :CD2CC64B:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.563992 :CD2CC653:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.695692 :CD2CC65B:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.810549 :CD2CC663:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.820936 :CD2CC66B:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.837226 :CD2CC673:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.853232 :CD2CC67B:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.870102 :CD2CC683:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.880437 :CD2CC68B:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.896243 :CD2CC693:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.906128 :CD2CC69B:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.922531 :CD2CC6A3:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.933183 :CD2CC6AB:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.943091 :CD2CC6B3:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.959126 :CD2CC6BB:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.968854 :CD2CC6C3:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:02.985764 :CD2CC6CB:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.002572 :CD2CC6D3:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.019069 :CD2CC6DB:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.026907 :CD2CC6E3:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.042787 :CD2CC6EB:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.052939 :CD2CC6F3:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.063263 :CD2CC706:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.078825 :CD2CC70E:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.088557 :CD2CC716:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.098970 :CD2CC71E:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.114975 :CD2CC726:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.132395 :CD2CC72E:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.141992 :CD2CC736:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.152422 :CD2CC73E:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.168584 :CD2CC746:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.184550 :CD2CC74E:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.194789 :CD2CC756:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.202565*:CD2CC768:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000060C5A188 estart=1757800803 eid=16813665 ctx=0x0000000783637648 cwh=0x00000000299C0068 cpu=0 buffg=473 interb=0 r=0 rb=0 w=0 wb=0 2025-09-14 06:00:03.202565*:CD2CC769:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000060C5A188 curCtx=0x0000000060BBEDC8 pubTabIdxCnt=0 2025-09-14 06:00:03.202565*:CD2CC76A:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000060C5A188 2025-09-14 06:00:03.202565*:CD2CC76B:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000060C5A188 2025-09-14 06:00:03.202565*:CD2CC76C:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028BBC288 estart=1757800801 eid=16777390 ctx=0x000000079F654AA8 cwh=0x0000000028BB0158 cpu=1062500 buffg=78860 interb=18890752 r=878 rb=16613376 w=12 wb=2277376 2025-09-14 06:00:03.202565*:CD2CC76D:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028BBC288 curCtx=0x0000000060BBDEF0 pubTabIdxCnt=0 2025-09-14 06:00:03.202565*:CD2CC76E:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028BBC288 2025-09-14 06:00:03.202565*:CD2CC76F:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028BBC288 2025-09-14 06:00:03.210749 :CD2CC770:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.210749*:CD2CC778:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000060C5A188 curCtx=0x0000000060BBEDC8 xsc->flg4=65792 flags=0 2025-09-14 06:00:03.210749*:CD2CC779:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000060C5A188 2025-09-14 06:00:03.226845 :CD2CC77A:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.237092 :CD2CC782:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.246087 :CD2CC78A:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.262046 :CD2CC792:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.271945 :CD2CC79A:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.282468 :CD2CC7A2:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.292613 :CD2CC7AA:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.304925 :CD2CC7B2:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.320997 :CD2CC7BA:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.328510 :CD2CC7C2:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.336094 :CD2CC7CA:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.343766 :CD2CC7D2:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.351425 :CD2CC7DA:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.359236 :CD2CC7E2:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.366836 :CD2CC7EA:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.374576 :CD2CC7F2:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.382400 :CD2CC7FA:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.390000 :CD2CC802:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:03.397514 :CD2CC80A:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:04.557287 :CD2CC9E6:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:04.557680 :CD2CC9EE:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:04.557680*:CD2CC9F1:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028BBC288 curCtx=0x0000000060BBDEF0 xsc->flg4=65792 flags=2 2025-09-14 06:00:04.557680*:CD2CC9F2:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028BBC288 2025-09-14 06:00:04.557940 :CD2CC9F8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:26:209] atxpop:jslv.c:9203 2025-09-14 06:00:04.562354 :CD2CC9F9:db_trace:ksl2.c@14083:ksl_update_post_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-14 06:00:04.562425 :CD2CC9FC: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-14 06:00:04.562500 :CD2CCA09: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: 23728, J001)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de