【免费】Oracle11gNewFeaturesforAdministratorsSummarySheetsbyAhmedbaraka资源-CSDN文库

Oracle

Features

需积分: 0 23 浏览量 2010-06-16 16:19:28 上传评论收藏 560KB PDF 举报

资源详情

资源评论

资源推荐

Page 1

Oracle 11g New Features for Administrators - Summary Sheets

Oracle 11g New Features for Administrators

Summary Sheets

Version 1.1

Editor:

Ahmed Baraka

Page 2

Oracle 11g New Features for Administrators - Summary Sheets

Usage Terms

• Anyone is can copy this document to any means of storage and present it in any format to any individual

or organization for non-commercial purpose free.

• No individual or organization may use this document for commercial purpose without a written permission

from the editor.

• There is no warranty of any type for the code or information presented in this document. The editor is not

responsible for any loses or damage resulted from using the information or executing the code in this

document.

• If any one wishes to correct a statement or a typing error or add a new piece of information, please send

an email message to

info@ahmedbaraka.com

Version History

Version Date Updates

1.0

23-Mar-2008 Initial document.

1.1

29-Apr-2008 - Mapping exam objectives to the document topics

- Fixing caught bugs in the code examples.

- Fixing caught errata and mistakes in some statements.

- Adding new topics.

Document Purpose

This document aims at briefly explaining Oracle Database 11g New Features with concentration on the practical

code. It discusses new features related to database administration and application development. The document is

edited so that it concentrates on the following:

• Brief description of the concepts. This includes:

o New terms and definitions.

o Significant advantages and/or disadvantages

o Concept limitations and precautions

• Code examples

On the other hand, the document avoids the following:

• Detailed explanation of the concepts

• Details of using Oracle Grid Control in implementing the concepts.

What is not covered?

The document discussed new features in Oracle 11g in only the topics as stated in the contents section. New

features introduced in other areas are not covered. To mention some of them, this document does not cover the

new features in the following areas:

• Oracle Streams

• Data Guard

• Oracle RAC

• Oracle XML DB

Prerequisite

To be able to get advantage of reading this document, you must have solid knowledge on Oracle database 10g

administration.

Page 3

Oracle 11g New Features for Administrators - Summary Sheets

Terms and Acronyms Used

Following are list of the terms and acronyms used in this document:

Term / Acronym Meaning

Oracle 11g Whenever Oracle 11g is mentioned in this document, it is meant to be Oracle Database

11g.

ADR Automatic Diagnostic Repository

Oracle Grid Control Oracle Grid Control, Database Control or Oracle Enterprise Manager (OEM) are used

interchangeably in this document.

Conventions in the Document

When you are asked to click on several links in the Enterprise Manager, the term "follow the links" is used. For

example, consider the following statement:

To manage created SQL patches, follow the links Database Home page> Server tab> Query Optimizer

section> SQL Plan Control> SQL Patch tab

This statement means, in the Database Home page you click Server tab where you will see Query Optimizer

section. Then you click on SQL Plan Control and then on the SQL Patch tab.

Resources

S/N Resource Type Resource Name

1 Book Oracle Database 11g New Features for DBAs and Developers, by Sam R. Alapati

and Charles Kim, Apress, ISBN: 978-1-59059-910-5

2 Book Oracle Database 11g New Features by Rober G. Freeman, Oracle Press

3 Oracle Official

Documentation

• Oracle Database New Features Guide 11g Release 1 (11.1) B28279-02

• Oracle Database Administrator's Guide 11g Release 1 (11.1) B28310-03

• Oracle Database Performance Tuning Guide 11g Release 1 (11.1) B28274-01

• Oracle Database Backup and Recovery User's Guide 11g Release 1 (11.1)

B28270-02

• Oracle Database PL/SQL Packages and Types Reference 11g Release 1 (11.1.)

B28419-02

• Oracle Database High Availability Overview 11g Release 1 (11.1) B28281-01

• Oracle Database Storage Administrator's Guide 11g Release 1 (11.1) B31107-03

• Oracle Database PL/SQL Language Reference 11g Release 1 (11.1) B28370-02

• Oracle Database VLDB and Partitioning Guide 11g Release 1 (11.1) B32024-01

• Oracle Database SecureFiles and Large Objects Developer's Guide 11g Release 1

(11.1) B28393-02

4 Oracle Metalink The following documents were referenced:

• Note:453487.1 Title: 11g New Features : Top 5 Features In 11g

• Note:454631.1 Title: 11g DBCA New features / Enhancements

• Note:445116.1 Title: Using the workload capture and replay in 11G

