Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Setting Dirty Reads or No Lock for SELECT

Re: Setting Dirty Reads or No Lock for SELECT

From: broom <broom_at_voicenet.com>
Date: 30 May 2001 19:36:14 -0700
Message-ID: <c948eb61.0105301836.270a0096@posting.google.com> 






While the others state you don't "need" to specify 


"dirty", they must not have ever gotten the message

"snapshot too old" and had a select abort because

of it.



If you are doing very large reads against an updating
table, make sure your RBS allocation can hold the whole
thing.  If you find a way to do dirty reads, let me know.
Received on Wed May 30 2001 - 21:36:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US