Skip Headers
Oracle® Database Administrator's Reference
11g Release 1 (11.1) for Linux and UNIX-Based Operating Systems

Part Number B32009-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

Index

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

Symbols

@ abbreviation, 1.1

Numerics

32-bit external procedures
calling from PL/SQL, 7.3

A

A_TERM environment variable, 6.4.1.1
A_TERMCAP environment variable, 6.4.1.1
accounts
SYS, 1.4.6
SYSTEM, 1.4.6
ADA_PATH environment variable, 1.2.2
adapters utility, 5.2
administering command line SQL, 4.1
administrators
operating system accounts, 1.4.7
AIX tools
Base Operation System tools, 8.2.5.1
Performance Tool Box Agent, 8.2.5.2
Performance Tool Box Manager, 8.2.5.2
performance toolbox, 8.2.5.2
SMIT, 8.2.5.3
System Management Interface tools, 8.2.5.3
AIXTHREAD_SCOPE environment variable, A.4
alert files, 1.5.2
archive buffers
tuning, A.1.6
ASM_DISKSTRING initialization parameter, 1.3.2
assistants
Oracle Database Configuration Assistant, 3.2.3
Oracle Database Upgrade Assistant, 3.2.2
Oracle Net Configuration Assistant, 3.2.1
asynchronous flag in SGA, B.4.4
asynchronous I/O, B.4, B.4.2
verifying, B.4.3
Automatic Storage Management
restarting, 2.1.2
stopping, 2.1.2
Automatic Storage Management process
restarting, 2.1.2
stopping, 2.1.2
Automatic Storage Management, using, 8.4.1
automating
shutdown, 2.2
startup, 2.2

B

bit-length support, 6.2
block size, A.1.5
adjusting, 8.3.3
buffer cache
extended, limitations, C.1
tuning, A.1.1
buffer cache size
tuning, 8.7
buffer cache support, extended, C.1
buffer manager, 8.3, 8.3
BUFFER parameter, A.1.7
buffer-cache paging activity
controlling, A.1.1

C

cache size, 8.7
catching routine, 6.12
example, 6.12
CLASSPATH environment variable, 1.2.2
client shared libraries, 6.1.6
client static libraries, 6.1.6
COBDIR environment variable, 6.4.1.2
commands
iostat, 8.2.3
lsps, 8.2.4
orapwd, 1.4.5
sar, 8.2.2
SPOOL, 4.2.4
swap, 8.2.4
swapinfo, 8.2.4
swapon, 8.2.4
vmo, A.1.1
vmstat, 8.2.1
common environment
setting, 1.2.3
concurrent I/O, A.2.2
configuration files
ottcfg.cfg, 6.1.1
pcbcfg.cfg, 6.1.1
pccfor.cfg, 6.1.1
pcscfg.cfg, 6.1.1
pmscfg.cfg, 6.1.1
precompiler, 6.1.1
configuring
accounts of Oracle users, 1.4.8
Oracle Database, 3.2.4
coraenv file, 1.2.3
CPU scheduling, A.3
CPU_COUNT initialization parameter, B.6, B.6
CREATE CONTROLFILE parameter, G.1
CREATE DATABASE parameter, G.1
CURSOR_SPACE_FOR_TIME initialization parameter
tuning Oracle Database, B.5

D

database
block size, A.1.5
database block size
setting, A.1.5
Database Control
See Oracle Enterprise Manager Database Control
database limits, G.1
DB_BLOCK_SIZE initialization parameter, 1.3.1, 8.6, 8.6, 8.6
DB_CACHE_SIZE initialization parameter, 8.6
DB_FILE_MULTIBLOCK_READ_COUNT parameter, A.2.5
DBAs
See administrators
dbhome file, 1.2.3
debugger programs, 6.1.4
demo_proc32.mk file, 6.3.2
demo_proc32.mk make file, 6.3.2
demo_procob.mk file, 6.4.4
demonstration programs
for Pro*COBOL, 6.4.3
Oracle Call Interface, 6.7.1
Oracle JDBC/OCI, 6.8
Pro*C/C++, 6.3.1
Pro*FORTRAN, 6.5.1
SQL*Module for Ada, 6.6.1
demonstrations
PL/SQL, 7.2
precompiler, 7.2
SQL*Loader, 7.1
direct I/O, A.2.2
disk I/O
file system type, 8.4.2
I/O slaves, A.2.4
tuning, 8.4
disk I/O pacing
tuning, A.2.8
disks
monitoring performance, 8.5
DISM, E.1
DISPLAY environment variable, 1.2.2
DYLD_LIBRARY_PATH environment variable, 1.2.2
dynamic cache parameters, C.1
dynamic linking
Oracle libraries and precompilers, 6.1.5

