| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Sequence number generation
I really don't see where this method scores over a sequence number. But I
can see a number of places where it loses out.
What happens when you select from the table and then don't commit the
transaction that selected it? You'll still have a gap in your sequence.
It's the same as a sequence but with a larger overhead, slower performance
and Igor mentioned the possibility of locks on the table stopping the update
processes altogether.
Just (as they say) my deux euros
Mike
>
> To have a better control, we always use tables for holding counters.
> Depending upon the requirement, either one table to hold different
counters
> or multiple tables, sometime in master tables as well.
>
> This does not any additional coding, the trigger in which you fetch from
> sequence you select from table. To keep it synchronized with the
> transaction, we make counter table block
>
> HTH!
>
> Aleem
> -----Original Message-----
> Sent: Thursday, July 18, 2002 11:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Sequence number generation
>
> It is not possible to avoid sequence number loss .
> If a user requests a sequence number, then ultimately rolls back that
> transaction,
> that sequence number is lost .
>
> However you can catch such lost sequence numbers programatically and reuse
> then.
> that would require a bit of extra coding.
>
> -----Original Message-----
> Sent: Thursday, July 18, 2002 10:43 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi
> Is it possible to avoid sequence number loss in the sequence number
> generation. if so how?
>
> Thanks in Advance
>
> Ayyappan.S
>
> "Dreams translate into thoughts, and
> thoughts translate into action: Kalam"
>
>
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: ineyman_at_perceptron.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ____________________________________________________________________________ ________________________ This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: Mike.Hately_at_churchill.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Jul 18 2002 - 10:28:25 CDT
 |
 |