Index

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

Symbols

@ abbreviation, 1.1

A

A_TERM environment variable, 6.4.1.2

A_TERMCAP environment variable, 6.4.1.2

ADA_PATH environment variable, 1.2.2

adapters utility, 5.2

administering command line SQL, 4.1

administrators

operating system accounts, 1.4.1

AIX tools

Base Operation System tools, 8.2.5.1

Performance Tool Box Agent, 8.2.5.2

Performance Tool Box Manager, 8.2.5.2

SMIT, 8.2.5.3

System Management Interface tools, 8.2.5.3

AIXTHREAD_SCOPE environment variable, A.4

archive buffers

tuning, A.1.6

ASM_DISKSTRING initialization parameter, 1.3.2

assistants

Oracle Database Configuration Assistant, 3.1.3

Oracle Database Upgrade Assistant, 3.1.2

Oracle Net Configuration Assistant, 3.1.1

asynchronous flag in SGA, B.4.4

asynchronous input/output, B.4, B.4.2

verifying, B.4.3

Automatic Storage Management

restarting, 2.2.1.2

stopping, 2.2.1

Automatic Storage Management, using, 8.4.1

automating

shutdown, 2.1

startup, 2.1

B

bit-length support, 6.2

block size, A.1.5

adjusting, 8.3.3

buffer cache

limitations, C.1

paging activity, A.1.1

support, C.1

tuning, A.1.1

tuning size, 8.7

buffer manager, 8.3, 8.3

BUFFER parameter, A.1.7

C

cache size, 8.7

catching routine, 6.12

example, 6.12

CLASSPATH environment variable, 1.2.2

client shared libraries, 6.1.6

client static libraries, 6.1.6

COBDIR environment variable, 6.4.1.1

commands

iostat, 8.2.3

lsps, 8.2.4

sar, 8.2.2

SPOOL, 4.2.4

swap, 8.2.4

swapinfo, 8.2.4

swapon, 8.2.4

vmo, A.1.1

vmstat, 8.2.1

common environment

setting, 1.2.3

concurrent input/output, A.2.2

configuration files

ottcfg.cfg, 6.1.1

pcbcfg.cfg, 6.1.1

pccfor.cfg, 6.1.1

pcscfg.cfg, 6.1.1

pmscfg.cfg, 6.1.1

precompiler, 6.1.1

configuring

accounts of Oracle users, 1.4.2

Oracle Database, 3.1.4

coraenv file, 1.2.3

CPU scheduling, A.3

CPU_COUNT initialization parameter, B.6, B.6

CREATE CONTROLFILE parameter, F.1

CREATE DATABASE parameter, F.1

D

database

block size, A.1.5

database block size

setting, A.1.5

Database Control

See Oracle Enterprise Manager Database Control

database limits, F.1

DB_BLOCK_SIZE initialization parameter, 1.3.1, 8.6, 8.6, 8.6

DB_CACHE_SIZE initialization parameter, 8.6

DB_FILE_MULTIBLOCK_READ_COUNT parameter, A.2.5

DBAs

See administrators

dbhome file, 1.2.3

debugger programs, 6.1.4

demo_proc32.mk file, 6.3.2

demo_procob.mk file, 6.4.4

demonstration programs

for Pro*COBOL, 6.4.3

Oracle JDBC/Oracle Call Interface, 6.8

Pro*C/C++, 6.3.1

Pro*FORTRAN, 6.5.1

SQL*Module for Ada, 6.6.1

demonstrations

PL/SQL, 7.2

precompiler, 7.2

SQL*Loader, 7.1

direct input/output, A.2.2

disk input/output

file system type, 8.4.2

input/output

slaves, A.2.4

pacing, A.2.8

tuning, 8.4

disks

monitoring performance, 8.5

DISM, D.1

DISPLAY environment variable, 1.2.2

dynamic cache parameters, C.1

dynamic linking

Oracle libraries and precompilers, 6.1.5

E

environment variables, 6.4.1.1

A_TERM, 6.4.1.2

A_TERMCAP, 6.4.1.2

ADA_PATH, 1.2.2

AIXTHREAD_SCOPE, A.4

all, 1.2.1

