The differences between various versions of Oracle

2011-05-31  来源:本站原创  分类:Database  人气:107 

Oracle 9i than 8i new features, what more?
Briefly said: 9i easier to manage.
Detail: concurrent cluster, 8i OPS upgraded to 9i RAC, 8i between nodes to exchange information with the hard drive, 9i node network cable between the high-speed cache fusion (Cache Fusion) technology to exchange information, exchange of more than 100 times faster.
9i to modify the kernel parameters line and memory allocation, 8i not.
Data file and table space management, 8i manual management, 9i automatic management.
9i than 8i enhanced support for ANSI SQL99.
9i than 8i enhance quick recovery after a failure (Fast-start).
8i only support physical backup (physical backup) database, 9i also adds support for logical backups (logical backup) database, the backup of the database in addition to the primary database as a mirror, can also provide other data services.

9i Oracle 10g more than what new features?
Briefly said: 10g support grid (Grid), to support automatic management (Automatic Management).

10g, g is the "Grid" short, support grid computing, namely, the use of multiple server nodes form a virtual high-speed networks, high-performance server, load balancing across the grid (Load Balance), on-demand node additions and deletions, avoid single point of failure (Single Point of Failure).

Easy to install, installation than 9i cut in half.
New browser-based Enterprise Manager (Enterprise Manager).

Automatic Storage Management (ASM), add or delete the hard disk no longer need to mirror the operating system administrator, load balancing, physical volumes, logical volumes, partitions, file system, just make an Oracle command, ASM will automatically add or remove hard disk management.

Memory automation, automatic distribution and release of required system memory.
SQL performance tuning automation.

Free browser-based application development tool Oracle Application Express (formerly HTML DB), to support 10g and 9i R2.

Rapid correction of human error flashback (Flashback) queries and recovery, can recover the database, table or record.

Data Pump (Data Pump) high import, export data faster than traditional methods more than double the export, import, fast 15--45 times.
Fine audit (Fine-Grained Auditing), record all the operation of sensitive data.
Table space to store data (TableSpace) cross-platform replication, greatly improve the data warehouse load.
Streams (Streams) copy, to achieve low system consumption, two-way (double-direction), HTTP (resume from break point), cross-platform (cross platform), the complex cross-copy data sources.
Data Guard disaster recovery (Data Guard) to increase the logical backup, backup the database daily to run in read-only, full use of the backup database.
EE supports many new options, strengthening the internal management of the database "Database Vault", the database activity auditing (Audit Vault), Data Warehouse advanced features (Warehouse Builder Enterprise ETL, Warehouse Builder Data Quality).

