sequence number was skipped
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: sequence number was skipped

  1. #1
    Join Date
    Sep 2002
    Posts
    411

    sequence number was skipped

    some of the user complained that the sequence number that was generated from the application was skipped somehow.

    Does anyone know why it skipped ??? There was nothing in the log file. the cause and solutions for this problems???

    below is the dll of my sequence.

    CREATE SEQUENCE blaw
    INCREMENT BY 1
    START WITH 1000000
    MINVALUE 1
    MAXVALUE 999999999999999999999999999
    NOCYCLE
    NOORDER
    CACHE 20
    /


    thanks
    Last edited by mike2000; 05-05-2003 at 10:22 AM.

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    You can't rely on there being no gaps. Some system crashes will loose the values in cache. Picking up some NEXVAL's and then Rolling Back the transaction will make a gap too. If you want a heated opinion on this, search on "Ask Tom".
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  4. #4
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    Hi,

    It is possible that individual sequence numbers will appear to be skipped, because they were generated and used in a transaction that ultimately rolled back.

    User may not realize that other users are drawing from the same sequence.

    Seelan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width