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

@ abbreviation, 1-7

---

A

accounts, 1-14

adapters utility, 5-3

ADDRESS specification protocols, 5-5

administering SQL, 3-2

advanced-developer demo, 6-9

APPC/LU6.2 protocol, 5-15, 5-16

ADDRESS, 5-16

Solaris 2.x-specific listener, 5-15

asynchronous I/O, 2-7

using, 2-8

authorization, 1-16

automatic login

remote_os_roles, 1-18

---

B

BEQ protocol, 5-6

ADDRESS, 5-6

syntax for connection parameters, 5-6

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++, 4-3

SQL Module for, 4-12

cache size, 2-12, 2-13

catching routine, 4-20

CATPROC.SQL, A-15

changing databases, 1-3

command interpreter, 1-9

commands

expst, 2-11

impst, 2-11

orapwd, 1-16

sar, 2-6

vmstat, 2-6

common environment

oraenv file, 1-2

setting, 1-2

configuration

encapsulator, 5-18

master agent, 5-18

configuration files

Net8, 5-2

precompiler, 4-2

CONNECT INTERNAL, 1-16

coraenv, 1-6

coraenv file, 1-2

CPU usage

priority level of processes, 2-10

processor binding, 2-10

single-task architecture, 2-10

tuning, 2-10

CREATE CONTROL FILE parameters, 1-12

---

D

data options, 6-1

database administrator, 1-15

database files, 1-16

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, 1-14

permissions, 1-15

dbhome file, 1-3

DBWR tuning, 2-7

debugger programs, 4-2

demonstration

precompiler, 1-30

the procedural option, PL/SQL, 1-29

demonstration programs

oracle call interface, 4-14

Pro*C/C++, 4-3

Pro*COBOL, 4-7

SQL*Module for Ada, 4-13

demonstration tables

creating manually, 3-3

deleting, 3-3

SQL*Plus, 3-3

demos (demonstration files)

advanced-developer, 6-9

electric utility, 6-9

Java, 6-9

Oracle Call Interface (OCI), 6-9

Oracle Developer, 6-9

PRO*C/C++, 6-9

retrofitting existing tables, 6-9

usage, 6-9

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

disk

monitoring performance, 2-9

quotas, 1-24

disk I/O

asynchronous I/O, 2-7

file system type, 2-9

I/O slaves, 2-8

request queues, 2-8

tuning, 2-7

tuning the database writer, 2-7

disk performance, 2-10

documentation, xiii

---

E

editor SQL*Plus, 3-5

electric utility demo, 6-9

encapsulator configuration, 5-18

environment variables, 1-2, 4-6, 4-7

MicroFocus COBOL compiler, 4-6

NLS_LANG, 1-5

ORA_NLS, 1-5

ORACLE_HOME, 1-5

ORACLE_SID, 1-6

ORACLE_TRACE, 1-6

ORAENV_ASK, 1-6

Pro*COBOL, 4-6

SHELL, 1-9

TNS_ADMIN, 1-6, 5-2

TWO_TASK, 1-7

exports, 2-10

expst command, 2-11

---

F

file size, 2-12

file systems, 2-9

files

coraenv, 1-2

dbhome, 1-3

oraenv, 1-2

oratab, 1-3

root.sh, 1-3

FORMAT precompiler, 4-9

Pro*COBOL, 4-10

---

G

getname command, 5-12

glogin.sql file, 3-2

---

H

help facility, 3-4

---

I

imports, 2-10

impst command, 2-11

initialization parameters, 1-10

BACKGROUND_DUMP_DEST, 1-11, 2-14

BITMAP_MERGE_AREA_SIZE, 1-11

COMMIT_POINT_STRENGTH, 1-11

CONTROL_FILES, 1-11

CREATE_BITMAP_AREA_SIZE, 1-11

DB_BLOCK_BUFFERS, 1-11

DB_BLOCK_SIZE, 1-11

DB_FILE_DIRECT_IO_COUNT, 1-11

DB_FILE_MULTIBLOCK_READ_COUNT, 1-11

DB_FILES, 1-11

defaults, 1-10

DISTRIBUTED_TRANSACTIONS, 1-11

HASH_AREA_SIZE, 1-11

HASH_MULTIBLOCK_IO_COUNT, 1-11

JAVA_POOL_SIZE, 1-11

LOCK_SGA, 1-11

LOG_ARCHIVE_DEST, 1-11

LOG_ARCHIVE_FORMAT, 1-11

LOG_BUFFER, 1-11

LOG_CHECKPOINT_INTERVAL, 1-11

MTS_LISTENER_ADDRESS, 1-12

MTS_MAX_DISPATCHERS, 1-11

MTS_MAX_SERVERS, 1-11

MTS_SERVERS, 1-12

NLS_LANGUAGE, 1-12

NLS_TERRITORY, 1-12

OBJECT_CACHE_MAX_SIZE_PERCENT, 1-12

OBJECT_CACHE_OPTIMAL_SIZE, 1-12

OPEN_CURSORS, 1-12

