Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250721221952\orcl_j000_15732_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250721221952\orcl_j000_15732_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:36134M/63366M, Ph+PgF:42015M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 15732, image: ORACLE.EXE (J000) *** 2025-07-21 22:19:52.282 *** SESSION ID:(193.9345) 2025-07-21 22:19:52.282 *** 2025-07-21 22:19:52.282 Process diagnostic dump for ORACLE.EXE (J000), OS id=15732, pid: 24, proc_ser: 188, sid: 193, sess_ser: 9345 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 15732 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=49 seq_num=50 snap_id=1 wait times: snap=0.188184 sec, exc=0.188184 sec, total=0.188184 sec wait times: max=0.500000 sec, heur=24.769152 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.000012 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=48 seq_num=49 snap_id=1 wait times: snap=0.499998 sec, exc=0.499998 sec, total=0.499998 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=47 seq_num=48 snap_id=1 wait times: snap=0.499998 sec, exc=0.499998 sec, total=0.499998 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=46 seq_num=47 snap_id=1 wait times: snap=0.510093 sec, exc=0.510093 sec, total=0.510093 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=45 seq_num=46 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.000010 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=44 seq_num=45 snap_id=1 wait times: snap=0.499995 sec, exc=0.499995 sec, total=0.499995 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=43 seq_num=44 snap_id=1 wait times: snap=0.500002 sec, exc=0.500002 sec, total=0.500002 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=42 seq_num=43 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.000008 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=41 seq_num=42 snap_id=1 wait times: snap=0.499998 sec, exc=0.499998 sec, total=0.499998 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=40 seq_num=41 snap_id=1 wait times: snap=0.510112 sec, exc=0.510112 sec, total=0.510112 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=39 seq_num=40 snap_id=1 wait times: snap=0.499983 sec, exc=0.499983 sec, total=0.499983 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000013 sec of elapsed time Sampled Session History of session 193 serial 9345 --------------------------------------------------- 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 --------------------------------------------------- [25 samples, 22:19:27 - 22:19:52] idle wait at each sample [session created at: 22:19:27] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-21 22:19:52.282 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 15732, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-21 22:16:02.299309 :B52D34E9: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-07-21 22:16:02.299418 :B52D34F2: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-07-21 22:16:32.353826 :B52D3ECD:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:16:58.275488 :B52D46CA:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:16:58.272 2025-07-21 22:16:58.275490 :B52D46CB:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18360 pso_num=24 pso_serial#=168 2025-07-21 22:16:58.275633 :B52D46CC:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=18360 (legacy spawn) 2025-07-21 22:16:58.282014 :B52D46CD: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-07-21 22:16:58.282188 :B52D46D2: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-07-21 22:16:58.282974 :B52D46D7:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:16:58.311558 :B52D46DA:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:16:58.303 2025-07-21 22:16:58.311561 :B52D46DB:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=3088 pso_num=24 pso_serial#=169 2025-07-21 22:16:58.311740 :B52D46DC:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=3088 (legacy spawn) 2025-07-21 22:16:58.318150 :B52D46DD: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-07-21 22:16:58.318316 :B52D46E6: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-07-21 22:16:58.319164 :B52D46E7:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:00.216842 :B52D47A8:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:00.204 2025-07-21 22:17:00.216846 :B52D47A9:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=1216 pso_num=24 pso_serial#=170 2025-07-21 22:17:00.216982 :B52D47AA:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=1216 (legacy spawn) 2025-07-21 22:17:00.223539 :B52D47AB: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-07-21 22:17:00.223729 :B52D47B0: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-07-21 22:17:00.224539 :B52D47B5:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:00.233221 :B52D47B8:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:00.219 2025-07-21 22:17:00.233224 :B52D47B9:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19432 pso_num=24 pso_serial#=171 2025-07-21 22:17:00.233365 :B52D47BA:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=19432 (legacy spawn) 2025-07-21 22:17:00.239800 :B52D47BB: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-07-21 22:17:00.239967 :B52D47C4: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-07-21 22:17:00.240804 :B52D47C5:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:01.607549 :B52D481C:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:01.594 2025-07-21 22:17:01.607551 :B52D481D:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18568 pso_num=24 pso_serial#=172 2025-07-21 22:17:01.607692 :B52D481E:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=18568 (legacy spawn) 2025-07-21 22:17:01.614173 :B52D482A: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-07-21 22:17:01.614335 :B52D4832: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-07-21 22:17:01.615146 :B52D4834:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:01.623841 :B52D4837:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:01.610 2025-07-21 22:17:01.623843 :B52D4838:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=316 pso_num=24 pso_serial#=173 2025-07-21 22:17:01.623980 :B52D4839:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=316 (legacy spawn) 2025-07-21 22:17:01.630477 :B52D4845: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-07-21 22:17:01.630644 :B52D484E: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-07-21 22:17:01.631451 :B52D484F:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:02.271993 :B52D48C1:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:02.266 2025-07-21 22:17:02.271995 :B52D48C2:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=14784 pso_num=24 pso_serial#=174 2025-07-21 22:17:02.272129 :B52D48C3:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=14784 osp_idx=22 osp_ver=600454 osp_pg=0 (spawn #409201) 2025-07-21 22:17:02.272131 :B52D48C4:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-21 22:17:02.272131 :B52D48C5:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=195 time=1816998158 2025-07-21 22:17:02.272132 :B52D48C6:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-07-21 22:17:02.272132 :B52D48C7:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-07-21 22:17:02.272133 :B52D48C8:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-07-21 22:17:02.272133 :B52D48C9:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-21 22:17:02.272134 :B52D48CA:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-21 22:17:02.272611 :B52D48CB: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-07-21 22:17:02.273275 :B52D48E0: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-07-21 22:17:02.280788 :B52D48FC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-07-21 22:17:02.281144 :B52D48FD: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-07-21 22:17:02.281181 :B52D4900:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-07-21 22:17:02.282024 :B52D4906: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-07-21 22:17:02.282148 :B52D490F: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-07-21 22:17:32.365300 :B52D5664:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:33.613490 :B52D5691:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:33.604 2025-07-21 22:17:33.613492 :B52D5692:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18676 pso_num=24 pso_serial#=175 2025-07-21 22:17:33.613640 :B52D5693:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=18676 (legacy spawn) 2025-07-21 22:17:33.620672 :B52D5694: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-07-21 22:17:33.620862 :B52D5699: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-07-21 22:17:33.621766 :B52D569E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:34.818153 :B52D572B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:34.807 2025-07-21 22:17:34.818155 :B52D572C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=11144 pso_num=24 pso_serial#=176 2025-07-21 22:17:34.818298 :B52D572D:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=11144 (legacy spawn) 2025-07-21 22:17:34.824811 :B52D572E: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-07-21 22:17:34.824985 :B52D5733: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-07-21 22:17:34.825838 :B52D5738:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:34.834609 :B52D573B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:34.822 2025-07-21 22:17:34.834611 :B52D573C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=7564 pso_num=24 pso_serial#=177 2025-07-21 22:17:34.834742 :B52D573D:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=7564 (legacy spawn) 2025-07-21 22:17:34.841241 :B52D573E: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-07-21 22:17:34.841410 :B52D5747: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-07-21 22:17:34.842250 :B52D5748:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:37.876619 :B52D583F:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:37.864 2025-07-21 22:17:37.876621 :B52D5840:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=10764 pso_num=24 pso_serial#=178 2025-07-21 22:17:37.876760 :B52D5841:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=10764 (legacy spawn) 2025-07-21 22:17:37.883249 :B52D5842: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-07-21 22:17:37.883422 :B52D5847: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-07-21 22:17:37.884222 :B52D584C:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:37.893209 :B52D584F:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:37.879 2025-07-21 22:17:37.893211 :B52D5850:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=18596 pso_num=24 pso_serial#=179 2025-07-21 22:17:37.893353 :B52D5851:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=18596 (legacy spawn) 2025-07-21 22:17:37.899796 :B52D5852: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-07-21 22:17:37.899962 :B52D585B: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-07-21 22:17:37.900779 :B52D585C:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:17:38.341195 :B52D5893:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:17:38.332 2025-07-21 22:17:38.341197 :B52D5894:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=7468 pso_num=24 pso_serial#=180 2025-07-21 22:17:38.341338 :B52D5895:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=7468 (legacy spawn) 2025-07-21 22:17:38.347947 :B52D5896: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-07-21 22:17:38.348116 :B52D589E: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-07-21 22:17:38.348962 :B52D58A0:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:18:02.350873 :B52D6049:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:18:02.345 2025-07-21 22:18:02.350875 :B52D604A:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=17412 pso_num=24 pso_serial#=181 2025-07-21 22:18:02.351021 :B52D604B:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=17412 osp_idx=22 osp_ver=600461 osp_pg=0 (spawn #409204) 2025-07-21 22:18:02.351022 :B52D604C:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-21 22:18:02.351022 :B52D604D:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=196 time=1817058251 2025-07-21 22:18:02.351023 :B52D604E:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-07-21 22:18:02.351023 :B52D604F:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-07-21 22:18:02.351023 :B52D6050:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-07-21 22:18:02.351024 :B52D6051:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-21 22:18:02.351024 :B52D6052:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-21 22:18:02.351511 :B52D6053: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-07-21 22:18:02.352170 :B52D6068: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-07-21 22:18:02.363225 :B52D6084:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-07-21 22:18:02.363699 :B52D6085:db_trace:kwqid.c@2146:kwqidrdq(): [10960:24:193] kwqidrdq: Error: 1403 occured in OCI execute 2025-07-21 22:18:02.366031 :B52D6086:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-07-21 22:18:02.366455 :B52D6087: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-07-21 22:18:02.366494 :B52D608A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-07-21 22:18:02.367384 :B52D6090: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-07-21 22:18:02.367504 :B52D6099: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-07-21 22:18:32.467275 :B52D6A6E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:18:35.848929 :B52D6B69:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:18:35.841 2025-07-21 22:18:35.848930 :B52D6B6A:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=4920 pso_num=24 pso_serial#=182 2025-07-21 22:18:35.849078 :B52D6B6B:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=4920 (legacy spawn) 2025-07-21 22:18:35.855793 :B52D6B6C: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-07-21 22:18:35.856001 :B52D6B71: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-07-21 22:18:35.856880 :B52D6B76:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:18:46.551588 :B52D6EA5:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:18:46.538 2025-07-21 22:18:46.551590 :B52D6EA6:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=15304 pso_num=24 pso_serial#=183 2025-07-21 22:18:46.551728 :B52D6EA7:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=15304 (legacy spawn) 2025-07-21 22:18:46.558256 :B52D6EA8: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-07-21 22:18:46.558434 :B52D6EAD: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-07-21 22:18:46.559245 :B52D6EB2:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:18:47.599543 :B52D6F51:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:18:47.585 2025-07-21 22:18:47.599545 :B52D6F52:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=1020 pso_num=24 pso_serial#=184 2025-07-21 22:18:47.599705 :B52D6F53:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=1020 (legacy spawn) 2025-07-21 22:18:47.606090 :B52D6F54: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-07-21 22:18:47.606263 :B52D6F5D: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-07-21 22:18:47.607111 :B52D6F5E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:18:47.625092 :B52D6F61:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:18:47.616 2025-07-21 22:18:47.625094 :B52D6F62:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=8240 pso_num=24 pso_serial#=185 2025-07-21 22:18:47.625234 :B52D6F63:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=8240 (legacy spawn) 2025-07-21 22:18:47.631728 :B52D6F64: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-07-21 22:18:47.631897 :B52D6F6D: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-07-21 22:18:47.632742 :B52D6F6E:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:18:50.692032 :B52D706A:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:18:50.678 2025-07-21 22:18:50.692034 :B52D706B:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=11784 pso_num=24 pso_serial#=186 2025-07-21 22:18:50.692175 :B52D706C:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=11784 (legacy spawn) 2025-07-21 22:18:50.698695 :B52D706D: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-07-21 22:18:50.698867 :B52D7072: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-07-21 22:18:50.699678 :B52D7077:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:18:50.708348 :B52D707A:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:18:50.694 2025-07-21 22:18:50.708350 :B52D707B:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=14676 pso_num=24 pso_serial#=187 2025-07-21 22:18:50.708493 :B52D707C:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=14676 (legacy spawn) 2025-07-21 22:18:50.714951 :B52D707D: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-07-21 22:18:50.715109 :B52D7085: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-07-21 22:18:50.715895 :B52D7087:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-07-21 22:19:02.465832 :B52D744D:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 07-21 22:19:02.452 2025-07-21 22:19:02.465834 :B52D744E:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=15732 pso_num=24 pso_serial#=188 2025-07-21 22:19:02.465960 :B52D744F:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=15732 osp_idx=22 osp_ver=600468 osp_pg=0 (spawn #409206) 2025-07-21 22:19:02.465960 :B52D7450:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-21 22:19:02.465961 :B52D7451:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=197 time=1817118345 2025-07-21 22:19:02.465961 :B52D7452:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-07-21 22:19:02.465962 :B52D7453:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-07-21 22:19:02.465962 :B52D7454:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-07-21 22:19:02.465962 :B52D7455:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-21 22:19:02.465963 :B52D7456:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-21 22:19:02.466451 :B52D7457: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-07-21 22:19:02.467094 :B52D746C: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-07-21 22:19:02.474759 :B52D7489:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-07-21 22:19:02.475169 :B52D748A: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-07-21 22:19:02.475205 :B52D748D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-07-21 22:19:02.476037 :B52D7493: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-07-21 22:19:02.476167 :B52D749C: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-07-21 22:19:27.505066 :B52D7D38: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-07-21 22:19:27.505089*:B52D7D3C:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024D4BB58 estart=1753107567 eid=16968327 ctx=0x000000077BD98A08 cwh=0x00000000232802A0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-07-21 22:19:27.505089*:B52D7D3D:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024D4BB58 curCtx=0x000000002328F300 pubTabIdxCnt=0 2025-07-21 22:19:27.505089*:B52D7D3E:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024D4BB58 2025-07-21 22:19:27.505089*:B52D7D3F:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024D4BB58 2025-07-21 22:19:27.505089*:B52D7D40:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024D4BB58 curCtx=0x000000002328F300 xsc->flg4=65792 flags=2 2025-07-21 22:19:27.505089*:B52D7D41:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024D4BB58 2025-07-21 22:19:27.505672 :B52D7D42: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-07-21 22:19:27.511077 :B52D7D4A: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-07-21 22:19:27.511881 :B52D7D52: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-07-21 22:19:27.512011 :B52D7D5A: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: 15732, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de