Home » Interview » Technology

What does cache and no cache options mean while creating a sequence?

Correct 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

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion