administration guide 11g(15)

oracle 11g管理篇

Capacity Planning for Database Objects .......................................................................................19-32 Estimating the Space Use of a Table ..........................................................................................19-32 Estimating the Space Use of an Index .......................................................................................19-33 Obtaining Object Growth Trends ..............................................................................................19-33 20 Managing Tables

About Tables...........................................................................................................................................20-1 Guidelines for Managing Tables........................................................................................................20-2 Design Tables Before Creating Them...........................................................................................20-2 Specify the Type of Table to Create..............................................................................................20-3 Specify the Location of Each Table...............................................................................................20-4 Consider Parallelizing Table Creation.........................................................................................20-4 Consider Using NOLOGGING When Creating Tables ............................................................20-4 Consider Using Table Compression.............................................................................................20-5 Consider Encrypting Columns That Contain Sensitive Data.................................................20-12 Understand Deferred Segment Creation...................................................................................20-13 Materializing Segments................................................................................................................20-15 Estimate Table Size and Plan Accordingly................................................................................20-16 Restrictions to Consider When Creating Tables.......................................................................20-16 Creating Tables....................................................................................................................................20-17 Example: Creating a Table...........................................................................................................20-17 Creating a Temporary Table........................................................................................................20-18 Parallelizing Table Creation........................................................................................................20-19 Loading Tables.....................................................................................................................................20-20 Methods for Loading Tables........................................................................................................20-20 Improving INSERT Performance with Direct-Path INSERT..................................................20-21 Using Conventional Inserts to Load Tables..............................................................................20-26 Avoiding Bulk INSERT Failures with DML Error Logging...................................................20-26 Automatically Collecting Statistics on Tables...............................................................................20-30 Altering Tables.....................................................................................................................................20-30 Reasons for Using the ALTER TABLE Statement....................................................................20-31 Altering Physical Attributes of a Table......................................................................................20-32 Moving a Table to a New Segment or Tablespace...................................................................20-32 Manually Allocating Storage for a Table...................................................................................20-33 Modifying an Existing Column Definition................................................................................20-33 Adding Table Columns................................................................................................................20-33 Renaming Table Columns............................................................................................................20-34 Dropping Table Columns ...........................................................................................................20-34 Placing a Table in Read-Only Mode...........................................................................................20-36 Redefining Tables Online..................................................................................................................20-37 Features of Online Table Redefinition.......................................................................................20-38 Performing Online Redefinition with DBMS_REDEFINITION.............................................20-38 Results of the Redefinition Process.............................................................................................20-42 Performing Intermediate Synchronization................................................................................20-43 Aborting Online Table Redefinition and Cleaning Up After Errors.....................................20-43 Restrictions for Online Redefinition of Tables..........................................................................20-43 Online Redefinition of a Single Partition...................................................................................20-45 xvi