Message-Id: <10631.117846@fatcity.com> From: "aaaa wwwwww" Date: Tue, 26 Sep 2000 03:08:30 -0700 Subject: 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@fatcity.com [mailto:root@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@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@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