E

environment variables, 6.4.1.2
A_TERM, 6.4.1.1
A_TERMCAP, 6.4.1.1
ADA_PATH, 1.2.2
AIXTHREAD_SCOPE, A.4
all, 1.2.1
CLASSPATH, 1.2.2
COBDIR, 6.4.1.2
DISPLAY, 1.2.2
DYLD_LIBRARY_PATH, 1.2.2
for Pro*COBOL, 6.4.1
HOME, 1.2.2
LANG, 1.2.2
LANGUAGE, 1.2.2
LD_LIBRARY_PATH, 1.2.2, 6.4.1.1, 6.4.1.2
LD_OPTIONS, 1.2.2
LIBPATH, 1.2.2, 6.4.1.2
LPDEST, 1.2.2
MicroFocus COBOL compiler, 6.4.1.2
ORA_TZFILE, 1.2.1, 1.2.1
ORACLE_BASE, 1.2.1
ORACLE_HOME, 1.2.1
ORACLE_PATH, 1.2.1
ORACLE_SID, 1.1, 1.2.1, 1.2.1
ORACLE_TRACE, 1.2.1
ORAENV_ASK, 1.2.1
PATH, 1.2.2, 4.2.1, 6.4.1.1, 6.4.1.2
PRINTER, 1.2.2
SHLIB_PATH, 1.2.2, 6.4.1.2
SQLPATH, 1.2.1, 1.2.1
TMPDIR, 1.2.2
TNS_ADMIN, 5.1
TWO_TASK, 1.2.1
XENVIRONMENT, 1.2.2
executables
precompiler, 6.1.2
precompilers, 6.1.2
relinking, 3.3
Extended file system, 8.4.2

F

file
services, 5.4
file buffer cache
tuning on AIX, A.1.2
file system
ext2/ext3, 8.4.2
GPFS, 8.4.2
JFS, 8.4.2
OCFS, 8.4.2
S5, 8.4.2
UFS, 8.4.2
VxFS, 8.4.2
file systems, 8.4.2
files
alert, 1.5, 1.5.2
coraenv, 1.2.3
dbhome, 1.2.3
demo_proc32.mk, 6.3.2
demo_procob.mk, 6.4.4
glogin.sql, 4.1.1
ins_precomp.mk, 6.1.2
login.sql, 4.1.1
Oracle Net Services configuration, 5.1
oraenv, 1.2.3
ottcfg.cfg, 6.1.1
pcbcfg.cfg, 6.1.1
pccfor.cfg, 6.1.1
pcscfg.cfg, 6.1.1
pmscfg.cfg, 6.1.1
privgroup, B.2.1, B.4.1
README, 6.1.3
root.sh, 1.2.3
trace, 1.5, 1.5.1
FORMAT precompiler, 6.4.4
Pro*COBOL, 6.4.5

G

getprivgrp command, B.2.1, B.4.1
glogin.sql file, 4.1.1
GPFS
considerations for using, A.2.2
groups
osdba, 1.4.2
See operating system groups

H

HOME environment variable, 1.2.2
HP-UX dynamic processor reconfiguration, B.6
HP-UX tools, 8.2.6
Glance/UX, 8.2.6
hugetlbfs
on Linux, C.3
on SUSE, C.2

I

