Edit D:\app\Administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250826220006\orcl_j003_4604_bucket.trc
Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\cdmp_20250826220006\orcl_j003_4604_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:35165M/63366M, Ph+PgF:40208M/72582M Instance name: orcl Redo thread mounted by this instance: 1 Oracle process number: 58 Windows thread id: 4604, image: ORACLE.EXE (J003) *** 2025-08-26 22:00:07.170 *** 2025-08-26 22:00:07.170 Process diagnostic dump for ORACLE.EXE (J003), OS id=4604, pid: 58, proc_ser: 3, 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-26 22:00:07.170 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: default bucket for process 58 (osid: 4604, J003) TIME(*=approx):SEQ:COMPONENT:FILE@LINE:FUNCTION:SECT/DUMP: [EVENT#:PID:SID] DATA ------------------------------------------------------------------------------- 2025-03-23 11:26:24.791081 :800033ED:db_trace:kst.c@673:kstipg(): [10280:58:0] kst: process state object created on 03-23 11:26:24.795 2025-03-23 11:26:24.791081 :800033EE:db_trace:kst.c@679:kstipg(): [10280:58:0] kst: process info: ospid=4296 pso_num=58 pso_serial#=1 2025-03-23 11:26:24.791153 :800033EF:db_trace:kso.c@4093:ksonfy(): [10420:58:0] kso: new process: pid=4296 osp_idx=56 osp_ver=0 osp_pg=0 (spawn #59) 2025-03-23 11:26:24.791153 :800033F0:db_trace:kso.c@4099:ksonfy(): [10420:58:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-03-23 11:26:24.791153 :800033F1:db_trace:kso.c@4103:ksonfy(): [10420:58:0] kso: new process: pso_index=58 reservation=1 time=44828 2025-03-23 11:26:24.791154 :800033F2:db_trace:kso.c@4109:ksonfy(): [10420:58:0] kso: spawn diagnostics: queue time=0 secs 2025-03-23 11:26:24.791154 :800033F3:db_trace:kso.c@4111:ksonfy(): [10420:58:0] kso: spawn diagnostics: fork time=0 secs 2025-03-23 11:26:24.791154 :800033F4:db_trace:kso.c@4113:ksonfy(): [10420:58:0] kso: spawn diagnostics: exec time=0 secs 2025-03-23 11:26:24.791154 :800033F5:db_trace:kso.c@4115:ksonfy(): [10420:58:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-03-23 11:26:24.791154 :800033F6:db_trace:kso.c@4117:ksonfy(): [10420:58:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-03-23 11:26:24.791379 :800033F7:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-03-23 11:26:24.791393 :800033FD:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] 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-03-23 11:26:24.798595 :80003403:db_trace:kst.c@698:kstpsodel(): [10280:58:0] kst: process state object about to be deleted 2025-03-23 11:26:24.867192 :8000344D:db_trace:kst.c@673:kstipg(): [10280:58:0] kst: process state object created on 03-23 11:26:24.874 2025-03-23 11:26:24.867193 :8000344E:db_trace:kst.c@679:kstipg(): [10280:58:0] kst: process info: ospid=4300 pso_num=58 pso_serial#=2 2025-03-23 11:26:24.867265 :8000344F:db_trace:kso.c@4093:ksonfy(): [10420:58:0] kso: new process: pid=4300 osp_idx=56 osp_ver=1 osp_pg=0 (spawn #60) 2025-03-23 11:26:24.867266 :80003450:db_trace:kso.c@4099:ksonfy(): [10420:58:0] kso: new process: first_req_pid=3704 spawner_pid=3660 sga_crt_ts=x8A8A 2025-03-23 11:26:24.867266 :80003451:db_trace:kso.c@4103:ksonfy(): [10420:58:0] kso: new process: pso_index=58 reservation=2 time=44906 2025-03-23 11:26:24.867266 :80003452:db_trace:kso.c@4109:ksonfy(): [10420:58:0] kso: spawn diagnostics: queue time=0 secs 2025-03-23 11:26:24.867266 :80003453:db_trace:kso.c@4111:ksonfy(): [10420:58:0] kso: spawn diagnostics: fork time=0 secs 2025-03-23 11:26:24.867266 :80003454:db_trace:kso.c@4113:ksonfy(): [10420:58:0] kso: spawn diagnostics: exec time=0 secs 2025-03-23 11:26:24.867267 :80003455:db_trace:kso.c@4115:ksonfy(): [10420:58:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-03-23 11:26:24.867267 :80003456:db_trace:kso.c@4117:ksonfy(): [10420:58:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-03-23 11:26:24.867516 :80003457:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=18 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-03-23 11:26:24.867531 :8000345F:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] 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-03-23 11:26:24.891483 :8000346E:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=56 loc='kcb2.h LINE:3844 ID:kcbzww' id1=0 id2=0 name= type=0 2025-03-23 11:26:26.397795*:800035FE:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x00000000320BDA40 estart=1742700385 eid=16777258 ctx=0x000000077FF2E8D0 cwh=0x00000000311961C8 cpu=0 buffg=0 interb=0 r=0 rb=0 w=0 wb=0 2025-03-23 11:26:26.397795*:800035FF:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x00000000320BDA40 curCtx=0x00000000322AFF48 pubTabIdxCnt=0 2025-03-23 11:26:26.397795*:80003600:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x00000000320BDA40 2025-03-23 11:26:26.397795*:80003601:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x00000000320BDA40 2025-03-23 11:26:26.397795*:80003602:sql_mon_query:keswx.c@6099:keswxCurPushMonitoring(begin): xsc=0x0000000032094700 estart=1742700384 eid=16777216 ctx=0x0000000777EE4ED0 cwh=0x00000000320B0158 cpu=93750 buffg=6263 interb=8216576 r=449 rb=8216576 w=0 wb=0 2025-03-23 11:26:26.397795*:80003603:sql_mon_query:keswx.c@2839:keswxCurPrepare(): Allocate monitor context: xsc=0x0000000032094700 curCtx=0x00000000322AEF40 pubTabIdxCnt=0 2025-03-23 11:26:26.397795*:80003604:sql_mon_query:keswx.c@6131:keswxCurPushMonitoring(): clear monitoring flag for xsc=0x0000000032094700 2025-03-23 11:26:26.397795*:80003605:sql_mon_query:keswx.c@6263:keswxCurPushMonitoring(end): full monitoring not yet started for xsc=0x0000000032094700 2025-03-23 11:26:26.444673*:80003612:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x00000000320BDA40 curCtx=0x00000000322AFF48 xsc->flg4=65792 flags=0 2025-03-23 11:26:26.444673*:80003613:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x00000000320BDA40 2025-03-23 11:26:26.792571 :80003669:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:26.794645 :80003671:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:26.796375 :80003679:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:26.803447 :80003681:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:26.814766 :80003689:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:26.816454 :80003691:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:26.819287 :80003699:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:26.820835 :800036A1:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:26.835301*:800036A9:sql_mon_query:keswx.c@3282:keswxCurEndPlanMonitoringCb(begin): xsc=0x0000000032094700 curCtx=0x00000000322AEF40 xsc->flg4=65792 flags=2 2025-03-23 11:26:26.835301*:800036AA:sql_mon_query:keswx.c@3389:keswxCurEndPlanMonitoringCb(end): monitoring has ended for xsc=0x0000000032094700 2025-03-23 11:26:26.840459 :800036AB:db_trace:kst.c@698:kstpsodel(): [10280:58:0] kst: process state object about to be deleted 2025-03-23 11:26:28.292814 :80003878:db_trace:kst.c@673:kstipg(): [10280:58:0] kst: process state object created on 03-23 11:26:28.280 2025-03-23 11:26:28.292815 :80003879:db_trace:kst.c@679:kstipg(): [10280:58:0] kst: process info: ospid=4604 pso_num=58 pso_serial#=3 2025-03-23 11:26:28.292885 :8000387A:db_trace:kso.c@4093:ksonfy(): [10420:58:0] kso: new process: pid=4604 osp_idx=56 osp_ver=2 osp_pg=0 (spawn #67) 2025-03-23 11:26:28.292885 :8000387B:db_trace:kso.c@4099:ksonfy(): [10420:58:0] kso: new process: first_req_pid=4308 spawner_pid=3660 sga_crt_ts=x8A8A 2025-03-23 11:26:28.292885 :8000387C:db_trace:kso.c@4103:ksonfy(): [10420:58:0] kso: new process: pso_index=58 reservation=3 time=48312 2025-03-23 11:26:28.292885 :8000387D:db_trace:kso.c@4109:ksonfy(): [10420:58:0] kso: spawn diagnostics: queue time=0 secs 2025-03-23 11:26:28.292885 :8000387E:db_trace:kso.c@4111:ksonfy(): [10420:58:0] kso: spawn diagnostics: fork time=0 secs 2025-03-23 11:26:28.292886 :8000387F:db_trace:kso.c@4113:ksonfy(): [10420:58:0] kso: spawn diagnostics: exec time=0 secs 2025-03-23 11:26:28.292886 :80003880:db_trace:kso.c@4115:ksonfy(): [10420:58:0] kso: spawn diagnostics: pre dbkc time=0 secs 2025-03-23 11:26:28.292886 :80003881:db_trace:kso.c@4117:ksonfy(): [10420:58:0] kso: spawn diagnostics: post dbkc time=0 secs 2025-03-23 11:26:28.293149 :80003886:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=59 loc='kso2.h LINE:416 ID:ksoreq_reply' id1=0 id2=0 name= type=0 2025-03-23 11:26:28.293424 :8000389F:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:28.295733 :800038CE:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] KSL POST RCVD poster=55 loc='kqr.h LINE:2216 ID:kqrpre1: post after loading' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:28.295842 :800038DA:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] KSL POST RCVD poster=55 loc='kqr.h LINE:2216 ID:kqrpre1: post after loading' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:28.295982 :800038DE:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] KSL POST RCVD poster=55 loc='kqr.h LINE:2216 ID:kqrpre1: post after loading' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:28.296181 :800038F5:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] KSL POST RCVD poster=57 loc='kqr.h LINE:2216 ID:kqrpre1: post after loading' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:28.296267 :800038F7:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] KSL POST RCVD poster=57 loc='kgl.h LINE:8483 ID:kgllldl: post after freeing latch' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:28.310909 :80003919:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] KSL POST RCVD poster=57 loc='kgl.h LINE:8483 ID:kgllldl: post after freeing latch' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:28.311143 :8000391C:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] KSL POST RCVD poster=57 loc='kgl.h LINE:8483 ID:kgllldl: post after freeing latch' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:28.311162 :8000391E:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] KSL POST RCVD poster=57 loc='kgl.h LINE:8483 ID:kgllldl: post after freeing latch' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:28.315237 :80003924:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] KSL POST RCVD poster=57 loc='kcb2.h LINE:3844 ID:kcbzww' id1=0 id2=0 name= type=0 fac#=0 facpost=1 2025-03-23 11:26:28.319749 :80003925:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=57 loc='kcb2.h LINE:3844 ID:kcbzww' id1=0 id2=0 name= type=0 2025-03-23 11:26:28.328458 :80003927:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=57 loc='kcb2.h LINE:3844 ID:kcbzww' id1=0 id2=0 name= type=0 2025-03-23 11:26:28.328464 :80003929:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=57 loc='kcb2.h LINE:3844 ID:kcbzww' id1=0 id2=0 name= type=0 2025-03-23 11:26:28.331562 :8000392A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=57 loc='kcb2.h LINE:3844 ID:kcbzww' id1=0 id2=0 name= type=0 2025-03-23 11:26:28.349467 :80003940:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=57 loc='kcb2.h LINE:3844 ID:kcbzww' id1=0 id2=0 name= type=0 2025-03-23 11:26:28.590132 :8000398A:db_trace:ksl2.c@14083:ksl_update_post_stats(): [10005:58:209] KSL POST SENT postee=14 loc='ksa2.h LINE:282 ID:ksasnd' id1=0 id2=0 name= type=0 2025-03-23 11:26:28.590207 :80003993:db_trace:ksl2.c@12699:ksliwat(): [10005:58:209] 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-03-23 11:26:58.619644 :800045FE:db_trace:kst.c@698:kstpsodel(): [10280:58:0] kst: process state object about to be deleted ------------------------------------------------------------------------------- Trace Bucket Dump End: default bucket for process 58 (osid: 4604, J003)
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de