Oracle9i: DBA OCP Upgrade Exam Cram D17106GC10 - Oracle入门与认证 - ITPUB论坛

hotiice
版主

精华贴数 10
个人空间 0
技术积分 16699 (62)
社区积分 1796 (649)
注册日期 2004-9-9
论坛徽章:21

#1

使用道具

发表于 2007-11-9 15:02

Oracle9i: DBA OCP Upgrade Exam Cram D17106GC10

1 Oracle Server Security
Objectives 1-2
Connecting as the DBA 1-3
Example Connects 1-4
Stricter Default Security 1-5
Secure Application Role 1-7
Global Application Context 1-8
Managing Global Application Context 1-9
Global Application Context Function 1-10
Global Context Example 1-11
Fine-Grained Access Control Enhancements 1-12
Policy Groups 1-13
Fine-Grained Audit 1-14
Fine-Grained Auditing Example 1-15
Encryption Enhancements 1-16
Oracle Label Security 1-17
Oracle Enterprise Login Assistant 1-18
Enterprise User Security Enhancements 1-19
Summary 1-20

2 General High Availability Technology
Objectives 2-2
Reducing Unplanned Downtime Overview 2-3
Fast-Start Time-Based Recovery Limit 2-4
Changes to Previous Parameters 2-9
Changes to V$INSTANCE_RECOVERY 2-10
Oracle Flashback Overview 2-11
Oracle Flashback 2-12
Resumable Space Allocation Overview 2-17
Resumable Space Allocation Life Cycle 2-18
Resumable Space Allocation Operations 2-20
Enable Session Resumable Space Allocation 2-21
RESUMABLE System Privilege 2-25
DBA_RESUMABLE Dictionary View 2-26
Export/Import Enhancements (STATISTICS) 2-28
Export/Import Enhancements (TABLESPACES Mode) 2-29
Export/Import Enhancements (Resumable Space Allocation) 2-30
Export/Import Enhancements (Flashback) 2-31
Summary 2-32

3 Oracle9i LogMiner Enhancements
Objectives 3-2
LogMiner New Features 3-3
DDL Statement Support 3-5
Data Dictionary Access 3-6 Dictionary Information in the Redo Logs 3-7
Using an Online Data Dictionary 3-8
DDL Tracking in the Dictionary 3-9
Dictionary Staleness Detection 3-10
Skip Past Log Corruptions 3-11
Display Only Committed Transactions Information 3-12
Primary Key Information 3-13
LogMiner Restrictions 3-15
LogMiner Views 3-16
Summary 3-17

4 Backup and Recovery
Objectives 4-2
RMAN Manageability Enhancements 4-3
Persistent Configuration Parameters 4-4
Retention Policies 4-5
Automatic Channel Allocation 4-6
CONFIGURE CHANNEL Command 4-7
CONFIGURE DEVICE Command 4-8
CONFIGURE BACKUP COPIES Command 4-10
CONFIGURE EXCLUDE Command 4-11
CONFIGURE SNAPSHOT CONTROLFILE and CONFIGURE AUXNAME Commands 4-12
CONFIGURE CONTROLFILE AUTOBACKUP Command 4-13
Long Term Backups 4-15
Mirrored Backups 4-16
Backup File Optimization 4-17
Restartable Backups 4-18
Archive Log Backup 4-19
Backupset Backup 4-20
Restore File Optimization and Restartable Restore 4-21
RMAN Reliability Enhancements 4-22
Archive Log Failover and Automatic Log Switch 4-23
Backup Piece Failover 4-24
Block Media Recovery (BMR) 4-25
MTTR Reduction 4-26
Other BMR Benefits 4-27
Trial Recovery 4-28
Trial Recovery Allowing Corruptions of Data Blocks 4-29
Miscellaneous RMAN Enhancements 4-32
REPORT NEED BACKUP Command 4-34
Command Unification 4-35
LIST Command Improvements 4-36
Other RMAN Enhancements 4-37
Summary 4-38

