Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250721220004\orcl_j005_11428_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:36107M/63366M, Ph+PgF:41984M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 31 Windows thread id: 11428, image: ORACLE.EXE (J005) *** 2025-07-21 22:00:04.965 *** SESSION ID:(249.1465) 2025-07-21 22:00:04.965 *** 2025-07-21 22:00:04.965 Process diagnostic dump for ORACLE.EXE (J005), OS id=11428, pid: 31, proc_ser: 203, sid: 249, sess_ser: 1465 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 11428 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J005) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12794, hash value=2360353636 Current Wait Stack: Not in wait; last wait ended 2.618802 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 2.618827 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.000187 sec, exc=0.000187 sec, total=0.000187 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.068408 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.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.041763 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.000160 sec, exc=0.000160 sec, total=0.000160 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.715373 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.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.026769 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.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.013107 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.000124 sec, exc=0.000124 sec, total=0.000124 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.051634 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.004970 sec, exc=0.004970 sec, total=0.004970 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007805 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.000067 sec, exc=0.000067 sec, total=0.000067 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.262453 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.007490 sec, exc=0.007490 sec, total=0.007490 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000199 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.000113 sec, exc=0.000113 sec, total=0.000113 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.007929 sec of elapsed time Sampled Session History of session 249 serial 1465 --------------------------------------------------- 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:01 - 22:00:04] not in wait at each sample [1 sample, 22:00:00] idle wait at each sample [session created at: 22:00:00] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-07-21 22:00:04.965 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 31 (osid: 11428, J005) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-07-17 22:00:02.064025 :B3607A73:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-17 22:00:02.064549 :B3607A74:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-17 22:00:32.146062 :B3608BCD:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-17 23:59:10.080856 :B36A107C:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-17 23:59:10.071 2025-07-17 23:59:10.080858 :B36A107D:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17412 pso_num=31 pso_serial#=186 2025-07-17 23:59:10.080990 :B36A107E:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17412 (legacy spawn) 2025-07-17 23:59:10.095716 :B36A107F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-17 23:59:43.254089 :B36A1C9C:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-17 23:59:48.140756 :B36A1E6A:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-17 23:59:48.132 2025-07-17 23:59:48.140758 :B36A1E6B:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=19228 pso_num=31 pso_serial#=187 2025-07-17 23:59:48.140902 :B36A1E6C:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=19228 (legacy spawn) 2025-07-17 23:59:48.147659 :B36A1E6D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-17 23:59:48.147843 :B36A1E76:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-17 23:59:48.148655 :B36A1E77:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-17 23:59:52.494518 :B36A201C:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-17 23:59:52.480 2025-07-17 23:59:52.494520 :B36A201D:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=19300 pso_num=31 pso_serial#=188 2025-07-17 23:59:52.494655 :B36A201E:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=19300 (legacy spawn) 2025-07-17 23:59:52.508740 :B36A201F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-18 00:00:25.552280 :B36A2EF6:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-18 22:00:00.569245 :B3D46C6A:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-18 22:00:00.566 2025-07-18 22:00:00.569246 :B3D46C6B:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18848 pso_num=31 pso_serial#=189 2025-07-18 22:00:00.569377 :B3D46C6C:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=18848 osp_idx=29 osp_ver=698 osp_pg=0 (spawn #399163) 2025-07-18 22:00:00.569378 :B3D46C6D:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-18 22:00:00.569379 :B3D46C6E:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=212 time=1556776454 2025-07-18 22:00:00.569379 :B3D46C6F:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-18 22:00:00.569380 :B3D46C70:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-18 22:00:00.569381 :B3D46C71:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-18 22:00:00.569381 :B3D46C72:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-18 22:00:00.569382 :B3D46C73:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-18 22:00:00.570081 :B3D46C74:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-18 22:00:30.660170 :B3D4802E:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-18 23:59:15.899351 :B3DE0400:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-18 23:59:15.885 2025-07-18 23:59:15.899353 :B3DE0401:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13816 pso_num=31 pso_serial#=190 2025-07-18 23:59:15.899491 :B3DE0402:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=13816 (legacy spawn) 2025-07-18 23:59:15.906386 :B3DE0403:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-18 23:59:15.906565 :B3DE0409:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-18 23:59:15.907372 :B3DE040D:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-18 23:59:15.916553 :B3DE0410:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-18 23:59:15.916 2025-07-18 23:59:15.916555 :B3DE0411:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=19100 pso_num=31 pso_serial#=191 2025-07-18 23:59:15.916742 :B3DE0412:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=19100 (legacy spawn) 2025-07-18 23:59:15.923590 :B3DE0413:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-18 23:59:15.923754 :B3DE041C:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-18 23:59:15.924577 :B3DE041D:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-18 23:59:17.948752 :B3DE04D8:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-18 23:59:17.935 2025-07-18 23:59:17.948754 :B3DE04D9:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=16748 pso_num=31 pso_serial#=192 2025-07-18 23:59:17.948917 :B3DE04DA:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=16748 (legacy spawn) 2025-07-18 23:59:17.965655 :B3DE04DB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-18 23:59:51.227263 :B3DE1119:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-18 23:59:52.315839 :B3DE1181:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-18 23:59:52.303 2025-07-18 23:59:52.315841 :B3DE1182:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=9724 pso_num=31 pso_serial#=193 2025-07-18 23:59:52.315979 :B3DE1183:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=9724 (legacy spawn) 2025-07-18 23:59:52.322610 :B3DE119C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-18 23:59:52.322791 :B3DE11A1:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-18 23:59:52.323601 :B3DE11A6:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-18 23:59:52.332396 :B3DE11A9:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-18 23:59:52.318 2025-07-18 23:59:52.332398 :B3DE11AA:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=4728 pso_num=31 pso_serial#=194 2025-07-18 23:59:52.332537 :B3DE11AB:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=4728 (legacy spawn) 2025-07-18 23:59:52.339132 :B3DE11AC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-18 23:59:52.339294 :B3DE11B5:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-18 23:59:52.340103 :B3DE11B6:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-18 23:59:54.787949 :B3DE129F:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-18 23:59:54.787 2025-07-18 23:59:54.787950 :B3DE12A0:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=9144 pso_num=31 pso_serial#=195 2025-07-18 23:59:54.788096 :B3DE12A1:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=9144 (legacy spawn) 2025-07-18 23:59:54.803014 :B3DE12A2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-19 00:00:28.115037 :B3DE2193:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-19 06:00:01.952150 :B3FADF94:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-19 06:00:01.944 2025-07-19 06:00:01.952151 :B3FADF95:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18800 pso_num=31 pso_serial#=196 2025-07-19 06:00:01.952299 :B3FADF96:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=18800 osp_idx=29 osp_ver=705 osp_pg=0 (spawn #400278) 2025-07-19 06:00:01.952300 :B3FADF97:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-19 06:00:01.952300 :B3FADF98:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=213 time=1585577845 2025-07-19 06:00:01.952301 :B3FADF99:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-19 06:00:01.952302 :B3FADF9A:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-19 06:00:01.952302 :B3FADF9B:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-19 06:00:01.952302 :B3FADF9C:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-19 06:00:01.952303 :B3FADF9D:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-19 06:00:01.952933 :B3FADF9E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-19 06:00:32.019779 :B3FAF1B9:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-19 23:59:10.004707 :B451FD6A:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-19 23:59:09.997 2025-07-19 23:59:10.004709 :B451FD6B:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18600 pso_num=31 pso_serial#=197 2025-07-19 23:59:10.004863 :B451FD6C:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=18600 (legacy spawn) 2025-07-19 23:59:10.020010 :B451FD6D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-19 23:59:43.377639 :B4520A04:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-19 23:59:46.988924 :B4520BB9:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-19 23:59:46.982 2025-07-19 23:59:46.988926 :B4520BBA:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18544 pso_num=31 pso_serial#=198 2025-07-19 23:59:46.989072 :B4520BBB:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=18544 (legacy spawn) 2025-07-19 23:59:47.003954 :B4520BBC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 00:00:20.137950 :B4521756:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-20 06:00:02.053530 :B46EB5DD:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-20 06:00:02.050 2025-07-20 06:00:02.053532 :B46EB5DE:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17836 pso_num=31 pso_serial#=199 2025-07-20 06:00:02.053649 :B46EB5DF:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=17836 osp_idx=29 osp_ver=708 osp_pg=0 (spawn #403612) 2025-07-20 06:00:02.053649 :B46EB5E0:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-20 06:00:02.053650 :B46EB5E1:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=214 time=1671977939 2025-07-20 06:00:02.053650 :B46EB5E2:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-20 06:00:02.053651 :B46EB5E3:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-20 06:00:02.053651 :B46EB5E4:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-20 06:00:02.053651 :B46EB5E5:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-20 06:00:02.053652 :B46EB5E6:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-20 06:00:02.054151 :B46EB5FB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-20 06:00:32.152036 :B46EC9CA:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-20 23:59:10.079826 :B4C47388:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-20 23:59:10.065 2025-07-20 23:59:10.079828 :B4C47389:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17996 pso_num=31 pso_serial#=200 2025-07-20 23:59:10.079968 :B4C4738A:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17996 (legacy spawn) 2025-07-20 23:59:10.094802 :B4C4738B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 23:59:43.245808 :B4C47F3C:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-20 23:59:44.548329 :B4C47FA9:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-20 23:59:44.540 2025-07-20 23:59:44.548331 :B4C47FAA:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=16028 pso_num=31 pso_serial#=201 2025-07-20 23:59:44.548475 :B4C47FAB:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=16028 (legacy spawn) 2025-07-20 23:59:44.555043 :B4C47FAC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-20 23:59:44.555211 :B4C47FB1:db_trace:ksl2.c@12699:ksliwat(): [10005:31:249] 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-20 23:59:44.556047 :B4C47FB6:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-20 23:59:47.408832 :B4C480A3:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-20 23:59:47.398 2025-07-20 23:59:47.408834 :B4C480A4:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17152 pso_num=31 pso_serial#=202 2025-07-20 23:59:47.408965 :B4C480A5:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17152 (legacy spawn) 2025-07-20 23:59:47.423844 :B4C480CE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 00:00:20.456870 :B4C48C8B:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-07-21 22:00:00.543725 :B52BDBF6:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 07-21 22:00:00.540 2025-07-21 22:00:00.543726 :B52BDBF7:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=11428 pso_num=31 pso_serial#=203 2025-07-21 22:00:00.543876 :B52BDBF8:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=11428 osp_idx=29 osp_ver=712 osp_pg=0 (spawn #409161) 2025-07-21 22:00:00.543877 :B52BDBF9:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-07-21 22:00:00.543878 :B52BDBFA:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=215 time=1815976423 2025-07-21 22:00:00.543878 :B52BDBFB:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-07-21 22:00:00.543878 :B52BDBFC:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-07-21 22:00:00.543879 :B52BDBFD:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-07-21 22:00:00.543879 :B52BDBFE:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-07-21 22:00:00.543879 :B52BDBFF:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-07-21 22:00:00.544453 :B52BDC00:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.549592 :B52BDC3A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.549616 :B52BDC3D:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:jslv.c:9203 2025-07-21 22:00:00.567297 :B52BDD2B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.567497 :B52BDD63:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.567667 :B52BDD6E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.567867 :B52BDD7A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568035 :B52BDD88:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568184 :B52BDD8B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568354 :B52BDDA8:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568581 :B52BDDF5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.568735 :B52BDE41:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569029 :B52BDEF5:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569185 :B52BDF27:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569347 :B52BDF73:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569510 :B52BDFD4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569656 :B52BDFE2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569804 :B52BDFEA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.569953 :B52BDFF3:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570109 :B52BDFFB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570251 :B52BE012:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570444 :B52BE02E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570667 :B52BE04B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570691 :B52BE04F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570813 :B52BE078:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570835 :B52BE07A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.570990 :B52BE08C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.575833 :B52BE0AB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.582665 :B52BE0C0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='kcrf.h LINE:3299 ID:kcrfw_redo_gen: wake LGWR after redo copy' id1=0 id2=0 name= type=0 2025-07-21 22:00:00.592234 :B52BE0D0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:01.696344*:B52BE26D:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000342A3AD0 estart=1753106401 eid=20637785 ctx=0x0000000777968158 cwh=0x00000000342D09C8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-07-21 22:00:01.696344*:B52BE26E:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000342A3AD0 curCtx=0x00000000507A7918 pubTabIdxCnt=0 2025-07-21 22:00:01.696344*:B52BE26F:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000342A3AD0 2025-07-21 22:00:01.696344*:B52BE270:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000342A3AD0 2025-07-21 22:00:01.696344*:B52BE271:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003431B6F0 estart=1753106400 eid=16777471 ctx=0x000000077B54EAC8 cwh=0x00000000342D0518 cpu=906250 buffg=51822 interb=196608 r=24 rb=196608 w=0 wb=0 2025-07-21 22:00:01.696344*:B52BE272:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003431B6F0 curCtx=0x00000000320487D0 pubTabIdxCnt=0 2025-07-21 22:00:01.696344*:B52BE273:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003431B6F0 2025-07-21 22:00:01.696344*:B52BE274:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003431B6F0 2025-07-21 22:00:01.696344*:B52BE275:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000342A3AD0 curCtx=0x00000000507A7918 xsc->flg4=65792 flags=1 2025-07-21 22:00:01.696344*:B52BE276:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000342A3AD0 2025-07-21 22:00:02.245706*:B52BE43D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003431B6F0 curCtx=0x00000000320487D0 xsc->flg4=65792 flags=2 2025-07-21 22:00:02.245706*:B52BE43E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003431B6F0 2025-07-21 22:00:02.259281 :B52BE43F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.280082 :B52BE4A0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.282457 :B52BE4A8:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:psdpgi.c:2235 2025-07-21 22:00:02.282652 :B52BE4A9:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpop:psdpgi.c:2235 2025-07-21 22:00:02.283539 :B52BE4AA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.283644 :B52BE4AD:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.284492 :B52BE4BF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.286053 :B52BE4C7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.286353 :B52BE4CF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:02.355287*: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-21 22:00:02.355287*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-07-21 22:00:02.355287*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-07-21 22:00:02.433322 :B52BE4D7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:04.315842 :B52BE610:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:31:249] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-07-21 22:00:04.315855 :B52BE611:db_trace:ktur.c@3079:ktuabt(): [10444:31:249] ABORT TRANSACTION - xid: 0x0009.01f.0001d439 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 31 (osid: 11428, J005)