topic ObjectID sequence in an enterprise geodatabase (Oracle) in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/objectid-sequence-in-an-enterprise-geodatabase/m-p/724925#M163 <HTML><HEAD></HEAD><BODY><P>In an enterprise geodatabase (Oracle), why is the sequence for the ObjectID incremented by 16?</P></BODY></HTML> Tue, 29 Mar 2016 13:40:29 GMT KyleDixon1 2016-03-29T13:40:29Z ObjectID sequence in an enterprise geodatabase (Oracle) https://community.esri.com/t5/geodatabase-questions/objectid-sequence-in-an-enterprise-geodatabase/m-p/724925#M163 <HTML><HEAD></HEAD><BODY><P>In an enterprise geodatabase (Oracle), why is the sequence for the ObjectID incremented by 16?</P></BODY></HTML> Tue, 29 Mar 2016 13:40:29 GMT https://community.esri.com/t5/geodatabase-questions/objectid-sequence-in-an-enterprise-geodatabase/m-p/724925#M163 KyleDixon1 2016-03-29T13:40:29Z Re: ObjectID sequence in an enterprise geodatabase (Oracle) https://community.esri.com/t5/geodatabase-questions/objectid-sequence-in-an-enterprise-geodatabase/m-p/724926#M164 <HTML><HEAD></HEAD><BODY><P>Because sequences are so pitifully slow.. Instead of paying the sequence cost with each insert, ArcGIS grabs one sequence value and allocates all the values in that range itself.&nbsp; If any values are left over, they are stuffed in a DBMS_PIPE for later reuse. Note that some sequences are set to 200 or even 400.&nbsp; If you restart the database, the pipe contents are lost, which could result in gaps.&nbsp; The Knowledge Base has documents which discuss both <A href="http://support.esri.com/es/knowledgebase/techarticles/detail/31437">changing the interval </A>and <A href="http://support.esri.com/fr/knowledgebase/techarticles/detail/28835">preserving cached ids</A>.</P><P></P><P>- V</P></BODY></HTML> Tue, 29 Mar 2016 14:08:22 GMT https://community.esri.com/t5/geodatabase-questions/objectid-sequence-in-an-enterprise-geodatabase/m-p/724926#M164 VinceAngelo 2016-03-29T14:08:22Z