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...
>
>
Received on Thu Jun 27 2002 - 05:55:01 CDT
