Chapter 2: RDBMS Features for Availability

< Day Day Up >

---

Chapter 2: RDBMS Features for Availability

Most sources for Chapter 2 come directly from the Oracle documentation set itself, and the Administrator's Guide mostly. Other sources include white papers available on OTN and some technical notes that will only be available if you have a Metalink account with Oracle Support.

Enterprise Manager

• 
  

  Choi, Phil, et al. Oracle Enterprise Manager Grid Control Installation and Basic Configuration 10g Release 1 (10.1), Oracle Corporation, December 2003.

  
  

This quick guide provides detailed memory and disk requirements, OS compatibilities, and other critical first-look information when you are deciding how (or if) to use EM Grid Control.

Data Architecting for Availability

• 
  

  Kyte, Thomas. Effective Oracle by Design, Berkeley: McGraw-Hill/Osborne, August 2003.

  
  

The best source of data architectural advice on the market.

• 
  

  Niemiec, Richard J. Oracle9i Performance Tuning Tips & Techniques, Berkeley: McGraw-Hill/Osborne, May 2003.

  
  

If you've caught Mr. Niemiec at IOUG or OracleWorld, you know his knowledge runs deep, and he's harnessed his team at TUSC for another excellent tome on perf/tune.

Partitioning

• 
  

  Baylis, Ruth, et al. Oracle^® Database Administrator's Guide 10g Release 1 (10.1), Oracle Corporation, December 2003.

  
  

Chapter 16 is the primary source of reliable and accurate information on partitions.

• 
  

  Cyran, Michele, et al. Oracle Database Concepts, 10g Release 1 (10.1), Oracle Corporation, December 2003.

  
  

Chapter 18 is the conceptual platform for understanding the terms and structures for partitioning. You should start here for foundational understanding.

• 
  

  'Partitioned Indexes: Global, Local, Prefixed and Non-Prefixed.' Available online from http://metalink.oracle.com, Reference DocID 69374.1. [Referenced on February 2, 2004]

  
  

The most concise explanation of partitioned indices that is available anywhere.

Index-Organized Tables

• 
  

  Baylis, Ruth, et al. Oracle ^® Database Administrator's Guide 10g Release 1 (10.1), Oracle Corporation, December 2003.

  
  

Chapter 14 provides a succinct introduction to the use and admin of IOTs.

Materialized Views

• 
  

  'Oracle9i Materialized Views,' Oracle white paper. Available online from http://otn.oracle.com/products/oracle9i/pdf/o9i_mv.pdf, May 2001. [Referenced on February 2, 2004]

  
  

The most important pieces of this excellent paper cover summary management and the succinct explanation of query rewrite.

• 
  

  Lane, Paul, et al. Oracle^® Data Warehousing Guide, 10g Release 1 (10.1), Oracle Corporation, December 2003.

  
  

Chapters 8 and 9 will give a complete picture of the minutae of mviews, including all the exceptions and restrictions that exist. In addition, Chapter 17 provides indepth coverage of the command-line implementation of SQL Access Advisor-for those of you who simply cannot abide by EM.

Online Reorganization

• 
  

  Baylis, Ruth, et al. Oracle^® Database Administrator's Guide 10g Release 1 (10.1), Oracle Corporation, December 2003.

  
  

Chapter 14 provides a succinct introduction to the usage of DBMS_REDEFINITION used for table reorgs.

• 
  

  'Maximum Availability Architecture,' Oracle white paper. Available online from: http://otn.oracle.com/deploy/availability/pdf/MAA_WP.pdf, February 2003. [Referenced February 2, 2004]

  
  

We started here for a lot of different things, but the section on table reorganization is succinct and provides useful examples.

Resource Manager and the Scheduler

• 
  

  Baylis, Ruth, et al. Oracle^® Database Administrator's Guide 10g Release 1 (10.1), Oracle Corporation, December 2003.

  
  

Chapter 24 covers Resource Manager in all its specificity. Chapters 25-28 cover the Scheduler, with Chapter 25 helping with a transition away from DBMS_JOB.

LogMiner: Transaction Extraction

• 
  

  Rich, Kathy, et al. Oracle^® Database Utilities 10g Release 1 (10.1), Oracle Corporation, December 2003.

  
  

Chapter 19 provides excellent coverage of using LogMiner at the SQL interface level to gain access to LogMiner. Our coverage is short and, admittedly, rather lean on specifics.

Transportable Tablespaces

• 
  

  Baylis, Ruth, et al. Oracle^® Database Administrator's Guide 10g Release 1 (10.1), Oracle Corporation, December 2003.

  
  

Chapter 8 covers the nitpicking details of transporting tablespaces in general, as well as using cross-platform transportation.