Introduction to the new characteristics of Oracle 10g First Release (on)
By Fenng
2003-6-8
Oracle (www.oracle.com) has already declared that Oracle 9i database is just a transitional product, and the real technological innovation is likely to be in the next version, that is, 10i (internally possible version number is 2003, hereinafter referred to as " 10i, it is estimated that there will be a new name when officially issued) is reflected in it. Many technicians may care about what new features that can be more than Oracle 10i, can you provide some exciting new features? We are here a simple summary introduction to some features of Oracle's next database version.
Note: Recently Oracle has officially announced that the version of Oracle is named 10g, where G is Grid. Here.
Overview
Oracle clarified in its technical white paper, the next version of the Oracle database key targets are 2:
2 Reduce management overhead
2 Improve performance
These enhancements have enhanced high availability, new Flashback capabilities, support rollback update operations; enhancements to security, easy to manage large numbers of users; Bi enhancements, including improved SQL capabilities, analysis functions, OLAP, data mining Ability, etc .; the ability to store non-relational data storage has been improved; the ability of XML; strengthening the development capability support.
Support for Bioinformatics.
Below we make a concise introduction to all aspects.
Performance and expansion capabilities
1. Support for new architecture
Support for Intel 64-bit platforms. Support InfiniBand. Greatly improved multi-layer development frame
The constructive performance and scalable ability. The new version also borrows the advantages of the Windows operating system support for Fiber.
2, high speed data processing power
In this release, a new type of table object is introduced. The table structure is very beneficial to large amounts of insertion and parsing data
Place.
This table structure has good support for FIFO data processing applications. Such applications are in telecommunications, production applications
Often available. By using this optimized table structure, it is enormous to improve the application of the telecommunications stage.
effect.
(This magical table object is the most interested in the author.)
3, RAC Workload Management
A new service framework. Make the administrator as a service to manage the monitoring application load.
4, partitioning for OLAP
By support for the global index of the Hash partition, you can provide a lot of concurrent insertion capabilities.
5, new improvement scheduler (SCHEDULER)
Introduced a new database scheduler to provide enterprise level scheduling. This scheduler can make the administrator
Ability is at a specific date, a specific time scheduling Job. There is also the ability to create the library of scheduling objects and existing objects
Other users share.
Manageability
One of this version of Oracle is a great simplification of management. A large amount of complex configuration and deployment settings are canceled or simplified. Common operations are automated. Most adjustments and management operations in different regions to simplify.
1. Simplified database configuration and upgrade
Provides pre-upgrade check capabilities to effectively reduce upgrade errors.
Remove many of the tasks related to database configuration or automate it. At the time of initial installation, all databases are pre-configured including in an OEM environment without having to create a management database. Patch can be automatically tagged and automatically downloaded from Oracle MetAlink.
2, automatic storage management
The new version of the database can be configured to use the storage virtual layer provided by Oracle (Storage
Virtualization Layer. Automatically and simplify database storage.
Administrators can now manage a small number of disk groups without having to manage thousands of files - automatic storage management functions
Automatically configure disk groups, provide data redundancy and data optimization assignment.
3, automatic disk backup and recovery
10i also greatly simplifies backup and recovery operations. This improvement is called Disk Based Recovery
AREA,
You can be used by a online disk cache for backup and recovery operations.
Backups can schedule automated operations, automated optimization adjustments. When the backup failed, you can restart it automatically to ensure that Oracle can have a consistent environment.
4, application optimization
In the previous version, DBA is more manually to optimize the SQL statement. Here, some new tools have been introduced, and from this DBA does not need to do these tired things.
5, automation statistics collection
Collective statistics for object automation.
6, automated instance adjustment
7, automated memory adjustment
The last version can automate TUNING for UGA, which can be adjusted for SGA-related parameters.
This means that DBA only needs to configure 2 memory parameters: the total amount of memory available, and the shared area
small.
Sleal continuation ...
