Oracle and features of each version of the release time (transfer)

2011-03-07  来源:本站原创  分类:Database  人气:113 

In 1983, OracleV3 database publishing, became the industry's first to support PC, minicomputer, and the host database

August 1991, Oracle established in Beijing, a wholly-owned company, its Chinese name "Beijing Oracle Software Systems Co., Ltd.", that is, Chinese people today the title of Oracle Corporation.

ORACLE7.0 new features

Database integrity constraints

Storage function, process, process packages

Database Triggers

View Editor

User-defined SQL functions

Role-based security

Double log file

Resource constraints

Audit to improve

Incomplete database recovery

Performance Optimization

To clear the table


Detection point process

Data replication

ORACLE7.1 new features

Meet the American National Standards Organization ISO SQL92 standard entry

Balanced data replication

Distributed Recovery

Dynamic SQL

Distributed query optimization

Server Management

Read-only database

ORACLE7.2 new features

Can automatically expand the physical file data

Manual compression of the rollback can be

Creating tables and indexes can not be recycled

Support for subqueries in FROM clause

PL / SQL package

PL / SQL cursor variable

Inspection and

Distributed to create a table

DBMS transaction queue


In 1996, Oracle7.3 common database server release

The view can be split

Bit image index

In the table scan operation before the asynchronous read

Standby database

Affairs at instance startup delay recovery

You can modify the connection view

SQLDBA not custom

Index rebuild

Check the database to read and write

Context options

Spatial Data Option

Table space changes, there are combinations, temporary or permanent.

Database trigger editing and error correction

Storage parameters to support an unlimited number of data segments

init.ora parameters can be modified

HASH connection and anti-connectivity

Relationship of trust

ORACLE tracking operation

High-level replication object group

PL / SQL application function package

In 1997, Oracle launched a database for network computing Oracle8,

Object-related database

Object category increase (not a date, character, number three types)

Support international standards SQL3

Can call an external process

Each table's LOB field can be greater than 1

You can split tables and indexes

export / import of other partition table

Partitions can exist where different tablespace

online / offline, backup / recover partition table of the other

Combined and balanced partition

Advanced queue management information processing

SQL, PL / SQL, OCI performance improvement, efficient use of memory and CPU

VARCHAR2 can exceed 4000 bytes, each table field can be redundant 1000

DML statements can be distributed execution

Connection pool to support more online

"STAR" Query optimization

V $ trying to get multiple instances of the parameters, the database failed to clear a new instance of the point to point

Database data interface can handle pictures, video, context, time, space and other information

Backup and recovery performance

The introduction of security services management center

Fast refresh a snapshot, the introduction of Replication Manager

Deferred integrity constraint checking

NET8 replace SQL * NET

Keyword can be sorted in reverse

You can change any view

New ROWID format

In 1999, Oracle officially the world's first Internet database providing Oracle8i.

New features:

Internet computing

- WebDB, for creating, deploying and monitoring Web application

- IMedia

- OracleInternet file system


- Database JavaVM

- Java stored procedures, functions and triggers

- In Java, SQL and PL / SQL to interact seamlessly between the

- Java code embedded in SQLJ

- Enhanced JDBC driver

Data warehouse

- Summary management

- Hash and composite partitioning

- Resource Management

- Transparent Tablespace

- Function index and virtual columns

- Online indexing and reconstruction

- Descending index

- Automatic parallel query level

- The joint index and single-sheet summary DML

- Read-only standby database

- Direct path load API

- New bitmap indexing

- Sample function

- Parallel and fine-grained ANALYZE

- Abolition of the legal limit state

- Copies of statistical data

- MERGE into operation

- Before the "n" query optimization

Transaction Processing

- Publish and subscribe capabilities

- Database event triggers

- Autonomous transactions

- Single table hash cluster

- Partition table object type column

- The partition table in the LOB

- Index-organized table partition

- Stable optimizer execution plan

Oracle Parallel Server

- For instance internal scalable query ConsistentReadServer

- Installation Wizard

- Automatic connection load balancing mechanism

- Mandatory on a particular node to perform operations

Object-relational database

- Temporary LOB

- A collection of non-nested technique

- Enhanced object view

- Enhanced Object Cache

- Enhanced SQL * Loader, support objects, collections, and loading the LOB

- LOB performance enhancements

- LONG to LOB data migration

- User-defined object identifiers and nested identifiers

- Analysis of the detection of unstable REF


- Fine-grained access control

- Scalable and parameter-driven application context specification

- LDAP Integration

N-tier authentication and authorization

SSL support with X.509v3

PADIUS adapter

System management and ease of use

- Java-based multi-user Oracle Enterprise Manager

- Java-based Oracle Universal Installer

- Java-based database configuration assistant

- Use automatic instance listener registration

- Parallel parallel transaction recovery

- Cancel out

