Do sequence fields go crazy during a failure in high-availability?

From: <tmccready_at_my-dejanews.com>
Date: Tue, 08 Sep 1998 19:55:29 GMT
Message-ID: <6t423h$as0$1@nnrp1.dejanews.com>

Oracle DBA's:

Is it true, on an Unix computer configured for high availability, that the numbers in a field, declared as sequence, become garbled?

In other words, when one cpu takes over as another cpu fails, the numbers in a sequence field can have duplicates, because the sequence numbers in the first cpu were in memory, and not committed to disk?

I have heard that some designers had to re-write their applications to avoid the above scenerio. That is what I want to avoid.

Thank you for your time.

Tom McCready

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 08 1998 - 14:55:29 CDT