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

performance toolbox, 8.2.5.2

SMIT, 8.2.5.3

System Management Interface tools, 8.2.5.3

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

Automatic Storage Management

restarting, 2.1.1.2

Automatic Storage Management process

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

adjusting, 8.3.3

buffer cache

extended, limitations, A.1

buffer cache size

tuning, 8.7

buffer cache support, extended, A.1

buffer manager, 8.3, 8.3

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

vmstat, 8.2.1

common environment

setting, 1.2.3

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

CREATE CONTROLFILE parameter, C.1

CREATE DATABASE parameter, C.1

D

Database Control

See Oracle Enterprise Manager Database Control

database limits, C.1

DB_BLOCK_SIZE initialization parameter, 1.3.1, 8.6, 8.6, 8.6

DB_CACHE_SIZE initialization parameter, 8.6

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

disk I/O

file system type, 8.4.2

tuning, 8.4

disks

monitoring performance, 8.5

DISPLAY environment variable, 1.2.2

dynamic cache parameters, A.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

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

services, 5.4

file system

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

file systems, 8.4.2

files

alert, 1.5

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

README, 6.1.3

root.sh, 1.2.3

trace, 1.5

FORMAT precompiler, 6.4.4

Pro*COBOL, 6.4.5

G

glogin.sql file, 4.1.1

H

HOME environment variable, 1.2.2

HP-UX tools, 8.2.6

Glance/UX, 8.2.6

hugetlbfs

on SUSE, A.2

I

initialization parameters, 1.3

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

ins_precomp.mk file, 6.1.2

installing

SQL*Plus command line Help, 4.1.4.1

I/O

tuning, 8.4

I/O support

asynchronous, A.4

iostat command, 8.2.3

IPC protocol, 5.3.1

ireclen, 6.1.4

J

JAVA_POOL_SIZE initialization parameters, 8.6

Journaled file system, 8.4.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

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

LPDEST environment variable, 1.2.2

lsps command, 8.2.4

M

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

MAXINSTANCES parameter, C.1, C.1

MAXLOGFILES parameter, C.1

MAXLOGHISTORY parameter, C.1

MAXLOGMEMBERS parameter, C.1

memory

tuning, 8.3

memory management, 8.3

control paging, 8.3.2

swap space, 8.3.1

MicroFocus COBOL compiler, 6.4.1.1

migrating, 3.1.2

mpstat command, 8.2.8

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, running, 4.2.2

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 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.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 Upgrade Assistant, 3.1.2

Oracle Enterprise Manager Database Control

starting, 2.1.3

stopping, 2.1.3

Oracle environment variables

ORA_NLS10, 1.2.1

Oracle JDBC/OCI

demonstration programs, 6.8

Oracle Management Agent

starting, 2.1.4

stopping, 2.1.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

TCP/IP protocol, 5.3.2

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

Oracle ODBC Driver, B

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

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 space, 8.3

tuning, 8.3, 8.3.2

paging, controlling, 8.3.2

parameters

CREATE CONTROLFILE, C.1

CREATE DATABASE, C.1

dynamic cache, A.1

MAXDATAFILES, C.1

MAXLOGFILES, C.1

MAXLOGHISTORY, C.1

MAXLOGMEMBERS, C.1

shm_max, 8.6

shm_seg, 8.6

shmmax, 8.6

shmseg, 8.6

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

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

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

relinking executables, 3.2

removing

SQL*Plus command line Help, 4.1.4.2

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

scripts

root.sh, 1.2.3

services file, 5.4

SGA, 8.6

determining the size of, 8.6.1

SGA address space, increasing, A.3

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

SPOOL command

SQL*Plus, 4.2.4

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

Oracle Enterprise Manager Database Control, 2.1.3

Oracle Management Agent, 2.1.4

startup

automating, 2.2

static linking

Oracle libraries and precompilers, 6.1.5

stopping

Oracle Cluster Services Synchronization Daemon, 2.1.2

Oracle Enterprise Manager Database Control, 2.1.3

Oracle Management Agent, 2.1.4

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

disk I/O, 8.4

I/O bottlenecks, 8.4

memory management, 8.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

undefined symbols, 6.10

unified file system, 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, A.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

symfind, 6.10

UTLRP.SQL

recompiling invalid SQL modules, 3.1.4

V

Veritas file system, 8.4.2

vmstat command, 8.2.1

X

XA functionality, 6.13

X/Open Distributed Transaction Processing XA interface, 6.13