Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Incredible ! Oracle HELP PLEASE !

Re: Incredible ! Oracle HELP PLEASE !

From: Christian GILBERT <externe.gilbert_at_francetelecom.com>
Date: Thu, 27 Jun 2002 08:38:12 GMT
Message-ID: <1103_1025167092@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 :

Hope this helps... Received on Thu Jun 27 2002 - 03:38:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US