Index

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

---

Symbols

@ abbreviation, 1-2

---

A

accounts

SCOTT, 1-19

SYS, 1-19

SYSTEM, 1-19

ADA_PATH environment variable, 1-5

adapters utility, 5-3

ADDRESS specification protocols, 5-5

administering SQL, 3-2

aio_max_num parameter, C-6

aio_task_max_num parameter, C-6

AIX tools

PTX Agent, 2-8

PTX Manager, 2-8

ANALYZE_SCHEMA, C-2

ARCHIVELOG, E-16

asynchronous flag for HP, B-7

---

B

BEQ protocol, 5-5

block size, A-6

tuning, 2-14

BUFFER

parameter for imp, A-7

buffer cache size, 2-17

tuning, 2-17

buffer manager, 2-11

buffer-cache

tuning, A-2

---

C

C

Pro*C/C++, 4-8

cache size, 2-17

catching routine, 4-25

example, 4-25

CATPROC.SQL, F-17

changing databases, 1-8

CLASS_PATH environment variable, 1-5

Cluster file system, 2-14

Cluster Manager

argument reference, E-12

starting, E-12

starting options, E-15

threads of, E-3

command interpreter, 1-7

common environment

setting, 1-8

CONFIG_WATCHDOG_NOWAYOUT parameter, E-3

configuration

encapsulator, 5-9

master agent, 5-9

configuration files

Oracle Net, 5-2

Oracle Net Services, 5-2

precompiler, 4-2

coraenv, 1-4

CPU usage

priority level of processes, 2-16

tuning, 2-16

CREATE CONTROLFILE parameter, 1-15

CREATE DATABASE parameter, 1-15

---

D

Data prefetch, B-7

database

block size, A-6

database files, 1-18

DB_BLOCK_BUFFERS initialization parameter, 1-12

DB_BLOCK_SIZE initialization parameter, 1-12

dba group, 1-16

dbhome file, 1-8

debugger programs, 4-4

demonstration programs

oracle call interface, 4-20

Pro*C/C++, 4-8

Pro*COBOL, 4-13

Pro*FORTRAN, 4-16

SQL*Module for Ada, 4-18

demonstration tables

creating manually, 3-3

deleting, 3-4

SQL*Plus, 3-3

demonstrations

PL/SQL, 1-29

precompiler, 1-31

SQL*Loader, 1-25

the procedural option, PL/SQL, 1-29

Direct I/O support on Tru64, C-7

directed placement optimizations, C-18

disk

monitoring performance, 2-15

disk I/O

file system type, 2-14

I/O slaves, A-13

tuning, 2-14

DISM, 1-13

DISPLAY environment variable, 1-6

documentation

accessing, xv

navigation files, xv

on administration and tuning, xvi

on migrating and upgrading from previous release, xvi

related, xvi

where installed, xv

dynamic and static linking

Oracle libraries, 4-4

---

E

encapsulator configuration, 5-9

environment variables, 4-11, 4-12

MicroFocus COBOL compiler, 4-11

ORACLE_DOC, xv

TNS_ADMIN, 5-2

EPC_DISABLED environment variable, 1-3

expst command, C-16

Extended file system, 2-14

---

F

file systems, 2-14

files

dbhome, 1-8

root.sh, 1-8

trace files, 2-20

FORMAT precompiler, 4-14

Pro*COBOL, 4-15

free command, 2-6

---

G

Glance/UX, 2-10

glogin.sql file, 3-2

---

H

help facility, 3-4

HOME environment variable, 1-6

HP Superdome, B-7

HP-UX tools, 2-10, 2-11

HTTP server log files, 1-25

---

I

imp

BUFFER parameter for, A-7

impst command, C-16

initialization parameters

BACKGROUND_DUMP_DEST, 1-20, 2-20

BITMAP_MERGE_AREA_SIZE, 1-20

COMMIT_POINT_STRENGTH, 1-20

CONTROL_FILES, 1-20

CREATE_BITMAP_AREA_SIZE, 1-20

DB_BLOCK_BUFFERS, 1-12

DB_BLOCK_SIZE, 1-12, 1-20

DB_FILE_DIRECT_IO_COUNT, 1-20

DB_FILE_MULTIBLOCK_READ_COUNT, 1-21

DISTRIBUTED_TRANSACTIONS, 1-21

HASH_AREA_SIZE, 1-21

HASH_MULTIBLOCK_IO_COUNT, 1-21

JAVA_POOL_SIZE, 1-12, 1-21

LOCK_SGA, 1-21

LOG_ARCHIVE_DEST, 1-21

LOG_ARCHIVE_FORMAT, 1-21

LOG_BUFFER, 1-21

LOG_CHECKPOINT_INTERVAL, 1-21

MAX_DISPATCHERS, 1-21

