Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Disadvantages of Oracle Parallel Server
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Disadvantages of Oracle Parallel Server

Brian Peasland EXPERT RESPONSE FROM: Brian Peasland

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site
>
QUESTION POSED ON: 17 December 2003
What is the biggest disadvantage of Oracle Parallel Server (OPS)?


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary


There are two big disadvantages to Oracle Parallel Server (OPS). Which one is the "biggest" all depends on your perspective. First, OPS is very complex. This complexity does bring high availability and it can bring higher performance. But it is not an easy thing to set up and administer OPS. Second, OPS has a problem known as "disk pinging." To illustrate this, we'll assume that there are two instances in the OPS configuration. Instance1, running on Server1, currently has some dirty data in its buffer cache. An application connected to Instance2 on Server2 wants to access that data. Before it can access that data, Instance1 writes the data back to the shared disk storage. Then Instance2 reads this data into it's buffer cache. This data going back and forth on disk is known as disk pinging and has been known to cause some performance problems.

Oracle addressed this last issue in Oracle9i's Real Application Clusters (RAC), the replacement for OPS with a product called Cache Fusion. Actually, Cache Fusion appeared late in Oracle 8.1.7's OPS. With Cache Fusion, Instance2 could read the buffer cache of Instance1 through a high-speed interconnect between the two servers. RAC with Cache Fusion eliminated the disk pinging that plagued OPS deployments. This only leaves the complexity issue.




Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts