Oracle-L: RE: Sequence number generation

From: Abdul Aleem <dmit_at_beaconhouse.edu.pk>
Date: Fri, 19 Jul 2002 05:28:22 -0800
Message-ID: <F001.0049C7D6.20020719052822@fatcity.com>

In such scenario we have different counter table for each counter

Aleem

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

Sent:	Thursday, July 18, 2002 6:55 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Re: Sequence number generation

so, what do you do, when you need to lock "counter table" and it's already locked by another process?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, July 18, 2002 3:38 AM

>
> 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"
>
>
>
>

> This communication contains information, which is confidential and may
also
> be privileged. It is for the exclusive use of the intended recipient(s).
If
> you are not the intended recipient(s), please note that any distribution,
> printing, copying or use of this communication or the information in it is
> strictly prohibited. If you have received this communication in error,
> please notify the sender immediately and then destroy any copies of it.
>

> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ayyappan S
> INET: ayyappan.subramaniyan_at_ssiworldwide.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ratnesh Kumar Singh
> INET: ratnesh.singh_at_patni.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Abdul Aleem
> INET: dmit_at_beaconhouse.edu.pk
>
> 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).

-- 
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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Abdul Aleem
  INET: dmit_at_beaconhouse.edu.pk

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 Fri Jul 19 2002 - 08:28:22 CDT