Index

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

---

Symbols

? abbreviation, 1-2

@ abbreviation, 1-2

---

A

accounts, 1-19

adapters utility, 6-3

ADDRESS specification protocols, 6-6

administering SQL, 3-2

advanced-developer demo, 7-8

APPC/LU6.2 protocol, 6-10, 6-11

ADDRESS, 6-12

Solaris 2.x-specific listener, 6-11

asynchronous I/O, 2-8

using, 2-8

authorization, 1-21

automatic login

remote_os_roles, 1-22

---

B

BEQ protocol, 6-6

syntax for connection parameters, 6-7

binding processes, 2-10

block and file size, 2-12

block size, 2-12

BSD-UNIX file system type, 2-9

buffer cache size, 2-12

tuning, 2-12

buffer manager, 2-6

---

C

C

Pro*C/C++, 5-4

SQL Module for, 5-13

cache size, 2-12, 2-13

catching routine, 5-20

CATPROC.SQL, A-15

changing databases, 1-8

command interpreter, 1-6

commands

expst, 2-11

impst, 2-11

orapwd, 1-21

sar, 2-6, 2-7

vmstat, 2-6, 2-7

common environment

oraenv file, 1-7

setting, 1-7

configuration

directory, 4-4

encapsulator, 6-14

master agent, 6-14

Netscape directory server, 4-4

Oracle Internet Directory, 4-4

configuration files

Net8, 6-2

precompiler, 5-2

CONNECT INTERNAL, 1-21

coraenv, 1-4

coraenv file, 1-7

CPU usage

priority level of processes, 2-10

processor binding, 2-10

single-task architecture, 2-11

tuning, 2-10

CREATE CONTROL FILE parameters, 1-18

---

D

data options, 7-1

database

starting, 4-13

stopping, 4-10

database files, 1-21

database I/O, 2-7

database performance, 2-5

database writer

tuning, 2-7

database writer (DBWR), 2-7

database writer tuning, 2-7

dba group

members, 1-20

dbhome file, 1-7

DBWR tuning, 2-7

debugger programs, 5-3

demonstration

precompiler, 1-32

the procedural option, PL/SQL, 1-31

demonstration programs

oracle call interface, 5-15

Pro*C/C++, 5-4

Pro*COBOL, 5-9

demonstration tables

creating manually, 3-3

deleting, 3-3

SQL*Plus, 3-3

demos (demonstration files)

advanced-developer, 7-8

electric utility, 7-8

Java, 7-8

Oracle Call Interface (OCI), 7-9

Oracle Developer, 7-9

PRO*C/C++, 7-8

retrofitting existing tables, 7-8

usage, 7-8

Developer/2000 (Oracle Developer) demo, 7-9

disk

monitoring performance, 2-9

quotas, 1-18

disk I/O

asynchronous I/O, 2-8

file system type, 2-9

I/O slaves, 2-8

request queues, 2-9

tuning, 2-7

tuning the database writer, 2-7

disk performance, 2-10

documentation

accessing, xiii

navigation files, xiii

related, xiv

where installed, xiii

---

E

editor SQL*Plus, 3-5

electric utility demo, 7-8

encapsulator configuration, 6-14

environment variables, 1-2, 5-7, 5-8

MicroFocus COBOL compiler, 5-7

NLS_LANG, 1-3

ORA_NLS, 1-3

ORACLE_DOC, xiii

ORACLE_HOME, 1-3

ORACLE_SID, 1-4

ORACLE_TRACE, 1-4

ORAENV_ASK, 1-4

Pro*COBOL, 5-7

SHELL, 1-6

TNS_ADMIN, 1-4, 6-2

TWO_TASK, 1-4

exports, 2-11

expst command, 2-11

---

F

file size, 2-12

file systems, 2-9

files

coraenv, 1-7

dbhome, 1-7

oraenv, 1-7

oratab, 1-33

root.sh, 1-7

FORMAT precompiler, 5-10

Pro*COBOL, 5-11

---

G

glogin.sql file, 3-2

---

H

help facility, 3-4

---

I

imports, 2-11

impst command, 2-11

InitDir, 4-7

initialization parameters

