Arcgis 10.2 objectid returning non sequential values

[davidzornosa]

Hello

i am making a sql insert in a geotable. I'm getting the objectid via:

    sde.gdb_util.next_rowid('my_user', 'my_table')

However, i've noticed that numbers given are not always in sequence. For instance, if i run the script 6 times, i get:

    run|oid
    ---|------
      1| 1601
      2| 1602
      3| 1603
      4| 1917
      5| 1918
      6| 1604
      
Is this normal? I know that for ids the only important thing is uniqueness, and sequentiality is optional, but i'm intrigued.

Thanks

[Asrujit_SenGupta]

Take a look at the below links for an explanation:

ObjectID of an ArcSDE feature class skipping values 

ObjectID of an SDE feature class skipping values 

https://community.esri.com/groups/geodatabase?sr=search&searchId=879773e9-ca84-434f-af89-9edf3c776de...‌