CLASSPATH, 1.2.2

COBDIR, 6.4.1.1

DISPLAY, 1.2.2

for Pro*COBOL, 6.4.1

HOME, 1.2.2

LANG, 1.2.2

LANGUAGE, 1.2.2

LD_LIBRARY_PATH, 1.2.2, 6.4.1.1, 6.4.1.2

LD_OPTIONS, 1.2.2

LIBPATH, 6.4.1.1

LPDEST, 1.2.2

MicroFocus COBOL compiler, 6.4.1.1

ORA_TZFILE, 1.2.1

ORACLE_BASE, 1.2.1

ORACLE_HOME, 1.2.1

ORACLE_PATH, 1.2.1

ORACLE_SID, 1.1, 1.2.1, 1.2.1

ORACLE_TRACE, 1.2.1

ORAENV_ASK, 1.2.1

PATH, 1.2.2, 4.2.1, 6.4.1.1, 6.4.1.2

PRINTER, 1.2.2

SHLIB_PATH, 6.4.1.1

SQLPATH, 1.2.1, 1.2.1

TMPDIR, 1.2.2

TNS_ADMIN, 5.1

TWO_TASK, 1.2.1

executables

precompiler, 6.1.2

precompilers, 6.1.2

relinking, 3.2

Extended file system, 8.4.2

F

file buffer cache

tuning on AIX, A.1.2

file systems

ext2/ext3, 8.4.2

GPFS, 8.4.2

JFS, 8.4.2

OCFS2, 8.4.2

S5, 8.4.2

UFS, 8.4.2

VxFS, 8.4.2

files

alert, 1.5

coraenv, 1.2.3

dbhome, 1.2.3

demo_procob.mk, 6.4.4

glogin.sql, 4.1.1

ins_precomp.mk, 6.1.2

Oracle Net Services configuration, 5.1

oraenv, 1.2.3

ottcfg.cfg, 6.1.1

pcbcfg.cfg, 6.1.1

pccfor.cfg, 6.1.1

pcscfg.cfg, 6.1.1

pmscfg.cfg, 6.1.1

privgroup, B.2.1, B.4.1

README, 6.1.3

root.sh, 1.2.3

services, 5.4

trace, 1.5

FORMAT precompiler, 6.4.4

Pro*COBOL, 6.4.5

G

getprivgrp command, B.2.1, B.4.1

glogin.sql file, 4.1.1

GPFS

considerations for using, A.2.2

H

HOME environment variable, 1.2.2

HP-UX dynamic processor reconfiguration, B.6

HP-UX tools, 8.2.6

Glance/UX, 8.2.6

hugetlbfs

on SUSE, C.2

I

implementing asynchronous input/output, B.4.2

Import utility, A.1.7

initialization parameters, 1.3

ASM_DISKSTRING, 1.3.2

CPU_COUNT, B.6

DB_BLOCK_SIZE, 1.3.1, 8.6, 8.6, 8.6

DB_CACHE_SIZE, 8.6

JAVA_POOL_SIZE, 8.6

LARGE_POOL_SIZE, 8.6

LOG_ARCHIVE_DEST_n, 1.3.3

LOG_BUFFERS, 8.6

SHARED_POOL_SIZE, 8.6

in-memory file system, C.1

input/output

asynchronous, A.2.3, B.4

slaves, A.2.4

tuning, 8.4

ins_precomp.mk file, 6.1.2

installing

SQL*Plus command line Help, 4.1.4.1

intimate shared memory, D.1

I/O buffers and SQL*Loader, A.1.7

iostat command, 8.2.3

IPC protocol, 5.3.1

ireclen, 6.1.4

ISM, D.1

J

JAVA_POOL_SIZE initialization parameters, 8.6

JFS2 considerations, A.2.2

JFSconsiderations, A.2.2

Journaled file system, 8.4.2, A.2.2, A.2.2, A.2.2

L

LANG environment variable, 1.2.2

LANGUAGE environment variable, 1.2.2

LARGE_POOL_SIZE initialization parameters, 8.6

LD_LIBRARY_PATH environment variable, 1.2.2, 6.4.1.1, 6.4.1.2