- For long-running operation in the process monitor

- Recovery Manager of Performance Improvement

- Recovery Manager capability to detect the disk affinity

- Automatic standby database

- Recovery time for instance recovery limit

- The damage block detection and repair

- Locally managed tablespaces

- Multi-file process and objectives

- Simple point in time tablespace recovery

Copy and Decision Automation

- To facilitate the deployment and deployment of complex snapshot of modules

- Offline instantiation

- Updatable snapshot in column-level subsetting

- Built-in application package

- Performance improvements snapshot refresh

- Distributed Query Optimization

- Enhanced security model

- Support OracleLite

PL / SQL improvements

- In PL / SQL (bulkbinds), the control of a SQL statement multiple data items

- In PL / SQL, the parameters passed by reference

- In PL / SQL in embedded dynamic SQL

- For tool vendors and cover PL / SQL code

- Unlimited PL / SQL package size


- Scalable indexing mechanism

- Extensible Optimizer

- Data cartridge service

- Pro * CTM external process

- Oracle Call Interface callback registration

- In index-organized tables for secondary indexes

- Support the process of external objects

Other new features

- Support for the euro symbol

- Temporary table

- The relationship between the calling program to perform routine safety

- Integration with Microsoft Transaction Server

- NetTM the HTTP protocol adapter

- RETURNING clause of the performance improvements

June 2001, Oracle launched a new generation of Internet e-commerce infrastructure Oracle9i.

Oracle9i key focus areas include:

• Providing the world's leading zero data loss protection of the environment

• Through the support of more on-line operation off-line maintenance requirements to reduce

• Provide for the damaged database fast and accurate repair

* Allows end users to identify and correct their own errors

The world's leading data protection environment

Oracle9i includes many new features to improve data protection. In addition to the existing products of the Standby key enhancements, including a provision monitoring, automation and control framework.

And management of the standby database is on the automation of many tasks, including initialization instance, the error jumps and easily switch back and forth between master and slave. Administrators can also optionally specify that each backup site lags behind the production environment, delayed application of the log (to relieve human error or damaged line errors) and select a zero data loss mode, in this mode redo logs to be synchronized sent to the alternate site.

Also enhanced in Oracle9i LogMiner, in order to provide full SQL-based Log Analysis (log analysis). LogMiner now supports indexing of clustered tables, chain line, direct load, scalar object type, LOB, LONG data types and DDL. LogMiner also showed support for the primary key and change the content based on query logs (for example, show the employee "Smith" all changes). A new graphical user interface and other database features also make this product easy to learn, easy to use.

Online Data Evolution

Oracle9i contains a new online re-organization and re-define the architecture, this architecture provides a more powerful re-organization capabilities. Administrators can now define the table to perform various on-line operations, including the heap-organized tables online re-organization. In essence, Oracle9i now allows on-line "CREATETABLEASSELECT" operation. In this new architecture, the table is copied to a new table. While copying the contents of the database to track updates to the original table. The copy is complete, updates will be applied to the new table. Once the update is applied, you can create indexes on the new table. After creating the index will be applied to any other updates, and the results table will replace the original table. Updating the dictionary data, while only in operation at the beginning and end of the lock table in exclusive mode. Using this new architecture, you can change the form of any online physical properties. Table can be moved to a new location, a table can be partitioned, the table can also be from an organization (such as deposits) to another organization (such as indexing of).

In addition, many logical properties can be changed. For example, you can change the column name, type and size, and columns can be added, deleted or merged. The main restriction is not to modify the table's primary key.

Oracle9i also supports the current index-organized tables online last level index create, rebuild, and so on. Can now be created online indexes and analyze them simultaneously. Secondary indexes support efficient use of the block tips.

Administrators can quickly stop the database in order to perform the requested operation inactive transaction. In addition, you can dynamically adjust the Oracle9i buffer cache and shared pool size. Finally, Oracle9i can also be the object the user is online and is accessible and to verify the structure of objects (analytical validation).

Accurate database repair

Oracle8i contains very complete recovery. Oracle9i by making them more powerful and more accurate they were extended.

Oracle9i includes disk damage

In 2004, the release oralce10g.

