Re: Strange problem with Sequence.. please help..

<xtanto_at_hotmail.com> wrote in message
news:1153536811.652095.242590_at_75g2000cwc.googlegroups.com...
> Hi All,
>
> Thanks for all your answer... Now I realized I cannot use sequence to
> get _continuous_numbers.
>
> So what is the best approach to get the _continuous_numbers without any
> chance to have a gap ?
>
> Thank you very much,
> xtanto
>
>
>
> Charles Hooper wrote:
> > Brian Peasland wrote:
> > > > If you restart the Oracle instance/database
> > > > the cached numbers will be lost.
> > >
> > > Additionally, the sequence number are cached in the Dictionary Cache.
> > > Depending on activity and the configuration of your server, it is
> > > possible for the
> > > sequence information to get aged out of the cache. So you can lose
> > > sequence numbers without a restart of the instance.
> > >
> > > HTH,
> > > Brian
> >
> > Brian,
> >
> > Thanks for the additional information regarding sequence numbers
> > potentially aging out of the dictionary cache. I have never noticed
> > this happening, but my sequences see a lot of activity.
> >
> > For any one interested, the Oracle Database Performance Tuning Guide
> > for 10g offers the following information regarding sequences
> > (paraphrased of course):
> >
> > The dictionary cache includes usernames, segment information, profile
> > data, tablespace information, sequence numbers, and descriptive
> > information about schema objects.
> >
> > Allocating sufficient cache space for frequently updated sequence
> > numbers significantly reduces the frequency of dictionary cache locks.
> > Use the CACHE keyword on the CREATE SEQUENCE or ALTER SEQUENCE
> > statement to configure the cached number for each sequence.
> >
> > Charles Hooper
> > PC Support Specialist
> > K&M Machine-Fabricating, Inc.
>

What is the business requirement? Why do you have to have an unbroken set of numbers? I think if you really look at the business requirement you don't need it.
Jim Received on Sat Jul 22 2006 - 10:35:13 CDT