BACKGROUND_DUMP_DEST, 1-23, 2-14

BITMAP_MERGE_AREA_SIZE, 1-23

COMMIT_POINT_STRENGTH, 1-23

CONTROL_FILES, 1-23

CREATE_BITMAP_AREA_SIZE, 1-23

DB_BLOCK_BUFFERS, 1-24

DB_BLOCK_SIZE, 1-24

DB_FILE_DIRECT_IO_COUNT, 1-24

DB_FILE_MULTIBLOCK_READ_COUNT, 1-24

DB_FILES, 1-24

DISTRIBUTED_TRANSACTIONS, 1-24

HASH_AREA_SIZE, 1-24

HASH_MULTIBLOCK_IO_COUNT, 1-24

JAVA_POOL_SIZE, 1-24

LOCK_SGA, 1-24

LOG_ARCHIVE_DEST, 1-24

LOG_ARCHIVE_FORMAT, 1-24

LOG_BUFFER, 1-24

LOG_CHECKPOINT_INTERVAL, 1-24

MTS_LISTENER_ADDRESS, 1-24

MTS_MAX_DISPATCHERS, 1-24

MTS_MAX_SERVERS, 1-24

MTS_SERVERS, 1-24

NLS_LANGUAGE, 1-24

NLS_TERRITORY, 1-24

OBJECT_CACHE_MAX_SIZE_PERCENT, 1-24

OBJECT_CACHE_OPTIMAL_SIZE, 1-24

OPEN_CURSORS, 1-24

OS_AUTHENT_PREFIX, 1-24

PROCESSES, 1-25

SHARED_POOL_SIZE, 1-25

SORT_AREA_SIZE, 1-25

initsid.ora file, 1-23

installation

MQSeries, 4-16

Oracle Internet Directory, 4-3

Intelligent Agent

configuration on SNMP, 6-14

interMedia

Java demo, 7-6

MediaAnnotator, 7-6

sample audio scripts, 7-2

sample programs, 7-3

sample video scripts, 7-5

Web Agent and Clipboard, 7-8

interMedia Audio, Video, and Image, 7-2

interMedia Locator, 7-6

interMedia Text, 7-2

interrupting SQL*Plus, 3-6

I/O

DBWR tuning, 2-7

disk request queues, 2-9

tuning, 2-7

I/O slaves, 2-8

iostat utility, 2-4

IPC protocol, 6-8

ireclen, 5-3

---

J

Java demos, 7-8

---

K

kernel parameters, 2-11

---

L

language, 1-3

LDAPSchema, 4-5

limits, 1-18

linking, 2-11

listeners

starting, 4-13

stopping, 4-10

log writer process (LGWR), 2-10

login.sql file, 3-2

---

M

master agent configuration, 6-14

MAXDATAFILES parameter, 1-18

MAXINSTANCES parameter, 1-18

MAXLOGFILES parameter, 1-18

MAXLOGHISTORY parameter, 1-18

MAXLOGMEMBERS parameter, 1-18

memory

estimating usage, 1-12

SGA tuning, 2-7

tuning, 2-6

virtual, 1-12

memory management, 2-6

control paging, 2-6

single shared memory segment, 2-7

swap space, 2-6

UNIX kernel, 2-7

memory usage, 1-18

MicroFocus COBOL compiler, 5-7

Migrate10to20 command, 4-10

migrating directory data, 4-10

mpstat utility, 2-5

multiple signal handlers, 5-20

multi-thread server, 6-4

---

N

naming support, 6-13

National Language Support (NLS) variable, 1-3

Net8

adapters utility, 6-3

ADDRESS specification, 6-5

APPC/LU6.2 protocol, 6-10

BEQ protocol, 6-6

files and utilities, 6-2

IPC protocol, 6-8

multi-thread server, 6-4

naming support, 6-13

oracle advanced security, 6-15

oracle connection manager, 6-3

oracle enterprise manager intelligent agent, 6-13

products and features, 6-2

protocol support, 6-5

protocols, 6-5

RAW protocol, 6-9

TCP/IP protocol, 6-9

Net8 configuration files, 6-2

NLS_LANG variable, 1-3

---

O

OCI demo, 7-9