implementing asynchronous I/O, B.4.2
Import utility, A.1.7
initialization parameters, 1.3
CPU_COUNT, B.6
DB_BLOCK_SIZE, 8.6, 8.6, 8.6
DB_CACHE_SIZE, 8.6
JAVA_POOL_SIZE, 8.6
LARGE_POOL_SIZE, 8.6
LOG_BUFFERS, 8.6
SHARED_POOL_SIZE, 8.6
initialization parameters ASM_DISKSTRING, 1.3.2
initialization parameters DB_BLOCK_SIZE, 1.3.1
initialization parameters LOG_ARCHIVE_DEST_n, 1.3.3
in-memory file system, C.1
ins_precomp.mk file, 6.1.2
installing
SQL*Plus command line Help, 4.1.4.1
intimate shared memory, E.1
I/O
asynchronous, A.2.3, B.4
tuning, 8.4
I/O buffers and SQL*Loader, A.1.7
I/O slaves, A.2.4
I/O support
asynchronous, C.5
direct, C.6
iostat command, 8.2.3
IPC protocol, 5.3.1
ireclen, 6.1.4
ISM, E.1

J

JAVA_POOL_SIZE initialization parameters, 8.6
JFS
considerations, A.2.2
JFS2
considerations, A.2.2
Journaled file system, 8.4.2
journaled file system, A.2.2, A.2.2
journaled file systems, A.2.2

L

LANG environment variable, 1.2.2
LANGUAGE environment variable, 1.2.2
LARGE_POOL_SIZE initialization parameters, 8.6
LD_LIBRARY_PATH environment variable, 1.2.2, 6.4.1.1, 6.4.1.2
LD_OPTIONS environment variable, 1.2.2
LIBPATH environment variable, 1.2.2, 6.4.1.2
libraries
client shared and static, 6.1.6
Lightweight Timer, B.3
lightweight timer implementation, B.3
Linux tools, 8.2.7
listener
setting up for TCP/IP or TCP/IP with Secure Sockets Layer, 5.4
LOG_ARCHIVE_DEST_n initialization parameter, 1.3.3
LOG_BUFFERS initialization parameters, 8.6
Logical Volume Manager
See LVM
login.sql file, 4.1.1
LPDEST environment variable, 1.2.2
lsps command, 8.2.4
LVM on AIX, A.2.1

M

Mac OS X tools, 8.2.9
make files
demo_proc32.mk, 6.3.2
demo_procob.mk, 6.4.4
ins_precomp.mk, 6.1.2
make files, custom, 6.9
MAXDATAFILES parameter, G.1
maxfree parameter, A.1.1
MAXINSTANCES parameter, G.1, G.1
MAXLOGFILES parameter, G.1
MAXLOGHISTORY parameter, G.1
MAXLOGMEMBERS parameter, G.1
maxperm parameter, A.1.1, A.1.2
memory
contention, A.1
tuning, 8.3
memory and paging, on AIX, A.1
memory management, 8.3
control paging, 8.3.2
swap space, 8.3.1
MicroFocus COBOL compiler, 6.4.1.2
migrating, 3.2.2
minfree parameter, A.1.1
minperm parameter, A.1.1, A.1.2
MLOCK privilege, B.4.1
mpstat command, 8.2.8
multiple signal handlers, 6.12
multithreaded applications, 6.11

N

network support, C.8

O

