Index

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

---

Symbols

example of use, 1-6

@

to denote $ORACLE_SID, 1-6

---

A

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

using, 2-8

automatic login

remote_os_roles, 1-19

---

B

BEQ protocol, 5-6

ADDRESS, 5-6

syntax for connection parameters, 5-6

binding processes, 2-11

block and file size

specifying, 2-12

BSD-UNIX file system type, 2-9

buffer cache size

tuning, 2-12

buffer manager, 2-6

---

C

C

Pro*C/C++, 4-3

SQL Module for, 4-13

cache

size

tuning, 2-12

catching routine

example, 4-21

CATPROC.SQL, A-15

changing databases, 1-3

COBOL

Pro*COBOL, 4-6

command interpreter, 1-8

commands

expst, 2-11

impst, 2-11

orapwd, 1-18

sar, 2-6, 2-7

vmstat, 2-6, 2-7

common environment

oraenv file, 1-2

setting, 1-2

configuration

master agent, 5-18

configuration files

Net8, 5-2

precompiler, 4-2

CONNECT INTERNAL

security, 1-17

coraenv, 1-6

CPU usage

priority level of processes, 2-10

processor binding, 2-11

single-task architecture, 2-11

tuning, 2-10

customizing initsid.ora file

initialization parameters, 1-9

---

D

data options

running demos for, 6-1

database

administrator

permissions for executables, 1-16

files

authorization, 1-17

security, 1-17

database I/O

DBWR tuning, 2-8

database writer

tuning, 2-8

dba group

members, 1-15

relinking, 1-16

DBWR

tuning, 2-8

debugger programs, 4-2

demonstration

precompiler, 1-28

the procedural option, PL/SQL, 1-27

demonstration programs

oracle call interface, 4-15

Pro*C/C++, 4-3

Pro*COBOL, 4-8

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

Disk I/O

tuning, 2-7

disk I/O

asynchronous I/O, 2-8

file system type, 2-9

I/O slaves, 2-8

request queues, 2-9

tuning the database writer, 2-8

disk performance

issues, 2-10

dynamic and static linking

oracle libraries, 4-19

---

E

echo command, 1-2

editor

SQL*Plus, 3-4

electric utility demo, 6-9

encapsulator configuration

configuration

encapsulator, 5-18

environment variables, 4-7

MicroFocus COBOL compiler, 4-7

NLS_LANG, 1-5

ORA_NLS, 1-5

ORACLE_HOME, 1-5

ORACLE_SID, 1-5

ORACLE_TRACE, 1-6

ORAENV_ASK, 1-6

Pro*COBOL, 4-6, 4-7

SHELL, 1-8

Sun Nihongo COBOL compiler, 4-7

TNS_ADMIN, 1-6, 5-3

TWO_TASK, 1-6

TZ, 1-8

exports

tuning, 2-11

expst command, 2-11

---

F

file names

default extensions in SQL*Plus, 3-6

files

trace files, 2-13

FORMAT precompiler

Pro*COBOL, 4-9, 4-10

---

G

getname command, 5-12

glogin.sql, 3-2

groups

sample script, 1-20

---

H

help facility

SQL*Plus, 3-4

---

I

imports

tuning, 2-11

impst command, 2-11

initialization parameters, 1-9

BACKGROUND_DUMP_DEST, 1-12

BITMAP_MERGE_AREA_SIZE, 1-12

COMMIT_POINT_STRENGTH, 1-12

CONTROL_FILES, 1-12

CREATE_BITMAP_AREA_SIZE, 1-12

DB_BLOCK_BUFFERS, 1-12

DB_BLOCK_SIZE, 1-12

DB_FILE_DIRECT_IO_COUNT, 1-13

DB_FILE_MULTIBLOCK_READ_COUNT, 1-13

DB_FILES, 1-12

defaults, 1-12

DISTRIBUTED_TRANSACTIONS, 1-13

HASH_AREA_SIZE, 1-13

HASH_MULTIBLOCK_IO_COUNT, 1-13

LOCK_SGA, 1-13

LOCK_SGA_AREAS, 1-13

LOG_ARCHIVE_BUFFER_SIZE, 1-13

LOG_ARCHIVE_BUFFERS, 1-13

LOG_ARCHIVE_DEST, 1-13

LOG_ARCHIVE_FORMAT, 1-13

LOG_BUFFER, 1-13

LOG_CHECKPOINT_INTERVAL, 1-13

LOG_SMALL_ENTRY_MAX_SIZE, 1-13

MTS_LISTENER_ADDRESS, 1-13

MTS_MAX_DISPATCHERS, 1-13

MTS_MAX_SERVERS, 1-13

MTS_SERVERS, 1-13

NLS_LANGUAGE, 1-13

NLS_TERRITORY, 1-13

