Re: Sequence - Cache expire ?

Nope. AFAIK, I don't see any other ways of sequence cache getting expired.

Ender Wiggin wrote:

> could this happen without an explicit flush of shared pool ? Initial gut
> feeling says "yes".
>
>
> Stan wrote:
>
>

>>When you flush the shared pool, all cached sequences gets flushed too.
>>
>>hth,
>>-Stan
>>
>>Ender Wiggin wrote:
>>
>>
>>>Hi,
>>> Does anyone know when Oracle expires/discards the cache for sequence
>>> except
>>>oracle shutdown/start ? System is Oracle 8i/Solaris. Thanks
>>>
>>>
>>>