More than 10g Oracle 11g What new features?
Oracle 11 g extend the exclusive provider of grid computing has the advantage, you can use it to improve customer service levels, reduce downtime and more efficient use of IT resources, but also can enhance the performance of business applications around the clock, scalable and security.
Using Real Application Testing (RAT) to minimize the risk of change
11 g reduced the database upgrade, and other hardware and operating system changes the cost, significantly simplifies system testing before and after the change so that you can identify and solve problems. For example:
Using Database Replay, you can easily capture at the database level and the actual production load test your system to re-play, so you can fully test the system changes (including critical concurrency characteristics) influence.
SQL Performance Analyzer identify structured query language) SQL (and performance of the implementation of plans to change back. You can then use the SQL Tuning Advisor to solve the problems identified, the method is to restore to the original implementation plan or further optimized.
Automation to improve the efficiency of utilization management DBA
Oracle Database 11 g continue to work (starting from the Oracle9i database to Oracle database has been 10 g) was significantly simplify and fully automate DBA tasks. Oracle Database 11 g of the new features include:
Self-learning function automatically using SQL Optimization System Global Area (SGA) and Program Global Area (PGA) memory cache of automatic, uniform adjustment of the new advisor for the partition, data recovery, flow performance and space management for the Automatic Database Diagnostic Monitor (ADDM) enhancements, to provide Oracle Real Application Clusters (Oracle RAC) environment in the global view for better performance and improved performance comparison analysis.
Quickly resolve the problem by troubleshooting
Oracle Database 11 g in the new troubleshooting features enable customers to capture Oracle after an error
Support the required data becomes extremely simple. This can speed up the solution to the problem, reducing the need for customers to reproduce the problem.
Minimize the cost of downtime by quickly restoring data Oracle Data Guard
Oracle Data Guard in coordination between local and remote server database maintenance and synchronization in order to quickly from a disaster or site failure recovery. Oracle Database 11 g provides a wealth of significant enhancements Oracle Data Guard, including the ability to run on the physical real-time query standby system for reporting and other purposes of physical standby system can be temporarily converted to a logical standby system to perform on-line, rolling the database upgrade
.. Support snapshot backup system test environment In addition, the performance of physical and logical standby has improved. Logical standby now supports Extensible Markup Language (XML) type character large object (CLOB) data types and transparent data encryption. Now supports automatic, quick-start failover to support asynchronous transfer.
Oracle Database 11 g provides several automatic storage management for the important high-availability enhancements
Support for rolling upgrades ..
.. Automatic bad block detection and repair
.. Fast mirror resynchronization, this feature can be effectively re-synchronized storage network connectivity is temporarily lost when the image Automatic Storage Management Automatic Storage Management storage array performance enhancement makes it faster to open a large database and reduce SGA memory consumption. These enhancements also allow the DBA to increase storage allocation unit size to speed up large-scale sequence of input / output (I / O)
Significantly increased uptime
Oracle Database 11 g so that you can apply a lot of one-off database patches (including diagnostic patch), and no downtime. The new data recovery advisor through the quick identification of root cause for the DBA to provide recovery options available, greatly reducing downtime, and in some cases, through "self-healing" mechanism automatically correct the problem.
Oracle Database 11 g There are other performance improvements, including
.. Automatically compile the database PL / SQL and Java
.. The trigger faster, including more effective trigger calls per line
Faster simple SQL operations ..
Oracle Data Guard .. faster and Oracle Streams Replication
.. And the Network File System (NFS) storage device faster, more reliable direct connection
Faster upgrade ..
.. Large files faster backup / restore
Faster backup compression ..
Oracle Database 11 g ILM including a large number of new features, such as
.. The new partition functions, including
. By the parent / child reference partition
. By the virtual column partitioning
Oracle Database 11 g also has Oracle Flashback Data Archive with the Total Recall, so you can query the table in the selected previous data, thus providing a simple and practical to add a time dimension to the data of the method to the change tracking, ILM, auditing and compliance.
Other high-availability enhancements
Oracle Database 11g high availability, there are other enhancements, including:
Oracle Flashback Transaction Query provides other related matters with rogue services change button to change the options that can be transmitted with a more enhanced platform migration and data movement, including transport district, models, and cross-platform database
Oracle Recovery Manager (RMAN) support the Windows Volume Shadow Copy Service (VSS) snapshots, in order to achieve more closely with the integrated Windows backup optimization of performance and reliability compliance, legal discovery and integration trends in the data warehouse the size of the database every two leading years will triple, which greatly affects the large database storage cost and performance, reliability and manageability. Oracle Database 11 g so that organizations can use low-cost servers and modular, easily scalable storage of large transactions and data warehousing systems and provide quick access to weather data. Oracle Database 11 g to provide new and innovative features to further improve the environment requires very stringent performance and scalability.
Using SecureFiles securely store all of your data
Oracle SecureFiles is used to store large objects in the database) LOB ((such as images, large text objects, or including XML, medical imaging, and geospatial raster objects, including advanced data types) of the next generation of products. SecureFiles provide services that fully and file system comparable to superior performance. In addition, it provides advanced features such as intelligent compression and transparent encryption and transparent duplication.
Online transaction processing by compression to improve performance and minimize storage costs
Oracle Database 11 g support for online transaction processing (OLAP) applications commonly used in the update, insert and delete operations of data compression. Previous versions of Oracle database applications to support data warehouse load operation commonly used bulk data compression. Oracle Database 11 g OLTP Table Compression through more efficient use of memory to cache data and to reduce table scan I / O improves database performance. Using OLTP table compression, you can use minimal processing overhead to 2 to 3 times the compression ratio.

  • The differences between various versions of Oracle 2011-05-31

    Oracle 9i than 8i new features, what more? Briefly said: 9i easier to manage. Detail: concurrent cluster, 8i OPS upgraded to 9i RAC, 8i between nodes to exchange information with the hard drive, 9i node network cable between the high-speed cache fusi

  • Differences between various versions of Oracle 2011-05-31

    Oracle 9i 8i more than what new features? Briefly said: 9i easier to manage. Detail: concurrent cluster, 8i OPS upgraded to 9i RAC, 8i between nodes to exchange information with the hard drive, 9i node network cable between the high-speed cache fusio

  • Between different versions of ORACLE database import and export 2011-01-20

    Transfer: Today, finally between different versions of the database to figure out the import and export problems, into a previously himself around, Oh. Has not figure out this problem from two clients,

  • Differences between the versions of MySQL 2010-08-25

    The first MySQL Community Server, this not money! This second MySQL Enterprise to pay, but you can call ask questions, that is, telephone technical support. The third MySQL Cluster, this alone is unable to use, in 1 or 2 on the basis of use. Of cours

  • Oracle version differences [turn] 2011-03-25

    Transfer: From the ORACLE database products, starting from ORACLE2.0 (not 1.0) until ORACLE7.3.4 are simply the version number, but ORACLE8 began, there have identifier properties of d

  • Oracle 8i.9i.10g.11g compare different versions of the new features 2010-02-20

    Oracle 9i 8i more than what new features? In brief: 9i easier to manage. Detail: Concurrent cluster, 8i OPS upgraded to 9i RAC, 8i between nodes to exchange information with the hard drive, 9i node network cable between the high-speed cache fusion (C

  • Oracle 8i.9i.10g.11g between the various versions of the new features of relatively 2010-07-01

    Oracle 9i 8i more than what new features? In brief: 9i easier to manage. Detail: Concurrent cluster, 8i OPS upgraded to 9i RAC, 8i between nodes to exchange information with the hard drive, 9i node network cable between the high-speed cache fusion (C

  • Different versions of the Oracle data import and export 2010-08-10

    1. Different versions of oracle data export -----" another oracle database into a different environment, will lead to action can not succeed! In fact, different versions of oralce data transfer, the key is how the two versions of oracle client segmen

  • oracle 8i, 9i and 10g differences 2010-08-13

    Oracle 9i 8i more than what new features? In brief: 9i easier to manage. Detail: Concurrent cluster, 8i OPS upgraded to 9i RAC, 8i between nodes to exchange information with the hard drive, 9i node network cable between the high-speed cache fusion (C

  • oracle data between different versions of the Import and Export 2010-10-13

    <Transfer from:> Oracle's imp / exp component is commonly used tool, it's an operating principle is backward compatible. The following is summary of a few basis rules and the related use test: Ru

  • (Transfer) Oracle version of the distinction between 2010-03-29 Oracle version of the distinction between collection From the ORACLE database products, starting from the ORACLE2.0 (not 1.0) till ORACLE7.3.4 are simply the version number, but ORACLE

  • Oracle genuine authorized users 2010-04-10

    Recent genuine oracle 10g database piracy, made about research, (ZT) with reference to online content, are summarized as follows: (Not guaranteed to be completely correct, the content from the internet) CopyLeft and software services in today's fight

  • oracle's license and use of genuine 2010-06-08

    1, genuine differences between Oracle products and pirated <br /> to the point, this is not pay attention in many research areas. For business (that you're not at home, his play), strictly speaking, is the difference between a paper permit. Whatever

  • Oracle: implementation plan: access path connection table, suggesting Statistical information bind variables 2011-09-09

    SQL execution: Analysis: Hard analysis, soft analysis Implementation Plan: access path (access path), table join (table join), statistics (statistics), bind variable (bind variable), tips (hints) ================================================== ===

  • OJDBC DATE raised the issue of different versions 2011-09-26

    General database, DATE field only the date, not including the date information, but Oracle Database DATE data type in the date, time, and for different versions of Oracle jdbc driver, for the treatment of the problem are some differences, if you are

  • The use of Oracle in RowNum 2010-02-08

    ROWNUM, is a pseudo-column, it returns a sequence according to records of a specific figure. ROWID pseudo-column with different: ROWID is a data type, uniquely identifies a record in one physical location ID, based on 64-bit encoding of 16 character

  • Oracle concepts (Oracle 10.2) 2010-02-20

    1, Oracle introduced This chapter provides an overview for the Oracle database server, contains the following topics Oracle database architecture Oracle Database Features Oracle Database Application Development Oracle database architecture Oracle dat

  • How to set Oracle Events to track database 2010-03-18

    Oracle Events event is an important diagnostic tool and problem-solving approach, often through Events or change the settings to screen the behavior of Oracle; There are four types of Events: Immediate dumps Conditional dumps Trace dumps Events that

  • Notes on 'Expert Oracle' - No.13.1: partition - partition of benefits 2010-02-25

    1. To improve the system reliability (HA): do not put all your eggs in one basket a. A bad area, but the data partition B can still be inquiries into b. A bad partition, and restore the partition of the time table than the entire restoration was much

  • In Oracle Database 10g, easy to response time analysis (change) 2010-04-27

    Of: Robin Schumacher Through the Oracle database 10 g, many previously unavailable to measure the response time is now at your fingertips. Download this article: Oracle Database 10 g In the past, trying to get the best performance of the process data