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: how to handle updates to millions of rows

Re: how to handle updates to millions of rows

From: Anton Dischner <nomail_at_nospam.org>
Date: Wed, 25 Aug 2004 16:48:47 +0200
Message-ID: <250820041648476737%nomail@nospam.org> 





Hi,



how big are you rollback-segs?



I have no problems with tables 100 mio + but i have to use big rb-segs:
several 100 MB up to several GB.



Try to use proper indexes tables (best tuning hint).



Try different optimizer hints:



Try /*+ rule */ or /*+ first rows */



kind regards,



Toni
Received on Wed Aug 25 2004 - 09:48:47 CDT












Original text of this message













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