Re: complex locking and sequence generation
- From: "vc" <boston103@xxxxxxxxxxx>
- Date: 29 May 2006 19:23:36 -0700
Maxim Demenko wrote:
[...]
Another idea - if only gapless representation of data is required - one
can use inserts in a table with reqular sequences ( with all the
benefits of concurrent processing ) and create a view on this table with
row_number() over (order by sequence_generated_values) analytical
function. That is an easy way to eliminate the gaps.
This would eliminate 'legitimate' gaps (if such can occur at all), so
it's the same as telling the auditors "there are no gaps and even if
there are you won't see them anyway".
There is no way to produce gap free sequences without making your
database one-threaded/serial for the application that requires such
sequences.
.
- References:
- complex locking and sequence generation
- From: steve
- Re: complex locking and sequence generation
- From: Mark D Powell
- Re: complex locking and sequence generation
- From: Maxim Demenko
- complex locking and sequence generation
- Prev by Date: Export and Import
- Next by Date: Re: Oracle 9 NT Authentication "conn / as sysdba" - Role issue ?
- Previous by thread: Re: complex locking and sequence generation
- Next by thread: ERROR - ORA-28000: the account is locked
- Index(es):
Relevant Pages
|
|
