Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
While creating a sequence, what does cache and nocache options mean?
October 26, 2010
While creating a sequence, what does cache and nocache options mean in oracle?
Posted Date: October 26, 2010 Points: 5
With respect to a sequence, the cache option specifies how many sequence values will be stored in memory for faster access.
The downside of creating a sequence with a cache is that if a system failure occurs, all cached sequence values that have not be used, will be "lost". This results in a "gap" in the assigned sequence values. When the system comes back up, Oracle will cache new numbers from where it left off in the sequence, ignoring the so called "lost" sequence values.
Note: To recover the lost sequence values, you can always execute an ALTER SEQUENCE command to reset the counter to the correct value.
Nocache means that none of the sequence values are stored in memory. This option may sacrifice some performance, however, you should not encounter a gap in the assigned sequence values.
Hope this helps.
Thanks & Regards,
To post reply
Related Questions Related Questions
Creating modal poup using javasccript
creating Custom row in Gridview
What are the Concepts required in creating a Login Form
Creating Forum System in asp.net 2.0
Clearing/Editing Internet explorer DNS cache
T-SQL - Creating a Local User On Windows OS
Creating Tree view
About Creating forum
cache and session
I have problem regarding creating connection to database
Latest Forum Questions From The Same Category
Xamarin for Visual Studio 2010/2012 ?
How to attach Google Plus authentication system in Windows 8.1 phone using c#
Installing Visual Studio 2012 on Windows 7
Can anyone suggests me a laptop on which I can install any OS ?
Software freelancers who work from home, need a license?
help me problem instal graphique card on i5 intel fujitsu e752 hd4000
Extracting data from different websites to excelsheet
Please let me know the cost/exam fee associated with the Microsoft ASP.Net certification
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend