Index

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

Symbols

@ abbreviation, 1.1

Numerics

32-bit external procedures

calling from PL/SQL, 7.3

A

A_TERM environment variable, 6.4.1.1

A_TERMCAP environment variable, 6.4.1.1

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

operating system accounts, 1.4.7

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

performance toolbox, 8.2.5.2

SMIT, 8.2.5.3

System Management Interface tools, 8.2.5.3

AIXTHREAD_SCOPE environment variable, A.4

alert files, 1.5.2

archive buffers

tuning, A.1.6

ASM_DISKSTRING initialization parameter, 1.3.2

assistants

Oracle Database Configuration Assistant, 3.2.3

Oracle Database Upgrade Assistant, 3.2.2

Oracle Net Configuration Assistant, 3.2.1

asynchronous flag in SGA, B.4.4

asynchronous I/O, B.4, B.4.2

verifying, B.4.3

Automatic Storage Management

restarting, 2.1.2

stopping, 2.1.2

Automatic Storage Management process

restarting, 2.1.2

stopping, 2.1.2

Automatic Storage Management, using, 8.4.1

automating

shutdown, 2.2

startup, 2.2

B

bit-length support, 6.2

block size, A.1.5

adjusting, 8.3.3

buffer cache

extended, limitations, C.1

tuning, A.1.1

buffer cache size

tuning, 8.7

buffer cache support, extended, C.1

buffer manager, 8.3, 8.3

BUFFER parameter, A.1.7

buffer-cache paging activity

controlling, A.1.1

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

commands

iostat, 8.2.3

lsps, 8.2.4

orapwd, 1.4.5

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 I/O, 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.8

Oracle Database, 3.2.4

coraenv file, 1.2.3

CPU scheduling, A.3

CPU_COUNT initialization parameter, B.6, B.6

CREATE CONTROLFILE parameter, G.1

CREATE DATABASE parameter, G.1

CURSOR_SPACE_FOR_TIME initialization parameter

tuning Oracle Database, B.5

D

database

block size, A.1.5

database block size

setting, A.1.5

Database Control

See Oracle Enterprise Manager Database Control

database limits, G.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_proc32.mk make 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 I/O, A.2.2

disk I/O

file system type, 8.4.2

I/O slaves, A.2.4

tuning, 8.4

disk I/O pacing

tuning, A.2.8

disks

monitoring performance, 8.5

DISM, E.1

DISPLAY environment variable, 1.2.2

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

A_TERM, 6.4.1.1

A_TERMCAP, 6.4.1.1

ADA_PATH, 1.2.2

AIXTHREAD_SCOPE, A.4

all, 1.2.1

CLASSPATH, 1.2.2

COBDIR, 6.4.1.2

DISPLAY, 1.2.2

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

LPDEST, 1.2.2

MicroFocus COBOL compiler, 6.4.1.2

ORA_TZFILE, 1.2.1, 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, 1.2.2, 6.4.1.2

SQLPATH, 1.2.1, 1.2.1

TMPDIR, 1.2.2

TNS_ADMIN, 5.1

TWO_TASK, 1.2.1

XENVIRONMENT, 1.2.2

executables

precompiler, 6.1.2

precompilers, 6.1.2

relinking, 3.3

Extended file system, 8.4.2

F

file

services, 5.4

file buffer cache

tuning on AIX, A.1.2

file system

ext2/ext3, 8.4.2

GPFS, 8.4.2

JFS, 8.4.2

OCFS, 8.4.2

S5, 8.4.2

UFS, 8.4.2

VxFS, 8.4.2

file systems, 8.4.2

files

alert, 1.5, 1.5.2

coraenv, 1.2.3

dbhome, 1.2.3

demo_proc32.mk, 6.3.2

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

trace, 1.5, 1.5.1

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

groups

osdba, 1.4.2

See operating system groups

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 Linux, C.3

on SUSE, C.2

I

implementing asynchronous I/O, B.4.2

Import utility, A.1.7

initialization parameters, 1.3

CPU_COUNT, B.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

initialization parameters ASM_DISKSTRING, 1.3.2

initialization parameters DB_BLOCK_SIZE, 1.3.1

initialization parameters LOG_ARCHIVE_DEST_n, 1.3.3

in-memory file system, C.1

ins_precomp.mk file, 6.1.2

installing

SQL*Plus command line Help, 4.1.4.1

intimate shared memory, E.1

I/O

asynchronous, A.2.3, B.4

tuning, 8.4

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

I/O slaves, A.2.4

I/O support

asynchronous, C.5

direct, C.6

iostat command, 8.2.3

IPC protocol, 5.3.1

ireclen, 6.1.4

ISM, E.1

J

JAVA_POOL_SIZE initialization parameters, 8.6

JFS

considerations, A.2.2

JFS2

considerations, A.2.2

Journaled file system, 8.4.2

journaled file system, A.2.2, A.2.2

journaled file systems, 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, 1.2.2, 6.4.1.2

libraries

client shared and static, 6.1.6

Lightweight Timer, B.3

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

See LVM

LPDEST environment variable, 1.2.2

lsps command, 8.2.4

LVM on AIX, A.2.1

M

Mac OS X tools, 8.2.9

make files

demo_proc32.mk, 6.3.2

demo_procob.mk, 6.4.4

ins_precomp.mk, 6.1.2

make files, custom, 6.9

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

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

migrating, 3.2.2

minfree parameter, A.1.1

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

N

network support, C.8

O

OCCI, 6.7

user programs, 6.7.2

OCI, 6.7

user programs, 6.7.2

oinstall group, 1.4.2

operating system buffer cache, tuning, 8.7

operating system commands

getprivgrp, B.2.1, B.4.1

setprivgrp, B.2.1, B.4.1

operating system commands, running, 4.2.2

operating system groups

oinstall, 1.4.2

Oracle Inventory group, 1.4.2

OSDBA, 1.4.7

OSOPER, 1.4.7

osoper, 1.4.2

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

oracle account, 1.4.3

Oracle advanced security, 5.5

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

See OCI

Oracle Call Interface and Oracle C++ Call Interface

demonstration programs, 6.7.1

Oracle Cluster Services Synchronization Daemon

starting, 2.1.3

stopping, 2.1.3

Oracle Database, 3.2.3

restarting, 2.1.2

stopping, 2.1.2

Oracle Database Configuration Assistant

configuring, 3.2.3

Oracle Database environment variables

Oracle Database variables, 1.2.1

Oracle Database process

stopping, 2.1.2

Oracle Database Sample Schemas

Oracle Database tuning and large memory allocations, B.5

Oracle Database Upgrade Assistant, 3.2.2

Oracle Enterprise Manager Database Control

starting, 2.1.6

stopping, 2.1.6

Oracle environment variables

ORA_NLS10, 1.2.1

Oracle Inventory group, 1.4.2

Oracle JDBC/OCI

demonstration programs, 6.8

Oracle Management Agent

starting, 2.1.7

stopping, 2.1.7

Oracle Net Configuration Assistant

using, 3.2.1

Oracle Net Listener

restarting, 2.1.4

stopping, 2.1.4

Oracle Net Services

configuration files, 5.1

IPC protocol, 5.3.1

Oracle advanced security, 5.5

protocol support, 5.3

protocols, 5.3

TCP/IP protocol, 5.3.2

Oracle Net Services TCP/IP with Secure Sockets Layer protocol, 5.3.3

Oracle ODBC Driver, F

Oracle products

configuring the database for additional, 3.1

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 software owner account, 1.4.1

Oracle Ultra Search

starting, 2.1.5

stopping, 2.1.5

Oracle user accounts

configuring, 1.4.8

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, E.1

oraenv file, 1.2.3

ORAENV_ASK environment variable, 1.2.1

orapwd command, 1.4.5

orapwd utility, 1.4.5

oreclen, 6.1.4

OS_AUTHENT_PREFIX parameter, 1.4.4

OSDBA group, 1.4.7

osdba group, 1.4.2

OSOPER group, 1.4.7

osoper group, 1.4.2

ottcfg.cfg file, 6.1.1

P

page-out activity, 8.3.2

paging

controlling, A.1.4

paging space, 8.3

allocating sufficient, A.1.3

tuning, 8.3, 8.3.2

paging, controlling, 8.3.2

parameters

BUFFER, A.1.7

CREATE CONTROLFILE, G.1

CREATE DATABASE, G.1

DB_FILE_MULTIBLOCK_READ_COUNT, A.2.5

