Re: Snapshot too old

From: Dennis Williams <oracledba.williams_at_gmail.com>
Date: Tue, 17 Oct 2006 13:59:45 -0500
Message-ID: <de807caa0610171159ld102464x6904d8ff2bc16235@mail.gmail.com>

Dean,

The ORA-01555 error has some subtle aspects that you should understand. The starting point is that your process is usually not the cause of the ORA-01555, but the victim of other processes' behavior. But Tom explains it far better . . .

http://asktom.oracle.com/pls/ask/f?p=4950:8:8972408939897688325::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1441804355350

Dennis Williams

On 10/15/06, Dean Paul <oracledbam_at_hotmail.com> wrote:
>
> Hi,
> I've been noticing "ORA-01555 caused by SQL statement below (Query
> Duration=33219 sec, SCN: 0x0000.5c80a509): "
>
> i changed undo_retention 16000 and undo tablespace is having enough space.
> Any suggestions are welcome.
> The table which we are running is having 39 millions of records.
> Thx
>
> _________________________________________________________________
> Add fun gadgets and colorful themes to express yourself on Windows Live
> Spaces
>
> http://clk.atdmt.com/MSN/go/msnnkwsp0070000001msn/direct/01/?href=http://www.get.live.com/spaces/features
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 17 2006 - 13:59:45 CDT