사용자 도구

사이트 도구


study:oracle:10gadminii_index

Oracle 10g Administration Workshop II

Introduction

  1. Course Objectives
  2. How DBAs Spend Their Time
  3. Oracle Database 10g Manageability Goals
  4. Database Management Challenges
  5. Oracle Database 10g Solution: Self-Managing Database
  6. How Oracle Database 10g DBAs Spend Their Time
  7. Student Preface

Using Globalization Support

  1. Objectives
  2. Globalization Support Features
  3. Encoding Schemes
  4. Database Character Sets and National Character Sets
  5. Datetimes with Timezones
  6. Configuring the Database Local Timezone
  7. Configuring Datetime Formats
  8. Using Timezones
  9. Specifying Language-Dependent Behavior
  10. Specifying Language-Dependent Behavior for the Server
  11. Language and Territory Dependent Parameters
  12. Other NLS Server Parameters
  13. Specifying Language-Dependent Behavior for the Session
  14. Locale Variants
  15. Using NLS Parameters in SQL Functions
  16. Linguistic Sorting
  17. Using Linguistic Sorting
  18. Sorts That Are Not Case or Accent Sensitive
  19. Linguistic Comparisons
  20. Linguistic Index Support
  21. Customizing Linguistic Sorting
  22. Oracle Locale Builder
  23. Character Set Scanner Utilities
  24. Data Conversion Between Client and Server Character Sets
  25. NLS Data Conversion with Oracle Utilities
  26. NLS Data Conversion with Data Pump
  27. Obtaining Character Set Information
  28. Obtaining NLS Parameter Information
  29. Summary
  30. Practice Overview: Using Globalization Support Features
  31. Practice: Using Globalization Support Features
  32. Practice: Globalization Support

Controlling Access to the Oracle Listener

  1. Objectives
  2. Oracle Net Services Review
  3. Listener Password Authentication
  4. Setting Listener Password
  5. Setting Listener Password with Net Manager
  6. Set Password with lsnrctl Utility
  7. Controlling Database Access
  8. Oracle Net Services External Procedures
  9. Overview of the EXTPROC Agent
  10. PL/SQL Calling a C External Procedure
  11. Default Configuration for External Procedure Calls
  12. Modifying the Configuration for External Procedure Calls
  13. Remove Default EXTPROC Entry
  14. Configure a Dedicated Listener for External Procedure Calls
  15. Summary
  16. Practice Overview: Controlling Access to the Listener

Configuring Recovery Manager

  1. Objectives
  2. Recovery Manager Features
  3. Recovery Manager Components
  4. Media Management
  5. Using a Flash Recovery Area with RMAN
  6. Setting Parameters for RMAN
  7. RMAN Usage Considerations
  8. Connection Types with RMAN
  9. Starting RMAN
  10. Additional RMAN Command Line Arguments
  11. Configuring Persistent Settings for RMAN
  12. Configuring RMAN Settings Using EM
  13. Control File Autobackups
  14. Retention Policies
  15. Managing Persistent Settings
  16. Channel Allocation
  17. Automatic and Manual Channel Allocation
  18. Channel Control Options
  19. Summary
  20. Practice Overview: Configuring RMAN

Using Recovery Manager

  1. Objectives
  2. Issuing Recovery Manager Commands
  3. RMAN Command Overview
  4. RMAN Commands
  5. Job Command: Example
  6. The BACKUP Command
  7. Backup Constraints
  8. Parallelization of Backup Sets
  9. Compressed Backups
  10. Image Copy
  11. Tags for Backups and Image Copies
  12. BACKUP Options
  13. Backing Up Archived Redo Logs
  14. Copying the Whole Database
  15. Making Incremental Backups
  16. Incremental Backup: Example
  17. Block Change Tracking
  18. Enabling Block Change Tracking
  19. Incrementally Updating Backups
  20. LIST Command Operations
  21. The REPORT Command
  22. The REPORT NEED BACKUP Command
  23. REPORT NEED BACKUP: Examples
  24. REPORT OBSOLETE and DELETE OBSOLETE
  25. Managing Backups with EM
  26. RMAN Dynamic Views
  27. Monitoring RMAN Backups
  28. Summary
  29. Practice Overview: Using RMAN

