Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250714220006\orcl_j003_16560_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:36345M/63366M, Ph+PgF:42343M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 16560, image: ORACLE.EXE (J003) *** 2025-07-14 22:00:06.268 *** SESSION ID:(233.28973) 2025-07-14 22:00:06.268 *** 2025-07-14 22:00:06.268 Process diagnostic dump for ORACLE.EXE (J003), OS id=16560, pid: 29, proc_ser: 156, sid: 233, sess_ser: 28973 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 16560 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J003) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12757, hash value=2658364552 Current Wait Stack: Not in wait; last wait ended 2.428601 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 2.428635 sec since last wait 0: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0xc9, filetype=0x2 wait_id=40 seq_num=41 snap_id=1 wait times: snap=0.000168 sec, exc=0.000168 sec, total=0.000168 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.067716 sec of elapsed time 1: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=39 seq_num=40 snap_id=1 wait times: snap=0.000008 sec, exc=0.000008 sec, total=0.000008 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.042466 sec of elapsed time 2: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0x3, filetype=0x2 wait_id=38 seq_num=39 snap_id=1 wait times: snap=0.000180 sec, exc=0.000180 sec, total=0.000180 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.713848 sec of elapsed time 3: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=37 seq_num=38 snap_id=1 wait times: snap=0.000003 sec, exc=0.000003 sec, total=0.000003 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.025744 sec of elapsed time 4: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=36 seq_num=37 snap_id=1 wait times: snap=0.000008 sec, exc=0.000008 sec, total=0.000008 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.013119 sec of elapsed time 5: waited for 'db file sequential read' file#=0x2, block#=0x78fa, blocks=0x1 wait_id=35 seq_num=36 snap_id=1 wait times: snap=0.000068 sec, exc=0.000068 sec, total=0.000068 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.049713 sec of elapsed time 6: waited for 'db file sequential read' file#=0x2, block#=0x1e5a, blocks=0x1 wait_id=34 seq_num=35 snap_id=1 wait times: snap=0.005372 sec, exc=0.005372 sec, total=0.005372 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007967 sec of elapsed time 7: waited for 'db file sequential read' file#=0x1, block#=0x2d00, blocks=0x1 wait_id=33 seq_num=34 snap_id=1 wait times: snap=0.000099 sec, exc=0.000099 sec, total=0.000099 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.262289 sec of elapsed time 8: waited for 'db file sequential read' file#=0x1, block#=0x130, blocks=0x1 wait_id=32 seq_num=33 snap_id=1 wait times: snap=0.003642 sec, exc=0.003642 sec, total=0.003642 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000357 sec of elapsed time 9: waited for 'db file sequential read' file#=0x1, block#=0xc8, blocks=0x1 wait_id=31 seq_num=32 snap_id=1 wait times: snap=0.000150 sec, exc=0.000150 sec, total=0.000150 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.008702 sec of elapsed time Sampled Session History of session 233 serial 28973 --------------------------------------------------- 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 --------------------------------------------------- [4 samples, 22:00:02 - 22:00:05] not in wait at each sample [1 sample, 22:00:01] idle wait at each sample [session created at: 22:00:02] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-14 22:00:06.268 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 16560, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-14 00:04:25.632186 :B1A46247:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:04:25.633014 :B1A46248:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:04:28.791396 :B1A4634F:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:04:28.778 2025-07-14 00:04:28.791398 :B1A46350:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=11464 pso_num=29 pso_serial#=141 2025-07-14 00:04:28.791546 :B1A46351:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=11464 (legacy spawn) 2025-07-14 00:04:28.798290 :B1A46352:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:04:28.798457 :B1A46357:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:04:28.799456 :B1A4635C:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:04:28.807886 :B1A4635F:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:04:28.793 2025-07-14 00:04:28.807888 :B1A46360:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=8628 pso_num=29 pso_serial#=142 2025-07-14 00:04:28.808026 :B1A46361:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=8628 (legacy spawn) 2025-07-14 00:04:28.814506 :B1A46362:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:04:28.814537 :B1A46365:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:04:28.814684 :B1A4636C:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:04:28.815494 :B1A46379:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:05:01.930733 :B1A46E65:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:05:01.928 2025-07-14 00:05:01.930735 :B1A46E66:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18248 pso_num=29 pso_serial#=143 2025-07-14 00:05:01.930879 :B1A46E67:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18248 (legacy spawn) 2025-07-14 00:05:01.937329 :B1A46E68:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:05:01.937500 :B1A46E6D:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:05:01.938302 :B1A46E72:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:05:01.967879 :B1A46E75:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:05:01.959 2025-07-14 00:05:01.967881 :B1A46E76:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=14076 pso_num=29 pso_serial#=144 2025-07-14 00:05:01.968015 :B1A46E77:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=14076 (legacy spawn) 2025-07-14 00:05:01.974555 :B1A46E78:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:05:01.974717 :B1A46E80:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:05:01.975571 :B1A46E82:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:05:05.092169 :B1A46F7A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:05:05.078 2025-07-14 00:05:05.092170 :B1A46F7B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=6548 pso_num=29 pso_serial#=145 2025-07-14 00:05:05.092313 :B1A46F7C:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=6548 (legacy spawn) 2025-07-14 00:05:05.098775 :B1A46F7D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:05:05.098946 :B1A46F82:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:05:05.099749 :B1A46F87:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:05:05.108449 :B1A46F8A:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:05:05.094 2025-07-14 00:05:05.108451 :B1A46F8B:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17340 pso_num=29 pso_serial#=146 2025-07-14 00:05:05.108586 :B1A46F8C:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=17340 (legacy spawn) 2025-07-14 00:05:05.115074 :B1A46F8D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:05:05.115248 :B1A46F96:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:05:05.116068 :B1A46F97:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:05:19.836049 :B1A47412:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:05:19.827 2025-07-14 00:05:19.836051 :B1A47413:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18200 pso_num=29 pso_serial#=147 2025-07-14 00:05:19.836185 :B1A47414:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18200 (legacy spawn) 2025-07-14 00:05:19.842598 :B1A47415:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:05:19.842779 :B1A4741A:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:05:19.843559 :B1A4741F:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:05:22.322797 :B1A474E1:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:05:22.314 2025-07-14 00:05:22.322799 :B1A474E2:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18420 pso_num=29 pso_serial#=148 2025-07-14 00:05:22.322951 :B1A474E3:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18420 (legacy spawn) 2025-07-14 00:05:22.329553 :B1A474E4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:05:22.329735 :B1A474E9:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:05:22.330549 :B1A474EE:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:06:14.697190 :B1A48BD2:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:06:14.694 2025-07-14 00:06:14.697193 :B1A48BD3:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18052 pso_num=29 pso_serial#=149 2025-07-14 00:06:14.697327 :B1A48BD4:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18052 (legacy spawn) 2025-07-14 00:06:14.703824 :B1A48BD5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:06:14.704005 :B1A48BDA:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:06:14.704835 :B1A48BDF:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:06:14.713398 :B1A48BE2:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:06:14.710 2025-07-14 00:06:14.713400 :B1A48BE3:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=316 pso_num=29 pso_serial#=150 2025-07-14 00:06:14.713531 :B1A48BE4:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=316 (legacy spawn) 2025-07-14 00:06:14.720034 :B1A48BE5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:06:14.720201 :B1A48BEE:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:06:14.721047 :B1A48BEF:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:06:17.935709 :B1A48CDE:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:06:17.923 2025-07-14 00:06:17.935711 :B1A48CDF:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=16524 pso_num=29 pso_serial#=151 2025-07-14 00:06:17.935846 :B1A48CE0:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=16524 (legacy spawn) 2025-07-14 00:06:17.942619 :B1A48CE1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:06:17.942789 :B1A48CE6:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:06:17.943577 :B1A48CEB:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 00:06:17.952265 :B1A48CEE:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 00:06:17.938 2025-07-14 00:06:17.952267 :B1A48CEF:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18180 pso_num=29 pso_serial#=152 2025-07-14 00:06:17.952404 :B1A48CF0:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18180 (legacy spawn) 2025-07-14 00:06:17.958876 :B1A48CF1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 00:06:17.959041 :B1A48CFA:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 00:06:17.959874 :B1A48CFB:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 01:00:04.951736 :B1A8AE75:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 01:00:04.943 2025-07-14 01:00:04.951738 :B1A8AE76:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=12732 pso_num=29 pso_serial#=153 2025-07-14 01:00:04.951868 :B1A8AE77:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=12732 osp_idx=27 osp_ver=14432 osp_pg=0 (spawn #382914) 2025-07-14 01:00:04.951869 :B1A8AE78:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-14 01:00:04.951870 :B1A8AE79:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=180 time=1135580845 2025-07-14 01:00:04.951871 :B1A8AE7A:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-14 01:00:04.951871 :B1A8AE7B:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-14 01:00:04.951872 :B1A8AE7C:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-14 01:00:04.951872 :B1A8AE7D:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-14 01:00:04.951873 :B1A8AE7E:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-14 01:00:04.952426 :B1A8AE7F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-14 01:00:35.066698 :B1A8BB66:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 08:13:46.500862 :B1CAE8F1:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 08:13:46.492 2025-07-14 08:13:46.500865 :B1CAE8F2:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=5196 pso_num=29 pso_serial#=154 2025-07-14 08:13:46.501233 :B1CAE8F3:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=5196 osp_idx=27 osp_ver=14433 osp_pg=0 (spawn #383925) 2025-07-14 08:13:46.501234 :B1CAE8F4:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-14 08:13:46.501235 :B1CAE8F5:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=181 time=1161602376 2025-07-14 08:13:46.501236 :B1CAE8F6:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-14 08:13:46.501237 :B1CAE8F7:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-14 08:13:46.501238 :B1CAE8F8:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-14 08:13:46.501238 :B1CAE8F9:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-14 08:13:46.501238 :B1CAE8FA:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-14 08:13:46.506426 :B1CAE8FB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-14 08:13:46.506475 :B1CAE901:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 08:13:46.506874 :B1CAE902:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 08:13:48.867226 :B1CAEAD5:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 08:13:48.867 2025-07-14 08:13:48.867227 :B1CAEAD6:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=13572 pso_num=29 pso_serial#=155 2025-07-14 08:13:48.867399 :B1CAEAD7:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=13572 osp_idx=27 osp_ver=14434 osp_pg=0 (spawn #383927) 2025-07-14 08:13:48.867399 :B1CAEAD8:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-14 08:13:48.867400 :B1CAEAD9:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=182 time=1161604751 2025-07-14 08:13:48.867401 :B1CAEADA:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-14 08:13:48.867401 :B1CAEADB:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-14 08:13:48.867402 :B1CAEADC:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-14 08:13:48.867402 :B1CAEADD:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-14 08:13:48.867403 :B1CAEADE:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-14 08:13:48.867940 :B1CAEADF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-14 08:13:48.867984 :B1CAEAE5:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] 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-07-14 08:13:48.868344 :B1CAEAE6:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-14 22:00:02.054983 :B20B8DCE:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-14 22:00:02.049 2025-07-14 22:00:02.054984 :B20B8DCF:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=16560 pso_num=29 pso_serial#=156 2025-07-14 22:00:02.055153 :B20B8DD5:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=16560 osp_idx=27 osp_ver=14435 osp_pg=0 (spawn #385835) 2025-07-14 22:00:02.055154 :B20B8DD6:db_trace:kso.c@4099:ksonfy(): [10420:29:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-14 22:00:02.055155 :B20B8DD7:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=183 time=1211177954 2025-07-14 22:00:02.055155 :B20B8DD8:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-14 22:00:02.055156 :B20B8DD9:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-14 22:00:02.055156 :B20B8DDA:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-14 22:00:02.055157 :B20B8DDB:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-14 22:00:02.055157 :B20B8DDC:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-14 22:00:02.055696 :B20B8DE0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.060556 :B20B8DFA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.060600 :B20B8DFD:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-07-14 22:00:02.078337 :B20B8FD0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.078669 :B20B8FD8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.078851 :B20B8FE0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.079033 :B20B8FE8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.079207 :B20B8FF0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.079387 :B20B8FF9:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.079566 :B20B9001:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.079736 :B20B9009:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.079890 :B20B9011:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.080041 :B20B901D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.080196 :B20B902F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.080361 :B20B9037:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.080509 :B20B903F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.080659 :B20B9047:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.080852 :B20B904F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.081030 :B20B9057:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.081182 :B20B905F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.081346 :B20B9067:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.081658 :B20B9085:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.081828 :B20B908D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.081987 :B20B9095:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.082244 :B20B909D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.082483 :B20B90A5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.082815 :B20B90AD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.083448 :B20B90B5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:02.110786 :B20B90BD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:03.579501*:B20B9318:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000030183AD0 estart=1752501603 eid=20414994 ctx=0x0000000777968158 cwh=0x000000002B560AB8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-07-14 22:00:03.579501*:B20B9319:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000030183AD0 curCtx=0x000000004E24C4B8 pubTabIdxCnt=0 2025-07-14 22:00:03.579501*:B20B931A:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000030183AD0 2025-07-14 22:00:03.579501*:B20B931B:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000030183AD0 2025-07-14 22:00:03.579501*:B20B931C:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000301BAAF8 estart=1752501601 eid=16777456 ctx=0x000000077B54EAC8 cwh=0x000000002B560608 cpu=1265625 buffg=70895 interb=196608 r=24 rb=196608 w=0 wb=0 2025-07-14 22:00:03.579501*:B20B931D:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000301BAAF8 curCtx=0x000000004E061240 pubTabIdxCnt=0 2025-07-14 22:00:03.579501*:B20B931E:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000301BAAF8 2025-07-14 22:00:03.579501*:B20B931F:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000301BAAF8 2025-07-14 22:00:03.579501*:B20B9320:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000030183AD0 curCtx=0x000000004E24C4B8 xsc->flg4=65792 flags=1 2025-07-14 22:00:03.579501*:B20B9321:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000030183AD0 2025-07-14 22:00:03.751796*:B20B933A:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000301BAAF8 curCtx=0x000000004E061240 xsc->flg4=65792 flags=2 2025-07-14 22:00:03.751796*:B20B933B:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000301BAAF8 2025-07-14 22:00:03.759391 :B20B933C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:03.781864 :B20B935F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:03.784228 :B20B9379:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-07-14 22:00:03.784480 :B20B937A:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-07-14 22:00:03.785580 :B20B9383:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:03.785698 :B20B938B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:03.786773 :B20B93A0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:03.788583 :B20B93A8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:03.788984 :B20B93B0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:03.845549*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-07-14 22:00:03.845549*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-14 22:00:03.845549*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-14 22:00:03.861182*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-07-14 22:00:03.861182*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-07-14 22:00:03.861182*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-14 22:00:03.861182*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-14 22:00:03.938370 :B20B945F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:05.834280 :B20B9697:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-14 22:00:05.834295 :B20B9698:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x0004.00a.0000c53c ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 29 (osid: 16560, J003)