oracle 11g管理篇

Migrating to Automatic Undo Management..................................................................................16-11 Undo Space Data Dictionary Views................................................................................................16-11

17 Using Oracle Managed Files

What Are Oracle Managed Files?.......................................................................................................17-1 Who Can Use Oracle Managed Files?..........................................................................................17-2 Benefits of Using Oracle Managed Files......................................................................................17-3 Oracle Managed Files and Existing Functionality......................................................................17-3 Enabling the Creation and Use of Oracle Managed Files.............................................................17-3 Setting the DB_CREATE_FILE_DEST Initialization Parameter...............................................17-4 Setting the DB_RECOVERY_FILE_DEST Parameter.................................................................17-5 Setting the DB_CREATE_ONLINE_LOG_DEST_n Initialization Parameters.......................17-5 Creating Oracle Managed Files..........................................................................................................17-5 How Oracle Managed Files Are Named......................................................................................17-6 Creating Oracle Managed Files at Database Creation...............................................................17-7 Creating Datafiles for Tablespaces Using Oracle Managed Files..........................................17-12 Creating Tempfiles for Temporary Tablespaces Using Oracle Managed Files....................17-14 Creating Control Files Using Oracle Managed Files................................................................17-15 Creating Redo Log Files Using Oracle Managed Files............................................................17-16 Creating Archived Logs Using Oracle Managed Files............................................................17-17 Operation of Oracle Managed Files.................................................................................................17-17 Dropping Datafiles and Tempfiles.............................................................................................17-18 Dropping Redo Log Files.............................................................................................................17-18 Renaming Files..............................................................................................................................17-18 Managing Standby Databases ....................................................................................................17-19 Scenarios for Using Oracle Managed Files....................................................................................17-19 Scenario 1: Create and Manage a Database with Multiplexed Redo Logs...........................17-19 Scenario 2: Create and Manage a Database with Database and Fast Recovery Areas........17-22 Scenario 3: Adding Oracle Managed Files to an Existing Database......................................17-23

Part III Schema Objects

18 Managing Schema Objects

Creating Multiple Tables and Views in a Single Operation.........................................................18-1 Analyzing Tables, Indexes, and Clusters..........................................................................................18-2 Using DBMS_STATS to Collect Table and Index Statistics.......................................................18-2 Validating Tables, Indexes, Clusters, and Materialized Views................................................18-3 Listing Chained Rows of Tables and Clusters............................................................................18-4 Truncating Tables and Clusters..........................................................................................................18-5 Using DELETE.................................................................................................................................18-6 Using DROP and CREATE............................................................................................................18-6 Using TRUNCATE..........................................................................................................................18-6 Enabling and Disabling Triggers.......................................................................................................18-7 Enabling Triggers............................................................................................................................18-9 Disabling Triggers...........................................................................................................................18-9 Managing Integrity Constraints.........................................................................................................18-9 xiv