20/20

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

adapters utility, 5.2

administering command line SQL, 4.1

AIX tools

Base Operation System tools, 8.2.7.1

Performance Tool Box Agent, 8.2.7.2

Performance Tool Box Manager, 8.2.7.2

SMIT, 8.2.7.3

System Management Interface tools, 8.2.7.3

AIXTHREAD_SCOPE environment variable, C.4

archive buffers

tuning, C.1.6

ASM_DISKSTRING initialization parameter, 1.3.1

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, D.4.4

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

verifying, D.4.3

Automatic Storage Management

restarting, 2.1.1.2

stopping, 2.1.1

Automatic Storage Management, using, 8.4.1

automating

shutdown, 2.2

startup, 2.2

---

B

bit-length support, 6.2

block size, C.1.5

adjusting, 8.3.3

buffer cache

paging activity, C.1.1

tuning, C.1.1

tuning size, 8.7

buffer manager, 8.3, 8.3

BUFFER parameter, C.1.7

---

C

cache size, 8.7

catching routine, 6.12

example, 6.12

CLASSPATH environment variable, 1.2.2, 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, C.1.1

vmstat, 8.2.1

common environment

setting, 1.2.3

concurrent input/output, C.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

coraenv file, 1.2.3

CPU scheduling, C.3

CPU_COUNT initialization parameter, D.6, D.6

CREATE CONTROLFILE parameter, F.1

CREATE DATABASE parameter, F.1

---

D

database

block size, C.1.5

database block size

setting, C.1.5

database limits, F.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, C.2.5

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 Call Interface, 6.7.1

Oracle JDBC/OCI, 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, C.2.2

disk input/output

file system type, 8.4.2

input/output

slaves, C.2.4

pacing, C.2.8

tuning, 8.4

disks

monitoring performance, 8.5

DISPLAY environment variable, 1.2.2

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

AIXTHREAD_SCOPE, C.4

all, 1.2.1

CLASSPATH, 1.2.2, 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, C.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

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, D.2.1, D.4.1

README, 6.1.3

root.sh, 1.2.3

services, 5.4

FORMAT precompiler, 6.4.4

Pro*COBOL, 6.4.5

---

G

getprivgrp command, D.2.1, D.4.1

glogin.sql file, 4.1.1

GPFS

considerations for using, C.2.2

---

H

HOME environment variable, 1.2.2

HP-UX dynamic processor reconfiguration, D.6

hugetlbfs

on SUSE, B.1

---

I

implementing asynchronous input/output, D.4.2

Import utility, C.1.7

initialization parameters, 1.3

ASM_DISKSTRING, 1.3.1

CPU_COUNT, D.6

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

SHARED_POOL_SIZE, 8.6

input/output

asynchronous, C.2.3, D.4

slaves, C.2.4

tuning, 8.4

ins_precomp.mk file, 6.1.2

installing

SQL*Plus command line Help, 4.1.4.1

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

I/O support

asynchronous, B.3

direct, B.4

iostat command, 8.2.3

IPC protocol, 5.3.1

ireclen, 6.1.4

---

J

JAVA_POOL_SIZE initialization parameters, 8.6

JFS2 considerations, C.2.2

JFSconsiderations, C.2.2

Journaled file system, 8.4.2, C.2.2, C.2.2, C.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, D.3

Linux tools, 8.2.6

listener

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

LOG_BUFFERS initialization parameters, 8.6

Logical Volume Manager

See LVM

login.sql file, 4.1.1

LPDEST environment variable, 1.2.2

lsps command, 8.2.4

LVM on AIX, C.2.1

---

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, C.1.1

MAXINSTANCES parameter, F.1, F.1

MAXLOGFILES parameter, F.1

MAXLOGHISTORY parameter, F.1

MAXLOGMEMBERS parameter, F.1

maxperm parameter, C.1.1, C.1.2

memory

contention, C.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, C.1.1

minor numbers of 8-bit, D.4.2

minperm parameter, C.1.1, C.1.2

MLOCK privilege, D.4.1

mpstat command, 8.2.5

