Oracle8i Administrator's Reference
Release 3 (8.1.7) 64 Bit for Fujitsu Siemens ReliantUNIX

Part Number A89874-01
Go To Documentation Library
Library
Go To Product List
Product
Go To Table Of Contents
Contents

Go to previous page

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
@ abbreviation, 1-2

A

accounts, 1-15
adapters utility, 5-2
ADDRESS specification protocols, 5-6
administering SQL, 3-2
advanced-developer demo, 6-8
asynchronous I/O, 2-8
using, 2-8
authorization, 1-17
automatic login
remote_os_roles, 1-18

B

BEQ protocol, 5-6
syntax for connection parameters, 5-7
binding processes, 2-11
block size, 2-13
BSD-UNIX file system type, 2-10
buffer cache size
tuning, 2-13
buffer manager, 2-6

C

C
Pro*C/C++, 4-4
cache size, 2-13, 2-14
tuning, 2-13
catching routine, 4-17
example, 4-17
CATPROC.SQL, A-16
changing databases, 1-8
command interpreter, 1-6
commands
orapwd, 1-18
sar, 2-7
vmstat, 2-7
common environment
setting, 1-7
configuration
encapsulator, 5-11
master agent, 5-11
configuration files
Net8, 5-2
precompiler, 4-2
CONNECT INTERNAL, 1-17
coraenv, 1-4
CPU usage
priority level of processes, 2-11
processor binding, 2-11
single-task architecture, 2-12
tuning, 2-11

D

data options, 6-1
database files, 1-17
database writer
tuning, 2-8
database writer tuning, 2-8
dba group
members, 1-16
dbhome file, 1-7
DBWR tuning, 2-8
debugger programs, 4-3
demonstration
precompiler, 1-26
the procedural option, PL/SQL, 1-26
demonstration programs
oracle call interface, 4-12
Pro*C/C++, 4-4
Pro*COBOL, 4-8
demonstration tables
creating manually, 3-3
deleting, 3-4
SQL*Plus, 3-3
demos (demonstration files)
advanced-developer, 6-8
electric utility, 6-8
Java, 6-8
Oracle Call Interface (OCI), 6-9
Oracle Developer, 6-9
PRO*C/C++, 6-8
retrofitting existing tables, 6-8
usage, 6-8
Developer/2000 (Oracle Developer) demo, 6-9
disk
monitoring performance, 2-10
quotas, 1-13
disk I/O
asynchronous I/O, 2-8
file system type, 2-10
I/O slaves, 2-8
tuning, 2-8
tuning the database writer, 2-8
disk performance, 2-11
issues, 2-11
documentation
accessing, xiii
navigation files, xiii
related, xiv
where installed, xiii
dynamic and static linking
Oracle libraries, 4-3

E

editor SQL*Plus, 3-6
electric utility demo, 6-8
encapsulator configuration, 5-11
environment variables, 1-2, 4-7
MicroFocus COBOL compiler, 4-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, 4-7
SHELL, 1-6
TNS_ADMIN, 1-4, 5-2
TWO_TASK, 1-5
exports, 2-12

F

file size, 2-13
file systems, 2-10
files
dbhome, 1-7
oratab, 1-28
root.sh, 1-7
trace files, 2-14
FORMAT precompiler, 4-9
Pro*COBOL, 4-10

G

glogin.sql file, 3-2

H

help facility, 3-4

I

imports, 2-12
initialization parameters
BACKGROUND_DUMP_DEST, 1-20, 2-15
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-20
DB_BLOCK_SIZE, 1-20
DB_FILE_DIRECT_IO_COUNT, 1-20
DB_FILE_MULTIBLOCK_READ_COUNT, 1-20
DB_FILES, 1-20
DISTRIBUTED_TRANSACTIONS, 1-20
HASH_AREA_SIZE, 1-20
HASH_MULTIBLOCK_IO_COUNT, 1-20
JAVA_POOL_SIZE, 1-20
LOCK_SGA, 1-20
LOG_ARCHIVE_DEST, 1-20
LOG_ARCHIVE_FORMAT, 1-20
LOG_BUFFER, 1-20
LOG_CHECKPOINT_INTERVAL, 1-20
MTS_LISTENER_ADDRESS, 1-20
MTS_MAX_DISPATCHERS, 1-20
MTS_MAX_SERVERS, 1-20
MTS_SERVERS, 1-20
NLS_LANGUAGE, 1-21
NLS_TERRITORY, 1-21
OBJECT_CACHE_MAX_SIZE_PERCENT, 1-21
OBJECT_CACHE_OPTIMAL_SIZE, 1-21
OPEN_CURSORS, 1-21
OS_AUTHENT_PREFIX, 1-21
PROCESSES, 1-21
SHARED_POOL_SIZE, 1-21
SORT_AREA_SIZE, 1-21
initsid.ora file, 1-19
Intelligent Agent
configuration on SNMP, 5-11
interMedia
Java demo, 6-6
MediaAnnotator, 6-6
sample audio scripts, 6-2
sample programs, 6-3
sample video scripts, 6-5
Web Agent and Clipboard, 6-8
interMedia Audio, Video, and Image, 6-2
interMedia Locator, 6-6, 6-7
interMedia Text, 6-2
interrupting SQL*Plus, 3-7
I/O
tuning, 2-8
I/O slaves, 2-8
IPC protocol, 5-8
ireclen, 4-3

