For no frills, no fluff, just solid, reliable technical information subscribe to our ezine, its jam-packed full of tips and tricks to help you make more of your Oracle systems
The Oracle 8 OLTP Enhancements consist of enhancements to the Oracle Call Interface (OCI) and parallel server and the introduction of queuing and messaging facilities inside the database.
Oracle 8 now formally incorporates queues and supporting processes to add items to and remove from a queue. This can be used in applications such as workflow management to send messages from one process to another and can remove the need for a separate transaction-processing monitor.
The parallel server now includes global fixed views (prefixed gv$), which are equivalent to the corresponding v$ views, but with an extra column to identify the particular instance to which each value applies. This saves the need to log on to each instance individually to obtain the information.
Another new feature of parallel server is transparent application failover. This enables users to be connected to another parallel server instance automatically when the original instance to which they were connected becomes unavailable.
The failover can be configured at three functional levels that determine how transparent is the switch to the standby system and two performance levels, which determine how quickly the standby system is available.
The functional levels are:
The performance levels are:
With Oracle 8, parallel server now has a distributed lock manager integrated into the database. This reduces the time required for installation and implementation of parallel server and makes the lock manager portable and more flexible.
Often in a parallel server environment, modifications to indexes are concentrated on a small set of leaf blocks, which may cause hot spots on the disk and reduce performance due to the amount of block pinging required for each instance to be able to update the data block.
In Oracle 8 this can be avoided by the use of reverse-key indexes which reverse the order of the bytes in each column of the index whilst maintaining the column order.
This feature can also be used to prevent skewed indexes, which occur when new values are always inserted at one end of the index and old values are always removed from the other end of the index.
Return from Oracle 8 OLTP enhancements to Oracle 8 new features overview
---------------------------------------
Looking for more Oracle tips and tricks? If you're looking for no frills, no fluff, just solid, reliable technical information, take a short cut now and subscribe to our ezine. Published monthly, it's jam-packed full of tips and tricks to help you make more of your Oracle systems and save you hours of blood, sweat and tears searching for information. Subscribe today - there's no charge - and your first issue will soon be winging its way to your mailbox.
Smartsoft Computing Ltd
Bristol, England
Tel: 0845 0031320
Contact Us
Click here to view our privacy policy .
This site uses woopra.com to gather statistical information about our visitors. View woopra privacy policy .
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. UNIX is a registered trademark of The Open Group in the United States and other countries.
© Copyright Smartsoft Computing Ltd 2001-2008. All rights reserved.