Oracle 9i: Overview of New Features

Oracle 9i Overview
    Database Performance
     Ease of Management
     Scalability
     Security
     Availability
Summary
Further Reading

2.1 Oracle 9i Performance Improvements

Performance is always a big issue with Oracle databases and there is a whole series of articles discussing Oracle performance tuning on our website, so what's changed in Oracle 9i to improve database performance? Well, probably one of the biggest improvements has been made to Parallel Server (now called Real Application Clusters by Oracle) which enable applications to use clustered servers without modification. Other improvements include:

• native compilation of PL/SQL
• reduction in latch contention (SGA locks) and I/O improvements
• better Java performance (better compilation, improved garbage collection)
• distributed database performance enhancements

See here for more details of how Oracle 9i new features affect performance.

2.2 Oracle 9i Manageability Enhancements

Ease of management of the Oracle database has always been a bone of contention, especially configuration of rollback segments and such like, so Oracle have made great strides to improve manageability as the complexity of the database has increased. These improvements include:

• automatic rollback segment management
• many operations management enhancements
• Oracle Enterprise Manager enhancements

More details of Oracle 9i new features relating to manageability are available here

2.3 Oracle 9i Scalability Enhancements

As the demand for Oracle databases to be able to support more and more users continues, issues of scalability become more important. Improvements in this area consist of:

• Real Application Clusters - new servers can be added as required
• reduced resource requirements per user
• improved resource management features to give greater control at lower levels

2.4 Oracle 9i Security Enhancements

As the number of users increase and the locations and types of users become more diverse, better security (and privacy) features become essential. The security improvements in Oracle 9i are:

• enhanced 3-tier security (integration with LDAP ...)
• improved hosting security (through use of virtual private databases), fine-grained auditing and single sign-on
• improved user security (more password management features, etc.)
• ability to encrypt stored data
• row-level access control (Oracle Label Security)

The rest of this article on Oracle 9i New Features continues here

---------------------------------------

Looking for more Oracle tips and tricks? Just subscribe to our ezine. 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 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-2009. All rights reserved.

Search for: