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:HELMUT.DAIMINGER_at_wwk.de]
>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: HELMUT.DAIMINGER_at_wwk.de
>
>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: ListGuru_at_fatcity.com (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: john.kanagaraj_at_hds.com
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: ListGuru_at_fatcity.com (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).
Received on Wed Oct 15 2003 - 11:49:48 CDT