OBJECT_CACHE_MAX_SIZE_PERCENT, 1-13

OBJECT_CACHE_OPTIMAL_SIZE, 1-13

OPEN_CURSORS, 1-13

OS_AUTHENT_PREFIX, 1-13

PROCESSES, 1-13

SHARED_POOL_SIZE, 1-13

SHOW PARAMETERS command, 1-12

SORT_AREA_SIZE, 1-13

SORT_READ_FAC, 1-13

SORT_SPACEMAP_SIZE, 1-13

Intelligent Agent

configuration on SNMP, 5-18

interrupting SQL*Plus, 3-6

I/O

DBWR tuning, 2-8

disk request queues, 2-9

tuning, 2-7

I/O slaves, 2-8

iostat, 2-4

IPC protocol, 5-7

ADDRESS, 5-7

ireclen, 4-3

---

J

Java

demos, 6-9

---

K

kernel

tuning UNIX parameters, 2-11

---

L

language, 1-5

limits

resource, 1-22

linking

single-task, 2-11

login home directories

administering, 1-19

sample script, 1-20

login.sql, 3-2

---

M

master agent configuration, 5-18

MAXDATAFILES parameter, 1-14

MAXINSTANCES parameter, 1-14

MAXLOGFILES parameter, 1-14

MAXLOGHISTORY parameter, 1-14

MAXLOGMEMBERS parameter, 1-14

memory

estimating usage, 1-21

SGA tuning, 2-7

shared, 1-22

tuning, 2-6

virtual, 1-21

memory management, 2-6

control paging, 2-7

single shared memory segment, 2-7

swap space, 2-6

UNIX kernel, 2-7

MicroFocus COBOL compiler, 4-7

mpstat, 2-5

multiple signal handlers, 4-21

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

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

README files, 5-2

SPX/IPX protocol, 5-10

TCP/IP protocol, 5-9

Net8 configuration files

location of, 5-2

NLS_LANG

environment 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

environment variable, 1-5

Oracle

memory usage, 1-22

oracle advanced security, 5-19

.bak files, 5-19

DCE integration, 5-20

security and single sign-on, 5-20

oracle call interface, 4-15

demonstration programs, 4-15

user programs, 4-16

using, 4-15

Oracle Call Interface (OCI) demo, 6-9

oracle connection manager, 5-4

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 variable

UNIX variables, 1-7

Oracle environment variables, 1-4

EPC_DISABLED, 1-5

NLS_LANG, 1-5

ORA_NLS33, 1-5

ORACLE_BASE, 1-5

ORACLE_HOME, 1-5

ORACLE_PATH, 1-5

ORACLE_SID, 1-5

ORACLE_TRACE, 1-6

ORAENV_ASK, 1-6

TNS_ADMIN, 1-6

TWO_TASK, 1-6

Oracle Forms demo, 6-9

oracle group

permissions and executables, 1-16

oracle libraries

oracle shared library, 4-19

static and dynamic linking, 4-19

oracle names, 5-4

oracle precompiler and OCI linking and makefiles, 4-17

custom makefiles, 4-17

undefined symbols, 4-18

oracle run time system

Pro*COBOL, 4-8

Oracle Server

accounts, 1-15

oracle software owner, 1-14

special accounts, 1-14

Oracle System Identifier, 1-5

ORACLE_HOME

environment variable, 1-5

using ? for, 1-6

ORACLE_SID

environment variable, 1-5

suppressing prompt, 1-3

oraenv file

description, 1-2

moving between databases, 1-3

ORAENV_ASK, 1-6

setting, 1-3

orapwd command, 1-18

oreclen, 4-3

---

P

paging space

tuning, 2-6, 2-7

parameters

CREATE CONTROL FILE, 1-14

passwords

remote, 1-18

permissions

dba group, 1-16

granting, 1-16

PL/SQL

demonstrations

loading, 1-27

precompiler

running demonstration, 1-28

value of ireclen and oreclen, 4-3

precompiler configuration files, 4-2

precompilers

overview, 4-2

signals, 4-21

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

signals, 4-21

system configuration file, 4-3

user programs, 4-5

using, 4-3

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

Pro*COBOL, 4-6

administering, 4-6

demonstration programs, 4-8

environment variables, 4-6, 4-7

FORMAT precompiler, 4-9, 4-10

naming differences, 4-6

oracle run time system, 4-8

system configuration file, 4-6

user programs, 4-9

using, 4-7

PRODUCT_USER_PROFILE Table

SQL*Plus, 3-2

protocols, 5-4

ADDRESS specification, 5-5

pupbld.sql, 3-2

---

Q

question mark

example of use, 1-6

---

R

raw devices, 2-14

buffer cache size, 2-12

disadvantages, 2-14

guidelines for using, 2-14

oracle8 parallel server installation, 2-15

raw disk partition availability, 2-15

