Re: Incredible ! Oracle HELP PLEASE !

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 - 03:38:12 CDT