Re: global sequence as unique identifier across multiple databases

On 7/18/07, Clarke, Andrew <andrew.clarke_at_logicacmg.com> 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

--
http://www.freelists.org/webpage/oracle-l