administration guide 11g(14)

oracle 11g管理篇

Integrity Constraint States ..........................................................................................................18-10 Setting Integrity Constraints Upon Definition..........................................................................18-11 Modifying, Renaming, or Dropping Existing Integrity Constraints.....................................18-12 Deferring Constraint Checks.......................................................................................................18-14 Reporting Constraint Exceptions................................................................................................18-14 Viewing Constraint Information.................................................................................................18-16 Renaming Schema Objects................................................................................................................18-16 Managing Object Dependencies......................................................................................................18-17 About Object Dependencies and Object Invalidation..............................................................18-17 Manually Recompiling Invalid Objects with DDL...................................................................18-18 Manually Recompiling Invalid Objects with PL/SQL Package Procedures........................18-19 Managing Object Name Resolution................................................................................................18-19 Switching to a Different Schema.....................................................................................................18-21 Managing Editions..............................................................................................................................18-21 About Editions and Edition-Based Redefinition......................................................................18-21 DBA Tasks for Edition-Based Redefinition...............................................................................18-22 Setting the Database Default Edition.........................................................................................18-22 Querying the Database Default Edition.....................................................................................18-22 Setting the Edition Attribute of a Database Service.................................................................18-23 Using an Edition............................................................................................................................18-24 Editions Data Dictionary Views..................................................................................................18-24 Displaying Information About Schema Objects..........................................................................18-24 Using a PL/SQL Package to Display Information About Schema Objects..........................18-25 Schema Objects Data Dictionary Views.....................................................................................18-25 19 Managing Space for Schema Objects

Managing Tablespace Alerts...............................................................................................................19-1 Setting Alert Thresholds................................................................................................................19-2 Viewing Alerts.................................................................................................................................19-3 Limitations.......................................................................................................................................19-3 Managing Resumable Space Allocation...........................................................................................19-4 Resumable Space Allocation Overview.......................................................................................19-4 Enabling and Disabling Resumable Space Allocation...............................................................19-7 Using a LOGON Trigger to Set Default Resumable Mode.......................................................19-8 Detecting Suspended Statements..................................................................................................19-8 Operation-Suspended Alert.........................................................................................................19-10 Resumable Space Allocation Example: Registering an AFTER SUSPEND Trigger............19-10 Reclaiming Wasted Space..................................................................................................................19-12 Understanding Reclaimable Unused Space..............................................................................19-12 Using the Segment Advisor.........................................................................................................19-12 Shrinking Database Segments Online........................................................................................19-26 Deallocating Unused Space.........................................................................................................19-28 Dropping Unused Object Storage....................................................................................................19-28 Understanding Space Usage of Data Types...................................................................................19-29 Displaying Information About Space Usage for Schema Objects............................................19-29 Using PL/SQL Packages to Display Information About Schema Object Space Usage......19-29 Schema Objects Space Usage Data Dictionary Views..............................................................19-30

xv