Oracle8i Administrator's Reference
Release 3 (8.1.7) 64 Bit for SGI IRIX

Part Number A87435_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-3
ADDRESS specification protocols, 5-6
administering SQL, 3-2
advanced-developer demo, 6-8
asynchronous I/O, 2-5
using, 2-5
authorization, 1-17
automatic login
remote_os_roles, 1-18

B

BEQ protocol, 5-6
syntax for connection parameters, 5-7
binding processes, 2-8
block size, 2-10
buffer cache size
tuning, 2-11
buffer manager, 2-3

C

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

D

data options, 6-1
database files, 1-17
database writer
tuning, 2-5
database writer tuning, 2-5
dba group
members, 1-16
dbhome file, 1-8
DBWR tuning, 2-5
debugger programs, 4-3
demonstration
precompiler, 1-26
the procedural option, PL/SQL, 1-26
demonstration programs
oracle call interface, 4-9
Pro*C/C++, 4-5
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-7
quotas, 1-14
disk I/O
asynchronous I/O, 2-5
file system type, 2-7
I/O slaves, 2-5
tuning, 2-5
tuning the database writer, 2-5
disk performance, 2-7
issues, 2-7
documentation
accessing, xiii
navigation files, xiii
related, xiv
where installed, xiii
driver
post-wait, 2-8
dynamic and static linking
Oracle libraries, 4-3

E

editor SQL*Plus, 3-5
electric utility demo, 6-8
encapsulator configuration, 5-11
environment variables, 1-2
LD_LIBRARY64_PATH, 1-6
LD_LIBRARYN32_PATH, 1-6
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
SGI_ABI, 1-6
SHELL, 1-7
SRCHOME, 1-7
THREADS_FLAG, 1-7
TNS_ADMIN, 1-4, 5-2
TWO_TASK, 1-5
exports, 2-9

F

file size, 2-10
file systems, 2-7
files
dbhome, 1-8
oratab, 1-28
root.sh, 1-8
trace files, 2-15

G

glogin.sql file, 3-2

H

help facility, 3-4

I

imports, 2-9
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
IRIX_CPU_AFFINITY, 2-12
IRIX_SCHEDULER, 2-13
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
interMedia Text, 6-2
interrupting SQL*Plus, 3-6
I/O
tuning, 2-5
I/O slaves, 2-5
IPC protocol, 5-8
ireclen, 4-3
IRIX_CPU_AFFINITY parameter, 2-12
IRIX_SCHEDULER parameter, 2-13

J

Java demos, 6-8

L

language, 1-3
LD_LIBRARY64_PATH variable, 1-6
LD_LIBRARYN32_PATH variable, 1-6
limits
resource, 1-14
linking, 2-9
log writer process (LGWR), 2-8
login.sql file, 3-2

M

memory
estimating usage, 1-13
SGA tuning, 2-5
tuning, 2-3
virtual, 1-13
memory management, 2-3
control paging, 2-4
single shared memory segment, 2-5
swap space, 2-4
UNIX kernel, 2-5
multiple signal handlers, 4-13
multi-thread server, 5-4

N

National Language Support (NLS) variable, 1-3
Net8
adapters utility, 5-3
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-10
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-9
demonstration programs, 4-9
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-11
undefined symbols, 4-11
Oracle Server accounts, 1-15
oracle software owner, 1-15
special accounts, 1-15
Oracle System Identifier, 1-4
Oracle TCP/IP protocol, 5-10
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-8
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-4
paging, 2-4
paging space, 2-3
tuning, 2-3, 2-4
passwords, 1-18
PL/SQL demonstrations
loading, 1-26
post-wait driver
tuning, 2-8
precompiler
running demonstration, 1-26
value of ireclen and oreclen, 4-3
precompiler configuration files, 4-2
precompilers
overview, 4-2
signals, 4-13
uppercase to lowercase conversion, 4-3
values, 4-3
vendor debugger programs, 4-3
Pro*C/C++
demonstration programs, 4-5
makefiles, 4-5
signals, 4-13
using, 4-4
PRO*C/C++ demo, 6-8
processor affinity/binding, 2-8
PRODUCT_USER_PROFILE Table, 3-3
protocols, 5-5
ADDRESS specification, 5-6

R

raw devices
buffer cache size, 2-11
disadvantages, 2-16
guidelines for using, 2-17
raw disk partition availability, 2-17
setting up, 2-17
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-9
resource limits, 1-14
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-8
running operating system commands, 3-6

S

sar, 2-2
sar command, 2-4, 2-11
scripts
start_peer, 5-12
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
semaphores
replacing with post-wait driver, 2-8
Server Manager
commands, 1-17
security, 1-17
setting up raw devices, 2-17
setup files
SQL*Plus, 3-2
SGA
calculating, 1-11
locking in physical memory, 2-14
relocating, 1-11, 1-12
tuning, 2-5
SGI_ABI variable, 1-6
shadow process, 1-16
shared memory
SGA tuning, 2-5
SHELL, 1-7
SHUTDOWN command, 1-17
security, 1-17
SIGCLD two-task signal, 4-13
SIGINT two-task signal, 4-13
SIGIO two-task signal, 4-13
signal handlers
using, 4-12
signal routine, 4-14
example, 4-14
signals
two-task, 4-13
SIGPIPE two-task signal, 4-13
SIGTERM two-task signal, 4-13
SIGURG two-task signal, 4-13
Simple Network Management Protocol (SNMP), 5-11
single shared memory segment, 2-5
site profile SQL*Plus, 3-2
SNMP
and Intelligent Agent, 5-11
SNMP and Intelligent Agent, 5-11
snmpd executable, 5-12
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-3
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-7
running operating system commands, 3-6
setup files, 3-2
site profile, 3-2
SPOOL command, 3-7
system editor, 3-5
user profile, 3-2
using, 3-5
SRCHOME variable, 1-7
start_peer script, 5-12
STARTUP command, 1-17
static and dynamic linking
oracle libraries, 4-3
superuser, 1-15
swap space, 2-3
tuning, 2-3
SYS account, 1-15
privileges, 1-15
SYSDATE, 1-9
SYSTEM account, 1-15
privileges, 1-15
system editor
SQL*Plus, 3-5
System Global Area or Shared Global Area (SGA)
relocating, 1-11, 1-12
system time, 1-9

T

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

U

ufs file system type, 2-7
UNIX Environment Variables Used with Oracle8i, 1-3
usage demo, 6-8
user interrupt handler, 4-14
user profile
SQL*Plus, 3-2
using SQL*Plus, 3-5
utility (electric) demo, 6-8

V

vmstat command, 2-4

W

writer activity, 2-5

X

XA functionality, 4-15

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