OS_AUTHENT_PREFIX, 1-12

PROCESSES, 1-12

SHARED_POOL_SIZE, 1-12

SHOW PARAMETERS command, 1-10

SORT_AREA_SIZE, 1-12

initsid.ora file, 1-10

Intelligent Agent

configuration on SNMP, 5-18

interMedia

Java demo, 6-6

MediaAnnotator, 6-7

sample audio scripts, 6-3

sample programs, 6-4

sample video scripts, 6-6

Web Agent and Clipboard, 6-8

interMedia Audio, Video, and Image, 6-3

interMedia Locator, 6-7

interMedia Text, 6-2

interrupting SQL*Plus, 3-6

I/O

DBWR tuning, 2-7

disk request queues, 2-8

tuning, 2-7

I/O slaves, 2-8

iostat utility, 2-4

IPC protocol, 5-7

ADDRESS, 5-7

ireclen, 4-3

---

J

Java demos, 6-9

---

K

kernel parameters, 2-11

---

L

language, 1-5

limits, 1-24

linking, 2-10

log writer process (LGWR), 2-10

login.sql file, 3-2

---

M

master agent configuration, 5-18

MAXDATAFILES parameter, 1-12

MAXINSTANCES parameter, 1-12

MAXLOGFILES parameter, 1-12

MAXLOGHISTORY parameter, 1-12

MAXLOGMEMBERS parameter, 1-12

memory

estimating usage, 1-18

SGA tuning, 2-7

shared, 1-24

tuning, 2-6

virtual, 1-18

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-19, 1-24

MicroFocus COBOL compiler, 4-6

mpstat utility, 2-5

multiple signal handlers, 4-20

multi-thread server, 5-4

---

N

naming support, 5-17

National Language Support (NLS) variable, 1-5

Net8

adapters utility, 5-3

ADDRESS specification, 5-4

APPC/LU6.2 protocol, 5-15

BEQ protocol, 5-6

files and utilities, 5-2

IPC protocol, 5-7

multi-thread server, 5-4

naming support, 5-17

oracle advanced security, 5-19

oracle connection manager, 5-4

oracle enterprise manager intelligent agent, 5-17

oracle names, 5-4

products and features, 5-2

protocol support, 5-4

protocols, 5-4

RAW protocol, 5-8

SPX/IPX protocol, 5-10

TCP/IP protocol, 5-9

Net8 configuration files, 5-2

Net8 README files, 5-2

NLS_LANG variable, 1-5

ntisbsdm broadcast daemon, 5-10

ntspxctl utility, 5-10

---

O

OCI demo, 6-9

OFA

See also Optimal Flexible Architecture

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

oracle advanced security, 5-19

.bak files, 5-19

DCE integration, 5-20

security and single sign-on, 5-20

oracle call interface, 4-14

demonstration programs, 4-14

user programs, 4-16

using, 4-14

Oracle Call Interface (OCI) demo, 6-9

oracle connection manager, 5-4

Oracle Data Option Demos, 6-1

Oracle Developer demo, 6-9

oracle enterprise manager intelligent agent, 5-17

agent service discovery and auto-configuration, 5-17

debugging tcl scripts, 5-17

Oracle environment variables, 1-5

EPC_DISABLED, 1-5

NLS_LANG, 1-5

ORA_NLS33, 1-5

ORACLE_BASE, 1-5

ORACLE_HOME, 1-5

ORACLE_PATH, 1-6

ORACLE_SID, 1-6

ORACLE_TRACE, 1-6

ORAENV_ASK, 1-6

TNS_ADMIN, 1-6

TWO_TASK, 1-7

UNIX variables, 1-7

Oracle Forms demo, 6-9

oracle libraries, 4-18

oracle shared library, 4-19

oracle names, 5-4

oracle precompiler and OCI linking and makefiles, 4-16

custom makefiles, 4-16

undefined symbols, 4-17

oracle run time system, 4-7

Oracle Server accounts, 1-14

oracle software owner, 1-13

special accounts, 1-13

Oracle System Identifier, 1-6

Oracle TCP/IP protocol, 5-9

ORACLE_HOME environment variable, 1-5

ORACLE_HOME variable, 1-7

ORACLE_SID

environment variable, 1-6

suppressing prompt, 1-3

ORACLE_SID variable, 1-7

Oracle8i Spatial, 6-11

oraenv file, 1-2

description, 1-2

moving between databases, 1-3

ORAENV_ASK, 1-6

setting, 1-3

orapwd command, 1-16

oratab file, 1-3

oreclen, 4-3

---

P

page-out activity, 2-7

paging, 2-6

paging space, 2-6

tuning, 2-6

parallel server installation, 2-15

passwords, 1-16

permissions, 1-15

executables, 1-15

PL/SQL demonstrations

loading, 1-29

precompiler

running demonstration, 1-30

value of ireclen and oreclen, 4-3

precompiler configuration files, 4-2

precompilers

overview, 4-2

signals, 4-20

uppercase to lowercase conversion, 4-2

values, 4-3

vendor debugger programs, 4-2

