Network Admin   «Prev  Next»

Lesson 3 Scalability features of Net
Objective Oracle enhancements for scalability.

Scalability features of Oracle Net

The new scalability features introduced with Oracle greatly improve the ability of Net to handle high volumes of incoming connections.
These new features especially impact distributed databases and Oracle Parallel Server (OPS). The two main areas with scalability enhancements in Oracle are the Oracle Distributed Database and OPS.

Oracle Distributed Database

There are two main areas of improvement for distributed databases: snapshots and Advanced Queuing. Oracle snapshots[1] provide new functionality, making them more sophisticated and robust. This means that a DBA can replicate data based on columns and/or row-level subsets. A snapshot can now include any specific rows or columns from the master table. Snapshots also allow aggregation, so that a snapshot can summarize information from a master table and pass summary data into a data warehouse table. Advanced Queuing[2] (the DBMS_AQADM package) in Oracle has been improved with a rule-based model for automatic forwarding of messages to Oracle clients. New event triggers can be used to trigger any event, such as a database startup, an Oracle user login, or a PL/SQL procedure.

Oracle Parallel Server

Within OPS, we see a host of new features. The most exciting addition is the OPS Assistant, which allows for easier configuration of the OPS environment. Another new product, Cluster Manager, assists in configuring OPS. To see two more new OPS features (cache fusion and connection-load balancing), view the Slide Show below.
Cache fusion: A diskless data transfer method for Oracle Parallel Server (OPS) that moves information from the cache of one database instance to the cache of another database instance.

Oracle Parallel Server Improvements
The next lesson introduces the new features for partitioned tables.

Oracle Net Features

Click the link below to learn about Oracle Net Features with their functions.
Oracle Net Features

[1]Snapshot: A replica of a table or part of a table that resides on another database instance. Snapshots can be read-only or updateable. 1
[2]Advanced Queuing: A pre-defined package enabling you to store messages into queues for deferred retrieval and processing by the Oracle server.