Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Snapshot too old

Snapshot too old

From: Dean Paul <oracledbam_at_hotmail.com>
Date: Sun, 15 Oct 2006 21:02:48 -0400
Message-ID: <BAY117-F5AA3DDE466F6698B3B69CD3090@phx.gbl>


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
Received on Sun Oct 15 2006 - 20:02:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US