Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250823140101\orcl_j003_20416_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250823140101\orcl_j003_20416_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:35288M/63366M, Ph+PgF:40461M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 27 Windows thread id: 20416, image: ORACLE.EXE (J003) *** 2025-08-23 14:01:01.319 *** SESSION ID:(219.7681) 2025-08-23 14:01:01.319 *** 2025-08-23 14:01:01.319 Process diagnostic dump for ORACLE.EXE (J003), OS id=20416, pid: 27, proc_ser: 248, sid: 219, sess_ser: 7681 ------------------------------------------------------------------------------- current sql: <none> client details: O/S info: user: SYSTEM, term: WIN-3PIMCL4OH3L, ospid: 20416 machine: WIN-3PIMCL4OH3L program: ORACLE.EXE (J003) Current Wait Stack: 0: waiting for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=5 seq_num=6 snap_id=1 wait times: snap=0.123750 sec, exc=0.123750 sec, total=0.123750 sec wait times: max=0.500000 sec, heur=2.619314 sec wait counts: calls=1 os=1 in_wait=1 iflags=0x5a8 Wait State: fixed_waits=0 flags=0x22 boundary=0x0000000000000000/-1 Session Wait History: elapsed time of 0.000013 sec since current wait 0: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=4 seq_num=5 snap_id=1 wait times: snap=0.500005 sec, exc=0.500005 sec, total=0.500005 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000008 sec of elapsed time 1: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=3 seq_num=4 snap_id=1 wait times: snap=0.499986 sec, exc=0.499986 sec, total=0.499986 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000012 sec of elapsed time 2: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=2 seq_num=3 snap_id=1 wait times: snap=0.510113 sec, exc=0.510113 sec, total=0.510113 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000011 sec of elapsed time 3: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=1 seq_num=2 snap_id=1 wait times: snap=0.499986 sec, exc=0.499986 sec, total=0.499986 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000015 sec of elapsed time 4: waited for 'jobq slave wait' =0x0, =0x0, =0x0 wait_id=0 seq_num=1 snap_id=1 wait times: snap=0.485415 sec, exc=0.485415 sec, total=0.485415 sec wait times: max=0.500000 sec wait counts: calls=1 os=1 occurred after 0.000000 sec of elapsed time Sampled Session History of session 219 serial 7681 --------------------------------------------------- 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 --------------------------------------------------- [3 samples, 14:00:58 - 14:01:01] idle wait at each sample [session created at: 14:00:58] ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-08-23 14:01:01.319 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 27 (osid: 20416, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-08-23 13:50:56.133539 :C397F4FF:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-08-23 13:50:56.133837 :C397F500:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-08-23 13:50:56.133853 :C397F501:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-08-23 13:50:56.134065 :C397F502:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-08-23 13:50:56.134079 :C397F503:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-08-23 13:50:56.134289 :C397F504:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-08-23 13:50:56.134302 :C397F505:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-08-23 13:50:56.134509 :C397F506:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-08-23 13:50:56.134521 :C397F507:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-08-23 13:50:56.134733 :C397F508:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpus:kelt.c:517 2025-08-23 13:50:56.134746 :C397F509:db_trace:ktc.c@8711:ktcAutoTxnTrace(): [10441:27:219] atxpop:kelt.c:517 2025-08-23 13:50:56.136905 :C397F50A:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:50:57.862210 :C397F5F7:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:50:57.851 2025-08-23 13:50:57.862211 :C397F5F8:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=19784 pso_num=27 pso_serial#=237 2025-08-23 13:50:57.862328 :C397F5F9:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=19784 osp_idx=25 osp_ver=331235 osp_pg=0 (spawn #518022) 2025-08-23 13:50:57.862329 :C397F5FA:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:50:57.862329 :C397F5FB:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=58 time=342759862 2025-08-23 13:50:57.862329 :C397F5FC:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:50:57.862330 :C397F5FD:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:50:57.862330 :C397F5FE:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:50:57.862330 :C397F5FF:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:50:57.862331 :C397F600:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:50:57.862817 :C397F601:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 13:51:27.917362 :C397FFDF:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:51:57.919037 :C3980965:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:51:57.907 2025-08-23 13:51:57.919039 :C3980966:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=19596 pso_num=27 pso_serial#=238 2025-08-23 13:51:57.919169 :C3980967:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=19596 osp_idx=25 osp_ver=331236 osp_pg=0 (spawn #518024) 2025-08-23 13:51:57.919170 :C3980968:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:51:57.919171 :C3980969:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=59 time=342819924 2025-08-23 13:51:57.919171 :C398096A:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:51:57.919172 :C398096B:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:51:57.919172 :C398096C:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:51:57.919172 :C398096D:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:51:57.919173 :C398096E:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:51:57.919674 :C398096F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 13:52:27.961924 :C39812D2:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:52:58.010541 :C3981C7F:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:52:57.997 2025-08-23 13:52:58.010543 :C3981C80:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=21796 pso_num=27 pso_serial#=239 2025-08-23 13:52:58.010665 :C3981C81:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=21796 osp_idx=25 osp_ver=331237 osp_pg=0 (spawn #518026) 2025-08-23 13:52:58.010666 :C3981C82:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:52:58.010667 :C3981C83:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=60 time=342880018 2025-08-23 13:52:58.010668 :C3981C84:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:52:58.010668 :C3981C85:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:52:58.010668 :C3981C86:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:52:58.010669 :C3981C87:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:52:58.010670 :C3981C88:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:52:58.011284 :C3981C89:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 13:53:28.082930 :C398276B:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:53:58.075492 :C3983144:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:53:58.064 2025-08-23 13:53:58.075494 :C3983145:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=18680 pso_num=27 pso_serial#=240 2025-08-23 13:53:58.075611 :C3983146:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=18680 osp_idx=25 osp_ver=331238 osp_pg=0 (spawn #518028) 2025-08-23 13:53:58.075612 :C3983147:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:53:58.075613 :C3983148:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=61 time=342940080 2025-08-23 13:53:58.075613 :C3983149:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:53:58.075614 :C398314A:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:53:58.075614 :C398314B:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:53:58.075615 :C398314C:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:53:58.075615 :C398314D:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:53:58.076134 :C398314E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 13:54:28.173654 :C3983AEB:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:54:58.203490 :C3984474:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:54:58.192 2025-08-23 13:54:58.203492 :C3984475:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=19760 pso_num=27 pso_serial#=241 2025-08-23 13:54:58.203625 :C3984476:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=19760 osp_idx=25 osp_ver=331239 osp_pg=0 (spawn #518031) 2025-08-23 13:54:58.203626 :C3984477:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:54:58.203627 :C3984478:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=62 time=343000205 2025-08-23 13:54:58.203627 :C3984479:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:54:58.203627 :C398447A:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:54:58.203628 :C398447B:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:54:58.203628 :C398447C:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:54:58.203628 :C398447D:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:54:58.204106 :C398447E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 13:55:28.279247 :C3984E4B:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:55:58.273231 :C3985866:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:55:58.262 2025-08-23 13:55:58.273233 :C3985867:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=7692 pso_num=27 pso_serial#=242 2025-08-23 13:55:58.273348 :C3985868:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=7692 osp_idx=25 osp_ver=331240 osp_pg=0 (spawn #518033) 2025-08-23 13:55:58.273349 :C3985869:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:55:58.273349 :C398586A:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=63 time=343060283 2025-08-23 13:55:58.273350 :C398586B:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:55:58.273350 :C398586C:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:55:58.273351 :C398586D:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:55:58.273351 :C398586E:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:55:58.273351 :C398586F:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:55:58.273867 :C3985870:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 13:56:28.353179 :C3986271:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:56:58.379785 :C3986C40:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:56:58.368 2025-08-23 13:56:58.379787 :C3986C41:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=10604 pso_num=27 pso_serial#=243 2025-08-23 13:56:58.379904 :C3986C42:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=10604 osp_idx=25 osp_ver=331241 osp_pg=0 (spawn #518035) 2025-08-23 13:56:58.379904 :C3986C43:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:56:58.379905 :C3986C44:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=64 time=343120377 2025-08-23 13:56:58.379905 :C3986C45:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:56:58.379906 :C3986C46:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:56:58.379906 :C3986C47:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:56:58.379907 :C3986C48:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:56:58.379907 :C3986C49:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:56:58.380388 :C3986C4A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 13:57:28.475788 :C39875FE:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:57:58.476031 :C3987F8B:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:57:58.465 2025-08-23 13:57:58.476034 :C3987F8C:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20068 pso_num=27 pso_serial#=244 2025-08-23 13:57:58.476148 :C3987F8D:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=20068 osp_idx=25 osp_ver=331242 osp_pg=0 (spawn #518037) 2025-08-23 13:57:58.476150 :C3987F8E:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:57:58.476150 :C3987F8F:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=65 time=343180487 2025-08-23 13:57:58.476151 :C3987F90:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:57:58.476152 :C3987F91:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:57:58.476152 :C3987F92:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:57:58.476152 :C3987F93:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:57:58.476152 :C3987F94:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:57:58.476616 :C3987F95:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 13:58:13.479685 :C398852B:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=59 loc='kkj.h LINE:914 ID:kkjpstnp' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-23 13:58:13.479716*:C398852C:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028FEBB58 estart=1755928693 eid=17020135 ctx=0x000000077BD98A08 cwh=0x0000000027AC01B0 cpu=0 buffg=1 interb=0 r=0 rb=0 w=0 wb=0 2025-08-23 13:58:13.479716*:C398852D:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028FEBB58 curCtx=0x0000000027ACF708 pubTabIdxCnt=0 2025-08-23 13:58:13.479716*:C398852E:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028FEBB58 2025-08-23 13:58:13.479716*:C398852F:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028FEBB58 2025-08-23 13:58:13.479716*:C3988530:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028FEBB58 curCtx=0x0000000027ACF708 xsc->flg4=65792 flags=2 2025-08-23 13:58:13.479716*:C3988531:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028FEBB58 2025-08-23 13:58:13.480314 :C3988532:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 13:58:13.485757 :C3988535:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 13:58:13.506790 :C3988542:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-23 13:58:43.622650 :C3988ED4:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:58:58.548757 :C39893C4:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:58:58.537 2025-08-23 13:58:58.548760 :C39893C5:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=18840 pso_num=27 pso_serial#=245 2025-08-23 13:58:58.548873 :C39893C6:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=18840 osp_idx=25 osp_ver=331243 osp_pg=0 (spawn #518039) 2025-08-23 13:58:58.548874 :C39893C7:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:58:58.548874 :C39893C8:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=66 time=343240549 2025-08-23 13:58:58.548875 :C39893C9:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:58:58.548875 :C39893CA:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:58:58.548876 :C39893CB:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:58:58.548876 :C39893CC:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:58:58.548876 :C39893CD:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:58:58.549394 :C39893CE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 13:59:28.653113 :C3989D90:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 13:59:58.629356 :C398A76A:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 13:59:58.618 2025-08-23 13:59:58.629358 :C398A76B:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=21488 pso_num=27 pso_serial#=246 2025-08-23 13:59:58.629478 :C398A76C:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=21488 osp_idx=25 osp_ver=331244 osp_pg=0 (spawn #518041) 2025-08-23 13:59:58.629479 :C398A76D:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 13:59:58.629479 :C398A76E:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=67 time=343300627 2025-08-23 13:59:58.629480 :C398A76F:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 13:59:58.629480 :C398A770:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 13:59:58.629481 :C398A771:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 13:59:58.629481 :C398A772:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 13:59:58.629482 :C398A773:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 13:59:58.629958 :C398A774:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 14:00:28.695468 :C398B0F1:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 14:00:57.341255 :C398B9D3:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 14:00:57.330 2025-08-23 14:00:57.341256 :C398B9D5:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=19800 pso_num=27 pso_serial#=247 2025-08-23 14:00:57.341385 :C398B9D6:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=19800 osp_idx=25 osp_ver=331245 osp_pg=0 (spawn #518043) 2025-08-23 14:00:57.341385 :C398B9D7:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 14:00:57.341385 :C398B9D8:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=68 time=343359346 2025-08-23 14:00:57.341386 :C398B9D9:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 14:00:57.341386 :C398B9DA:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 14:00:57.341387 :C398B9DB:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 14:00:57.341387 :C398B9DC:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 14:00:57.341387 :C398B9DD:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 14:00:57.341872 :C398B9E2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-08-23 14:00:57.341911 :C398B9E8:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] KSL POST RCVD poster=18 loc='ksv2.h LINE:1639 ID:ksvpst: run' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-08-23 14:00:57.347399 :C398BA04:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:57.372579 :C398BA5C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:57.388029 :C398BA64:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:57.421286 :C398BABE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:57.424897 :C398BAD6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:57.428431 :C398BAE6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:57.433671 :C398BAFE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:57.473114 :C398BC75:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-23 14:00:57.474484 :C398BCBF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] 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-23 14:00:58.621295*:C398BE0F:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000028FF2BE0 estart=1755928857 eid=16780890 ctx=0x0000000777AAE258 cwh=0x0000000028FE07D0 cpu=46875 buffg=0 interb=0 r=0 rb=0 w=0 wb=0 2025-08-23 14:00:58.621295*:C398BE10:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000028FF2BE0 curCtx=0x0000000024C9F998 pubTabIdxCnt=0 2025-08-23 14:00:58.621295*:C398BE11:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000028FF2BE0 2025-08-23 14:00:58.621295*:C398BE12:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000028FF2BE0 2025-08-23 14:00:58.621295*:C398BE1D:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000028FF2BE0 curCtx=0x0000000024C9F998 xsc->flg4=65792 flags=2 2025-08-23 14:00:58.621295*:C398BE1E:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000028FF2BE0 2025-08-23 14:00:58.648847 :C398BE1F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:58.697148 :C398BE27:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:58.697453 :C398BE3D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:58.697726 :C398BE45:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:58.697744 :C398BE48:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=18 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-08-23 14:00:58.697804 :C398BE54:db_trace:ksl2.c@12699:ksliwat(): [10005:27:219] 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-23 14:00:58.702406 :C398BE7C:db_trace:kst.c@698:kstpsodel(): [10280:27:0] kst: process state object about to be deleted 2025-08-23 14:00:58.713390 :C398BEAD:db_trace:kst.c@673:kstipg(): [10280:27:0] kst: process state object created on 08-23 14:00:58.699 2025-08-23 14:00:58.713392 :C398BEAE:db_trace:kst.c@679:kstipg(): [10280:27:0] kst: process info: ospid=20416 pso_num=27 pso_serial#=248 2025-08-23 14:00:58.713514 :C398BEAF:db_trace:kso.c@4093:ksonfy(): [10420:27:0] kso: new process: pid=20416 osp_idx=25 osp_ver=331246 osp_pg=0 (spawn #518050) 2025-08-23 14:00:58.713515 :C398BEB0:db_trace:kso.c@4099:ksonfy(): [10420:27:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-08-23 14:00:58.713515 :C398BEB1:db_trace:kso.c@4103:ksonfy(): [10420:27:0] kso: new process: pso_index=27 reservation=69 time=343360721 2025-08-23 14:00:58.713516 :C398BEB2:db_trace:kso.c@4109:ksonfy(): [10420:27:0] kso: spawn diagnostics: queue time=0 secs 2025-08-23 14:00:58.713516 :C398BEB3:db_trace:kso.c@4111:ksonfy(): [10420:27:0] kso: spawn diagnostics: fork time=0 secs 2025-08-23 14:00:58.713517 :C398BEB4:db_trace:kso.c@4113:ksonfy(): [10420:27:0] kso: spawn diagnostics: exec time=0 secs 2025-08-23 14:00:58.713517 :C398BEB5:db_trace:kso.c@4115:ksonfy(): [10420:27:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-08-23 14:00:58.713517 :C398BEB6:db_trace:kso.c@4117:ksonfy(): [10420:27:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-08-23 14:00:58.714000 :C398BEB7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:27:219] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 27 (osid: 20416, J003)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de