Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250507082248\orcl_j000_8908_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250507082248\orcl_j000_8908_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:37438M/63366M, Ph+PgF:44872M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 8908, image: ORACLE.EXE (J000) *** 2025-05-07 08:22:49.024 *** SESSION ID:(193.34211) 2025-05-07 08:22:49.024 *** 2025-05-07 08:22:49.024 Process diagnostic dump for ORACLE.EXE (J000), OS id=8908, pid: 24, proc_ser: 201, sid: 193, sess_ser: 34211 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 8908 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) 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.112276 sec, exc=0.112276 sec, total=0.112276 sec wait times: max=0.500000 sec, heur=1.619323 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=2 seq_num=3 snap_id=1 wait times: snap=0.510115 sec, exc=0.510115 sec, total=0.510115 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 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.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.000013 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.496909 sec, exc=0.496909 sec, total=0.496909 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 34211 --------------------------------------------------- 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, 08:22:47 - 08:22:49] idle wait at each sample [session created at: 08:22:47] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-05-07 08:22:49.025 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 8908, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-05-07 08:20:47.263678 :93D0A08F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.263807 :93D0A090:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.263836 :93D0A091:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.263861 :93D0A092:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.264068 :93D0A093: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-05-07 08:20:47.264099 :93D0A096:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.268491 :93D0A09C: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-05-07 08:20:47.268548 :93D0A09F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-05-07 08:20:47.268578 :93D0A0A0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-05-07 08:20:47.270369 :93D0A0A6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.270413 :93D0A0A7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.273610 :93D0A0A8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.273884 :93D0A0A9: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-05-07 08:20:47.273923 :93D0A0AC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.278549 :93D0A0B2: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-05-07 08:20:47.278613 :93D0A0B5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-05-07 08:20:47.278656 :93D0A0B6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-05-07 08:20:47.280421 :93D0A0BC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.280466 :93D0A0BD:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.280824 :93D0A0BE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.280854 :93D0A0BF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281076 :93D0A0C0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281105 :93D0A0C1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281110 :93D0A0C2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281134 :93D0A0C3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281232 :93D0A0C4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281258 :93D0A0C5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281262 :93D0A0C6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281286 :93D0A0C7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281411 :93D0A0C8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281454 :93D0A0C9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281462 :93D0A0CA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281503 :93D0A0CB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281619 :93D0A0CC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281644 :93D0A0CD:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281649 :93D0A0CE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281673 :93D0A0CF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281768 :93D0A0D0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281793 :93D0A0D1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281798 :93D0A0D2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281822 :93D0A0D3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281914 :93D0A0D4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.281940 :93D0A0D5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.281973 :93D0A0D6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.282213 :93D0A0D7: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-05-07 08:20:47.282247 :93D0A0DA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.294050 :93D0A0E0: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-05-07 08:20:47.294120 :93D0A0E3:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-05-07 08:20:47.294154 :93D0A0E4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-05-07 08:20:47.301891 :93D0A0EA: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-05-07 08:20:47.301949 :93D0A0ED:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-05-07 08:20:47.301978 :93D0A0EE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-05-07 08:20:47.303891 :93D0A0F4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.303936 :93D0A0F5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.304552 :93D0A0F6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.304777 :93D0A0F7: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-05-07 08:20:47.304808 :93D0A0FA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.311866 :93D0A100: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-05-07 08:20:47.311927 :93D0A103:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:ktcc.c:879 2025-05-07 08:20:47.311960 :93D0A104:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:ktcc.c:879 2025-05-07 08:20:47.312255 :93D0A10A:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-05-07 08:20:47.312596 :93D0A10B:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-05-07 08:20:47.312713 :93D0A10C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.312914 :93D0A10D: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-05-07 08:20:47.312937 :93D0A110:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.314463 :93D0A116:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:20:47.314670 :93D0A117: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-05-07 08:20:47.314715 :93D0A11A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:20:47.315680 :93D0A120: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-05-07 08:20:47.315782 :93D0A129: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-05-07 08:21:17.387910 :93D0AAE3:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:21:19.037416 :93D0ABA4:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:21:19.031 2025-05-07 08:21:19.037418 :93D0ABA5:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=12208 pso_num=24 pso_serial#=192 2025-05-07 08:21:19.037551 :93D0ABA6:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=12208 (legacy spawn) 2025-05-07 08:21:19.043930 :93D0ABA7: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-05-07 08:21:19.044103 :93D0ABAC: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-05-07 08:21:19.044920 :93D0ABB1:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:21:33.632586 :93D0B027:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:21:33.618 2025-05-07 08:21:33.632587 :93D0B028:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=11176 pso_num=24 pso_serial#=193 2025-05-07 08:21:33.632730 :93D0B029:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=11176 (legacy spawn) 2025-05-07 08:21:33.640753 :93D0B02A: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-05-07 08:21:33.640926 :93D0B02F: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-05-07 08:21:33.641649 :93D0B034:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:21:33.651965 :93D0B037:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:21:33.649 2025-05-07 08:21:33.651967 :93D0B038:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=9952 pso_num=24 pso_serial#=194 2025-05-07 08:21:33.652054 :93D0B039:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=9952 (legacy spawn) 2025-05-07 08:21:33.658079 :93D0B03A: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-05-07 08:21:33.658245 :93D0B043: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-05-07 08:21:33.659094 :93D0B044:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:21:36.719395 :93D0B125:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:21:36.706 2025-05-07 08:21:36.719397 :93D0B126:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=11412 pso_num=24 pso_serial#=195 2025-05-07 08:21:36.719534 :93D0B127:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=11412 (legacy spawn) 2025-05-07 08:21:36.726132 :93D0B128: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-05-07 08:21:36.726312 :93D0B12D: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-05-07 08:21:36.727131 :93D0B132:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:21:36.736037 :93D0B135:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:21:36.722 2025-05-07 08:21:36.736039 :93D0B136:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=8880 pso_num=24 pso_serial#=196 2025-05-07 08:21:36.736198 :93D0B137:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=8880 (legacy spawn) 2025-05-07 08:21:36.742746 :93D0B138: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-05-07 08:21:36.742923 :93D0B141: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-05-07 08:21:36.743812 :93D0B142:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:21:45.668940 :93D0B404:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:21:45.660 2025-05-07 08:21:45.668942 :93D0B405:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=8768 pso_num=24 pso_serial#=197 2025-05-07 08:21:45.669082 :93D0B406:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=8768 (legacy spawn) 2025-05-07 08:21:45.695430 :93D0B407: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-05-07 08:21:45.695602 :93D0B40C: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-05-07 08:21:45.696407 :93D0B411:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:21:47.306072 :93D0B462:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:21:47.301 2025-05-07 08:21:47.306073 :93D0B463:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=11524 pso_num=24 pso_serial#=198 2025-05-07 08:21:47.306211 :93D0B464:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=11524 osp_idx=22 osp_ver=241427 osp_pg=0 (spawn #156972) 2025-05-07 08:21:47.306212 :93D0B465:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-07 08:21:47.306212 :93D0B466:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=25 time=3876884468 2025-05-07 08:21:47.306213 :93D0B467:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-05-07 08:21:47.306213 :93D0B468:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-05-07 08:21:47.306213 :93D0B469:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-05-07 08:21:47.306214 :93D0B46A:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-07 08:21:47.306214 :93D0B46B:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-07 08:21:47.306724 :93D0B46C: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-05-07 08:21:47.307361 :93D0B481: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-05-07 08:21:47.314905 :93D0B49D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:21:47.315268 :93D0B49E: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-05-07 08:21:47.315304 :93D0B4A1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:21:47.316179 :93D0B4A7: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-05-07 08:21:47.316294 :93D0B4AE: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-05-07 08:22:17.411220 :93D0BE26:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:22:19.866174 :93D0BEEE:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:22:19.857 2025-05-07 08:22:19.866177 :93D0BEEF:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=6552 pso_num=24 pso_serial#=199 2025-05-07 08:22:19.866308 :93D0BEF0:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=6552 (legacy spawn) 2025-05-07 08:22:19.872709 :93D0BEF1: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-05-07 08:22:19.872882 :93D0BEF6: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-05-07 08:22:19.873682 :93D0BEFB:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:22:21.280288 :93D0BF54:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:22:21.272 2025-05-07 08:22:21.280289 :93D0BF55:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=7552 pso_num=24 pso_serial#=200 2025-05-07 08:22:21.280428 :93D0BF56:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=7552 (legacy spawn) 2025-05-07 08:22:21.286868 :93D0BF57: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-05-07 08:22:21.287039 :93D0BF5C: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-05-07 08:22:21.287868 :93D0BF61:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-05-07 08:22:42.378201 :93D0C605:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 05-07 08:22:42.372 2025-05-07 08:22:42.378203 :93D0C606:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=8908 pso_num=24 pso_serial#=201 2025-05-07 08:22:42.378353 :93D0C607:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=8908 osp_idx=22 osp_ver=241430 osp_pg=0 (spawn #156974) 2025-05-07 08:22:42.378355 :93D0C608:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-07 08:22:42.378355 :93D0C609:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=26 time=3876939546 2025-05-07 08:22:42.378355 :93D0C60A:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-05-07 08:22:42.378356 :93D0C60B:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-05-07 08:22:42.378356 :93D0C60C:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-05-07 08:22:42.378357 :93D0C60D:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-07 08:22:42.378357 :93D0C60E:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-07 08:22:42.378879 :93D0C60F: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-05-07 08:22:42.379520 :93D0C624: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-05-07 08:22:42.384903 :93D0C640: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-05-07 08:22:42.385880 :93D0C648: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-05-07 08:22:42.386007 :93D0C651: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-05-07 08:22:47.389333 :93D101F4: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-05-07 08:22:47.389357*:93D101F8:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000000FD4BB58 estart=1746577367 eid=16848414 ctx=0x000000077BD98A08 cwh=0x000000000FD002A0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-05-07 08:22:47.389357*:93D101F9:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000000FD4BB58 curCtx=0x000000000FD0F300 pubTabIdxCnt=0 2025-05-07 08:22:47.389357*:93D101FA:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000000FD4BB58 2025-05-07 08:22:47.389357*:93D101FB:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000000FD4BB58 2025-05-07 08:22:47.389357*:93D101FC:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000000FD4BB58 curCtx=0x000000000FD0F300 xsc->flg4=65792 flags=2 2025-05-07 08:22:47.389357*:93D101FD:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000000FD4BB58 2025-05-07 08:22:47.389853 :93D101FE: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-05-07 08:22:47.400606 :93D10206:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-05-07 08:22:47.401061 :93D10207:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-05-07 08:22:47.403366 :93D10208:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-05-07 08:22:47.403699 :93D10209: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-05-07 08:22:47.403732 :93D1020C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-05-07 08:22:47.404648 :93D10212: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-05-07 08:22:47.404769 :93D1021B: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: 8908, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de