From: "Jonathan Lewis" Newsgroups: comp.databases.oracle.server Subject: Re: Re: Sequence Number Re-use is it possible, what is the standard Date: Sat, 3 Mar 2001 18:00:04 -0000 Message-ID: <983642932.13770.0.nnrp-08.9e984b29@news.demon.co.uk> References: <57fq9tkfvmsqnsja55sd70o6blbq2dt33d@4ax.com> <97l2qo$mbm$1@s1.read.news.oleane.net> <3A9E4470.1C8F8114@chello.nl> NNTP-Posting-Host: jlcomp.demon.co.uk X-NNTP-Posting-Host: jlcomp.demon.co.uk:158.152.75.41 X-Trace: news.demon.co.uk 983642932 nnrp-08:13770 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-Complaints-To: abuse@demon.net X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Lines: 58 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@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