Oracle9i UNIX Administration Handbook

Run Oracle9i on the UNIX Platform

Officially authorized by Oracle Corporation, this in-depth resource explains how to deploy and manage Oracle9i on all of the major UNIX platforms, including Solaris, HP-UNIX, IBM-AIX UNIX, and Linux. Youll learn to configure, administer, monitor, and tune Oracle9i in the UNIX environment using a proven set of commands, tools, and techniques. Plus, youll get ready-to-use UNIX scripts that you can use to perform dozens of administrative tasks.

• Manage and tune the Oracle UNIX server with UNIX commands
  
• Capture UNIX server statistics with Oracle9i STATSPACK
  
• Handle UNIX disk management and reduce I/O
  
• Write powerful UNIX scripts to interact with Oracle9i
  
• Examine the interaction between Oracle and the UNIX OS
  
• Monitor UNIX dedicated and multi-threaded server connections to Oracle
  
• Take advantage of the Oracle Optimal Flexible Architecture (OFA) for file management
  
• Create automated UNIX scripts to monitor Oracle files
  
• Encapsulate Oracle DBA tasks into UNIX shell scripts
  

Contents           

  PART I: UNIX Server Basics
   Ch. 1: Introduction to UNIX
   Ch. 2: RAM Memory in UNIX
   Ch. 3: CPU Usage and Oracle
   Ch. 4: Disk I/O Monitoring in UNIX
   Ch. 5: UNIX Network Considerations

  PART II:The Interaction Between Oracle and the UNIX Server
   Ch. 6: Oracle Interfaces to the Server
   Ch. 7: Oracle Sessions and the UNIX Server
   Ch. 8: Building a Server Monitor with STATSPACK
   Ch. 9: Creating Server Exception Reports and Alerts

  PART III: UNIX Administration for the Oracle DBA
   Ch. 10: UNIX Tasks for the Oracle DBA
   Ch. 11: Oracle File Monitoring in UNIX
   Ch. 12: Oracle Job Scheduling in UNIX
   Ch. 13: Maintaining Oracle in UNIX
   Ch. 14: Advanced UNIX Administration for Oracle