Re: PARALLEL SERVER

From: Bill Pass <wbpass_at_YAHOO.COM>
Date: Thu, 23 May 2002 09:51:42 -0800
Message-ID: <F001.0046996E.20020523095142@fatcity.com>

I have done OPS/RAC on 7.x, 8.x, 8i and 9i w/IBM SP, RS/6000 and Sun.

Believe it or not you can encounter database hangs on OPS/RAC on any of these versions that you do not encounter on non-OPS/RAC solutions (or as Oracle likes to put it in some cases slows down so much that it appears hung).

In most cases you can steer clear of these issues by not executing DDL very often while the system is running in a production mode or by avoiding full consistent exports. Replication is another area that can lead to hung databases when used in conjunction with OPS/RAC.

I still advise clients to not go their unless they have to (adding more CPU's will give you more bang for the buck than another system in most cases like yours).

In cases where you need the scalability and your application is designed for it (pre-9i), you can make it work. The simpler the application the easier it will be to get functional.

I prefer the terminal releases of any of these versions up to and including 9.0.1.4.

Bill

• Seema Singh <oracledbam_at_hotmail.com> wrote:
  > Hi
  > I have one application which is running on Oracle
  > 8.1.6.But most of time CPU
  > idea is very low due to capacity peak.I am looking
  > for either Oracle
  > Parallel server or Oracle9i.Oracle Parallel server
  > would distribute the load
  > but question is.
  > Is Oracle Parallel server is stable in rel 8.1.7 or
  > rel 9i?
  > We are also thinking to upgrade Oracle9i,What Would
  > be the group View on
  > Oracle9i?
  > Is is ok to move forward Oracle9i for production
  > database?
  > Any statistics how much %of peoples are using Oracle
  > Parallel server and
  > Oracle 9i right now?
  > Thanks
  > -Seema
  >
  >
  >
  

  ---

  
  > Send and receive Hotmail on your mobile device:
  > http://mobile.msn.com
  >
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Seema Singh
  > INET: oracledbam_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).
  

  ---

Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bill Pass
  INET: wbpass_at_yahoo.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).

Received on Thu May 23 2002 - 12:51:42 CDT