Sequence Number Loss

Hi, Everyone,

 I have a problem with Oracle Sequence number:  

 Enviroment: Oracle 8 in Sun E3000 server with Solaries2.6.  Problem: When Oracle is shutdown ( "shutdowm immediate")

         for a cold backup, Oracle sequences seem lose some
         number( advace some number), sometimes OK, and 
         other times very bad. Our users are not happy about some
         numeric sequence numbers( like account#) because they are
         not consecutive.
 Suggestions sought: we want to use Sequence as our primary key 
         source because they are guranteed to be unique and
         have good perfomance, but we also want the number to
         be consecutive( at least most of the time). Any suggestions
         and advices are highly appreciated.

  from: Sean Zhang
  <zhang_at_visi.net> Received on Thu Jan 07 1999 - 20:18:43 CST