Index

A B C D E F G H I J L M N O P R S T U V W X

Symbols

@ abbreviation, 1.1

A

accounts

SCOTT, 1.8.7

SYS, 1.8.7

SYSTEM, 1.8.7

ADA_PATH environment variable, 1.2.2

administering command line SQL, 3.1

AIX tools

PTX Agent, 2.2.4.3

PTX Manager, 2.2.4.3

asynchronous flag for HP, B.4.4

B

block size, A.1.5

tuning, 2.3.3

BUFFER

parameter for imp, A.1.7.1

buffer cache size, 2.7

tuning, 2.7

buffer manager, 2.3, 2.3

buffer-cache

tuning, A.1.1

C

Pro*C/C++, 4.3

cache size, 2.7

catching routine, 4.11

example, 4.11

changing databases, 1.2.3.3

CLASS_PATH environment variable, 1.2.2

Cluster file system, 2.4.1

Cluster Manager

starting, F.4.3

starting options, F.5

command interpreter, 1.2.2

common environment

setting, 1.2.3

CONFIG_WATCHDOG_NOWAYOUT parameter, F.2

configuration

encapsulator, 5.6.2

master agent, 5.6.1

configuration files

Oracle Net, 5.1

Oracle Net Services, 5.1

precompiler, 4.1.1

coraenv, 1.2.1

CREATE CONTROLFILE parameter, 1.7

CREATE DATABASE parameter, 1.7

D

database

block size, A.1.5

database files, 1.8.4

DB_BLOCK_SIZE initialization parameter, 1.5, 1.5, 1.5

DB_CACHE_SIZE initialization parameter, 1.5

dba group, 1.8.2, 1.8.2

dbhome file, 1.2.3.2

debugger programs, 4.1.4.2

demonstration programs

oracle call interface, 4.7.1

Pro*C/C++, 4.3.1

Pro*COBOL, 4.4.2

Pro*FORTRAN, 4.5.1

SQL*Module for Ada, 4.6.1

demonstration tables

creating manually, 3.1.4.1

deleting, 3.1.4.2

SQL*Plus, 3.1.3

demonstrations

PL/SQL, 1.11.2

precompiler, 1.11.2.2

SQL*Loader, 1.10.1

the procedural option, PL/SQL, 1.11.2

directed placement optimizations

disk

monitoring performance, 2.5

disk I/O

file system type, 2.4.1

I/O slaves, A.2.4

tuning, 2.4

DISM, 1.5.2

DISPLAY environment variable, 1.2.2

documentation

accessing, Preface

navigation files, Preface

on administration and tuning, Preface

on migrating and upgrading from previous release, Preface

related, Preface

where installed, Preface

E

encapsulator configuration, 5.6.2, 5.6.2

environment variables, 4.4.1.1

MicroFocus COBOL compiler, 4.4.1.1

ORACLE_DOC, Preface

TNS_ADMIN, 5.1

EPC_DISABLED environment variable, 1.2.1

Extended file system, 2.4.1

F

file systems, 2.4.1

files

dbhome, 1.2.3.2

root.sh, 1.2.3.2

trace files, 2.9.1

FORMAT precompiler, 4.4.4

Pro*COBOL, 4.4.5

free command, 2.2.2

G

Glance/UX, 2.2.5.2

Globalization Support environment variable, 1.2.1

glogin.sql file, 3.1.1.1

H

HOME environment variable, 1.2.2

HP-UX tools, 2.2.5.2, 2.2.5.2

HTTP server log files, 1.10.1

I

imp

BUFFER parameter for, A.1.7.1

initialization parameters

BACKGROUND_DUMP_DEST, 1.9, 2.9.2

BITMAP_MERGE_AREA_SIZE, 1.9

COMMIT_POINT_STRENGTH, 1.9

CONTROL_FILES, 1.9

CREATE_BITMAP_AREA_SIZE, 1.9

DB_BLOCK_SIZE, 1.5, 1.5, 1.5, 1.9

DB_CACHE_SIZE, 1.5

DB_FILE_DIRECT_IO_COUNT, 1.9

DB_FILE_MULTIBLOCK_READ_COUNT, 1.9

HASH_AREA_SIZE, 1.9

HASH_MULTIBLOCK_IO_COUNT, 1.9

JAVA_POOL_SIZE, 1.5, 1.9

LARGE_POOL_SIZE, 1.5

LOCK_SGA, 1.9

LOG_ARCHIVE_DEST, 1.9

LOG_ARCHIVE_FORMAT, 1.9

LOG_BUFFER, 1.9

LOG_BUFFERS, 1.5

LOG_CHECKPOINT_INTERVAL, 1.9

MAX_DISPATCHERS, 1.9

