Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250426180657\orcl_j000_8396_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250426180657\orcl_j000_8396_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:37610M/63366M, Ph+PgF:45336M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 22 Windows thread id: 8396, image: ORACLE.EXE (J000) *** 2025-04-26 18:06:57.153 *** SESSION ID:(177.31653) 2025-04-26 18:06:57.153 *** 2025-04-26 18:06:57.153 Process diagnostic dump for ORACLE.EXE (J000), OS id=8396, pid: 22, proc_ser: 191, sid: 177, sess_ser: 31653 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 8396 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=13 seq_num=14 snap_id=1 wait times: snap=0.084217 sec, exc=0.084217 sec, total=0.084217 sec wait times: max=0.500000 sec, heur=6.584132 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.000008 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=12 seq_num=13 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.000011 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=11 seq_num=12 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 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=10 seq_num=11 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=9 seq_num=10 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.000007 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=8 seq_num=9 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.000009 sec of elapsed time 5: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=7 seq_num=8 snap_id=1 wait times: snap=0.500097 sec, exc=0.500097 sec, total=0.500097 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000009 sec of elapsed time 6: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=6 seq_num=7 snap_id=1 wait times: snap=0.500006 sec, exc=0.500006 sec, total=0.500006 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000007 sec of elapsed time 7: 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 8: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 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 9: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.506906 sec, exc=0.506906 sec, total=0.506906 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time Sampled Session History of session 177 serial 31653 --------------------------------------------------- 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 --------------------------------------------------- [7 samples, 18:06:50 - 18:06:57] idle wait at each sample [session created at: 18:06:50] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-04-26 18:06:57.153 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 22 (osid: 8396, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-04-26 18:05:06.730433 :8F1C611C: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-04-26 18:05:06.730591 :8F1C6125: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-04-26 18:05:06.731382 :8F1C6126:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:05:08.325367 :8F1C617F:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:05:08.317 2025-04-26 18:05:08.325369 :8F1C6180:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=220 pso_num=22 pso_serial#=178 2025-04-26 18:05:08.325501 :8F1C6181:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=220 (legacy spawn) 2025-04-26 18:05:08.350414 :8F1C6182: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-04-26 18:05:08.350613 :8F1C6187: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-04-26 18:05:08.351526 :8F1C618C:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:05:10.009029 :8F1C622B:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:05:09.994 2025-04-26 18:05:10.009031 :8F1C622C:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=10508 pso_num=22 pso_serial#=179 2025-04-26 18:05:10.009170 :8F1C622D:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=10508 (legacy spawn) 2025-04-26 18:05:10.015587 :8F1C622E: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-04-26 18:05:10.015757 :8F1C6234: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-04-26 18:05:10.016547 :8F1C6238:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:05:10.025037 :8F1C623B:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:05:10.010 2025-04-26 18:05:10.025039 :8F1C623C:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=3236 pso_num=22 pso_serial#=180 2025-04-26 18:05:10.025171 :8F1C623D:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=3236 (legacy spawn) 2025-04-26 18:05:10.031614 :8F1C623E: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-04-26 18:05:10.031774 :8F1C6247: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-04-26 18:05:10.032577 :8F1C6248:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:05:13.194567 :8F1C6350:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:05:13.188 2025-04-26 18:05:13.194569 :8F1C6351:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=10880 pso_num=22 pso_serial#=181 2025-04-26 18:05:13.194706 :8F1C6352:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=10880 (legacy spawn) 2025-04-26 18:05:13.201136 :8F1C6353: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-04-26 18:05:13.201302 :8F1C6358: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-04-26 18:05:13.202101 :8F1C635D:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:05:13.210698 :8F1C6360:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:05:13.204 2025-04-26 18:05:13.210700 :8F1C6361:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=10448 pso_num=22 pso_serial#=182 2025-04-26 18:05:13.210835 :8F1C6362:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=10448 (legacy spawn) 2025-04-26 18:05:13.217311 :8F1C6363: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-04-26 18:05:13.217474 :8F1C636C: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-04-26 18:05:13.218272 :8F1C636D:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:05:25.208779 :8F1C674D:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:05:25.196 2025-04-26 18:05:25.208781 :8F1C674E:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=7348 pso_num=22 pso_serial#=183 2025-04-26 18:05:25.208914 :8F1C674F:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=7348 (legacy spawn) 2025-04-26 18:05:25.215362 :8F1C6750: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-04-26 18:05:25.215527 :8F1C6755: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-04-26 18:05:25.216312 :8F1C675A:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:05:35.149141 :8F1C6A71:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:05:35.143 2025-04-26 18:05:35.149143 :8F1C6A72:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=10152 pso_num=22 pso_serial#=184 2025-04-26 18:05:35.149281 :8F1C6A73:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=10152 osp_idx=0 osp_ver=126664 osp_pg=0 (spawn #121047) 2025-04-26 18:05:35.149282 :8F1C6A74:db_trace:kso.c@4099:ksonfy(): [10420:22:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-04-26 18:05:35.149282 :8F1C6A75:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=212 time=2961536937 2025-04-26 18:05:35.149282 :8F1C6A76:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-04-26 18:05:35.149283 :8F1C6A77:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-04-26 18:05:35.149283 :8F1C6A78:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-04-26 18:05:35.149283 :8F1C6A79:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-04-26 18:05:35.149284 :8F1C6A7A:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-04-26 18:05:35.149767 :8F1C6A7B: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-04-26 18:05:35.150467 :8F1C6A90: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-04-26 18:05:35.157950 :8F1C6AAC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:05:35.158376 :8F1C6AAD: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-04-26 18:05:35.158411 :8F1C6AB0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:05:35.159318 :8F1C6AB6: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-04-26 18:05:35.159455 :8F1C6ABF: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-04-26 18:06:05.222129 :8F1C7B00:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:06:10.490965 :8F1C7CA8:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:06:10.483 2025-04-26 18:06:10.490967 :8F1C7CA9:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=6652 pso_num=22 pso_serial#=185 2025-04-26 18:06:10.491098 :8F1C7CAA:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=6652 (legacy spawn) 2025-04-26 18:06:10.515921 :8F1C7CAB: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-04-26 18:06:10.516102 :8F1C7CB0: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-04-26 18:06:10.516936 :8F1C7CB5:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:06:14.924092 :8F1C7DFC:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:06:14.915 2025-04-26 18:06:14.924095 :8F1C7DFD:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=9828 pso_num=22 pso_serial#=186 2025-04-26 18:06:14.924236 :8F1C7DFE:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=9828 (legacy spawn) 2025-04-26 18:06:14.930701 :8F1C7DFF: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-04-26 18:06:14.930868 :8F1C7E04: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-04-26 18:06:14.931649 :8F1C7E09:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:06:22.786501 :8F1C8092:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:06:22.783 2025-04-26 18:06:22.786505 :8F1C8093:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=9344 pso_num=22 pso_serial#=187 2025-04-26 18:06:22.786643 :8F1C8094:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=9344 (legacy spawn) 2025-04-26 18:06:22.793026 :8F1C8095: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-04-26 18:06:22.793207 :8F1C809A: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-04-26 18:06:22.794011 :8F1C809F:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:06:22.802619 :8F1C80A2:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:06:22.799 2025-04-26 18:06:22.802621 :8F1C80A3:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=10696 pso_num=22 pso_serial#=188 2025-04-26 18:06:22.802765 :8F1C80A4:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=10696 (legacy spawn) 2025-04-26 18:06:22.809197 :8F1C80A5: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-04-26 18:06:22.809357 :8F1C80AE: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-04-26 18:06:22.810152 :8F1C80AF:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:06:25.985789 :8F1C81C8:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:06:25.973 2025-04-26 18:06:25.985791 :8F1C81C9:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=10960 pso_num=22 pso_serial#=189 2025-04-26 18:06:25.985931 :8F1C81CA:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=10960 (legacy spawn) 2025-04-26 18:06:25.992416 :8F1C81CB: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-04-26 18:06:25.992587 :8F1C81D0: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-04-26 18:06:25.993383 :8F1C81D5:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:06:26.012566 :8F1C81D8:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:06:26.004 2025-04-26 18:06:26.012568 :8F1C81D9:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=10780 pso_num=22 pso_serial#=190 2025-04-26 18:06:26.012705 :8F1C81DA:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=10780 (legacy spawn) 2025-04-26 18:06:26.019086 :8F1C81DB: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-04-26 18:06:26.019251 :8F1C81E4: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-04-26 18:06:26.020069 :8F1C81E5:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-04-26 18:06:35.232863 :8F1C84C5:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 04-26 18:06:35.227 2025-04-26 18:06:35.232865 :8F1C84C6:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=8396 pso_num=22 pso_serial#=191 2025-04-26 18:06:35.233005 :8F1C84C7:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=8396 osp_idx=0 osp_ver=126671 osp_pg=0 (spawn #121049) 2025-04-26 18:06:35.233005 :8F1C84C8:db_trace:kso.c@4099:ksonfy(): [10420:22:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-04-26 18:06:35.233006 :8F1C84C9:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=213 time=2961597031 2025-04-26 18:06:35.233006 :8F1C84CA:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-04-26 18:06:35.233007 :8F1C84CB:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-04-26 18:06:35.233007 :8F1C84CC:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-04-26 18:06:35.233007 :8F1C84CD:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-04-26 18:06:35.233008 :8F1C84CE:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-04-26 18:06:35.233499 :8F1C84CF: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-04-26 18:06:35.234175 :8F1C84E4: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-04-26 18:06:35.245129 :8F1C850B:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-04-26 18:06:35.245600 :8F1C850C:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-04-26 18:06:35.247867 :8F1C850D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:35.248269 :8F1C850E: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-04-26 18:06:35.248308 :8F1C8511:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:35.249189 :8F1C8517: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-04-26 18:06:35.249330 :8F1C8520: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-04-26 18:06:48.826207 :8F1C8AE6: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-04-26 18:06:48.927825 :8F1C8E17: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-04-26 18:06:48.927825*:8F1C8E26:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000000FCDC718 estart=1745662008 eid=16779317 ctx=0x000000077FD6A000 cwh=0x000000000FCD0068 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-04-26 18:06:48.927825*:8F1C8E27:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000000FCDC718 curCtx=0x000000000FCD8938 pubTabIdxCnt=0 2025-04-26 18:06:48.927825*:8F1C8E28:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000000FCDC718 2025-04-26 18:06:48.927825*:8F1C8E29:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000000FCDC718 2025-04-26 18:06:48.927825*:8F1C8E2A:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000000FCDC718 curCtx=0x000000000FCD8938 xsc->flg4=65792 flags=2 2025-04-26 18:06:48.927825*:8F1C8E2B:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000000FCDC718 2025-04-26 18:06:48.929869 :8F1C8E2C: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-04-26 18:06:48.929903 :8F1C8E2F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:jslv.c:9203 2025-04-26 18:06:48.933564 :8F1C8E49: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-04-26 18:06:49.038569 :8F1C8E5C: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-04-26 18:06:49.165373 :8F1C8E74: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-04-26 18:06:49.290519 :8F1C8E7C: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-04-26 18:06:50.399338 :8F1C8EE8: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-04-26 18:06:50.402072 :8F1C8EF0: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-04-26 18:06:50.403064 :8F1C8EF8: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-04-26 18:06:50.404939 :8F1C8F00: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-04-26 18:06:50.406493 :8F1C8F08: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-04-26 18:06:50.409134 :8F1C8F10: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-04-26 18:06:50.412448 :8F1C8F18: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-04-26 18:06:50.427424 :8F1C8F20: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-04-26 18:06:50.428106 :8F1C8F28: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-04-26 18:06:50.428766 :8F1C8F30: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-04-26 18:06:50.429304 :8F1C8F38: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-04-26 18:06:50.431913 :8F1C8F40: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-04-26 18:06:50.432969 :8F1C8F48:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:50.433756 :8F1C8F49:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:50.434517 :8F1C8F4A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:50.434938 :8F1C8F4B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:50.434944 :8F1C8F4C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:50.435511 :8F1C8F4D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:50.436002 :8F1C8F4E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:50.436331 :8F1C8F4F:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:50.437475 :8F1C8F50:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:50.466832 :8F1C8F51: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-04-26 18:06:50.466883 :8F1C8F54:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:50.467883 :8F1C8F5A: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-04-26 18:06:50.468814 :8F1C8F62:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:50.469302 :8F1C8F63: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-04-26 18:06:50.489319 :8F1C8F6B: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-04-26 18:06:50.489372 :8F1C8F6E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:50.490267 :8F1C8F74: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-04-26 18:06:50.491240 :8F1C8F7C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:50.491695 :8F1C8F7D: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-04-26 18:06:50.508347 :8F1C8F85: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-04-26 18:06:50.508401 :8F1C8F88:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:50.509309 :8F1C8F8E: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-04-26 18:06:50.521336 :8F1C8F96:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:50.521863 :8F1C8F97: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-04-26 18:06:50.542036 :8F1C8FA9: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-04-26 18:06:50.542087 :8F1C8FAC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:50.542989 :8F1C8FB2: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-04-26 18:06:50.543879 :8F1C8FBA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-04-26 18:06:50.544319 :8F1C8FBB: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-04-26 18:06:50.565664 :8F1C8FFA: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-04-26 18:06:50.565721 :8F1C8FFD:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-04-26 18:06:50.566631 :8F1C9003: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-04-26 18:06:50.567103 :8F1C900B: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-04-26 18:06:50.567478 :8F1C9013: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-04-26 18:06:50.567661 :8F1C901B: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-04-26 18:06:50.567791 :8F1C9023: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-04-26 18:06:50.567977 :8F1C902B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:jslv.c:9203 2025-04-26 18:06:50.572383 :8F1C902C: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-04-26 18:06:50.572472 :8F1C902F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=59 loc='kkj.h LINE:928 ID:jslve_execute' id1=0 id2=0 name= type=0 2025-04-26 18:06:50.572555 :8F1C9038: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: 8396, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de