Rao,
there is only 11 sequences and only 3 or 4 are used frequently... Most of
the headaches comes form one involved in almost every incoming transaction.
There is also Tuxedo as transaction manager, HP man guessed if it might have
a role, though i cannot imagine which way. The problem is still here on
spite of they'd asked to pin sequences. It is rather random than regular
effect and without any visible relation with traffic.
TIA,
Uldis
>
> 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
Received on Wed Oct 04 2000 - 05:46:53 CDT
