title: Oracle sequence - skipped numbers
body: <pre><code>CREATE SEQUENCE F_SQ  
  START WITH 1  
  MAXVALUE 999999999999999999999999999  
  MINVALUE 1  
  NOCYCLE  
  CACHE 20  
  NOORDER;  
  </code></pre>
  
  <p>I have a sequence created using the above script. Our nightly jobs use these sequences, so on the first day it used 1,2,3,4,5 and the next day it started with 21,22,23 .. and so on</p>
  
  <p>I can understand it is happening because of the CACHE parameter.</p>
  
  <p>Now the questions is</p>
  
  <p>For three days it been skipping some numbers in between .</p>
  
  <p>Will the sequence ever decide to use these skipped numbers?(from above example 6 to 20) , if so on what circumstance and is there a way to avoid it ?</p>