Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 11 - Application Deployment

OLTP Applications Using ‘Exclusive’ or Specific Data

In this type of application, the RAC system gives almost linear scalability. Instead of using a stand-alone database with limited resources, the RAC database provides more than one database instance, allowing applications to connect to any of the instances. For example, a bank branch is accessing the central database system. Any particular branch usually inserts or updates only the data pertaining to it. It rarely needs to access another branches’ data. This kind of arrangement allows a set of branches to be grouped by region or load, say, on instance one. Another group of branches accesses instance two, and so on. Since the data blocks of one branch are rarely spread across multiple instances, scalability is almost linear, with nearly zero cross instance transfers.

Departmental Applications

Extending the analogy explained above, let’s assume there are many functional entities or departments accessing a common RAC database system. For example, human resources, sales, distribution, manufacturing, and finance all access the same database system. Each of these functional units has a set of data. It is very rare that the data pertaining to one department is needed for another department.

In this case, access can easily be vertically partitioned. For example, sales and distribution can access through instance one, human resources and finance can access through instance two, and manufacturing can access through instance three. All these applications modify different sets of tables. Conflicts and cross instance block transfers are minimized.

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA

For more information, please visit www.praetoriate.com or email .