-- Index

$

using, 2-23

,, 5-5

?

example of use, 2-10

@

to denote $ORACLE_SID, 2-10

_editor

setting, 4-6

Ada compiler, 2-10

ADA_PATH, 2-10

adapters utility, 6-3

ADDRESS specification

protocol adapters, 6-5

administering

SQL, 4-2

afiedt.buf, 4-7

asynchronous I/O, 3-6

using, 3-6

automatic login

listener.ora file, 2-23

non-UNIX systems, 2-23

remote_os_roles, 2-27

BEQ protocol adapter, 6-6

ADDRESS, 6-6

overview, 6-6

syntax for connection parameters, 6-6

binding processes, 3-8

block and file size

specifying, 3-9

BSD, 2-11

buffer cache size

tuning, 3-9

buffer manager, 3-4

C

Pro*C/C++, 5-4

cache

size

catching routine

changing databases, 2-6

chmod command

example, 2-22

cluster

estimating size, 2-13

COBOL

Pro*COBOL, 5-6

command interpreter, 2-11

commands

expst, 3-8

impst, 3-8

ipcs, 3-5

sar, 3-4

common environment

configuration files

Net8, 6-3

precompiler, 5-3

CONNECT INTERNAL

security, 2-21

control remote DBA access

REMOTE_DBA_OPS_ALLOWED, 2-24

REMOTE_DBA_OPS_DENIED, 2-24

control remote login, 2-24

OPS_DOLLAR_LOGIN_DENIED, 2-24

COPY command

SQL*Plus, 4-8

coraenv, 2-9

CPU usage

priority level of processes, 3-7

processor binding, 3-8

single-task architecture, 3-8

tuning, 3-7

daemon user

security, 2-23

database

administrator

permissions for executables, 2-20

files

database I/O

database writer

dba group

DBA group ID

non-default name, 2-24

DBA_GROUP

/etc/listener.ora file, 2-24

DBA_GROUP_sid

/etc/listener.ora file, 2-24

DBWR

tuning, 3-5

debugger programs, 5-3

default

directory, 2-11, 2-12

linker option, 2-11

printer, 2-11

default printer, 2-11

default settings

system editor, 4-7

demonstration

precompiler, 2-30

the procedural option, PL/SQL, 2-29

demonstration programs

oracle call interface, 5-8

Pro*C/C++, 5-4

demonstration tables

creating manually, 4-4

deleting, 4-4

SQL*Plus, 4-3

disk

monitoring performance, 3-7

quotas, 2-14

Disk I/O

tuning, 3-5

disk I/O

asynchronous I/O, 3-6

I/O slaves, 3-6

tuning the database writer, 3-5

disk performance

issues, 3-7

DISPLAY

environment variable, 2-10

dynamic and static linking

oracle libraries, 5-11

echo command, 2-5

editor

setting the order of, 4-6

SQL*Plus, 4-6

environment variables, 5-7

exclamation point

SQL*Plus prompt, 4-7

executable program, 2-11

exports

tuning, 3-8

expst command, 3-8

file names

default extensions in SQL*Plus, 4-8

files

groups

help facility

HOME, 2-10

I/O

imports

index size

initialization parameters

BACKGROUND_DUMP_DEST, 2-15

BITMAP_MERGE_AREA_SIZE, 2-15

COMMIT_POINT_STRENGTH, 2-15

CONTROL_FILES, 2-15

CREATE_BITMAP_AREA_SIZE, 2-15

DB_BLOCK_BUFFERS, 2-15

DB_BLOCK_SIZE, 2-15

DB_FILE_DIRECT_IO_COUNT, 2-15

DB_FILE_MULTIBLOCK_READ_COUNT, 2-15

DB_FILES, 2-15

defaults, 2-14

DISTRIBUTED_TRANSACTIONS, 2-15

HASH_AREA_SIZE, 2-15

HASH_MULTIBLOCK_IO_COUNT, 2-15

LOCK_SGA, 2-15

LOCK_SGA_AREAS, 2-15

LOG_ARCHIVE_BUFFER_SIZE, 2-15

LOG_ARCHIVE_BUFFERS, 2-15

LOG_ARCHIVE_DEST, 2-15

LOG_ARCHIVE_FORMAT, 2-15

LOG_BUFFER, 2-15

LOG_CHECKPOINT_INTERVAL, 2-15

LOG_SMALL_ENTRY_MAX_SIZE, 2-15

MTS_LISTENER_ADDRESS, 2-15

MTS_MAX_DISPATCHERS, 2-15

MTS_MAX_SERVERS, 2-15

MTS_SERVERS, 2-15

NLS_LANGUAGE, 2-15

NLS_TERRITORY, 2-15

OBJECT_CACHE_MAX_SIZE_PERCENT, 2-15