Diagnostic Sources

  1. Objectives
  2. Diagnostic Files
  3. The Alert Log
  4. What Is in the alert.log File
  5. Viewing Recent Alert Log Entries
  6. Alert Models Architecture
  7. Server-Generated Alert Types
  8. Viewing Alerts with Enterprise Manager
  9. Alerts Notification
  10. Alert Log Monitoring Configuration
  11. Editing Thresholds
  12. Viewing Initialization Parameters
  13. Trace Files
  14. Specifying the Location of Trace Files
  15. Controlling Trace File Size
  16. Controlling Trace File Writes
  17. Using Enterprise Manager to Enable and View SQL Tracing
  18. System Log Files
  19. Summary
  20. Practice Overview: Diagnosing Problems

Recovering from Noncritical Losses

  1. Objectives
  2. Recovery of Noncritical Files
  3. Creating New Temporary Tablespace
  4. Re-creating Redo Log Files
  5. Recovering an Index Tablespace
  6. Re-creating Indexes
  7. Read-only Tablespace Recovery
  8. Read-only Tablespace Recovery Issues
  9. Authentication Methods for Database Administrators
  10. Loss of Password Authentication File
  11. Summary
  12. Practice Overview: Re-creating a Temporary Tablespace
  13. Practice: Re-creating the Temp Tablespace

Database Recovery

  1. Objectives
  2. Recovery Steps
  3. Server Managed Recovery: RESTORE and RECOVER Commands
  4. User-Managed Recovery Procedures:RECOVER Command
  5. Recovering a Control File Autobackup
  6. Creating a New Control File
  7. Incomplete Recovery Overview
  8. Situations Requiring Incomplete Recovery
  9. Types of Incomplete Recovery
  10. Incomplete Recovery Best Practices
  11. Using RECOVER for Incomplete Recovery
  12. UNTIL TIME Recovery Example
  13. UNTIL TIME Recovery Steps
  14. Cancel-Based Recovery: Example
  15. Incomplete Recovery and the Alert Log
  16. Incomplete Recovery of a Database Using RMAN
  17. RMAN Incomplete Recovery UNTIL TIME: Example
  18. RMAN Incomplete Recovery UNTIL SEQUENCE: Example
  19. Recovery Using Enterprise Manager
  20. Simplified Recovery Through RESETLOGS
  21. Recovery Through RESETLOGS: Changes
  22. Summary
  23. Practice Overview: Incomplete Recovery

Flashback Database

  1. Objectives
  2. Flashback Any Error
  3. Flashback Technology Benefits
  4. When to Use Flashback Technology
  5. Flashback Database Overview
  6. Flashback Database Reduces Restore Time
  7. Flashback Database Architecture
  8. Configuring Flashback Database
  9. Configure Flashback Database with EM
  10. Monitoring Flashback Database
  11. Monitoring Flashback Database with EM
  12. Best Practices for the Database and Flash Recovery Area
  13. Backing Up the Flash Recovery Area
  14. Flash Recovery Area Space Usage
  15. Flashback Database Examples
  16. Flashback Database with EM
  17. Excluding Tablespaces from Flashback Database
  18. Flashback Database Considerations
  19. Summary
  20. Practice Overview: Flashback Database

Recovering from User Errors

  1. Objectives
  2. Flashback Time Navigation
  3. Flashback Drop Overview
  4. Recycle Bin
  5. Querying the Recycle Bin
  6. Flashback Dropped Tables Using EM
  7. Restoring Objects from the Recycle Bin
  8. Recycle Bin Automatic Space Reclamation
  9. Recycle Bin Manual Space Reclamation
  10. Bypassing the Recycle Bin
  11. Querying Dropped Tables
  12. Flashback Drop Considerations
  13. Flashback Versions Query Overview
  14. Flashback Versions Query Using EM
  15. Flashback Versions Query Syntax
  16. Flashback Versions Query Example
  17. Flashback Versions Query Considerations
  18. Flashback Transaction Query Overview
  19. Querying FLASHBACK_TRANSACTION_QUERY
  20. Using Flashback Versions Query and Flashback Transaction Query
  21. Flashback Transaction Query Using EM
  22. Flashback Transaction Query Considerations
  23. Flashback Table Overview
  24. Using EM to Flashback Tables
  25. Flashback Table Example
  26. Rolling Back a Flashback Table Operation
  27. Flashback Table Considerations
  28. Guaranteed Undo Retention
  29. SCN and Time Mapping Enhancements
  30. Summary
  31. Practice Overview: Recovering from User Errors