MAX_DUMP_FILE, 2-20

MAX_SERVERS, 1-21

NLS_LANGUAGE, 1-21

NLS_TERRITORY, 1-21

OBJECT_CACHE_MAX_SIZE_PERCENT, 1-22

OBJECT_CACHE_OPTIMAL_SIZE, 1-22

OPEN_CURSORS, 1-22

OS_AUTHENT_PREFIX, 1-22

PROCESSES, 1-22

SHARED_POOL_SIZE, 1-12, 1-22

SHARED_SERVERS, 1-21

SORT_AREA_SIZE, 1-22

USER_DUMP_DEST, 2-20

initsid.ora file, 1-20

installation

Oracle Internet Directory, xvi

Oracle Workflow, xvi

instances

commit occurrence on, E-16

Intelligent Agent

configuration on SNMP, 5-9

interMedia

Annotator, D-3

Java Servlet Photo Album Demonstration, D-2

JavaServer Pages Photo Album Demonstration, D-2

ORD Image OCI Demonstration, D-2

ORDAudio Java Demonstration, D-2

ORDAudio SQL Demonstration, D-2

ORDDoc Java Demonstration, D-2

ORDDoc SQL Demonstration, D-2

ORDImage Java Demonstration, D-2

ORDVideo Java Demonstration, D-2

ORDVideo SQL Demonstration, D-2

Web Agent and Clipboard, D-3

interrupting SQL*Plus, 3-7

Intimate Shared Memory, 1-11, 1-12

I/O

asynchronous on AIX, A-11

asynchronous on HP, B-3

asynchronous on Tru64, C-5

tuning, 2-14

I/O slaves, A-13

iostat command, 2-5

IPC protocol, 5-6

ireclen, 4-4

ISM, 1-13

---

J

JAVA_POOL_SIZE initialization parameters, 1-12

Journaled file system, 2-14

---

L

lamport clock

restrictions, E-16

LANG environment variable, 1-6

language, 1-3

LANGUAGE environment variable, 1-6

LD_LIBRARY_PATH environment variable, 1-6

LDPATH environment variable, 1-6

LIBPATH environment variable, 1-6

Lightweight Timer, B-3

Locator, D-3

log writer process (LGWR), 2-16

login.sql file, 3-2

LP_DEST environment variable, 1-6

LPDEST environment variable, 1-6

lsps command, 2-6

---

M

master agent configuration, 5-9

max_async_req parameter, C-3

MAX_COMMIT_PROPAGATION_DELAY parameter, E-15

max_objs parameter, C-3

max_sessions parameter, C-3

MAXDATAFILES parameter, 1-15

maxfree parameter, A-2

MAXINSTANCES parameter, 1-15

MAXLOGFILES parameter, 1-15

MAXLOGHISTORY parameter, 1-15

MAXLOGMEMBERS parameter, 1-15

maxperm parameter, A-2, A-4

memory

contention, A-2

estimating usage, 1-14

tuning, 2-11

virtual, 1-14

memory management, 2-11

control paging, 2-13

swap space, 2-12

MicroFocus COBOL compiler, 4-11

minfree parameter, A-2

minperm parameter, A-2, A-4

MLOCK privilege, B-4

mpstat command, 2-7

msg_size parameter, C-3

multiple signal handlers, 4-25

---

N

National Language Support (NLS) environment variable, 1-3

NLS_LANG environment variable, 1-3

NM. See Node Monitor

Node Monitor

configuring, E-8

starting, E-10

threads of, E-3

NUMA

See directed placement optimizations

---

O

OCMS

Watchdog daemon, E-3

oinstall group, 1-17

oper group, 1-17

Optimal Flexible Architecture

characteristics of OFA, F-2

file mapping, F-2, F-11

ORA_NLS environment variable, 1-3

ORA_TZFILE environment variable, 1-3

oracle account, 1-18

oracle advanced security, 5-11

oracle call interface, 4-20

demonstration programs, 4-20

oracle enterprise manager intelligent agent, 5-9

Oracle environment variables

EPC_DISABLED, 1-3

NLS_LANG, 1-3

ORA_NLS, 1-3

ORA_NLS33, 1-3

ORA_TZFILE, 1-3

ORACLE_BASE, 1-3

ORACLE_HOME, 1-4

ORACLE_PATH, 1-4

ORACLE_SID, 1-4

ORACLE_TRACE, 1-4

Oracle9i variables, 1-3

ORAENV_ASK, 1-4

SQLPATH, 1-4

TNS_ADMIN, 1-5

TWO_TASK, 1-5

Oracle HTTP Server, 1-24

Oracle libraries

static and dynamic linking, 4-4

Oracle Net

products and features, 5-2

Oracle Net configuration files, 5-2

Oracle Net Services

adapters utility, 5-3

ADDRESS specification, 5-4

