Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250816220848\orcl_p017_3336_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250816220848\orcl_p017_3336_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:35442M/63366M, Ph+PgF:40772M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 40 Windows thread id: 3336, image: ORACLE.EXE (P017) *** 2025-08-16 22:08:48.230 *** 2025-08-16 22:08:48.230 Process diagnostic dump for ORACLE.EXE (P017), OS id=3336, pid: 40, 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-08-16 22:08:48.230 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 40 (osid: 3336, P017) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-03-23 11:26:20.576572 :8000066B:db_trace:kst.c@673:kstipg(): [10280:40:0] kst: process state object created on 03-23 11:26:20.577 2025-03-23 11:26:20.576572 :8000066C:db_trace:kst.c@679:kstipg(): [10280:40:0] kst: process info: ospid=3336 pso_num=40 pso_serial#=1 2025-03-23 11:26:20.576643 :8000066D:db_trace:kso.c@4093:ksonfy(): [10420:40:0] kso: new process: pid=3336 osp_idx=38 osp_ver=0 osp_pg=0 (spawn #39) 2025-03-23 11:26:20.576643 :8000066E:db_trace:kso.c@4099:ksonfy(): [10420:40:0] kso: new process: first_req_pid=3724 spawner_pid=3660 sga_crt_ts=x8A8A 2025-03-23 11:26:20.576643 :8000066F:db_trace:kso.c@4103:ksonfy(): [10420:40:0] kso: new process: pso_index=40 reservation=1 time=40609 2025-03-23 11:26:20.576644 :80000670:db_trace:kso.c@4109:ksonfy(): [10420:40:0] kso: spawn diagnostics: queue time=0 secs 2025-03-23 11:26:20.576644 :80000671:db_trace:kso.c@4111:ksonfy(): [10420:40:0] kso: spawn diagnostics: fork time=0 secs 2025-03-23 11:26:20.576644 :80000672:db_trace:kso.c@4113:ksonfy(): [10420:40:0] kso: spawn diagnostics: exec time=0 secs 2025-03-23 11:26:20.576644 :80000673:db_trace:kso.c@4115:ksonfy(): [10420:40:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-03-23 11:26:20.576645 :80000674:db_trace:kso.c@4117:ksonfy(): [10420:40:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-03-23 11:26:20.576678 :80000675:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40: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.611476 :80000830:db_trace:ksl2.c@12699:ksliwat(): [10005:40: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.614018 :80000896:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.622521 :800008C0:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] 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.633533 :800008DC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.639085 :8000094E:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] 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.639091 :80000955:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.642868 :800009FA:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] 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.665672 :80000A8D:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.736176 :800021C3:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] 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.740208 :800021DC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.740609 :80002374:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] 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.747138 :800023AC:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.863299 :80002A51:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] 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.863306 :80002A61:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.873010 :80002C7B:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] 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.876015 :80002CAD:KFNU:kfn.c@2200:kfnPrepareASM(): kfnPrepareASM force=0 state_kfnsg=0x7 2025-03-23 11:26:20.884447 :80002D0B:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] KSL POST RCVD poster=51 loc='ksq.h LINE:1877 ID:ksqrcl' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.884776 :80002D0E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] KSL POST SENT postee=25 loc='ksq.h LINE:1877 ID:ksqrcl' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.884847 :80002D10:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.887837 :80002D50:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] 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.890092 :80002D9A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.890092 :80002D9B:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.890156 :80002DC9:db_trace:ksl2.c@12699:ksliwat(): [10005:40:66] 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.890166 :80002DD4:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:40:66] 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.890187 :80002DE6:db_trace:ksl2.c@2477:kslwtbctx(): [10005:40:66] KSL WAIT BEG [latch free] 136586856/0x8242668 375/0x177 0/0x0 wait_id=50 seq_num=51 snap_id=1 2025-03-23 11:26:20.890492 :80002E2C:db_trace:ksl2.c@2611:kslwtectx(): [10005:40:66] KSL WAIT END [latch free] 136586856/0x8242668 375/0x177 0/0x0 wait_id=50 seq_num=51 snap_id=1 2025-03-23 11:26:20.890493 :80002E2D:db_trace:ksl2.c@2619:kslwtectx(): [10005:40:66] KSL WAIT END wait times (usecs) - snap=305, exc=305, tot=305 2025-03-23 11:26:20.890649 :80002E5C:db_trace:ksl2.c@2324:kslwtbctx(): [10005:40: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.891032 :80002E83:db_trace:ksl2.c@2611:kslwtectx(): [10005:40: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.891033 :80002E84:db_trace:ksl2.c@2619:kslwtectx(): [10005:40:0] KSL WAIT END wait times (usecs) - snap=383, exc=383, tot=383 2025-03-23 11:26:21.764429 :800030B7:db_trace:ksl2.c@12699:ksliwat(): [10005:40: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.395831 :80009AC7:db_trace:ksl2.c@2324:kslwtbctx(): [10005:40: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.396221 :80009AE0:db_trace:ksl2.c@2611:kslwtectx(): [10005:40: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.396223 :80009AE1:db_trace:ksl2.c@2619:kslwtectx(): [10005:40:0] KSL WAIT END wait times (usecs) - snap=392, exc=392, tot=392 2025-03-23 11:31:22.397487 :80009B33:db_trace:kst.c@698:kstpsodel(): [10280:40:0] kst: process state object about to be deleted ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 40 (osid: 3336, P017)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de