5 Data Guard Overview
Objectives 5-2
Data Guard Overview 5-4
General Data Guard Architecture 5-5
Data Guard Broker and Data Guard Manager 5-6
Data Guard Manager 5-9
Data Availability Modes  5-11
Setting Parameters with DGB  5-15
Redo Log Reception Possibilities  5-16
Creating Standby Redo Logs  5-17
Setting a Failure Resolution Policy 5-18
Finishing Managed Recovery  5-19
Physical Standby Database Failover  5-20
Version Difference  5-21
Database Switchover Steps 5-22
Automatic Recovery of Log Gaps  5-27
Miscellaneous Enhancements  5-28
Summary 5-31

6 Database Resource Manager Enhancements
Objectives 6-2
Active Session Pool 6-3
Maximum Estimated Execution Time 6-4
Automatic Consumer Group Switching 6-5
Undo Quota 6-9
Changing Undo Quota 6-7
Oracle Supplied Plans 6-8
Summary 6-9

7 Online Operations
Objectives 7-2
Online Index Rebuild 7-3
Online Table Redefinition 7-6
Online Table Redefinition: SYNC and ABORT 7-9
Online Table Redefinition: Example 7-10
Online Table Redefinition Limitations 7-12
Online Analyze Validate 7-14
Quiesce Database Benefits 7-16
Quiesce Database Syntax 7-17
Server Parameter File (SPFILE) 7-18
What Is an SPFILE? 7-19
Creating an SPFILE 7-20
Changing Parameter Values Within an SPFILE 7-21
STARTUP Command Behavior 7-22
Exporting an SPFILE 7-23
Example of an Exported SPFILE 7-24
Migrating to an SPFILE 7-25
Summary 7-26

8 Segment Management (Part I)
Objectives 8-2
Global Index Maintenance During Partition DDLs 8-3
Maintaining Global Indexes During DDL 8-4
List Partitioning Overview and Benefits 8-7
List Partitioning Example 8-8
List Partitioning Usage 8-9
Metadata API 8-11
Metadata API in Oracle9i 8-12
Metadata API in Oracle9i Browsing Example 8-13
Common Extraction, Transformation, and Loading Process 8-14
Pipelined Data Transformation in Oracle9i 8-15
Overview of External Tables 8-16
Applications of External Tables 8-17
Example of Defining External Tables 8-18
Querying External Tables 8-20
Data Dictionary Information for External Tables 8-21
Summary 8-22

9 Segment Management (Part II)
Objectives 9-2
Automatic Segment-Space Management 9-3
Automatic Segment-Space Management at Work 9-4
Creating an Automatic Space Management Segment 9-6
Creating an Automatic Space Management Segment: Example 9-7
Modifications to the DBMS_SPACE Package 9-8
Block Space Management 9-9
DBMS_REPAIR Package 9-10
DBMS_REPAIR and PCTFREE Implementation 9-11
Modifications to Dictionary Views 9-12
Compatibility and Migration 9-13
What Is a Bitmap Join Index? 9-15
Advantages and Disadvantages 9-16
Example With Three Tables 9-17
Data Dictionary and Bitmap Join Indexes 9-18
Bitmap Join Indexes Restrictions 9-19
Summary 9-20

10 Performance Improvements
Objectives 10-2
Identifying Unused Indexes 10-3
Enabling and Disabling Monitoring Index Usage 10-4
V$OBJECT_USAGE View 10-5
Skip Scanning of Indexes 10-7
Cursor Sharing Enhancements 10-8
CURSOR_SHARING Parameter 10-10
Cached Execution Plans 10-11
New View to Support Cached Execution Plans 10-12
New PLAN_HASH_VALUE Column in V$SQL 10-13
New First Rows Optimization 10-14
New Gathering Statistic Estimates 10-15
New GATHER AUTO Option 10-17
Optimizer Cost Model Enhancements 10-18
Gathering System Statistics 10-20
Gathering System Statistics Example 10-21
Summary 10-23

