Q:
What does cache and no cache options mean while creating a sequence?
Answer
The CACHE option means how many sequences will be stored in memory for access by the application objects. The performance is faster. However in case of the database is down the data is memory is lost for the sequence.
The NO CACHE option means values are not stored in memory. So there might be some performance issue.
View answer
Workspace
Report Error
Discuss