Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Q: Sequence delay

RE: Q: Sequence delay

From: aaaa wwwwww <>
Date: Tue, 26 Sep 2000 03:08:30 -0700
Message-Id: <>


NOCACHE has no meaning. U must very much cache them.

If there are too many U may have to look at cache_buckets



On Tue, 26 Sep 2000 01:10:26  
 Uldis Pavuls wrote:

>Sorry, haven't mentioned it (supposed it's evident) : we've tried different
>values up to max (as stated in Oracle docs) and even NOCACHE with ORDERED
>and NO ... Problem still pops up. There even any correlation with intensity
>couldn't be catch - it happens even in deep night with rare transaction -
>it's how it was discovered. The effect is not stable, it comes and goes, and
>i cannot see any rule there. I suspect there might be some latch contention,
>but statistics seems to be normal because they're statistics :) and cannot
>be impacted by random fluctuations ... Haven't anybody met something like
>The worse thing it's a customer's instance we do not have full and free
>access to, and it's rather 7x1440 than 7x24, eh ;) Response limit is said to
>be 3-5", end even such is complained as delay often ... Of course, downtime
>happens, but there is no place to play, and we're failing to reproduce the
>problem on our development instances.
>Strange, there wasn't such a problem while the same thing was running
> 10.20.
>Might it have some impact the migration between and 8.1.6 was done
>as file migration, not imp/exp?
>Uldis Pavuls
>DBA, Tieto Konts Financial Systems Ltd.
>Kr.Barona 32, Riga, Latvia, LV 1011
>phone +371 7 286 660, fax +371 7 243 000
>> -----Original Message-----
>> From: []On Behalf Of aaaa wwwwww
>> Sent: otrdiena, 2000. gada 26. septembris 09:11
>> To: Multiple recipients of list ORACLE-L
>> Subject: Re: Q: Sequence delay
>> Cash 100 or 200 numbers and see
>> Rao
>> --
>> On Mon, 25 Sep 2000 14:50:31
>> Uldis Pavuls wrote:
>> >Dear Guru,
>> >
>> >we've met some situation i cannot explain, i.e. some sequence
>> tends time to
>> >time respond with delay. It's sometimes several, sometimes many (50, for
>> >example) seconds. In OLTP it is a pain, isn't it?
>> >Oracle 8.1.6 EE/HP UX 11, Tuxedo involved, too.
>> >
>Please see the official ORACLE-L FAQ:
>Author: Uldis Pavuls
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Get your FREE Email and Voicemail at Lycos Communications at
Received on Tue Sep 26 2000 - 05:08:30 CDT

Original text of this message