Re: global sequence as unique identifier across multiple databases
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: andrew.clarke@xxxxxxxxxxxxx
- Date: Tue, 31 Jul 2007 11:37:28 -0700
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:
