Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250715081437\orcl_j000_17752_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250715081437\orcl_j000_17752_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:36325M/63366M, Ph+PgF:42269M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 22 Windows thread id: 17752, image: ORACLE.EXE (J000) *** 2025-07-15 08:14:38.055 *** SESSION ID:(177.49739) 2025-07-15 08:14:38.055 *** 2025-07-15 08:14:38.055 Process diagnostic dump for ORACLE.EXE (J000), OS id=17752, pid: 22, proc_ser: 111, sid: 177, sess_ser: 49739 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 17752 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=20 seq_num=21 snap_id=1 wait times: snap=0.320776 sec, exc=0.320776 sec, total=0.320776 sec wait times: max=0.500000 sec, heur=10.362985 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.000006 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=19 seq_num=20 snap_id=1 wait times: snap=0.499992 sec, exc=0.499992 sec, total=0.499992 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000006 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=18 seq_num=19 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.000011 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=17 seq_num=18 snap_id=1 wait times: snap=0.510101 sec, exc=0.510101 sec, total=0.510101 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000010 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=16 seq_num=17 snap_id=1 wait times: snap=0.499996 sec, exc=0.499996 sec, total=0.499996 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=15 seq_num=16 snap_id=1 wait times: snap=0.510109 sec, exc=0.510109 sec, total=0.510109 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=14 seq_num=15 snap_id=1 wait times: snap=0.500003 sec, exc=0.500003 sec, total=0.500003 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=13 seq_num=14 snap_id=1 wait times: snap=0.499994 sec, exc=0.499994 sec, total=0.499994 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time 7: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=12 seq_num=13 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.000006 sec of elapsed time 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=11 seq_num=12 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.000007 sec of elapsed time 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=10 seq_num=11 snap_id=1 wait times: snap=0.499987 sec, exc=0.499987 sec, total=0.499987 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 177 serial 49739 --------------------------------------------------- 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 --------------------------------------------------- [11 samples, 08:14:27 - 08:14:38] idle wait at each sample [session created at: 08:14:27] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-15 08:14:38.055 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 22 (osid: 17752, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-15 08:11:02.378045 :B23C49D9:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=34 time=1247838267 2025-07-15 08:11:02.378045 :B23C49DA:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-07-15 08:11:02.378045 :B23C49DB:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-07-15 08:11:02.378046 :B23C49DC:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-07-15 08:11:02.378046 :B23C49DD:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-15 08:11:02.378047 :B23C49DE:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-15 08:11:02.378529 :B23C49DF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-15 08:11:02.379168 :B23C49F4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:11:02.386707 :B23C4A10:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-07-15 08:11:02.387072 :B23C4A11:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:11:02.387108 :B23C4A14:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-07-15 08:11:02.387952 :B23C4A1A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:11:02.388062 :B23C4A23:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:11:32.480306 :B23C5474:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:11:43.420055 :B23C57C8:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:11:43.406 2025-07-15 08:11:43.420057 :B23C57C9:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=14972 pso_num=22 pso_serial#=95 2025-07-15 08:11:43.420195 :B23C57CA:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=14972 (legacy spawn) 2025-07-15 08:11:43.426613 :B23C57D6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:11:43.426793 :B23C57DE:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:11:43.427604 :B23C57DF:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:11:43.436359 :B23C57E2:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:11:43.422 2025-07-15 08:11:43.436361 :B23C57E3:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=12112 pso_num=22 pso_serial#=96 2025-07-15 08:11:43.436499 :B23C57E4:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=12112 (legacy spawn) 2025-07-15 08:11:43.456503 :B23C57E5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:11:43.456672 :B23C57EB:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:11:43.457477 :B23C57EF:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:11:46.518123 :B23C58E5:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:11:46.504 2025-07-15 08:11:46.518125 :B23C58E6:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=15376 pso_num=22 pso_serial#=97 2025-07-15 08:11:46.518303 :B23C58E7:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=15376 (legacy spawn) 2025-07-15 08:11:46.524726 :B23C58F8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:11:46.524899 :B23C58FF:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:11:46.525710 :B23C5902:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:11:46.534320 :B23C5905:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:11:46.520 2025-07-15 08:11:46.534323 :B23C5906:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=7436 pso_num=22 pso_serial#=98 2025-07-15 08:11:46.534457 :B23C5907:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=7436 (legacy spawn) 2025-07-15 08:11:46.540877 :B23C5913:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:11:46.541039 :B23C591B:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:11:46.541825 :B23C591C:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:11:49.923196 :B23C5A44:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:11:49.914 2025-07-15 08:11:49.923198 :B23C5A45:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17920 pso_num=22 pso_serial#=99 2025-07-15 08:11:49.923340 :B23C5A46:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=17920 (legacy spawn) 2025-07-15 08:11:49.929867 :B23C5A47:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:11:49.930045 :B23C5A4C:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:11:49.930866 :B23C5A51:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:12:02.465737 :B23C5E30:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:12:02.460 2025-07-15 08:12:02.465739 :B23C5E31:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=5964 pso_num=22 pso_serial#=100 2025-07-15 08:12:02.465900 :B23C5E32:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=5964 osp_idx=0 osp_ver=406642 osp_pg=0 (spawn #387252) 2025-07-15 08:12:02.465901 :B23C5E33:db_trace:kso.c@4099:ksonfy(): [10420:22:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-15 08:12:02.465901 :B23C5E34:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=35 time=1247898361 2025-07-15 08:12:02.465902 :B23C5E35:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-07-15 08:12:02.465902 :B23C5E36:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-07-15 08:12:02.465903 :B23C5E37:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-07-15 08:12:02.465903 :B23C5E38:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-15 08:12:02.465903 :B23C5E39:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-15 08:12:02.466411 :B23C5E3A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-15 08:12:02.467059 :B23C5E4F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:12:02.478009 :B23C5E6B:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-07-15 08:12:02.478533 :B23C5E6C:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-07-15 08:12:02.480846 :B23C5E6D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-07-15 08:12:02.481186 :B23C5E6E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:12:02.481221 :B23C5E71:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-07-15 08:12:02.482087 :B23C5E77:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:12:02.482211 :B23C5E80:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:12:32.582780 :B23C6858:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:12:33.779416 :B23C687A:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:12:33.771 2025-07-15 08:12:33.779418 :B23C687B:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=18052 pso_num=22 pso_serial#=101 2025-07-15 08:12:33.779555 :B23C687C:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=18052 (legacy spawn) 2025-07-15 08:12:33.786074 :B23C687D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:12:33.786259 :B23C6886:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:12:33.787096 :B23C6887:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:12:55.983520 :B23C6FB8:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:12:55.969 2025-07-15 08:12:55.983522 :B23C6FB9:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=16960 pso_num=22 pso_serial#=102 2025-07-15 08:12:55.983654 :B23C6FBA:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=16960 (legacy spawn) 2025-07-15 08:12:55.990125 :B23C6FE3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:12:55.990297 :B23C6FE8:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:12:55.991068 :B23C6FED:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:12:55.999775 :B23C6FF0:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:12:55.985 2025-07-15 08:12:55.999778 :B23C6FF1:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=10764 pso_num=22 pso_serial#=103 2025-07-15 08:12:55.999914 :B23C6FF2:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=10764 (legacy spawn) 2025-07-15 08:12:56.006391 :B23C6FF3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:12:56.006556 :B23C6FFB:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:12:56.007350 :B23C6FFD:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:12:58.248228 :B23C7038:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:12:58.239 2025-07-15 08:12:58.248230 :B23C7039:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=11428 pso_num=22 pso_serial#=104 2025-07-15 08:12:58.248363 :B23C703A:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=11428 (legacy spawn) 2025-07-15 08:12:58.254840 :B23C703B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:12:58.255010 :B23C7040:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:12:58.255806 :B23C7045:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:12:59.111558 :B23C7107:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:12:59.098 2025-07-15 08:12:59.111560 :B23C7108:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=8984 pso_num=22 pso_serial#=105 2025-07-15 08:12:59.111698 :B23C7109:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=8984 (legacy spawn) 2025-07-15 08:12:59.118162 :B23C710A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:12:59.118326 :B23C7112:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:12:59.119178 :B23C7114:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:12:59.127870 :B23C7117:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:12:59.114 2025-07-15 08:12:59.127872 :B23C7118:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17612 pso_num=22 pso_serial#=106 2025-07-15 08:12:59.128005 :B23C7119:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=17612 (legacy spawn) 2025-07-15 08:12:59.134539 :B23C711A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:12:59.134726 :B23C7123:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:12:59.135531 :B23C7124:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:13:02.557369 :B23C7220:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:13:02.552 2025-07-15 08:13:02.557371 :B23C7221:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=8240 pso_num=22 pso_serial#=107 2025-07-15 08:13:02.557517 :B23C7222:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=8240 osp_idx=0 osp_ver=406649 osp_pg=0 (spawn #387254) 2025-07-15 08:13:02.557517 :B23C7223:db_trace:kso.c@4099:ksonfy(): [10420:22:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-15 08:13:02.557518 :B23C7224:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=36 time=1247958454 2025-07-15 08:13:02.557518 :B23C7225:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-07-15 08:13:02.557519 :B23C7226:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-07-15 08:13:02.557519 :B23C7227:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-07-15 08:13:02.557519 :B23C7228:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-15 08:13:02.557520 :B23C7229:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-15 08:13:02.558009 :B23C722A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-15 08:13:02.558672 :B23C723F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:13:02.566207 :B23C725C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-07-15 08:13:02.566574 :B23C725D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:13:02.566610 :B23C7260:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-07-15 08:13:02.567464 :B23C7266:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:13:02.567579 :B23C726F:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:13:32.666490 :B23C7C17:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:13:35.394304 :B23C7CFE:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:13:35.381 2025-07-15 08:13:35.394306 :B23C7CFF:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=15780 pso_num=22 pso_serial#=108 2025-07-15 08:13:35.394457 :B23C7D00:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=15780 (legacy spawn) 2025-07-15 08:13:35.401355 :B23C7D01:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:13:35.401528 :B23C7D06:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:13:35.402389 :B23C7D0B:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:13:35.411747 :B23C7D0E:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:13:35.412 2025-07-15 08:13:35.411749 :B23C7D0F:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17868 pso_num=22 pso_serial#=109 2025-07-15 08:13:35.411889 :B23C7D10:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=17868 (legacy spawn) 2025-07-15 08:13:35.418995 :B23C7D11:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:13:35.419030 :B23C7D14:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:13:35.419195 :B23C7D1B:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:13:35.420144 :B23C7D28:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:13:35.998367 :B23C7D37:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:13:35.990 2025-07-15 08:13:35.998369 :B23C7D38:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17732 pso_num=22 pso_serial#=110 2025-07-15 08:13:35.998514 :B23C7D39:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=17732 (legacy spawn) 2025-07-15 08:13:36.004926 :B23C7D3A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:13:36.005093 :B23C7D43:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:13:36.005933 :B23C7D44:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-07-15 08:14:02.668074 :B23C85AC:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 07-15 08:14:02.662 2025-07-15 08:14:02.668076 :B23C85AD:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17752 pso_num=22 pso_serial#=111 2025-07-15 08:14:02.668214 :B23C85AE:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=17752 osp_idx=0 osp_ver=406653 osp_pg=0 (spawn #387256) 2025-07-15 08:14:02.668215 :B23C85AF:db_trace:kso.c@4099:ksonfy(): [10420:22:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-15 08:14:02.668215 :B23C85B0:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=37 time=1248018564 2025-07-15 08:14:02.668215 :B23C85B1:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-07-15 08:14:02.668216 :B23C85B2:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-07-15 08:14:02.668216 :B23C85B3:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-07-15 08:14:02.668216 :B23C85B4:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-15 08:14:02.668217 :B23C85B5:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-15 08:14:02.668725 :B23C85B6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-15 08:14:02.669366 :B23C85CB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:14:02.683463 :B23C85E7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-07-15 08:14:02.683548 :B23C85E8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-07-15 08:14:02.684363 :B23C85E9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-07-15 08:14:02.684702 :B23C85EA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:14:02.684740 :B23C85ED:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-07-15 08:14:02.692631 :B23C85F3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:14:02.692699 :B23C85F6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:ktcc.c:879 2025-07-15 08:14:02.692744 :B23C85F7:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:ktcc.c:879 2025-07-15 08:14:02.693103 :B23C85FD:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-07-15 08:14:02.693477 :B23C85FE:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-07-15 08:14:02.693668 :B23C85FF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-07-15 08:14:02.693900 :B23C8600:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:14:02.693927 :B23C8603:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-07-15 08:14:02.695569 :B23C8609:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-07-15 08:14:02.695801 :B23C860A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:14:02.695833 :B23C860D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-07-15 08:14:02.696775 :B23C8613:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:14:02.696905 :B23C861B:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:14:27.692665 :B23C8E41:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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-15 08:14:27.692688*:B23C8E44:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000000FCCBB58 estart=1752538467 eid=16957878 ctx=0x000000077BD98A08 cwh=0x000000000FC802A0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-07-15 08:14:27.692688*:B23C8E45:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000000FCCBB58 curCtx=0x000000000FC8F300 pubTabIdxCnt=0 2025-07-15 08:14:27.692688*:B23C8E46:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000000FCCBB58 2025-07-15 08:14:27.692688*:B23C8E47:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000000FCCBB58 2025-07-15 08:14:27.692688*:B23C8E48:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000000FCCBB58 curCtx=0x000000000FC8F300 xsc->flg4=65792 flags=2 2025-07-15 08:14:27.692688*:B23C8E49:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000000FCCBB58 2025-07-15 08:14:27.693227 :B23C8E4A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:14:27.698540 :B23C8E52:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:14:27.699388 :B23C8E5A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-15 08:14:27.699519 :B23C8E63:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] 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 22 (osid: 17752, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de