The new features in Oracle9i Database release 2 (9.2) deliver the performance, scalability, and availability critical to hosted service software at anywhere.

• Scalability and Performance
• Availability
• Manageability
• Information Integration
• Business Intelligence
• Security and Directory
• Internet Content Management
• Application Development
• Windows Integration

Scalability and Performance

Oracle9i Real Application Clusters enables all applications to exploit cluster database availability, scalability, and performance

Key enhancements in Oracle9i

• Partitioning of Applications No Longer Necessary
• Fast Split Partitioning
• Shared Server
• Itanium 2 on HP-UX and Linux

Availability
Oracle9i extends to internet database availability critical for any e-business application.

Key enhancements in Oracle9i

• Enhanced Disaster Recovery Environment
• Streamlined Operational Database Management

Manageability
Oracle9i Systems management is simplified and improved by increased self-management and self-tuning capabilities.

Key enhancements in Oracle9i

• Streamlined Operational Database Management
• Simplified Oracle9i Administration With Oracle Enterprise Manager
• LogMiner Enhancements
• Minimizing the Production Impact of Upgrading
• Cluster File Systems
• Domain Indexes Enhancement
• Table Function Enhancement
• Oracle Net Services Enhancements
• Segment-level Statistics Collection
• Real Application Clusters Guard II

Information Integration
Important feature of database management system is the ability to share information among multiple databases and its applications. Traditionally, this has meant that users and applications must pull information from the database. Today, new efficiencies and business models require a more comprehensive and automated approach. This approach must automatically determine what information is relevant and share that information with those who need it. It must also be a universal solution that adapts to changing business requirements and minimizes the trade-offs of single purpose solutions. This active sharing of information includes capturing and managing events in the database, including but not limited to data manipulation language (DML) and propagating those events to other databases and applications.

Information sharing is crucial for data and application integration, replication, data warehouse loading, high availability, data protection, and other applications. However, decision makers are often overwhelmed by the variety of options they face when selecting an information sharing solution. Some solutions are targeted for different purposes and appear incompatible with other solutions. As a result, users find that no single solution meets all their needs and fear becoming limited by the solution they have implemented should their needs change. They therefore want a single solution that meets all their information sharing needs.


Business Intelligence


Oracle9i technology focuses especially on the challenges raised by the large volume of data and the need for near real time complex analysis in an Internet-enabled environment.

Key enhancements in Oracle9i

• Oracle OLAP Option Enhancements
• Scalability for Business Intelligence

Security and Directory

Security for Oracle9i release 2 has enhancements of new features

• SYS Auditing Capability
• DBA GRANT/REVOKE of Object Privileges
• Password for Users SYS and SYSTEM at Database Creation
• Simplified User Setup and Administration
• User Migration Utility
• Support for Advanced Encryption Standard (AES)
• Strong Authentication: Support for RADIUS Authorizations
• Public Key Infrastructure: SSL Hardware Acceleration
• Directory Naming Access Control in Oracle Net Services
• Oracle Label Security: Releasabilities

Internet Content Management

Oracle9i allows customers to store, manage and aggregate all types of multimedia content into a single database.

Key enhancements in Oracle9i

• Storage, Management, and Aggregation of Content
• Oracle Spatial

Application Development

Best development platform for e-business and application development

Key enhancements in Oracle9i

• Oracle Text
• Workspace Manager
• Multilevel Referential Integrity Support
• Oracle Spatial
• XML and XML DB
• Open Server-Side PL/SQL and Java Debugging
• Object Type Translator (OTT) Tags: Carrying Forward User Added Code

Windows Integration

The platform of choice for organizations deploying on the Windows operating system
Oracle9i release 2 (9.2) supports.

• Microsoft .Net environment with OLE DB .NET and ODBC .NET compliance
• Oracle Data Provider for .NET (ODP.NET).
  Note: ODP.0.NET is planned to be available in production by the end of 2002 and is not part of the Oracle9i Release 2 CD but is separately downloadable at:
  
  Oracle Data Provider for .NET (ODP.NET)
  
• Improvements in the OLE DB driver to provide better performance by reducing the number of round trips to the database and by caching metadata for improved query performance