RE: OPS instalation - pretty urgent

!! Please do not post Off Topic to this List !!

Private vs. public redo log threads mainly influence the instance startup time, nothing more. Instance nimber x will look for a private redo log thread x and if it doesn't find it, it will start looking for an unused public redo log thread. You can make a public redo log thread orivate by disabling it and then re-enabling it without the keyword "GLOBAL".
With rollback segments, it's a different issue. You should have private rollback segments, in their separate tablespaces so that no two instances access the same tablespace for rollback segments. Bear in mind that as of 8.1.7 when an instance needs a read consistent image of a block, it will ask the instance that owns the exclusive lock to produce one and then ship it over the interconnect ("hypefabric" or "clic" in my case). That means that rollback segments will be very heavily used (unless, and this is for the real conossieurs, the cache fusion was disabled by setting _cr_server to "FALSE".) As for the releasable locks, they are very CPU intensive, and instance will use an incredible amounts of the CPU time. If that is a problem, allocate permanent instead of the releasable locks. You will have to read the manuals to understand this one.

> -----Original Message-----
> From: Pablo ksksksk [mailto:p_rodri99_at_yahoo.es]
> Sent: Wednesday, September 12, 2001 8:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: OPS instalation - pretty urgent
>
>
> Hi Mladen Thanks for the answer.
>
> I'm already doing some reading...
>
> I'd like to ask you some questions about your answer
> Here I go. Please be nice if I'm wrong
>
> 1)Log threads have to be private to each instance,
> right? there's no Public thread I think.
>
> 2)Is it usual to use PUBLIC rollback segments in OPS,
> or people just preffer PRIVATE ones. and Why? is there
> a performance issue involved?
>
> 3)I really don't know what you mean with this: "Start
> with static locking(hashed, GC_FILES_TO_LOCKS) and
> turn it to releasable for the high concurrency tables"
> (if it's hard to explain, don't worry I'll try to find
> it out)
>
> 4)Why do you say I'll need MTS? That depends on the
> number of users using the system right?
>
>
> Thanks for your time. I appreciate it.
>
>
>
>
>
> Uh, oh! Did you just say OPS? First of all, go to
> Oracle
> and ask them for EXACTLY the OS version you need and
> the
> required OS patches. Second, plan your configuration:
> private
> rollback segments, private log threads, locally
> managed tablespaces,
> you should know exactly how much space do you need for
> SYSTEM,
> how many 1GB log files you need, etc, etc. You are
> probably aware
> that everything has to reside on the raw devices. Find
> a good SA to
> carve up your disk drives to fit your needs. Start
> with static locking
> (hashed, GC_FILES_TO_LOCKS) and turn it to releasable
> for the high
> concurrency tables. Configure large pool for the MTS
> connections, you'll
> need it. Ask oracle & IBM whether you need any
> specific OS parameter to
> be set (AIO, nonpageable memory, post-wait
> extensions), make sure that
> you have a truckload of semaphore sets and 50 times
> more semaphores.
> Don't be stinting on the shared memory size. Download
> all relevant manuals
> from metalink, print them out on your bosses favorite
> laserjet and
> read them. Remember the following phone number: (800)
> 223-1711.
> Take vacation when you're done.
>
>
>
> _______________________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger: Comunicación instantánea gratis con tu gente -
> http://messenger.yahoo.es
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Pablo=20ksksksk?=
> INET: p_rodri99_at_yahoo.es
>
> 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).
>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
  INET: MGogala_at_oxhp.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).