MAX_DUMP_FILE, 2.9.1

MAX_SERVERS, 1.9

NLS_LANGUAGE, 1.9

NLS_TERRITORY, 1.9

OBJECT_CACHE_MAX_SIZE_PERCENT, 1.9

OBJECT_CACHE_OPTIMAL_SIZE, 1.9

OPEN_CURSORS, 1.9

OS_AUTHENT_PREFIX, 1.9

PROCESSES, 1.9, 1.9

SHARED_POOL_SIZE, 1.5, 1.9

SHARED_SERVERS, 1.9

SORT_AREA_SIZE, 1.9

USER_DUMP_DEST, 2.9.1

initsid.ora file, 1.9

installation

Oracle Internet Directory, Preface

Oracle Workflow, Preface

Intelligent Agent

configuration on SNMP, 5.6, 5.6

interMedia

Annotator, E.1.2

Clipboard, E.1.4

Java Servlet Photo Album Demonstration, E.1.1

JavaServer Pages Photo Album Demonstration, E.1.1

ORDAudio Java Demonstration, E.1.1

ORDAudio SQL Demonstration, E.1.1

ORDDoc Java Demonstration, E.1.1

ORDDoc SQL Demonstration, E.1.1

ORDImage Java Demonstration, E.1.1

ORDImage OCI Demonstration, E.1.1

ORDVideo Java Demonstration, E.1.1

ORDVideo SQL Demonstration, E.1.1

interrupting SQL*Plus, 3.3.3

Intimate Shared Memory, 1.5.2

I/O

asynchronous on AIX, A.2.3

asynchronous on HP, B.4

asynchronous on Tru64, D.5

tuning, 2.4

I/O slaves, A.2.4

iostat command, 2.2.1

IPC protocol, 5.3.1

ireclen, 4.1.4.3

ISM, 1.5.2

J

JAVA_POOL_SIZE initialization parameters, 1.5

Journaled file system, 2.4.1

L

LANG environment variable, 1.2.2

language, 1.2.1

LANGUAGE environment variable, 1.2.2, 1.2.2

LARGE_POOL_SIZE initialization parameters, 1.5

LD_LIBRARY_PATH environment variable, 1.2.2

LDPATH environment variable, 1.2.2

LIBPATH environment variable, 1.2.2

Lightweight Timer, B.3

Locator, E.1.3

LOG_BUFFERS initialization parameters, 1.5

LP_DEST environment variable, 1.2.2

LPDEST environment variable, 1.2.2

lsps command, 2.2.1

M

master agent configuration, 5.6.1

max_async_req parameter, D.4.1.1

max_objs parameter, D.4.1.1

max_sessions parameter, D.4.1.1

MAXDATAFILES parameter, 1.7

maxfree parameter, A.1.1

MAXINSTANCES parameter, 1.7, 1.7

MAXLOGFILES parameter, 1.7

MAXLOGHISTORY parameter, 1.7

MAXLOGMEMBERS parameter, 1.7

maxperm parameter, A.1.1, A.1.2.1

memory

contention, A.1

tuning, 2.3

memory management, 2.3

control paging, 2.3.2

swap space, 2.3.1

MicroFocus COBOL compiler, 4.4.1.1

minfree parameter, A.1.1

minperm parameter, A.1.1, A.1.2.1

MLOCK privilege, B.4.1

mpstat command, 2.2.3

msg_size parameter, D.4.1.1

multiple signal handlers, 4.11

N

NLS_LANG environment variable, 1.2.1

Node Monitor

configuring, F.4.2

NUMA

See directed placement optimizations

O

OCMS

Watchdog daemon, F.2

oinstall group, 1.8.2

oper group, 1.8.2

Optimal Flexible Architecture

characteristics of OFA, G.1.1

file mapping, G.1.1, G.2.7

ORA_NLS environment variable, 1.2.1

ORA_TZFILE environment variable, 1.2.1

oracle account, 1.8.3

oracle advanced security, 5.7

oracle call interface, 4.7

demonstration programs, 4.7.1

oracle enterprise manager intelligent agent, 5.5

Oracle environment variables

EPC_DISABLED, 1.2.1

NLS_LANG, 1.2.1, 1.2.1

ORA_NLS, 1.2.1

ORA_NLS33, 1.2.1

ORA_TZFILE, 1.2.1

ORACLE_BASE, 1.2.1

ORACLE_HOME, 1.2.1, 1.2.1

ORACLE_PATH, 1.2.1

ORACLE_SID, 1.2.1, 1.2.1, 1.2.1

ORACLE_TRACE, 1.2.1, 1.2.1, 1.2.1

Oracle9i variables, 1.2.1

ORAENV_ASK, 1.2.1, 1.2.1

SQLPATH, 1.2.1, 1.2.1

