Oracle8 Adhoc New Features

The miscellaneous new features in Oracle8 include: • Networking and password management • Replication enhancements • Index-only tables • Deferred constraints • Extended ROWID formats • Enhanced National Language Support

Networking and Password Management

SQL*Net has been renamed to Net8 as it now supports HTTP and IIOP connections and has been enhanced to improve the scalability, manageability and security of the database. The scalability has been improved by the use of connection pooling, multiplexing and link concentration to optimise the use of network resources, allowing thousands of concurrent users to access a single database. Connection pooling is a mechanism for reusing idle transport connections when the network sessions have timed out and is particularly useful for systems where there are infrequent concentrated bursts of activity such as a data warehouse. Multiplexing enables multiple network sessions to share a single transport connection and is ideal for applications such as process control which require a continuous connection. Link concentration uses the connection manager to multiplex a large number of client connections to a single server. The network administration has been improved by the creation of a default configuration when Net8 is installed and by use of a new name resolution option called the Native Hostname Adapter. Client profiles can now be created using Enterprise Manager and stored on an Oracle Names Server for central access. After installation, the Net8 wizard searches the network for Oracle Names Servers, creates a list in optimal order and downloads the appropriate client profile if it exists. The security administration has been improved with the introduction of the Oracle Security Server based on the x.509 security standard. This provides single sign on and centralised security management through Enterprise Manager and a security API that can be used to create digital signatures for documents. Password management has also been introduced to provide password aging, history and complexity checking via user written functions. Password profiles can be created for groups of users in much the same way as resource profiles.

Replication Enhancements

Oracle8 allows the FAST option for refreshing of snapshots containing correlated sub-queries and tables containing objects (CLOBs or BLOBs) can now be replicated. The performance has also been enhanced by propagating deferred transactions in parallel and by using internal triggers to capture and store updates to replicated data.

Index-Only Tables

Oracle8 allows tables to be stored in a B-tree by combining the index and the data in one structure, thereby eliminating the need to store row ids as well as the extra space and the associated processing required to maintain two copies of the columns that make up the index. If the data to be stored with the index is greater than a user specified percentage (maximum 40%) of the block size, then the data is migrated to a row overflow area. This keeps the B-tree index densely clustered, ensuring the index searches remain fast. Index organised tables are particularly useful for online analytical processing (OLAP) applications and other applications that access and manipulate complex data. There are no restrictions on SQL to access these tables, except that the rowid cannot be selected (as it doesn’t exist). The only other restriction is that they can only be indexed one way (i.e. by the primary key).

Deferred Constraints

With Oracle8 the enforcement of constraints can now be deferred until a transaction commits instead of being enforced immediately the dml statement is submitted. This complies with the SQL92 standard, intermediate level.

Extended Rowid Format

In Oracle8 the rowid has been extended from 6 bytes to 10 bytes internally and is presented as an 18 byte string in base 64 which contains the characters "A-Z", "a-z", "+" and "/". The rowid now comprises a unique object number, a tablespace relative file number, a block number and a slot number enabling Oracle8 to support very large databases, objects and partitions.

Enhanced National Language Support

This now includes calendar support, monetary formats, language specific character sets, sorting rules, culture specific conventions, character handling and user messages in the native language. See the Oracle8 new features overview for a summary of other new features. ----------------------------------------------------------- Looking to sky-rocket productivity, slash costs and accelerate innovation? Training is a highly cost-effective, proven method of boosting productivity leaving time, money and staff available for more innovation. Smartsoft offers instructor-led training in Oracle and related technologies on or off site in cities across the UK as well as self-study online training.  See our training course schedule, or let us know your requirements. Oracle tips and tricks Subscribe to our newsletter, jam-packed full of tips and tricks to help you slash costs, sky-rocket productivity and make your systems better, faster and smarter. Smartsoft Computing Ltd, Bristol, England Tel: 0845 003 1320 Contact Us View our privacy policy This site uses woopra.com to gather statistical information about our visitors. This data is aggregated to show industry trends (such as browser share). However, this data shall be the average of many thousands of visits and is in no way linked to individuals. View woopra privacy policy.  Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. © Copyright Smartsoft Computing Ltd 2014. All rights reserved.