Atitit. Oracle 9 10 11 12 new features Attilax summary

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.