LD_OPTIONS environment variable, 1.2.2

LIBPATH environment variable, 6.4.1.1

libraries

client shared and static, 6.1.6

lightweight timer implementation, B.3

Linux tools, 8.2.7

listener

setting up for TCP/IP or TCP/IP with Secure Sockets Layer, 5.4

LOG_ARCHIVE_DEST_n initialization parameter, 1.3.3

LOG_BUFFERS initialization parameters, 8.6

Logical Volume Manager, A.2.1

LPDEST environment variable, 1.2.2

lsps command, 8.2.4

M

make files

custom, 6.9

demo_proc32.mk, 6.3.2

demo_procob.mk, 6.4.4

ins_precomp.mk, 6.1.2

MAXDATAFILES parameter, F.1

maxfree parameter, A.1.1

MAXINSTANCES parameter, F.1, F.1

MAXLOGFILES parameter, F.1

MAXLOGHISTORY parameter, F.1

MAXLOGMEMBERS parameter, F.1

maxperm parameter, A.1.1, A.1.2

memory

contention, A.1

control paging, 8.3.2

swap space, 8.3.1

tuning, 8.3

MicroFocus COBOL compiler, 6.4.1.1

migrating, 3.1.2

minfree parameter, A.1.1

minor numbers of 8-bit, B.4.2

minperm parameter, A.1.1, A.1.2

MLOCK privilege, B.4.1

mpstat command, 8.2.8

multiple signal handlers, 6.12

multithreaded applications, 6.11

O

operating system buffer cache, tuning, 8.7

operating system commands

getprivgrp, B.2.1

running, 4.2.2

setprivgrp, B.2.1

operating system groups

OSDBA, 1.4.1

OSOPER, 1.4.1

operating system tools

for AIX, 8.2.5

iostat, 8.2.3

lsps, 8.2.4

sar, 8.2.2

swap, 8.2.4

swapinfo, 8.2.4

swapon, 8.2.4

vmstat, 8.2.1

ORA_NLS10 environment variable, 1.2.1

ORA_TZFILE environment variable, 1.2.1

Oracle block size, adjusting, 8.3.3

Oracle buffer manager, 8.3

Oracle C++ Call Interface

demonstration programs, 6.7.1

overview, 6.7

user programs, 6.7.2

Oracle Call Interface

demonstration programs, 6.7.1

overview, 6.7

user programs, 6.7.2

Oracle Cluster Services Synchronization Daemon

starting, 2.2.2

stopping, 2.2.2

Oracle Database, 3.1.3

restarting, 2.2.1.2

Oracle Database Configuration Assistant

configuring, 3.1.3

Oracle Database environment variables

Oracle Database variables, 1.2.1

Oracle Database process

stopping, 2.2.1

Oracle Database Sample Schemas, 4.1.3

Oracle Database tuning and large memory allocations, B.5

Oracle Database Upgrade Assistant, 3.1.2

Oracle Enterprise Manager Database Control

starting, 2.2.3

stopping, 2.2.3

Oracle environment variables

ORA_NLS10, 1.2.1

ORACLE_BASE, 1.2.1

ORACLE_HOME, 1.2.1

ORACLE_SID, 1.2.1

Oracle JDBC/Oracle Call Interface

demonstration programs, 6.8

Oracle Management Agent

starting, 2.2.4

stopping, 2.2.4

Oracle Net Configuration Assistant

using, 3.1.1

Oracle Net Services

configuration files, 5.1

IPC protocol, 5.3.1

Oracle advanced security, 5.5

protocol support, 5.3

protocols, 5.3

Secure Sockets Layer protocol, 5.3.3

TCP/IP protocol, 5.3.2

Oracle Protocol Support

IPC protocol, 5.3.1

TCP/IP protocol, 5.3.2

TCP/IP with Secure Sockets Layer protocol, 5.3.3

Oracle user accounts

configuring, 1.4.2

ORACLE_BASE environment variable, 1.2.1

ORACLE_HOME environment variable, 1.2.1

ORACLE_PATH environment variable, 1.2.1

ORACLE_SID environment variable, 1.1, 1.2.1, 1.2.1

ORACLE_TRACE environment variable, 1.2.1