TWO_TASK, 1.2.1, 1.2.1

Oracle HTTP Server, 1.10

Oracle Net configuration files, 5.1

Oracle Net Services

IPC protocol, 5.3.1

oracle advanced security, 5.7

oracle enterprise manager intelligent agent, 5.5

protocol support, 5.3

protocols, 5.3

TCP/IP protocol, 5.3.3

Oracle Net Services configuration files, 5.1

oracle precompiler and OCI linking and makefiles

custom makefiles, 4.8

undefined symbols, 4.9

oracle run time system

Pro*COBOL, 4.4.2

Oracle System Identifier, 1.2.1

Oracle Text, E.2

ORACLE_BASE environment variable, 1.2.1

ORACLE_DOC environment variable, Preface

ORACLE_HOME environment variable, 1.2.1, 1.2.1

ORACLE_PATH environment variable, 1.2.1

ORACLE_SID environment variable, 1.1, 1.2.1, 1.2.1, 1.2.1

Oracle9i Spatial, E.3

oracm, F.4.3

oradism command, 1.5.2

oraenv file

description, 1.2.3.1

moving between databases, 1.2.3.3

ORAENV_ASK, 1.2.1

ORAINVENTORY, 1.8.2

orapwd command, 1.8.6, 1.8.6

orapwd utility, 1.8.6

oreclen, 4.1.4.3

OS_AUTHENT_PREFIX parameter, 1.8.5

OSDBA, 1.8.2

OSOPER, 1.8.2

P

page-out activity, 2.3.2

paging, 2.3.2

excessive, A.1.1, A.1.4

inadequate, A.1.3

paging space, 2.3

tuning, 2.3, 2.3.2

parameters

CONFIG_WATCHDOG_NOWAYOUT, F.2

CREATE CONTROLFILE, 1.7

CREATE DATABASE, 1.7

max_async_req, D.4.1.1

max_objs, D.4.1.1

max_sessions, D.4.1.1

MAXDATAFILES, 1.7

maxfree, A.1.1

MAXLOGFILES, 1.7

MAXLOGHISTORY, 1.7

MAXLOGMEMBERS, 1.7

maxperm, A.1.1, A.1.2.1

minfree, A.1.1

minperm, A.1.1, A.1.2.1

msg_size, D.4.1.1

OS_AUTHENT_PREFIX, 1.8.5

rad_gh_regions, D.1.6

rdg_max_auto_msg_wires, D.4.1.1

SCHED_NOAGE, B.2

SGA_MAX_SIZE, 1.5.2

shm_allocate_striped, D.1.6

SHM_MAX, 1.5

SHM_SEG, 1.5

SHMMAX, 1.5

SHMSEG, 1.5

TIMED_STATISTICS, D.7

PATH environment variable, 1.2.2

PL/SQL demonstrations, 1.11.2

loading, 1.11.2

Polycenter advanced file system, 2.4.1

precompiler configuration files, 4.1.1

precompilers

overview, 4.1

running demonstrations, 1.11.2.2

signals, 4.11

uppercase to lowercase conversion, 4.1.4.1

value of ireclen and oreclen, 4.1.4.3

vendor debugger programs, 4.1.4.2

PRINTER environment variable, 1.2.2

Pro*C/C++

demonstration programs, 4.3.1

make files, 4.3.1

signals, 4.11

using, 4.3

Pro*COBOL, 4.4, 4.4

demonstration programs, 4.4.2

FORMAT precompiler, 4.4.4, 4.4.5

naming differences, 4.4

oracle run time system, 4.4.2

user programs, 4.4.4

PRODUCT_USER_PROFILE Table, 3.1.2

Programmer's Analysis Kit (HP PAK), 2.2.5.2

protocols, 5.3

PTX Agent, 2.2.4.3

R

rad_gh_regions parameter, D.1.6

raw device setup, 2.8.2

raw devices, 2.8

buffer cache size, 2.7

guidelines for using, 2.8.1

Oracle9i Real Application Clusters installation, 2.8.1

raw disk partition availability, 2.8.1, 2.8.1

setting up, 2.8.1

Tru64, D.8

rdg_max_auto_msg_wires parameter, D.4.1.1

Real Time Clock, D.7

S

sar command, 2.2.1, 2.3.2

SCHED_NOAGE parameter, B.2

SCOTT account, 1.8.7

scripts

start_peer, 5.6.3

security, 1.8.2, 1.8.4

features of UNIX, 1.8.2

file ownership, 1.8.2

group accounts, 1.8.2

two-task architecture, 1.8.2

setup files

SQL*Plus, 3.1.1

SGA, 1.5

determining, 1.5.1

SGA_MAX_SIZE parameter, 1.5.2