Pro*C/C++

administering, 4-3

demonstration programs, 4-3

makefiles, 4-4

signals, 4-20

system configuration file, 4-3

user programs, 4-5

using, 4-3

PRO*C/C++ demo, 6-9

Pro*COBOL, 4-5

administering, 4-6

demonstration programs, 4-7, 4-8

environment variables, 4-6

FORMAT precompiler, 4-9, 4-10

naming differences, 4-6

oracle run time system, 4-7

system configuration file, 4-6

user programs, 4-9

using, 4-7

processor affinity/binding, 2-10

PRODUCT_USER_PROFILE Table, 3-3

protocols, 5-4

ADDRESS specification, 5-5

---

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, 5-8

README files

Net8, 5-2

README.txt files, 6-10

related documentation, xiii

relinking, 1-31

parameters, 1-32

remote connections parameters

OS_AUTHENT_PREFIX, 1-18

REMOTE_OS_AUTHENT, 1-18

REMOTE_OS_ROLES, 1-18

remote passwords, 1-16

resource contention

kernel parameters, 2-11

tuning, 2-11

resource limits, 1-24

restrictions (SQL*Plus), 3-6

resizing windows, 3-6

return codes, 3-7

retrofit demo, 6-9

root user, 1-13

root.sh script, 1-3

running operating system commands, 3-6

---

S

s5 file system type, 2-9

sar command, 2-6, 2-13

sar utility, 2-3

scripts

start_peer, 5-18

security, 1-14, 1-15, 1-16

assigning permissions, 1-15

CONNECT INTERNAL, 1-16

features of UNIX, 1-14

file ownership, 1-14

group accounts, 1-14

Server Manager access, 1-15

SHUTDOWN command, 1-15

STARTUP command, 1-15

two-task architecture, 1-14

Server Manager

commands, 1-15

security, 1-15

SHOW PARAMETERS, 1-10

setting up raw devices, 2-15

setup files

SQL*Plus, 3-2

SGA

calculating, 1-25

relocating, 1-25

tuning, 2-7

shadow process, 1-14

shared memory

SGA, 1-24

SGA tuning, 2-7

SHELL, 1-9

SHOW PARAMETERS statement, 1-10

SHUTDOWN command, 1-15

security, 1-15

SIGCLD two-task signal, 4-20

SIGINT two-task signal, 4-20

SIGIO two-task signal, 4-20

signal handlers

signals, 4-19

using, 4-19

signal routine, 4-20

example, 4-20

signals

creating handlers, 4-19

two-task, 4-19

SIGPIPE two-task signal, 4-20

SIGTERM two-task signal, 4-20

SIGURG two-task signal, 4-20

Simple Network Management Protocol (SNMP), 5-18

single shared memory segment, 2-7

site profile SQL*Plus, 3-2

SNMP and Intelligent Agent, 5-18

snmpd executable, 5-18

software distribution, 1-5

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, 6-11

special accounts, 1-13

SPOOL command

SQL*Plus, 3-6

using, 3-6

SPX/IPX protocol, 5-10

ADDRESS, 5-14

command summary, 5-12

getname command, 5-12

ntisbsdm broadcast daemon, 5-10

ntspxctl utility, 5-10

SQL scripts, 2-5

SQL*DBA, 1-10

SQL*Module for Ada, 4-12

administering, 4-12

demonstration programs, 4-13

system configuration file, 4-12

user programs, 4-14

using, 4-12

SQL*Module for C, 4-12

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

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, 5-18

STARTUP command, 1-15

Sun Nihongo COBOL, 4-10

compiler environment variables, 4-7

superuser, 1-13

swap space, 2-6

swap utility, 2-5

SYS account, 1-14

privileges, 1-14

SYSDATE, 1-9

SYSTEM account, 1-14

privileges, 1-14

system configuration file

Pro*C/C++, 4-3

Pro*COBOL, 4-6

SQL*Module for Ada, 4-12

system editor

SQL*Plus, 3-5

System Global Area or Shared Global Area (SGA)

relocating, 1-25

requirements, 1-24

system time, 1-9

---

T

TCP/IP protocol, 5-9

ADDRESS, 5-9

thread support, 4-18

TNS listener, 5-9

TNS_ADMIN environment variable, 1-6

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

tuning, 2-6, 2-7, 2-10, 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-7

two-task, 1-14

signals, 4-19

---

U

ufs file system type, 2-9

UNIX Environment Variables Used with Oracle8i, 1-7

UNIX file system type, 2-9

UNIX kernel, 2-11

usage demo, 6-9

user interrupt handler, 4-20

user profile

SQL*Plus, 3-2

user programs

oracle call interface, 4-16

Pro*C/C++, 4-5

Pro*COBOL, 4-9

SQL*Module for Ada, 4-14

using SQL*Plus, 3-5

utility (electric) demo, 6-9

---

V

Veritas file system type, 2-9

vmstat command, 2-6

vmstat utility, 2-2

vxfs file system type, 2-9

---

W

writer activity, 2-7

---

X

XA functionality, 4-22