Is your particular problem reproducible? Without any changes to the cache size?
Many times simply running the job again works.
- Kirti
- John Kanagaraj <john.kanagaraj_at_hds.com> 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: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
>
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: kirtikumar_deshpande_at_yahoo.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 - 12:09:33 CDT