multiple signal handlers, 6.12

multithreaded applications, 6.11

---

O

OCCI, 6.7

user programs, 6.7.2

OCI, 6.7

user programs, 6.7.2

operating system buffer cache, tuning, 8.7

operating system commands

getprivgrp, D.2.1

running, 4.2.2

setprivgrp, D.2.1

operating system tools

for AIX, 8.2.7

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, 6.7, 6.7.1

See OCCI

Oracle Call Interface, 6.7

demonstration programs, 6.7.1

See OCI

Oracle Cluster Services Synchronization Daemon

starting, 2.1.2

stopping, 2.1.2

Oracle Database, 3.1.3

restarting, 2.1.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.1.1

Oracle Database Sample Schemas

Oracle Database tuning and large memory allocations, D.5

Oracle Database Upgrade Assistant, 3.1.2

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/OCI

demonstration programs, 6.8

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 ODBC Driver, E

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_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, A.1.5

oraenv file, 1.2.3

ORAENV_ASK environment variable, 1.2.1

oreclen, 6.1.4

ottcfg.cfg file, 6.1.1

---

P

page-out activity, 8.3.2

paging

allocating sufficient, C.1.3

controlling, C.1.4

tuning, 8.3

parameters

BUFFER, C.1.7

CREATE CONTROLFILE, F.1

CREATE DATABASE, F.1

DB_FILE_MULTIBLOCK_READ_COUNT, C.2.5

MAXDATAFILES, F.1

maxfree, C.1.1

MAXLOGFILES, F.1

MAXLOGHISTORY, F.1

MAXLOGMEMBERS, F.1

maxperm, C.1.1, C.1.2

minfree, C.1.1

minperm, C.1.1, C.1.2

SCHED_NOAGE, D.2

SGA_MAX_SIZE, A.1.6

shm_max, 8.6

shm_seg, 8.6

shmmax, 8.6

shmseg, 8.6

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.7.2

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, D.2.1, D.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, C.3.2

PRODUCT_USER_PROFILE table, 4.1.2

protocols, 5.3

---

R

raw devices

buffer cache size, 8.7

raw logical volumes, C.2.2, C.2.2, C.2.2

relinking executables, 3.2

removing

SQL*Plus command line Help, 4.1.4.2

resilvering, with Oracle Database, C.2.9

restarting

Automatic Storage Management, 2.1.1.2

Oracle Database, 2.1.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, D.2.1

scheduling policy, D.2

scripts

root.sh, 1.2.3

sequential read ahead

tuning, C.2.7

services file, 5.4

setprivgrp command, D.2.1, D.4.1

SGA, 8.6

determining the size of, 8.6.1

SGA_MAX_SIZE parameter, A.1.6

shared memory segments, D.1

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.2

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.5

SPOOL command

SQL*Plus, 4.2.4

SQL*Loader, C.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.1.2

startup

automating, 2.2

static linking

Oracle libraries and precompilers, 6.1.5

stopping

Oracle Cluster Services Synchronization Daemon, 2.1.2

striped logical volume

designing, C.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

tuning, 8.3

disk input/output, 8.4

input/output bottlenecks, 8.4

large memory allocations, D.5

memory management, 8.3

recommendations, D.5.2

sequential read ahead, C.2.7

tuning tools

iostat command, 8.2.3

lsps command, 8.2.4

mpstat, 8.2.5

Performance Tool Box Agent, 8.2.7.2

Performance Tool Box Manager, 8.2.7.2

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

upgrading, 3.1.2

user interrupt handler, 6.12

user profile

SQL*Plus, 4.1.1

user programs

for Pro*C/C++, 6.3.2

OCCI, 6.7.2

OCI, 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, C.1.7

symfind, 6.10

---

V

Veritas file system, 8.4.2

virtual memory data pages

tuning Oracle Database, D.5

Virtual Memory Manager

See VMM

virtual memory page size, default, D.5.1

VMM

vmo command, C.1.1

vmstat command, 8.2.1

---

X

XA functionality, 6.13

X/Open Distributed Transaction Processing XA interface, 6.13