Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions
• Command Syntax
• Terminology
• Accessing Documentation
• Third Party Software Notices

1 Administering Oracle Database

• 1.1 Overview
• 1.2 Environment Variables
  • 1.2.1 Oracle Database Environment Variables
  • 1.2.2 UNIX Environment Variables
  • 1.2.3 Setting a Common Environment
  • 1.2.4 Setting the System Time Zone
• 1.3 Initialization Parameters
  • 1.3.1 DB_BLOCK_SIZE Initialization Parameter
  • 1.3.2 ASM_DISKSTRING Initialization Parameter
  • 1.3.3 LOG_ARCHIVE_DEST_n Initialization Parameter
• 1.4 Operating System Accounts and Groups
  • 1.4.1 Creating Additional Operating System Accounts
  • 1.4.2 Configuring the Accounts of Oracle Users
• 1.5 Using Trace Files

2 Stopping and Starting Oracle Software

• 2.1 Stopping and Starting Oracle Processes
  • 2.1.1 Stopping and Starting Oracle Database and Automatic Storage Management Instances
    • 2.1.1.1 Stopping an Oracle Database or Automatic Storage Management Instance
    • 2.1.1.2 Restarting an Oracle Database or Automatic Storage Management Instance
  • 2.1.2 Stopping and Starting Oracle Restart
  • 2.1.3 Stopping and Starting Oracle Enterprise Manager Database Control
  • 2.1.4 Stopping and Starting Oracle Management Agent
• 2.2 Automating Shutdown and Startup
  • 2.2.1 Automating Database Startup and Shutdown on Other Operating Systems

3 Configuring Oracle Database

• 3.1 Using Configuration Assistants as Standalone Tools
  • 3.1.1 Using Oracle Net Configuration Assistant
  • 3.1.2 Using Oracle Database Upgrade Assistant
  • 3.1.3 Using Oracle Database Configuration Assistant
  • 3.1.4 Configuring New or Upgraded Databases
• 3.2 Relinking Executables

4 Administering SQL*Plus

• 4.1 Administering Command-Line SQL*Plus
  • 4.1.1 Using Setup Files
  • 4.1.2 Using the PRODUCT_USER_PROFILE Table
  • 4.1.3 Using Oracle Database Sample Schemas
  • 4.1.4 Installing and Removing SQL*Plus Command-Line Help
    • 4.1.4.1 Installing SQL*Plus Command-Line Help
    • 4.1.4.2 Removing SQL*Plus Command-Line Help
• 4.2 Using Command-Line SQL*Plus
  • 4.2.1 Using a System Editor from SQL*Plus
  • 4.2.2 Running Operating System Commands from SQL*Plus
  • 4.2.3 Interrupting SQL*Plus
  • 4.2.4 Using the SPOOL Command
• 4.3 SQL*Plus Restrictions
  • 4.3.1 Resizing Windows
  • 4.3.2 Return Codes
  • 4.3.3 Hiding the Password

5 Configuring Oracle Net Services

• 5.1 Locating Oracle Net Services Configuration Files
• 5.2 Adapters Utility
• 5.3 Oracle Protocol Support
  • 5.3.1 IPC Protocol Support
  • 5.3.2 TCP/IP Protocol Support
  • 5.3.3 TCP/IP with Secure Sockets Layer Protocol Support
• 5.4 Setting Up the Listener for TCP/IP or TCP/IP with Secure Sockets Layer
• 5.5 Oracle Advanced Security

6 Using Oracle Precompilers and the Oracle Call Interface

• 6.1 Overview of Oracle Precompilers
  • 6.1.1 Precompiler Configuration Files
  • 6.1.2 Relinking Precompiler Executables
  • 6.1.3 Precompiler README Files
  • 6.1.4 Issues Common to All Precompilers
  • 6.1.5 Static and Dynamic Linking
  • 6.1.6 Client Shared and Static Libraries
• 6.2 Bit-Length Support for Client Applications
• 6.3 Pro*C/C++ Precompiler
  • 6.3.1 Pro*C/C++ Demonstration Programs
  • 6.3.2 Pro*C/C++ User Programs
• 6.4 Pro*COBOL Precompiler
  • 6.4.1 Pro*COBOL Environment Variables
    • 6.4.1.1 Micro Focus Server Express COBOL Compiler
    • 6.4.1.2 Acucorp ACUCOBOL-GT COBOL Compiler
  • 6.4.2 Pro*COBOL Oracle Runtime System
  • 6.4.3 Pro*COBOL Demonstration Programs
  • 6.4.4 Pro*COBOL User Programs
  • 6.4.5 FORMAT Precompiler Option
• 6.5 Pro*FORTRAN Precompiler
  • 6.5.1 Pro*FORTRAN Demonstration Programs
  • 6.5.2 Pro*FORTRAN User Programs
• 6.6 SQL*Module for ADA
  • 6.6.1 SQL*Module for Ada Demonstration Programs
  • 6.6.2 SQL*Module for Ada User Programs