11 Scalable Session State Management
Objectives  11-2
Oracle Shared Server Improvements 11-3
Connection Establishment: Direct Handoff 11-4
Common Event Model for Database and Network 11-5
Multithreaded HS Agent Architecture  11-6
HS Agent Initialization Paramaters  11-7
Summary  11-8

12 Real Application Clusters
Objectives 12-2
Real Application Clusters Overview 12-3
Benefits of Real Application Clusters 12-4
Global Cache Service 12-5
Dynamic Resource Remastering 12-6
Block Transfers 12-7
Benefits of Cache Fusion 12-8
High Availability Features 12-9
Real Application Clusters Guard Architecture 12-10
Monitors and Failover 12-11
Shared Initialization Parameter File 12-12
Shared Server-Side Parameter File 12-13
SRVCTL Commands 11-24
Real Application Clusters and OEM 11-25
OEM Instance Management Provisions 12-14
Summary 12-15

13 File Management
Objectives 13-2
Oracle-Managed Files Overview 13-3
Who Can Use Oracle-Managed Files? 13-4
New Dynamic Initialization Parameters 13-5
OMF Example 13-6
OMF File Names Structure  13-7
Managing OMF Control Files  13-9
Impact of OMF on Create Controlfile Command  13-10
Managing OMF Redo Log Files  13-12
Managing OMF Tablespaces  13-13
Default Temporary Tablespace 13-15
Create Default Temporary Tablespace at Database Creation Time 13-17
Alter Default Temporary Tablespace 13-18
Default Temporary Tablespace Restrictions 13-19
Summary 13-20

14 Tablespace Management
Objectives 14-2
Automatic Undo Management 14-3
Automatic Undo Management Concepts 14-4
Dynamic Extents Transfer 14-6
Specifying the Mode for Undo Space Management 14-7
Creating an Undo Tablespace at Database Creation Time 14-9
Creating an Undo Tablespace After Database Creation 14-10
Altering an Undo Tablespace 14-11
Dropping an Undo Tablespace 14-12
Switching Undo Tablespaces 14-13
Changing the Retention Period for Undo Information 14-15
Data Dictionary Views to Support Automatic Undo Management 14-17
New Data Dictionary View to Support Automatic Undo Management 14-18
New Parameters to Support Automatic Undo Management: Summary 14-20
Multiple Block Size Support 14-21
Standard Block Size 14-22
Nonstandard Block Sizes 14-24
Creating a Nonstandard Block Size Tablespace 14-25
Multiple Block Sizing Rules 14-26
Summary 14-27

15 Memory Management
Objectives 15-2
Automatic SQL Execution Memory Management 15-3
PGA Memory Management 15-4
Enabling Automatic SQL Execution Memory Management 15-5
New Statistics and Columns 15-7
New Views to Support SQL Execution Memory Management 15-9
Example Use of V$SQL_WORKAREA 15-10
Dynamic SGA Concepts 15-11
Unit of Allocation  15-12
Growing a Component’s SGA Memory Area  15-14
Dynamic Shared Pool 15-15
Dynamic Buffer Cache 15-16
New Buffer Cache Parameters  15-17
Deprecated Buffer Cache Parameters  15-18
Example Buffer Caches Setup  15-19
Dynamic Buffer Cache Advisory Parameter 15-20
New View to Support Buffer Cache Advisory 15-21
Summary 15-22

16 Enterprise Manager Enhancements
Objectives 16-2
New Console Look and Feel 16-3
Console Launched Standalone 16-4
Stand-alone Connection Benefits 16-5
Stand-alone Connection Restrictions 16-6
EM Support for 9i Database Features  16-7
Undo Tablespace Support  16-8
Buffer Cache Size Advice View  16-9
Creating Default Temporary Tablespace  16-10
HTML Database Reports 16-11
Database Configuration Report 16-12
User-Defined Events 16-13
User-Defined Event Tests 16-14
Event Handler 16-16
Summary 16-17

