Sequence generation in Oracle RAC env. (Cached, non-ordered)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Sequence generation in Oracle RAC env. (Cached, non-ordered)

  1. #1
    Join Date
    Jul 2003
    Posts
    135

    Question Sequence generation in Oracle RAC env. (Cached, non-ordered)

    Oracle Env. 11G

    How does CACHED, non-ordered sequence behave (for PK generation), here is the scenario,
    Cache size =10
    Node 1 Active - Records created 1,2,3 (3 records total in table)
    Node Changes - 2 is Active - Records created 11,12,13, 14 (7 records total in table)
    Node Changes - 1 is Active - Records created 21, 22 (or are sequences going to be 4, 5) (9 records total in table)
    Node Changes - 2 is Active - No new record added (9 records total in table)
    Node Changes - 1 is Active - Records created - Is it going to be 23, 24 OR or is it going to be 6,7 OR or is it going to be 31, 32 (9 records total in table)

    Also, What happens to PK numbers at:
    * shutdown
    * hotbackup
    * mirroring whole schema or database to another separate db using storage mirroring
    * mirroring whole schema or database to another separate db using datapump

    -D

  2. #2
    Join Date
    Aug 2014
    Posts
    2
    Hi

    When the database is shutdown, all the numers which are in cache got lost and when the database would come up, it would start fron next set of sequence. I do not think, there would be any impact on sequence in other cases

    Harvinder

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