• 6.7 OCI and OCCI
  • 6.7.1 OCI and OCCI Demonstration Programs
  • 6.7.2 OCI and OCCI User Programs
• 6.8 Oracle JDBC/OCI Programs with a 64-Bit Driver
• 6.9 Custom Make Files
• 6.10 Correcting Undefined Symbols
• 6.11 Multithreaded Applications
• 6.12 Using Signal Handlers
• 6.13 XA Functionality

7   SQL*Loader and PL/SQL Demonstrations

• 7.1 SQL*Loader Demonstrations
• 7.2 PL/SQL Demonstrations
• 7.3 Calling 32-Bit External Procedures from 64-Bit Oracle Database PL/SQL

8 Tuning Oracle Database

• 8.1 Importance of Tuning
• 8.2 Operating System Tools
  • 8.2.1 vmstat
  • 8.2.2 sar
  • 8.2.3 iostat
  • 8.2.4 swap, swapinfo, swapon, or lsps
  • 8.2.5 AIX Tools
    • 8.2.5.1 Base Operation System Tools
    • 8.2.5.2 Performance Toolbox
    • 8.2.5.3 System Management Interface Tool
  • 8.2.6 HP-UX Tools
  • 8.2.7 Linux Tools
  • 8.2.8 Solaris Tools
• 8.3 Tuning Memory Management
  • 8.3.1 Allocating Sufficient Swap Space
  • 8.3.2 Controlling Paging
  • 8.3.3 Adjusting Oracle Block Size
  • 8.3.4 Allocating Memory Resource
• 8.4 Tuning Disk Input-Output
  • 8.4.1 Using Automatic Storage Management
  • 8.4.2 Choosing the Appropriate File System Type
• 8.5 Monitoring Disk Performance
  • 8.5.1 Monitoring Disk Performance on Other Operating Systems
  • 8.5.2 Using Disk Resync to Monitor Automatic Storage Management Disk Group
• 8.6 System Global Area
  • 8.6.1 Determining the Size of the SGA
  • 8.6.2 Shared Memory on AIX
• 8.7 Tuning the Operating System Buffer Cache

A Administering Oracle Database on Linux

• A.1 Extended Buffer Cache Support
• A.2 Using hugetlbfs on SUSE Linux Enterprise Server 10 or Red Hat Enterprise Linux 4
• A.3 Increasing SGA Address Space
• A.4 Asynchronous Input-Output Support
• A.5 Simultaneous Multithreading
• A.6 Allocating Shared Resources
• A.7 Database Migration from 32-Bit Linux to 64-Bit Linux
  • A.7.1 Online Backup of Database With RMAN
  • A.7.2 Migrating 32-Bit Linux Database to 64-Bit Linux Database
    • A.7.2.1 Migrating 32-Bit Database to 64-Bit Database With the Same Directory Structure for Data Files
    • A.7.2.2 Migrating 32-Bit Database to 64-Bit Database With Different Directory Structure for Data Files
  • A.7.3 Migrating Data To and From ASM

B Using Oracle ODBC Driver

• B.1 Features Not Supported
• B.2 Implementation of Data Types
• B.3 Limitations on Data Types
• B.4 Format of the Connection String for the SQLDriverConnect Function
• B.5 Reducing Lock Timeout in a Program
• B.6 Linking ODBC Applications
• B.7 Obtaining Information About ROWIDs
• B.8 ROWIDs in a WHERE Clause
• B.9 Enabling Result Sets
• B.10 Enabling EXEC Syntax
• B.11 Supported Functionality
  • B.11.1 API Conformance
  • B.11.2 Implementation of ODBC API Functions
  • B.11.3 Implementation of the ODBC SQL Syntax
  • B.11.4 Implementation of Data Types
• B.12 Unicode Support
  • B.12.1 Unicode Support Within the ODBC Environment
  • B.12.2 Unicode Support in ODBC API
  • B.12.3 SQLGetData Performance
  • B.12.4 Unicode Samples
• B.13 Performance and Tuning
  • B.13.1 General ODBC Programming Guidelines
  • B.13.2 Data Source Configuration Options
  • B.13.3 DATE and TIMESTAMP Data Types
• B.14 Error Messages

C Database Limits

• C.1 Database Limits

D Managing Input Output Resources

• D.1 Overview
• D.2 Requirements
• D.3 PL/SQL Statement

E Very Large Memory on Linux x86

• E.1 Shared Global Area Tuning
  • E.1.1 Manual SGA Tuning
    • E.1.1.1 ZONE_DMA
    • E.1.1.2 ZONE_NORMAL
    • E.1.1.3 ZONE_HIMEM
  • E.1.2 Automatic SGA Tuning
• E.2 Overview of HugePages
• E.3 Methods To Increase SGA Limits
  • E.3.1 Hugemem Kernel
  • E.3.2 Hugemem Kernel with Very Large Memory
• E.4 Configuring Very Large Memory for Oracle Database
• E.5 Restrictions Involved in Implementing Very Large Memory

Index