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: ORA-01555 on a long select after many small txs from the same connection ?

Re: ORA-01555 on a long select after many small txs from the same connection ?

From: Nick Rumble <rumbln_at_tetraworld.com>
Date: Wed, 7 Jul 1999 10:05:59 +0100
Message-ID: <931338285.3059.0.nnrp-11.c2d9cf02@news.demon.co.uk> 





It seems to me that the design of delayed block cleanout is flawed.



There must be endless situations where rollback segment data becomes
unavailable (either through being overwritten, or may be the rollback
segment being taken offline/dropped) ....



.... and there real rub is that there seems to be no real guarantee that a
DBA can configure the system in such a way as to avoid this problem
altogether.




Received on Wed Jul 07 1999 - 04:05:59 CDT












Original text of this message













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