OBJECT_CACHE_OPTIMAL_SIZE, 2-15

OPEN_CURSORS, 2-16

OS_AUTHENT_PREFIX, 2-16

PROCESSES, 2-16

REMOTE_OS_AUTHENT, 2-23

SHARED_POOL_SIZE, 2-16

SHOW PARAMETERS command, 2-14

SORT_AREA_SIZE, 2-16

SORT_READ_FAC, 2-16

SORT_SPACEMAP_SIZE, 2-16

USER_DUMP_DEST, 2-16

input and output, 2-10

interrupting SQL*Plus, 4-7

IPC protocol adapter, 6-7

kernel

tuning UNIX parameters, 3-8

keywords

DBA group ID, 2-23

LANGUAGE

environment variable, 2-10

language, 2-8

ld, 2-11

LD_LIBRARY_PATH

environment variable, 2-11

LDOPTS

environment variable, 2-11

LDPATH

environment variable, 2-11

limits

resource, 2-14

linking

single-task, 3-8

login home directories

administering, 2-27

sample script, 2-28

login.sql, 4-2

LPDEST

environment variable, 2-11

MAXDATAFILES parameter, 2-34

MAXINSTANCES parameter, 2-34

MAXLOGFILES parameter, 2-34

MAXLOGHISTORY parameter, 2-34

MAXLOGMEMBERS parameter, 2-34

memory

estimating usage, 2-12

SGA tuning, 3-5

shared, 2-16

tuning, 3-3

virtual, 2-12

memory management, 3-3

control paging, 3-4

single shared memory segment, 3-5

swap space, 3-4

UNIX kernel, 3-5

MicroFocus COBOL compiler, 5-7

multiple databases

shared password file, 2-26

multiple signal handlers, 5-14

multi-thread server, 6-4

naming adapters, 6-10

National Language Support (NLS)

variable, 2-8

Net8

adapters utility, 6-3

automatic logins, 2-23

BEQ protocol adapter, 6-6

files and utilities, 6-3

IPC protocol adapter, 6-7

multi-thread server, 6-4

naming adapters, 6-10

Net8 assistant, 6-4

oracle connection manager, 6-4

oracle enterprise manager intelligent agent, 6-10

oracle names, 6-4

products and features, 6-3

protocol adapters, 6-5

README files, 6-2

TCP/IP protocol adapter, 6-8

Net8 assistant, 6-4

Net8 configuration files

network

NLS_LANG

environment variable, 2-8

operating system commands

running from SQL*Plus, 4-7

ORA_NLS

environment variable, 2-8

Oracle

memory usage, 2-13

oracle account

set authorization, 2-22

oracle call interface, 5-8

demonstration programs, 5-8

user programs, 5-9

using, 5-8

oracle connection manager, 6-4

oracle enterprise manager intelligent agent, 6-10

agent service discovery and auto-configuration, 6-10

debugging tcl scripts, 6-10

Oracle environment variables

oracle group

permissions and executables, 2-20

oracle libraries

oracle shared library, 5-12

static and dynamic linking, 5-11

oracle names, 6-4

oracle precompiler and OCI linking and makefiles, 5-10

custom makefiles, 5-10

undefined symbols, 5-10

Oracle Server

accounts, 2-19

oracle software owner, 2-19

special accounts, 2-19

Oracle System Identifier, 2-8

ORACLE_HELP

environment variable, 2-8

ORACLE_HOME

environment variable, 2-8

using ? for, 2-10

ORACLE_SID

environment variable, 2-8

suppressing prompt, 2-6

ORACLE_TERM

environment variable, 2-9

oraenv file

description, 2-5

moving between databases, 2-6

paging space

password files

passwords

PATH, 2-11

permissions

dba group, 2-20

granting, 2-20

PL/SQL

demonstrations

loading, 2-29

precompiler

relinking executables, 5-2

running demonstration, 2-30

value of ireclen and oreclen, 5-3

precompiler configuration files, 5-3

precompilers

overview, 5-2

signals, 5-14

uppercase to lowercase conversion, 5-3

values, 5-3

vendor debugger programs, 5-3

preface

Send Us Your Comments, vii

PRINTER, 2-11

Pro*C/C++

administering, 5-4

demonstration programs, 5-4

makefiles, 5-4, 5-5

signals, 5-14

system configuration file, 5-4

environment variables, 5-7

naming differences, 5-6

system configuration file, 5-7

using, 5-7

PRODUCT_USER_PROFILE Table

SQL*Plus, 4-3

protocol adapters, 6-5

ADDRESS specification, 6-5

pupbld.sql, 4-3

question mark

example of use, 2-10

raw devices

buffer cache size, 3-9

README files

Net8, 6-2

Index

Symbols

A

B

C

D

E

F

G

H

I

K

L

M

N

O

P

Q

R

S

T

U

V

W

X