Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250817100022\orcl_j000_21040_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250817100022\orcl_j000_21040_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:35407M/63366M, Ph+PgF:40677M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 24 Windows thread id: 21040, image: ORACLE.EXE (J000) *** 2025-08-17 10:00:22.625 *** SESSION ID:(193.9763) 2025-08-17 10:00:22.625 *** 2025-08-17 10:00:22.625 Process diagnostic dump for ORACLE.EXE (J000), OS id=21040, pid: 24, proc_ser: 220, sid: 193, sess_ser: 9763 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 21040 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J000) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12934, hash value=1235815238 Current Wait Stack: Not in wait; last wait ended 0.778508 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.778533 sec since last wait 0: waited for 'Disk file operations I/O' FileOperation=0x5, fileno=0x0, filetype=0x3 wait_id=142 seq_num=143 snap_id=1 wait times: snap=0.000232 sec, exc=0.000232 sec, total=0.000232 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#=0x29d4, block#=0x0, blocks=0x0 wait_id=141 seq_num=142 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.005658 sec of elapsed time 2: waited for 'log file sequential read' log#=0x29d4, block#=0x0, blocks=0x0 wait_id=140 seq_num=141 snap_id=1 wait times: snap=0.000022 sec, exc=0.000022 sec, total=0.000022 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.387890 sec of elapsed time 3: waited for 'log file sequential read' log#=0x0, block#=0x3000, blocks=0x800 wait_id=139 seq_num=140 snap_id=1 wait times: snap=0.000340 sec, exc=0.000340 sec, total=0.000340 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000004 sec of elapsed time 4: waited for 'log file sequential read' log#=0x0, block#=0x2800, blocks=0x800 wait_id=138 seq_num=139 snap_id=1 wait times: snap=0.000309 sec, exc=0.000309 sec, total=0.000309 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000014 sec of elapsed time 5: waited for 'log file sequential read' log#=0x0, block#=0x2000, blocks=0x800 wait_id=137 seq_num=138 snap_id=1 wait times: snap=0.000331 sec, exc=0.000331 sec, total=0.000331 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.152877 sec of elapsed time 6: waited for 'log file sequential read' log#=0x29d4, block#=0x800, blocks=0x800 wait_id=136 seq_num=137 snap_id=1 wait times: snap=0.000224 sec, exc=0.000224 sec, total=0.000224 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.001424 sec of elapsed time 7: waited for 'log file sequential read' log#=0x29d4, block#=0x0, blocks=0x0 wait_id=135 seq_num=136 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.000129 sec of elapsed time 8: waited for 'log file sequential read' log#=0x29d4, block#=0x2, blocks=0x7fe wait_id=134 seq_num=135 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.000169 sec of elapsed time 9: waited for 'log file sequential read' log#=0x0, block#=0x1, blocks=0x1 wait_id=133 seq_num=134 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 Sampled Session History of session 193 serial 9763 --------------------------------------------------- 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 --------------------------------------------------- [6 samples, 10:00:16 - 10:00:21] not in wait at each sample [1 sample, 10:00:15] idle wait at each sample [session created at: 10:00:16] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-17 10:00:22.625 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 24 (osid: 21040, J000) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-17 09:58:51.036187 :C0E38268: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-17 09:58:51.037006 :C0E38269:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 09:58:54.113175 :C0E3835E:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 09:58:54.099 2025-08-17 09:58:54.113177 :C0E3835F:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19628 pso_num=24 pso_serial#=208 2025-08-17 09:58:54.113320 :C0E38360:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=19628 (legacy spawn) 2025-08-17 09:58:54.132358 :C0E38361: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-17 09:58:54.132531 :C0E38367: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-17 09:58:54.133373 :C0E3836B:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 09:58:54.142325 :C0E3836E:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 09:58:54.130 2025-08-17 09:58:54.142327 :C0E3836F:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21604 pso_num=24 pso_serial#=209 2025-08-17 09:58:54.142455 :C0E38370:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=21604 (legacy spawn) 2025-08-17 09:58:54.149132 :C0E38371: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-17 09:58:54.149299 :C0E3837A: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-17 09:58:54.150187 :C0E3837B:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 09:58:55.060771 :C0E383AD:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 09:58:55.052 2025-08-17 09:58:55.060773 :C0E383AE:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=22016 pso_num=24 pso_serial#=210 2025-08-17 09:58:55.060908 :C0E383AF:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=22016 (legacy spawn) 2025-08-17 09:58:55.067362 :C0E383B0: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-17 09:58:55.067530 :C0E383B5: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-17 09:58:55.068360 :C0E383BA:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 09:59:14.712847 :C0E38A27:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 09:59:14.704 2025-08-17 09:59:14.712849 :C0E38A28:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=7616 pso_num=24 pso_serial#=211 2025-08-17 09:59:14.712987 :C0E38A29:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=7616 (legacy spawn) 2025-08-17 09:59:14.719537 :C0E38A2A: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-17 09:59:14.719710 :C0E38A2F: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-17 09:59:14.720553 :C0E38A34:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 09:59:20.878093 :C0E38C2C:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 09:59:20.872 2025-08-17 09:59:20.878095 :C0E38C2D:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19852 pso_num=24 pso_serial#=212 2025-08-17 09:59:20.878240 :C0E38C2E:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=19852 osp_idx=22 osp_ver=740997 osp_pg=0 (spawn #497483) 2025-08-17 09:59:20.878241 :C0E38C2F: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-17 09:59:20.878241 :C0E38C30:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=75 time=4105430189 2025-08-17 09:59:20.878242 :C0E38C31:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-17 09:59:20.878242 :C0E38C32:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-17 09:59:20.878242 :C0E38C33:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-17 09:59:20.878242 :C0E38C34:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-17 09:59:20.878243 :C0E38C35:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-17 09:59:20.878740 :C0E38C36: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-17 09:59:20.879361 :C0E38C4B: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-17 09:59:20.887096 :C0E38C67:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-17 09:59:20.887453 :C0E38C68: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-17 09:59:20.887488 :C0E38C6B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-17 09:59:20.888337 :C0E38C71: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-17 09:59:20.888455 :C0E38C7A: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-17 09:59:51.020517 :C0E396DA:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 09:59:57.273922 :C0E398B6:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 09:59:57.265 2025-08-17 09:59:57.273924 :C0E398B7:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21492 pso_num=24 pso_serial#=213 2025-08-17 09:59:57.274061 :C0E398B8:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=21492 (legacy spawn) 2025-08-17 09:59:57.280456 :C0E398B9: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-17 09:59:57.280642 :C0E398BE: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-17 09:59:57.281502 :C0E398C3:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 10:00:03.877680 :C0E39ACA:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 10:00:03.863 2025-08-17 10:00:03.877683 :C0E39ACB:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=19848 pso_num=24 pso_serial#=214 2025-08-17 10:00:03.877826 :C0E39ACC:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=19848 (legacy spawn) 2025-08-17 10:00:03.884311 :C0E39ACD: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-17 10:00:03.884489 :C0E39AD2: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-17 10:00:03.885272 :C0E39AD7:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 10:00:03.894068 :C0E39ADA:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 10:00:03.878 2025-08-17 10:00:03.894070 :C0E39ADB:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21012 pso_num=24 pso_serial#=215 2025-08-17 10:00:03.894237 :C0E39ADC:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=21012 (legacy spawn) 2025-08-17 10:00:03.911663 :C0E39ADD: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-17 10:00:03.911826 :C0E39AE6: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-17 10:00:03.912677 :C0E39AE7:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 10:00:06.873250 :C0E39BDF:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 10:00:06.868 2025-08-17 10:00:06.873252 :C0E39BE0:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=20872 pso_num=24 pso_serial#=216 2025-08-17 10:00:06.873390 :C0E39BE1:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=20872 osp_idx=22 osp_ver=741001 osp_pg=0 (spawn #497485) 2025-08-17 10:00:06.873390 :C0E39BE2: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-17 10:00:06.873391 :C0E39BE3:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=76 time=4105476173 2025-08-17 10:00:06.873391 :C0E39BE4:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-17 10:00:06.873391 :C0E39BE5:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-17 10:00:06.873392 :C0E39BE6:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-17 10:00:06.873392 :C0E39BE7:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-17 10:00:06.873393 :C0E39BE8:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-17 10:00:06.873894 :C0E39BE9: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-17 10:00:06.873945 :C0E39BEF: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-17 10:00:06.893751 :C0E39C00:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 10:00:06.990613 :C0E39C03:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 10:00:06.977 2025-08-17 10:00:06.990615 :C0E39C04:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21932 pso_num=24 pso_serial#=217 2025-08-17 10:00:06.990760 :C0E39C05:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=21932 (legacy spawn) 2025-08-17 10:00:06.997302 :C0E39C06: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-17 10:00:06.997490 :C0E39C0B: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-17 10:00:06.998290 :C0E39C10:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 10:00:07.006996 :C0E39C13:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 10:00:06.993 2025-08-17 10:00:07.006998 :C0E39C14:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=22176 pso_num=24 pso_serial#=218 2025-08-17 10:00:07.007137 :C0E39C15:db_trace:kso.c@4070:ksonfy(): [10420:24:0] kso: new process: pid=22176 (legacy spawn) 2025-08-17 10:00:07.013679 :C0E39C16: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-17 10:00:07.013849 :C0E39C1F: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-17 10:00:07.014689 :C0E39C20:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 10:00:15.898454 :C0E39EF0:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 10:00:15.893 2025-08-17 10:00:15.898456 :C0E39EF1:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=4148 pso_num=24 pso_serial#=219 2025-08-17 10:00:15.898600 :C0E39EF2:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=4148 osp_idx=22 osp_ver=741004 osp_pg=0 (spawn #497486) 2025-08-17 10:00:15.898601 :C0E39EF3: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-17 10:00:15.898602 :C0E39EF4:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=77 time=4105485204 2025-08-17 10:00:15.898602 :C0E39EF5:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-17 10:00:15.898603 :C0E39EF6:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-17 10:00:15.898603 :C0E39EF7:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-17 10:00:15.898603 :C0E39EF8:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-17 10:00:15.898604 :C0E39EF9:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-17 10:00:15.899095 :C0E39EFA: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-17 10:00:15.899143 :C0E39F00: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-17 10:00:15.903482 :C0E39F12:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-17 10:00:15.903530 :C0E39F13:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-17 10:00:15.903804 :C0E39F14:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-17 10:00:15.903821 :C0E39F15:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-17 10:00:15.904040 :C0E39F16:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-17 10:00:15.904053 :C0E39F17:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-17 10:00:15.904347 :C0E39F18:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-17 10:00:15.904360 :C0E39F19:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-17 10:00:15.904584 :C0E39F1A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-17 10:00:15.904598 :C0E39F1B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-17 10:00:15.904831 :C0E39F1C:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:kelt.c:517 2025-08-17 10:00:15.904846 :C0E39F1D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:kelt.c:517 2025-08-17 10:00:15.907299 :C0E39F4B:db_trace:kst.c@698:kstpsodel(): [10280:24:0] kst: process state object about to be deleted 2025-08-17 10:00:16.054944 :C0E3A054:db_trace:kst.c@673:kstipg(): [10280:24:0] kst: process state object created on 08-17 10:00:16.049 2025-08-17 10:00:16.054946 :C0E3A055:db_trace:kst.c@679:kstipg(): [10280:24:0] kst: process info: ospid=21040 pso_num=24 pso_serial#=220 2025-08-17 10:00:16.055083 :C0E3A056:db_trace:kso.c@4093:ksonfy(): [10420:24:0] kso: new process: pid=21040 osp_idx=22 osp_ver=741005 osp_pg=0 (spawn #497488) 2025-08-17 10:00:16.055084 :C0E3A057: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-17 10:00:16.055084 :C0E3A058:db_trace:kso.c@4103:ksonfy(): [10420:24:0] kso: new process: pso_index=24 reservation=78 time=4105485361 2025-08-17 10:00:16.055085 :C0E3A059:db_trace:kso.c@4109:ksonfy(): [10420:24:0] kso: spawn diagnostics: queue time=0 secs 2025-08-17 10:00:16.055085 :C0E3A05A:db_trace:kso.c@4111:ksonfy(): [10420:24:0] kso: spawn diagnostics: fork time=0 secs 2025-08-17 10:00:16.055085 :C0E3A05B:db_trace:kso.c@4113:ksonfy(): [10420:24:0] kso: spawn diagnostics: exec time=0 secs 2025-08-17 10:00:16.055086 :C0E3A05C:db_trace:kso.c@4115:ksonfy(): [10420:24:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-17 10:00:16.055086 :C0E3A05D:db_trace:kso.c@4117:ksonfy(): [10420:24:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-17 10:00:16.055620 :C0E3A05E: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-17 10:00:16.060725 :C0E3A07D: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-17 10:00:16.060766 :C0E3A080:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:jslv.c:9203 2025-08-17 10:00:16.077889 :C0E3A0C0: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-17 10:00:16.078090 :C0E3A0C8: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-17 10:00:16.078249 :C0E3A0D0: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-17 10:00:16.078404 :C0E3A0D8: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-17 10:00:16.078565 :C0E3A0E0: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-17 10:00:16.078722 :C0E3A0E8: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-17 10:00:16.078878 :C0E3A0F0: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-17 10:00:16.079025 :C0E3A0F8: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-17 10:00:16.079169 :C0E3A100: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-17 10:00:16.079309 :C0E3A108: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-17 10:00:16.079463 :C0E3A110: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-17 10:00:16.079602 :C0E3A118: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-17 10:00:16.079743 :C0E3A120: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-17 10:00:16.079956 :C0E3A128: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-17 10:00:16.080159 :C0E3A130: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-17 10:00:16.080306 :C0E3A138: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-17 10:00:16.080718 :C0E3A140: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-17 10:00:16.080984 :C0E3A148: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-17 10:00:16.081189 :C0E3A150: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-17 10:00:16.099714 :C0E3A158: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-17 10:00:17.759608 :C0E3A31A: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-17 10:00:17.780186 :C0E3A322: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-17 10:00:17.782229 :C0E3A32A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpus:psdpgi.c:2235 2025-08-17 10:00:17.782426 :C0E3A32B:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:24:193] atxpop:psdpgi.c:2235 2025-08-17 10:00:17.783363 :C0E3A32C: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-17 10:00:17.783465 :C0E3A32F: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-17 10:00:17.784464 :C0E3A341: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-17 10:00:17.786059 :C0E3A349: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-17 10:00:17.786342 :C0E3A351: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-17 10:00:17.840557*: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-17 10:00:17.840557*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-08-17 10:00:17.840557*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-08-17 10:00:17.840557*:C0E3A359:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000031CAF4C8 estart=1755396017 eid=16777319 ctx=0x000000077D1D13B0 cwh=0x000000002DAE2228 cpu=0 buffg=3 interb=0 r=0 rb=0 w=0 wb=0 2025-08-17 10:00:17.840557*:C0E3A35A:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000031CAF4C8 curCtx=0x00000000319772F0 pubTabIdxCnt=0 2025-08-17 10:00:17.840557*:C0E3A35B:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000031CAF4C8 2025-08-17 10:00:17.840557*:C0E3A35C:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000031CAF4C8 2025-08-17 10:00:17.871803*:C0E3A369:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000031CAF4C8 curCtx=0x00000000319772F0 xsc->flg4=65792 flags=1 2025-08-17 10:00:17.871803*:C0E3A36A:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000031CAF4C8 2025-08-17 10:00:17.871803*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-08-17 10:00:17.871803*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-08-17 10:00:17.871803*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-17 10:00:17.871803*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-08-17 10:00:17.936470 :C0E3A36B: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-17 10:00:19.852434 :C0E3A406: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-17 10:00:19.852445 :C0E3A407:db_trace:ktur.c@3079:ktuabt(): [10444:24:193] ABORT TRANSACTION - xid: 0x000a.00c.00178472 2025-08-17 10:00:22.292762*:C0E3A65F:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000031CA01F0 estart=1755396021 eid=16777838 ctx=0x000000077F58CBF8 cwh=0x0000000024D80338 cpu=0 buffg=3 interb=0 r=0 rb=0 w=0 wb=0 2025-08-17 10:00:22.292762*:C0E3A660:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000031CA01F0 curCtx=0x000000003196AEA0 pubTabIdxCnt=0 2025-08-17 10:00:22.292762*:C0E3A661:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000031CA01F0 2025-08-17 10:00:22.292762*:C0E3A662:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000031CA01F0 2025-08-17 10:00:22.292762*:C0E3A663:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000031CA01F0 curCtx=0x000000003196AEA0 xsc->flg4=65792 flags=1 2025-08-17 10:00:22.292762*:C0E3A664:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000031CA01F0 2025-08-17 10:00:22.297582 :C0E3A665: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-17 10:00:22.299027 :C0E3A66D: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-17 10:00:22.309255 :C0E3A675: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-17 10:00:22.337732 :C0E3A67D: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: 21040, J000)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de