Index

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

Symbols

@ abbreviation, 1.1

A

accounts

SYS, 1.4.6

SYSTEM, 1.4.6

ADA_PATH environment variable, 1.2.2

adapters utility, 5.2

administering command line SQL, 4.1

administrators

UNIX accounts, 1.4.7

aio_task_max_num subsystem attribute

on Tru64 UNIX, E.5.1

AIX Logical Volume Manager, A.2.1

AIX tools, 8.2.2

PTX Agent, 8.2.2.3

PTX Manager, 8.2.2.3

SMIT, 8.2.2.1

ASM_DISKSTRING

operating system default values, 1.3.2

asynchronous flag for HP, B.4.4

asynchronous flag in SGA

on HP-UX systems, B.4.4

asynchronous I/O

on HP-UX, B.4

on Linux, C.6

verifying on HP-UX, B.4.3

Automatic Storage Management process

restarting, 2.1.2

stopping, 2.1.2

B

Base Operation System tools, 8.2.2.2

block size on AIX, A.1.5

buffer cache size, 8.7

tuning, 8.7

buffer manager, 8.3, 8.3

BUFFER parameter for the Import utility

on AIX, A.1.7.1

buffer-cache

tuning, A.1.1

buffer-cache paging activity

controlling on AIX, A.1.1

C

Pro*C/C++, 6.3

cache size, 8.7

catching routine, 6.12

example, 6.12

CLASS_PATH environment variable, 1.2.2

client shared library, 6.1.6

client static library, 6.1.6

Cluster file system, 8.4.2

CLUSTER_INTERCONNECTS

initialization parameter, 1.3.4

common environment

setting, 1.2.3

configuration files

Oracle Net, 5.1

Oracle Net Services, 5.1

precompiler, 6.1.1

configuring

accounts of Oracle users, 1.4.8

controlling paging

on AIX, A.1.4

coraenv, 1.2.1

coraenv file

description, 1.2.3.1

CPU scheduling and process priorities

on AIX, A.3

CPU_COUNT initialization parameter

and HP-UX dynamic processor reconfiguration, B.7

CREATE CONTROLFILE parameter, G.1

CREATE DATABASE parameter, G.1

CURSOR_SPACE_FOR_TIME initialization parameter

tuning Oracle Database on HP-UX systems, B.5

D

database

block size on AIX, A.1.5

creation methods

Oracle Database Configuration Assistant, 3.2.3

migration, 3.2.2

upgrading, 3.2.2

database block size

setting on AIX, A.1.5

Database Configuration Assistant

using, 3.2.3

Database Control

starting, 2.1.6

stopping, 2.1.6

Database Upgrade Assistant

using, 3.2.2

DB_BLOCK_SIZE

maximum value of, 1.3.1

DB_BLOCK_SIZE initialization parameter, 8.6, 8.6, 8.6

DB_CACHE_SIZE initialization parameter, 8.6

DB_FILE_MULTIBLOCK_READ_COUNT parameter

on AIX, A.2.5

dba group, 1.4.2, 1.4.2

dbhome file, 1.2.3.2

debugger programs, 6.1.4.2

demonstration programs

for Pro*COBOL, 6.4.3

Oracle Call Interface, 6.7.1

Pro*C/C++, 6.3.1

Pro*COBOL, 6.4.2

Pro*FORTRAN, 6.5.1

running Oracle JDBC/OCI demonstrations programs with a 64-bit driver, 6.8

SQL*Module for Ada, 6.6.1

demonstration tables

SQL*Plus, 4.1.3

demonstrations

precompiler, 7.2

direct I/O support

on Linux, C.7

direct I/O support and concurrent I/O support

on Tru64 UNIX, E.6

directed placement optimizations, E.1

disabling on Tru64 UNIX, E.1.3

enabling on Tru64 UNIX, E.1.2

requirements to run on Tru64 UNIX, E.1.1

using on Tru64 UNIX, E.1.4

disabling direct I/O support on Tru64 UNIX, E.6.5

disk

monitoring performance, 8.5

disk I/O

file system type, 8.4.2

I/O slaves, A.2.4

tuning, 8.4

Disk I/O pacing

tuning on AIX, A.2.8

DISM, F.1

DISPLAY environment variable, 1.2.2

documentation

on administration and tuning, Preface

on migrating and upgrading from previous release, Preface

related, Preface

DYLD_LIBRARY_PATH environment variable, 1.2.2

dynamic cache parameters

