Ask the Expert

Disadvantages of Oracle Parallel Server

What is the biggest disadvantage of Oracle Parallel Server (OPS)?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: