Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250727060006\orcl_j003_17112_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:36000M/63366M, Ph+PgF:41769M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 29 Windows thread id: 17112, image: ORACLE.EXE (J003) *** 2025-07-27 06:00:06.125 *** SESSION ID:(233.30381) 2025-07-27 06:00:06.125 *** 2025-07-27 06:00:06.125 Process diagnostic dump for ORACLE.EXE (J003), OS id=17112, pid: 29, proc_ser: 92, sid: 233, sess_ser: 30381 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 17112 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J003) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12820, hash value=1610347870 Current Wait Stack: Not in wait; last wait ended 2.208291 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 2.208317 sec since last wait 0: waited for 'Disk file operations I/O' FileOperation=0x2, fileno=0xc9, filetype=0x2 wait_id=45 seq_num=46 snap_id=1 wait times: snap=0.000161 sec, exc=0.000161 sec, total=0.000161 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.063931 sec of elapsed time 1: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=44 seq_num=45 snap_id=1 wait times: snap=0.000006 sec, exc=0.000006 sec, total=0.000006 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.039332 sec of elapsed time 2: waited for 'undo segment extension' segment#=0x8, =0x0, =0x0 wait_id=43 seq_num=44 snap_id=1 wait times: snap=0.046769 sec, exc=0.046769 sec, total=0.046769 sec wait times: max=0.040000 sec wait counts: calls=1 os=1 occurred after 0.000106 sec of elapsed time 3: waited for 'undo segment extension' segment#=0x8, =0x0, =0x0 wait_id=42 seq_num=43 snap_id=1 wait times: snap=0.019874 sec, exc=0.019874 sec, total=0.019874 sec wait times: max=0.020000 sec wait counts: calls=1 os=1 occurred after 0.000020 sec of elapsed time 4: waited for 'undo segment extension' segment#=0x8, =0x0, =0x0 wait_id=41 seq_num=42 snap_id=1 wait times: snap=0.000003 sec, exc=0.000003 sec, total=0.000003 sec wait times: max=0.010000 sec wait counts: calls=1 os=1 occurred after 0.000038 sec of elapsed time 5: waited for 'undo segment extension' segment#=0x8, =0x0, =0x0 wait_id=40 seq_num=41 snap_id=1 wait times: snap=0.000009 sec, exc=0.000009 sec, total=0.000009 sec wait times: max=0.000000 sec wait counts: calls=1 os=1 occurred after 0.001634 sec of elapsed time 6: waited for 'latch: In memory undo latch' address=0x7b9a2b4b8, number=0xf3, tries=0x0 wait_id=39 seq_num=40 snap_id=1 wait times: snap=0.000033 sec, exc=0.000033 sec, total=0.000033 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.709020 sec of elapsed time 7: waited for 'asynch descriptor resize' outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82 wait_id=38 seq_num=39 snap_id=1 wait times: snap=0.000005 sec, exc=0.000005 sec, total=0.000005 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.025235 sec of elapsed time 8: 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.000004 sec, exc=0.000004 sec, total=0.000004 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.012829 sec of elapsed time 9: waited for 'db file sequential read' file#=0x2, block#=0x78fa, blocks=0x1 wait_id=36 seq_num=37 snap_id=1 wait times: snap=0.000067 sec, exc=0.000067 sec, total=0.000067 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.049918 sec of elapsed time Sampled Session History of session 233 serial 30381 --------------------------------------------------- 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, 06:00:02 - 06:00:05] not in wait at each sample [1 sample, 06:00:01] idle wait at each sample [session created at: 06:00:02] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-27 06:00:06.125 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 29 (osid: 17112, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-27 00:05:16.147000 :B76DC8E4: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-27 00:05:16.147046 :B76DC8EA: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-27 00:05:16.151313 :B76DC8F9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-27 00:05:16.151365 :B76DC8FA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-27 00:05:16.151672 :B76DC8FB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-27 00:05:16.151690 :B76DC8FC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-27 00:05:16.151907 :B76DC8FD:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-27 00:05:16.151922 :B76DC8FE:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-27 00:05:16.152134 :B76DC8FF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-27 00:05:16.152147 :B76DC900:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-27 00:05:16.152353 :B76DC901:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-27 00:05:16.152366 :B76DC902:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-27 00:05:16.152574 :B76DC903:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:kelt.c:517 2025-07-27 00:05:16.152587 :B76DC904:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:kelt.c:517 2025-07-27 00:05:16.154846 :B76DC905:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 00:05:51.610708 :B76DD4DB:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 00:05:51.602 2025-07-27 00:05:51.610710 :B76DD4DC:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=14676 pso_num=29 pso_serial#=81 2025-07-27 00:05:51.610841 :B76DD4DD:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=14676 (legacy spawn) 2025-07-27 00:05:51.617294 :B76DD4DE: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-27 00:05:51.617458 :B76DD4E7: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-27 00:05:51.618296 :B76DD4E8:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 00:06:03.120932 :B76DDF2D:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 00:06:03.106 2025-07-27 00:06:03.120935 :B76DDF2E:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=18832 pso_num=29 pso_serial#=82 2025-07-27 00:06:03.121080 :B76DDF2F:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=18832 (legacy spawn) 2025-07-27 00:06:03.127567 :B76DDF30: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-27 00:06:03.127738 :B76DDF35: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-27 00:06:03.128553 :B76DDF3A:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 00:06:03.137264 :B76DDF3D:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 00:06:03.122 2025-07-27 00:06:03.137266 :B76DDF3E:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19368 pso_num=29 pso_serial#=83 2025-07-27 00:06:03.137397 :B76DDF3F:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19368 (legacy spawn) 2025-07-27 00:06:03.143850 :B76DDF40: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-27 00:06:03.144008 :B76DDF49: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-27 00:06:03.144789 :B76DDF4A:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 00:06:06.208121 :B76DE030:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 00:06:06.194 2025-07-27 00:06:06.208123 :B76DE031:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=14932 pso_num=29 pso_serial#=84 2025-07-27 00:06:06.208269 :B76DE032:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=14932 (legacy spawn) 2025-07-27 00:06:06.214873 :B76DE033: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-27 00:06:06.215050 :B76DE038: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-27 00:06:06.215851 :B76DE03D:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 00:06:06.224583 :B76DE040:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 00:06:06.210 2025-07-27 00:06:06.224586 :B76DE041:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=8732 pso_num=29 pso_serial#=85 2025-07-27 00:06:06.224730 :B76DE042:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=8732 (legacy spawn) 2025-07-27 00:06:06.231203 :B76DE043: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-27 00:06:06.231363 :B76DE04C: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-27 00:06:06.232204 :B76DE04D:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 00:06:10.287139 :B76DE18C:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 00:06:10.277 2025-07-27 00:06:10.287141 :B76DE18D:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=12004 pso_num=29 pso_serial#=86 2025-07-27 00:06:10.287278 :B76DE18E:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=12004 (legacy spawn) 2025-07-27 00:06:10.293814 :B76DE18F: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-27 00:06:10.293980 :B76DE198: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-27 00:06:10.294819 :B76DE199:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 01:00:01.249905 :B7720EEB:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 01:00:01.236 2025-07-27 01:00:01.249907 :B7720EEC:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=9252 pso_num=29 pso_serial#=87 2025-07-27 01:00:01.250041 :B7720EED:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=9252 (legacy spawn) 2025-07-27 01:00:01.256525 :B7720EEE: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-27 01:00:01.256693 :B7720EF7: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-27 01:00:01.257490 :B7720EF8:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 01:00:01.275372 :B7720EFB:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 01:00:01.268 2025-07-27 01:00:01.275374 :B7720EFC:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=19260 pso_num=29 pso_serial#=88 2025-07-27 01:00:01.275506 :B7720EFD:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=19260 (legacy spawn) 2025-07-27 01:00:01.282011 :B7720EFE: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-27 01:00:01.282186 :B7720F07: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-27 01:00:01.282996 :B7720F08:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 01:00:10.020597 :B77211B7:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 01:00:10.011 2025-07-27 01:00:10.020599 :B77211B8:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=15876 pso_num=29 pso_serial#=89 2025-07-27 01:00:10.020738 :B77211B9:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=15876 (legacy spawn) 2025-07-27 01:00:10.027271 :B77211BA: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-27 01:00:10.027441 :B77211BF: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-27 01:00:10.028268 :B77211C4:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 01:00:15.469904 :B77213A0:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 01:00:15.462 2025-07-27 01:00:15.469906 :B77213A1:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17984 pso_num=29 pso_serial#=90 2025-07-27 01:00:15.470049 :B77213A2:db_trace:kso.c@4070:ksonfy(): [10420:29:0] kso: new process: pid=17984 (legacy spawn) 2025-07-27 01:00:15.476562 :B77213A3: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-27 01:00:15.476728 :B77213A8: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-27 01:00:15.477559 :B77213AD:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 01:00:59.797800 :B77223C1:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 01:00:59.793 2025-07-27 01:00:59.797802 :B77223C2:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=13600 pso_num=29 pso_serial#=91 2025-07-27 01:00:59.797940 :B77223C3:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=13600 osp_idx=27 osp_ver=15135 osp_pg=0 (spawn #426245) 2025-07-27 01:00:59.797940 :B77223C4: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-27 01:00:59.797940 :B77223C5:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=50 time=2258835673 2025-07-27 01:00:59.797941 :B77223C6:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-27 01:00:59.797941 :B77223C7:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-27 01:00:59.797941 :B77223C8:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-27 01:00:59.797942 :B77223C9:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-27 01:00:59.797942 :B77223CA:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-27 01:00:59.798456 :B77223CB: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-27 01:00:59.798501 :B77223D1: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-27 01:00:59.805853 :B77223DF: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-27 01:00:59.806955 :B77223E7: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-27 01:00:59.807526 :B77223EF: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-27 01:00:59.807982 :B77223F7: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-27 01:00:59.808417 :B77223FF: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-27 01:00:59.811012 :B7722407: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-27 01:00:59.812116 :B772240F: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-27 01:00:59.863749 :B772243F: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-27 01:00:59.864691 :B7722447: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-27 01:00:59.864957 :B772244F: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-27 01:00:59.865186 :B7722457: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-27 01:00:59.867042 :B772245F:db_trace:kst.c@698:kstpsodel(): [10280:29:0] kst: process state object about to be deleted 2025-07-27 06:00:02.064366 :B78954A7:db_trace:kst.c@673:kstipg(): [10280:29:0] kst: process state object created on 07-27 06:00:02.058 2025-07-27 06:00:02.064367 :B78954A8:db_trace:kst.c@679:kstipg(): [10280:29:0] kst: process info: ospid=17112 pso_num=29 pso_serial#=92 2025-07-27 06:00:02.064493 :B78954AD:db_trace:kso.c@4093:ksonfy(): [10420:29:0] kso: new process: pid=17112 osp_idx=27 osp_ver=15136 osp_pg=0 (spawn #426936) 2025-07-27 06:00:02.064494 :B78954AE: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-27 06:00:02.064494 :B78954AF:db_trace:kso.c@4103:ksonfy(): [10420:29:0] kso: new process: pso_index=29 reservation=51 time=2276777954 2025-07-27 06:00:02.064495 :B78954B0:db_trace:kso.c@4109:ksonfy(): [10420:29:0] kso: spawn diagnostics: queue time=0 secs 2025-07-27 06:00:02.064495 :B78954B1:db_trace:kso.c@4111:ksonfy(): [10420:29:0] kso: spawn diagnostics: fork time=0 secs 2025-07-27 06:00:02.064495 :B78954B2:db_trace:kso.c@4113:ksonfy(): [10420:29:0] kso: spawn diagnostics: exec time=0 secs 2025-07-27 06:00:02.064496 :B78954B3:db_trace:kso.c@4115:ksonfy(): [10420:29:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-27 06:00:02.064496 :B78954B4:db_trace:kso.c@4117:ksonfy(): [10420:29:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-27 06:00:02.065017 :B78954BD: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-27 06:00:02.069995 :B78954D9: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-27 06:00:02.070034 :B78954DC:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:jslv.c:9203 2025-07-27 06:00:02.087899 :B78956DE: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-27 06:00:02.088098 :B78956E6: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-27 06:00:02.088278 :B78956EE: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-27 06:00:02.088442 :B78956F6: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-27 06:00:02.088618 :B78956FE: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-27 06:00:02.088793 :B7895706: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-27 06:00:02.089146 :B789570E: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-27 06:00:02.089309 :B7895716: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-27 06:00:02.089469 :B789571E: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-27 06:00:02.089627 :B7895726: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-27 06:00:02.089791 :B789572E: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-27 06:00:02.089954 :B7895736: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-27 06:00:02.090191 :B789573E: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-27 06:00:02.090406 :B7895746: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-27 06:00:02.090584 :B789574E: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-27 06:00:02.090744 :B7895756: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-27 06:00:02.090927 :B789575E: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-27 06:00:02.091081 :B7895766: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-27 06:00:02.091238 :B789576E: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-27 06:00:02.091389 :B7895776: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-27 06:00:02.091551 :B789577E: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-27 06:00:02.091712 :B7895786: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-27 06:00:02.091864 :B789578E: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-27 06:00:02.092483 :B7895796: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-27 06:00:02.118496 :B789579E: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-27 06:00:03.136283*:B7895924:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000325D3AD0 estart=1753567203 eid=20787753 ctx=0x0000000777968158 cwh=0x0000000052060158 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-07-27 06:00:03.136283*:B7895925:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000325D3AD0 curCtx=0x0000000051F61BF8 pubTabIdxCnt=0 2025-07-27 06:00:03.136283*:B7895926:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000325D3AD0 2025-07-27 06:00:03.136283*:B7895927:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000325D3AD0 2025-07-27 06:00:03.136283*:B7895928:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003264B6F0 estart=1753567202 eid=16777481 ctx=0x000000077B54EAC8 cwh=0x0000000032640068 cpu=812500 buffg=47411 interb=196608 r=24 rb=196608 w=0 wb=0 2025-07-27 06:00:03.136283*:B7895929:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003264B6F0 curCtx=0x0000000051F57FD8 pubTabIdxCnt=0 2025-07-27 06:00:03.136283*:B789592A:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003264B6F0 2025-07-27 06:00:03.136283*:B789592B:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003264B6F0 2025-07-27 06:00:03.136283*:B789592C:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000325D3AD0 curCtx=0x0000000051F61BF8 xsc->flg4=65792 flags=1 2025-07-27 06:00:03.136283*:B789592D:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000325D3AD0 2025-07-27 06:00:03.755059 :B7895AA8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:29:233] KSL POST SENT postee=16 loc='ktm.h LINE:583 ID:ktmpsm' id1=0 id2=0 name= type=0 2025-07-27 06:00:03.755300 :B7895AB5:db_trace:ksl2.c@2477:kslwtbctx(): [10005:29:233] KSL WAIT BEG [latch: In memory undo latch] 33179219128/0x7b9a2b4b8 243/0xf3 0/0x0 wait_id=39 seq_num=40 snap_id=1 2025-07-27 06:00:03.755333 :B7895AB8:db_trace:ksl2.c@2611:kslwtectx(): [10005:29:233] KSL WAIT END [latch: In memory undo latch] 33179219128/0x7b9a2b4b8 243/0xf3 0/0x0 wait_id=39 seq_num=40 snap_id=1 2025-07-27 06:00:03.755334 :B7895AB9:db_trace:ksl2.c@2619:kslwtectx(): [10005:29:233] KSL WAIT END wait times (usecs) - snap=33, exc=33, tot=33 2025-07-27 06:00:03.756978 :B7895AEA:db_trace:ktu.c@5576:ktugur(): [10445:29:233] des1:tsn:1 rdba:0x00800354 where: kduwh01: kdusru 2025-07-27 06:00:03.757015 :B7895AEB:db_trace:ksl2.c@12699:ksliwat(): [10005:29:233] KSL POST RCVD poster=16 loc='kcb2.h LINE:3844 ID:kcbzww' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-07-27 06:00:03.757017 :B7895AEC:db_trace:ktu.c@5576:ktugur(): [10445:29:233] des1:tsn:1 rdba:0x00800354 where: kduwh01: kdusru 2025-07-27 06:00:03.776920 :B7895BB5:db_trace:ktu.c@5576:ktugur(): [10445:29:233] des1:tsn:1 rdba:0x00800354 where: kduwh01: kdusru 2025-07-27 06:00:03.823800 :B7895C3F:db_trace:ktu.c@5576:ktugur(): [10445:29:233] des1:tsn:1 rdba:0x00800354 where: kduwh01: kdusru 2025-07-27 06:00:03.844481 :B7895C40:db_trace:ktu.c@4871:ktuaex1r(): [10442:29:233] Extension usn 8, ext 1, nex 4 2025-07-27 06:00:03.844490 :B7895C41:db_trace:ktusm.c@2117:ktusmasp(): [10445:29:233] des1:tsn:1 rdba:0x00815e05 where: kdiwh22: kdifind 2025-07-27 06:00:03.844490*:B7895C42:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003264B6F0 curCtx=0x0000000051F57FD8 xsc->flg4=65792 flags=2 2025-07-27 06:00:03.844490*:B7895C43:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003264B6F0 2025-07-27 06:00:03.844906 :B7895C44: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-27 06:00:03.864893 :B7895C4C: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-27 06:00:03.866845 :B7895C54:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpus:psdpgi.c:2235 2025-07-27 06:00:03.867045 :B7895C55:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:29:233] atxpop:psdpgi.c:2235 2025-07-27 06:00:03.867930 :B7895C56: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-27 06:00:03.868018 :B7895C59: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-27 06:00:03.868875 :B7895C6B: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-27 06:00:03.870370 :B7895C73: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-27 06:00:03.870673 :B7895C7B: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-27 06:00:03.933166*: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-27 06:00:03.933166*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-27 06:00:03.933166*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-27 06:00:03.933166*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-07-27 06:00:03.933166*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-07-27 06:00:03.933166*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-27 06:00:03.933166*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-27 06:00:04.004190 :B7895C83: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-27 06:00:05.885238 :B7895D85: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-27 06:00:05.885251 :B7895D86:db_trace:ktur.c@3079:ktuabt(): [10444:29:233] ABORT TRANSACTION - xid: 0x000a.005.00174df5 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 29 (osid: 17112, J003)