Introduction to Oracle 10G new features __oracle

Oracle has hinted on several occasions that Oracle 9i databases are only a transitional product, and that real technological innovation is likely to be reflected in the next edition, now known as 10G. Many technicians may be more concerned about what new features Oracle 10G can offer and whether they can provide some exciting new features. Here is a brief overview of some of the new features of Oracle 10g. Overview

Oracle explains in its technical white paper that there are two key objectives for the next version of Oracle database: reducing management overhead and improving performance

These enhancements are enhanced for high availability, new flashback capabilities, support rollback update operations, enhanced security, easy management of large numbers of users, BI enhancements, including improved SQL capabilities, analytics, OLAP, data mining capabilities, and improved capabilities for non-relational data storage , the ability of XML, and the strengthening of support for development capabilities. Support for bioinformatics (bioinformatics).

Here is a concise introduction to each of the following. performance and scaling capabilities

1. Support for new architectures
Support for the Intel 64-bit platform. Support InfiniBand. Greatly improved performance and scalability under multi-tier development architectures. The new version also borrows the benefits of Windows operating system support for Fiber.

2. High-speed data processing capability (this looks good, haha)
In this release, a new type of Table object is introduced. This table structure is useful for a large number of inserts and parsing data. This table structure has a good support for FIFO data processing applications. Such applications can often be used in telecommunications and production applications. Using this optimized table structure can greatly improve the performance of telecom-level applications.
(This magical Table object is the author's most interesting place.) See here)

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

4. Partitioning for OLAP
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 gives administrators the ability to schedule jobs on specific dates and at specific times. There is also the ability to create a library of scheduled objects that can be shared with existing objects 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 Upgrades
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. Automated Storage Management
The new version of the database can be configured to use the storage virtual layer provided by Oracle (Storage virtualization Layer). Automate and simplify storage of databases. Administrators can now manage a small number of disk groups without managing thousands of files-the automated storage management feature configures disk groups automatically, providing data redundancy and optimized allocation of data.

3. Automated disk-based Backup and recovery
The 10G also greatly simplifies backup and recovery operations. This improvement is called disk based Recovery area, which can be used by an online disk Cache for backup and recovery 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. (This seems a little too absolute)

5. Automated Statistical Collection
Automate collection of optimization statistics for objects.

6. Automation instance Adjustment
Do DBAs need to intervene more and less? The good news or the bad news?

7. Automated Memory tuning
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. the strengthening of high availability

1. Reduce downtime for application and database upgrades
By using the standby database. Allows switching between different versions of standby and product databases. The existing online redefinition feature enables you to clone all related database objects in one step.

2. Flash Back (flashback) any errors
This version of Oracle also expands the capabilities of flashback. Added a new type of log file that records changes to the database block. The new Log file is also managed by the automatic disk backup and Recovery feature. If an error occurs, such as for unsuccessful batch operations, the DBA can run flashback. Use these before Images to quickly restore the entire database to a previous point in time--this new feature can also be used in the Standby database without a recovery operation.
Flashback is a database-level operation, and can also flash the entire table back. The capacity of existing flashback queries has also been strengthened. In this release, administrators can quickly see the changes that are caused by a particular transaction.

3.Enhanced Data Guard Infrastructure

4. Security strengthening
VPD has been improved (hopefully this name will not change to anything else) and supports more security protocols. DATA Integration

1.Oracle streams This version also includes Oracle streams features, performance, and management improvements. New features include a product database downstream capture/offloading the capture and mining operations. supports strengthening for data types such as long, long RAW, NCLOB, and so on. The iot/cascade deletion is enhanced and performance is improved.

2.Data Pump
Oracle data pump--A high-speed, parallel technology architecture that enables rapid movement of data and metadata between databases. The original export/import was replaced by the Data Pump Export/data Pump Import and provided a perfect granularity of object selectivity. The Data Pump operation is recoverable. Compared with the exp/imp, there has been a great improvement. Archived data, logical backup data, and removable tablespace can be manipulated using the Pump.

This feature is very similar to NCR's product tools (even the names are very similar), what will be the functional performance, let us wait and see. Business Intelligence/Data warehousing and Bioinformatics (bioinformatics)

1. Support for Super large databases
The amount of data that can be supported to 8E. Improved storage, backup, and recovery management also have great support for large databases. Partitions can support indexing organization tables.

2. Shorten information turnaround time
The new version of Oracle provides enhanced ETL capabilities. can easily build large data warehouses and multiple data marts. A new change data capture framework allows administrators to easily capture and publish data changes. The new CDC feature uses the Oracle Stream technology architecture.
For large data transfers, the new version provides cross-platform support for the transfer table, allowing large amounts of data to be quickly detached from the database and attached to the second database.

3. Enhanced External Table functionality

4.SQL Loader Function Enhancement

5. Enhanced SQL analytics Capabilities
The capabilities of SQL statements are greatly enhanced for BI.

6. Enhanced OLAP analysis Capabilities
Oracle-built analytics enhancements. Provides a new interface based on Pl/sql and XML.

New parallelism capabilities are provided to facilitate aggregation and SQL impert operations. Some algorithms have been improved. OEMs can also be used to monitor and manage data mining environments.

7.BIOINFORMATICS Support
This version contains specific support for bioinformatics technology. Includes Native support for Double and Float data types. The built-in statistical functions support the common ANOVA analysis.

8. Improved data mining capabilities to expand data management capabilities

1.XML Enhancements

2. Multimedia
In the previous release, there was a restriction on the media file 4G. The 4G size limit for the media file is now removed (the limit is now: 8-128t). Multimedia data can be accessed through the SQL multimedia standard. Provide support for more new multimedia formats.

3. Document and Text management
Provides the ability to automatically discover languages and character sets for unknown documents. Support for new German spelling rules Japanese adverb, and so on.
The text index of the local partition can be created online. The document can be inserted when the index is created and rebuilt. Document services, such as highlighting, do not need to rebuild the index. The ability to retrieve documents is also improved. the strengthening of application development

The enhancement of 1.SQL language
SQL and Pl/sql support for regular expressions. An exciting feature that is afraid to rewrite many people's programming habits. You might see an SQL statement that accomplishes more complex functions. This version also supports the function of expression filtering.

Enhancement of the 2.pl/sql
The most important when the number of new Pl/sql Optimizer compilers provides a framework for effectively optimizing the compilation of Pl/sql programs. This release also introduces two new database packages: Utl_compress, Utl_mail.

3. The enhancement of globalization and Unicode provided globalization Development Kit (GDK). The Oracle NLS definition file begins to have platform independence.

4.Java improvements
Better support for JDBC. the others also include Improvements in OCCI and Pre compilers, improvements to database Web services, enhancement of web-based development environments, etc.