17 SQL Enhancements
Objectives 17-2
SQL:1999 Enhancements Overview 17-3
SQL:1999 Joins 17-4
CASE Expression Enhancements 17-5
Simple CASE Expressions 17-6
Searched CASE Expressions 17-7
NULLIF and COALESCE 17-8
Scalar Subqueries 17-9
Scalar Subquery Examples 17-10
Explicit Defaults 17-11
The MERGE Statement 17-12
Analytical Function Enhancements 17-13
WIDTH_BUCKET Function 17-15
Composite Columns 17-16
Constraint Enhancements 17-17
Explicit Index Control 17-18
Less Foreign Key Locking Overhead 17-19
Constraints on Views 17-20
View Constraint Types 17-21
Create Constrained Views 17-22
Constrained View Maintenance 17-23
Index Scans and Function-Based Indexes 17-24
SELECT ... FOR UPDATE WAIT 17-25
LONG to LOB Migration 17-26
PL/SQL Support for LOB Migration 17-27
Restrictions on LOB Migration 17-28
Common SQL Parser 17-29
Native PL/SQL Execution 17-30
Summary 17-31

18 Globalization Support
Objectives 18-2
Globalization and NLS  18-3
TIMESTAMP and INTERVAL Data Types 18-4
TIMESTAMP and INTERVAL Example 18-5
TIMESTAMP Literals 18-6
INTERVAL Literals 18-7
TIMESTAMP Formats 18-8
Using Time Zones 18-9
Application or Server Time Zone Handling 18-10
Datetime/Interval Arithmetic 18-11
Datetime Functions 18-12
Datetime Conversion Functions 18-13
Datetime EXTRACT Function 18-14
Daylight Saving Time 18-15
Introduction to Unicode 18-16
Unicode Character Forms 18-17
Enhanced Unicode Support  18-18
New Unicode Character Sets  18-20
Choosing a Unicode Solution Scenario: Unicode Database 18-21
Choosing a Unicode Solution Scenario: Unicode Data Type 18-22
Byte and Character Semantics  18-24
Implicit Type Conversion for NCHAR Data Type 18-26
Character Set Scanner 18-27
Common Character Conversion Problems 18-28
Character Set Scanner Operation 18-30
Character Set Scanner Command 18-31
Character Set Scanner Output 18-32
Character Conversion 18-35
Summary 18-37

19 Database Workspace Management
Objectives 19-2
What Is a Database Workspace? 19-3
How Does Workspace Manager Work? 19-4
Enabling Versioning on a Table 19-5
Changes Due to Versioning 19-6
The History Option 19-8
Guidelines for Enabling Versioning on Tables 19-9
Disabling Versioning on a Table 19-11
Workspace Savepoints 19-12
Create a Workspace 19-13
Assign Workspace: Associate a User 19-14
Example of Versioning Rows in a Table 19-15
Assign Workspace: Grant Privileges 19-16
Workspace Manager Locks 19-18
Freeze a Workspace 19-19
Roll Back a Workspace 19-20
Refresh a Workspace 19-21
Resolve Workspace Conflicts 19-22
Merge a Workspace 19-23
Enterprise Manager Interface 19-24
Workspace Metadata Views 19-26
Summary 19-28

20 Advanced Replication
Objectives  20-2
Extended Availability  20-3
Add New Master Site  20-4
Prepare_Instantiated_Master  20-6
When to Add New Masters Without Quiescing  20-7
Restrictions on Adding New Masters  20-8
Constraints SCNs  20-9
Multitier Materialized Views  20-10
Replication of Objects  20-11
Replicating Objects with Materialized Views  20-12
Monitoring and Managing Replication Environments  20-13
Job Queue Changes  20-14
Changes for Related Oracle 9i Features  20-15
Summary  20-16

__________________

①②⑧