Re: Alert to trap/anticipate ORA-01555 before its occurence

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Mon, 13 Dec 2004 10:07:26 -0600
Message-ID: <8dfrr01cu1n6fgd0h1ndllo60buhun3bbe@4ax.com>

spendius_at_muchomail.com (Spendius) wrote:

>Hi,
>Has someone perhaps thought of means to prevent this error ?
>What SQL, against which views...
>Wonder if I could add an OEM event related to this error.
>
>Thanks.
>Regards,
>Spendius

The Docs spell out solutions:

---

ORA-01555 snapshot too old: rollback segment number string with name "string" too small

Cause: Rollback records needed by a reader for consistent read are overwritten by other writers.

Action: If in Automatic Undo Management mode, increase the setting of UNDO_RETENTION. Otherwise, use larger rollback segments

---

Obviously, Oracle cannot tell in advance that it is going to encounter this error, so advance planning of the rollback segments is critical to avoiding this error. Received on Mon Dec 13 2004 - 10:07:26 CST