on Linux, C.1

E

enabling Large Pages on Red Hat Enterprise Linux AS 2.1 and SUSE Linux Enterprise Server 8, C.2

environment variables, 6.4.1.2

for Pro*COBOL, 6.4.1

MicroFocus COBOL compiler, 6.4.1.2

TNS_ADMIN, 5.1

/etc/privgroup file, B.2.1, B.4.1

extended buffer cache support

on Linux, C.1

Extended file system, 8.4.2

F

file buffer cache

tuning the AIX, A.1.2

file system

AdvFS, 8.4.2

CFS, 8.4.2

ext2/ext3, 8.4.2

GPFS, 8.4.2

JFS, 8.4.2

OCFS, 8.4.2

options on AIX, A.2.2.1

S5, 8.4.2

UFS, 8.4.2

VxFS, 8.4.2

file systems, 8.4.2

files

dbhome, 1.2.3.2

/etc/privgroup, B.2.1, B.4.1

root.sh, 1.2.3.2

trace files, 1.6.1

FORMAT precompiler, 6.4.4

Pro*COBOL, 6.4.5

G

getprivgrp command, B.2.1, B.4.1

Glance/UX, 8.2.3.2

glogin.sql file, 4.1.1.1

GPFS

considerations for using, A.2.2.1

groups

OSDBA and OSOPER, 1.4.7

H

High Speed Network Support

on Linux, C.9

HOME environment variable, 1.2.2

HP-UX asynchronous driver

verifying that it is configured for Oracle Database, B.4.3.1

HP-UX dynamic processor reconfiguration

and CPU_COUNT initialization parameter, B.7

HP-UX performance analysis tools, 8.2.3.2

HP-UX performance tuning tools, 8.2.3.1

HP-UX SCHED_NOAGE scheduling policy

description, B.2

HP-UX tools, 8.2.3, 8.2.3.2, 8.2.3.2

I

implementing asynchronous I/O

on HP-UX, B.4.2

increasing SGA address space, C.5

initialization parameters, 1.3

BACKGROUND_DUMP_DEST, 1.6.1

DB_BLOCK_SIZE, 8.6, 8.6, 8.6

DB_CACHE_SIZE, 8.6

JAVA_POOL_SIZE, 8.6

LARGE_POOL_SIZE, 8.6

LOG_BUFFERS, 8.6

MAX_DUMP_FILE, 1.6.1

maximum value for ASYNC in LOG_ARCHIVE_DEST, 1.3.3

SHARED_POOL_SIZE, 8.6

USER_DUMP_DEST, 1.6.1

in-memory file system

when extending buffer cache support on Linux, C.1

installation

Oracle Internet Directory, Preface

Oracle Workflow, Preface

installing SQL*Plus command line help, 4.1.5

interrupting SQL*Plus, 4.2.3

I/O

asynchronous on AIX, A.2.3

asynchronous on HP, B.4

asynchronous on Tru64, E.5

tuning, 8.4

I/O buffers and SQL*Loader

on AIX, A.1.7

I/O slaves, A.2.4

iostat, 8.2.1

IPC protocol, 5.3.1

ireclen, 6.1.4.3

ISM, F.1

iSQL*Plus

starting, 2.1.4

stopping, 2.1.4

J

JAVA_POOL_SIZE initialization parameters, 8.6

JFS and JFS2

considerations, A.2.2.1

Journaled file system, 8.4.2

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, 8.6

LD_LIBRARY_PATH environment variable, 1.2.2

LD_OPTION environment variable, 1.2.2

LIBPATH environment variable, 1.2.2

library

client shared and static libraries, 6.1.6

Lightweight Timer, B.3

lightweight timer implementation

on HP-UX, B.3

limitations of extended buffer cache

on Linux, C.1

Linux tools, 8.2.4

listener

setting up for TCP/IP or TCP/IP with SSL, 5.4

LOG_ARCHIVE_DEST initialization parameter

maximum value for ASYNC in, 1.3.3

LOG_BUFFERS initialization parameters, 8.6

LPDEST environment variable, 1.2.2

lsps command, 8.2.1

M

max_async_req parameter, E.4.1.1

max_objs parameter, E.4.1.1

max_sessions parameter, E.4.1.1

MAXDATAFILES parameter, G.1

maxfree parameter, A.1.1

MAXINSTANCES parameter, G.1, G.1

MAXLOGFILES parameter, G.1

MAXLOGHISTORY parameter, G.1

