Introduction to the new features of Oracle 10G I release (i)

Oracle
Introduction to the new features of Oracle 10G I release (i)



by fenng

2003-6-8



Oracle (www.oracle.com) has long claimed that Oracle 9i databases are only a transitional product, and that real technological innovation is likely to be in the next edition, usually 10i (the internal possible version number is 2003, hereinafter referred to as 10i, It is expected that there will be a new name in the official release. Many technicians may be more concerned about what new features Oracle 10i can offer and whether they can provide some exciting new features. Here's a brief overview of some of the features of Oracle's next database version.

NOTE: Recently Oracle has officially announced that this version of Oracle named 10G, where G is the meaning of the grid. hereby correct.



Overview



Oracle has stated in its technical white paper that there are two key objectives for the next version of Oracle database:



² Reduce Management Overhead

² Improve Performance

These enhancements are enhanced with high availability, new flashback capabilities, support for rollback update operations, and security enhancements to facilitate the management of large numbers of users; BI enhancements, including improved SQL capabilities, analysis capabilities, OLAP, data mining capabilities, improved capabilities for relational data storage, XML capabilities, and increased support for development capabilities.

Support for bioinformatics (bioinformatics).



Below we make a concise introduction to each aspect.



Performance and scaling capabilities



1. Support for new architectures

Support for the Intel 64-bit platform. Support InfiniBand. Greatly improved multilayer development frame

The performance and scalability capabilities of the structure. The new version also borrows the benefits of Windows operating system support for fiber.



2. High-speed data processing capability

In this release, a new type of Table object is introduced. This table structure is useful for inserting and parsing data in large quantities

Secretariat

This table structure has a good support for FIFO data processing applications. Such applications in telecommunications, production applications

can often be used. By using this optimized table structure, the application of the telecom class can be greatly improved.

Role.

(This magical Table object is the author's most interesting place.) )



3, RAC workload management

A new service framework. Enables administrators to set up and manage monitoring application load as a service.



4, for the OLAP partition

A large number of concurrent inserts can be provided through support for a hash partition's global index



5. New Improved Scheduler (Scheduler)

A new database scheduler is introduced to provide enterprise-level scheduling function. This scheduler allows administrators to have

Ability to schedule a job on a specific date and at a specific time. There is also the ability to create a library of scheduled objects that can and have existing objects being

shared by other users.



Manageability



One notable thing about this version of Oracle is the great management simplification. A large number of complex configuration and deployment settings are canceled or simplified. The common process of operation is automated. To simplify most of the adjustment and management operations in different areas.



1. Simplified database configuration and upgrade

Provides a pre-upgrade check capability to effectively reduce upgrade errors.

Remove a lot of tasks related to database configuration or automate them. At the initial installation, all databases are preconfigured to be included in the OEM environment without having to establish a management repository. Patches can be automatically flagged and downloaded automatically from Oracle Metalink.



2. Automatic Storage Management

The new version of the database can be configured to use Oracle-provided storage virtual tiers (Storage

Virtualization layer). Automate and simplify storage of databases.

Administrators can now manage a handful of disk groups without managing thousands of files-the automated storage management feature can

Automatically configures disk groups, providing data redundancy and optimized allocation of data.



3, automatic disk-based Backup and recovery

The 10i also greatly simplifies backup and recovery operations. This improvement is called disk based Recovery

Area,

Can be used by an online disk Cache for backup and restore operations.

Backups can be scheduled into automated operations, automating tuning.

When a backup fails, it can be restarted automatically to ensure that Oracle has a consistent environment to use.

4. Application optimization

In previous releases, the DBA had more time to manually refine the SQL statements. Here are some new tools that the DBA does not have to do these tiring things by hand.

5, automated statistical collection

Automate collection of optimization statistics for objects.

6. Automatic instance Adjustment



7. Automatic Memory adjustment

The previous version was able to automate the UGA tuning, which can adjust the SGA-related parameters.

This means that the DBA only needs to configure 2 memory parameters: The total amount of memory available to the user and the size of the shared area

Small.



Not to be continued ...