Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250628180742\orcl_j000_17072_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250628180742\orcl_j000_17072_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:36371M/63366M, Ph+PgF:42462M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 22 Windows thread id: 17072, image: ORACLE.EXE (J000) *** 2025-06-28 18:07:42.662 *** SESSION ID:(177.60471) 2025-06-28 18:07:42.662 *** 2025-06-28 18:07:42.662 Process diagnostic dump for ORACLE.EXE (J000), OS id=17072, pid: 22, proc_ser: 160, sid: 177, sess_ser: 60471 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 17072 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12668, hash value=3713225718 Current Wait Stack: Not in wait; last wait ended 0.988435 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.988461 sec since last wait 0: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=153 seq_num=154 snap_id=1 wait times: snap=0.000207 sec, exc=0.000207 sec, total=0.000207 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000005 sec of elapsed time 1: waited for 'log file sequential read' log#=0x28b4, block#=0x0, blocks=0x0 wait_id=152 seq_num=153 snap_id=1 wait times: snap=0.000005 sec, exc=0.000005 sec, total=0.000005 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.148574 sec of elapsed time 2: waited for 'log file sequential read' log#=0x28b4, block#=0x0, blocks=0x0 wait_id=151 seq_num=152 snap_id=1 wait times: snap=0.000020 sec, exc=0.000020 sec, total=0.000020 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.392435 sec of elapsed time 3: waited for 'log file sequential read' log#=0x0, block#=0x12000, blocks=0x800 wait_id=150 seq_num=151 snap_id=1 wait times: snap=0.000288 sec, exc=0.000288 sec, total=0.000288 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000016 sec of elapsed time 4: waited for 'log file sequential read' log#=0x0, block#=0x11800, blocks=0x800 wait_id=149 seq_num=150 snap_id=1 wait times: snap=0.000350 sec, exc=0.000350 sec, total=0.000350 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000342 sec of elapsed time 5: waited for 'log file sequential read' log#=0x0, block#=0x11000, blocks=0x800 wait_id=148 seq_num=149 snap_id=1 wait times: snap=0.001657 sec, exc=0.001657 sec, total=0.001657 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.085494 sec of elapsed time 6: waited for 'log file sequential read' log#=0x28b4, block#=0x0, blocks=0x0 wait_id=147 seq_num=148 snap_id=1 wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000126 sec of elapsed time 7: waited for 'log file sequential read' log#=0x28b4, block#=0x2, blocks=0x7fe wait_id=146 seq_num=147 snap_id=1 wait times: snap=0.000195 sec, exc=0.000195 sec, total=0.000195 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000143 sec of elapsed time 8: waited for 'log file sequential read' log#=0x0, block#=0x1, blocks=0x1 wait_id=145 seq_num=146 snap_id=1 wait times: snap=0.000045 sec, exc=0.000045 sec, total=0.000045 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 9: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x0, filetype=0x3 wait_id=144 seq_num=145 snap_id=1 wait times: snap=0.000202 sec, exc=0.000202 sec, total=0.000202 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000125 sec of elapsed time Sampled Session History of session 177 serial 60471 --------------------------------------------------- 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:07:35 - 18:07:41] not in wait at each sample [5 samples, 18:07:30 - 18:07:34] idle wait at each sample [session created at: 18:07:30] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-06-28 18:07:42.662 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 22 (osid: 17072, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-28 18:05:07.126541 :AADEB5BA: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-06-28 18:05:07.127336 :AADEB5BF:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:05:07.135957 :AADEB5C2:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:05:07.121 2025-06-28 18:05:07.135959 :AADEB5C3:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=15356 pso_num=22 pso_serial#=145 2025-06-28 18:05:07.136141 :AADEB5C4:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=15356 (legacy spawn) 2025-06-28 18:05:07.142648 :AADEB5C5: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-06-28 18:05:07.142829 :AADEB5CD: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-06-28 18:05:07.143641 :AADEB5CF:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:05:10.195845 :AADEB6C6:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:05:10.194 2025-06-28 18:05:10.195848 :AADEB6C7:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=15828 pso_num=22 pso_serial#=146 2025-06-28 18:05:10.195984 :AADEB6C8:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=15828 (legacy spawn) 2025-06-28 18:05:10.202341 :AADEB6C9: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-06-28 18:05:10.202515 :AADEB6CE: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-06-28 18:05:10.203290 :AADEB6D3:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:05:10.212051 :AADEB6D6:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:05:10.209 2025-06-28 18:05:10.212053 :AADEB6D7:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=9728 pso_num=22 pso_serial#=147 2025-06-28 18:05:10.212189 :AADEB6D8:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=9728 (legacy spawn) 2025-06-28 18:05:10.218569 :AADEB6D9: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-06-28 18:05:10.218737 :AADEB6E2: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-06-28 18:05:10.219551 :AADEB6E3:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:05:11.108765 :AADEB705:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:05:11.100 2025-06-28 18:05:11.108767 :AADEB706:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=15164 pso_num=22 pso_serial#=148 2025-06-28 18:05:11.108902 :AADEB707:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=15164 (legacy spawn) 2025-06-28 18:05:11.115363 :AADEB708: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-06-28 18:05:11.115531 :AADEB711: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-06-28 18:05:11.116365 :AADEB712:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:05:11.125091 :AADEB715:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:05:11.116 2025-06-28 18:05:11.125093 :AADEB716:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17488 pso_num=22 pso_serial#=149 2025-06-28 18:05:11.125231 :AADEB717:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=17488 (legacy spawn) 2025-06-28 18:05:11.131691 :AADEB718: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-06-28 18:05:11.131860 :AADEB721: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-06-28 18:05:11.132671 :AADEB722:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:05:21.154867 :AADEBA55:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:05:21.146 2025-06-28 18:05:21.154870 :AADEBA56:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17868 pso_num=22 pso_serial#=150 2025-06-28 18:05:21.155002 :AADEBA57:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=17868 (legacy spawn) 2025-06-28 18:05:21.161450 :AADEBA58: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-06-28 18:05:21.161642 :AADEBA5D: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-06-28 18:05:21.162439 :AADEBA62:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:05:28.913672 :AADEBCD8:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:05:28.905 2025-06-28 18:05:28.913673 :AADEBCD9:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=13716 pso_num=22 pso_serial#=151 2025-06-28 18:05:28.913817 :AADEBCDA:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=13716 (legacy spawn) 2025-06-28 18:05:28.920363 :AADEBCDB: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-06-28 18:05:28.920531 :AADEBCE4: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-06-28 18:05:28.921348 :AADEBCE5:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:05:29.910746 :AADEBD2F:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:05:29.905 2025-06-28 18:05:29.910748 :AADEBD30:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=12944 pso_num=22 pso_serial#=152 2025-06-28 18:05:29.910886 :AADEBD31:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=12944 osp_idx=0 osp_ver=355694 osp_pg=0 (spawn #331964) 2025-06-28 18:05:29.910887 :AADEBD32:db_trace:kso.c@4099:ksonfy(): [10420:22:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-28 18:05:29.910887 :AADEBD33:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=229 time=4109673094 2025-06-28 18:05:29.910887 :AADEBD34:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-06-28 18:05:29.910888 :AADEBD35:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-06-28 18:05:29.910888 :AADEBD36:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-06-28 18:05:29.910888 :AADEBD37:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-28 18:05:29.910889 :AADEBD38:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-28 18:05:29.911372 :AADEBD39: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-06-28 18:05:29.912009 :AADEBD4E: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-06-28 18:05:29.919484 :AADEBD6A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-06-28 18:05:29.919856 :AADEBD6B: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-06-28 18:05:29.919890 :AADEBD6E:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-06-28 18:05:29.920770 :AADEBD74: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-06-28 18:05:29.920928 :AADEBD7D: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-06-28 18:06:00.008987 :AADECE3A:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:06:19.996219 :AADED472:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:06:19.993 2025-06-28 18:06:19.996221 :AADED473:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=12576 pso_num=22 pso_serial#=153 2025-06-28 18:06:19.996356 :AADED474:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=12576 (legacy spawn) 2025-06-28 18:06:20.002734 :AADED475: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-06-28 18:06:20.002907 :AADED47A: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-06-28 18:06:20.003690 :AADED47F:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:06:20.364428 :AADED495:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:06:20.353 2025-06-28 18:06:20.364430 :AADED496:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=9744 pso_num=22 pso_serial#=154 2025-06-28 18:06:20.364567 :AADED497:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=9744 (legacy spawn) 2025-06-28 18:06:20.371096 :AADED498: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-06-28 18:06:20.371274 :AADED4A1: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-06-28 18:06:20.372071 :AADED4A2:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:06:23.438495 :AADED58A:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:06:23.425 2025-06-28 18:06:23.438497 :AADED58B:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=18400 pso_num=22 pso_serial#=155 2025-06-28 18:06:23.438634 :AADED58C:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=18400 (legacy spawn) 2025-06-28 18:06:23.445067 :AADED58D: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-06-28 18:06:23.445236 :AADED596: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-06-28 18:06:23.446039 :AADED597:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:06:23.454614 :AADED59A:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:06:23.441 2025-06-28 18:06:23.454615 :AADED59B:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=18368 pso_num=22 pso_serial#=156 2025-06-28 18:06:23.454747 :AADED59C:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=18368 (legacy spawn) 2025-06-28 18:06:23.461138 :AADED59D: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-06-28 18:06:23.461299 :AADED5A6: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-06-28 18:06:23.462092 :AADED5A7:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:06:29.983051 :AADED7CE:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:06:29.977 2025-06-28 18:06:29.983053 :AADED7CF:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=16600 pso_num=22 pso_serial#=157 2025-06-28 18:06:29.983192 :AADED7D0:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=16600 osp_idx=0 osp_ver=355699 osp_pg=0 (spawn #331966) 2025-06-28 18:06:29.983193 :AADED7D1:db_trace:kso.c@4099:ksonfy(): [10420:22:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-28 18:06:29.983194 :AADED7D2:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=230 time=4109733172 2025-06-28 18:06:29.983194 :AADED7D3:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-06-28 18:06:29.983195 :AADED7D4:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-06-28 18:06:29.983195 :AADED7D5:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-06-28 18:06:29.983195 :AADED7D6:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-28 18:06:29.983195 :AADED7D7:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-28 18:06:29.983688 :AADED7D8: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-06-28 18:06:29.984328 :AADED7ED: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-06-28 18:06:29.995354 :AADED80A:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-06-28 18:06:29.995835 :AADED80B:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-06-28 18:06:29.998208 :AADED80C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-06-28 18:06:29.998555 :AADED80D: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-06-28 18:06:29.998590 :AADED810:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-06-28 18:06:29.999465 :AADED816: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-06-28 18:06:29.999590 :AADED81F: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-06-28 18:07:00.069115 :AADEE200:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:07:02.475245 :AADEE2B8:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:07:02.467 2025-06-28 18:07:02.475247 :AADEE2B9:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17732 pso_num=22 pso_serial#=158 2025-06-28 18:07:02.475387 :AADEE2BA:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=17732 (legacy spawn) 2025-06-28 18:07:02.481861 :AADEE2BB: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-06-28 18:07:02.482028 :AADEE2C4: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-06-28 18:07:02.482897 :AADEE2C5:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:07:04.461665 :AADEE38C:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:07:04.452 2025-06-28 18:07:04.461667 :AADEE38D:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=13920 pso_num=22 pso_serial#=159 2025-06-28 18:07:04.461802 :AADEE38E:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=13920 (legacy spawn) 2025-06-28 18:07:04.468147 :AADEE38F: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-06-28 18:07:04.468310 :AADEE394: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-06-28 18:07:04.469112 :AADEE399:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-28 18:07:30.043369 :AADEEE6A:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-28 18:07:30.038 2025-06-28 18:07:30.043371 :AADEEE6B:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17072 pso_num=22 pso_serial#=160 2025-06-28 18:07:30.043512 :AADEEE6C:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=17072 osp_idx=0 osp_ver=355702 osp_pg=0 (spawn #331968) 2025-06-28 18:07:30.043513 :AADEEE6D:db_trace:kso.c@4099:ksonfy(): [10420:22:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-28 18:07:30.043513 :AADEEE6E:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=231 time=4109793235 2025-06-28 18:07:30.043513 :AADEEE6F:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-06-28 18:07:30.043514 :AADEEE70:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-06-28 18:07:30.043514 :AADEEE71:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-06-28 18:07:30.043515 :AADEEE72:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-28 18:07:30.043515 :AADEEE73:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-28 18:07:30.044013 :AADEEE74: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-06-28 18:07:30.044675 :AADEEE89: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-06-28 18:07:30.052223 :AADEEEA5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-06-28 18:07:30.052605 :AADEEEA6: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-06-28 18:07:30.052639 :AADEEEA9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-06-28 18:07:30.053493 :AADEEEAF: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-06-28 18:07:30.053610 :AADEEEB8: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-06-28 18:07:35.728392 :AADEF203: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-06-28 18:07:35.729733*:AADEF233:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000000FCDC718 estart=1751105255 eid=16783190 ctx=0x000000077FD6A000 cwh=0x000000000FCD0068 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-06-28 18:07:35.729733*:AADEF234:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000000FCDC718 curCtx=0x000000000FCD8938 pubTabIdxCnt=0 2025-06-28 18:07:35.729733*:AADEF235:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000000FCDC718 2025-06-28 18:07:35.729733*:AADEF236:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000000FCDC718 2025-06-28 18:07:35.729733*:AADEF237:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000000FCDC718 curCtx=0x000000000FCD8938 xsc->flg4=65792 flags=2 2025-06-28 18:07:35.729733*:AADEF238:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000000FCDC718 2025-06-28 18:07:35.733954 :AADEF239: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-06-28 18:07:35.734013 :AADEF23C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:jslv.c:9203 2025-06-28 18:07:35.751746 :AADEF242: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-06-28 18:07:35.751954 :AADEF24A: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-06-28 18:07:35.752113 :AADEF252: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-06-28 18:07:35.752261 :AADEF25A: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-06-28 18:07:35.752422 :AADEF262: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-06-28 18:07:35.752597 :AADEF26A: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-06-28 18:07:35.752760 :AADEF272: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-06-28 18:07:35.752905 :AADEF27A: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-06-28 18:07:35.753227 :AADEF282: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-06-28 18:07:35.753490 :AADEF28A: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-06-28 18:07:35.771938 :AADEF292: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-06-28 18:07:37.454946 :AADEF47C:db_trace:ktu.c@4871:ktuaex1r(): [10442:22:177] Extension usn 8, ext 1, nex 3 2025-06-28 18:07:37.454952 :AADEF47D:db_trace:ktusm.c@2117:ktusmasp(): [10445:22:177] des1:tsn:1 rdba:0x00815e05 where: kdiwh22: kdifind 2025-06-28 18:07:37.456781 :AADEF486: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-06-28 18:07:37.476829 :AADEF49F: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-06-28 18:07:37.478613 :AADEF4D0:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-06-28 18:07:37.478825 :AADEF4D1:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-06-28 18:07:37.479688 :AADEF4D2: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-06-28 18:07:37.479774 :AADEF4D5: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-06-28 18:07:37.480609 :AADEF4E7: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-06-28 18:07:37.482037 :AADEF4F1: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-06-28 18:07:37.482297 :AADEF4FE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-06-28 18:07:37.482353 :AADEF501: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-06-28 18:07:37.521123*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-06-28 18:07:37.521123*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-06-28 18:07:37.521123*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-06-28 18:07:37.552366*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-06-28 18:07:37.552366*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-06-28 18:07:37.552366*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-06-28 18:07:37.552366*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-06-28 18:07:37.621423 :AADEF519: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-06-28 18:07:39.507553 :AADEF5C6: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-06-28 18:07:39.507565 :AADEF5C7:db_trace:ktur.c@3079:ktuabt(): [10444:22:177] ABORT TRANSACTION - xid: 0x0007.000.0000c5f7 2025-06-28 18:07:42.127392 :AADEF752: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-06-28 18:07:42.128744 :AADEF75A: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-06-28 18:07:42.139880 :AADEF762: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-06-28 18:07:42.166588 :AADEF76A: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 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 22 (osid: 17072, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de