OCCI, 6.7
user programs, 6.7.2
OCI, 6.7
user programs, 6.7.2
oinstall group, 1.4.2
operating system buffer cache, tuning, 8.7
operating system commands
getprivgrp, B.2.1, B.4.1
setprivgrp, B.2.1, B.4.1
operating system commands, running, 4.2.2
operating system groups
oinstall, 1.4.2
Oracle Inventory group, 1.4.2
OSDBA, 1.4.7
OSOPER, 1.4.7
osoper, 1.4.2
operating system tools
for AIX, 8.2.5
iostat, 8.2.3
lsps, 8.2.4
sar, 8.2.2
swap, 8.2.4
swapinfo, 8.2.4
swapon, 8.2.4
vmstat, 8.2.1
ORA_NLS10 environment variable, 1.2.1
ORA_TZFILE environment variable, 1.2.1, 1.2.1
oracle account, 1.4.3
Oracle advanced security, 5.5
Oracle block size, adjusting, 8.3.3
Oracle buffer manager, 8.3
Oracle C++ Call Interface, 6.7, 6.7.1
See OCCI
Oracle Call Interface, 6.7
See OCI
Oracle Call Interface and Oracle C++ Call Interface
demonstration programs, 6.7.1
Oracle Cluster Services Synchronization Daemon
starting, 2.1.3
stopping, 2.1.3
Oracle Database, 3.2.3
restarting, 2.1.2
stopping, 2.1.2
Oracle Database Configuration Assistant
configuring, 3.2.3
Oracle Database environment variables
Oracle Database variables, 1.2.1
Oracle Database process
stopping, 2.1.2
Oracle Database Sample Schemas
Oracle Database tuning and large memory allocations, B.5
Oracle Database Upgrade Assistant, 3.2.2
Oracle Enterprise Manager Database Control
starting, 2.1.6
stopping, 2.1.6
Oracle environment variables
ORA_NLS10, 1.2.1
Oracle Inventory group, 1.4.2
Oracle JDBC/OCI
demonstration programs, 6.8
Oracle Management Agent
starting, 2.1.7
stopping, 2.1.7
Oracle Net Configuration Assistant
using, 3.2.1
Oracle Net Listener
restarting, 2.1.4
stopping, 2.1.4
Oracle Net Services
configuration files, 5.1
IPC protocol, 5.3.1
Oracle advanced security, 5.5
protocol support, 5.3
protocols, 5.3
TCP/IP protocol, 5.3.2
Oracle Net Services TCP/IP with Secure Sockets Layer protocol, 5.3.3
Oracle ODBC Driver, F
Oracle products
configuring the database for additional, 3.1
Oracle Protocol Support
IPC protocol, 5.3.1
TCP/IP protocol, 5.3.2
TCP/IP with Secure Sockets Layer protocol, 5.3.3
Oracle software owner account, 1.4.1
Oracle Ultra Search
starting, 2.1.5
stopping, 2.1.5
Oracle user accounts
configuring, 1.4.8
ORACLE_BASE environment variable, 1.2.1
ORACLE_HOME environment variable, 1.2.1
ORACLE_PATH environment variable, 1.2.1
ORACLE_SID environment variable, 1.1, 1.2.1, 1.2.1
ORACLE_TRACE environment variable, 1.2.1
oradism command, E.1
oraenv file, 1.2.3
ORAENV_ASK environment variable, 1.2.1
orapwd command, 1.4.5
orapwd utility, 1.4.5
oreclen, 6.1.4
OS_AUTHENT_PREFIX parameter, 1.4.4
OSDBA group, 1.4.7
osdba group, 1.4.2
OSOPER group, 1.4.7
osoper group, 1.4.2
ottcfg.cfg file, 6.1.1

P

