Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250529220006\orcl_j005_10836_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:37263M/63366M, Ph+PgF:44179M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 31 Windows thread id: 10836, image: ORACLE.EXE (J005) *** 2025-05-29 22:00:06.180 *** SESSION ID:(249.863) 2025-05-29 22:00:06.180 *** 2025-05-29 22:00:06.180 Process diagnostic dump for ORACLE.EXE (J005), OS id=10836, pid: 31, proc_ser: 163, sid: 249, sess_ser: 863 ------------------------------------------------------------------------------- current sql: call dbms_stats.gather_database_stats_job_proc ( ) client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 10836 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J005) application name: DBMS_SCHEDULER, hash value=2478762354 action name: ORA$AT_OS_OPT_SY_12507, hash value=2238634138 Current Wait Stack: Not in wait; last wait ended 2.531287 sec ago Wait State: fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 2.531316 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.000118 sec, exc=0.000118 sec, total=0.000118 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.065988 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.000002 sec, exc=0.000002 sec, total=0.000002 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.033881 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.000134 sec, exc=0.000134 sec, total=0.000134 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.838877 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.028244 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.000002 sec, exc=0.000002 sec, total=0.000002 sec wait times: max=307445734561 min 49 sec wait counts: calls=0 os=0 occurred after 0.011550 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.000086 sec, exc=0.000086 sec, total=0.000086 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.040554 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.001892 sec, exc=0.001892 sec, total=0.001892 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.005801 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.000087 sec, exc=0.000087 sec, total=0.000087 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.303360 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.000127 sec, exc=0.000127 sec, total=0.000127 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.000168 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.005287 sec, exc=0.005287 sec, total=0.005287 sec wait times: max=infinite wait counts: calls=0 os=0 occurred after 0.008276 sec of elapsed time Sampled Session History of session 249 serial 863 --------------------------------------------------- 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 --------------------------------------------------- [5 samples, 22:00:02 - 22:00:06] not in wait at each sample [1 sample, 22:00:01] idle wait at each sample [session created at: 22:00:01] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-05-29 22:00:06.180 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 31 (osid: 10836, J005) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-05-26 23:59:13.860570 :9C73AE03:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14708 pso_num=31 pso_serial#=149 2025-05-26 23:59:13.860695 :9C73AE04:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=14708 osp_idx=29 osp_ver=403 osp_pg=0 (spawn #222761) 2025-05-26 23:59:13.860695 :9C73AE05:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-26 23:59:13.860696 :9C73AE06:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=135 time=1279726110 2025-05-26 23:59:13.860696 :9C73AE07:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-05-26 23:59:13.860697 :9C73AE08:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-05-26 23:59:13.860697 :9C73AE09:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-05-26 23:59:13.860699 :9C73AE0A:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-26 23:59:13.860700 :9C73AE0B:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-26 23:59:13.861269 :9C73AE0C: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-05-26 23:59:43.938684 :9C73B8C9:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-26 23:59:55.043339 :9C73BCD2:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-26 23:59:55.029 2025-05-26 23:59:55.043341 :9C73BCD3:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=7888 pso_num=31 pso_serial#=150 2025-05-26 23:59:55.043480 :9C73BCD4:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=7888 (legacy spawn) 2025-05-26 23:59:55.057160 :9C73BCD5: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-05-26 23:59:58.367810 :9C73BE06: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-05-26 23:59:58.368001 :9C73BE0B: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-05-26 23:59:58.369226 :9C73BE10:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-26 23:59:58.630219 :9C73BE13:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-26 23:59:58.616 2025-05-26 23:59:58.630221 :9C73BE14:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=12548 pso_num=31 pso_serial#=151 2025-05-26 23:59:58.630359 :9C73BE15:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=12548 (legacy spawn) 2025-05-26 23:59:58.644517 :9C73BE16: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-05-27 00:06:18.602587 :9C744540: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-05-27 00:06:18.602762 :9C744545: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-05-27 00:06:18.603974 :9C74454A:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-27 22:00:00.595077 :9CD9C0CD:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-27 22:00:00.587 2025-05-27 22:00:00.595078 :9CD9C0CE:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13996 pso_num=31 pso_serial#=152 2025-05-27 22:00:00.595211 :9CD9C0CF:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=13996 osp_idx=29 osp_ver=406 osp_pg=0 (spawn #225820) 2025-05-27 22:00:00.595212 :9CD9C0D0:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-27 22:00:00.595212 :9CD9C0D1:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=136 time=1358972844 2025-05-27 22:00:00.595213 :9CD9C0D2:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-05-27 22:00:00.595213 :9CD9C0D3:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-05-27 22:00:00.595213 :9CD9C0D4:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-05-27 22:00:00.595214 :9CD9C0D5:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-27 22:00:00.595214 :9CD9C0D6:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-27 22:00:00.595785 :9CD9C0D7: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-05-27 22:00:30.644673 :9CD9D305:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-27 23:59:17.113699 :9CE2EE74:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-27 23:59:17.100 2025-05-27 23:59:17.113701 :9CE2EE75:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13472 pso_num=31 pso_serial#=153 2025-05-27 23:59:17.113845 :9CE2EE76:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=13472 (legacy spawn) 2025-05-27 23:59:17.120720 :9CE2EE77: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-05-27 23:59:17.120901 :9CE2EE7C: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-05-27 23:59:17.121735 :9CE2EE81:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-27 23:59:17.915774 :9CE2EF3A:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-27 23:59:17.902 2025-05-27 23:59:17.915776 :9CE2EF3B:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=15352 pso_num=31 pso_serial#=154 2025-05-27 23:59:17.915884 :9CE2EF3C:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=15352 (legacy spawn) 2025-05-27 23:59:17.931472 :9CE2EF3D: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-05-27 23:59:21.239361 :9CE2F05F: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-05-27 23:59:21.239547 :9CE2F064: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-05-27 23:59:21.240847 :9CE2F069:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-27 23:59:21.498009 :9CE2F06C:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-27 23:59:21.488 2025-05-27 23:59:21.498011 :9CE2F06D:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=10868 pso_num=31 pso_serial#=155 2025-05-27 23:59:21.498147 :9CE2F06E:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=10868 (legacy spawn) 2025-05-27 23:59:21.512352 :9CE2F06F: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-05-27 23:59:54.674942 :9CE2FC83:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-27 23:59:55.244530 :9CE2FCBD:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-27 23:59:55.235 2025-05-27 23:59:55.244533 :9CE2FCBE:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14388 pso_num=31 pso_serial#=156 2025-05-27 23:59:55.244689 :9CE2FCBF:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=14388 (legacy spawn) 2025-05-27 23:59:55.262378 :9CE2FCC0: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-05-27 23:59:55.263969 :9CE2FCC5: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-05-27 23:59:58.608646 :9CE2FDEC: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-05-27 23:59:58.608823 :9CE2FDF1: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-05-27 23:59:58.610137 :9CE2FDF6:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-27 23:59:58.859533 :9CE2FE08:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-27 23:59:58.852 2025-05-27 23:59:58.859535 :9CE2FE09:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13944 pso_num=31 pso_serial#=157 2025-05-27 23:59:58.859680 :9CE2FE0A:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=13944 (legacy spawn) 2025-05-27 23:59:58.873994 :9CE2FE0B: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-05-28 00:06:18.825918 :9CE38265: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-05-28 00:06:18.826086 :9CE3826E: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-05-28 00:06:18.827400 :9CE3826F:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-28 22:00:00.420419 :9D49E149:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-28 22:00:00.413 2025-05-28 22:00:00.420421 :9D49E14A:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=11800 pso_num=31 pso_serial#=158 2025-05-28 22:00:00.420570 :9D49E150:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=11800 osp_idx=29 osp_ver=412 osp_pg=0 (spawn #229141) 2025-05-28 22:00:00.420571 :9D49E151:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-28 22:00:00.420572 :9D49E152:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=137 time=1445372672 2025-05-28 22:00:00.420572 :9D49E153:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-05-28 22:00:00.420573 :9D49E154:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-05-28 22:00:00.420573 :9D49E155:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-05-28 22:00:00.420573 :9D49E156:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-28 22:00:00.420574 :9D49E157:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-28 22:00:00.421244 :9D49E15B: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-05-28 22:00:30.521938 :9D49F51B:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-28 23:59:09.685736 :9D535787:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-28 23:59:09.677 2025-05-28 23:59:09.685744 :9D535788:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=15240 pso_num=31 pso_serial#=159 2025-05-28 23:59:09.685919 :9D535789:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=15240 (legacy spawn) 2025-05-28 23:59:09.692796 :9D535796: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-05-28 23:59:09.692960 :9D53579F: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-05-28 23:59:09.693834 :9D5357A0:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-28 23:59:10.095790 :9D5357B6:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-28 23:59:10.083 2025-05-28 23:59:10.095792 :9D5357B7:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13156 pso_num=31 pso_serial#=160 2025-05-28 23:59:10.095925 :9D5357B8:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=13156 (legacy spawn) 2025-05-28 23:59:10.110110 :9D5357B9: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-05-28 23:59:43.247893 :9D5363E2:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-28 23:59:43.706792 :9D536436:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-28 23:59:43.698 2025-05-28 23:59:43.706794 :9D536437:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=13452 pso_num=31 pso_serial#=161 2025-05-28 23:59:43.706931 :9D536438:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=13452 (legacy spawn) 2025-05-28 23:59:43.713395 :9D536439: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-05-28 23:59:43.713579 :9D536442: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-05-28 23:59:43.714383 :9D536443:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-28 23:59:46.856307 :9D536563:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-28 23:59:46.845 2025-05-28 23:59:46.856309 :9D536564:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=14936 pso_num=31 pso_serial#=162 2025-05-28 23:59:46.856441 :9D536565:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=14936 (legacy spawn) 2025-05-28 23:59:46.870393 :9D536566: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-05-29 00:00:20.041845 :9D537128:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted 2025-05-29 22:00:01.661668 :9DBACAAC:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 05-29 22:00:01.660 2025-05-29 22:00:01.661670 :9DBACAAD:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=10836 pso_num=31 pso_serial#=163 2025-05-29 22:00:01.661800 :9DBACAB7:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=10836 osp_idx=29 osp_ver=417 osp_pg=0 (spawn #232477) 2025-05-29 22:00:01.661801 :9DBACAB8:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-05-29 22:00:01.661801 :9DBACAB9:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=138 time=1531762422 2025-05-29 22:00:01.661801 :9DBACABA:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs 2025-05-29 22:00:01.661801 :9DBACABB:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs 2025-05-29 22:00:01.661802 :9DBACABC:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs 2025-05-29 22:00:01.661802 :9DBACABD:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-05-29 22:00:01.661802 :9DBACABE:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-05-29 22:00:01.662255 :9DBACAC7: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-05-29 22:00:01.667173 :9DBACAEE: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-05-29 22:00:01.667203 :9DBACAF2:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:jslv.c:9203 2025-05-29 22:00:01.682956 :9DBACB87: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-05-29 22:00:01.683193 :9DBACB8F: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-05-29 22:00:01.683425 :9DBACB97: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-05-29 22:00:01.683627 :9DBACB9F: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-05-29 22:00:01.683833 :9DBACBA7: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-05-29 22:00:01.684222 :9DBACBAF: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-05-29 22:00:01.684447 :9DBACBB7: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-05-29 22:00:01.684644 :9DBACBBF: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-05-29 22:00:01.684968 :9DBACBC7: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-05-29 22:00:01.685312 :9DBACBD7: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-05-29 22:00:01.685607 :9DBACBDF: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-05-29 22:00:01.686211 :9DBACBED: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-05-29 22:00:01.686351 :9DBACBF7: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-05-29 22:00:01.686594 :9DBACC15: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-05-29 22:00:01.686839 :9DBACC31: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-05-29 22:00:01.686869 :9DBACC33: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-05-29 22:00:01.687053 :9DBACC46: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-05-29 22:00:01.687243 :9DBACC4E: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-05-29 22:00:01.687430 :9DBACC57: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-05-29 22:00:01.687591 :9DBACC63: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-05-29 22:00:01.687621 :9DBACC65: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-05-29 22:00:01.687802 :9DBACC77: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-05-29 22:00:01.687984 :9DBACC7F: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-05-29 22:00:01.688169 :9DBACC87: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-05-29 22:00:01.688354 :9DBACC8F: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-05-29 22:00:01.688535 :9DBACC97: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-05-29 22:00:01.688717 :9DBACC9F: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-05-29 22:00:01.688901 :9DBACCA7: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-05-29 22:00:01.689110 :9DBACCAF: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-05-29 22:00:01.689293 :9DBACCB7: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-05-29 22:00:01.689482 :9DBACCBF: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-05-29 22:00:01.689665 :9DBACCC7: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-05-29 22:00:01.689850 :9DBACCCF: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-05-29 22:00:01.691951 :9DBACCDC: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-05-29 22:00:01.692154 :9DBACCE8: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-05-29 22:00:01.718202 :9DBACE5A: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-05-29 22:00:03.529703*:9DBAD27A:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000322D3AD0 estart=1748527203 eid=18875258 ctx=0x0000000777968158 cwh=0x00000000319D0AB8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0 2025-05-29 22:00:03.529703*:9DBAD27B:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000322D3AD0 curCtx=0x0000000040C688B0 pubTabIdxCnt=0 2025-05-29 22:00:03.529703*:9DBAD27C:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000322D3AD0 2025-05-29 22:00:03.529703*:9DBAD27D:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000322D3AD0 2025-05-29 22:00:03.529703*:9DBAD27E:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x000000003231AAF8 estart=1748527201 eid=16777354 ctx=0x000000077B54EAC8 cwh=0x00000000319D0608 cpu=1625000 buffg=77827 interb=196608 r=24 rb=196608 w=0 wb=0 2025-05-29 22:00:03.529703*:9DBAD27F:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x000000003231AAF8 curCtx=0x0000000040BD1240 pubTabIdxCnt=0 2025-05-29 22:00:03.529703*:9DBAD280:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x000000003231AAF8 2025-05-29 22:00:03.529703*:9DBAD281:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x000000003231AAF8 2025-05-29 22:00:03.529703*:9DBAD282:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000322D3AD0 curCtx=0x0000000040C688B0 xsc->flg4=65792 flags=1 2025-05-29 22:00:03.529703*:9DBAD283:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000322D3AD0 2025-05-29 22:00:03.554069 :9DBAD28E:db_trace:ktu.c@4871:ktuaex1r(): [10442:31:249] Extension usn 9, ext 1, nex 3 2025-05-29 22:00:03.554076 :9DBAD28F:db_trace:ktusm.c@2117:ktusmasp(): [10445:31:249] des1:tsn:1 rdba:0x008191c2 where: kdiwh22: kdifind 2025-05-29 22:00:03.560955*:9DBAD290:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x000000003231AAF8 curCtx=0x0000000040BD1240 xsc->flg4=65792 flags=2 2025-05-29 22:00:03.560955*:9DBAD291:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x000000003231AAF8 2025-05-29 22:00:03.568958 :9DBAD292: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-05-29 22:00:03.589520 :9DBAD29C: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-05-29 22:00:03.591507 :9DBAD2A4:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:psdpgi.c:2235 2025-05-29 22:00:03.591711 :9DBAD2A5:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpop:psdpgi.c:2235 2025-05-29 22:00:03.592624 :9DBAD2A6: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-05-29 22:00:03.592717 :9DBAD2A9: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-05-29 22:00:03.593644 :9DBAD2BB: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-05-29 22:00:03.595022 :9DBAD2C3: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-05-29 22:00:03.595347 :9DBAD2CB: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-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin): qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=0 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-05-29 22:00:03.654694*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0 2025-05-29 22:00:03.743922 :9DBAD331: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-05-29 22:00:05.734663 :9DBAD3F6: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-05-29 22:00:05.734676 :9DBAD3F7:db_trace:ktur.c@3079:ktuabt(): [10444:31:249] ABORT TRANSACTION - xid: 0x0001.015.0000c136 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 31 (osid: 10836, J005)