Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250806220005\orcl_j005_3328_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:35683M/63366M, Ph+PgF:41214M/72582M 
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 31
Windows thread id: 3328, image: ORACLE.EXE (J005)


*** 2025-08-06 22:00:05.355
*** SESSION ID:(249.1593) 2025-08-06 22:00:05.355
 

*** 2025-08-06 22:00:05.355
Process diagnostic dump for ORACLE.EXE (J005), OS id=3328,
pid: 31, proc_ser: 12, sid: 249, sess_ser: 1593 
-------------------------------------------------------------------------------
current sql: call dbms_stats.gather_database_stats_job_proc (  )
client details:
  O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 3328
  machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J005)
  application name: DBMS_SCHEDULER, hash value=2478762354
  action name: ORA$AT_OS_OPT_SY_12874, hash value=1525390198
Current Wait Stack:
  Not in wait; last wait ended 2.724582 sec ago 
Wait State:
  fixed_waits=0 flags=0x21 boundary=0x0000000000000000/-1
Session Wait History:
    elapsed time of 2.724607 sec since last wait
 0: waited for 'Disk file operations I/O'
    FileOperation=0x2, fileno=0xc9, filetype=0x2
    wait_id=39 seq_num=40 snap_id=1
    wait times: snap=0.000185 sec, exc=0.000185 sec, total=0.000185 sec
    wait times: max=infinite
    wait counts: calls=0 os=0
    occurred after 0.075528 sec of elapsed time
 1: 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.000009 sec, exc=0.000009 sec, total=0.000009 sec
    wait times: max=307445734561 min 49 sec
    wait counts: calls=0 os=0
    occurred after 0.761853 sec of elapsed time
 2: waited for 'asynch descriptor resize'
    outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82
    wait_id=37 seq_num=38 snap_id=1
    wait times: snap=0.000003 sec, exc=0.000003 sec, total=0.000003 sec
    wait times: max=307445734561 min 49 sec
    wait counts: calls=0 os=0
    occurred after 0.026836 sec of elapsed time
 3: 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.013010 sec of elapsed time
 4: 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.000101 sec, exc=0.000101 sec, total=0.000101 sec
    wait times: max=infinite
    wait counts: calls=0 os=0
    occurred after 0.049569 sec of elapsed time
 5: 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.008269 sec, exc=0.008269 sec, total=0.008269 sec
    wait times: max=infinite
    wait counts: calls=0 os=0
    occurred after 0.007930 sec of elapsed time
 6: 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.000073 sec, exc=0.000073 sec, total=0.000073 sec
    wait times: max=infinite
    wait counts: calls=0 os=0
    occurred after 0.262017 sec of elapsed time
 7: 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.006392 sec, exc=0.006392 sec, total=0.006392 sec
    wait times: max=infinite
    wait counts: calls=0 os=0
    occurred after 0.000219 sec of elapsed time
 8: 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.000130 sec, exc=0.000130 sec, total=0.000130 sec
    wait times: max=infinite
    wait counts: calls=0 os=0
    occurred after 0.007926 sec of elapsed time
 9: waited for 'asynch descriptor resize'
    outstanding #aio=0x0, current aio limit=0xffffffff, new aio limit=0x82
    wait_id=30 seq_num=31 snap_id=1
    wait times: snap=0.000001 sec, exc=0.000001 sec, total=0.000001 sec
    wait times: max=307445734561 min 49 sec
    wait counts: calls=0 os=0
    occurred after 0.000053 sec of elapsed time
Sampled Session History of session 249 serial 1593
---------------------------------------------------
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:01 - 22:00:05]
    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-08-06 22:00:05.355
 