setting up, 2-14

RAW protocol, 5-8

README files

Net8, 5-2

README.txt files, 6-9

related documentation, xiii

relinking, 1-29

parameters, 1-30

remote connections parameters

OS_AUTHENT_PREFIX, 1-19

REMOTE_OS_AUTHENT, 1-19

REMOTE_OS_ROLES, 1-19

resource contention

kernel parameters, 2-11

tuning, 2-11

resource limits, 1-22

restrictions (SQL*Plus), 3-6

resizing windows, 3-6

return codes, 3-6

retrofit demo, 6-9

root

user, 1-14

running operating system commands

SQL*Plus, 3-5

---

S

s5 file system type, 2-9

sar, 2-3

sar command, 2-6, 2-7, 2-12

scripts

start_peer, 5-18

security

assigning permissions, 1-16

CONNECT INTERNAL, 1-17

default group names, 1-16

file ownership, 1-15

group accounts, 1-15

Server Manager access, 1-17

SHUTDOWN command, 1-17

STARTUP command, 1-17

two-task architecture, 1-15

Server Manager

commands, 1-17

security, 1-17

SHOW PARAMETERS, 1-12

setting up

raw devices, 2-14

setup files

SQL*Plus, 3-2

SGA

calculating, 1-23

relocating, 1-24

tuning, 2-7

shadow process

security, 1-15

shared memory

SGA, 1-22

SGA tuning, 2-7

SHELL, 1-8

SHUTDOWN command, 1-17

security, 1-17

SIGCLD two-task signal, 4-20

SIGINT two-task signal, 4-20

SIGIO two-task signal, 4-20

signal handlers

signals, 4-20

using, 4-20

signal routine

example, 4-21

signals

creating handlers, 4-20

two-task, 4-20

SIGPIPE two-task signal, 4-20

SIGTERM two-task signal, 4-20

SIGURG two-task signal, 4-20

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, 2-4

mpstat, 2-5

sar, 2-3

swap, 2-5

vmstat, 2-2

Spatial

demonstrations

Oracle Data Options

Spatialdemonstrations, 6-11

special accounts, 1-14

special groups

root, 1-15

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

administering, 3-2

SQL scripts, 2-6

SQL*DBA

SHOW PARAMETERS, 1-12

SQL*Module

for C, 4-13

SQL*Module for Ada, 4-13

administering, 4-13

demonstration programs, 4-13

system configuration file, 4-13

user programs, 4-14

using, 4-13

SQL*Plus

default editor, 3-4

demonstration tables, 3-3

editor, 3-4

help facility, 3-4

interrupting, 3-6

PRODUCT_USER_PROFILE Table, 3-2

restrictions, 3-6

running operating system commands, 3-5

setup files, 3-2

site profile, 3-2

SPOOL command, 3-6

system editor, 3-4

user profile, 3-2

using, 3-4

start_peer script, 5-18

STARTUP command

security, 1-17

static and dynamic linking

oracle libraries, 4-19

Sun Nihongo COBOL, 4-10

Sun Nihongo COBOL compiler

environment variables, 4-7

superuser, 1-14

swap, 2-5

swap space

tuning, 2-6

SYS

accounts and groups, 1-15

SYS account

privileges, 1-15

SYSDATE

and TZ, 1-8

SYSTEM

accounts and groups, 1-15

SYSTEM account

privileges, 1-15

system configuration file

Pro*C/C++, 4-3

Pro*COBOL, 4-6

SQL*Module for Ada, 4-13

system editor

SQL*Plus, 3-4

System Global Area (SGA)

relocating, 1-24

requirements, 1-22

system time

setting, 1-8

---

T

TCP/IP protocol, 5-9

ADDRESS, 5-9

thread support, 4-18

time zone

setting with TZ, 1-8

TNS listener

configuring for Oracle TCP/IP protocol, 5-9

TNS_ADMIN

environment variable, 1-6

tools, 2-2

trace and alert files

alert files, 2-13

trace file names, 2-13

using, 2-12, 2-13

tracing Bourne shell scripts, 1-6

tuning

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

two-task

architecture

security, 1-15

signals, 4-20

TZ

and SYSDATE, 1-8

environment variable, 1-8

---

U

ufs file system type, 2-9

UNIX

security, 1-15

UNIX Environment Variables Used with Oracle8i, 1-7

UNIX file system type, 2-9

UNIX kernel

tuning, 2-11

usage demo, 6-9

user interrupt handler, 4-21

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

users

sample script, 1-20

using SQL*Plus, 3-4

utility (electric) demo, 6-9

---

V

Veritas file system type, 2-9

vmstat, 2-2

vmstat command, 2-6, 2-7

vxfs file system type, 2-9

---

W

writer activity

tuning, 2-8

---

X

XA functionality, 4-22