Re: OPS Sequences: nocache == order ??

I agree with Anoj, you need to talk to the business folks to remove this dependency. Else you may encounter waits/queues on getting the next sequence numbers. One of the benfits in OPS and in RAC is the sequence cache option, because each instance will not have to query the Oracle's fast cache areas for the next sequence or wait in queue to get the next number.

Any ways if you see slowness you now where to look!

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Tue, 03 Sep 2002 15:54:06 -0800

Unfortunately, we have an application dependency and I was required to come up with a quick & dirty fix. Thanks for your reply.

On 2002.09.03 19:10 Anjo Kolk wrote:
>
> If you run OPS and specify order, it works like no cache.
>
> My question to you: "Why cripple OPS and your business performance by
having
> this requirement ?" Spending a few bucks to get rid of this dependency
will
> improve the performance, until you run in to the next problem ;-)
>
> Anjo.

>
>
>
> On Wednesday 04 September 2002 00:00, you wrote:
> > I'm managing an OPS configuration (4x HP 9000/N, HP-UX 11/64 , RDBMS
> > 8.1.7.1)
> > and I'm having an application dependency on a temporal order of
sequence
> > numbers.
> > With OPS that becomes a problem because each node caches a set of
sequence
> > numbers
> > (20 by default). Oracle has an option, specifically for that situation,
> > namely "ORDER".
> > My question is whether ORDER is the same thing as NOCACHE and whether
it is
> > possible
> > to have a NOCACHE sequence which will return numbers in an incorrect
order
> > (larger number
> > before the smaller one).
> > Please, o OPS gods and godesses, help me out and I'll sacrifice you a
beer
> > when I see you.
> > Mladen Gogala
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anjo Kolk
> INET: anjo_at_oraperf.com
>
> 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).
>

--
Mladen Gogala
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mladen Gogala
   INET: mgogala_at_adelphia.net

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).





Murali Vallath
Oracle Certified DBA
http://www8.ewebcity.com/muralivallath/
http://www.summerksyus.com/


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Murali Vallath
  INET: murali_vallath_at_hotmail.com

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).