Thanks for taking time to reply, Cary. Much
appreciated.
Did I understand it correctly that in active/active
setup it would be beneficial to give each node "it's
own virtual empire" so to speak.
Like one node to service say marketing and sales,
while the other to deal with say inventory and
automation and minimize interdependencies between the
two?
I was thinking more along the lines of equally
distributing/balancing the utilization across the
nodes (which presumably makes it easier to re-route db
calls to surviving node in case of instance/node
failure after remastering, since all nodes are
"peers")
I obviously need to do some serious RTFMing here.
So if the key is to have application partitioned (by
probably functional/business areas?), is it at the
logical design stage that this needs to be accounted
for?
Assuming enterprise framework in place, like Zachman's
(http://www.zifa.com/framework.html) would it be at
the system model/logical level (or using Oracle
Designer terminology I guess at the system analysis
stage) that "design for RAC" comes to the picture for
a first time?
Thanks again.
- Cary Millsap <cary.millsap_at_hotsos.com> wrote: >
If two or more RAC instances will be trying to cache
> the same data
> blocks, then this causes the performance problems
> that you'll see show
> up as lots of time spent on the event called "global
> cache cr request".
> If you can partition your application so that RAC
> nodes don't have to
> share blocks very often through the cache fusion
> mechanism, then your
> system will scale a lot better.
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
>
> Upcoming events:
> - Hotsos Clinic, Dec 9-11 Honolulu
> - Hotsos Clinic 101, Jan 7-9 Knoxville
> - Steve Adams's Miracle Master Class, Jan 13-15
> Copenhagen
> - 2003 Hotsos Symposium, Feb 9-12 Dallas
>
>
> -----Original Message-----
> Sent: Tuesday, November 26, 2002 3:34 PM
> To: Multiple recipients of list ORACLE-L
>
> Dear List,
>
> Number of times I've seen that one of prerequsites
> for
> switching from single node DB to OPS/RAC is to have
> an
> application specifically designed / architectured to
> run on RAC.
> Can somebody elaborate? Is it something "visible" on
>
> ERD? That is by looking at the model can RAC guru
> tell
> that it wouldn't work well on RAC?
> Or put it another way can one conclude based on the
> ERD that app was modeled to run on RAC?
>
> What's the recepie for app design for RAC?
>
> TIA
>
>
>
> Post your free ad now! http://personals.yahoo.ca
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Boris Dali
> INET: boris_dali_at_yahoo.ca
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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: Cary Millsap
> INET: cary.millsap_at_hotsos.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> 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).
>
Post your free ad now!
http://personals.yahoo.ca
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boris Dali
INET: boris_dali_at_yahoo.ca
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Wed Nov 27 2002 - 09:49:07 CST
