This discussion is archived
2 Replies Latest reply: Jan 28, 2013 7:02 AM by User529841-OC RSS

ORA-7445 Error

User529841-OC Newbie
Currently Being Moderated
two days ago my database 11g has started sending warnings about this error

ORA-7445 [kkoatSampPred()+26] [SIGSEGV] [ADDR:0x24] [PC:0x45F618A] [Address not mapped to object]

Can anyone help me to figure out what does this message means?
ORA-7445 seems to be a very generic error.
Down here I pasted the file trc

thanks

Luc




/home/oracle/app/oracle/diag/rdbms/bi/BI/incident/incdir_49523/BI_j002_32045_i49523.trc
Error Stack:
incident_dump:========= Dump for incident 49523 (ORA 7445 [kkoatSampPred()+26]) ========
custom_assert_dump:----- Beginning of Customized Incident Dump(s) -----
current_sql_statement:----- Current SQL Statement for this session (sql_id=a99zk89s1ybk5) -----
PL/SQL Stack:----- PL/SQL Stack -----
call_stack_dump:----- Call Stack Trace -----
call_stack_binary_dump:--------------------- Binary Stack Dump ---------------------
call_stack_frame_dump:========== FRAME [1] (skdstdst()+36 -> kgdsdst()) ==========
call_stack_frame_dump:========== FRAME [2] (ksedst1()+98 -> skdstdst()) ==========
call_stack_frame_dump:========== FRAME [3] (ksedst()+34 -> ksedst1()) ==========
call_stack_frame_dump:========== FRAME [4] (dbkedDefDump()+2736 -> ksedst()) ==========
call_stack_frame_dump:========== FRAME [5] (ksedmp()+36 -> dbkedDefDump()) ==========
call_stack_frame_dump:========== FRAME [6] (ssexhd()+2326 -> ksedmp()) ==========
call_stack_frame_dump:========== FRAME [7] (__restore_rt() -> ssexhd()) ==========
call_stack_frame_dump:========== FRAME [8] (kkoatSampPred()+26 -> __restore_rt()) ==========
call_stack_frame_dump:========== FRAME [9] (kkoatGetPreds()+776 -> kkoatSampPred()) ==========
call_stack_frame_dump:========== FRAME [10] (kkoatVerifyEst()+2672 -> kkoatGetPreds()) ==========
call_stack_frame_dump:========== FRAME [11] (kkeAdjJoinPrefCard()+1277 -> kkoatVerifyEst()) ==========
call_stack_frame_dump:========== FRAME [12] (kkejcd()+1884 -> kkeAdjJoinPrefCard()) ==========
call_stack_frame_dump:========== FRAME [13] (kkojnp()+3632 -> kkejcd()) ==========
call_stack_frame_dump:========== FRAME [14] (kkocnp()+65 -> kkojnp()) ==========
call_stack_frame_dump:========== FRAME [15] (kkooqb()+24064 -> kkocnp()) ==========
call_stack_frame_dump:========== FRAME [16] (kkoqbc()+2244 -> kkooqb()) ==========
call_stack_frame_dump:========== FRAME [17] (apakkoqb()+166 -> kkoqbc()) ==========
call_stack_frame_dump:========== FRAME [18] (apaqbdDescendents()+451 -> apakkoqb()) ==========
call_stack_frame_dump:========== FRAME [19] (apaqbdList()+71 -> apaqbdDescendents()) ==========
call_stack_frame_dump:========== FRAME [20] (apaqbd()+9 -> apaqbdList()) ==========
call_stack_frame_dump:========== FRAME [21] (kkqctCostTransfQB()+248 -> apaqbd()) ==========
call_stack_frame_dump:========== FRAME [22] (kkqstarFinalizeFactNode()+162 -> kkqctCostTransfQB()) ==========
call_stack_frame_dump:========== FRAME [23] (kkqstarGetSecDir()+1275 -> kkqstarFinalizeFactNode()) ==========
call_stack_frame_dump:========== FRAME [24] (kkqstarGetDir()+70 -> kkqstarGetSecDir()) ==========
call_stack_frame_dump:========== FRAME [25] (kkqctNxtTwoPassStt()+763 -> kkqstarGetDir()) ==========
call_stack_frame_dump:========== FRAME [26] (kkqctGetNxtStt()+247 -> kkqctNxtTwoPassStt()) ==========
call_stack_frame_dump:========== FRAME [27] (kkqctdrvST()+2272 -> kkqctGetNxtStt()) ==========
call_stack_frame_dump:========== FRAME [28] (qksqbApplyToQbcLoc()+601 -> kkqctdrvST()) ==========
call_stack_frame_dump:========== FRAME [29] (qksqbApplyToQbc()+951 -> qksqbApplyToQbcLoc()) ==========
call_stack_frame_dump:========== FRAME [30] (kkqctdrvTD()+4950 -> qksqbApplyToQbc()) ==========
call_stack_frame_dump:========== FRAME [31] (kkqstardrv()+373 -> kkqctdrvTD()) ==========
call_stack_frame_dump:========== FRAME [32] (kkqdrv()+1641 -> kkqstardrv()) ==========
call_stack_frame_dump:========== FRAME [33] (kkqctdrvIT()+712 -> kkqdrv()) ==========
call_stack_frame_dump:========== FRAME [34] (apadrv()+2615 -> kkqctdrvIT()) ==========
call_stack_frame_dump:========== FRAME [35] (opitca()+1733 -> apadrv()) ==========
call_stack_frame_dump:========== FRAME [36] (kksFullTypeCheck()+29 -> opitca()) ==========
call_stack_frame_dump:========== FRAME [37] (rpiswu2()+1541 -> kksFullTypeCheck()) ==========
call_stack_frame_dump:========== FRAME [38] (kksLoadChild()+7565 -> rpiswu2()) ==========
call_stack_frame_dump:========== FRAME [39] (kxsGetRuntimeLock()+1992 -> kksLoadChild()) ==========
call_stack_frame_dump:========== FRAME [40] (kksfbc()+13436 -> kxsGetRuntimeLock()) ==========
call_stack_frame_dump:========== FRAME [41] (kkspsc0()+1787 -> kksfbc()) ==========
call_stack_frame_dump:========== FRAME [42] (kksParseCursor()+139 -> kkspsc0()) ==========
call_stack_frame_dump:========== FRAME [43] (opiosq0()+1915 -> kksParseCursor()) ==========
call_stack_frame_dump:========== FRAME [44] (kpooprx()+290 -> opiosq0()) ==========
call_stack_frame_dump:========== FRAME [45] (kpoal8()+774 -> kpooprx()) ==========
call_stack_frame_dump:========== FRAME [46] (opiodr()+1149 -> kpoal8()) ==========
call_stack_frame_dump:========== FRAME [47] (kpoodrc()+31 -> opiodr()) ==========
call_stack_frame_dump:========== FRAME [48] (rpiswu2()+1541 -> kpoodrc()) ==========
call_stack_frame_dump:========== FRAME [49] (kpoodr()+612 -> rpiswu2()) ==========
call_stack_frame_dump:========== FRAME [50] (upirtrc()+2357 -> kpoodr()) ==========
call_stack_frame_dump:========== FRAME [51] (kpurcsc()+93 -> upirtrc()) ==========
call_stack_frame_dump:========== FRAME [52] (kpuexec()+9779 -> kpurcsc()) ==========
call_stack_frame_dump:========== FRAME [53] (OCIStmtExecute()+34 -> kpuexec()) ==========
call_stack_frame_dump:========== FRAME [54] (qksanExecSql()+684 -> OCIStmtExecute()) ==========
call_stack_frame_dump:========== FRAME [55] (qksanAnalyzeSql()+2108 -> qksanExecSql()) ==========
call_stack_frame_dump:========== FRAME [56] (qksanAnalyzeSegSql()+77 -> qksanAnalyzeSql()) ==========
call_stack_frame_dump:========== FRAME [57] (kestsaDoRounds()+1287 -> qksanAnalyzeSegSql()) ==========
call_stack_frame_dump:========== FRAME [58] (kestsaAutoTuneSql()+1206 -> kestsaDoRounds()) ==========
call_stack_frame_dump:========== FRAME [59] (kestsaAutoTuneDrv()+1085 -> kestsaAutoTuneSql()) ==========
call_stack_frame_dump:========== FRAME [60] (kestsTuneSqlDrv()+184 -> kestsaAutoTuneDrv()) ==========
call_stack_arg_register_dump: ----- Argument/Register Address Dump -----
process_map_dump:----- Process Map Dump -----
guard_frame_metadata:----- Guard Frame Metadata Dump -----
java_stack:----- Java Stack -----
fixed_areas:----- Fixed Areas Dump (level=71) -----
fixed_pga:----- Dump of the Fixed PGA -----
fixed_generic_pga:----- Dump of the Fixed Generic PGA -----
fixed_sga:----- Dump of the Fixed SGA -----
fixed_gsga:----- Dump of the Fixed Generic SGA -----
fixed_uga:----- Dump of the Fixed USGA -----
fixed_gsga:----- Dump of the Fixed Generic UGA -----
process_state:----- Process State Dump (2)-----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
child_cursor_dump:

session_cursors_dump:----- Session Cursor Dump -----
current_cursor_dump:----- Current Cursor -----
cursor_xsc_bindump:----- Binary dump of xsc -----
cursor_ctxdef_bindump:----- Binary dump of ctxdef -----
cursor_ctxrhds_bindump:----- Binary dump of run-time heap -----
session_open_cursors_dump:----- Session Open Cursors -----
curdef_dump:Cursor#2(0x2ad739db1a80) state=BOUND curiob=0x2ad739dd6f20
cursor_dump:----- Dump Cursor sql_id=59v4zh1ac3v2a xsc=0x2ad739dd6f20 cur=0x2ad739db1a80 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_bind_bytecode_out:----- Bind Byte Code (OUT) -----
cursor_bind_bytecode_in:----- Bind Byte Code (IN) -----
cursor_bind_info:----- Bind Info (kkscoacd) -----
curdef_dump:Cursor#3(0x2ad739db1b10) state=BOUND curiob=0x2ad739f16c40
cursor_dump:----- Dump Cursor sql_id=g6sky1sj5hysw xsc=0x2ad739f16c40 cur=0x2ad739db1b10 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#1(0x2ad739db19f0) state=BOUND curiob=0x2ad739f509b8
cursor_dump:----- Dump Cursor sql_id=59pmx1qapbjk3 xsc=0x2ad739f509b8 cur=0x2ad739db19f0 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#5(0x2ad739db1c30) state=BOUND curiob=0x2ad739f50658
cursor_dump:----- Dump Cursor sql_id=5rr4cr8d38fpt xsc=0x2ad739f50658 cur=0x2ad739db1c30 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#8(0x2ad739db1de0) state=BOUND curiob=0x2ad73a056be0
cursor_dump:----- Dump Cursor sql_id=4n6n6yr3u3vax xsc=0x2ad73a056be0 cur=0x2ad739db1de0 -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#9(0x2ad739db1e70) state=BOUND curiob=0x2ad73a056680
cursor_dump:----- Dump Cursor sql_id=5sxszjtu4m9yj xsc=0x2ad73a056680 cur=0x2ad739db1e70 -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#10(0x2ad739db1f00) state=BOUND curiob=0x2ad73a493870
cursor_dump:----- Dump Cursor sql_id=g4um54aqp3kmc xsc=0x2ad73a493870 cur=0x2ad739db1f00 -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#11(0x2ad739db1f90) state=BOUND curiob=0x2ad739e7c580
cursor_dump:----- Dump Cursor sql_id=7p36nhcab5b4w xsc=0x2ad739e7c580 cur=0x2ad739db1f90 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#12(0x2ad739db2020) state=BOUND curiob=0x2ad739e7c220
cursor_dump:----- Dump Cursor sql_id=8rd7vhbrgqz1g xsc=0x2ad739e7c220 cur=0x2ad739db2020 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#13(0x2ad739db20b0) state=BOUND curiob=0x2ad739f8cdb8
cursor_dump:----- Dump Cursor sql_id=g5m0bnvyy37b1 xsc=0x2ad739f8cdb8 cur=0x2ad739db20b0 -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_bind_bytecode_in:----- Bind Byte Code (IN) -----
cursor_bind_info:----- Bind Info (kkscoacd) -----
curdef_dump:Cursor#7(0x2ad739db1d50) state=BOUND curiob=0x2ad739f4f0e8
cursor_dump:----- Dump Cursor sql_id=cd128j7abrw14 xsc=0x2ad739f4f0e8 cur=0x2ad739db1d50 -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_bind_bytecode_out:----- Bind Byte Code (OUT) -----
cursor_bind_bytecode_in:----- Bind Byte Code (IN) -----
cursor_bind_info:----- Bind Info (kkscoacd) -----
curdef_dump:Cursor#4(0x2ad739db1ba0) state=ROW curiob=0x2ad73a056f40
cursor_dump:----- Dump Cursor sql_id=424h0nf7bhqzd xsc=0x2ad73a056f40 cur=0x2ad739db1ba0 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_bind_bytecode_in:----- Bind Byte Code (IN) -----
cursor_bind_info:----- Bind Info (kkscoacd) -----
curdef_dump:Cursor#14(0x2ad739db2140) state=BOUND curiob=0x2ad739e8cdc8
cursor_dump:----- Dump Cursor sql_id=839k4s1b1s6a7 xsc=0x2ad739e8cdc8 cur=0x2ad739db2140 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#15(0x2ad739db21d0) state=BOUND curiob=0x2ad73a0739a0
cursor_dump:----- Dump Cursor sql_id=cgcpkn0xbb35h xsc=0x2ad73a0739a0 cur=0x2ad739db21d0 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
curdef_dump:Cursor#17(0x2ad739db22f0) state=SYNTAX curiob=0x2ad739e93030
cursor_dump:----- Dump Cursor sql_id=a99zk89s1ybk5 xsc=0x2ad739e93030 cur=0x2ad739db22f0 -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
sql_object:Starting SQL statement dump
current_sql_statement:----- Current SQL Statement for this session (sql_id=a99zk89s1ybk5) -----
PL/SQL Stack:----- PL/SQL Stack -----
optimizer_state:Optimizer state dump:
compilation_environment:Bug Fix Control Environment
cached_cursors:----- Session Cached Cursor Dump -----
generic_cached_cursors:----- Generic Session Cached Cursor Dump -----
rdbms_cached_cursors:----- RDBMS Session Cached Cursor Dump -----
cursor_dump:----- Dump Cursor sql_id=2dwc02nvhh4ug xsc=0x2ad739f19c78 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=ctqfp94452zwc xsc=0x2ad739f18a70 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=7yzrxyr4c4x8z xsc=0x2ad739f18138 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=dk3b123p7r9g9 xsc=0x2ad739efc750 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=9xc110my4bxm0 xsc=0x2ad739f27498 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=b0zjmqksucj3y xsc=0x2ad739f26f78 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=3radj2m4q9f2w xsc=0x2ad739f26640 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=ggpdp5ny7dxac xsc=0x2ad739f26198 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=cprbus8brypfr xsc=0x2ad739f26ad0 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=5x02baz48zq08 xsc=0x2ad739f6c790 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=49z9aff5bg0yx xsc=0x2ad739f6c300 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=28ut9acxabpj9 xsc=0x2ad739f43d18 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=9jjdth5xc2pq4 xsc=0x2ad739f439b8 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=38uf8anvk7rhw xsc=0x2ad739f511e8 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=2v3yknpwxkvtv xsc=0x2ad739f43528 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=8uvjkznfxk0b3 xsc=0x2ad739f50e88 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=agx159bc8zx12 xsc=0x2ad739e4c4b0 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=05qp00hqz20ft xsc=0x2ad739f24aa0 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=cv42vyz073jak xsc=0x2ad739f24510 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=auaqvk5w7uh75 xsc=0x2ad739f19918 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=11c4adc2p66y8 xsc=0x2ad73a073d60 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=3jvckj4584rn2 xsc=0x2ad73a44e440 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=1xar5z51h2y0u xsc=0x2ad73a05dd68 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=01zgfy2mygvc6 xsc=0x2ad739e7d410 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=202vk9cq2h63r xsc=0x2ad739e7d0b0 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=9dzv2dyhrfk3n xsc=0x2ad739f8e250 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=4125jqjwrsp2j xsc=0x2ad739e8c868 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=b94dvw0r4c6rp xsc=0x2ad739e4c150 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=2vx3ud50wmt80 xsc=0x2ad739e8c508 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=0uz76y6sf0r1y xsc=0x2ad739e8c1a8 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=69bcp7snfca18 xsc=0x2ad73a733f80 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=1tyhmp4k7ct72 xsc=0x2ad73a30ca60 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=dgj9npvuhszs4 xsc=0x2ad739e81c78 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=8cstk793zg8n9 xsc=0x2ad739e81918 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=d61rs9z4bsdvq xsc=0x2ad73a455a60 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=afzq1f1xpxv18 xsc=0x2ad739e7dbd8 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=8sfavnp8y7nsq xsc=0x2ad73a05e450 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=893q6mgp3ak5t xsc=0x2ad739e815b8 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=18tn1sys6dxm5 xsc=0x2ad739e7d878 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=awnn70sa9s852 xsc=0x2ad73a3a0a78 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=8wjz10qnvfjay xsc=0x2ad739f13a58 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=87gaftwrm2h68 xsc=0x2ad73a256f28 cur=(nil) -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_bind_bytecode_in:----- Bind Byte Code (IN) -----
cursor_bind_info:----- Bind Info (kkscoacd) -----
cursor_dump:----- Dump Cursor sql_id=3nkd3g3ju5ph1 xsc=0x2ad73a2587d8 cur=(nil) -----
child_cursor_dump:
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_bind_bytecode_in:----- Bind Byte Code (IN) -----
cursor_bind_info:----- Bind Info (kkscoacd) -----
cursor_dump:----- Dump Cursor sql_id=77mtwmnd4c4pk xsc=0x2ad739ed1b78 cur=(nil) -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=9k43zr1uannr6 xsc=0x2ad739ecc928 cur=(nil) -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_bind_bytecode_in:----- Bind Byte Code (IN) -----
cursor_bind_info:----- Bind Info (kkscoacd) -----
cursor_dump:----- Dump Cursor sql_id=1a8n1zgb7m90w xsc=0x2ad739efcec8 cur=(nil) -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_bind_bytecode_in:----- Bind Byte Code (IN) -----
cursor_bind_info:----- Bind Info (kkscoacd) -----
cursor_dump:----- Dump Cursor sql_id=96g93hntrzjtr xsc=0x2ad739ed5738 cur=(nil) -----
child_cursor_dump:
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_bind_bytecode_in:----- Bind Byte Code (IN) -----
cursor_bind_info:----- Bind Info (kkscoacd) -----
cursor_dump:----- Dump Cursor sql_id=127wjuu9n6rb5 xsc=0x2ad739f10618 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=bydu6hvazsn5r xsc=0x2ad739f0f4b0 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
cursor_dump:----- Dump Cursor sql_id=5n8gt16uhxa17 xsc=0x2ad739f0f150 cur=(nil) -----
child_cursor_dump:
parent_cursor_dump:
cursor_sharing_diagnostics_dump:
pinned_buffer_history:----- Pinned Buffer History -----
plsql_runtime_state:----- PL/SQL Runtime State -----
archival_runtime_state:----- Archival Runtime State -----
recovery_context_info:----- Recovery Context Info -----
sql_control_block:----- SQL Control Block -----
trace bucket:xsc=0x2ad739f8cdb8 estart=1359320505 eid=16777285 ctx=0x8acf7c68 cwh=0x2ad739f3c068 cpu=42994 buffg=90 interb=712704 r=1 rb=712704 w=0 wb=0
kghscDump:Dumping stream dest (@=0x7fff2d6c0a58 offset=0 length=0 size=1632 first=0xb01e67f0 cur=0xb01e67f0 mbs=1000 hp=(nil) opt=18)
kghscDump:Dumping stream src (@=0x7fff2d6c0ea0 offset=0 length=1030 size=2000 first=0x7fff2d6c12d0 cur=0x7fff2d6c12d0 mbs=1000 hp=0x2ad739e1c0b8 opt=57)
qksanPostAnalyzeDump: qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980
qksanPostAnalyzeDump: qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980
trace bucket:------------------------------------------------------------------------------- Trace Bucket Dump Begin: KSI TIME(*=approx):SEQ:FILE@LINE:FUNCTION: DATA -------------------------------------------------------------------------------
autosga_transfer_history:----- Auto SGA Transfer History -----
verify_checkpoint_queue:----- Verification of Checkpoint Queue -----
db_cache_advice:----- DB Cache Advice Metadata -----
object_stats_elements:----- Object Level Stats Elements -----
event_group_dump:Dumping Event (group=SESSION)
event_group_dump:Dumping Event (group=SYSTEM)
Event Triggered Actions:----- START Event Driven Actions Dump ----
DDE Actions:----- START DDE Actions Dump -----
DDE Action:----- START DDE Action: 'dumpFrameContext' (Sync) -----
Frame Context:----- START Frame Context DUMP -----
FC REcord:[0001] (location=FILE:apa.c LINE:2783 FUNCTION:apaqbdDescendents() ID:dbgec*):
USER_DUMP:USER_DUMP_START
kkotrcDumpQbc:Query block=0x2ad73a0e41c0
FC REcord:[0002] (location=FILE:qksan.c LINE:3422 FUNCTION:qksanAnalyzeSql() ID:dbgec*):
USER_DUMP:USER_DUMP_START
qksanDumpAnalyzeCtx:Dumping SQL analyze context=0x7fff2d6c7918
qksanctx:Dumping 'qksanctx' addr=0x7fff2d6c7918 size=1056 bytes Dump of memory from 0x7fff2d6c7918 to 0x7fff2d6c7d38
qksanDumpSql: qksanDumpSql() dumping sql text
compilation_environment:Bug Fix Control Environment
keshs_Dump:----- Dump of outline -----
FC REcord:[0003] (location=FILE:kesai.c LINE:4474 FUNCTION:kesaiTuneSqlDrv() ID:dbgec*):
USER_DUMP:USER_DUMP_START
kesaiDumpDumpCtx:Dumping Dumping Context=0x7fff2d6cb520
sqladv_task_dump:Dumping advisor task 0x7fff2d6c9ed0
kesatmDumpTask:kesatmDumpTask(): dump adv task metadata
sqladv_task_mem_dump:binary dump old structure kesatmCtx
keaobj:Dumping advisor object 0x2ad739d8f918 (target)
kestsDumpCtl:kestsDumpCtl(): dump control parameters
keaobj:Dumping advisor object 0x2ad73a0c1da8 (current)
sqladv_task_stats:kesatmDumpTaskStats() begin
kesqsDumpSql:kesqsDumpSql(): dumping sql structure
qksanDumpSql: qksanDumpSql() dumping sql text
kesqsDumpStats:
compilation_environment:Bug Fix Control Environment
trace bucket: keswatPopBuckets(): begin bid=7221 eid=7387
sqladv_task_dump:Dumping advisor task 0x7fff2d6c9ed0
kesatmDumpTask:kesatmDumpTask(): dump adv task metadata
keaobj:Dumping advisor object 0x2ad739d8f918 (target)
kestsDumpCtl:kestsDumpCtl(): dump control parameters
kesqsDumpSql:kesqsDumpSql(): dumping sql structure
qksanDumpSql: qksanDumpSql() dumping sql text
qksanPostAnalyzeDump: qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980
qksanPostAnalyzeDump: qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980
kestsaMakeEndTraces:kestsaMakeEndTraces(): dump state at end of auto-tune
qksanPostAnalyzeDump: qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980
kestsDumpXpl:kestsDumpXpl(): dump explain plan(s): first type=original
kestsDumpXpl single plan:Dumping plan with type=original
kesqsDumpSql:kesqsDumpSql(): dumping sql structure
qksanDumpSql: qksanDumpSql() dumping sql text
kestsDumpFinding:kestsDumpFinding(): dump finding structure
kesqsDumpSql:kesqsDumpSql(): dumping sql structure
qksanDumpSql: qksanDumpSql() dumping sql text
qksanPostAnalyzeDump: qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980
qksanPostAnalyzeDump: qksanPostAnalyzeDump(): Dumping analyze context after compilation qksanStatus=SUCCESS ecode=10980
DDE Action:----- START DDE Action: 'dumpBuckets' (Sync) -----
DDE Action:----- START DDE Action: 'dumpDiagCtx' (Sync) -----
Diag Context Dump:------- Diag Context Dump -------
gen_diagctx_dump:----- General DiagCtx Dump -----
dde_diag_dump:----- DDE Diagnostic Information Dump -----
Invocation Context:----- Invocation Context Dump -----
Incident Context:----- Incident Context Dump -----
Invocation Context:----- Invocation Context Dump -----
uts_diag_dump:----- UTS Diagnostic Information Dump (addr=0x2ad739ce8398) -----
uts_file_dump:==== Dumping UTS file=0x2ad739cf2fb0 desc=default ====
uts_adrfile_dump:--- Dumping UTS file (ADR type) file=0x2ad739cf2fb0 ---
uts_fstack_dump:--- Dumping file stack addr=0x2ad739ce8328 cnt=1 ---
uts_file_dump:==== Dumping UTS file=0x2ad739cf6e48 desc=stack ====
uts_adrfile_dump:--- Dumping UTS file (ADR type) file=0x2ad739cf6e48 ---
events_diag_dump:----- Events Diagnostic Information Dump -----
eventGrp_Dump:--- Dump of Event Group ---
eventGrp_Dump:--- Dump of Event Group ---
adr_diag_dump:----- ADR Diagnostic Information Dump -----
ads_open_files_dump:----- ADS Open Files Dump -----
ads_streamds_dump:----- ADS Stream Desc Dump -----
ads_streamds_dump:----- ADS Stream Desc Dump -----
ads_streamds_dump:----- ADS Stream Desc Dump -----
ads_streamds_dump:----- ADS Stream Desc Dump -----
adl_diag_dump:----- ADL Diagnostic Information Dump -----
diag_ctx_memory:----- Diag Context Memory -----
diag_ctx_params_memory:----- Diag Context Init Params Memory -----
thread_local_root:----- Diag Thread Local Root Dump -----
thread_local_root_memory:----- Diag Thread Local Root Memory -----
diag_ctx_fc_memory:----- Diag Context Flood Control Memory -----
DDE Action:----- START DDE Action: 'dumpGenralConfiguration' (Sync) -----
General Configuration:========= General Configuration ========
General Configuration Source:--------- GC Source: [generic GC] --------
General Configuration Source:--------- GC Source: [unittest_GC] --------
General Configuration Source:--------- GC Source: [kernel_GC] --------
General Configuration Source:--------- GC Source: [Non_Default_Kernel_Parameters] --------
General Configuration Source:--------- GC Source: [Visible_Default_Kernel_Parameters] --------
DDE Action:----- START DDE Action: 'kzxt_dump_action' (Sync) -----
DDE Action:----- START DDE Action: 'kdlut_bucketdump_action' (Sync) -----
DDE Action:----- START DDE Action: 'dumpKernelDiagState' (Sync) -----
Kernel Diag Dump:------- Kernel Diag Dump -------
DDE Action:----- START DDE Action: 'xdb_dump_buckets' (Sync) -----
DDE Action:----- START DDE Action: 'dumpKGERing' (Sync) -----
DDE Action:----- START DDE Action: 'kpuActionDefault' (Sync) -----

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points