OFA

See also

Optimal Flexible Architecture, A-1

characteristics of OFA, A-2

directory structure, A-12

file mapping, A-2, A-9

implementation on Oracle8 for Unix, A-2

ORA_NLS variable, 1-3

oracle advanced security, 6-15

.bak files, 6-15

DCE integration, 6-16

security and single sign-on, 6-16

Oracle AQ

initializing for Oracle Message Broker, 4-14

oracle call interface, 5-15

demonstration programs, 5-15

Oracle Call Interface (OCI) demo, 7-9

oracle connection manager, 6-3

Oracle Data Option Demos, 7-1

Oracle Developer demo, 7-9

oracle enterprise manager intelligent agent, 6-13

agent service discovery and auto-configuration, 6-13

debugging tcl scripts, 6-13

Oracle environment variables

EPC_DISABLED, 1-3

NLS_LANG, 1-3

ORA_NLS33, 1-3

ORACLE_BASE, 1-3

ORACLE_HOME, 1-3

ORACLE_PATH, 1-3

ORACLE_SID, 1-4

ORACLE_TRACE, 1-4

ORAENV_ASK, 1-4

TNS_ADMIN, 1-4

TWO_TASK, 1-4

UNIX variables, 1-5

Oracle Forms demo, 7-9

Oracle HTTP Server, 1-27

Oracle Information Navigator, xiii

Oracle Internet Directory

configuration, 4-4

starting, 4-13

stopping, 4-10

oracle precompiler and OCI linking and makefiles

custom makefiles, 5-17

undefined symbols, 5-18

oracle run time system

Pro*COBOL, 5-9

Oracle Server accounts, 1-19

oracle software owner, 1-19

special accounts, 1-19

Oracle System Identifier, 1-4

Oracle TCP/IP protocol, 6-9

ORACLE_DOC variable, xiii

ORACLE_HOME environment variable, 1-3

ORACLE_HOME variable, 1-2

ORACLE_SID

environment variable, 1-4

ORACLE_SID variable, 1-2

Oracle8i Spatial, 7-10

oraenv file, 1-7

description, 1-7

moving between databases, 1-8

ORAENV_ASK, 1-4

orapwd command, 1-21

oratab file, 1-33

oreclen, 5-3

---

P

page-out activity, 2-7

paging, 2-6

paging space, 2-6

tuning, 2-6

parallel server installation, 2-15

passwords, 1-21

PL/SQL demonstrations

loading, 1-31

precompiler

running demonstration, 1-32

value of ireclen and oreclen, 5-3

precompiler configuration files, 5-2

precompilers

overview, 5-2

signals, 5-20

uppercase to lowercase conversion, 5-3

values, 5-3

vendor debugger programs, 5-3

Pro*C/C++

demonstration programs, 5-4

makefiles, 5-5

signals, 5-20

using, 5-4

PRO*C/C++ demo, 7-8

Pro*COBOL, 5-7

demonstration programs, 5-9

environment variables, 5-7

FORMAT precompiler, 5-10, 5-11

naming differences, 5-7

oracle run time system, 5-9

user programs, 5-10

using, 5-8

processor affinity/binding, 2-10

PRODUCT_USER_PROFILE Table, 3-2

protocols, 6-5

ADDRESS specification, 6-6

---

R

raw devices, 2-14

buffer cache size, 2-12

disadvantages, 2-14

guidelines for using, 2-15

Oracle8i parallel server installation, 2-15

raw disk partition availability, 2-15

setting up, 2-15

RAW protocol, 6-9

README.txt files, 7-9

related documentation, xiv

relinking, 1-8

parameters, 1-9

remote connections parameters

OS_AUTHENT_PREFIX, 1-22

REMOTE_OS_AUTHENT, 1-22

REMOTE_OS_ROLES, 1-22

remote passwords, 1-21

resource contention

kernel parameters, 2-11

tuning, 2-11

resource limits, 1-18

restrictions (SQL*Plus), 3-6

resizing windows, 3-6

return codes, 3-6

retrofit demo, 7-8

root user, 1-19

root.sh script, 1-7

running operating system commands, 3-6

---

S

s5 file system type, 2-9

