Re: Single vs. Multiple Sequences

From: <stephen.odonnell_at_gmail.com>
Date: 9 Sep 2005 05:49:39 -0700
Message-ID: <1126270179.452035.268750@g43g2000cwa.googlegroups.com>

Chris McMahon wrote:
> Are there performance advantages to having a sequence generator per
> table VS a single sequence generator used across all tables? Are there
> locking issues that might be a problem with using a single sequence
> generator?

A single sequence may well cause some locking issues. It was discussed on asktom recently

http://asktom.oracle.com/pls/ask/f?p=4950:8:9636515143644882621::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2985886242221

Cheers,

Stephen. Received on Fri Sep 09 2005 - 07:49:39 CDT