Re: Re: Sequence Number Re-use is it possible, what is the standard

For unbroken auditing of sequences, I have outlined in my book a mechanism for using triggers and autonomous transactions to log the acquisition of a sequence number, with a normal trigger to clear the log on success. This means your base table holds the used values, and your log table holds the 'lost' values. But - following on Anjo's comment - the scope for contention and serialisation is huge.

(NB this is an 8.1 technique only).

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



u28656005_at_spawnkill.ip-mobilphone.net wrote in message ...


>Thanks for the response.

>

>We are already using NOCache. I think we are just wondering if anyone has

 put


>the unused numbers into another table so the front-end can get it from

 there or


>the sequence number to not have big gaps.

>

>I also added functionality on the front-end to show a screen to ask them to

>save, if they haven't already, so it won't skip as much. I know that will

 help


>tremendously.

>

>However, when we get to some of our more complex systems, like our

 purcahsing


>system, it might need a more elegant solution.

>

>Thank you everyone who has replied so far.

>

>Mark

>

>

>

>

>

>

>

>

>--

>Spam protected message from:

>Sent  by mspritzler  from sasco within field com

>Posted via http://www.usenet-replayer.com/cgi/content/new