Dealing with Database Corruption

  1. Objectives
  2. What Is Block Corruption?
  3. Block Corruption Symptoms: ORA-1578
  4. DBVERIFY Utility
  5. Interpreting DBVERIFY
  6. The ANALYZE Command
  7. Initialization Parameter DB_BLOCK_CHECKING
  8. How to Handle Corruptions
  9. Using Flashback for Logical Corruption
  10. The DBMS_REPAIR Package
  11. Using DBMS_REPAIR
  12. Block Media Recovery (BMR)
  13. The BLOCKRECOVER Command
  14. RMAN BMR Interface
  15. Examples of BLOCKRECOVER
  16. Which Object Is Corrupted?
  17. Summary
  18. Practice Overview: Dealing with Database Corruption

Automatic Management

  1. Objectives
  2. Oracle Wait Events
  3. System Statistics
  4. Displaying Session-Related Statistics
  5. Troubleshooting and Tuning Views
  6. Statistics Collection
  7. Automatic Optimizer Statistics Collection: Overview
  8. Dictionary and Special Views
  9. Statspack
  10. Workload Repository
  11. AWR Snapshot Baselines
  12. Advisory Framework Overview
  13. Database Control and Advisors
  14. Typical Advisor Tuning Session
  15. Manually Invoking ADDM
  16. Application Tuning Challenges
  17. SQL Tuning Advisor Overview
  18. SQL Tuning Advisor Options and Recommendations
  19. Using the SQL Tuning Advisor
  20. Using the SQL Tuning Advisor: Example
  21. Using the SQL Access Advisor
  22. The Undo Management Page
  23. Automatic Undo Retention Tuning
  24. The Undo Advisor Page
  25. Summary
  26. Practice Overview: Optimizing Database Performance

Monitoring and Managing Storage

  1. Objectives
  2. Online Redo Log File Configuration
  3. Redo Logfile Sizing Advisor
  4. Increasing the Performance of Archiving
  5. Resumable Statements
  6. Using Resumable Space Allocation
  7. Resuming Suspended Statements
  8. Proactive Tablespace Monitoring Overview
  9. Tablespace Space Usage Monitoring
  10. Edit Tablespace Page
  11. Segment Advisor Overview
  12. Shrinking Segments: Overview
  13. Shrinking Segments: Considerations
  14. Database Control and Segment Shrink
  15. Accessing the Segment Advisor
  16. Segment Advisor
  17. Shrinking Segments Using SQL
  18. Segment Shrink: Execution Considerations
  19. Segment Resource Estimation
  20. Growth Trend Report
  21. Monitoring Index Space
  22. Monitoring Index Space Usage
  23. Deciding Whether to Rebuild or Coalesce an Index
  24. Identifying Unused Indexes
  25. Index-Organized Tables
  26. Index-Organized Tables and Heap Tables
  27. Creating Index-Organized Tables
  28. IOT Row Overflow
  29. Querying DBA_TABLES for IOT Information
  30. Querying DBA_INDEXES and DBA_SEGMENTS for IOT information
  31. Using a Mapping Table
  32. Maintaining a Mapping Table
  33. Clusters
  34. Cluster Types
  35. Situations Where Clusters Are Useful
  36. Sorted Hash Cluster: Example
  37. Summary
  38. Practice Overview: Managing Storage

Automatic Storage Management

  1. Objectives 14–2
  2. What Is Automatic Storage Management?
  3. ASM Key Features and Benefits
  4. ASM Concepts
  5. ASM General Architecture
  6. ASM Instance Functionalities
  7. ASM Instance Creation
  8. ASM Instance Initialization Parameters
  9. Accessing an ASM Instance
  10. Dynamic Performance View Additions
  11. ASM Home Page
  12. ASM Performance Page
  13. ASM Configuration Page
  14. Starting Up an ASM Instance
  15. Shutting Down an ASM Instance
  16. ASM Disk Groups
  17. Failure Group
  18. Disk Group Mirroring
  19. Disk Group Dynamic Rebalancing
  20. ASM Administration Page
  21. Create Disk Group Page
  22. Create or Delete Disk Groups
  23. Adding Disks to Disk Groups
  24. Miscellaneous Alter Commands
  25. Monitoring Long-Running Operations Using V$ASM_OPERATION
  26. ASM Files
  27. ASM Filenames
  28. ASM File Name Syntax
  29. ASM File Name Mapping
  30. ASM File Templates
  31. Template and Alias Examples
  32. Retrieving Aliases
  33. SQL Commands and File Naming
  34. DBCA and Storage Options
  35. Database Instance Parameter Changes
  36. Migrating Your Database to ASM Storage
  37. Summary
  38. Practice Overview: Using ASM

Monitoring and Managing Memory

  1. Objectives
  2. Oracle Memory Structures
  3. Oracle Memory Structures Buffer Cache
  4. Using Multiple Buffer Pools
  5. Shared Pool
  6. Large Pool
  7. UGA and Oracle Shared Server
  8. Java Pool
  9. The Redo Log Buffer
  10. Automatic Shared Memory Management: Overview
  11. Benefits of Automatic Shared Memory Management
  12. SGA Tuning Principles
  13. Database Control and Automatic Shared Memory Management
  14. Manual Configuration
  15. Behavior of Auto-Tuned SGA Parameters
  16. Behavior of Manually Tuned SGA Parameters
  17. Using the V$PARAMETER View
  18. Resizing SGA_TARGET
  19. Disabling Automatic Shared Memory Management
  20. Manually Resizing Dynamic SGA Parameters
  21. Program Global Area (PGA)
  22. Automatic PGA Memory Management
  23. PGA Management Resources
  24. Using the Memory Advisor
  25. Summary
  26. Practice Overview: Automatic Shared Memory Management

Managing Resources

  1. Objectives
  2. Overview
  3. Database Resource Manager Concepts
  4. Resource Manager Configurations
  5. The Initial Plan: SYSTEM_PLAN
  6. Creating a New Resource Plan
  7. Creating a Simple Plan
  8. Oracle Enterprise Manager: Resource Manager
  9. Active Session Pool Mechanism
  10. Setting the Active Session Pool
  11. Maximum Estimated Execution Time
  12. Setting Idle Timeouts
  13. Switching Back to the Initial Consumer Group at End of Call
  14. Creating Resource Consumer Groups
  15. Assigning Users to Consumer Groups
  16. Automatic Consumer Group Switching
  17. Configuring Consumer Group Switching
  18. Adaptive Consumer Group Mapping
  19. Creating a Mapping Using DBMS_RESOURCE_MANAGER
  20. Assigning Priorities Using DBMS_RESOURCE_MANAGER
  21. Using Sub-Plans to Limit CPU Utilization
  22. Limiting CPU Utilization: Example
  23. Creating a Complex Plan
  24. Resource Allocation Methods for Resource Plans
  25. Comparison of EMPHASIS and RATIO
  26. Resource Allocation Methods for Consumer Groups
  27. Administering the Resource Manager
  28. Assigning Resource Manager Privileges
  29. Setting the Resource Plan for an Instance
  30. Viewing Resource Consumer Groups
  31. Changing a Consumer Group Within a Session
  32. Changing Consumer Groups for Sessions
  33. Database Resource Manager Information
  34. Resource Plan Directives
  35. Monitoring the Resource Manager
  36. Summary
  37. Practice Overview: Using the Resource Manager

Automating Tasks with the Scheduler

  1. Objectives
  2. Scheduling Needs
  3. Scheduler Concepts
  4. Privileges for Scheduler Components
  5. Creating a Scheduler Job
  6. Creating a Scheduler Job: Example
  7. Setting the Repeat Interval for a Job
  8. Calendaring Expressions
  9. Using Scheduler Programs
  10. Creating a Program Using EM
  11. Specifying Schedules for a Job
  12. Creating and Using Schedules
  13. Using EM to Create Schedules
  14. Advanced Scheduler Concepts
  15. Creating a Job Class
  16. Job Logging
  17. Creating a Window
  18. Prioritizing Jobs Within a Window
  19. Enabling and Disabling Scheduler Components
  20. Managing Jobs
  21. Managing Programs
  22. Managing Programs with EM
  23. Managing Schedules
  24. Managing Windows
  25. Window Priority
  26. Managing Attributes of Scheduler Components
  27. Managing Attributes of the Scheduler
  28. Viewing Job Execution Details
  29. Viewing Job Logs
  30. Purging Job Logs
  31. Data Dictionary Views
  32. Summary
  33. Practice Overview: Automating Tasks with the Scheduler
  34. Practice: Using the Scheduler

Workshop

  1. Objectives
  2. Workshop Methodology
  3. Business Requirements
  4. Database Configuration
  5. Simulated Application
  6. Method for Resolving Database Issues
  7. Summary
  8. Practice Overview: Workshop Setup
  9. Practice Workshop Setup
  10. Workshop Scenario 1
study/oracle/10gadminii_index.txt · 마지막으로 수정됨: 2008/04/22 10:53 저자 starlits