Re: -1555-ORA-01555: snapshot too old: rollback segment number 7 with name "_SYSSMU7$" too small

xhoster@xxxxxxxxx wrote:

In fact, I've seen 1555's disappear merely by changing undo_retention in a
situation (unlike this one) where it couldn't easily be rewritten as an
insert into...select and where removing the commit from the loop would have
been rather inconvenient.

Xho

The potential problem with changing undo retention, to cover for
badly designed code, is that increased undo retention is not free.
Howard Rogers, dizwell.com, has written about this too.
--
Puget Sound Oracle Users Group
.

Relevant Pages

  • Re: BULK COLLECT - Can it be implemented for a few rows .
    ... So we designed a NEW PROC using BULK COLLECT. ... CURSOR CUR2IS SELECT DISTINCT ... COMMIT; ... FOR I IN CUR1LOOP ...
    (comp.databases.oracle.tools)
  • Re: Straight SQL always put perform PL/SQL?
    ... end loop; ... CURSOR test_cur IS ... PL/SQL procedure successfully completed. ...
    (comp.databases.oracle.server)
  • Re: Asynchronous Commit in Oracle Database 10g R2
    ... >> end loop; ... > This is soley due to the lack of a two phase commit between these data ... Jonathan Lewis ...
    (comp.databases.oracle.server)
  • Re: [PATCH] x86: Reduce the default HZ value
    ... A simple tight loop experiment showed that with HZ=1000 we took about ... I can see at least one immediate downside: ... also talks about where these HZ based timeouts be used and ... Also the default HZ value was 250 before this commit ...
    (Linux-Kernel)
  • Re: Did Anti-Spyware Vendors Cave In....?
    ... The anti-virus software isn't removing the files. ... but nothing also prevents me from automating that same action ... for someone else to commit actions on my behalf. ... Hopefully the result will be that the EULA is simply a contract over the ...
    (microsoft.public.security)