RE: Q: Sequence delay

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.
Received on Tue Sep 26 2000 - 02:06:36 CDT