Atitit. Oracle 9 10 11 12 new features Attilax summary

Atitit. Oracle 9 10 11 12 new features

1. ORACLE 11G new Features 1

1.1. oracle11g new features 1

1.2. Audit 1

1.3.1. Audit Introduction 1

1.4. Other (mostly management functions) 2

2. new features of Oracle 12c 2

2.1.2 Improved Defaults enhanced default, default can now refer directly to sequence, while enhancing default's ability to act as an identity 2

2.2. Easy Top-n and pagination queries , easier to use top-n and page number query 2

3. Introduction to Oracle 10G new features 2

4. Reference 2

1. ORACLE 11G new Features

ORACLE 11G new Features-EU's column-blog channel-CSDN.NET.htm

1.1. oracle11g new feature 1.2.   Audit 1.3.1. Audit Introduction

1) What is audit and role

Auditing (Audit) is used to monitor database operations performed by users , and ORACLE stores audit trail results to OS files (the default location is $ORACLE _base/ admin/$ORACLE _sid/adump/) or database (SYS stored in the system table Space . aud$ table, viewable through view dba_audit_trail ).

In oracle11g , the audit function (audit_trail) is turned on by default. In previous versions, auditing was turned off by default.

Because the audit is turned on, the database adds a lot of consumption. Can degrade business performance, so if it is not necessary, after you have installed the database, you can choose to turn off the database auditing feature.

Author :: Old Wow's paw attilax ayron, email:[email protected]

Reprint please indicate source: Http://blog.csdn.net/attilax

1.4. Others (mostly management functions)

Reference

Oracle Database 11g: Important new features for DBAs and Developers . htm

2.12 new features of Oracle 12c

2.1.2 Improved Defaults enhanced default, default can now refer directly to sequence, while enhancing default's ability to act as identity 2.2. Easy top-n and pagination queries, easier to use TOP-N and page number query

Provides syntax similar to the limit in MySQL ,Row limiting Clause

3. Introduction to Oracle 10G new features

Transparent Data encryption

Stored procedure Encryption Wrap

4. Reference

oracle11g new Features _ Spring mouse _ Sina blog. htm

Oracle 11g New Features Introduction _ Database Review and analysis _it expert network. htm

Read 12 new features of Oracle 12c-open source China community. htm

Introduction to Oracle 10G new features-oracle tutorial. htm

Oracle 10G new features--rman-jimeper-blog Park. htm

Atitit. Oracle 9 10 11 12 new features Attilax summary