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 >-- >Author: Daiminger, Helmut > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj 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).
