Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250612222434\orcl_j000_13744_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250612222434\orcl_j000_13744_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:36737M/63366M, Ph+PgF:43242M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 13744, image: ORACLE.EXE (J000) *** 2025-06-12 22:24:34.499 *** SESSION ID:(193.57913) 2025-06-12 22:24:34.499 *** 2025-06-12 22:24:34.499 Process diagnostic dump for ORACLE.EXE (J000), OS id=13744, pid: 24, proc_ser: 40, sid: 193, sess_ser: 57913 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 13744 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) 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.422154 sec, exc=0.422154 sec, total=0.422154 sec wait times: max=0.500000 sec, heur=4.414124 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.499999 sec, exc=0.499999 sec, total=0.499999 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 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.000012 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.499999 sec, exc=0.499999 sec, total=0.499999 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 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.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.000008 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.500162 sec, exc=0.500162 sec, total=0.500162 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 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.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.000010 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.500116 sec, exc=0.500116 sec, total=0.500116 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.491628 sec, exc=0.491628 sec, total=0.491628 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 193 serial 57913 --------------------------------------------------- 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, 22:24:30 - 22:24:34] idle wait at each sample [session created at: 22:24:30] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-06-12 22:24:34.499 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 13744, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-12 22:21:49.454872 :A3DE8D6B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:21:49.441 2025-06-12 22:21:49.454874 :A3DE8D6C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16884 pso_num=24 pso_serial#=24 2025-06-12 22:21:49.455009 :A3DE8D6D:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=16884 (legacy spawn) 2025-06-12 22:21:49.461405 :A3DE8D6E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:21:49.461572 :A3DE8D77:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:21:49.462353 :A3DE8D78:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:22:02.458971 :A3DE9178:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:22:02.450 2025-06-12 22:22:02.458973 :A3DE9179:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=15576 pso_num=24 pso_serial#=25 2025-06-12 22:22:02.459114 :A3DE917A:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=15576 (legacy spawn) 2025-06-12 22:22:02.485445 :A3DE917B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:22:02.485620 :A3DE9180:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:22:02.486415 :A3DE9185:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:22:04.898209 :A3DE9250:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:22:04.892 2025-06-12 22:22:04.898211 :A3DE9251:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16496 pso_num=24 pso_serial#=26 2025-06-12 22:22:04.898349 :A3DE9252:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=16496 osp_idx=22 osp_ver=397590 osp_pg=0 (spawn #279190) 2025-06-12 22:22:04.898350 :A3DE9253:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-12 22:22:04.898351 :A3DE9254:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=144 time=2742668094 2025-06-12 22:22:04.898351 :A3DE9255:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-12 22:22:04.898351 :A3DE9256:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-12 22:22:04.898352 :A3DE9257:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-12 22:22:04.898352 :A3DE9258:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-12 22:22:04.898352 :A3DE9259:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-12 22:22:04.898850 :A3DE925A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-12 22:22:04.899532 :A3DE926F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:22:04.910519 :A3DE928B:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-06-12 22:22:04.910984 :A3DE928C:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-06-12 22:22:04.913247 :A3DE928D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:22:04.913630 :A3DE928E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:22:04.913683 :A3DE9291:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:22:04.914567 :A3DE9297:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:22:04.914700 :A3DE92A0:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:22:34.996583 :A3DE9BE2:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:22:36.400300 :A3DE9C71:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:22:36.387 2025-06-12 22:22:36.400301 :A3DE9C72:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=12524 pso_num=24 pso_serial#=27 2025-06-12 22:22:36.400439 :A3DE9C73:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=12524 (legacy spawn) 2025-06-12 22:22:36.406970 :A3DE9C74:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:22:36.407162 :A3DE9C79:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:22:36.407961 :A3DE9C7E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:22:36.661856 :A3DE9C81:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:22:36.652 2025-06-12 22:22:36.661859 :A3DE9C82:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=14012 pso_num=24 pso_serial#=28 2025-06-12 22:22:36.662005 :A3DE9C83:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=14012 (legacy spawn) 2025-06-12 22:22:36.668425 :A3DE9C84:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:22:36.668580 :A3DE9C8D:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:22:36.669392 :A3DE9C8E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:22:58.982262 :A3DEA329:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:22:58.968 2025-06-12 22:22:58.982264 :A3DEA32A:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=13496 pso_num=24 pso_serial#=29 2025-06-12 22:22:58.982403 :A3DEA32B:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=13496 (legacy spawn) 2025-06-12 22:22:58.989097 :A3DEA32C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:22:58.989278 :A3DEA335:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:22:58.990070 :A3DEA336:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:22:58.998763 :A3DEA339:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:22:58.983 2025-06-12 22:22:58.998765 :A3DEA33A:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=14740 pso_num=24 pso_serial#=30 2025-06-12 22:22:58.998936 :A3DEA33B:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=14740 (legacy spawn) 2025-06-12 22:22:59.005342 :A3DEA33C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:22:59.005517 :A3DEA345:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:22:59.006331 :A3DEA346:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:23:02.206898 :A3DEA45B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:23:02.197 2025-06-12 22:23:02.206900 :A3DEA45C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=13316 pso_num=24 pso_serial#=31 2025-06-12 22:23:02.207050 :A3DEA45D:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=13316 (legacy spawn) 2025-06-12 22:23:02.213537 :A3DEA45E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:02.213698 :A3DEA463:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:23:02.214508 :A3DEA468:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:23:02.223164 :A3DEA46B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:23:02.212 2025-06-12 22:23:02.223165 :A3DEA46C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16452 pso_num=24 pso_serial#=32 2025-06-12 22:23:02.223300 :A3DEA46D:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=16452 (legacy spawn) 2025-06-12 22:23:02.229785 :A3DEA46E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:02.229943 :A3DEA477:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:23:02.230745 :A3DEA478:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:23:04.977897 :A3DEA54B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:23:04.972 2025-06-12 22:23:04.977899 :A3DEA54C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=15532 pso_num=24 pso_serial#=33 2025-06-12 22:23:04.978042 :A3DEA54D:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=15532 osp_idx=22 osp_ver=397597 osp_pg=0 (spawn #279192) 2025-06-12 22:23:04.978043 :A3DEA54E:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-12 22:23:04.978043 :A3DEA54F:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=145 time=2742728172 2025-06-12 22:23:04.978043 :A3DEA550:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-12 22:23:04.978044 :A3DEA551:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-12 22:23:04.978044 :A3DEA552:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-12 22:23:04.978044 :A3DEA553:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-12 22:23:04.978045 :A3DEA554:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-12 22:23:04.978537 :A3DEA555:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-12 22:23:04.979172 :A3DEA56A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:04.986656 :A3DEA587:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:23:04.987021 :A3DEA588:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:04.987058 :A3DEA58B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:23:04.987958 :A3DEA591:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:04.988089 :A3DEA59A:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:23:35.077888 :A3DEAED7:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:23:35.409028 :A3DEAF03:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:23:35.406 2025-06-12 22:23:35.409030 :A3DEAF04:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=13620 pso_num=24 pso_serial#=34 2025-06-12 22:23:35.409169 :A3DEAF05:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=13620 (legacy spawn) 2025-06-12 22:23:35.415573 :A3DEAF06:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:35.415750 :A3DEAF0B:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:23:35.416544 :A3DEAF10:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:23:35.425460 :A3DEAF13:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:23:35.422 2025-06-12 22:23:35.425462 :A3DEAF14:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=17188 pso_num=24 pso_serial#=35 2025-06-12 22:23:35.425598 :A3DEAF15:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=17188 (legacy spawn) 2025-06-12 22:23:35.432003 :A3DEAF16:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:35.432177 :A3DEAF1F:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:23:35.432987 :A3DEAF20:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:23:38.529009 :A3DEB010:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:23:38.520 2025-06-12 22:23:38.529011 :A3DEB011:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=13924 pso_num=24 pso_serial#=36 2025-06-12 22:23:38.529158 :A3DEB012:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=13924 (legacy spawn) 2025-06-12 22:23:38.536080 :A3DEB013:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:38.536249 :A3DEB018:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:23:38.537065 :A3DEB01D:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:23:38.545766 :A3DEB020:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:23:38.536 2025-06-12 22:23:38.545767 :A3DEB021:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=13448 pso_num=24 pso_serial#=37 2025-06-12 22:23:38.545909 :A3DEB022:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=13448 (legacy spawn) 2025-06-12 22:23:38.552431 :A3DEB02F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:38.552587 :A3DEB038:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:23:38.553397 :A3DEB039:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:23:38.559870 :A3DEB03C:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:23:38.551 2025-06-12 22:23:38.559872 :A3DEB03D:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=14444 pso_num=24 pso_serial#=38 2025-06-12 22:23:38.560009 :A3DEB03E:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=14444 (legacy spawn) 2025-06-12 22:23:38.566471 :A3DEB03F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:38.566642 :A3DEB048:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:23:38.567544 :A3DEB04D:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:23:44.937836 :A3DEB238:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:23:44.929 2025-06-12 22:23:44.937838 :A3DEB239:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=16120 pso_num=24 pso_serial#=39 2025-06-12 22:23:44.937978 :A3DEB23A:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=16120 (legacy spawn) 2025-06-12 22:23:44.944684 :A3DEB23B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:23:44.944863 :A3DEB240:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:23:44.945758 :A3DEB245:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-06-12 22:24:05.056733 :A3DEB82C:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 06-12 22:24:05.051 2025-06-12 22:24:05.056735 :A3DEB82D:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=13744 pso_num=24 pso_serial#=40 2025-06-12 22:24:05.056874 :A3DEB82E:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=13744 osp_idx=22 osp_ver=397604 osp_pg=0 (spawn #279194) 2025-06-12 22:24:05.056874 :A3DEB82F:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-12 22:24:05.056875 :A3DEB830:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=146 time=2742788250 2025-06-12 22:24:05.056875 :A3DEB831:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-06-12 22:24:05.056875 :A3DEB832:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-06-12 22:24:05.056876 :A3DEB833:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-06-12 22:24:05.056876 :A3DEB834:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-12 22:24:05.056876 :A3DEB835:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-12 22:24:05.057373 :A3DEB836:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-12 22:24:05.057996 :A3DEB84B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:05.072345 :A3DEB867:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:24:05.072432 :A3DEB868:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:24:05.092318 :A3DEB88C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:24:05.092385 :A3DEB88D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:24:05.092665 :A3DEB88E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:24:05.092704 :A3DEB88F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:24:05.092757 :A3DEB890:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:24:05.093105 :A3DEB891:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:05.093144 :A3DEB894:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:24:05.104267 :A3DEB89A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:05.104343 :A3DEB89D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-06-12 22:24:05.104384 :A3DEB89E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-06-12 22:24:05.106280 :A3DEB8A4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:24:05.106325 :A3DEB8A5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:24:05.106815 :A3DEB8A6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:24:05.107047 :A3DEB8A7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:05.107084 :A3DEB8AA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:24:05.112232 :A3DEB8B0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:05.112326 :A3DEB8B3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-06-12 22:24:05.112378 :A3DEB8B4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-06-12 22:24:05.112724 :A3DEB8BA:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-06-12 22:24:05.113073 :A3DEB8BB:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-06-12 22:24:05.113274 :A3DEB8BC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:24:05.113523 :A3DEB8BD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:05.113550 :A3DEB8C0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:24:05.115126 :A3DEB8C6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-06-12 22:24:05.115352 :A3DEB8C7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:05.115381 :A3DEB8CA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-06-12 22:24:05.116272 :A3DEB8D0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:05.116382 :A3DEB8D9:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-06-12 22:24:30.077703 :A3DEF786:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-12 22:24:30.077725*:A3DEF788:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024A4BB58 estart=1749738269 eid=16906455 ctx=0x000000077BD98A08 cwh=0x00000000232802A0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-06-12 22:24:30.077725*:A3DEF789:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024A4BB58 curCtx=0x000000002328F300 pubTabIdxCnt=0 2025-06-12 22:24:30.077725*:A3DEF78A:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024A4BB58 2025-06-12 22:24:30.077725*:A3DEF78B:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024A4BB58 2025-06-12 22:24:30.077725*:A3DEF78C:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024A4BB58 curCtx=0x000000002328F300 xsc->flg4=65792 flags=2 2025-06-12 22:24:30.077725*:A3DEF78D:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024A4BB58 2025-06-12 22:24:30.078215 :A3DEF78E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:30.083541 :A3DEF796:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:30.084304 :A3DEF79E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-06-12 22:24:30.084403 :A3DEF7A7:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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 24 (osid: 13744, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de