MAXLOGMEMBERS parameter, G.1

maxperm parameter, A.1.1, A.1.2.1

MAXPERM parameters

tuning on AIX, A.1.2.1

memory

contention, A.1

tuning, 8.3

memory and paging

on AIX, A.1

memory management, 8.3

control paging, 8.3.2

swap space, 8.3.1

MicroFocus COBOL compiler, 6.4.1.2

migration, 3.2.2

minfree parameter, A.1.1

MINPERM, A.1.2.1

minperm parameter, A.1.1, A.1.2.1

MLOCK privilege, B.4.1

on HP-UX, B.4.1

moving from a journaled file system to raw logical volumes, A.2.2.2

moving from raw logical volumes to a journaled file system, A.2.2.3

mpstat command, 8.2.6

msg_size parameter, E.4.1.1

multiple signal handlers, 6.12

N

NUMA

See directed placement optimizations

O

oinstall group, 1.4.2

oper group, 1.4.2

operating system tools, 8.2

ORA_NLS10 environment variable, 1.2.1

ORA_TZFILE environment variable, 1.2.1

oracle account, 1.4.3

oracle advanced security, 5.5

Oracle block size

adjusting, 8.3.3

Oracle C++ Call Interface, 6.7.1

Oracle Call Interface

user programs, 6.7.2

Oracle Call Interface and Oracle C++ Call Interface, 6.7

demonstration programs, 6.7.1

Oracle Data Migration Assistant

upgrading your database, 3.2.2

Oracle Database Configuration Assistant

described, 3.2.3

Oracle Database environment variables

Oracle Database variables, 1.2.1

Oracle Database process

restarting, 2.1.2

stopping, 2.1.2

Oracle Database tuning and large memory allocations

on HP-UX systems, B.5

Oracle environment variables

ORA_NLS10, 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

ORAENV_ASK, 1.2.1, 1.2.1

SQLPATH, 1.2.1, 1.2.1

TWO_TASK, 1.2.1, 1.2.1

Oracle initialization parameters

on Tru64 UNIX, E.1.5

Oracle Management Agent

starting, 2.1.7

stopping, 2.1.7

Oracle Net Configuration Assistant

described, 3.2.1

using, 3.2.1

Oracle Net configuration files, 5.1

Oracle Net listener

restarting, 2.1.3

stopping, 2.1.3

Oracle Net Services

IPC protocol, 5.3.1

oracle advanced security, 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, 6.9

undefined symbols, 6.10

Oracle products

configuring the database for additional, 3.1

Oracle Real Application Clusters

tuning on HP-UX, B.6

Oracle Real Application Clusters and Fault Tolerant IPC

on AIX, A.4.4

Oracle Real Application Clusters requirements

for direct I/O and concurrent I/O support on Tru64 UNIX, E.6.4

oracle run time system

Pro*COBOL, 6.4.2

Oracle System Identifier, 1.2.1

Oracle users

configuring the accounts of, 1.4.8

ORACLE_BASE environment variable, 1.2.1

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

oradism command, F.1

oraenv file

description, 1.2.3.1

ORAENV_ASK, 1.2.1

ORAINVENTORY, 1.4.2

orapwd command, 1.4.5, 1.4.5

orapwd utility, 1.4.5

oreclen, 6.1.4.3

OS_AUTHENT_PREFIX parameter, 1.4.4

OSDBA, 1.4.2

OSDBA and OSOPER groups, 1.4.7

OSOPER, 1.4.2

P

page-out activity, 8.3.2

paging, 8.3.2

excessive, A.1.1, A.1.4

inadequate, A.1.3

paging space, 8.3

allocating sufficient on AIX, A.1.3

tuning, 8.3, 8.3.2

parameters

CREATE CONTROLFILE, G.1

CREATE DATABASE, G.1

max_async_req, E.4.1.1

max_objs, E.4.1.1

max_sessions, E.4.1.1

MAXDATAFILES, G.1

maxfree, A.1.1

MAXLOGFILES, G.1

MAXLOGHISTORY, G.1

MAXLOGMEMBERS, G.1

maxperm, A.1.1, A.1.2.1

minfree, A.1.1

minperm, A.1.1, A.1.2.1

msg_size, E.4.1.1

OS_AUTHENT_PREFIX, 1.4.4

rad_gh_regions, E.1.6

rdg_max_auto_msg_wires, E.4.1.1

SCHED_NOAGE, B.2

SGA_MAX_SIZE, F.1

