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 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.