J

Java demos, 6-8

L

language, 1-3
limits
resource, 1-13
linking, 2-12
log writer process (LGWR), 2-11
login.sql file, 3-2

M

master agent configuration, 5-11
memory
estimating usage, 1-12
SGA tuning, 2-8
tuning, 2-6
virtual, 1-12
memory management, 2-6
control paging, 2-7
single shared memory segment, 2-8
swap space, 2-7
UNIX kernel, 2-8
MicroFocus COBOL compiler, 4-7
mpstat utility, 2-5
multiple signal handlers, 4-17
multi-thread server, 5-4

N

National Language Support (NLS) variable, 1-3
Net8
adapters utility, 5-2
ADDRESS specification, 5-5
BEQ protocol, 5-6
files and utilities, 5-2
IPC protocol, 5-8
multi-thread server, 5-4
oracle advanced security, 5-13
oracle connection manager, 5-3
products and features, 5-2
protocol support, 5-5
protocols, 5-5
RAW protocol, 5-9
TCP/IP protocol, 5-9
Net8 configuration files, 5-2
NLS_LANG variable, 1-3

O

OCI demo, 6-9
OFA
See also Optimal Flexible Architecture
Optimal Flexible Architecture, A-1
characteristics of OFA, A-2
file mapping, A-2, A-11
implementation on Oracle8 for Unix, A-2
ORA_NLS variable, 1-3
Oracle Advanced Security
.bak files, 5-13
security and single sign-on, 5-13
oracle advanced security, 5-13
.bak files, 5-13
security and single sign-on, 5-13
oracle call interface, 4-12
demonstration programs, 4-12
Oracle Call Interface (OCI) demo, 6-9
oracle connection manager, 5-3
Oracle Data Option Demos, 6-1
Oracle Developer demo, 6-9
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-4
ORACLE_SID, 1-4
ORACLE_TRACE, 1-4
ORAENV_ASK, 1-4
TNS_ADMIN, 1-4
TWO_TASK, 1-5
UNIX variables, 1-5
Oracle Forms demo, 6-9
Oracle HTTP Server, 1-23
Oracle Information Navigator, xiii
Oracle libraries
static and dynamic linking, 4-3
oracle precompiler and OCI linking and makefiles
custom makefiles, 4-15
undefined symbols, 4-15
oracle run time system
Pro*COBOL, 4-8
Oracle Server accounts, 1-15
oracle software owner, 1-15
special accounts, 1-15
Oracle System Identifier, 1-4
Oracle TCP/IP protocol, 5-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, 6-11
oraenv file
description, 1-7
moving between databases, 1-8
ORAENV_ASK, 1-4
orapwd command, 1-18
oratab file, 1-28
oreclen, 4-3

P

page-out activity, 2-7
paging, 2-7
paging space, 2-6
tuning, 2-6, 2-7
parallel server installation, 2-16
passwords, 1-18
PL/SQL demonstrations
loading, 1-26
precompiler
running demonstration, 1-26
value of ireclen and oreclen, 4-3
precompiler configuration files, 4-2
precompilers
overview, 4-2
signals, 4-17
uppercase to lowercase conversion, 4-3
values, 4-3
vendor debugger programs, 4-3
Pro*C/C++
demonstration programs, 4-4
makefiles, 4-5
signals, 4-17
using, 4-4
PRO*C/C++ demo, 6-8
Pro*COBOL, 4-7
demonstration programs, 4-8
environment variables, 4-7
FORMAT precompiler, 4-9, 4-10
naming differences, 4-7
oracle run time system, 4-8
user programs, 4-9
processor affinity/binding, 2-11
PRODUCT_USER_PROFILE Table, 3-3
protocols, 5-5
ADDRESS specification, 5-6