shm_allocate_striped, E.1.6

shm_max, 8.6

shm_seg, 8.6

shmmax, 8.6

shmseg, 8.6

TIMED_STATISTICS, E.7

PATH environment variable, 1.2.2

per-process max locked memory

VLM Window size and Red Hat Enterprise Linux 3, C.1

PL/SQL demonstrations, 7.2

PL/SQL kernel demonstrations, 7.2

Polycenter advanced file system, 8.4.2

post-installation tasks

configuration assistants, 3.2

precompiler configuration files, 6.1.1

precompiler executables

relinking, 6.1.2

precompiler README files, 6.1.3

precompilers

overview, 6.1

running demonstrations, 7.2

signals, 6.12

uppercase to lowercase conversion, 6.1.4.1

value of ireclen and oreclen, 6.1.4.3

vendor debugger programs, 6.1.4.2

PRINTER environment variable, 1.2.2

privgroup file, B.2.1, B.4.1

Pro*C/C++

demonstration programs, 6.3.1

make files, 6.3.1

signals, 6.12

user programs, 6.3.2

using, 6.3

Pro*COBOL, 6.4, 6.4

demonstration programs, 6.4.2, 6.4.3

environment variables, 6.4.1

FORMAT precompiler, 6.4.4, 6.4.5

naming differences, 6.4

oracle run time system, 6.4.2

user programs, 6.4.4

process affinity to RADs

on Tru64 UNIX, E.1.7

processor binding on SMP systems

using on AIX, A.3.2

PRODUCT_USER_PROFILE Table, 4.1.2

Programmer's Analysis Kit (HP PAK), 8.2.3.2

protocols, 5.3

PTX Agent, 8.2.2.3

R

rad_gh_regions parameter, E.1.6

raw device setup, 1.5.2, 1.5.2

raw devices, 1.5

backing up on AIX, A.2.11

buffer cache size, 8.7

guidelines for using, 1.5.1

Oracle Real Application Clusters installation, 1.5.1

raw disk partition availability, 1.5.1, 1.5.1

setting up, 1.5.1

Tru64, E.8

rdg_max_auto_msg_wires parameter, E.4.1.1

Real Time Clock, E.7

Red Hat Enterprise Linux only

VLM window size and default size of per-process max locked memory, C.1

S

sar, 8.2.1

sar command, 8.3.2

SCHED_NOAGE for Oracle Database

enabling on Oracle Database, B.2.1

SCHED_NOAGE parameter, B.2

security, 1.4.2

features of UNIX, 1.4.2

file ownership, 1.4.2

group accounts, 1.4.2

two-task architecture, 1.4.2

semtimedop support

on Linux, C.8

sequential read ahead

tuning on AIX, A.2.7

setprivgrp command, B.2.1, B.4.1

setup files

SQL*Plus, 4.1.1

SGA, 8.6

determining, 8.6.1

SGA_MAX_SIZE parameter, F.1

shadow process, 1.4.2

shared memory on AIX, 8.6.2

shared memory segments for an Oracle instance

on HP-UX, B.1

SHARED_POOL_SIZE initialization parameters, 8.6

SHLIB_PATH environment variable, 1.2.2

shm_allocate_striped parameter, E.1.6

shm_max parameter, 8.6

shm_seg parameter, 8.6

shmmax parameter, 8.6

shmseg parameter, 8.6

SIGCLD two-task signal, 6.12

SIGINT two-task signal, 6.12

SIGIO two-task signal, 6.12

signal handlers

using, 6.12

signal routine, 6.12

example, 6.12

SIGPIPE two-task signal, 6.12

SIGTERM two-task signal, 6.12

SIGURG two-task signal, 6.12

simultaneous enabling of Oracle Real Application Cluster and NUMA

on Tru64 UNIX, E.4.2

software distribution, 1.2.1

Solaris tools, 8.2.6

special accounts, 1.4.1

Spike optimization tool, E.9

spike optimization tool

on Tru64 UNIX, E.9

SPOOL command

SQL*Plus, 4.2.4

using, 4.2.4

SQL*Loader, A.1.7

SQL*Loader demonstrations, 7.1

SQL*Module for Ada

user programs, 6.6.2

using, 6.6.1

SQL*Module for Ada (AIX only), 6.6

SQL*Plus

command line help, 4.1.4

default editor, 4.2.1

demonstration tables, 4.1.3

editor, 4.2.1

interrupting, 4.2.3, 4.2.3

