Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Incredible ! Oracle HELP PLEASE !
You cannot use sequences and have no gaps.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Oscar" <oscar_ll_at_jofre.com> wrote in message news:afeqnt$1cv$1_at_nsnmrro2-gest.nuria.telefonica-data.net...Received on Thu Jun 27 2002 - 08:46:18 CDT
> what does it means ? How can I used. With NOCACHE still with problems.
>
>
> pin the sequence using DBMS_SHARED_POOL.KEEP
> "Christian GILBERT" <externe.gilbert_at_francetelecom.com> escribió en el
> mensaje news:1103_1025167092_at_10.193.118.17...
> > Sur Wed, 26 Jun 2002 17:47:30 +0200, "Oscar" <oscar_ll_at_jofre.com> a
écrit:
> > > Hi, I have a big problem with Oracle. Can anyone help me, make the
test.
> > [...]
> > > create sequence ID_LGC02 start with 1
> > > ;
> > >
> > > Now Introduce values:
> > >
> > > insert into LGC02 ( ID_LGC02,TIARLG, TITRLG, FECHLG, HORALG, WSIDLG,
> USERLG,
> > > DATA_A)
> > > VALUES (ID_TIGSA_LGC02.nextval, 'O',
> > > 'A', 260602, 165225, 'SERVIDOR ',
> > > 'CGIFS ',
> > > 'VC11020601000011020601
> > >
>
0000000000000000000000000000000000000000000000000000000000000000000000000000
> > > ')
> > >
> > [...]
> > > NOW:
> > >
> > > insert into LGC02 ( ID_LGC02,TIARLG, TITRLG, FECHLG, HORALG, WSIDLG,
> USERLG,
> > > DATA_A)
> > > VALUES (ID_TIGSA_LGC02.nextval, 'O',
> > > 'A', 260602, 165225, 'SERVIDOR ',
> > > 'CGIFS ',
> > > 'VC11020601000011020601
> > >
>
0000000000000000000000000000000000000000000000000000000000000000000000000000
> > > ')
> > >
> > >
> > > is supose to introduce like a next val 5 but NOT it puts 9 !!!!
> > >
> > >
> > > My problem is that I need to have 5 insteas of 9. Can Anyone
> help
> > > me ? Thank's. Oscar
> > >
> > >
> >
> > Looks like your sequence as been aged out of the shared pool...
> > By default Oracle caches a certain number of sequence values (say
5...),
> in order not to loose
> > time allocating number after number...
> > If it the cached values age out, you get a hole in the number generated,
> as you experienced...
> >
> > A few hints :
> >
> > - recreate the sequence with NOCACHE attribute. May include a
overhead...
> > - pin the sequence using DBMS_SHARED_POOL.KEEP
> >
> > Hope this helps...
> >
> >
>
>