Contents

Title and Copyright Information

Send Us Your Comments

Preface

Oracle Information Navigator

1 Administering Oracle8i

Overview

Environment Variables

Oracle8i Environment Variables

UNIX Environment Variables

Setting a Common Environment

Setting and Exporting the Value of a Variable in a Current Session

Setting the System Time

Network Executables

System Global Area

Calculating the Size of the SGA

Oracle8i Memory Requirements and Usage

Server Resource Limits

Database Limits

Special Accounts and Groups

Security

Groups and Security

Security for Server Manager Commands

Security for Database Files

Remote Passwords

Customizing the initsid.ora File

The Embedded PL/SQL Gateway

Overview

Installing the Embedded PL/SQL Gateway

Oracle HTTP Server

Oracle HTTP Server status

Oracle HTTP Server log files

Demonstrations Files

SQL*Loader Demonstrations

Administering SQL*Loader

PL/SQL Demonstrations

Database Examples

2 Tuning Oracle8i

The Importance of Tuning

Solaris Tools

vmstat

sar

iostat

swap

mpstat

SQL Scripts

Tuning Memory Management

Allocate Sufficient Swap Space

Control Paging

Hold the SGA in a Single Shared Memory Segment

Tuning Disk I/O

Tune the Database Writer to Increase Write Bandwidth

Look for Large Disk Request Queues Using IOSTAT

Choose the Appropriate File System Type

Monitoring Disk Performance

Disk Performance Issues

Tuning CPU Usage

Keep All Oracle Users/Processes at the Same Priority

Use Processor Affinity/Binding on Multi-Processor Systems

Use Single-Task Linking for Large Exports/Imports and SQL*Loader Jobs

Tuning Oracle Resource Contention

Tune UNIX Kernel Parameters

Tuning Block Size and File Size

Specifying Oracle Block Size

Tuning the Solaris Buffer Cache Size

Using Trace and Alert Files

Trace File Names

Alert Files

Using Raw Devices/Volumes

Disadvantages of Raw Devices/Volumes

Guidelines for Using Raw Devices/Volumes

Raw Device Setup

3 Administering SQL*Plus

Administering SQL*Plus

Using Setup Files

Using the PRODUCT_USER_PROFILE Table

Using Demonstration Tables

Using the Help Facility

Using SQL*Plus

Using a System Editor from SQL*Plus

Running Operating System Commands from SQL*Plus

Interrupting SQL*Plus

Using the SPOOL Command

Restrictions of SQL*Plus

Resizing Windows

Return Codes

4 Configuring Oracle Message Broker

Update Path for the JRE

Directory Installation and Configuration

Directory Configuration

Oracle Advanced Queuing Configuration (Optional)

Stop Oracle Internet Directory

Stop the Database Server and the Listeners

Configure Database Parameters

Restart the Database Server and the Listeners

Start Oracle Internet Directory

Initialize AQ

Remove AQ Queue Tables

MQSeries Installation Tasks (Optional)

TIBCO Installation Tasks (Optional)

Asynchronous Component Invocation Installation Tasks (Optional)

Creating an OMB Instance and Using Oracle Message Broker

Migrating Directory Data between Releases

Migrating from Release 2.0.0.0 to Release 2.0.1.0

Migrating Between Releases 1.0 to 2.0

5 Using Oracle Precompilers and the Oracle Call Interface

Overview of Oracle Precompilers

Precompiler Configuration Files

Issues Common to All Precompilers

Static and Dynamic Linking

Oracle Shared Library

Pro*C/C++ Precompiler

Pro*C/C++ Demonstration Programs

Pro*C/C++ User Programs

Pro*COBOL Precompiler

Pro*COBOL Environment Variables

MicroFocus COBOL Compiler

Sun Nihongo COBOL Compiler

Sun Nihongo COBOL Makefile Names

Pro*COBOL Demonstration Programs

Pro*COBOL User Programs

FORMAT Precompiler Option

Pro*FORTRAN Precompiler

Pro*FORTRAN Demonstration Programs

Pro*FORTRAN User Programs

SQL*Module for Ada

SQL*Module for Ada Demonstration Programs

SQL*Module Ada User Programs

Oracle Call Interface

OCI Demonstration Programs

OCI Linking Errors

OCI User Programs

Custom Makefiles

Correcting Undefined Symbols

Multi-Threaded Applications

Using Signal Handlers

XA Functionality

6 Configuring Net8

Core Net8 Products and Features

Net8 Files and Utilities

Oracle Connection Manager

Server Models

Oracle Names

Net8 Protocol Support

ADDRESS Specification

The BEQ Protocol

The IPC Protocol

The RAW Protocol

The TCP/IP Protocol

Specifying a TCP/IP ADDRESS

The APPC/LU6.2 Protocol

Solaris 2.x-Specific Listener

Specifying an APPC/LU6.2 ADDRESS

NIS Naming Support

Oracle Enterprise Manager

Configuring Oracle Intelligent Agent for Oracle SNMP

Oracle Advanced Security

Supplementary Documentation

7 Running Oracle Data Option Demos

Oracle8i interMedia

Text

Audio, Video, and Image

Locator

Web Agent and Clipboard

Oracle8i Time Series Demos

Oracle8i Visual Information Retrieval

Oracle8i Spatial

A Optimal Flexible Architecture

Optimal Flexible Architecture (OFA)

Characteristics of OFA-Compliant Database

OFA Implemented on UNIX

Mount Points

Naming Directories

Naming Files

Naming Tablespaces

Exploiting OFA Structure for Oracle Files

OFA File Mapping

Raw Device Sizes

File Mapping for Multiple-Instance OFA Database

Directory Structure

Index