Oracle8

Oracle8 and Oracle8 Enterprise Edition

Typographic Conventions

Command Syntax

Optimal Flexible Architecture (OFA)

Characteristics of OFA-Compliant Database

OFA Implemented on Oracle8 for UNIX

Exploiting OFA Structure for Oracle Files

OFA File Mapping

Raw Device Sizes

File Mapping for Multiple-Instance OFA Database

Directory Structure

Default OFA Database

Customizing the initsid.ora File

Sample initsid.ora File

Setting the Environment

Displaying and Setting Environment Variables

Setting a Common Environment

Database Examples

Environment Variables for Oracle8

Oracle Environment Variables on UNIX

UNIX Environment Variables Used with Oracle8

Setting the System Time

Estimating Oracle8 Server Memory Usage

Calculating Cluster Size and Index Size

Calculating Cluster Size

Calculating Index Size

Server Resource Limits

Initialization Parameters

Default Initialization Parameter Values

Controlling the System Global Area

Size limits of the SGA

Calculating the Size of the SGA

Relocating the SGA

Managing Special Accounts and Groups

Security for Oracle Server Utilities

Oracle Server Roles and UNIX Groups

Security for Server Manager Commands

Security for Database Files

Network Security

Enabling Automatic Logins for Oracle Net8

Checking Order

Security and Remote Passwords

Administering Login Home Directories

Building and Running Demonstrations

Loading PL/SQL Demonstrations

Running PL/SQL Demonstrations

SQL*Loader Demonstrations

Administering SQL*Loader

Oracle Security Server

Oracle8 Server SQL Reference

CREATE CONTROLFILE Parameters

The Importance of Tuning

Before Tuning the System

utlbstat and utlestat 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 2.x Buffer Cache Size

Using Trace and Alert Files

Trace File Names

Alert Files

Raw Devices

Disadvantages of Raw Devices

Guidelines for Using Raw Devices

Setting Up Raw Devices

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

Setting the Order of the Editor

Setting the _editor option

Setting Environment Variables

Default Settings

Running Operating System Commands from SQL*Plus

Interrupting SQL*Plus

Using the SPOOL Command

Overview of Oracle Precompilers

Relinking Precompiler Executables

Precompiler Configuration Files

Issues Common to All Precompilers

Supplemental 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

Supplemental 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

Oracle Net8 Protocol Adapters

The BEQ Protocol Adapter

Overview of the BEQ Protocol Adapter

Specifying a BEQ ADDRESS

The IPC Protocol Adapter

Overview of the IPC Protocol Adapter

Specifying an IPC ADDRESS

The RAW Protocol Adapter

The TCP/IP Protocol Adapter

Overview of the TCP/IP Protocol Adapter

Specifying a TCP/IP ADDRESS

The SPX/IPX Protocol Adapter

The ntisbsdm Broadcast Daemon

The ntspxctl Utility

SPX/IPX Protocol Adapter Command Summary

The getname Command

Specifying the SPX/IPX ADDRESS

The APPC/LU6.2 Protocol Adapter

Solaris 2.x-Specific Listener

Specifying an APPC/LU6.2 ADDRESS

Net8 Naming Adapters

Oracle Enterprise Manager (OEM) Intelligent Agent

Oracle Advanced Networking Option

Issues Common to Data Cartridges

Oracle8 Time Series Cartridge

Installing Time Series Cartridge Demos

Oracle8 Visual Information Retrieval Cartridge

Creating the Demo

Oracle8 Image Cartridge

Creating the Demo

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Optimal Flexible Architecture on Oracle8

2 Administering Oracle8 on Solaris 2.x

3 Tuning Oracle8 on Solaris 2.x

4 Administering SQL*Plus on Solaris 2.x

5 Using Oracle Precompilers and the Oracle Call Interface on Solaris 2.x

6 Configuring Oracle Net8

7 Running Oracle Data Cartridge Demos on Solaris 2.x

Index