Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250902221901\orcl_p020_3320_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250902221901\orcl_p020_3320_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:35029M/63366M, Ph+PgF:39938M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 43 Windows thread id: 3320, image: ORACLE.EXE (P020) *** 2025-09-02 22:19:01.231 *** 2025-09-02 22:19:01.231 Process diagnostic dump for ORACLE.EXE (P020), OS id=3320, pid: 43, proc_ser: 1, sid: <no session> ------------------------------------------------------------------------------- Skipping session state dump because target process has no session. ------------------------------------------------------------------------------- Process diagnostic dump actual duration=0.000000 sec (max dump time=30.000000 sec) *** 2025-09-02 22:19:01.231 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 43 (osid: 3320, P020) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-03-23 11:26:20.585057 :800006C8:db_trace:kst.c@673:kstipg(): [10280:43:0] kst: process state object created on 03-23 11:26:20.577 2025-03-23 11:26:20.585058 :800006C9:db_trace:kst.c@679:kstipg(): [10280:43:0] kst: process info: ospid=3320 pso_num=43 pso_serial#=1 2025-03-23 11:26:20.585129 :800006CA:db_trace:kso.c@4093:ksonfy(): [10420:43:0] kso: new process: pid=3320 osp_idx=41 osp_ver=0 osp_pg=0 (spawn #42) 2025-03-23 11:26:20.585129 :800006CB:db_trace:kso.c@4099:ksonfy(): [10420:43:0] kso: new process: first_req_pid=3724 spawner_pid=3660 sga_crt_ts=x8A8A 2025-03-23 11:26:20.585130 :800006CC:db_trace:kso.c@4103:ksonfy(): [10420:43:0] kso: new process: pso_index=43 reservation=1 time=40609 2025-03-23 11:26:20.585130 :800006CD:db_trace:kso.c@4109:ksonfy(): [10420:43:0] kso: spawn diagnostics: queue time=0 secs 2025-03-23 11:26:20.585130 :800006CE:db_trace:kso.c@4111:ksonfy(): [10420:43:0] kso: spawn diagnostics: fork time=0 secs 2025-03-23 11:26:20.585130 :800006CF:db_trace:kso.c@4113:ksonfy(): [10420:43:0] kso: spawn diagnostics: exec time=0 secs 2025-03-23 11:26:20.585130 :800006D0:db_trace:kso.c@4115:ksonfy(): [10420:43:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-03-23 11:26:20.585130 :800006D1:db_trace:kso.c@4117:ksonfy(): [10420:43:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-03-23 11:26:20.585163 :800006D2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:0] KSL POST SENT postee=22 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.611490 :80000836:db_trace:ksl2.c@12699:ksliwat(): [10005:43:0] KSL POST RCVD poster=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.613650 :8000087B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.622520 :800008BF:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.636838 :80000909:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.639090 :80000953:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.639097 :8000095F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=10 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.643757 :80000A19:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=10 loc='ksa2.h LINE:286 ID:ksasnr' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.665912 :80000A99:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.736182 :800021C9:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.740428 :8000220B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.740613 :80002379:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.747077 :8000238C:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.863422 :80002ACE:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.863429 :80002AD6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.873017 :80002C81:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.875661 :80002C9E:KFNU:kfn.c@2200:kfnPrepareASM(): kfnPrepareASM force=0 state_kfnsg=0x7 2025-03-23 11:26:20.878848 :80002CCF:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=50 loc='ksq.h LINE:1877 ID:ksqrcl' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.879195 :80002CD2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=47 loc='ksq.h LINE:1877 ID:ksqrcl' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.879256 :80002CD4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.887843 :80002D57:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=22 loc='ksu.h LINE:12733 ID:ksusig' error and flags=2147494035 id2=136 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.890079 :80002D85:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4295 ID:kxfpqr: QC' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.890080 :80002D87:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.890150 :80002DC0:db_trace:ksl2.c@12699:ksliwat(): [10005:43:90] KSL POST RCVD poster=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.890162 :80002DCF:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:43:90] KSL POST SENT postee=22 loc='kxfp.h LINE:4291 ID:kxfprienq: slave' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.890428 :80002DFA:db_trace:ksl2.c@2324:kslwtbctx(): [10005:43:0] KSL WAIT BEG [latch free] 136431760/0x821c890 70/0x46 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:26:20.890575 :80002E43:db_trace:ksl2.c@2611:kslwtectx(): [10005:43:0] KSL WAIT END [latch free] 136431760/0x821c890 70/0x46 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:26:20.890575 :80002E44:db_trace:ksl2.c@2619:kslwtectx(): [10005:43:0] KSL WAIT END wait times (usecs) - snap=147, exc=147, tot=147 2025-03-23 11:26:20.890605 :80002E49:db_trace:ksl2.c@2324:kslwtbctx(): [10005:43:0] KSL WAIT BEG [latch: call allocation] 136410064/0x82173d0 10/0xa 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:26:20.890914 :80002E79:db_trace:ksl2.c@2611:kslwtectx(): [10005:43:0] KSL WAIT END [latch: call allocation] 136410064/0x82173d0 10/0xa 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:26:20.890914 :80002E7A:db_trace:ksl2.c@2619:kslwtectx(): [10005:43:0] KSL WAIT END wait times (usecs) - snap=308, exc=308, tot=308 2025-03-23 11:26:21.764422 :800030B1:db_trace:ksl2.c@12699:ksliwat(): [10005:43:0] KSL POST RCVD poster=22 loc='ksr2.h LINE:603 ID:ksrpublish' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:31:22.395536 :80009AAE:db_trace:ksl2.c@2477:kslwtbctx(): [10005:43:90] KSL WAIT BEG [latch free] 136424880/0x821adb0 45/0x2d 0/0x0 wait_id=0 seq_num=1 snap_id=1 2025-03-23 11:31:22.395546 :80009AAF:db_trace:ksl2.c@2611:kslwtectx(): [10005:43:90] KSL WAIT END [latch free] 136424880/0x821adb0 45/0x2d 0/0x0 wait_id=0 seq_num=1 snap_id=1 2025-03-23 11:31:22.395547 :80009AB0:db_trace:ksl2.c@2619:kslwtectx(): [10005:43:90] KSL WAIT END wait times (usecs) - snap=13, exc=13, tot=13 2025-03-23 11:31:22.395799 :80009ABC:db_trace:ksl2.c@2324:kslwtbctx(): [10005:43:0] KSL WAIT BEG [latch free] 136431760/0x821c890 70/0x46 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:31:22.395804 :80009AC0:db_trace:ksl2.c@2611:kslwtectx(): [10005:43:0] KSL WAIT END [latch free] 136431760/0x821c890 70/0x46 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:31:22.395805 :80009AC1:db_trace:ksl2.c@2619:kslwtectx(): [10005:43:0] KSL WAIT END wait times (usecs) - snap=6, exc=6, tot=6 2025-03-23 11:31:22.395829 :80009AC6:db_trace:ksl2.c@2324:kslwtbctx(): [10005:43:0] KSL WAIT BEG [latch: call allocation] 136410064/0x82173d0 10/0xa 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:31:22.396295 :80009AE5:db_trace:ksl2.c@2611:kslwtectx(): [10005:43:0] KSL WAIT END [latch: call allocation] 136410064/0x82173d0 10/0xa 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:31:22.396295 :80009AE6:db_trace:ksl2.c@2619:kslwtectx(): [10005:43:0] KSL WAIT END wait times (usecs) - snap=465, exc=465, tot=465 2025-03-23 11:31:22.396298 :80009AE7:db_trace:ksl2.c@2324:kslwtbctx(): [10005:43:0] KSL WAIT BEG [latch: call allocation] 136410064/0x82173d0 10/0xa 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:31:22.396352 :80009AE9:db_trace:ksl2.c@2611:kslwtectx(): [10005:43:0] KSL WAIT END [latch: call allocation] 136410064/0x82173d0 10/0xa 0/0x0 wait_id=0 seq_num=0 snap_id=0 2025-03-23 11:31:22.396353 :80009AEA:db_trace:ksl2.c@2619:kslwtectx(): [10005:43:0] KSL WAIT END wait times (usecs) - snap=54, exc=54, tot=54 2025-03-23 11:31:22.397628 :80009B38:db_trace:kst.c@698:kstpsodel(): [10280:43:0] kst: process state object about to be deleted ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 43 (osid: 3320, P020)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de