BEQ protocol, 5-5

files and utilities, 5-2

IPC protocol, 5-6

oracle advanced security, 5-11

oracle enterprise manager intelligent agent, 5-9

protocol support, 5-4

protocols, 5-4

RAW protocol, 5-7

TCP/IP protocol, 5-7

Oracle Net Services configuration files, 5-2

oracle precompiler and OCI linking and makefiles

custom makefiles, 4-22

undefined symbols, 4-23

oracle run time system

Pro*COBOL, 4-13

oracle software owner, 1-16

special accounts, 1-16

Oracle System Identifier, 1-4

Oracle TCP/IP protocol, 5-7

Oracle Text, D-4

ORACLE_BASE environment variable, 1-3

ORACLE_DOC environment variable, xv

ORACLE_HOME environment variable, 1-4

ORACLE_PATH environment variable, 1-4

ORACLE_SID environment variable, 1-2, 1-4

Oracle9i Spatial, D-4

oracm, E-12

oradism command, 1-13

oraenv file

description, 1-8

moving between databases, 1-8

ORAENV_ASK, 1-4

ORAINVENTORY, 1-17

orapwd command, 1-19

orapwd utility, 1-19

oreclen, 4-4

OS_AUTHENT_PREFIX parameter, 1-18

OSDBA, 1-16

OSOPER, 1-17

---

P

page-out activity, 2-13

paging, 2-13

excessive, A-2, A-5

inadequate, A-5

paging space, 2-11

tuning, 2-11, 2-13

parameters

aio_max_num, C-6

aio_task_max_num, C-6

CONFIG_WATCHDOG_NOWAYOUT, E-3

CREATE CONTROLFILE, 1-15

CREATE DATABASE, 1-15

max_async_req, C-3

MAX_COMMIT_PROPAGATION_DELAY, E-15

max_objs, C-3

max_sessions, C-3

MAXDATAFILES, 1-15

maxfree, A-2

MAXLOGFILES, 1-15

MAXLOGHISTORY, 1-15

MAXLOGMEMBERS, 1-15

maxperm, A-2, A-4

minfree, A-2

minperm, A-2, A-4

msg_size, C-3

OS_AUTHENT_PREFIX, 1-18

rad_gh_regions, C-21

rdg_max_auto_msg_wires, C-3

SCHED_NOAGE, B-2

SGA_MAX_SIZE, 1-13

shm_allocate_striped, C-21

SHM_MAX, 1-11

SHM_SEG, 1-11

SHMMAX, 1-11

SHMSEG, 1-11

THREAD, E-16

TIMED_STATISTICS, B-3, C-9

TRU64_IPC_NET, C-5

PATH environment variable, 1-7

PL/SQL demonstrations, 1-29

loading, 1-29

Polycenter advanced file system, 2-14

precompiler configuration files, 4-2

precompilers

overview, 4-2

running demonstrations, 1-31

signals, 4-25

uppercase to lowercase conversion, 4-4

value of ireclen and oreclen, 4-4

values, 4-4

vendor debugger programs, 4-4

PRINTER environment variable, 1-7

Pro*C/C++

demonstration programs, 4-8

make files, 4-8

signals, 4-25

using, 4-8

Pro*COBOL, 4-10

demonstration programs, 4-13

FORMAT precompiler, 4-14, 4-15

naming differences, 4-10

oracle run time system, 4-13

user programs, 4-14

using, 4-12

PRODUCT_USER_PROFILE Table, 3-3

Programmer's Analysis Kit (HP PAK), 2-11

protocols, 5-4

ADDRESS specification, 5-5

PTX Agent, 2-8

---

R

rad_gh_regions parameter, C-21

raw device setup, 2-19

raw devices, 2-17

buffer cache size, 2-17

guidelines for using, 2-18

Oracle9i Real Application Clusters installation, 2-18

raw disk partition availability, 2-18

setting up, 2-18

Tru64, C-10

RAW protocol, 5-7

rdg_max_auto_msg_wires parameter, C-3

Real Time Clock, C-9

related documentation, xvi

Reliable Data Gram, C-3

relinking, 1-9

remote connections parameters

OS_AUTHENT_PREFIX, 1-19

resource contention

tuning, 2-16

restrictions (SQL*Plus), 3-7

resizing windows, 3-7

return codes, 3-7

root.sh script, 1-8

running operating system commands, 3-6

---

S

sar command, 2-4, 2-13

SCHED_NOAGE parameter, B-2

SCOTT account, 1-19

scripts

start_peer, 5-10

security, 1-17, 1-18

features of UNIX, 1-17

file ownership, 1-17

group accounts, 1-17

two-task architecture, 1-17

setup files

SQL*Plus, 3-2

SGA, 1-11, A-7

determining, 1-12

SGA_MAX_SIZE parameter, 1-13

