Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250816140745\orcl_j000_22520_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250816140745\orcl_j000_22520_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:35432M/63366M, Ph+PgF:40738M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 22520, image: ORACLE.EXE (J000) *** 2025-08-16 14:07:45.469 *** SESSION ID:(193.3947) 2025-08-16 14:07:45.469 *** 2025-08-16 14:07:45.469 Process diagnostic dump for ORACLE.EXE (J000), OS id=22520, pid: 24, proc_ser: 177, sid: 193, sess_ser: 3947 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 22520 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12925, hash value=2280594335 Current Wait Stack: Not in wait; last wait ended 0.887527 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.887556 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.000347 sec, exc=0.000347 sec, total=0.000347 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000007 sec of elapsed time 1: waited for 'log file sequential read' log#=0x29ce, block#=0x0, blocks=0x0 wait_id=152 seq_num=153 snap_id=1 wait times: snap=0.000008 sec, exc=0.000008 sec, total=0.000008 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.022436 sec of elapsed time 2: waited for 'log file sequential read' log#=0x29ce, block#=0x0, blocks=0x0 wait_id=151 seq_num=152 snap_id=1 wait times: snap=0.000019 sec, exc=0.000019 sec, total=0.000019 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.575598 sec of elapsed time 3: waited for 'log file sequential read' log#=0x0, block#=0x9000, blocks=0x800 wait_id=150 seq_num=151 snap_id=1 wait times: snap=0.000334 sec, exc=0.000334 sec, total=0.000334 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.034577 sec of elapsed time 4: waited for 'log file sequential read' log#=0x29ce, block#=0x800, blocks=0x800 wait_id=149 seq_num=150 snap_id=1 wait times: snap=0.000214 sec, exc=0.000214 sec, total=0.000214 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.002613 sec of elapsed time 5: waited for 'log file sequential read' log#=0x29ce, block#=0x0, blocks=0x0 wait_id=148 seq_num=149 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.000133 sec of elapsed time 6: waited for 'log file sequential read' log#=0x29ce, block#=0x2, blocks=0x7fe wait_id=147 seq_num=148 snap_id=1 wait times: snap=0.000211 sec, exc=0.000211 sec, total=0.000211 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000161 sec of elapsed time 7: waited for 'log file sequential read' log#=0x0, block#=0x1, blocks=0x1 wait_id=146 seq_num=147 snap_id=1 wait times: snap=0.000043 sec, exc=0.000043 sec, total=0.000043 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000003 sec of elapsed time 8: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x0, filetype=0x3 wait_id=145 seq_num=146 snap_id=1 wait times: snap=0.000204 sec, exc=0.000204 sec, total=0.000204 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000129 sec of elapsed time 9: waited for 'control file sequential read' file#=0x0, block#=0x20, blocks=0x1 wait_id=144 seq_num=145 snap_id=1 wait times: snap=0.000046 sec, exc=0.000046 sec, total=0.000046 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000007 sec of elapsed time Sampled Session History of session 193 serial 3947 --------------------------------------------------- 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, 14:07:39 - 14:07:45] not in wait at each sample [6 samples, 14:07:32 - 14:07:38] idle wait at each sample [session created at: 14:07:32] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-16 14:07:45.469 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 22520, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-16 13:59:31.735288 :C0846D3D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:00:01.812291 :C084773F:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-16 14:00:15.111171 :C0847BF9:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-16 14:00:15.102 2025-08-16 14:00:15.111172 :C0847BFA:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=22504 pso_num=24 pso_serial#=169 2025-08-16 14:00:15.111306 :C0847BFB:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=22504 osp_idx=22 osp_ver=738404 osp_pg=0 (spawn #494704) 2025-08-16 14:00:15.111306 :C0847BFC:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-16 14:00:15.111307 :C0847BFD:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=120 time=4033484408 2025-08-16 14:00:15.111307 :C0847BFE:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-16 14:00:15.111308 :C0847BFF:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-16 14:00:15.111308 :C0847C00:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-16 14:00:15.111309 :C0847C01:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-16 14:00:15.111309 :C0847C02:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-16 14:00:15.111793 :C0847C03:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.111838 :C0847C09:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] 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-08-16 14:00:15.119077 :C0847C17:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.120130 :C0847C1F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.120678 :C0847C27:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.121212 :C0847C2F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.121662 :C0847C37:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.124065 :C0847C3F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.125154 :C0847C47:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.177886 :C0847C4F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.178767 :C0847C57:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.179100 :C0847C5F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.179330 :C0847C67:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:00:15.181314 :C0847C6F:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-16 14:00:31.834742 :C0848274:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-16 14:00:31.823 2025-08-16 14:00:31.834744 :C0848275:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19488 pso_num=24 pso_serial#=170 2025-08-16 14:00:31.834873 :C0848276:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19488 osp_idx=22 osp_ver=738405 osp_pg=0 (spawn #494706) 2025-08-16 14:00:31.834873 :C0848277:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-16 14:00:31.834874 :C0848278:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=121 time=4033501142 2025-08-16 14:00:31.834874 :C0848279:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-16 14:00:31.834875 :C084827A:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-16 14:00:31.834875 :C084827B:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-16 14:00:31.834875 :C084827C:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-16 14:00:31.834876 :C084827D:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-16 14:00:31.835355 :C084827E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:01:01.913019 :C0848D9D:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-16 14:01:31.909054 :C0849795:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-16 14:01:31.898 2025-08-16 14:01:31.909056 :C0849796:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21928 pso_num=24 pso_serial#=171 2025-08-16 14:01:31.909185 :C0849797:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=21928 osp_idx=22 osp_ver=738406 osp_pg=0 (spawn #494708) 2025-08-16 14:01:31.909186 :C0849798:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-16 14:01:31.909186 :C0849799:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=122 time=4033561204 2025-08-16 14:01:31.909186 :C084979A:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-16 14:01:31.909187 :C084979B:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-16 14:01:31.909187 :C084979C:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-16 14:01:31.909188 :C084979D:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-16 14:01:31.909188 :C084979E:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-16 14:01:31.909701 :C084979F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:02:01.979127 :C084A179:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-16 14:02:31.991065 :C084ABAC:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-16 14:02:31.980 2025-08-16 14:02:31.991067 :C084ABAD:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20404 pso_num=24 pso_serial#=172 2025-08-16 14:02:31.991188 :C084ABAE:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=20404 osp_idx=22 osp_ver=738407 osp_pg=0 (spawn #494710) 2025-08-16 14:02:31.991189 :C084ABAF:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-16 14:02:31.991189 :C084ABB0:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=123 time=4033621298 2025-08-16 14:02:31.991190 :C084ABB1:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-16 14:02:31.991190 :C084ABB2:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-16 14:02:31.991190 :C084ABB3:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-16 14:02:31.991191 :C084ABB4:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-16 14:02:31.991191 :C084ABB5:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-16 14:02:31.991665 :C084ABB6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:02:47.015006 :C084B214:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-16 14:03:17.153139 :C084BC28:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-16 14:03:32.090793 :C084C14F:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-16 14:03:32.079 2025-08-16 14:03:32.090795 :C084C150:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19596 pso_num=24 pso_serial#=173 2025-08-16 14:03:32.090913 :C084C151:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19596 osp_idx=22 osp_ver=738408 osp_pg=0 (spawn #494714) 2025-08-16 14:03:32.090914 :C084C152:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-16 14:03:32.090914 :C084C153:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=124 time=4033681392 2025-08-16 14:03:32.090915 :C084C154:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-16 14:03:32.090915 :C084C155:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-16 14:03:32.090916 :C084C156:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-16 14:03:32.090916 :C084C157:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-16 14:03:32.090916 :C084C158:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-16 14:03:32.091388 :C084C159:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:04:02.175762 :C084CB4B:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-16 14:04:32.189811 :C084D56B:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-16 14:04:32.178 2025-08-16 14:04:32.189813 :C084D56C:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21772 pso_num=24 pso_serial#=174 2025-08-16 14:04:32.189958 :C084D56D:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=21772 osp_idx=22 osp_ver=738409 osp_pg=0 (spawn #494716) 2025-08-16 14:04:32.189959 :C084D56E:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-16 14:04:32.189960 :C084D56F:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=125 time=4033741486 2025-08-16 14:04:32.189960 :C084D570:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-16 14:04:32.189960 :C084D571:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-16 14:04:32.189961 :C084D572:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-16 14:04:32.189962 :C084D573:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-16 14:04:32.189962 :C084D574:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-16 14:04:32.190475 :C084D575:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:05:02.253712 :C084DF46:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-16 14:05:32.258221 :C084EF0F:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-16 14:05:32.247 2025-08-16 14:05:32.258223 :C084EF10:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21776 pso_num=24 pso_serial#=175 2025-08-16 14:05:32.258347 :C084EF11:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=21776 osp_idx=22 osp_ver=738410 osp_pg=0 (spawn #494718) 2025-08-16 14:05:32.258347 :C084EF12:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-16 14:05:32.258348 :C084EF13:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=126 time=4033801564 2025-08-16 14:05:32.258348 :C084EF14:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-16 14:05:32.258349 :C084EF15:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-16 14:05:32.258349 :C084EF16:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-16 14:05:32.258349 :C084EF17:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-16 14:05:32.258349 :C084EF18:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-16 14:05:32.258827 :C084EF19:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:06:02.350929 :C084FB2B:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-16 14:06:32.345457 :C0850540:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-16 14:06:32.334 2025-08-16 14:06:32.345459 :C0850541:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20908 pso_num=24 pso_serial#=176 2025-08-16 14:06:32.345597 :C0850542:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=20908 osp_idx=22 osp_ver=738411 osp_pg=0 (spawn #494720) 2025-08-16 14:06:32.345598 :C0850543:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-16 14:06:32.345598 :C0850544:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=127 time=4033861642 2025-08-16 14:06:32.345599 :C0850545:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-16 14:06:32.345599 :C0850546:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-16 14:06:32.345600 :C0850547:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-16 14:06:32.345600 :C0850548:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-16 14:06:32.345600 :C0850549:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-16 14:06:32.346083 :C085054A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:07:02.465799 :C0850F49:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-16 14:07:32.429819 :C0851BE5:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-16 14:07:32.424 2025-08-16 14:07:32.429821 :C0851BE6:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=22520 pso_num=24 pso_serial#=177 2025-08-16 14:07:32.429954 :C0851BE7:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=22520 osp_idx=22 osp_ver=738412 osp_pg=0 (spawn #494721) 2025-08-16 14:07:32.429956 :C0851BE8:db_trace:kso.c@4099:ksonfy(): [10420:24:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-16 14:07:32.429956 :C0851BE9:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=128 time=4033921736 2025-08-16 14:07:32.429957 :C0851BEA:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-16 14:07:32.429957 :C0851BEB:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-16 14:07:32.429957 :C0851BEC:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-16 14:07:32.429958 :C0851BED:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-16 14:07:32.429958 :C0851BEE:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-16 14:07:32.430410 :C0851BEF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-16 14:07:32.430916 :C0851C07:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:32.438792 :C0851C32:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-16 14:07:32.439143 :C0851C33:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:32.439181 :C0851C36:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-16 14:07:32.440092 :C0851C3C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:32.440214 :C0851C45:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=14 loc='ksl2.h LINE:2165 ID:kslpsr' id1=134 id2=0 name=EV type=0 fac#=0 facpost=1 2025-08-16 14:07:38.728770 :C0851FAC:db_trace:ksl2.c@12699:ksliwat(): [10005:24:193] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-16 14:07:38.728770*:C0851FDD:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000026B6C718 estart=1755324458 eid=16786192 ctx=0x000000077FD6A000 cwh=0x0000000026B60068 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-08-16 14:07:38.728770*:C0851FDE:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000026B6C718 curCtx=0x0000000026B68938 pubTabIdxCnt=0 2025-08-16 14:07:38.728770*:C0851FDF:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000026B6C718 2025-08-16 14:07:38.728770*:C0851FE0:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000026B6C718 2025-08-16 14:07:38.728770*:C0851FE1:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000026B6C718 curCtx=0x0000000026B68938 xsc->flg4=65792 flags=2 2025-08-16 14:07:38.728770*:C0851FE2:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000026B6C718 2025-08-16 14:07:38.734965 :C0851FE3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.735006 :C0851FE6:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:jslv.c:9203 2025-08-16 14:07:38.751897 :C0851FEC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.752100 :C0851FF4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.752272 :C0851FFC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.752473 :C0852004:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.752639 :C085200C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.752816 :C0852014:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.753039 :C085201C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.753185 :C0852024:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.753513 :C085202C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.753771 :C0852034:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:38.772061 :C085203C:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 8, ext 1, nex 2 2025-08-16 14:07:38.772068 :C085203D:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:0 rdba:0x00400c39 where: kddwh01: kdddel 2025-08-16 14:07:38.772889 :C085203E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:40.365410*:C0852161:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024A31FA8 estart=1755324460 eid=21429475 ctx=0x0000000777968158 cwh=0x0000000026B906F8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-08-16 14:07:40.365410*:C0852162:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024A31FA8 curCtx=0x000000002930C8D0 pubTabIdxCnt=0 2025-08-16 14:07:40.365410*:C0852163:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024A31FA8 2025-08-16 14:07:40.365410*:C0852164:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024A31FA8 2025-08-16 14:07:40.365410*:C0852165:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000024ACB300 estart=1755324458 eid=16777523 ctx=0x000000077B54EAC8 cwh=0x0000000026B90248 cpu=1406250 buffg=75927 interb=196608 r=24 rb=196608 w=0 wb=0 2025-08-16 14:07:40.365410*:C0852166:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000024ACB300 curCtx=0x0000000029241240 pubTabIdxCnt=0 2025-08-16 14:07:40.365410*:C0852167:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000024ACB300 2025-08-16 14:07:40.365410*:C0852168:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000024ACB300 2025-08-16 14:07:40.365410*:C0852169:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024A31FA8 curCtx=0x000000002930C8D0 xsc->flg4=65792 flags=1 2025-08-16 14:07:40.365410*:C085216A:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024A31FA8 2025-08-16 14:07:40.437870 :C08521A5:db_trace:ktu.c@4871:ktuaex1r(): [10442:24:193] Extension usn 9, ext 0, nex 3 2025-08-16 14:07:40.437878 :C08521A6:db_trace:ktusm.c@2117:ktusmasp(): [10445:24:193] des1:tsn:1 rdba:0x008127ba where: kduwh01: kdusru 2025-08-16 14:07:40.437878*:C08521B8:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000024ACB300 curCtx=0x0000000029241240 xsc->flg4=65792 flags=2 2025-08-16 14:07:40.437878*:C08521B9:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000024ACB300 2025-08-16 14:07:40.442014 :C08521BA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:40.462048 :C08521CB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:40.463959 :C08521DC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-16 14:07:40.464145 :C08521DD:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-16 14:07:40.464966 :C08521E6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:40.465043 :C08521EB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:40.465910 :C0852216:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:40.467386 :C085221E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:40.467655 :C0852226:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:40.506033*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-08-16 14:07:40.506033*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-08-16 14:07:40.506033*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-08-16 14:07:40.521659*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-08-16 14:07:40.521659*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-08-16 14:07:40.521659*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-16 14:07:40.521659*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-08-16 14:07:40.582816 :C0852266:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:42.524259 :C08522F2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:42.524271 :C08522F3:db_trace:ktur.c@3079:ktuabt(): [10444:24:193] ABORT TRANSACTION - xid: 0x0002.018.0000c850 2025-08-16 14:07:45.031402 :C08524A0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:45.032813 :C08524A8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:45.043364 :C08524B0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-16 14:07:45.071538 :C08524B8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:24:193] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 24 (osid: 22520, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de