Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

Re: global sequence as unique identifier across multiple databases

Jared Still

2007-07-31

Replies:

On 7/18/07, Clarke, Andrew <andrew.clarke@logicacmg.com> wrote:
Oracle FAQs has a list of all the various options, with a bonus "sheesh!" style comment from Noons ;)
 


Re Noon's comment:

Anyone here ever do the math to determine how long it will take
to max out a sequence?

( see item #4 in the article)

Assume:

* 1000 sites
* 1000 transactions per second at at least 1 site

With a maximum value of 9,999,999,999,999,999,999,999,999,999 for a single sequence,
how long will it take a site consuming 1000 sequences per second to exhaust the sequence?

Or at 1,000,000 sequnces per second?


--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.