[seasar-dotnet:2139] S2Dao.NetでORA-01002が稀に発生する現象について

[K.Ohmori]

$BBg?9$H?=$7$^$9!#(B

$[E-MAIL ADDRESS DELETED]$[$I%?%$%H%k$r8m$C$FEj9F$7$F$$$^$9!#(B
$BBgJQ<:Ni$7$^$7$?!#(B

$B8=:_=>;v$7$F$$$k%W%m%8%'%/%H$G2TF/Cf$N%7%9%F%`$N(B
$B99?7=hM}(B(Quill$B$G$N%H%i%s%6%/%7%g%s=hM}(B)$B$K$F2<5-$N8=>]$,H/@8$7$F$$$^$7$F!"(B
$B$J$+$J$+<}B+$G$-$:6l$7$s$G$*$j$^$9!#(B

$B$I$3$,$^$:$$$N$+;XE&E@$,$"$l$P65$($F$$$?$@$1$J$$$G$7$g$&$+!#(B
$B$b$7$/$OF1MM$"$k$$$ON`;w$7$?8=>]$N2r7h;vNc$r$*;}$A$NJ}$,(B
$B$$$i$C$7$c$$$^$7$?$i!"$I$&$+$465<x$/$@$5$$!#(B


$B!Z;v>]![(B
$B!{(BVB.net$B$N2hLL$+$i$N99?7=hM}$r<B9T$9$k:]$N(B
  $B%H%i%s%6%/%7%g%s=hM}It$K$F!"BP>]%G!<%?$N%m%C%/$r(B
  $B9T$C$F$$$k$,!"%m%C%/$K<:GT$7$F(B
  $B!V(BORA-01002$B!'%U%'%C%A=g=x$,L58z$G$9!#!W$,H/@8$9$k(B
$B!{0l4S$7$?:F8=@-$,$J$/!"5)$K$7$+H/@8$7$J$$(B
$B!{2hLL$rJD$8$:$KEPO?$r7+$jJV$7$F$$$k;~$KH/@8$7$F$$$kLOMM(B
$B!{(B1$B2sL\$N99?7<B9T;~$K$O$^$:H/@8$7$J$$(B
  $B"M8=>]H/@8;~$K2hLL$rJD$8$F(B(DB$[E-MAIL ADDRESS DELETED]$7$F$$$k(B)$B!"5/F0$7D>$7$F(B
    $BEPO?$r<B9T$9$k$[E-MAIL ADDRESS DELETED]>o99?7$G$-$k(B
$B!{(B1$BEYH/@8$9$k$H!"F~NOFbMF$rJ];}$7$F99?7=hM}$r:F<B9T$7$F$b(B
  $B:FEY<:GT$9$k$3$H$,$"$k!#<:GT$r7+$jJV$9;~$O(B10$BJ,0J>eB3$/$3$H$b$"$k!#(B


$B!Z%7%9%F%`4D6-![(B
$B!{%5!<%P!<(BOS$B!'(BWindows2008 R2 (64Bit)
  $B"M(BVM Ware ESX Server$B>e$G2TF0$9$k2>A[(BOS$B$G$9(B
  $B"M(BVM$B$O(B3$B$D$"$j!"%5!<%P(BA$B$K6&MQ(BDB$B$r>e0L$K0LCV$5$;!"(B
    $B$=$N2<0L$K%5!<%P(BB$B$H(BC($B;v6H=jJL$N(BDB)$B$,F10L$G0LCV$7$^$9!#(B
$B!{(BDB$B!'(BOracle 11g R2 11.2.0.1.0(64Bit)
  $B"M(BVM3$B5!(BA$B!"(BB$B!"(BC$B$=$l$>$l$,(BDB$B%5!<%P$G$"$j!"%5!<%P4V$NO"7H$O(B
    $B%^%9%?!'%^%F%j%"%i%$%:%I%S%e!<$G(BDB$BF14|(B
    $B%H%i%s!'%F%-%9%HO"7H(B(SQL loader$B$G<h9~(B)
$B!{%/%i%$%"%s%H(BOS$B!'(BWindows 7
  $B"M(BF$B<R$N%G%9%/%H%C%W5!$G$9(B
  $B"M%5!<%P(BA$B!"(BB$B!"(BC$B$NJ*M}c~BN$,$"$k5rE@$H!"%/%i%$%"%s%H$N5rE@$O(B
    NTT$B$N(BVPN$B%o%$%I$K$F(BWAN$B@\B3$5$l$F$$$^$9(B
$B!{3+H/[E-MAIL ADDRESS DELETED]!'(BVB.NET (Framework 3.5)
$B!{3+H/4D6-!'(BVisual Studio 2008
$B!{(BS2Container.net$B!'(B1.4.0 RC2
$B!{(BODP.NET $B%5!<%P!<B&(B64bit 11.2.0.0$B!"%/%i%$%"%s%HB&(B32bit 11.2.0.2


$B!ZJdB-![(B
$B!{%H%i%s%6%/%7%g%s=hM}$G$N99?7BP>]%F!<%V%k$,J#?t$"$k(B
$B!{%H%i%s%6%/%7%g%s=hM}$NKAF,!"(BUPDATE$B$d(BINSERT$BH/9TA0$K%m%C%/$7$F$$$k(B
$B!{%m%C%/$O(BSELECT $B!A(B FOR UPDATE NO WAIT$B$GH/9T(B
$B!{%H%i%s%6%/%7%g%s=hM}$r<BAu$7$F$$$k%5!<%S%9<BAu%/%i%9$N%a%=%C%I$K$O!V(B<Transaction()> _$B!W$r;XDj(B
$B"M(BVM$B$N(BDB$B$,J,$+$l$F$$$^$9$N$G3F(BDB$BMQ$K(BTransactionSetting$B3HD%$7$F$$$^$9!#(B
$B!{%5!<%S%9<BAu%/%i%9$N%a%=%C%I$K$O!V(BPublic Overridable Function$B!W$r;XDj(B
$B!{%H%i%s%6%/%7%g%s=hM}$r<BAu$7$F$$$k%a%=%C%IFb$G!"(BDAO$B$KDj5A$7$?(B
   $B%a%=%C%I(B($B"((B)$B$r8F$S=P$7$F$$$k(B
   $B"(!V(B<Procedure("hogehoge")> _$B!W$r;XDj$7(BPL/SQL$B%Q%C%1!<%8(B($B%9%H%"!<%I!&(B
      $B%W%m%7!<%8%c(B)$B$r%3!<%k$7$F$$$k(B
$B!{(BPL/SQL$BFb$O%H%i%s%6%/%7%g%s=hM}$[E-MAIL ADDRESS DELETED]@$7$F$$$J$$(B
$B!{(BCURSOR$B8!:wCf$K%3%_%C%H$O9T$C$F$$$^$;$s(B
$B!{@\B3%W!<%k4XO"$N;XDj$O$9$Y$FL$;XDj!a4{DjCM!#(B
  (Connection Pool$B$d(BMAX Pool Size$B!"(BLifeTime$B$J$I(B)
$B!{EPO?<B9T;~$N%a%=%C%I$NN.$l$O2<5-$NDL$j(B
   $B-!(Bform$B$N(BF10$B%-!<$K3dEv$7$?EPO?%\%?%s$r2!2<(B
   $B-"(Bform$B$N%\%?%s(BClick$B%$%Y%s%H%W%m%7!<%8%c8F=P(B
   $B-#-"Fb$G99?7=hM}(B(form$B%a%=%C%I(B)$B$r8F=P(B
   $B-$%5!<%S%9%$%s%?%U%'!<%9$N99?7=hM}(B($B!V(B<Implementation()> _$B!W;XDj(B)$B$N%a%=%C%I8F=P(B
      $B"M<BBN$O%5!<%S%9<BAu%/%i%9$N99?7=hM}(B($B!V(B<Transaction()> _$B!W;XDj(B)$B$N%a%=%C%I(B
   $B-%-$$N%a%=%C%IFb$NKAF,$G!"99?7=hM}A0$K%m%C%/$7$F$$$k(B
   $B-&%H%i%s#1!A#3$N99?7(B
   $B-'%H%i%s#4$N99?7(B
   $B-(-%$G%m%C%/$7$F$$$k%H%i%s#5$N99?7(B
$B!{%"%W%j%1!<%7%g%s%m%0$rE:IU$7$^$9(B
$B![E-MAIL ADDRESS DELETED]>o7O![(Bhoge_seijou.log
   1)3$B9TL\!'%H%i%s%6%/%7%g%s=hM}3+;O(B
   2)6~17$B9TL\!'99?7BP>]%G!<%?$r%m%C%/(B
   3)18$B!A(B24$B9TL\!'%H%i%s#1$r(BINSERT
   4)25$B!A(B31$B9TL\!'%H%i%s#2$r(BINSERT
   5)32$B!A(B39$B9TL\!'%H%i%s#3$r(BINSERT
   6)40$B!A(B56$B9TL\!'%G!<%?Cj=P(B
   7)58$B9TL\!'(BPL/SQL$B8F=P(B($B%H%i%s#4$r99?7"M%H%j%,O"F0"MJL%F!<%V%k%G!<%?$r99?7(B)
   8)78$B9TL\!'(BPL/SQL$B8F=P(B($B%H%i%s#5$r99?7(B)
   9)79$B!&(B80$B9TL\!'99?7(B($B%3%_%C%H(B)$[E-MAIL ADDRESS DELETED]>o40N;(B
$B!Z0[>o7O![(Bhoge_ijou.log
   1)3$B9TL\!'%H%i%s%6%/%7%g%s=hM}3+;O(B
   2)6~17$B9TL\!'99?7BP>]%G!<%?$r%m%C%/(B
   3)20$B9TL\!'!V(BORA-01002: $B%U%'%C%A=g=x$,L58z$G$9!W$,H/@8(B

$B0J>e$h$m$7$/$*4j$$$$$?$7$^$9!#(B
-------------- next part --------------
A non-text attachment was scrubbed...
Name: hoge_seijou.log
Type: application/octet-stream
Size: 6076 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-dotnet/attachments/20120402/5913dd66/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: hoge_ijou.log
Type: application/octet-stream
Size: 3589 bytes
Desc: $BL5$7(B
URL: <http://ml.seasar.org/archives/seasar-dotnet/attachments/20120402/5913dd66/attachment-0001.obj>