Is your particular problem reproducible? Without any changes to the cache size?
Many times simply running the job again works. - Kirti --- John Kanagaraj <[EMAIL PROTECTED]> wrote: > Helmut, > > The SELECT article 'Understanding ORA-0155' by Tim Gorman is a must-read. > Get a subscription to IOUG, or ask Tim nicely and he might give a copy of > the article to you... (Probably better to get an IOUG subs - there is a ton > of excellent articles and tech stuff out there) > > John Kanagaraj > DB Soft Inc > Phone: 408-970-7002 (W) > > Disappointment is inevitable, but Discouragement is optional! > > ** The opinions and facts contained in this message are entirely mine and do > not reflect those of my employer or customers ** > >-----Original Message----- > >From: Daiminger, Helmut [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, October 15, 2003 9:25 AM > >To: Multiple recipients of list ORACLE-L > >Subject: Problem with undo tablespace and snapshot too old > > > > > >Hi! > > > >We are experiencing a weird problem here... > > > >We have automatic undo management enabled and the undo > >tablespace is 6 GB in > >size. undo_retention is set to 30 minutes. > > > >when a certain transaction runs, it fails with ORA-1555 > >Snapshot too old, > >although the undo tablespace only uses 700 MB (out of 6 GB possible). > > > >That loos weird to me... > > > >Then our other DBA suggested to cut the size of the buffer > >cache in half and > >let the transaction run again. We have done that and it worked > >flawlessly... > >WHY??? > > > >What is the relation between the buffer cache size und > >rollback (i.e. undo > >retention)? > > > >This is 9.2 on HP-UX. > > > >Thanks, > >Helmut > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.net > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).