oradism command, D.1

oraenv file, 1.2.3

ORAENV_ASK environment variable, 1.2.1

oreclen, 6.1.4

OSDBA group, 1.4.1

OSOPER group, 1.4.1

ottcfg.cfg file, 6.1.1

P

page-out activity, 8.3.2

paging

allocating sufficient, A.1.3

controlling, A.1.4

tuning, 8.3

parameters

BUFFER, A.1.7

CREATE CONTROLFILE, F.1

CREATE DATABASE, F.1

DB_FILE_MULTIBLOCK_READ_COUNT, A.2.5

dynamic cache, C.1

MAXDATAFILES, F.1

maxfree, A.1.1

MAXLOGFILES, F.1

MAXLOGHISTORY, F.1

MAXLOGMEMBERS, F.1

maxperm, A.1.1, A.1.2

minfree, A.1.1

minperm, A.1.1, A.1.2

SCHED_NOAGE, B.2

SGA_MAX_SIZE, D.1

shm_max, 8.6

shm_seg, 8.6

shmmax, 8.6

shmseg, 8.6

USE_INDIRECT_DATA_BUFFERS, C.1

PATH environment variable, 1.2.2, 4.2.1, 6.4.1.1, 6.4.1.2

pcbcfg.cfg file, 6.1.1

pccfor.cfg file, 6.1.1

pcscfg.cfg file, 6.1.1

Performance Tool Box Agent, 8.2.5.2

performance tuning tools, 8.2.6

PL/SQL demonstrations, 7.2

PL/SQL kernel demonstrations, 7.2

pmscfg.cfg file, 6.1.1

postinstallation tasks

configuration assistants, 3.1

precompiler executables

relinking, 6.1.2

precompilers

executables, 6.1.2

overview, 6.1

Pro*C/C++, 6.3

Pro*COBOL, 6.4

README files, 6.1.3

running demonstrations, 7.2

signals, 6.12

uppercase to lowercase conversion, 6.1.4

value of ireclen and oreclen, 6.1.4

vendor debugger programs, 6.1.4

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

Pro*C/C++ precompiler, 6.3

Pro*COBOL

demonstration programs, 6.4.3

environment variables, 6.4.1

FORMAT precompiler, 6.4.4, 6.4.5

naming differences, 6.4

Oracle Runtime system, 6.4.2

user programs, 6.4.4

Pro*FORTRAN demonstration programs, 6.5.1

processor binding on SMP systems

using, A.3.2

PRODUCT_USER_PROFILE table, 4.1.2

Programmer's Analysis Kit, 8.2.6

protocols, 5.3

R

raw devices

buffer cache size, 8.7

raw logical volumes, A.2.2, A.2.2, A.2.2

relinking executables, 3.2

removing

SQL*Plus command line Help, 4.1.4.2

resilvering, with Oracle Database, A.2.9

restarting

Automatic Storage Management, 2.2.1.2

Oracle Database, 2.2.1.2

restrictions, SQL*Plus, 4.3

passwords, 4.3.3

resizing windows, 4.3.1

return codes, 4.3.2

root.sh script, 1.2.3

S

Sample Schemas

See Oracle Database Sample Schemas

sar command, 8.2.2, 8.3.2

SCHED_NOAGE

enabling, B.2.1

scheduling policy, B.2

scripts

root.sh, 1.2.3

sequential read ahead

tuning, A.2.7

services file, 5.4

setprivgrp command, B.2.1, B.4.1

SGA, 8.6

determining the size of, 8.6.1

SGA_MAX_SIZE parameter, D.1

shared memory segments, B.1

shared memory, on AIX, 8.6.2

SHARED_POOL_SIZE initialization parameters, 8.6

SHLIB_PATH environment variable, 6.4.1.1

shm_max parameter, 8.6

shm_seg parameter, 8.6

shmmax parameter, 8.6

shmseg parameter, 8.6

shutdown

automating, 2.1

SIGCLD signal, 6.12

SIGCONT signal, 6.12

SIGINT signal, 6.12

SIGIO signal, 6.12

signal handlers, 6.12

signal routine, 6.12

example, 6.12

signals