R

raw devices
buffer cache size, 2-13
disadvantages, 2-15
guidelines for using, 2-16
Oracle8i parallel server installation, 2-16
raw disk partition availability, 2-16
setting up, 2-16
RAW protocol, 5-9
README.txt files, 6-9
related documentation, xiv
relinking, 1-9
remote connections parameters
OS_AUTHENT_PREFIX, 1-18
REMOTE_OS_AUTHENT, 1-18
REMOTE_OS_ROLES, 1-18
remote passwords, 1-18
resource contention
tuning, 2-12
resource limits, 1-13
restrictions (SQL*Plus), 3-7
resizing windows, 3-7
return codes, 3-7
retrofit demo, 6-8
root user, 1-15
root.sh script, 1-7
running operating system commands, 3-6

S

s5 file system type, 2-10
sar command, 2-7, 2-14
scripts
start_peer, 5-11
security, 1-16, 1-17
CONNECT INTERNAL, 1-17
features of UNIX, 1-16
file ownership, 1-16
group accounts, 1-16
Server Manager access, 1-17
SHUTDOWN command, 1-17
STARTUP command, 1-17
two-task architecture, 1-16
Server Manager
commands, 1-17
security, 1-17
setting up raw devices, 2-16
setup files
SQL*Plus, 3-2
SGA
calculating, 1-10
relocating, 1-11
tuning, 2-8
shadow process, 1-16
shared memory
SGA tuning, 2-8
SHELL, 1-6
SHUTDOWN command, 1-17
security, 1-17
SIGCLD two-task signal, 4-17
SIGINT two-task signal, 4-17
SIGIO two-task signal, 4-17
signal handlers
using, 4-16
signal routine, 4-17
example, 4-17
SIGPIPE two-task signal, 4-17
SIGTERM two-task signal, 4-17
SIGURG two-task signal, 4-17
Simple Network Management Protocol (SNMP), 5-11
single shared memory segment, 2-8
site profile SQL*Plus, 3-2
SNMP
and Intelligent Agent, 5-11
SNMP and Intelligent Agent, 5-11
snmpd executable, 5-11
software distribution, 1-3
Spatial demonstrations, 6-11
special groups
root, 1-16
SPOOL command
SQL*Plus, 3-7
using, 3-7
SQL scripts, 2-6
SQL*Plus
default editor, 3-6
demonstration tables, 3-3
editor, 3-6
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
start_peer script, 5-11
STARTUP command, 1-17
static and dynamic linking
oracle libraries, 4-3
superuser, 1-15
swap space, 2-6
tuning, 2-6
SYS account, 1-15
privileges, 1-15
SYSDATE, 1-8
SYSTEM account, 1-15
privileges, 1-15
system editor
SQL*Plus, 3-6
System Global Area or Shared Global Area (SGA)
relocating, 1-11
system time, 1-8

T

TCP/IP protocol, 5-9
ADDRESS, 5-10
thread support, 4-16
TNS listener, 5-9
configuring for Oracle TCP/IP protocol, 5-9
TNS_ADMIN environment variable, 1-4
tools, 2-2
trace and alert files
alert files, 2-15
trace file names, 2-14
using, 2-13, 2-14
tracing Bourne shell scripts, 1-4
tuning, 2-6, 2-8, 2-12
block and file size, 2-13
buffer cache size, 2-13
client/server configuration, 2-11
CPU usage, 2-11
disk I/O, 2-8
I/O bottlenecks, 2-8
memory management, 2-6
resource contention, 2-12
trace and alert files, 2-13, 2-14
TWO_TASK environment variable, 1-5
two-task, 1-16

U

ufs file system type, 2-10
UNIX Environment Variables Used with Oracle8i, 1-3
UNIX file system type, 2-10
usage demo, 6-8
user interrupt handler, 4-17
user profile
SQL*Plus, 3-2
user programs
Pro*COBOL, 4-9
using SQL*Plus, 3-6
utility (electric) demo, 6-8

V

Veritas file system type, 2-10
vmstat command, 2-7
vmstat utility, 2-2
vxfs file system type, 2-10

W

writer activity, 2-8

X

XA functionality, 4-19

Go to previous page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Library
Go To Product List
Product
Go To Table Of Contents
Contents