Table of Contents
- Title and Copyright Information
- Preface
- 1 Administering Oracle Database
- 2 Stopping and Starting Oracle Software
- 3 Configuring Oracle Database
- 4 Administering SQL*Plus
- 5 Configuring Oracle Net Services
-
6
Using Oracle Precompilers and the Oracle Call Interface
- 6.1 Overview of Oracle Precompilers
- 6.2 Bit-Length Support for Client Applications
- 6.3 Pro*C/C++ Precompiler
- 6.4 Pro*COBOL Precompiler
- 6.5 Pro*FORTRAN Precompiler
- 6.6 SQL*Module for ADA
- 6.7 OCI and OCCI
- 6.8 Running 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
-
8
Tuning Oracle Database
- 8.1 Importance of Tuning
- 8.2 Operating System Tools
- 8.3 Tuning Memory Management
- 8.4 Tuning Disk Input-Output
- 8.5 Monitoring Disk Performance
- 8.6 System Global Area
- 8.7 Tuning the Operating System Buffer Cache
- A Administering Oracle Database on Linux
- B Administering Oracle Database on Oracle Solaris
-
C
Administering Oracle Database on IBM AIX on POWER Systems (64-Bit)
- C.1 Memory and Paging
-
C.2
Disk Input-Output Issues
- C.2.1 IBM AIX on POWER Systems (64-Bit) Logical Volume Manager
- C.2.2 Using Journaled File Systems Compared to Raw Logical Volumes
- C.2.3 Using Asynchronous Input-Output
- C.2.4 Input-Output Slaves
- C.2.5 Using the DB_FILE_MULTIBLOCK_READ_COUNT Parameter
- C.2.6 Tuning Disk Input-Output Pacing
- C.2.7 Resilvering with Oracle Database
- C.3 CPU Scheduling and Process Priorities
- C.4 AIXTHREAD_SCOPE Environment Variable
- C.5 Network Information Service external naming support
- C.6 Configuring IBM Java Secure Socket Extension Provider with Oracle JDBC Thin Driver
-
D
Administering Oracle Database on HP-UX
- D.1 HP-UX Shared Memory Segments for an Oracle Instance
- D.2 HP-UX SCHED_NOAGE Scheduling Policy
- D.3 Lightweight Timer Implementation
- D.4 Asynchronous Input-Output
- D.5 Large Memory Allocations and Oracle Database Tuning
- D.6 CPU_COUNT Initialization Parameter and HP-UX Dynamic Processor Reconfiguration
- D.7 Network Information Service external naming support
- D.8 Activating and Setting Expanded Host Names and Node Names
-
E
Using Oracle ODBC Driver
- E.1 Oracle ODBC Features Not Supported
- E.2 Implementation of Data Types
- E.3 Limitations on Data Types
- E.4 Format of the Connection String for the SQLDriverConnect Function
- E.5 Reducing Lock Timeout in a Program
- E.6 Linking ODBC Applications
- E.7 Obtaining Information About ROWIDs
- E.8 ROWIDs in a WHERE Clause
- E.9 Enabling Result Sets
- E.10 Enabling EXEC Syntax
- E.11 Supported Functionality
- E.12 Unicode Support
- E.13 Performance and Tuning
- E.14 Error Messages
- F Database Limits
- Index