SIGCLD, 6.12

SIGCONT, 6.12

SIGINT, 6.12

SIGIO, 6.12

SIGPIPE, 6.12

SIGTERM, 6.12

SIGURG, 6.12

SIGPIPE signal, 6.12

SIGTERM signal, 6.12

SIGURG signal, 6.12

Solaris tools, 8.2.8

SPOOL command

SQL*Plus, 4.2.4

SQL*Loader, A.1.7

SQL*Loader demonstrations, 7.1

SQL*Module for Ada, 6.6

demonstration programs, 6.6.1

user programs, 6.6.2

SQL*Plus

command line Help, 4.1.4

default editor, 4.2.1

editor, 4.2.1

interrupting, 4.2.3

PRODUCT_USER_PROFILE table, 4.1.2

restrictions, 4.3

running operating system commands, 4.2.2

site profile, 4.1.1

SPOOL command, 4.2.4

system editor, 4.2.1

user profile, 4.1.1

using command-line SQL*Plus, 4.2

SQL*Plus command line Help

installing, 4.1.4.1

removing, 4.1.4.2

SQL*Plus, interrupting, 4.2.3

SQLPATH environment variable, 1.2.1, 1.2.1

starting

Oracle Cluster Services Synchronization Daemon, 2.2.2

Oracle Enterprise Manager Database Control, 2.2.3

Oracle Management Agent, 2.2.4

startup

automating, 2.1

static linking

Oracle libraries and precompilers, 6.1.5

stopping

Oracle Cluster Services Synchronization Daemon, 2.2.2

Oracle Enterprise Manager Database Control, 2.2.3

Oracle Management Agent, 2.2.4

striped logical volume

designing, A.2.1

swap command, 8.2.4

swap space, 8.3

tuning, 8.3

swap space allocation, 8.3.1

swapinfo command, 8.2.4

swapon command, 8.2.4

symfind utility, 6.10

SYSDATE, 1.2.4

system editor

SQL*Plus, 4.2.1

system time, 1.2.4

T

tables

PRODUCT_USER_PROFILE, 4.1.2

TCP/IP protocol, 5.3.2

TCP/IP with Secure Sockets Layer protocol, 5.3.3

thread support, 6.11

TMPDIR environment variable, 1.2.2

trace alert, 1.5

trace files, 1.5

tuning, 8.3

disk input/output, 8.4

input/output bottlenecks, 8.4

large memory allocations, B.5

memory management, 8.3

recommendations, B.5.2

sequential read ahead, A.2.7

tuning tools

Glance/UX utility, 8.2.6

iostat command, 8.2.3

lsps command, 8.2.4

mpstat, 8.2.8

Performance Tool Box Agent, 8.2.5.2

Performance Tool Box Manager, 8.2.5.2

Programmer's Analysis Kit, 8.2.6

sar command, 8.2.2

swap command, 8.2.4

swapinfo command, 8.2.4

swapon command, 8.2.4

vmstat command, 8.2.1

TWO_TASK environment variable, 1.2.1

U

undefined symbols, 6.10

unified file systems, 8.4.2

UNIX System V file system, 8.4.2

upgraded databases

configuring, 3.1.4

upgrading, 3.1.2

USE_INDIRECT_DATA_BUFFERS parameter, C.1

user interrupt handler, 6.12

user profile

SQL*Plus, 4.1.1

user programs

for Pro*C/C++, 6.3.2

Oracle C++ Call Interface, 6.7.2

Oracle Call Interface, 6.7.2

Pro*C/C++, 6.3.2

Pro*COBOL, 6.4.4

SQL*Module for Ada, 6.6.2

using command-line SQL*Plus, 4.2

utilities

adapters, 5.2

Import, A.1.7

symfind, 6.10

UTLRP.SQL

recompiling invalid SQL modules, 3.1.4

V

Veritas file system, 8.4.2

virtual memory data pages

tuning Oracle Database, B.5

Virtual Memory Manager, A.2.7

virtual memory page size, default, B.5.1

vmo command, A.1.1

vmstat command, 8.2.1

X

XA functionality, 6.13

X/Open Distributed Transaction Processing XA interface, 6.13