shadow process, 1-17

SHARED_POOL_SIZE initialization parameters, 1-12

SHELL environment variable, 1-7

SHLIB_PATH environment variable, 1-7

shm_allocate_striped parameter, C-21

SHM_MAX parameter, 1-11

SHM_SEG parameter, 1-11

SHMMAX parameter, 1-11

SHMSEG parameter, 1-11

SIGCLD two-task signal, 4-24

SIGINT two-task signal, 4-24

SIGIO two-task signal, 4-24

signal handlers

using, 4-24

signal routine, 4-25

example, 4-25

SIGPIPE two-task signal, 4-24

SIGTERM two-task signal, 4-24

SIGURG two-task signal, 4-24

Simple Network Management Protocol (SNMP), 5-9

smit

See System Management Interface Tool

SNMP

and Intelligent Agent, 5-9

SNMP and Intelligent Agent, 5-9

snmpd executable, 5-10

software distribution, 1-4

Spatial demonstrations, D-4

special accounts, 1-16

Spike optimization tool, C-12

SPOOL command

SQL*Plus, 3-7

using, 3-7

SQL scripts, 2-11

SQL*Loader, A-7

SQL*Module for Ada

user programs, 4-19

using, 4-18

SQL*Plus

default editor, 3-6

demonstration tables, 3-3

editor, 3-6

help, 3-4

help facility, 3-4

interrupting, 3-7

PRODUCT_USER_PROFILE Table, 3-3

restrictions, 3-7

running operating system commands, 3-6

setup files, 3-2

site profile, 3-2

SPOOL command, 3-7

system editor, 3-6

user profile, 3-2

using, 3-6

SQLPATH environment variable, 1-4

SSL, 1-24

ssm_threshold parameter, C-21

start_peer script, 5-10

static and dynamic linking

oracle libraries, 4-4

Sun Nihongo COBOL, 4-12

compiler environment variables, 4-12

swap command, 2-6

swap space, 2-11

tuning, 2-11

swapinfo command, 2-6

swapon command, 2-6

SYS account, 1-19

SYSDATE, 1-9

SYSTEM, 1-19

system editor

SQL*Plus, 3-6

system time, 1-9

---

T

TCP/IP protocol, 5-7

ADDRESS, 5-6, 5-8

THREAD initialization parameter, E-16

thread support, 4-24

TIMED_STATISTICS parameter, B-3, C-9

TMPDIR environment variable, 1-7

TNS listener, 5-7

configuring for Oracle TCP/IP protocol, 5-7

TNS_ADMIN environment variable, 1-5

tools, 2-3

trace and alert files

alert files, 2-20

trace file names, 2-20

using, 2-17, 2-20

tracing Bourne shell scripts, 1-4

TRU64_IPC_NET parameter, C-5

tuning, 2-11

archiver buffers, A-6

CPU usage, 2-16

disk I/O, 2-14

I/O bottlenecks, 2-14

memory management, 2-11

resource contention, 2-16

SGA on AIX, A-7

trace and alert files, 2-17, 2-20

UDP, A-21

tuning tools

AIX System Management Interface Tool, 2-7

free, 2-6

Glance/UX, 2-10

iostat, 2-5

lsps, 2-6

mpstat, 2-7

Programmer's Analysis Kit (HP PAK), 2-11

PTX Agent, 2-8

PTX Manager, 2-8

sar, 2-4

swap, 2-6

swapinfo, 2-6

swapon, 2-6

vmstat, 2-3

TWO_TASK environment variable, 1-5

---

U

UDP IPC, C-4

UDP tuning, A-21

unified file system, 2-14

UNIX environment variables

ADA_PATH, 1-5

CLASSPATH, 1-5

DISPLAY, 1-6

HOME, 1-6

LANG, 1-6

LANGUAGE, 1-6

LD_LIBRARY_PATH, 1-6

LD_OPTIONS, 1-6

LDPATH, 1-6

LIBPATH, 1-6

LPDEST, 1-6

PATH, 1-5, 1-7

PRINTER, 1-7

SHELL, 1-7

SHLIB_PATH, 1-7

TMPDIR, 1-7

XENVIRONMENT, 1-7

UNIX groups

dba, 1-16

oinstall, 1-17

oper, 1-17

UNIX System V file system, 2-14

user interrupt handler, 4-25

user profile

SQL*Plus, 3-2

user programs

Pro*COBOL, 4-14

SQL*Module for Ada, 4-19

using SQL*Plus, 3-6

---

V

Veritas file system, 2-14

vmstat command, 2-3, 2-13

vmtune command, A-2

---

W

Watchdog daemon

description, E-3

polling, E-7

starting, E-6

starting options, E-15

---

X

XA functionality, 4-26

XENVIRONMENT environment variable, 1-7