SUSE LINUX Enterprise Server 9 Administrators Handbook
SUSE LINUX Enterprise Server 9 Administrators Handbook
ISBN: 672327910
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 214
Pages: 214
Authors: Peter Kuo, Jacques Beland
- Oracle Database 10g INSIDER SOLUTIONS
- Table of Contents
- Copyright
- Preface
- About the Authors
- Acknowledgments
- We Want to Hear from You
- Introduction
- Who Should Read This Book
- What You Need to Use This Book
- How This Book Is Organized
- About the Book s Sample Code
- Conventions Used in This Book
- PartI.Getting Started with Oracle Database 10g
- Chapter 1. Exploring Oracle Database 10g Architecture
- Overview of New Features
- Processes Beneath the Hood
- Memory Architecture
- Automatic Undo Management
- SQL Advisors
- Oracle s Suite of Other Advisors
- Flash Recovery Area
- Flashback Operations
- Improved Oracle Enterprise Manager
- Grid Technology Unveiled
- Summary
- Chapter 2. Installing Oracle Database 10g
- Installation Decisions
- Prerequisites
- Installing 10g on UNIXLinux
- Oracle Database 10g DBCA Overview
- Installing 10g on Windows
- Companion CD Installation and Patches (All Platforms)
- Installation Checklists
- Database and Binary Cloning
- Using Enterprise Manager for Cloning
- Migrating a Database from 8i or 9i
- Overview of Database Upgrade Assistant
- Applying Patches to Database Installations
- Uninstalling from a Failed Install
- Summary
- Chapter 3. Customizing Installation Options
- OEM and Automatic Alerts
- XML DB for XML Data Processing
- ConText and Other Options
- Setting Up RAC
- Managing Backups with RMAN
- Summary
- Chapter 4. Setting Up Automatic Storage Management
- Automatic Storage Management (ASM)
- Prerequisites for Using ASM
- Configuration Options
- Performing ASM Operations
- Avoiding ASM Pitfalls
- When and Where to Use ASM
- Summary
- PartII.Quick Wins Using Oracle Database 10g
- Chapter 5. Using Automatic Memory Management
- Introduction to Quick Wins
- What Is Automatic Shared Memory Management?
- Understanding Memory Advisor
- Automated Maintenance Tasks
- Memory Management Tips
- Scaling for Database Expansion
- ASMM Improvements in 10g Release 2
- Summary
- Chapter 6. Monitoring with Automatic Statistics Collection
- Automatic Statistics Collection Fundamentals
- Collecting and Analyzing Statistics
- Metrics Monitoring and Customization
- Using Database Alerts with Metrics
- Making the Most of Metrics and Statistics Collection
- New Features in Oracle Database 10g Release 2
- Summary
- Chapter 7. Managing Automatic Undo
- Using Automatic Undo Management
- Redo Log File Sizings
- Using Undo Advisor
- Guaranteeing Undo Availability
- Undo Tips from the Trenches
- Automatic Undo Management Improvements in Release 2
- Summary
- Chapter 8. Leveraging Automatic Segment Management
- Segment Management in Oracle Database 10g
- Making Segment Management Work for You
- Using Segment Advisor
- Intelligent Segment Resource Estimation
- Space-Management Tips and Tricks
- ASSM Improvements in Release 2
- Summary
- Chapter 9. Implementing Recovery Manager
- RMAN Basics
- New Features of RMAN
- Recovery Without Hurdles
- New Features in Oracle Database 10g Release 2
- Summary
- PartIII.Tuning Oracle Database 10g
- Chapter 10. Adopting a New Approach to Tuning
- A New Performance Philosophy
- New and Improved Views
- Time and Wait Model
- OEM and Tuning
- New Features in Oracle Database 10g Release 2
- Summary
- Chapter 11. Effectively Using the Automatic Workload Repository
- Introducing the AWR
- Customizing the AWR
- Performing Baselining
- Active Session History
- New Features in Oracle Database 10g Release 2
- Summary
- Chapter 12. Effectively Using the Automatic Database Diagnostic Monitor
- Introduction to ADDM
- Interfacing to ADDM
- Making Sense of ADDM Data
- New Features in Oracle Database 10g Release 2
- Summary
- Chapter 13. Effectively Using the SQL Advisors
- Automating the SQL Advisors
- Using the Advisors for Tuning
- Avoiding Advisor Pitfalls
- New Features in Oracle Database 10g Release 2
- Summary
- Chapter 14. Influencing the Cost Based Optimizer
- New Optimizer Improvements
- SQL Profiles
- Effective Use of Histograms
- New Features in Oracle Database 10g Release 2
- Summary
- PartIV.Scaling and Availability with Oracle Database 10g
- Chapter 15. Utilizing Oracle Database 10g Real Applications Clusters
- Oracle 10g RAC Overview
- Cluster Ready Services
- Service Workload Management
- 10g RAC Installation and Migration Enhancements
- 10g RAC Manageability Enhancements
- Automatic Storage Management for Cluster Management
- Third-Party Cluster Management Support
- Limited Rolling Upgrade with OPATCH
- 10g RAC Tips for Better Use
- Advanced RAC Features in Oracle Database 10g Release 2
- Summary
- Chapter 16. Utilizing 10g Physical and Logical Standby with Data Guard
- Oracle 10g Data Guard Overview
- General Improvements with Oracle 10g Data Guard
- Logical Standby Improvements
- Data Guard Broker Improvements
- Applying Patch Sets with Data Guard in Place
- New Features in Oracle Database 10g Release 2
- Summary
- Chapter 17. Effectively Using Flashback Technologies
- Brief Overview of Flashback Technology
- Flashback Database
- Flashback Table
- Flashback Drop with Recycle Bin
- Flashback Versions Query
- Flashback Transaction Query
- Advanced Flashback Features in Oracle Database 10g Release 2
- Summary
- Chapter 18. Leveraging Grid Technology Features
- What Exactly Is the Grid?
- Oracle s Version of the Grid
- Managing the Grid
- Summary
- PartV.Using Oracle Database 10g Utilities and Other Advanced Features
- Chapter 19. Maximizing Data Movement with Oracle Data Pump
- Oracle 10g Data Pump Enhancements
- External Table Enhancements
- Advanced Data Pump Features in Oracle Database 10g Release 2
- Summary
- Chapter 20. Using 10g SQLPlus and iSQLPlus
- 10g SQLPlus Enhancements
- 10g iSQLPlus Enhancements
- Advanced iSQLPlus and SQLPlus Features in Oracle Database 10g Release 2
- Summary
- Chapter 21. Making the Most of Oracle Database 10g
- A Collection of Useful Features
- DMLDDL Features
- Network Features
- Security Features
- Resource Manager and Scheduler
- New Database Initialization Parameters
- Oracle Streams Enhancements
- MetaLink Integration with Oracle Database 10g
- Oracle Database 10g EM Patch Cache
- Oracle Applications 11i with Oracle Database 10g
- Summary
- Index
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Z
SUSE LINUX Enterprise Server 9 Administrators Handbook
ISBN: 672327910
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 214
Pages: 214
Authors: Peter Kuo, Jacques Beland