Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250629181045\orcl_p027_3360_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:36549M/63366M, Ph+PgF:42668M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 50 Windows thread id: 3360, image: ORACLE.EXE (P027) *** 2025-06-29 18:10:45.627 *** 2025-06-29 18:10:45.627 Process diagnostic dump for ORACLE.EXE (P027), OS id=3360, pid: 50, proc_ser: 1, sid: ------------------------------------------------------------------------------- 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-06-29 18:10:45.627 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 50 (osid: 3360, P027) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-03-23 11:26:20.603128 :800007A1:db_trace:kst.c@673:kstipg(): [10280:50:0] kst: process state object created on 03-23 11:26:20.592 2025-03-23 11:26:20.603128 :800007A2:db_trace:kst.c@679:kstipg(): [10280:50:0] kst: process info: ospid=3360 pso_num=50 pso_serial#=1 2025-03-23 11:26:20.603196 :800007A3:db_trace:kso.c@4093:ksonfy(): [10420:50:0] kso: new process: pid=3360 osp_idx=48 osp_ver=0 osp_pg=0 (spawn #49) 2025-03-23 11:26:20.603197 :800007A4:db_trace:kso.c@4099:ksonfy(): [10420:50:0] kso: new process: first_req_pid=3724 spawner_pid=3660 sga_crt_ts=x8A8A 2025-03-23 11:26:20.603197 :800007A5:db_trace:kso.c@4103:ksonfy(): [10420:50:0] kso: new process: pso_index=50 reservation=1 time=40625 2025-03-23 11:26:20.603197 :800007A6:db_trace:kso.c@4109:ksonfy(): [10420:50:0] kso: spawn diagnostics: queue time=0 secs 2025-03-23 11:26:20.603197 :800007A7:db_trace:kso.c@4111:ksonfy(): [10420:50:0] kso: spawn diagnostics: fork time=0 secs 2025-03-23 11:26:20.603197 :800007A8:db_trace:kso.c@4113:ksonfy(): [10420:50:0] kso: spawn diagnostics: exec time=0 secs 2025-03-23 11:26:20.603197 :800007A9:db_trace:kso.c@4115:ksonfy(): [10420:50:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-03-23 11:26:20.603197 :800007AA:db_trace:kso.c@4117:ksonfy(): [10420:50:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-03-23 11:26:20.603229 :800007AB:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50: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.611529 :80000843:db_trace:ksl2.c@12699:ksliwat(): [10005:50: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.613711 :8000087F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.622538 :800008CE:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] 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.635015 :800008E2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.639103 :80000969:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] 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.639109 :80000970:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.645299 :80000A51:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] 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.666654 :80000AB1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.736195 :800021D7:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] 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.740351 :800021F6:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.740627 :80002382:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] 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.747120 :8000239E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.863439 :80002AE9:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] 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.863446 :80002AF2:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.873045 :80002C93:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] 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.875635 :80002C9D:KFNU:kfn.c@2200:kfnPrepareASM(): kfnPrepareASM force=0 state_kfnsg=0x7 2025-03-23 11:26:20.878447 :80002CCB:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] KSL POST RCVD poster=30 loc='ksq.h LINE:1877 ID:ksqrcl' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:20.878845 :80002CCE:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] KSL POST SENT postee=43 loc='ksq.h LINE:1877 ID:ksqrcl' id1=0 id2=0 name= type=0 2025-03-23 11:26:20.878900 :80002CD0:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.887871 :80002D66:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] 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.890074 :80002D7F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.890075 :80002D80:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.890137 :80002DAF:db_trace:ksl2.c@12699:ksliwat(): [10005:50:146] 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.890145 :80002DBA:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:50:146] 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.890425 :80002DF7:db_trace:ksl2.c@2324:kslwtbctx(): [10005:50: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.890506 :80002E31:db_trace:ksl2.c@2611:kslwtectx(): [10005:50: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.890507 :80002E32:db_trace:ksl2.c@2619:kslwtectx(): [10005:50:0] KSL WAIT END wait times (usecs) - snap=81, exc=81, tot=81 2025-03-23 11:26:21.764409 :800030A4:db_trace:ksl2.c@12699:ksliwat(): [10005:50: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.395614 :80009AB2:db_trace:ksl2.c@2324:kslwtbctx(): [10005:50: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.395617 :80009AB3:db_trace:ksl2.c@2611:kslwtectx(): [10005:50: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.395618 :80009AB4:db_trace:ksl2.c@2619:kslwtectx(): [10005:50:0] KSL WAIT END wait times (usecs) - snap=4, exc=4, tot=4 2025-03-23 11:31:22.397117 :80009B1E:db_trace:kst.c@698:kstpsodel(): [10280:50:0] kst: process state object about to be deleted ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 50 (osid: 3360, P027)