page-out activity, 8.3.2
paging
controlling, A.1.4
paging space, 8.3
allocating sufficient, A.1.3
tuning, 8.3, 8.3.2
paging, controlling, 8.3.2
parameters
BUFFER, A.1.7
CREATE CONTROLFILE, G.1
CREATE DATABASE, G.1
DB_FILE_MULTIBLOCK_READ_COUNT, A.2.5
dynamic cache, C.1
MAXDATAFILES, G.1
maxfree, A.1.1
MAXLOGFILES, G.1
MAXLOGHISTORY, G.1
MAXLOGMEMBERS, G.1
maxperm, A.1.1, A.1.2
minfree, A.1.1
minperm, A.1.1, A.1.2
OS_AUTHENT_PREFIX, 1.4.4
SCHED_NOAGE, B.2
SGA_MAX_SIZE, E.1
shm_max, 8.6
shm_seg, 8.6
shmmax, 8.6
shmseg, 8.6
USE_INDIRECT_DATA_BUFFERS, C.1
PATH environment variable, 1.2.2, 4.2.1, 6.4.1.1, 6.4.1.2
pcbcfg.cfg file, 6.1.1
pccfor.cfg file, 6.1.1
pcscfg.cfg file, 6.1.1
Performance Tool Box Agent, 8.2.5.2
performance tuning tools, 8.2.6
per-process max locked memory
VLM Window size and Red Hat Enterprise Linux 3, C.1
PL/SQL demonstrations, 7.2
PL/SQL kernel demonstrations, 7.2
pmscfg.cfg file, 6.1.1
postinstallation tasks
configuration assistants, 3.2
precompiler configuration files
files
precompiler configuration, 6.1.1
precompiler executables
relinking, 6.1.2
precompiler README files, 6.1.3
precompilers
executables, 6.1.2
overview, 6.1
Pro*C/C++, 6.3
Pro*COBOL, 6.4
running demonstrations, 7.2
signals, 6.12
uppercase to lowercase conversion, 6.1.4
value of ireclen and oreclen, 6.1.4
vendor debugger programs, 6.1.4
PRINTER environment variable, 1.2.2
private memory, B.5.1
private SQL areas, B.5.1
privgroup file, B.2.1, B.4.1
Pro*C/C++
demonstration programs, 6.3.1
make files, 6.3.1
signals, 6.12
user programs, 6.3.2
Pro*C/C++ precompiler, 6.3
Pro*COBOL
demonstration programs, 6.4.3
environment variables, 6.4.1
FORMAT precompiler, 6.4.4, 6.4.5
naming differences, 6.4
Oracle Runtime system, 6.4.2
user programs, 6.4.4
Pro*COBOL precompiler, 6.4
Pro*FORTRAN demonstration programs, 6.5.1
processor binding on SMP systems
using, A.3.2
PRODUCT_USER_PROFILE table, 4.1.2
Programmer's Analysis Kit, 8.2.6
protocols, 5.3

R

raw devices
buffer cache size, 8.7
raw logical volumes, A.2.2, A.2.2, A.2.2
relinking executables, 3.3
removing
SQL*Plus command line Help, 4.1.4.2
resilvering, with Oracle Database, A.2.9
restarting
Automatic Storage Management, 2.1.2
Oracle Database, 2.1.2
Oracle Net Listener, 2.1.4
restrictions, SQL*Plus, 4.3
passwords, 4.3.3
resizing windows, 4.3.1
return codes, 4.3.2
root.sh file, 1.2.3
root.sh script, 1.2.3

S

Sample Schemas
See Oracle Database Sample Schemas
sar command, 8.2.2, 8.3.2
SCHED_NOAGE parameter, enabling, B.2.1
SCHED_NOAGE parameter, scheduling policy, B.2
scripts
root.sh, 1.2.3
security, 1.4.2
features of operating system, 1.4.2
file ownership, 1.4.2
group accounts, 1.4.2
two-task architecture, 1.4.2
semtimedop support, C.7
sequential read ahead
tuning, A.2.7
services file, 5.4
setprivgrp command, B.2.1, B.4.1
SGA, 8.6
determining the size of, 8.6.1
SGA address space, increasing, C.4
SGA_MAX_SIZE parameter, E.1
shadow process, 1.4.2
shared memory segments, B.1
shared memory, on AIX, 8.6.2
SHARED_POOL_SIZE initialization parameters, 8.6
SHLIB_PATH environment variable, 1.2.2, 6.4.1.2
shm_max parameter, 8.6
shm_seg parameter, 8.6
shmmax parameter, 8.6
shmseg parameter, 8.6
shutdown
automating, 2.2
SIGCLD signal, 6.12
SIGCONT signal, 6.12
SIGINT signal, 6.12
SIGIO signal, 6.12
signal handlers, 6.12
signal routine, 6.12
example, 6.12
signals
SIGCLD, 6.12
SIGCONT, 6.12
SIGINT, 6.12
SIGIO, 6.12
SIGPIPE, 6.12
SIGTERM, 6.12
SIGURG, 6.12
SIGPIPE signal, 6.12
SIGTERM signal, 6.12
SIGURG signal, 6.12
Solaris tools, 8.2.8
special accounts
Oracle software owner account, 1.4.1
SPOOL command
SQL*Plus, 4.2.4
SQL*Loader, A.1.7
SQL*Loader demonstrations, 7.1
SQL*Module for Ada, 6.6
demonstration programs, 6.6.1
user programs, 6.6.2
SQL*Plus
command line Help, 4.1.4
default editor, 4.2.1
editor, 4.2.1
interrupting, 4.2.3
PRODUCT_USER_PROFILE table, 4.1.2
restrictions, 4.3
running operating system commands, 4.2.2
site profile, 4.1.1
SPOOL command, 4.2.4
system editor, 4.2.1
user profile, 4.1.1
using command-line SQL*Plus, 4.2
SQL*Plus command line Help
installing, 4.1.4.1
removing, 4.1.4.2
SQL*Plus, interrupting, 4.2.3
SQLPATH environment variable, 1.2.1, 1.2.1
starting
Oracle Cluster Services Synchronization Daemon, 2.1.3
Oracle Enterprise Manager Database Control, 2.1.6
Oracle Management Agent, 2.1.7
Oracle Processes on Mac OS X, 2.1.1
Oracle Ultra Search, 2.1.5
startup
automating, 2.2
static linking
Oracle libraries and precompilers, 6.1.5
stopping
Automatic Storage Management, 2.1.2
Oracle Cluster Services Synchronization Daemon, 2.1.3
Oracle Database, 2.1.2
Oracle Enterprise Manager Database Control, 2.1.6
Oracle Management Agent, 2.1.7
Oracle Net Listener, 2.1.4
Oracle Ultra Search, 2.1.5
striped logical volume
designing, A.2.1
swap command, 8.2.4
swap space, 8.3
determining available and used, D.1
tuning, 8.3
swap space allocation, 8.3.1
swapinfo command, 8.2.4
swapon command, 8.2.4
symfind utility, 6.10
SYS account, 1.4.6
SYSDATE, 1.2.4
SYSTEM account, 1.4.6
system editor
SQL*Plus, 4.2.1
system time, 1.2.4