July 12, 2007, Oracle announced a database in the United States New York, Oracle 11g, which is the latest version of the Oracle database

  • Oracle and features of each version of the release time (transfer) 2011-03-07

    In 1983, OracleV3 database publishing, became the industry's first to support PC, minicomputer, and the host database August 1991, Oracle established in Beijing, a wholly-owned company, its Chinese name "Beijing Oracle Software Systems Co., Ltd."

  • oracle expdp / impdp into high-low version version 2011-08-28

    oracle import and export using expdp / impdp My version 11gR2 version colleagues need to specify the version number is 11gr1 I installed the oracle is installed is 11gR1 11gR2 colleagues with expdp impdp import export version is

  • Oracle Index and create various types of indexing described method [transfer] 2010-12-02

    Overview of the index in a variety of relational database systems are important part of its search for improving the speed of data play a vital role. In Oracle, the index base is divided into the following: B * Tree index, inverted index, descending

  • Oracle parameters and parameters of the viewing method of classification (transfer) 2011-08-17

    Oracle parameters and parameters of the viewing method of classification Original address: Oracle database system in the initialization parameter file init.ora to set the parameters to confi

  • eclipse中js报错(版本-Version: Juno Service Release 2... 2013-09-05

    eclipse中javascript报错问题处理: eclipse 版本: Version: Juno Service Release 2 Build id: 20130225-0426 三个地方: <1>"eclipse设置 ": Java代码 window->preference->JavaScript ->Validator->Errors/Warnings->Enable Javascript Sematic validation前面的

  • Export oracle data from the first version of txt 2010-07-24

    export oracle database perl to do the first edition appeared in this version of the text from the network to modify the plan after the completion of improved versions and features.

  • Linux Install Oracle reported Checking operating system version must be redhat-3, SuSE-9, redhat 2011-01-08

    Linux system installation oralce in the process, if the Linux distribution is not the recommended version of oracle may be reported as an error, leading to runInstaller can not be completed: [[email protected] database]$ ./runInstaller Starting Oracle

  • Various dates in Oracle to achieve the full version handling 2010-12-23

    TO_DATE format Day: dd number 12 dy abbreviated fri day spelled out friday ddspth spelled out, ordinal twelfth Month: mm number 03 mon abbreviated mar month spelled out march Year: yy two digits 98 yyyy four digits 1998 24-hour format next time range

  • Oracle Flashback features 2010-04-27

    alter table oa_fw_data_attribute enable row movement; flashback table oa_fw_data_attribute to timestamp to_timestamp ('2010-04-27 13:30:00 ',' yyyy-mm-dd hh24: mi: ss'); alter table oa_fw_data_attribute disable row movement;

  • Oracle delete the data table space after the release of 2010-03-02

    Oracle10g new features shrink segment to reduce HWM Table causes queries to slow the huge reduction is inevitable, so I often remove the data tables of data, but using delete, the data is deleted, but the rate has not improved much, sad the. Use the

  • Oracle exp / imp command to import and export database backup (transfer) is more 2011-01-05

    Oracle data import and export imp / exp is equivalent to oracle data restore and backup. exp command to export the data from the remote database server to the local dmp file, imp command to import the dmp file to the distance from the local database

  • Oracle representatives about a few bytes of a character problem (transfer) 2011-05-30

    In the Oracle definition of variables, often VARCHAR2 (3 Char) or VARCHAR2 (10 Byte) data type, then 3char or 10Byte in the end on behalf of several Chinese characters, several characters in it, the last of a colleague outside the company to discuss

  • ORACLE in the parameters. REF cursor and dynamic SQL instance (transfer) 2010-08-31

    Oracle cursor using Daquan SELECT statement is used to query data from the database, when the PL / SQL using the SELECT statement, used in conjunction with the INTO clause, the query is assigned the return value of the variable in the INTO clause, th

  • Oracle EBS之把自定义concurrent加入Pick Release Document Set(All Pick Release Documents)的几个注意点 2012-03-09

    1. 自定义的concurrent必须至少有一个参数的Token与标准的Pick Slip Report中任一Token相同. 一般情况下只有report(XMLP或者Oracle Reports)的参数可以设Token,所以需要加进这个 Document Set的concurrent基本上只能是report(XMLP或者Oracle Reports都可以). 2. 自定义的concurrent(基于第一点,即report)如果是XMLP的,而且output选为XML,则必须 同时有配套模板(e

  • About Oracle representative of a few bytes of a character problem (transfer) 2011-05-30

    In the Oracle-defined variable, often VARCHAR2 (3 Char) or VARCHAR2 (10 Byte) data type, then 3char or 10Byte in the end on behalf of several characters, several characters in it, the last foreign company, one colleague to discuss this issue, what di

  • (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 version of those things you know? 2010-07-12

    In this paper, is the Oracle version of the distinction, from the Oracle database products, starting from the Oracle2.0 (not 1.0) to Oracle7.3.4 are related to Oracle is a relatively simple version number to the beginning of Oracle8, the database pro

  • [Transfer] Oracle JDBC driver version you know? 2010-11-17

    When using the Oracle JDBC driver, you are not some problems by replacing the different versions of the Oracle JDBC driver to resolve it? The most commonly used ojdbc14.jar there are several versions, classes12.jar there are several versions you know

  • 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 database version history 2011-05-18

    Summer of 1979, RSI released the second edition of Oracle * March 1983, RSI released the third edition of Oracle From now on Oracle products have a key feature: portability * In October 1984, Oracle released version 4 products This version adds impor