Re: Snapshot too old

  • From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • To: oracledbam@xxxxxxxxxxx
  • Date: Tue, 17 Oct 2006 13:59:45 -0500

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@xxxxxxxxxxx> 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

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



Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2006