Home » SQL & PL/SQL » SQL & PL/SQL » Cache vs Nocache of Sequences (Oracle 10g)
Cache vs Nocache of Sequences [message #383530] Thu, 29 January 2009 01:35 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi all,
Need one clarification regarding Sequences whether there is a diffence in using cache and nocache,if means pls explain on this

my question
1.Using Sequence can performance issue occurs
2.Whether it occurs on giving Cache in sequence

Re: Cache vs Nocache of Sequences [message #383531 is a reply to message #383530] Thu, 29 January 2009 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you just have a quick look at the documentation before posting this question.
Don't you it does not mention the difference between cache and nocache?
Do you think you are here to read the documentation for you?
Or do you want us to copy and paste it?
What do you think is the purpose of "search" field both here and in Oracle documentation (without speaking about Google)?

Re: Cache vs Nocache of Sequences [message #383535 is a reply to message #383531] Thu, 29 January 2009 01:53 Go to previous message
Messages: 7062
Registered: December 2001
Senior Member
NOCACHE does have an impact on performance. Oracle has created the cache 'keyword' with performance in mind. When you have set the cache, Oracle would simply have to take the values from memory. That's a lot faster than having to look up the values.

Michel has pointed you to the documentation for more reading on sequences. This thread on asktom might be useful too: link

Previous Topic: Test Data printing (merged)
Next Topic: I need help in this query (merged)
Goto Forum:

Current Time: Mon Jul 24 02:17:25 CDT 2017

Total time taken to generate the page: 0.04164 seconds