Table of Contents


book cover
Oracle® Database 10g INSIDER SOLUTIONS
By Arun Kumar R., John Kanagaraj, Richard Stroupe
...............................................
Publisher: Sams Publishing
Pub Date: August 23, 2005
ISBN: 0-672-32791-0
Pages: 528
 



Table of Contents  | Index

   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
   Part I.  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 UNIX/Linux
      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
   Part II.  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
   Part III.  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
   Part IV.  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
   Part V.  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 SQL*Plus and iSQL*Plus
      10g SQL*Plus Enhancements
      10g iSQL*Plus Enhancements
      Advanced iSQL*Plus and SQL*Plus Features in Oracle Database 10g Release 2
      Summary
          Chapter 21.  Making the Most of Oracle Database 10g
      A Collection of Useful Features
      DML/DDL 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


Oracle Database 10g Insider Solutions
SUSE LINUX Enterprise Server 9 Administrators Handbook
ISBN: 672327910
EAN: 2147483647
Year: 2006
Pages: 214

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net