Home » SQL & PL/SQL » SQL & PL/SQL » Sequence max value vs database performance (10.2.0.3, windows)
Sequence max value vs database performance [message #571924] Tue, 04 December 2012 07:22 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

I m little bit confuse about the MAX VALUE of SEQUENCE. By default it takes max values as 99999999999999999.
Will it really effect our database ?

Thanks
Regards,
Ishika
Re: Sequence max value vs database performance [message #571925 is a reply to message #571924] Tue, 04 December 2012 07:24 Go to previous messageGo to next message
cookiemonster
Messages: 11068
Registered: September 2008
Location: Rainy Manchester
Senior Member
What effect would you expect it to have, other than the obvious one of stopping the sequence exceeding that value?
Re: Sequence max value vs database performance [message #571926 is a reply to message #571925] Tue, 04 December 2012 07:41 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
will it consuming spaces? should we allocate it to some provided value in MAX VALUE?

Regards,
Ishika
Re: Sequence max value vs database performance [message #571929 is a reply to message #571926] Tue, 04 December 2012 08:15 Go to previous message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It does not consume any space.
Oracle does not, of course, store all the values that a sequence can generate.

Regards
Michel
Previous Topic: Help with writing a query to multiply columns
Next Topic: execution plan
Goto Forum:
  


Current Time: Mon Oct 20 17:17:58 CDT 2014

Total time taken to generate the page: 0.09693 seconds