Chapter 1: New Features for Database Creation and Deletion
SYSAUX Tablespace
Automated Storage Management Configuration
Automated RAC Services Configuration
Simplified Upgrade for RAC and OPS Databases
Drop Database
Chapter 2: Database Tuning and Performance Improvements
Database Resource Manager Improvements
Database Resource Manager Overview
Adaptive Consumer Group Mapping
Fixed CPU Quota
Integration of Resource Manager and Profiles
Tuning Improvements
Buffer Cache Flushing - User Initiated
Automated Checkpoint Tuning
CPU Costing
Dynamic Sampling
Tuning Transaction Recovery
Easy Transaction Recovery Monitoring
Oracle Enterprise Manager Changes
Overview of the changes
SQL Reporting
New Performance Overview Charts
Single-Set Aggregates in DML Returning Clause
New and Updated Optimizer Hints
Wait Model Improvements
Overview of enhancements
Changes and updates
Application Tuning
Overview of improvements
SQL Access Advisor
Materialized View Tuning API - The new TUNE--MVIEW API
New Static Data Dictionary Views
Overview
List of Views and Explanation
New Dynamic Performance Views
Overview
List of Views
Static data dictionary views have new columns
Dynamic performance views have new columns
CHAPTER 3 - New Features for Tablespace Management
Temporary Tablespace
·
Temporary Tablespace Group Overview
·
Temporary Tablespace Group Benefits
·
Examples
Rename Tablespace
·
Tablespace Rename Overview
·
Tablespace Rename Benefits
·
Examples
Bigfile Tablespace
·
Bigfile Tablespace Overview
·
Bigfile Tablespace Benefits
·
Extended ROWID Format
·
Examples
Automated Storage Management (ASM)
·
Automated Storage Management Overview
·
Automated Storage Management Benefits
·
ASM Disk Group
·
ASM Disk
·
ASM Files
·
ASM Instance
Chapter 4: New Table and Index Features
Creating a Sorted Hash Cluster
Benefits
Examples
Partitioning Improvement
Overview of Improvements in Partitioning
Global Partitioned Indexes - Hash Partitioning
Enhancements for Partitioned Index-Organized Tables
- List Partitioning
- LOB Support
- Global Index Maintenance
Local Partitioned Indexes Manageability Improvements
Enhanced Partition Management in Enterprise Manager
Enhanced Bitmap Index Performance and Space Management
Chapter 5: New DML Features: Insert, Update and Delete
Single-Set Aggregates in DML Returning Clause
Upsert through SQL Interrow Calculations
Chapter 6: New SELECT features
SQLAccess Advisor
Materialized View Tuning API
Grouped Table Outer Join
Increased Number of Aggregates per Query
SQL Interrow Calculations
Remote Stored Functions in SELECT Statements
Native Net Over Fast Interconnects
Native Net Over TCP/IP
Case-Insensitive and Accent-Insensitive Query and Sort
Enhanced Collections
Enhanced CONNECT BY Support
Oracle Expression Filter
SQL Regular
Row Timestamp
Chapter 7: Improved Features: MERGE, EXTERNAL TABLES, MINSERT
Asynchronous Change Data
Cross-Platform Transportable Tablespaces
Enhanced Table Functions
External Tables Unload
Enhanced MERGE Functionality
CHAPTER 8 - New Initialization Parameters
Type of Initialization Parameters
Twenty New Parameters
CREATE--STORED--OUTLINES
DB--ALLOWED--LOGIN--VERSION
DB--FLASHBACK--RETENTION--TARGET
DB--RECOVERY--FILE--DEST
DB--RECOVERY--FILE--DEST--SIZE
DDL--WAIT--FOR--LICKS
INSTANCE--TYPE
LDAP--DIRECTORY--ACCESS
LOG--ARCHIVE--CONFIG
OSM--DISK--REPARIR--TIME
OSM--DISKGROUPS
OSM--DISKSTRING
OSM--POWER--LIMIT
PLSQL--OPTIMIZE--LEVEL
PLSQL--WARNINGS
RESUMABLE--TIMEOUT
SKIP--UNUSABLE--INDESES
SMTP--OUT--SERVER
SP--NAME
STREAMS--POOL--SIZE
Chapter 9 - New Management Features
Database Startup and Shutdown
Overview of enhancements
Database Automated Startup and Shutdown Configuration
Database Install
Simplified Database Install
Improvements in Auditing
Uniform Audit Trail
Extended SQL Support in FGA
Easier Database Registration
Unified User Model
Chapter 10 - Utilities Improvements
Data Pump Utilities
·
Data Pump Overview
·
Data Pump Benefits
·
Data Pump Export
·
Data Pump Export Examples
·
Data Pump Import
·
Data Pump Import Examples
SQL*Loader Improvements
·
Direct Path Support for ROWID Datatype
·
Direct Path Support for VARRAY Datatype
·
Direct Path Support for XML Type Tables
SQL*Plus Enhancements
·
Session Configuration
·
SQL Prompt Runtime Variable Substitution
·
DESCRIBE Command Improvements
·
SPOOL Command Improvements
·
Show Recycle Bin
·
SQL*Plus Compatibility
iSQL*Plus Enhancements
·
Input Prompting
·
Command Changes
New Scheduler Utilities
·
Introduction to Scheduler
·
Scheduler Architecture
·
Program and Job Concepts
·
Managing Jobs and Programs
·
Data Dictionary View for Scheduler
·
Examples
Chapter 11: New Network Features
Back Up Directory Naming Entries to Local Naming File
Dynamic Connection Manager Configuration
Easy Connect Naming Method
Easy OCI/JDBC Install
Improved Network Outage Detection
Simplified Directory Usage Configuration
Improved Connection Manager Access Rules
Automated Shared Server Configuration
Simplified Shared Server Configuration Parameters
Certificate Validation with Certificate Revocation Lists (CRLs)
Centralized CRL Management
Centralized User Management for Kerberos Users
Kerberos-Enabled Database Links
Operating System Credential Cache
Access to Single Sign On Wallet
Key Store Interface
End-to-End Identity Propagation
Database Authentication with Standard LDAP Password Verifiers
Single Station Administration for Password Authentication to Oracle Database
Smart Card Support for X509v3 Certificates
.Transport Layer Security (TLS) Support
SSL Session Renegotiation
Performance Improvements
4096-Bit Key Size Support
Chapter 12 - Backup and Recovery New Features
Extended Flashback Functions
·
Flashback Database
·
Flashback Standby Database
·
Flashback Re-instantiation
·
Flashback Drop
·
Flashback Table
·
Flashback Row History
·
Flashback Transaction History
RMAN Enhancements
·
Automated Channel Failover for Backup and Restore
·
Automated File Creation During Recovery
·
Simplified Backups to Disk
·
Proxy Copy Backup of Archivelogs
·
Incrementally Updated Backups
·
Simplified Recovery Through Resetlogs
·
Restore Tolerates Corrupt or Missing Backups
·
Full Database Begin Backup Command
·
Change-Aware Incremental Backups
·
Automated Disk-Based Backup and Recovery
·
RMAN Database Deregistration
·
Backup of Standby Control File
·
Automated TSPITR Instantiation
·
Simplified Recovery Manager Cataloging of Backup Files
Chapter 13 - High Availability Improvements
Log Miner
Overview of the improvements
Automated LogMiner Configuration
Support for Index-Organized Tables
Support for Additional Types
LONG, Multibyte CLOB and NCLOB
Real Application Clusters
Overview of the Improvements
Data guard broker support
CRS (Cluster Ready Services)
workload management improvements
- manage, and monitor application workloads as a service
Improved Streams RAC Support
- supports hot mining,
- automatically restart processes after failover
- supplemental logging
Installtion and configuration
- Overview of the improvements
- Changes to OUI
- Changes to DBCA
- suppot for ASM
- Support for OMF
- Virtual Internet Protocol Assistant (VIPCA)
Improvements to adding a node
Support for rolling upgrades for one-off patches
- using Cluster File System
Optimizing the Cache Fusion
- Dynamic affinity policy enhancements
Enhancements to SRVCTL utility
New Cluster Database Management Tools
OEM enhancements
Data Guard
Simplified Zero Data Loss for Data Guard SQL Apply
Real Time Apply
Named Data Guard Configurations
Secured Redo Transmission
Zero Downtime Instantiation for SQL Apply
Supplemental Logging
Fine-Grained
Enhanced Online Redefinition
Improved Handling of DDL Locks on Busy Tables
Signature-Based Dependency Tracking Using Synonyms
Chapter 14 - Oracle Streams
Overview of Streams
Batch Enqueue/Dequeue
Downstream Capture
Downstream Capture Overview
Creating a Downstream Capture Process
Performance Enhancements for greater work loads
Enhanced Capture and Apply Performance
Performance Enhancements for AnyData Queues, Rules, and Propagation
Updates to the Rules
Easy Rules Engine Transformation Management
Negative Rules
Tuning Rules
Improved Enqueue Handler
Access to Additional LCR Attributes
Row Subsetting
Additional Support
for Long and NCLOB datatypes
for IOT Support
High-Level API for Message Queuing
LCR.EXECUTE procedure improvements
Streams packaged procedures Enhancements
Set Instantiation SCN at Apply Site
Clean Up Rules Sets
Instantiation Through Transportable Tablespaces
New APIs to Grant Privileges
Improved Capture and Apply Error Handling
Methods for providing faster instantiation
Using RMAN
Expose Commit Order of Changes
Advanced Replication to Streams Migration Tool
Improved Monitoring methods
Better interoperation with Oracle RAC
capture changes from redo log as well as the archived redo log
automatic transfer of the queue
New streams related dynamic performance views
New streams related initialization parameters
Chapter 15: Security Enhancements
VPD Support for Parallel Query
VPD Static and Dynamic Policies
Column-level VPD
Chapter 16 - Business Intelligence
Data Warehousing Enhancements
Interrow Calculations
SQLAccess Advisor tool
DBMS--ADVISOR package
for Indexing
for materialized view
Partitioning Enhancements
partitioning for index-organized tables.
partitioning materialized views in OLAP
Hash-partitioned global indexes.
ETL Enhancements
SQL Support for Analytic Applications
Grouped Table Outer Join
Size of aggregations in a single SQL statement.
SQL Inter-row Calculations
Summary Management
Enhanced Partition-aware Materialized View Refresh
EXPLAIN PLAN Shows Materialized View Access The
Enhanced Dimensions
Nested Materialized View Refresh Materialized
Enhanced PCT Refresh Partition
Query Rewrite Uses Multiple Materialized Views
New OLAP capabilities
Parallel AGGREGATE Command
Parallel SQL IMPORT Command
PL/SQL Creation of Analytic Workspaces
Intra-Dimensional (Attribute) Aggregation
Enhanced Composite Dimensions Indexing
PL/SQL OLAP Measure Calculation Definition
Complete Analytical Workspace Management
Multi-Writer Support
XML Interface for Analytic Workspace
Support for Bioinformatics
DOUBLE and FLOAT Datatypes
Blast Queries
Statistical Functions
Document Clustering
Document Named Entity Extraction
Support Vector Machines
Document Clustering Non-negative Matrix Factorization
Document Clustering Neural Nets
Taxonomy Builder
Data Mining for Analytical
Attribute Importance Algorithms
Enhanced Data Preprocessing
PMML Producers / Consumers
Data Mining Rapid Application Development
Multi-User Access Control
JSR-73 RI & TCK (Java Data Mining)
Complete Oracle Data Mining Management GUI
Enhanced Adaptive Bayes Network
Enhanced Model Seeker
Chapter 17: Globalization Improvements
Globalization Development Kit
Enhanced Character Set Scanner and Converter
CLOB and NCLOB Implicit Conversions
Unicode 3.2 Support
Expanded Locale Coverage
Please note that the correct name for the new Oracle Database is 'Oracle Database 10g'. Incorrect
references to the new Oracle Database 10g include: Oracle Database 10g, Oracle 10g, Oracle Database10 g, OracleDB 10g, The Oracle Database 10g, Oracle
RAC 10g, Oracle10g.
