Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250622180942\orcl_j000_17796_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:36357M/63366M, Ph+PgF:42596M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 22 Windows thread id: 17796, image: ORACLE.EXE (J000) *** 2025-06-22 18:09:42.808 *** SESSION ID:(177.24127) 2025-06-22 18:09:42.808 *** 2025-06-22 18:09:42.808 Process diagnostic dump for ORACLE.EXE (J000), OS id=17796, pid: 22, proc_ser: 47, sid: 177, sess_ser: 24127 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 17796 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12642, hash value=3498786719 Current Wait Stack: Not in wait; last wait ended 1.061752 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 1.061777 sec since last wait 0: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=143 seq_num=144 snap_id=1 wait times: snap=0.000213 sec, exc=0.000213 sec, total=0.000213 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 1: waited for 'log file sequential read' log#=0x2890, block#=0x0, blocks=0x0 wait_id=142 seq_num=143 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.004033 sec of elapsed time 2: waited for 'log file sequential read' log#=0x2890, block#=0x0, blocks=0x0 wait_id=141 seq_num=142 snap_id=1 wait times: snap=0.000017 sec, exc=0.000017 sec, total=0.000017 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.589426 sec of elapsed time 3: waited for 'log file sequential read' log#=0x0, block#=0x11800, blocks=0x800 wait_id=140 seq_num=141 snap_id=1 wait times: snap=0.000271 sec, exc=0.000271 sec, total=0.000271 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000011 sec of elapsed time 4: waited for 'log file sequential read' log#=0x0, block#=0x11000, blocks=0x800 wait_id=139 seq_num=140 snap_id=1 wait times: snap=0.000298 sec, exc=0.000298 sec, total=0.000298 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.079246 sec of elapsed time 5: waited for 'log file sequential read' log#=0x2890, block#=0x800, blocks=0x800 wait_id=138 seq_num=139 snap_id=1 wait times: snap=0.000200 sec, exc=0.000200 sec, total=0.000200 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.002818 sec of elapsed time 6: waited for 'log file sequential read' log#=0x2890, block#=0x0, blocks=0x0 wait_id=137 seq_num=138 snap_id=1 wait times: snap=0.000002 sec, exc=0.000002 sec, total=0.000002 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000118 sec of elapsed time 7: waited for 'log file sequential read' log#=0x2890, block#=0x2, blocks=0x7fe wait_id=136 seq_num=137 snap_id=1 wait times: snap=0.000188 sec, exc=0.000188 sec, total=0.000188 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000148 sec of elapsed time 8: waited for 'log file sequential read' log#=0x0, block#=0x1, blocks=0x1 wait_id=135 seq_num=136 snap_id=1 wait times: snap=0.000042 sec, exc=0.000042 sec, total=0.000042 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time 9: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x0, filetype=0x3 wait_id=134 seq_num=135 snap_id=1 wait times: snap=0.000197 sec, exc=0.000197 sec, total=0.000197 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000121 sec of elapsed time Sampled Session History of session 177 serial 24127 --------------------------------------------------- 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:09:36 - 18:09:42] not in wait at each sample [1 sample, 18:09:35] idle wait at each sample [session created at: 18:09:35] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-06-22 18:09:42.808 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 22 (osid: 17796, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-06-22 18:07:37.413109 :A83510AB:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=17452 (legacy spawn) 2025-06-22 18:07:37.419870 :A83510AC: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-22 18:07:37.420060 :A83510B2: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-22 18:07:37.420934 :A83510B6:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:07:37.429918 :A83510B9:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:07:37.417 2025-06-22 18:07:37.429920 :A83510BA:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=13668 pso_num=22 pso_serial#=34 2025-06-22 18:07:37.430065 :A83510BB:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=13668 (legacy spawn) 2025-06-22 18:07:37.437103 :A83510BC: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-22 18:07:37.437286 :A83510C1: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-22 18:07:37.438219 :A83510C6:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:07:40.758928 :A83511C4:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:07:40.753 2025-06-22 18:07:40.758930 :A83511C5:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17852 pso_num=22 pso_serial#=35 2025-06-22 18:07:40.759067 :A83511C6:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=17852 osp_idx=0 osp_ver=340277 osp_pg=0 (spawn #311969) 2025-06-22 18:07:40.759068 :A83511C7: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-22 18:07:40.759068 :A83511C8:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=110 time=3591403954 2025-06-22 18:07:40.759069 :A83511C9:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-06-22 18:07:40.759069 :A83511CA:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-06-22 18:07:40.759069 :A83511CB:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-06-22 18:07:40.759070 :A83511CC:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-22 18:07:40.759070 :A83511CD:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-22 18:07:40.759548 :A83511CE: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-22 18:07:40.760170 :A83511E3: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-22 18:07:40.767717 :A83511FF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-06-22 18:07:40.768078 :A8351200: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-22 18:07:40.768114 :A8351203:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-06-22 18:07:40.768981 :A8351209: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-22 18:07:40.769107 :A8351212: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-22 18:08:10.878311 :A8351BA9:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:08:12.346615 :A8351C30:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:08:12.339 2025-06-22 18:08:12.346618 :A8351C31:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=18076 pso_num=22 pso_serial#=36 2025-06-22 18:08:12.346752 :A8351C32:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=18076 (legacy spawn) 2025-06-22 18:08:12.353151 :A8351C33: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-22 18:08:12.353324 :A8351C3C: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-22 18:08:12.354143 :A8351C3D:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:08:13.523286 :A8351CA1:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:08:13.511 2025-06-22 18:08:13.523288 :A8351CA2:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=15976 pso_num=22 pso_serial#=37 2025-06-22 18:08:13.523422 :A8351CA3:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=15976 (legacy spawn) 2025-06-22 18:08:13.529889 :A8351CA4: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-22 18:08:13.530065 :A8351CAA: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-22 18:08:13.530856 :A8351CAE:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:08:13.550552 :A8351CB1:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:08:13.542 2025-06-22 18:08:13.550554 :A8351CB2:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=12464 pso_num=22 pso_serial#=38 2025-06-22 18:08:13.550687 :A8351CB3:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=12464 (legacy spawn) 2025-06-22 18:08:13.557314 :A8351CB4: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-22 18:08:13.557485 :A8351CB9: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-22 18:08:13.558352 :A8351CBE:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:08:40.837245 :A8352519:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:08:40.832 2025-06-22 18:08:40.837248 :A835251A:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17688 pso_num=22 pso_serial#=39 2025-06-22 18:08:40.837387 :A835251B:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=17688 osp_idx=0 osp_ver=340281 osp_pg=0 (spawn #311971) 2025-06-22 18:08:40.837388 :A835251C: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-22 18:08:40.837388 :A835251D:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=111 time=3591464032 2025-06-22 18:08:40.837388 :A835251E:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-06-22 18:08:40.837389 :A835251F:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-06-22 18:08:40.837389 :A8352520:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-06-22 18:08:40.837389 :A8352521:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-22 18:08:40.837389 :A8352522:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-22 18:08:40.837893 :A8352523: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-22 18:08:40.838573 :A8352538: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-22 18:08:40.849692 :A8352554:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-06-22 18:08:40.850163 :A8352555:db_trace:kwqid.c@2146:kwqidrdq(): [10960:22:177] kwqidrdq: Error: 1403 occured in OCI execute 2025-06-22 18:08:40.852460 :A8352556:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-06-22 18:08:40.852850 :A8352557: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-22 18:08:40.852887 :A835255A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-06-22 18:08:40.853755 :A8352560: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-22 18:08:40.853878 :A8352569: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-22 18:09:10.899782 :A8352F08:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:09:14.496456 :A8353019:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:09:14.488 2025-06-22 18:09:14.496458 :A835301A:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=18100 pso_num=22 pso_serial#=40 2025-06-22 18:09:14.496596 :A835301B:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=18100 (legacy spawn) 2025-06-22 18:09:14.503026 :A835301C: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-22 18:09:14.503200 :A8353021: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-22 18:09:14.504019 :A8353026:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:09:18.043259 :A8353151:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:09:18.034 2025-06-22 18:09:18.043261 :A8353152:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=18384 pso_num=22 pso_serial#=41 2025-06-22 18:09:18.043401 :A8353153:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=18384 (legacy spawn) 2025-06-22 18:09:18.049906 :A8353154: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-22 18:09:18.050159 :A8353159: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-22 18:09:18.051121 :A835316C:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:09:23.248058 :A83532CB:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:09:23.245 2025-06-22 18:09:23.248060 :A83532CC:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=8784 pso_num=22 pso_serial#=42 2025-06-22 18:09:23.248209 :A83532CD:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=8784 (legacy spawn) 2025-06-22 18:09:23.254879 :A83532CE: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-22 18:09:23.255070 :A83532D3: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-22 18:09:23.255909 :A83532D8:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:09:23.265572 :A83532DB:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:09:23.261 2025-06-22 18:09:23.265575 :A83532DC:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=18320 pso_num=22 pso_serial#=43 2025-06-22 18:09:23.265724 :A83532DD:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=18320 (legacy spawn) 2025-06-22 18:09:23.273679 :A83532DE: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-22 18:09:23.274057 :A83532E7: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-22 18:09:23.276019 :A83532E8:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:09:26.399463 :A83533D9:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:09:26.386 2025-06-22 18:09:26.399465 :A83533DA:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17772 pso_num=22 pso_serial#=44 2025-06-22 18:09:26.399600 :A83533DB:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=17772 (legacy spawn) 2025-06-22 18:09:26.406112 :A83533DC: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-22 18:09:26.406281 :A83533E1: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-22 18:09:26.407066 :A83533E6:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:09:26.426310 :A83533E9:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:09:26.417 2025-06-22 18:09:26.426312 :A83533EA:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=18284 pso_num=22 pso_serial#=45 2025-06-22 18:09:26.426445 :A83533EB:db_trace:kso.c@4070:ksonfy(): [10420:22:0] kso: new process: pid=18284 (legacy spawn) 2025-06-22 18:09:26.432846 :A83533EC: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-22 18:09:26.433042 :A83533F5: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-22 18:09:26.433894 :A83533F6:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:09:35.605139 :A83536FF:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:09:35.600 2025-06-22 18:09:35.605141 :A8353700:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=13676 pso_num=22 pso_serial#=46 2025-06-22 18:09:35.605272 :A8353701:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=13676 osp_idx=0 osp_ver=340288 osp_pg=0 (spawn #311973) 2025-06-22 18:09:35.605273 :A8353702:db_trace:kso.c@4099:ksonfy(): [10420:22:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-06-22 18:09:35.605273 :A8353703:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=112 time=3591518797 2025-06-22 18:09:35.605274 :A8353704:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-06-22 18:09:35.605274 :A8353705:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-06-22 18:09:35.605274 :A8353706:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-06-22 18:09:35.605275 :A8353707:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-22 18:09:35.605275 :A8353708:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-22 18:09:35.605817 :A8353709:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:22:177] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-06-22 18:09:35.605858 :A835370F:db_trace:ksl2.c@12699:ksliwat(): [10005:22:177] KSL POST RCVD poster=18 loc='ksv2.h LINE:1639 ID:ksvpst: run' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-06-22 18:09:35.638159 :A83537A4:db_trace:kst.c@698:kstpsodel(): [10280:22:0] kst: process state object about to be deleted 2025-06-22 18:09:35.722240 :A8353886:db_trace:kst.c@673:kstipg(): [10280:22:0] kst: process state object created on 06-22 18:09:35.709 2025-06-22 18:09:35.722244 :A8353887:db_trace:kst.c@679:kstipg(): [10280:22:0] kst: process info: ospid=17796 pso_num=22 pso_serial#=47 2025-06-22 18:09:35.722515 :A8353888:db_trace:kso.c@4093:ksonfy(): [10420:22:0] kso: new process: pid=17796 osp_idx=0 osp_ver=340289 osp_pg=0 (spawn #311976) 2025-06-22 18:09:35.722516 :A8353889: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-22 18:09:35.722516 :A835388A:db_trace:kso.c@4103:ksonfy(): [10420:22:0] kso: new process: pso_index=22 reservation=113 time=3591518907 2025-06-22 18:09:35.722516 :A835388B:db_trace:kso.c@4109:ksonfy(): [10420:22:0] kso: spawn diagnostics: queue time=0 secs 2025-06-22 18:09:35.722517 :A835388C:db_trace:kso.c@4111:ksonfy(): [10420:22:0] kso: spawn diagnostics: fork time=0 secs 2025-06-22 18:09:35.722517 :A835388D:db_trace:kso.c@4113:ksonfy(): [10420:22:0] kso: spawn diagnostics: exec time=0 secs 2025-06-22 18:09:35.722517 :A835388E:db_trace:kso.c@4115:ksonfy(): [10420:22:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-06-22 18:09:35.722518 :A835388F:db_trace:kso.c@4117:ksonfy(): [10420:22:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-06-22 18:09:35.723245 :A8353890: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-22 18:09:35.728265 :A83538AF: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-22 18:09:35.728306 :A83538B2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:jslv.c:9203 2025-06-22 18:09:35.745304 :A83538C8: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-22 18:09:35.745506 :A83538D0: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-22 18:09:35.745666 :A83538D8: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-22 18:09:35.745816 :A83538E0: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-22 18:09:35.745972 :A83538E8: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-22 18:09:35.746125 :A83538F0: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-22 18:09:35.746280 :A83538F8: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-22 18:09:35.746437 :A8353900: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-22 18:09:35.746578 :A8353908: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-22 18:09:35.746718 :A8353910: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-22 18:09:35.746857 :A8353918: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-22 18:09:35.747003 :A8353920: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-22 18:09:35.747140 :A8353928: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-22 18:09:35.747280 :A8353930: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-22 18:09:35.747448 :A8353938: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-22 18:09:35.747640 :A8353940: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-22 18:09:35.747962 :A8353948: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-22 18:09:35.748221 :A8353950: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-22 18:09:35.766918 :A8353958: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-22 18:09:36.771882*:A83539E3:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024AE3AD0 estart=1750586975 eid=19698621 ctx=0x0000000777968158 cwh=0x00000000299A0068 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-06-22 18:09:36.771882*:A83539E4:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024AE3AD0 curCtx=0x0000000029A619A8 pubTabIdxCnt=0 2025-06-22 18:09:36.771882*:A83539E5:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024AE3AD0 2025-06-22 18:09:36.771882*:A83539E6:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024AE3AD0 2025-06-22 18:09:36.771882*:A83539E7:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024B5B820 estart=1750586975 eid=16777409 ctx=0x000000077B54EAC8 cwh=0x000000000FD00608 cpu=796875 buffg=45364 interb=196608 r=24 rb=196608 w=0 wb=0 2025-06-22 18:09:36.771882*:A83539E8:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024B5B820 curCtx=0x0000000029A69FF0 pubTabIdxCnt=0 2025-06-22 18:09:36.771882*:A83539E9:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024B5B820 2025-06-22 18:09:36.771882*:A83539EA:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024B5B820 2025-06-22 18:09:36.771882*:A83539EB:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024AE3AD0 curCtx=0x0000000029A619A8 xsc->flg4=65792 flags=1 2025-06-22 18:09:36.771882*:A83539EC:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024AE3AD0 2025-06-22 18:09:37.427962 :A8353AC8: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-22 18:09:37.443696*:A8353AF2:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024B5B820 curCtx=0x0000000029A69FF0 xsc->flg4=65792 flags=2 2025-06-22 18:09:37.443696*:A8353AF3:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024B5B820 2025-06-22 18:09:37.451917 :A8353AF4: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-22 18:09:37.474197 :A8353B16: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-22 18:09:37.476616 :A8353B2A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpus:psdpgi.c:2235 2025-06-22 18:09:37.476840 :A8353B2B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:22:177] atxpop:psdpgi.c:2235 2025-06-22 18:09:37.477907 :A8353B2C: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-22 18:09:37.478017 :A8353B2F: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-22 18:09:37.479010 :A8353B41: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-22 18:09:37.480750 :A8353B49: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-22 18:09:37.481127 :A8353B51: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-22 18:09:37.521823*: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-22 18:09:37.521823*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-06-22 18:09:37.521823*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-06-22 18:09:37.521823*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-06-22 18:09:37.521823*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-06-22 18:09:37.521823*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-06-22 18:09:37.521823*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-06-22 18:09:37.593838 :A8353B9C: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-22 18:09:39.478884 :A8353C26: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-22 18:09:39.478899 :A8353C27:db_trace:ktur.c@3079:ktuabt(): [10444:22:177] ABORT TRANSACTION - xid: 0x000a.00e.0016f4d4 2025-06-22 18:09:42.201183 :A8353E5C: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-22 18:09:42.202550 :A8353E64: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-22 18:09:42.212977 :A8353E6C: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-22 18:09:42.237958 :A8353E74: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: 17796, J000)