ࡱ> SRz(  \     b/ 0DTimes New Roman0̱̱~0DArialNew Roman0̱̱~0"@  @@``  @n?" dd@  @@`` p3     S ~1?`[QDf3f@8 g4MdMdر~0б ppp@ <4!d!dL? W Cursor Sharing   Bug: 2138662  @Bug 2138662: cursor_sharing=force causes ORA-7445 and core dumps A Yrelated bugs 2195595: production instance crashed with a ORA-07445 [11] 1358871: cursor_sharing = force causes ORA-7445 (ttcclr) in proc program 2118514: ora-3113 and ORA-7445 [rworirw2()+704] while running a query having order by 1951929: recieving many ORA-7445 [kqrgcu()+244] errors introduced in Oracle 8.1.7.2, some fixed in Oracle 8.1.7.4D ; :xy      S     J  What is Cursor Sharing?  $Cursor sharing determines what statements are considered to be identical, and can therefore share the same cursor or cache entry. The statement is rewritten bind variables replacing literals Can be enabled as session level In a badly written application this can avoid excessive parse times. %  What goes wrong?  MHeap corruption caused by rewritten statement Associated with ORDER BY clause N  Workarounds  |cursor_sharing = exact cursor_space_for_time = true but sometimes causes ORA-4031 in which case flush shared_pool frequently$4I4I }  Summary  The bugs may be different aspects of the same problem cursor_sharing can cause a heap corruption in the shared pool I would suggest that it is not safe to use this feature to deal with poor performance caused by high parse times.     VDavid Kurtz Go-Faster Consultancy Ltd. david.kurtz@go-faster.co.uk www.go-faster.co.uk< K(-B6"$ / u  ` ___f3f` ___3f` 999MMM>?" dd@,|?" dd@   " @ `"  n?" dd@   @@``PR    @ ` ` p>> S K   (  b8  q0a q 0a2  C BUCENG HZI8Qf3? جU,جU,8`T,8`T q0a2  C BUCENG HZIDQD? U8U8D`T8D`T 2  C BUCENG HZIEQ[? U9U9E`T9E`T dn"   G/*d6?@33@@@sf 4  Z4gֳgֳ ?  T Click to edit Master title style! !:  T5gֳgֳ ?0  RClick to edit Master text styles Second level Third level Fourth level Fifth level!     S    `d5gֳgֳ ?`  ?*    `5gֳgֳ ?   A*    `$6gֳgֳ ?   A*H  0޽h? ??0 ___f3f Fireball.pot\     0 d (   b8  0    0 2   C BUCENG HZI8Qf3? جU,جU,8`T,8`T 0 2   C BUCENG HZIDQD? U8U8D`T8D`T 9Y 2   C BUCENG HZIEQ[? U9U9E`T9E`T "    G/*d6?@33@@@sf   Z$9gֳgֳ ?`  T Click to edit Master title style! !  T9gֳgֳ ?0 `    W#Click to edit Master subtitle style$ $   `D:gֳgֳ ?`  ?*   `:gֳgֳ ?   A*   `;gֳgֳ ?   A*H  0޽h? ??0    ___f3f 0 @0(  V H  0޽h ? ̙33 P$(  r  S $ `  r  S  0 `    H  0޽h ? ___f3f   (   l  C !   l  C D#0  H  0޽h ? ___f3f  P( )pM@ Pl P C D   l P C $0  H P 0޽h ? ___f3f  \(  \l \ C    l \ C 0  H \ 0޽h ? ___f3f  d( )pM@ dl d C Ԛ   l d C T0  H d 0޽h ? ___f3f  0l(  ll l C t   l l C 0  H l 0޽h ? ___f3fH  4v(  4 4 3 rd;gֳgֳ ? `   4 # ld!gֳgֳ ?   d2 4 c !gֳgֳvd @?UQl$ 000 < 2  d2 4 c gֳgֳvd @?@UQ< l$ 000 < 2  d2 4 c D gֳgֳvd @? UQ l$ 000 < 2  d2 4 c gֳgֳvd @?@ TP< l$ 000 < 2  B 4 s *޽h ? f3f3f" 0 8r(  8^ 8S (8    8# l%dIdI 9     H 8 0޽h ? ̙33r<Pc&K'7) `2:+,.0 =Oh+'0\E hp   @ L Xdldb_writer_processes on NT.  David KurtzNC:\Program Files\Microsoft Office\Templates\Presentation Designs\FIREBALL.POT\ David Kurtz6viMicrosoft PowerPointoso@`@ّ0y@q>گGCoM  !P& &&#TNPP0D & TNPP &&TNPP    --- !---&0&W&--&&- $WjjW- $j}}j - $}}"- $*- $3- $;- $C!- $K%- $R)- $X,- $**\.- $*==*`0- $=PP=b1- $PddPd2- $dwwde2- $ww&&&- &P$&[[\{ 0CUd$p,z3;DLU]zepmdtU{C0{\ZW\L&&-&& &&-&&P$&[[\{ 0CUd$p,z3;DLU]zepmdtU{C0{\ZW\L&&- $WjjW- $j}}j - $}}"- $*- $3- $;- $C!- $K%- $R)- $X,- $**\.- $*==*`0- $=PP=b1- $PddPd2- $dwwde2- $ww&- --&&&O &--&& - $O b bO - $b u ub"- $u  u.- $  9- $  D"- $  P'- $  [-- $  e2- $  o7- $  v:- $ " "|=- $" 5 5"@- $5 H H5A- $H \ \HC- $\ o o\C- $o  o&&&- &N$%T T s   (<!M'\,i2s8z?~EL~SzZs`if\lMq<w({sTROTL&&-&& &&-&&N$%T T s   (<!M'\,i2s8z?~EL~SzZs`if\lMq<w({sTROTL&& - $O b bO - $b u ub"- $u  u.- $  9- $  D"- $  P'- $  [-- $  e2- $  o7- $  v:- $ " "|=- $" 5 5"@- $5 H H5A- $H \ \HC- $\ o o\C- $o  o&- --&&&K!~z&--&&- $K!^!^zKz- $^!q!qz^z.- $q!!zqz=- $!!zzM&- $!!zz[-- $!!zzk5- $!!zzy<- $!!zzC- $!!zzI- $! ! zzN- $ !!z zR- $!1!1zzU- $1!D!Dz1zW- $D!X!XzDzY- $X!k!kzXzZ- $k!~!~zkz&&&- &N$%O!O!n!"#$&(+$.71I4X7d;n?vCzH|LzPvUnYd]XaIe7h$knpsuvwnxOxMxKxOL&&-&& &&-&&N$%O!O!n!"#$&(+$.71I4X7d;n?vCzH|LzPvUnYd]XaIe7h$knpsuvwnxOxMxKxOL&&- $K!^!^zKz- $^!q!qz^z.- $q!!zqz=- $!!zzM&- $!!zz[-- $!!zzk5- $!!zzy<- $!!zzC- $!!zzI- $! ! zzN- $ !!z zR- $!1!1zzU- $1!D!Dz1zW- $D!X!XzDzY- $X!k!kzXzZ- $k!~!~zkz&- --&&&0CqW&--&&- $0C:C:W0W- $:CECEW:W - $ECOCOWEW- $OCZCZWOW- $ZCdCdWZW- $dCoCoWdW- $oCyCyWoW- $yCCWyW"- $CCWW&- $CCWW*- $CCWW.- $CCWW2- $CCWW6- $CCWW:- $CCWW>- $CCWW@- $CCWW@- $CCWW @- $CCWW@- $CCWW@- $C%C%WW@- $%C4C4W%W@- $4CDCDW4W@- $DCTCTWDW"@- $TCcCcWTW&@- $cCsCsWcW)@- $sCCWsW-@- $CCWW2@- $CCWW6@- $CCWW9@- $CCWW=@- $CCWWB@- $CCWWH@- $CCWWM@- $CCWWR@- $CCWWW@- $CCWW\@- $C!C!WWa@- $!C.C.W!We@- $.C;C;W.Wj@- $;CHCHW;Wo@- $HCVCVWHWu@- $VCcCcWVWz@- $cCpCpWcW~@- $pC}C}WpW@- $}CCW}W@- $CCWW@- $CCWW;- $CCWW5- $CCWW1- $CCWW -- $CCWW')- $CCWW/%- $CCWW6!- $CCWW=- $CCWWD- $CCWWK- $CCWWS- $CCWWZ - $CCWWa - $CCWWh- $CCWWo- $CCWWv- $C&C&WW~- $&C.C.W&W- $.C6C6W.W- $6C;C;W6W- $;C@C@W;W- $@CECEW@W- $ECJCJWEW- $JCOCOWJW- $OCUCUWOW- $UCZCZWUW- $ZC_C_WZW- $_CdCdW_W- $dCiCiWdW- $iCoCoWiW- $oCqCqWoW&&&- &,$9C6D3F1I0L0L1P3R6T9UgUjTmRnPoLoLnImFjDgC&&-&& &&-&&,$9C6D3F1I0L0L1P3R6T9UgUjTmRnPoLoLnImFjDgC&&- $0C:C:W0W- $:CECEW:W - $ECOCOWEW- $OCZCZWOW- $ZCdCdWZW- $dCoCoWdW- $oCyCyWoW- $yCCWyW"- $CCWW&- $CCWW*- $CCWW.- $CCWW2- $CCWW6- $CCWW:- $CCWW>- $CCWW@- $CCWW@- $CCWW @- $CCWW@- $CCWW@- $C%C%WW@- $%C4C4W%W@- $4CDCDW4W@- $DCTCTWDW"@- $TCcCcWTW&@- $cCsCsWcW)@- $sCCWsW-@- $CCWW2@- $CCWW6@- $CCWW9@- $CCWW=@- $CCWWB@- $CCWWH@- $CCWWM@- $CCWWR@- $CCWWW@- $CCWW\@- $C!C!WWa@- $!C.C.W!We@- $.C;C;W.Wj@- $;CHCHW;Wo@- $HCVCVWHWu@- $VCcCcWVWz@- $cCpCpWcW~@- $pC}C}WpW@- $}CCW}W@- $CCWW@- $CCWW;- $CCWW5- $CCWW1- $CCWW -- $CCWW')- $CCWW/%- $CCWW6!- $CCWW=- $CCWWD- $CCWWK- $CCWWS- $CCWWZ - $CCWWa - $CCWWh- $CCWWo- $CCWWv- $C&C&WW~- $&C.C.W&W- $.C6C6W.W- $6C;C;W6W- $;C@C@W;W- $@CECEW@W- $ECJCJWEW- $JCOCOWJW- $OCUCUWOW- $UCZCZWUW- $ZC_C_WZW- $_CdCdW_W- $dCiCiWdW- $iCoCoWiW- $oCqCqWoW&- --&&&--yH--s Cwwgws C - Times New Romanwgw; d - f.2 Cursor Sharing'.--A1-- fTimes New Romanwgws D - .2 g Bug: 2138662 .--"Systemw$f  -&TNPP &՜.+,D՜.+,t    $ On-screen ShowGo-Faster Consultancy Ltd.y=1  Times New RomanArial Fireball.potCursor SharingABug 2138662: cursor_sharing=force causes ORA-7445 and core dumpsWhat is Cursor Sharing?What goes wrong? WorkaroundsSummaryNo Slide Title  Fonts UsedDesign Template Slide TitlesT(RZ _PID_GUID _PID_HLINKSAN{19222E0C-F767-4A8C-B01C-0AE8AC64E83E}A257,2,Custom Topic A258,3,Custom Topic B259,4,Vital Statistics260,5,Favorite Links to Visit#_U= David Kurtz  !"#$%&'()*+,-./0123456789:;<=>?@ACDEFGHIKLMNOPQTRoot EntrydO)Current UserJSummaryInformation(EPowerPoint Document(y=DocumentSummaryInformation8B