sar command, 2-6, 2-7, 2-13

sar utility, 2-3

scripts

start_peer, 6-14

security, 1-20, 1-21

CONNECT INTERNAL, 1-21

features of UNIX, 1-20

file ownership, 1-20

group accounts, 1-20

Server Manager access, 1-21

SHUTDOWN command, 1-21

STARTUP command, 1-21

two-task architecture, 1-20

Server Manager

commands, 1-21

security, 1-21

setting up raw devices, 2-15

setup files

SQL*Plus, 3-2

SGA

calculating, 1-10

relocating, 1-10

tuning, 2-7

shadow process, 1-20

shared memory

SGA tuning, 2-7

SHELL, 1-6

SHUTDOWN command, 1-21

security, 1-21

SIGCLD two-task signal, 5-20

SIGINT two-task signal, 5-19

SIGIO two-task signal, 5-19

signal handlers

using, 5-19

signal routine, 5-20

example, 5-20

signals

two-task, 5-19

SIGPIPE two-task signal, 5-20

SIGTERM two-task signal, 5-20

SIGURG two-task signal, 5-20

Simple Network Management Protocol (SNMP), 6-14

single shared memory segment, 2-7

site profile SQL*Plus, 3-2

SNMP and Intelligent Agent, 6-14

snmpd executable, 6-14

software distribution, 1-3

Solaris 2.x tools, 2-2

iostat utility, 2-4

mpstat utility, 2-5

sar utility, 2-3

swap utility, 2-5

vmstat utility, 2-2

Spatial demonstrations, 7-10

special accounts, 1-19

special groups

root, 1-20

SPOOL command

SQL*Plus, 3-6

using, 3-6

SQL scripts, 2-5

SQL*Module for Ada, 5-13

user programs, 5-15

using, 5-13

SQL*Module for C, 5-13

SQL*Plus

default editor, 3-5

demonstration tables, 3-3

editor, 3-5

help facility, 3-4

interrupting, 3-6

PRODUCT_USER_PROFILE Table, 3-2

restrictions, 3-6

running operating system commands, 3-6

setup files, 3-2

site profile, 3-2

SPOOL command, 3-6

system editor, 3-5

user profile, 3-2

using, 3-5

start_peer script, 6-14

STARTUP command, 1-21

step1.sql setup script, 4-14

step2.sql setup script, 4-14

step3.sql setup script, 4-14

Sun Nihongo COBOL, 5-8

compiler environment variables, 5-8

superuser, 1-19

swap space, 2-6

swap utility, 2-5

SYS account, 1-19

privileges, 1-19

SYSDATE, 1-8

SYSTEM account, 1-19

privileges, 1-19

system editor

SQL*Plus, 3-5

System Global Area or Shared Global Area (SGA)

relocating, 1-10

system time, 1-8

---

T

TCP/IP protocol, 6-9

ADDRESS, 6-9

thread support, 5-19

TNS listener, 6-9

TNS_ADMIN environment variable, 1-4

tools, 2-2

trace and alert files

alert files, 2-14

trace file names, 2-13

using, 2-12, 2-13

tracing Bourne shell scripts, 1-4

tuning, 2-6, 2-7, 2-11

block and file size, 2-12

CPU usage, 2-10

disk I/O, 2-7

I/O bottlenecks, 2-7

memory management, 2-6

resource contention, 2-11

Solaris 2.x buffer cache size, 2-12

trace and alert files, 2-12, 2-13

TWO_TASK environment variable, 1-4

two-task, 1-20

signals, 5-19

---

U

ufs file system type, 2-9

UNIX Environment Variables Used with Oracle8i, 1-5

UNIX file system type, 2-9

UNIX kernel, 2-11

usage demo, 7-8

user interrupt handler, 5-20

user profile

SQL*Plus, 3-2

user programs

Pro*COBOL, 5-10

SQL*Module for Ada, 5-15

using SQL*Plus, 3-5

utility (electric) demo, 7-8

---

V

Veritas file system type, 2-9

vmstat command, 2-6, 2-7

vmstat utility, 2-2

vxfs file system type, 2-9

---

W

writer activity, 2-7

---

X

XA functionality, 5-22