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, C.4.4
asynchronous input/output, C.4, C.4.2
verifying, C.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, B.1
paging activity, A.1.1
support, B.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, C.6, C.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, B.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
login.sql, 4.1.1
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, C.2.1, C.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, C.2.1, C.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, C.6
HP-UX tools, 8.2.6
Glance/UX, 8.2.6
hugetlbfs
on SUSE, B.2

I

implementing asynchronous input/output, C.4.2
Import utility, A.1.7
initialization parameters, 1.3
ASM_DISKSTRING, 1.3.2
CPU_COUNT, C.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, B.1
input/output
asynchronous, A.2.3, C.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
I/O support
direct, B.4
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, C.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
login.sql file, 4.1.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, C.4.2
minperm parameter, A.1.1, A.1.2
MLOCK privilege, C.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, C.2.1
running, 4.2.2
setprivgrp, C.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, C.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
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, B.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, C.2
SGA_MAX_SIZE, D.1
shm_max, 8.6
shm_seg, 8.6
shmmax, 8.6
shmseg, 8.6
USE_INDIRECT_DATA_BUFFERS, B.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, C.2.1, C.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, C.2.1
scheduling policy, C.2
scripts
root.sh, 1.2.3
sequential read ahead
tuning, A.2.7
services file, 5.4
setprivgrp command, C.2.1, C.4.1
SGA, 8.6
determining the size of, 8.6.1
SGA_MAX_SIZE parameter, D.1
shared memory segments, C.1
shared memory, on AIX, 8.6.3
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, C.5
memory management, 8.3
recommendations, C.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, B.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, C.5
Virtual Memory Manager, A.2.7
virtual memory page size, default, C.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