T

tables
PRODUCT_USER_PROFILE, 4.1.2
TCP/IP protocol, 5.3.2
TCP/IP with Secure Sockets Layer protocol, 5.3.3
thread support, 6.11
TMPDIR environment variable, 1.2.2
trace alert, 1.5
trace files, 1.5, 1.5.1
tuning, 8.3, 8.3
disk I/O, 8.4
I/O bottlenecks, 8.4
memory management, 8.3
sequential read ahead, A.2.7
tuning Oracle Database
large memory allocations, B.5
tuning recommendations, B.5.3
tuning tools
Glance/UX utility, 8.2.6
iostat command, 8.2.3
lsps command, 8.2.4
mpstat, 8.2.8
Performance Tool Box Agent, 8.2.5.2
Performance Tool Box Manager, 8.2.5.2
Programmer's Analysis Kit, 8.2.6
sar command, 8.2.2
swap command, 8.2.4
swapinfo command, 8.2.4
swapon command, 8.2.4
vmstat command, 8.2.1
TWO_TASK environment variable, 1.2.1

U

Ultra SearchSee Oracle Ultra Search
undefined symbols, 6.10
unified file system, 8.4.2
UNIX System V file system, 8.4.2
upgraded databases
configuring, 3.2.4
upgrading, 3.2.2
USE_INDIRECT_DATA_BUFFERS parameter, C.1
user interrupt handler, 6.12
user profile
SQL*Plus, 4.1.1
user programs
for Pro*C/C++, 6.3.2
OCCI, 6.7.2
OCI, 6.7.2
Pro*C/C++, 6.3.2
Pro*COBOL, 6.4.4
SQL*Module for Ada, 6.6.2
using command-line SQL*Plus, 4.2
utilities
adapters, 5.2
Import, A.1.7
orapwd, 1.4.5
symfind, 6.10
UTLRP.SQL
recompiling invalid SQL modules, 3.2.4

V

Veritas file system, 8.4.2
virtual memory data pages
tuning Oracle Database, B.5
Virtual Memory Manager
See VMM
virtual memory page size, default, B.5.2
VLM window size, C.1
VMM
vmo command, A.1.1
vmstat command, 8.2.1

X

XA functionality, 6.13
XENVIRONMENT environment variable, 1.2.2
X/Open Distributed Transaction Processing XA interface, 6.13