PRODUCT_USER_PROFILE Table, 4.1.2

restrictions, 4.3

running operating system commands, 4.2.2

setup files, 4.1.1

site profile, 4.1.1.1

SPOOL command, 4.2.4

system editor, 4.2.1

user profile, 4.1.1.2

using command line SQL*Plus, 4.2

SQL*Plus command line help

installing, 4.1.5

SQLPATH environment variable, 1.2.1

ssm_threshold parameter, E.1.6

static and dynamically linking

Oracle libraries and precompilers, 6.1.5

striped logical volume

designing on AIX, A.2.1.1

support for 32-bit and 64-bit client applications, 6.2

swap command, 8.2.1

swap space, 8.3

tuning, 8.3

swapinfo command, 8.2.1

swapon command, 8.2.1

SYS account, 1.4.6

SYSDATE, 1.2.4

SYSTEM, 1.4.6

system editor

SQL*Plus, 4.2.1

system time, 1.2.4

T

TCP/IP protocol, 5.3.3

TCP/IP protocol support, 5.3.2

thread support, 6.11

TIMED_STATISTICS parameter, E.7

TMPDIR environment variable, 1.2.2

trace and alert files

alert files, 1.6.2

trace file names, 1.6.1

using, 1.6, 8.7

tracing Bourne shell scripts, 1.2.1

Tru64 UNIX subsystem attributes

descriptions, E.1.6

tuning, 8.3, 8.3

archiver buffers, A.1.6

disk I/O, 8.4

I/O bottlenecks, 8.4

memory management, 8.3

Oracle Real Application Clusters on HP-UX, B.6

sequential read ahead on AIX, A.2.7

trace and alert files, 1.6, 8.7

UDP, A.4.1

tuning HMP parameters

on HP-UX, B.6.1

tuning Oracle Database on HP-UX

tuning recommendations, B.5.3

tuning Oracle Database on HP-UX systems

large memory allocations, B.5

persistent private SQL areas and memory, B.5.1

tuning recommendations

for Oracle Database on HP-UX, B.5.3

tuning tools

Glance/UX, 8.2.3.2

lsps, 8.2.1

mpstat, 8.2.6

Programmer's Analysis Kit (HP PAK), 8.2.3.2

PTX Agent, 8.2.2.3

PTX Manager, 8.2.2.3

swap, 8.2.1

swapinfo, 8.2.1

swapon, 8.2.1

TWO_TASK environment variable, 1.2.1

U

UDP IPC, E.4.1.2

UDP tuning, A.4.1

Ultra Search

starting, 2.1.5

stopping, 2.1.5

unified file system, 8.4.2

UNIX commands

getprivgrp, B.2.1, B.4.1

setprivgrp, B.2.1, B.4.1

UNIX environment variables

CLASSPATH, 1.2.2

DISPLAY, 1.2.2

DYLD_LIBRARY_PATH, 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

LIBPATH, 1.2.2

LPDEST, 1.2.2

PATH, 1.2.2

PRINTER, 1.2.2

SHLIB_PATH, 1.2.2

TMPDIR, 1.2.2

XENVIRONMENT, 1.2.2

UNIX groups

dba, 1.4.2

oinstall, 1.4.2

oper, 1.4.2

UNIX System V file system, 8.4.2

upgraded databases

configuring, 3.2.4

USE_INDIRECT_DATA_BUFFERS parameter

on Linux, C.1

user interrupt handler, 6.12

user profile

SQL*Plus, 4.1.1.2

user programs

for Pro*C/C++, 6.3.2

Oracle Call Interface and Oracle C++ Call Interface, 6.7.2

Pro*COBOL, 6.4.4

SQL*Module for Ada, 6.6.2

using command line SQL*Plus, 4.2

using hugetlbfs on Red Hat Enterprise Linux AS 2.1, C.3

using hugetlbfs on Red Hat Enterprise Linux AS3, C.4

using Spike

on Tru64 UNIX, E.9.1

UTLRP.SQL

recompiling invalid SQL modules, 3.2.4

V

Veritas file system, 8.4.2

virtual memory data pages

tuning Oracle Database on HP-UX, B.5

virtual memory page size

tuning Oracle Database on HP-UX, B.5.2

vm_stat command, 8.3.2

vmstat, 8.2.1

vmstat command, 8.3.2

X

XA functionality, 6.13

XENVIRONMENT environment variable, 1.2.2

Z

DBAs. See administrators