dynamic cache, C.1

MAXDATAFILES, G.1

maxfree, A.1.1

MAXLOGFILES, G.1

MAXLOGHISTORY, G.1

MAXLOGMEMBERS, G.1

maxperm, A.1.1, A.1.2

minfree, A.1.1

minperm, A.1.1, A.1.2

OS_AUTHENT_PREFIX, 1.4.4

SCHED_NOAGE, B.2

SGA_MAX_SIZE, E.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

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

pmscfg.cfg file, 6.1.1

postinstallation tasks

configuration assistants, 3.2

precompiler configuration files

files

precompiler configuration, 6.1.1

precompiler executables

relinking, 6.1.2

precompiler README files, 6.1.3

precompilers

executables, 6.1.2

overview, 6.1

Pro*C/C++, 6.3

Pro*COBOL, 6.4

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

private memory, B.5.1

private SQL areas, B.5.1

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*COBOL precompiler, 6.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.3

removing

SQL*Plus command line Help, 4.1.4.2

resilvering, with Oracle Database, A.2.9

restarting

Automatic Storage Management, 2.1.2

Oracle Database, 2.1.2

Oracle Net Listener, 2.1.4

restrictions, SQL*Plus, 4.3

passwords, 4.3.3

resizing windows, 4.3.1

return codes, 4.3.2

root.sh file, 1.2.3

root.sh script, 1.2.3

S

Sample Schemas

See Oracle Database Sample Schemas

sar command, 8.2.2, 8.3.2

SCHED_NOAGE parameter, enabling, B.2.1

SCHED_NOAGE parameter, scheduling policy, B.2

scripts

root.sh, 1.2.3

security, 1.4.2

features of operating system, 1.4.2

file ownership, 1.4.2

group accounts, 1.4.2

two-task architecture, 1.4.2

semtimedop support, C.7

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 address space, increasing, C.4

SGA_MAX_SIZE parameter, E.1

shadow process, 1.4.2

shared memory segments, B.1

shared memory, on AIX, 8.6.2

SHARED_POOL_SIZE initialization parameters, 8.6

SHLIB_PATH environment variable, 1.2.2, 6.4.1.2

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

special accounts

Oracle software owner account, 1.4.1

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

Oracle Enterprise Manager Database Control, 2.1.6

Oracle Management Agent, 2.1.7

Oracle Processes on Mac OS X, 2.1.1

Oracle Ultra Search, 2.1.5

startup

automating, 2.2

static linking

Oracle libraries and precompilers, 6.1.5

stopping

Automatic Storage Management, 2.1.2

Oracle Cluster Services Synchronization Daemon, 2.1.3

Oracle Database, 2.1.2

Oracle Enterprise Manager Database Control, 2.1.6

Oracle Management Agent, 2.1.7

Oracle Net Listener, 2.1.4

Oracle Ultra Search, 2.1.5

striped logical volume

designing, A.2.1

swap command, 8.2.4

swap space, 8.3

determining available and used, D.1

tuning, 8.3

swap space allocation, 8.3.1

swapinfo command, 8.2.4

swapon command, 8.2.4

symfind utility, 6.10

SYS account, 1.4.6

SYSDATE, 1.2.4

SYSTEM account, 1.4.6

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

tuning, 8.3, 8.3

disk I/O, 8.4

I/O bottlenecks, 8.4

memory management, 8.3

sequential read ahead, A.2.7

tuning Oracle Database

large memory allocations, B.5

tuning recommendations, B.5.3

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

Ultra SearchSee Oracle Ultra Search

undefined symbols, 6.10

unified file system, 8.4.2

UNIX System V file system, 8.4.2

upgraded databases

configuring, 3.2.4

upgrading, 3.2.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

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, A.1.7

orapwd, 1.4.5

symfind, 6.10

UTLRP.SQL

recompiling invalid SQL modules, 3.2.4

V

Veritas file system, 8.4.2

virtual memory data pages

tuning Oracle Database, B.5

Virtual Memory Manager

See VMM

virtual memory page size, default, B.5.2

VLM window size, C.1

VMM

vmo command, A.1.1

vmstat command, 8.2.1

X

XA functionality, 6.13

XENVIRONMENT environment variable, 1.2.2

X/Open Distributed Transaction Processing XA interface, 6.13