Millions of sequence in a database to record the counter for mill ions of products?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 19 Jul 2002 12:47:16 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70264B551@lnewton.leeds.lfs.co.uk>

Hi Niall,

yep, been there, saw the movie, ate the pie (That must have been Watership Down then !)

Rollbacks : the sequence is not rolled back. (The original autonomous transaction.)
Concurrent sessions : If I remember correctly, in 734, having more than one session actually loses numbers, but I did try it under 8174 (no pinning) and got sequential numbers - so maybe it's 'fixed' in 8174.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----

From: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk] Posted At: Friday, July 19, 2002 12:32 PM Posted To: server
Conversation: Millions of sequence in a database to record the counter for millions of products?
Subject: Re: Millions of sequence in a database to record the counter for millions of products?

put a few rollbacks into your test and more than one concurrent session and
see what happens.

--

Niall Litchfield
Oracle DBA
Audit Commission UK Received on Fri Jul 19 2002 - 06:47:16 CDT