Q

Disadvantages of Oracle Parallel Server

This Content Component encountered an error

What is the biggest disadvantage of Oracle Parallel Server (OPS)? 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.

This was first published in December 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close