Contents

Title and Copyright Information

Send Us Your Comments

Preface

Purpose

Audience

Oracle8i and Oracle8i Enterprise Edition

Typographic Conventions

Command Syntax

Related Documentation

Oracle Services and Support

1 Administering Oracle8i

Setting the Environment

Displaying Environment Variables

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

Setting a Common Environment

Database Examples

Environment Variables for Oracle8i

Oracle Environment Variables on UNIX

UNIX Environment Variables Used with Oracle8i

Setting the System Time

Initialization Parameters

Customizing the initsid.ora File

Default Initialization Parameter Values

Database Limits

Managing Special Accounts and Groups

Managing Security

Groups and Security

Security for Server Manager Commands

Security for Database Files

Security and Remote Passwords

Administering Login Home Directories

Estimating Oracle8i Memory Usage

Server Resource Limits

Controlling the System Global Area

Size Limits of the SGA

Calculating the Size of the SGA

Relocating the SGA

Building and Running Demonstrations

SQL*Loader Demonstrations

Administering SQL*Loader

Loading PL/SQL Demonstrations

Running PL/SQL Demonstrations

Relinking Network Executables

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

Raw Devices/Volumes

Disadvantages of Raw Devices/Volumes

Guidelines for Using Raw Devices/Volumes

Raw Device Setup

3 Administering SQL*Plus

Administering SQL*Plus

Setup Files

The Site Profile

The User Profile

The PRODUCT_USER_PROFILE Table

Demonstration Tables

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

Resizing Windows

Return Codes

4 Using Oracle Precompilers and the Oracle Call Interface

Overview of Oracle Precompilers

Precompiler Configuration Files

Issues Common to All Precompilers

Additional Documentation

Pro*C/C++

Administering Pro*C/C++

Using Pro*C/C++

Pro*COBOL

Administering Pro*COBOL

Environment Variables

Using Pro*COBOL

Pro*FORTRAN

Administering Pro*FORTRAN

Using Pro*FORTRAN

SQL*Module for Ada

Administering SQL*Module for Ada

Using SQL*Module for Ada

Oracle Call Interface

Using the Oracle Call Interface

Oracle Precompiler and Oracle Call Interface Linking and Makefiles

Custom Makefiles

Undefined Symbols

Thread Support

Static and Dynamic Linking with Oracle Libraries

Using Signal Handlers

Signals

XA Functionality

5 Configuring Net8

Supplementary Documentation

Supplementary Information in README Files

Core Net8 Products and Features

Net8 Files and Utilities

Oracle Connection Manager

Multi-Threaded Server

Oracle Names

Net8 Assistant

Net8 Protocol Support

ADDRESS Specification

The BEQ Protocol

Specifying a BEQ ADDRESS

The IPC Protocol

Specifying an IPC ADDRESS

The RAW Protocol

The TCP/IP Protocol

Specifying a TCP/IP ADDRESS

The SPX/IPX Protocol

The ntisbsdm Broadcast Daemon

The ntspxctl Utility

SPX/IPX Protocol Command Summary

The getname Command

Specifying the SPX/IPX ADDRESS

The APPC/LU6.2 Protocol

Solaris 2.x-Specific Listener

Specifying an APPC/LU6.2 ADDRESS

Net8 Naming Support

Oracle Enterprise Manager (OEM)

Configuring Oracle Intelligent Agent for Oracle SNMP

Oracle Advanced Security Option

6 Running Oracle Data Option Demos

Additional Documentation

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

Naming 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