-------------------------------------------------------------------------------
Trace Bucket Dump Begin: default bucket for process 31 (osid: 3328, J005)
TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA
-------------------------------------------------------------------------------
2025-08-02 00:06:17.653223 :BA183933: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-08-02 00:06:17.654387 :BA183938:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-02 06:00:02.054823 :BA33E7EE:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-02 06:00:02.048
2025-08-02 06:00:02.054824 :BA33E7EF:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18832 pso_num=31 pso_serial#=252
2025-08-02 06:00:02.054954 :BA33E7F5:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=18832 osp_idx=29 osp_ver=761 osp_pg=0 (spawn #446916)
2025-08-02 06:00:02.054955 :BA33E7F6:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A
2025-08-02 06:00:02.054956 :BA33E7F7:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=230 time=2795071361
2025-08-02 06:00:02.054956 :BA33E7F8:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs
2025-08-02 06:00:02.054956 :BA33E7F9:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs
2025-08-02 06:00:02.054957 :BA33E7FA:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs
2025-08-02 06:00:02.054957 :BA33E7FB:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs
2025-08-02 06:00:02.054957 :BA33E7FC:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs
2025-08-02 06:00:02.055638 :BA33E7FD: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-08-02 06:00:32.124302 :BA33FB2A:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-02 23:59:09.836338 :BA8948A4:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-02 23:59:09.826
2025-08-02 23:59:09.836340 :BA8948A5:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17604 pso_num=31 pso_serial#=253
2025-08-02 23:59:09.836489 :BA8948A6:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17604 (legacy spawn)
2025-08-02 23:59:09.851503 :BA8948A7: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-08-02 23:59:42.972207 :BA8954C2:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-02 23:59:54.906416 :BA8958D8:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-02 23:59:54.900
2025-08-02 23:59:54.906418 :BA8958D9:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=19764 pso_num=31 pso_serial#=254
2025-08-02 23:59:54.906564 :BA8958DA:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=19764 (legacy spawn)
2025-08-02 23:59:54.922602 :BA8958DB: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-08-03 00:00:28.012698 :BA896666:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-03 06:00:00.267411 :BAA5EF2F:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-03 06:00:00.259
2025-08-03 06:00:00.267412 :BAA5EF30:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=15772 pso_num=31 pso_serial#=255
2025-08-03 06:00:00.267565 :BAA5EF31:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=15772 osp_idx=29 osp_ver=764 osp_pg=0 (spawn #450259)
2025-08-03 06:00:00.267566 :BAA5EF32:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A
2025-08-03 06:00:00.267566 :BAA5EF33:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=231 time=2881469564
2025-08-03 06:00:00.267566 :BAA5EF34:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs
2025-08-03 06:00:00.267567 :BAA5EF35:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs
2025-08-03 06:00:00.267568 :BAA5EF36:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs
2025-08-03 06:00:00.267568 :BAA5EF37:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs
2025-08-03 06:00:00.267569 :BAA5EF38:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs
2025-08-03 06:00:00.268161 :BAA5EF3C: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-08-03 06:00:30.331033 :BAA60181:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-03 23:59:10.082604 :BAFC8C21:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-03 23:59:10.072
2025-08-03 23:59:10.082606 :BAFC8C22:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=18696 pso_num=31 pso_serial#=1
2025-08-03 23:59:10.082757 :BAFC8C23:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=18696 (legacy spawn)
2025-08-03 23:59:10.097982 :BAFC8C33: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-08-03 23:59:43.602206 :BAFC984E:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-03 23:59:48.686010 :BAFC9A5D:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-03 23:59:48.676
2025-08-03 23:59:48.686012 :BAFC9A5E:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=19688 pso_num=31 pso_serial#=2
2025-08-03 23:59:48.686150 :BAFC9A5F:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=19688 (legacy spawn)
2025-08-03 23:59:48.693014 :BAFC9A60: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-08-03 23:59:48.693250 :BAFC9A65: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-08-03 23:59:48.694147 :BAFC9A6A:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-03 23:59:52.483724 :BAFC9BFC:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-03 23:59:52.484
2025-08-03 23:59:52.483726 :BAFC9BFD:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17248 pso_num=31 pso_serial#=3
2025-08-03 23:59:52.483872 :BAFC9BFE:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17248 (legacy spawn)
2025-08-03 23:59:52.498641 :BAFC9BFF: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-08-04 00:00:25.578037 :BAFCAA7E:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-04 22:00:01.457615 :BB656578:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-04 22:00:01.449
2025-08-04 22:00:01.457616 :BB656579:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=19736 pso_num=31 pso_serial#=4
2025-08-04 22:00:01.457752 :BB65657A:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=19736 osp_idx=29 osp_ver=768 osp_pg=0 (spawn #455829)
2025-08-04 22:00:01.457753 :BB65657B:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A
2025-08-04 22:00:01.457753 :BB65657C:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=232 time=3025470767
2025-08-04 22:00:01.457753 :BB65657D:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs
2025-08-04 22:00:01.457754 :BB65657E:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs
2025-08-04 22:00:01.457754 :BB65657F:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs
2025-08-04 22:00:01.457755 :BB656580:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs
2025-08-04 22:00:01.457755 :BB656581:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs
2025-08-04 22:00:01.458410 :BB65658A: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-08-04 22:00:31.517292 :BB657915:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-04 23:59:09.763809 :BB6EE094:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-04 23:59:09.761
2025-08-04 23:59:09.763811 :BB6EE095:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=208 pso_num=31 pso_serial#=5
2025-08-04 23:59:09.763949 :BB6EE096:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=208 (legacy spawn)
2025-08-04 23:59:09.778046 :BB6EE097: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-08-04 23:59:13.085217 :BB6EE1C1: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-08-04 23:59:13.085374 :BB6EE1CA: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-08-04 23:59:13.086705 :BB6EE1CB:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-04 23:59:13.337540 :BB6EE1DA:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-04 23:59:13.332
2025-08-04 23:59:13.337542 :BB6EE1DB:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=6364 pso_num=31 pso_serial#=6
2025-08-04 23:59:13.337735 :BB6EE1DC:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=6364 (legacy spawn)
2025-08-04 23:59:13.351979 :BB6EE1DE: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-08-04 23:59:46.385750 :BB6EEDB5:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-04 23:59:51.419794 :BB6EEF78:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-04 23:59:51.405
2025-08-04 23:59:51.419796 :BB6EEF79:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17880 pso_num=31 pso_serial#=7
2025-08-04 23:59:51.419915 :BB6EEF7A:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17880 (legacy spawn)
2025-08-04 23:59:51.433739 :BB6EEF7B: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-08-04 23:59:54.629490 :BB6EF0A5: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-08-04 23:59:54.629658 :BB6EF0AA: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-08-04 23:59:54.631311 :BB6EF0AF:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-04 23:59:54.878472 :BB6EF0B2:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-04 23:59:54.879
2025-08-04 23:59:54.878475 :BB6EF0B3:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=19576 pso_num=31 pso_serial#=8
2025-08-04 23:59:54.878619 :BB6EF0B4:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=19576 (legacy spawn)
2025-08-04 23:59:54.892761 :BB6EF0B5: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-08-05 00:00:28.295736 :BB6EFF76:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-05 22:00:02.061798 :BBD7CF84:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-05 22:00:02.054
2025-08-05 22:00:02.061800 :BBD7CF85:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=19016 pso_num=31 pso_serial#=9
2025-08-05 22:00:02.061935 :BBD7CF8C:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=19016 osp_idx=29 osp_ver=773 osp_pg=0 (spawn #459155)
2025-08-05 22:00:02.061935 :BBD7CF8D:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A
2025-08-05 22:00:02.061936 :BBD7CF8E:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=233 time=3111871361
2025-08-05 22:00:02.061936 :BBD7CF8F:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs
2025-08-05 22:00:02.061937 :BBD7CF90:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs
2025-08-05 22:00:02.061937 :BBD7CF91:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs
2025-08-05 22:00:02.061937 :BBD7CF92:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs
2025-08-05 22:00:02.061938 :BBD7CF93:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs
2025-08-05 22:00:02.062493 :BBD7CF9C: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-08-05 22:00:32.141930 :BBD7E0EA:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-05 23:59:09.854462 :BBE14894:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-05 23:59:09.848
2025-08-05 23:59:09.854464 :BBE14895:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=17436 pso_num=31 pso_serial#=10
2025-08-05 23:59:09.854612 :BBE14896:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=17436 (legacy spawn)
2025-08-05 23:59:09.869143 :BBE14897: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-08-05 23:59:42.900134 :BBE1548F:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-05 23:59:54.502241 :BBE158DF:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-05 23:59:54.499
2025-08-05 23:59:54.502243 :BBE158E0:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=19976 pso_num=31 pso_serial#=11
2025-08-05 23:59:54.502386 :BBE158E1:db_trace:kso.c@4070:ksonfy(): [10420:31:0] kso: new process: pid=19976 (legacy spawn)
2025-08-05 23:59:54.517219 :BBE158E2: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-08-06 00:00:27.832266 :BBE167DB:db_trace:kst.c@698:kstpsodel(): [10280:31:0] kst: process state object about to be deleted
2025-08-06 22:00:00.817803 :BC493EF4:db_trace:kst.c@673:kstipg(): [10280:31:0] kst: process state object created on 08-06 22:00:00.814
2025-08-06 22:00:00.817804 :BC493EF5:db_trace:kst.c@679:kstipg(): [10280:31:0] kst: process info: ospid=3328 pso_num=31 pso_serial#=12
2025-08-06 22:00:00.817957 :BC493EF6:db_trace:kso.c@4093:ksonfy(): [10420:31:0] kso: new process: pid=3328 osp_idx=29 osp_ver=776 osp_pg=0 (spawn #462487)
2025-08-06 22:00:00.817958 :BC493EF7:db_trace:kso.c@4099:ksonfy(): [10420:31:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A
2025-08-06 22:00:00.817958 :BC493EF8:db_trace:kso.c@4103:ksonfy(): [10420:31:0] kso: new process: pso_index=31 reservation=234 time=3198270111
2025-08-06 22:00:00.817959 :BC493EF9:db_trace:kso.c@4109:ksonfy(): [10420:31:0] kso: spawn diagnostics: queue time=0 secs
2025-08-06 22:00:00.817960 :BC493EFA:db_trace:kso.c@4111:ksonfy(): [10420:31:0] kso: spawn diagnostics: fork time=0 secs
2025-08-06 22:00:00.817960 :BC493EFB:db_trace:kso.c@4113:ksonfy(): [10420:31:0] kso: spawn diagnostics: exec time=0 secs
2025-08-06 22:00:00.817960 :BC493EFC:db_trace:kso.c@4115:ksonfy(): [10420:31:0] kso: spawn diagnostics: pre dbkc time=0 secs
2025-08-06 22:00:00.817961 :BC493EFD:db_trace:kso.c@4117:ksonfy(): [10420:31:0] kso: spawn diagnostics: post dbkc time=0 secs
2025-08-06 22:00:00.818784 :BC493F08: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-08-06 22:00:00.824238 :BC494075: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-08-06 22:00:00.824295 :BC494078:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:jslv.c:9203
2025-08-06 22:00:00.841332 :BC49410E: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-08-06 22:00:00.841514 :BC494116: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-08-06 22:00:00.841671 :BC49411E: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-08-06 22:00:00.841836 :BC494126: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-08-06 22:00:00.842000 :BC49412E: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-08-06 22:00:00.842172 :BC494136: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-08-06 22:00:00.842321 :BC49413E: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-08-06 22:00:00.842474 :BC494146: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-08-06 22:00:00.842619 :BC49414E: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-08-06 22:00:00.842766 :BC494156: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-08-06 22:00:00.842926 :BC49415E: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-08-06 22:00:00.843071 :BC494166: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-08-06 22:00:00.843214 :BC49416E: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-08-06 22:00:00.843494 :BC494176: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-08-06 22:00:00.843652 :BC49417E: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-08-06 22:00:00.843818 :BC494186: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-08-06 22:00:00.843968 :BC49418E: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-08-06 22:00:00.844125 :BC494196: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-08-06 22:00:00.844495 :BC49419E: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-08-06 22:00:00.844711 :BC4941A6: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-08-06 22:00:00.844864 :BC4941AE: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-08-06 22:00:00.845147 :BC4941B6: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-08-06 22:00:00.845392 :BC4941BE: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-08-06 22:00:00.845633 :BC4941C6: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-08-06 22:00:00.846253 :BC4941CE: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-08-06 22:00:00.847612 :BC49421C: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-08-06 22:00:00.848151 :BC49424C: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-08-06 22:00:00.852205 :BC494256: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-08-06 22:00:00.852570 :BC494260: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-08-06 22:00:00.857706 :BC494287: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-08-06 22:00:00.857966 :BC49429F: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-08-06 22:00:00.858085 :BC4942AA: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-08-06 22:00:00.858750 :BC4942B6: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-08-06 22:00:00.868889 :BC4942D9: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-08-06 22:00:02.297676*:BC49453D:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000052973AD0 estart=1754488802 eid=21124583 ctx=0x0000000777968158 cwh=0x0000000034610AB8 cpu=0 buffg=2 interb=0 r=0 rb=0 w=0 wb=0
2025-08-06 22:00:02.297676*:BC49453E:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000052973AD0 curCtx=0x00000000557BC4B8 pubTabIdxCnt=0
2025-08-06 22:00:02.297676*:BC49453F:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000052973AD0
2025-08-06 22:00:02.297676*:BC494540:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000052973AD0
2025-08-06 22:00:02.297676*:BC494541:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000529AAAF8 estart=1754488800 eid=16777503 ctx=0x000000077B54EAC8 cwh=0x0000000034610608 cpu=1218750 buffg=67893 interb=196608 r=24 rb=196608 w=0 wb=0
2025-08-06 22:00:02.297676*:BC494542:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000529AAAF8 curCtx=0x0000000031FC1240 pubTabIdxCnt=0
2025-08-06 22:00:02.297676*:BC494543:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000529AAAF8
2025-08-06 22:00:02.297676*:BC494544:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000529AAAF8
2025-08-06 22:00:02.297676*:BC494545:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000052973AD0 curCtx=0x00000000557BC4B8 xsc->flg4=65792 flags=1
2025-08-06 22:00:02.297676*:BC494546:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000052973AD0
2025-08-06 22:00:02.547720*:BC4945B0:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000529AAAF8 curCtx=0x0000000031FC1240 xsc->flg4=65792 flags=2
2025-08-06 22:00:02.547720*:BC4945B1:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000529AAAF8
2025-08-06 22:00:02.547958 :BC4945B3: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-08-06 22:00:02.571238 :BC4945C2: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-08-06 22:00:02.573837 :BC4945CA:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpus:psdpgi.c:2235
2025-08-06 22:00:02.574112 :BC4945CB:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:31:249] atxpop:psdpgi.c:2235
2025-08-06 22:00:02.575224 :BC4945CC: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-08-06 22:00:02.575345 :BC4945CF: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-08-06 22:00:02.576512 :BC4945E1: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-08-06 22:00:02.578496 :BC4945E9: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-08-06 22:00:02.578885 :BC4945F1: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-08-06 22:00:02.641432*:SQL_Analyze:qksan.c@3402:qksanAnalyzeSql(begin): qksanAnalyzeSql(enter): goal=15 options=16778048 pgadep=0 binds#=0 byPos=0 timeLim=0 timeFired=0
2025-08-06 22:00:02.641432*:SQL_Analyze:qksan.c@936:qksanBindSql(begin): binding for SQL analyze
2025-08-06 22:00:02.657052*:SQL_Analyze:qksan.c@1344:qksanBindSql(end): Done binding: status=0 ret=0 bind#=0 byPos=1 wasBoundP=0x0000000000000000 bindIndP=0x0000000000000000
2025-08-06 22:00:02.688314*:SQL_Analyze:qksan.c@6338:qksanAvgExecStats(): The number of total executions: 1 and execution count: 0
2025-08-06 22:00:02.688314*:SQL_Analyze:qksan.c@4776:qksanPostAnalyzeDump(begin):   qksanPostAnalyzeDump(): Dumping analyze context after compilation  qksanStatus=SUCCESS ecode=0
2025-08-06 22:00:02.688314*:SQL_Analyze:qksan.c@4800:qksanPostAnalyzeDump(end): 2025-08-06 22:00:02.688314*:SQL_Analyze:qksan.c@3690:qksanAnalyzeSql(end): exit: ecode=0 status=0
2025-08-06 22:00:02.753718 :BC4946C8: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-08-06 22:00:04.646988 :BC494819: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-08-06 22:00:04.647000 :BC49481A:db_trace:ktur.c@3079:ktuabt(): [10444:31:249] ABORT TRANSACTION - xid: 0x0009.00d.0001d762
-------------------------------------------------------------------------------
Trace Bucket Dump End: default bucket for process 31 (osid: 3328, J005)