• Note:470199.1 Title: 11g feature: Flashback Data Archive Guide

• Note:444149.1 Title: New Background Processes In 11g

• Note:432776.1 11g New Feature : Transparent Data Encryption at Tablespace

Level

5 Web Site www.oracle-base.com

6 Web Site www.psoug.org

7 Web Site www.orafaq.com

8 Web Site http://technology.amis.nl

Page 5

Oracle 11g New Features for Administrators - Summary Sheets

Contents

Installation, Database Upgrades and Change Management 8

Installation New Features Support ______________________________________________________8

Role and Privilege Changes ___________________________________________________________8

Deprecated Components _____________________________________________________________9

New Initialization Parameters Affecting Database Creation ___________________________________9

DBCA Enhancements _______________________________________________________________10

Upgrading to Oracle Database 11g_____________________________________________________10

Database Replay___________________________________________________________________12

The SQL Performance Analyzer _______________________________________________________16

Patching in Oracle Database Control ___________________________________________________20

Database Diagnosis and Repair ________ 21

Introducing Automatic Diagnostic Repository (ADR) _______________________________________21

Configuring the ADR________________________________________________________________21

Using adrci Tool ___________________________________________________________________21

Using The Support Workbench in the OEM_______________________________________________23

Database Health Monitor ____________________________________________________________24

Data Recovery Advisor ______________________________________________________________25

SQL Test Case Builder ______________________________________________________________26

Data Block Corruption Parameters _____________________________________________________26

Database Administration _____________ 27

Automatic Memory Management ______________________________________________________27

Automatic Maintenance Tasks ________________________________________________________27

Oracle Flashback-Related New Features_________________________________________________29

Flashback Data Archive _____________________________________________________________30

Oracle Flashback Transaction Backout __________________________________________________32

Virtual Columns ___________________________________________________________________33

New Data Partitioning Schemes _______________________________________________________33

DDL Lock Timeout _________________________________________________________________33

Explicit Locking of Tables ____________________________________________________________34

Invisible Indexes __________________________________________________________________34

Read-Only Tables __________________________________________________________________34

Shrinking Temporary Tablespaces and Tempfiles__________________________________________34

Creating an Initialization Parameter File from Memory _____________________________________34

Restore Point Enhancements _________________________________________________________35

Database Resident Connection Pooling__________________________________________________35

Comparing and Synchronizing Database Objects _________________________________________36

SQL*Plus New Features _____________________________________________________________38

Online Application Maintenance _______________________________________________________38

剩余104页未读，继续阅读

评论收藏

内容反馈

gavin08

粉丝: 0
资源: 7

Oracle 11g New Features for Administrators Summary Sheets by Ahm...

评论0

最新资源

Oracle 11g New Features for Administrators Summary Sheets by Ahm...

评论0

Sybex OCP Oracle 10g New Features For Administrators

Oracle Database 10g：New Features for Administrators

Oracle9i: New Features for Administrators

D77758GC20_Oracle Database 12c New Features for Administrators Activity Guide

D77758GC20_Oracle Database 12c New Features for Administrators Activity Guide 2

Mcgraw Hill Osborne Ocp Oracle Database 10G New Features For Administrators Exam Guide.pdf

Oracle Database 10g：New Features for Administrators Vol 1

oracle database 11g new features volume 2

OCP.Oracle.11g.New.Features.for.Administrators.Exam.Guide.

Oracle.11g.-.New.Features.for.Administrators.中文版教材

Oracle.Database.11g.New.Features.for.Administrators.Exam.Guide

Oracle Database 11g Underground Advice for Database Administrators

OCP.Oracle.Database.10g.New.Features.for.Administrators.Exam.Guide

oracle database 12c new feature sg2

\McGraw.Hill.Osborne.Media.OCP.Oracle.Database.10g.New.Features.for.Administrators.Exam.Guide.eBook-LiB.pdf

Oracle 11g，面向管理员的新增功能

D50081CN11_ppt---Oracle Database 11g：面向管理员的新增功能 part2

NetSuite ERP for Administrators 2018

Oracle Database 11g The Complete Reference.pdf

数据库系统概念（原书第七版）习题答案

oci.dll 12版本全部

Kingbase KCA题库

数据库系统概念（原书第七版）课后作业题

fineReport课后10题答案.zip

win64-11gR2-client.zip

Oracle11安装依赖包，11.2.0.4.0版本

oracle 12c windows 安装包下载

Oracle19c-Windows客户端

Oracle19c(19.3)数据库驱动ojdbc.jar

最新资源