RE: Snapshot too old error

From: Conboy, Jim <Jim.Conboy_at_trw.com>
Date: Mon, 16 Sep 2002 06:58:31 -0800
Message-ID: <F001.004D08C0.20020916065831@fatcity.com>

If you're running 9i, check that you're not using undo segments with a short undo_retention parameter instead of traditional rollback segments. If you're using undo, I think the default retention is 900 seconds (15 min) and you are open to those pesky snapshot errors after that. Undo is fine, but the retention should be raised.

Jim

-----Original Message-----
Sent: Friday, September 13, 2002 10:43 PM To: Multiple recipients of list ORACLE-L

Hi All,

I am running a pro*c program which has a cursor which fetches data from a table which is constantly being updated by front-end, so I am getting "snapshot too old error". My requirement is not to adhere to the consistency of the data. I am fine if the data that my program is reading is not consistent. How can I ask oracle to not to give me this "snapshot too old" error even when the data is consistent/inconsistent.

Thanks a lot,
Rajesh
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Pillai, Rajesh
INET: Rajesh.Pillai_at_nordstrom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Conboy, Jim
INET: Jim.Conboy_at_trw.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------