shadow process, 1.8.2

SHARED_POOL_SIZE initialization parameters, 1.5

SHELL environment variable, 1.2.2, 1.2.2

SHLIB_PATH environment variable, 1.2.2

shm_allocate_striped parameter, D.1.6

SHM_MAX parameter, 1.5

SHM_SEG parameter, 1.5

SHMMAX parameter, 1.5

SHMSEG parameter, 1.5

SIGCLD two-task signal, 4.11

SIGINT two-task signal, 4.11

SIGIO two-task signal, 4.11

signal handlers

using, 4.11

signal routine, 4.11

example, 4.11

SIGPIPE two-task signal, 4.11

SIGTERM two-task signal, 4.11

SIGURG two-task signal, 4.11

Simple Network Management Protocol (SNMP), 5.6

SNMP

and Intelligent Agent, 5.6

SNMP and Intelligent Agent, 5.6

snmpd executable, 5.6.3

software distribution, 1.2.1

Spatial demonstrations, E.3

special accounts, 1.8.1

Spike optimization tool, D.9

SPOOL command

SQL*Plus, 3.3.4

using, 3.3.4

SQL*Loader, A.1.7

SQL*Module for Ada

user programs, 4.6.2

using, 4.6.1

SQL*Plus

command line help, 3.1.5

default editor, 3.3.1

demonstration tables, 3.1.3

editor, 3.3.1

interrupting, 3.3.3, 3.3.3

PRODUCT_USER_PROFILE Table, 3.1.2

restrictions, 3.4

running operating system commands, 3.3.2

setup files, 3.1.1

site profile, 3.1.1.1

SPOOL command, 3.3.4

system editor, 3.3.1

user profile, 3.1.1.2

using command line SQL*Plus, 3.3

SQLPATH environment variable, 1.2.1

SSL, 1.10

ssm_threshold parameter, D.1.6

start_peer script, 5.6.3

swap command, 2.2.1

swap space, 2.3

tuning, 2.3

swapinfo command, 2.2.1

swapon command, 2.2.1

SYS account, 1.8.7

SYSDATE, 1.2.5

SYSTEM, 1.8.7

system editor

SQL*Plus, 3.3.1

system time, 1.2.5

T

TCP/IP protocol, 5.3.3

thread support, 4.10

TIMED_STATISTICS parameter, D.7

TMPDIR environment variable, 1.2.2

tools, 2.2

trace and alert files

alert files, 2.9.2

trace file names, 2.9.1

using, 2.7, 2.9

tracing Bourne shell scripts, 1.2.1

tuning, 2.3, 2.3

archiver buffers, A.1.6

disk I/O, 2.4

I/O bottlenecks, 2.4

memory management, 2.3

resource contention, 2.6

trace and alert files, 2.7, 2.9

UDP, A.3.3

tuning tools

AIX System Management Interface Tool, 2.2.4.1

free, 2.2.2

Glance/UX, 2.2.5.2

iostat, 2.2.1

lsps, 2.2.1

mpstat, 2.2.3

Programmer's Analysis Kit (HP PAK), 2.2.5.2

PTX Agent, 2.2.4.3

PTX Manager, 2.2.4.3

sar, 2.2.1

swap, 2.2.1

swapinfo, 2.2.1

swapon, 2.2.1

vmstat, 2.2.1

TWO_TASK environment variable, 1.2.1

U

UDP IPC, D.4.1.2

UDP tuning, A.3.3

unified file system, 2.4.1

UNIX environment variables

CLASSPATH, 1.2.2

DISPLAY, 1.2.2

HOME, 1.2.2

LANG, 1.2.2

LANGUAGE, 1.2.2

LD_LIBRARY_PATH, 1.2.2

LD_OPTIONS, 1.2.2

LDPATH, 1.2.2

LIBPATH, 1.2.2

LPDEST, 1.2.2

PATH, 1.2.2

PRINTER, 1.2.2

SHELL, 1.2.2, 1.2.2

SHLIB_PATH, 1.2.2

TMPDIR, 1.2.2

XENVIRONMENT, 1.2.2

UNIX groups

dba, 1.8.2

oinstall, 1.8.2

oper, 1.8.2

UNIX System V file system, 2.4.1

user interrupt handler, 4.11

user profile

SQL*Plus, 3.1.1.2

user programs

Pro*COBOL, 4.4.4

SQL*Module for Ada, 4.6.2

using command line SQL*Plus, 3.3

V

Veritas file system, 2.4.1

vmstat command, 2.2.1, 2.3.2

vmtune command, A.1.1

W

Watchdog daemon

description, F.2

starting, F.4.1

starting options, F.5

X

XA functionality, 4.12

XENVIRONMENT environment variable, 1.2.2