Re: global sequence as unique identifier across multiple databases

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


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

Other related posts: