RE: Q: Sequence delay

Dear

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

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

Rao

--

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

>it?

>

>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

>7.3.4.5/HPUX 10.20.

>

>Might it have some impact the migration between 7.3.4.5 and 8.1.6 was done

>as file migration, not imp/exp?

>

>TIA,

>Uldis

>

>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

>mailto:U.Pavuls@konts.lv, http://www.konts.lv

>

>> -----Original Message-----

>> From: root_at_fatcity.com [mailto:root_at_fatcity.com]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: http://www.orafaq.com

>-- 

>Author: Uldis Pavuls

>  INET: U.Pavuls_at_konts.lv

>

>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: ListGuru_at_fatcity.com (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