Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: View current seq. no.
Your comment about each session having its own 'current' value (i.e. the most recent value it got using the nextval call) is correct, but your scenario of A and B alternating is not correct:
> If user A and user B use the sequence, first A, then B,
> then A and then B again and so on ... having cache 10
> (as an example) defined, you would have
>
> A:1 B:11 A:2 B:12 A:3
>
The sequence would be:
A:1 B:2 A:3 B:4 A:5
There is a globally cached 'next value' for the sequence which is passed to whichever session asks for it.
--
Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk
Dante wrote in message <7h66vj$nla$1_at_nnrp1.deja.com>...
> It is important to understand that you have
> a current value for each session using the
> sequence and a current value for the DB instance.
>
Received on Thu May 13 1999 - 03:05:53 CDT