| |
| |
| Acknowledgements | |
| |
| |
| Introduction | |
| |
| |
| |
| Getting Started | |
| |
| |
| Welcome to Oracle Database 10g and the "Grid" | |
| |
| |
| Upgrading to Oracle Database 10g | |
| |
| |
| The DBUA | |
| |
| |
| Performing Manual Upgrades | |
| |
| |
| About the compatible Parameter | |
| |
| |
| The Database Configuration Assistant | |
| |
| |
| The SYSAUX Tablespace | |
| |
| |
| Introducing the SYSAUX Tablespace | |
| |
| |
| Managing Occupants of the SYSAUX Tablespace | |
| |
| |
| Automatic Storage Management | |
| |
| |
| ASM Features | |
| |
| |
| The ASM Instance | |
| |
| |
| Setting Up ASM Disks | |
| |
| |
| Addressing ASM Disks | |
| |
| |
| ASM and Data Dictionary Views | |
| |
| |
| Oracle Database 10g Real Application Clusters | |
| |
| |
| Portable Clusterware | |
| |
| |
| Rolling Upgrades | |
| |
| |
| Cluster Ready Services | |
| |
| |
| Database Assistants | |
| |
| |
| The gcs_server_processes Parameter | |
| |
| |
| |
| Server Manageability | |
| |
| |
| Statistics Collection | |
| |
| |
| Automated Statistics Collection | |
| |
| |
| Collecting Data Dictionary Statistics | |
| |
| |
| New DBMS_STATS Behaviors | |
| |
| |
| New Table-Monitoring Behaviors | |
| |
| |
| Flushing the Buffer Cache | |
| |
| |
| Database Resource Manager New Features | |
| |
| |
| Reverting Back to the Original Consumer Group | |
| |
| |
| Setting the Idle Timeout | |
| |
| |
| Creating Mappings for Automatic Assignment of Sessions to Consumer Groups | |
| |
| |
| Scheduler Changes | |
| |
| |
| Overview of The Scheduler | |
| |
| |
| Practical Use of The Scheduler | |
| |
| |
| User-Configurable Default Tablespaces | |
| |
| |
| Tablespace Groups and Multiple Default Temporary Tablespaces | |
| |
| |
| Assigning Temporary Tablespaces to Tablespace Groups | |
| |
| |
| Defining a Tablespace Group as the Default Temporary Tablespace | |
| |
| |
| Tablespace Group Data Dictionary View | |
| |
| |
| Renaming Tablespaces | |
| |
| |
| Dropping Databases | |
| |
| |
| Larger LOBs | |
| |
| |
| Automatic Undo Retention | |
| |
| |
| Shrinking and Compacting Segments Online | |
| |
| |
| Using New Online Redefinition Features | |
| |
| |
| |
| Performance Tuning | |
| |
| |
| Improvements to the Wait Interface | |
| |
| |
| Changes to the V$EVENT_NAME View | |
| |
| |
| New Wait Information in V$SESSION | |
| |
| |
| Using V$SESSION to Find Blocking Sessions | |
| |
| |
| The V$SESSION_WAIT_HISTORY View | |
| |
| |
| V$SESSION_WAIT_CLASS and V$SYSTEM_WAIT_CLASS Views | |
| |
| |
| New Histogram Views | |
| |
| |
| The Database Common Management Infrastructure | |
| |
| |
| CMI Architecture Overview | |
| |
| |
| The Automatic Workload Repository | |
| |
| |
| Server-Based Advisors | |
| |
| |
| Server-Generated Alerts | |
| |
| |
| Automatic SGA Tuning | |
| |
| |
| Self-Tuning Checkpointing | |
| |
| |
| New Oracle Database 10g Trace Functionality | |
| |
| |
| Sorted Hash Clusters | |
| |
| |
| Example of Using a Sorted Hash Cluster | |
| |
| |
| Shared Server Changes | |
| |
| |
| Changes to Shared Server Configuration | |
| |
| |
| MTS Parameters Obsoleted | |
| |
| |
| The V$DISPATCHER_CONFIG View | |
| |
| |
| Tracing Shared Server Sessions | |
| |
| |
| |
| Security | |
| |
| |
| Virtual Private Database New Features | |
| |
| |
| Column-Level Privacy | |
| |
| |
| New VPD Policies | |
| |
| |
| VPD Support for Oracle Parallel Query | |
| |
| |
| Oracle Database 10g Auditing New Features | |
| |
| |
| New Columns in DBA_AUDIT_TRAIL | |
| |
| |
| Fine-Grained Auditing New Features | |
| |
| |
| Directory (LDAP) Based New Features | |
| |
| |
| |
| Availability and Recoverability | |
| |
| |
| General Database Recovery Improvements | |
| |
| |
| Easier Recovery Through the resetlogs Command | |
| |
| |
| Changes to the alter database archivelog Command | |
| |
| |
| New and Changed Oracle Database 10g Database Backup Commands | |
| |
| |
| RMAN Improvements | |
| |
| |
| Using the Flash Recovery Area | |
| |
| |
| Using Backup Copies and Fast Recovery | |
| |
| |
| Use RMAN to Back Up the Current Control File | |
| |
| |
| Using the catalog and uncatalog Commands | |
| |
| |
| Dropping a Database in RMAN | |
| |
| |
| Unregistering a Database in RMAN | |
| |
| |
| Changes to Incremental Backups | |
| |
| |
| Recovering Datafiles Not Backed Up | |
| |
| |
| Automatic Channel Failover | |
| |
| |
| Compressing RMAN Backups | |
| |
| |
| Controlling Backup Rates and Duration | |
| |
| |
| New Flashback Features | |
| |
| |
| Flashback Database | |
| |
| |
| Flashback Drop | |
| |
| |
| Flashback Versions Query | |
| |
| |
| Configuring Guaranteed Undo Retention | |
| |
| |
| Flashback Transaction Query | |
| |
| |
| Flashback Table | |
| |
| |
| New Transaction Recovery Monitoring Features | |
| |
| |
| New Data Guard Features | |
| |
| |
| Apply Redo in Real Time | |
| |
| |
| The valid_for Attribute | |
| |
| |
| Redo Transmission Enhancements | |
| |
| |
| New Standby Database Parameters | |
| |
| |
| Changes to Standby Database Startups | |
| |
| |
| ARCH Process Writes to Standby Redo Logs | |
| |
| |
| Assign Threads to Standby Redo Log Groups | |
| |
| |
| Logical Standby Database Enhancements | |
| |
| |
| |
| Business Intelligence | |
| |
| |
| Oracle Data Pump | |
| |
| |
| Oracle Data Pump Architecture | |
| |
| |
| Data Pump Data Dictionary Views | |
| |
| |
| Data Pump Interactive Mode | |
| |
| |
| Data Pump API | |
| |
| |
| Data Pump Export | |
| |
| |
| Data Pump Import | |
| |
| |
| Bigfile Tablespaces | |
| |
| |
| What Are Bigfile Tablespaces? | |
| |
| |
| Why Bigfile Tablespaces? | |
| |
| |
| Bigfile Tablespace Management | |
| |
| |
| Bigfile Tablespaces and Extended ROWIDs | |
| |
| |
| Cross-Platform Transportable Tablespaces | |
| |
| |
| Introduction to Cross-Platform Transportable Tablespaces | |
| |
| |
| Datafile Byte Ordering: Endian Formats | |
| |
| |
| Enhanced Merge Functionality | |
| |
| |
| New merge Conditional Clauses and Extensions | |
| |
| |
| Optional delete Clause in the merge Statement | |
| |
| |
| Enhanced External Table Functionality | |
| |
| |
| Writing to External Tables | |
| |
| |
| Projecting Columns in External Tables | |
| |
| |
| New Materialized View, Query Rewrite, and Summary Management DDL Features | |
| |
| |
| Partition Change Tracking Enhancements | |
| |
| |
| Query Rewrite Enhancements | |
| |
| |
| Mview Fast Refresh Enhancements | |
| |
| |
| Summary Management DDL Enhancements | |
| |
| |
| New Partitioning Features | |
| |
| |
| Index-Organized Table Partitioning Improvements | |
| |
| |
| Hash-Partitioned Global Indexes | |
| |
| |
| Partitioned Index Maintenance | |
| |
| |
| Skipping Unusable Indexes | |
| |
| |
| |
| Application Development | |
| |
| |
| Bulk Bind Improvements | |
| |
| |
| Processing Sparse Collections | |
| |
| |
| Exception Handling | |
| |
| |
| SQL and PL/SQL Regular Expressions | |
| |
| |
| What Are Regular Expressions? | |
| |
| |
| Using Regular Expressions in Oracle Database 10g | |
| |
| |
| Case- and Accent-Insensitive Searches | |
| |
| |
| User-Specified Quote Character Assignment | |
| |
| |
| PL/SQL New Packages of Note | |
| |
| |
| The utl_compress Package | |
| |
| |
| The utl_mail Package | |
| |
| |
| Other New PL/SQL Packages | |
| |
| |
| Oracle Collections | |
| |
| |
| Creating Temporary Tables with VARRAY Columns | |
| |
| |
| Changing the VARRAY Size | |
| |
| |
| Defining the Tablespace of a Nested Table | |
| |
| |
| ANSI Support for Nested Tables and VARRAY Columns | |
| |
| |
| The PL/SQL Compiler | |
| |
| |
| New PL/SQL Compiler | |
| |
| |
| Natively Compiled PL/SQL New Features | |
| |
| |
| Fine-Grained Debug Privileges | |
| |
| |
| PL/SQL Compile-Time Warnings | |
| |
| |
| Improvements to the dbms_profiler Procedure | |
| |
| |
| Table Function Enhancements | |
| |
| |
| New Connect String Format | |
| |
| |
| |
| Other Database New Features | |
| |
| |
| Calling Remote Stored Procedures | |
| |
| |
| Workspace Manager Enhancements | |
| |
| |
| New Functionality in the dbms_wm Package | |
| |
| |
| Multiparent Workspaces | |
| |
| |
| Workspace Manager Events | |
| |
| |
| Exporting, Importing, and Loading Versioned Data | |
| |
| |
| Workspace Continuous Refresh | |
| |
| |
| Other Improvements for Workspace Manager | |
| |
| |
| Streams Enhancements | |
| |
| |
| SQL Plus Enhancements | |
| |
| |
| Enhancements to the describe Command | |
| |
| |
| Enhancements to the spool Command | |
| |
| |
| Changes to the Behavior of the SQL Plus Profile Files | |
| |
| |
| New define Variables | |
| |
| |
| Capability to Do Variable Substitution at the SQL Prompt | |
| |
| |
| The New SQL Plus compatibility Command | |
| |
| |
| Support for Whitespace in File- and Pathnames | |
| |
| |
| Other SQL Plus Enhancements and New Features | |
| |
| |
| SQL Language New Features | |
| |
| |
| Data Type Enhancements | |
| |
| |
| Moving Data from BFILEs to a LOB | |
| |
| |
| LOBs and the before row insert Trigger | |
| |
| |
| New Functionality for the returning Clause | |
| |
| |
| SQL Modeling | |
| |
| |
| Using Aggregates in the returning Clause | |
| |
| |
| Grouped Table Outer Joins | |
| |
| |
| Removal of Aggregate and SQL Statement Length Limitations | |
| |
| |
| New connect by Functionality | |
| |
| |
| Example Using connect_by_iscycle | |
| |
| |
| Example Using connect_by_isleaf | |
| |
| |
| Example Using connect_by_root | |
| |
| |
| |
| Oracle Enterprise Manager 10g | |
| |
| |
| Introducing the Redesigned OEM Architecture | |
| |
| |
| Server Tier | |
| |
| |
| Client Tier | |
| |
| |
| Middle Tier | |
| |
| |
| Communication Components | |
| |
| |
| Changes to OEM Installation | |
| |
| |
| Grid Control | |
| |
| |
| Database Control | |
| |
| |
| Studio Control | |
| |
| |
| Connecting to OEM | |
| |
| |
| Key New Features in OEM | |
| |
| |
| Introducing the Revamped OEM Home Page | |
| |
| |
| Consolidated Management with Target Home Page | |
| |
| |
| Server-Generated Alerts | |
| |
| |
| Key New Management Features | |
| |
| |
| Provisioning | |
| |
| |
| Job Scheduler | |
| |
| |
| New OEM Administration and Maintenance Features | |
| |
| |
| Performance Tuning | |
| |
| |
| OEM Grid Control | |
| |
| |
| Top Sessions | |
| |
| |
| Top SQL Assessment | |
| |
| |
| Introducing Oracle EM2Go | |
| |
| |
| EM2Go Home Page | |
| |
| |
| Other New OEM Related Features | |
| |
| |
| Baselining | |
| |
| |
| History | |
| |
| |
| Oracle Data Pump | |
| |
| |
| Related Links | |
| |
| |
| Alert Log Viewer | |
| |
| |
| |
| Oracle Database 10g New Processes | |
| |
| |
| Index | |