Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: What to Choose ?
Jain,
If you do not have experience with OPS and raw devices you should stick with a cluster and mirrored disks. If you need performance use the Parallel Query Option and Partitions. You are correct that OPS is for scaling and DSS not really HA or OLTP. Of course many folks are thinking of using OPS and Transparent Application Fail-over (TAF) for HA - but they fail to consider unless the application (third party in most cases) and the database are designed for TAF they will fail-over as advertised - users would have to re-connect to a surviving node so why pay the cost of OPS when a cluster solution does the same thing. Another important point is that you DO NOT just migrate to OPS. OPS uses PCM locks to control block level access between the nodes. These are assigned at the datafile level - so if the application/database design does not create tablespaces based on access or lumps all the objects into large/general tablespaces and you plan to provide access to these objects by all nodes you will have contention - pinging in OPS terms. Also these PCM locks add overhead so unless you plan to really scale the number of nodes you will not be able to overcome this performance hit.
Hope this helps,
Jeffrey S. Kilgour
Professional Services (Oracle)
Washington IDC
-----Original Message-----
From: Jain, Akshay [mailto:Akshay.Jain_at_cit.com]
Sent: Wednesday, August 30, 2000 4:27 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: What to Choose ?
I thought that Oracle parallel server meant multiple processing nodes mounted onto the same disk farm. Thus disk failures would show up in all instances. Also, if different instances are accessing the same data block, one has to wait for the other to finish with it, making OPS not a proven technology for OLTP (??).
A backup from the hardware end sounds more purposeful towards high availability.
P.S. Someone said IBM's HACMP config isn't reliable in having the second node mount disks when one node goes down, leaving no access to data at all.
Akshay Jain
-----Original Message-----
Sent: Friday, August 25, 2000 6:02 AM
To: Multiple recipients of list ORACLE-L
WE are looking at "high availability".I need some help to decide
whether to go for
a High Availability Sun cluster with backup server or for Oracle parallel
server.
Keeping the key word in mind what would u people advice ?
I would be happy if you can provide any links to the mentioned Subject.
Thanks,
Kamal
-- Author: Kamalakannan, D (CAP, GCF) INET: D.Kamalakannan_at_gecapital.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-LReceived on Thu Aug 31 2000 - 09:37:12 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Author: Jain, Akshay INET: Akshay.Jain_at_cit.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