Полезная информация

Oracle8 Administrator's Reference
Release 8.0.5 for Intel-LINUX

A66585-02

Library

Product

Contents

Prev

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  Y  Z 


Symbols

$
using, 2-24
?
example of use, 2-10
@
to denote $ORACLE_SID, 2-10
_editor
setting, 4-6

A

Ada compiler, 2-11
ADA_PATH, 2-11
adapters utility, 6-3
ADDRESS specification
protocol adapters, 6-5
administering
SQL, 4-2
afiedt.buf, 4-7
asynchronous I/O, 3-5
using, 3-5
automatic login
listener.ora file, 2-24
non-UNIX systems, 2-24
remote_os_roles, 2-28

B

BEQ protocol adapter, 6-5
ADDRESS, 6-6
overview, 6-5
syntax for connection parameters, 6-6
binding processes, 3-8
block and file size
specifying, 3-9
BSD, 2-12
buffer cache size
tuning, 3-9
buffer manager, 3-3

C

C
Pro*C/C++, 5-4
cache
size
tuning, 3-9
catching routine
example, 5-12
CATPROC.SQL, 1-15
CDE tools, 2-9
changing databases, 2-6
chmod command
example, 2-23
cluster
estimating size, 2-14
command interpreter, 2-12
commands
expst, 3-8
impst, 3-8
ipcs, 3-5
orapwd, 2-26
sar, 3-4
vmstat, 3-4
common environment
oraenv file, 2-5
setting, 2-5
configuration files
Net8, 6-3
precompiler, 5-3
CONNECT INTERNAL
security, 2-22
control remote DBA access
REMOTE_DBA_OPS_ALLOWED, 2-25
REMOTE_DBA_OPS_DENIED, 2-25
control remote login, 2-25
OPS_DOLLAR_LOGIN_DENIED, 2-25
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

D

daemon user
security, 2-24
database
administrator
permissions for executables, 2-21
files
authorization, 2-23
security, 2-23
database I/O
DBWR tuning, 3-5
database writer
tuning, 3-5
dba group
members, 2-20
relinking, 2-21
DBA group ID
keywords, 2-24
non-default name, 2-25
DBA_GROUP
/etc/listener.ora file, 2-25
DBA_GROUP_sid
/etc/listener.ora file, 2-25
DBWR
tuning, 3-5
debugger programs, 5-3
default
directory, 2-11, 2-12
linker option, 2-11
printer, 2-11
default printer, 2-12
default settings
system editor, 4-7
demonstration
precompiler, 2-31
the procedural option, PL/SQL, 2-30
demonstration programs
oracle call interface, 5-6
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-5
I/O slaves, 3-6
tuning the database writer, 3-5
disk performance
issues, 3-7
DISPLAY
environment variable, 2-11
dynamic and static linking
oracle libraries, 5-10

E

echo command, 2-5
editor
setting the order of, 4-6
SQL*Plus, 4-6
environment variables
ADA_PATH, 2-11
DISPLAY, 2-11
HOME, 2-11
LANG, 2-11
LANGUAGE, 2-11
LD_LIBRARY_PATH, 2-11
LDOPTS, 2-11
LDPATH, 2-11
LPDEST, 2-11
NLS_LANG, 2-8
ORA_NLS, 2-8
ORACLE_HELP, 2-8
ORACLE_HOME, 2-8
ORACLE_SID, 2-8
ORACLE_TERM, 2-9
ORACLE_TERMINAL, 2-9
ORACLE_TRACE, 2-9
ORAENV_ASK, 2-9
PATH, 2-11
PRINTER, 2-12
setting for SQL*Plus, 4-7
SHELL, 2-12
TERM, 2-12
TMPDIR, 2-12
TNS_ADMIN, 2-9, 6-3
TWO_TASK, 2-10
TZ, 2-12
XENVIRONMENT, 2-12
exclamation point
SQL*Plus prompt, 4-7
executable program, 2-11
exports
tuning, 3-8
expst command, 3-8

F

file names
default extensions in SQL*Plus, 4-8
files
trace files, 3-10

G

glogin.sql, 4-2
groups
sample script, 2-30

H

help facility
SQL*Plus, 4-4
help file, 2-8
HOME, 2-11
home directory, 2-11

I

I/O
DBWR tuning, 3-5
tuning, 3-5
I/O slaves, 3-6
imports
tuning, 3-8
impst command, 3-8
index size
calculating, 2-14
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-15
DISTRIBUTED_TRANSACTIONS, 2-15
HASH_AREA_SIZE, 2-15
HASH_MULTIBLOCK_IO_COUNT, 2-16
LOCK_SGA, 2-16
LOCK_SGA_AREAS, 2-16
LOG_ARCHIVE_BUFFER_SIZE, 2-16
LOG_ARCHIVE_BUFFERS, 2-16
LOG_ARCHIVE_DEST, 2-16
LOG_ARCHIVE_FORMAT, 2-16
LOG_BUFFER, 2-16
LOG_CHECKPOINT_INTERVAL, 2-16
LOG_SMALL_ENTRY_MAX_SIZE, 2-16
MTS_LISTENER_ADDRESS, 2-16
MTS_MAX_DISPATCHERS, 2-16
MTS_MAX_SERVERS, 2-16
MTS_SERVERS, 2-16
NLS_LANGUAGE, 2-16
NLS_TERRITORY, 2-16
OBJECT_CACHE_MAX_SIZE_PERCENT, 2-16
OBJECT_CACHE_OPTIMAL_SIZE, 2-16
OPEN_CURSORS, 2-16
OS_AUTHENT_PREFIX, 2-16
PROCESSES, 2-16
REMOTE_OS_AUTHENT, 2-24
SHARED_POOL_SIZE, 2-16
SHOW PARAMETERS command, 2-15
SORT_AREA_SIZE, 2-16
SORT_READ_FAC, 2-16
SORT_SPACEMAP_SIZE, 2-16
USER_DUMP_DEST, 2-16
input and output, 2-11
interrupting SQL*Plus, 4-7
IPC protocol adapter, 6-7
ADDRESS, 6-7
overview, 6-7
ipcs command, 3-5
ireclen, 5-3

K

kernel
tuning UNIX parameters, 3-8
keywords
DBA group ID, 2-24

L

LANGUAGE
environment variable, 2-11
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-28
sample script, 2-29
login.sql, 4-2
LPDEST
environment variable, 2-11

M

MAXDATAFILES parameter, 2-35
MAXINSTANCES parameter, 2-35
MAXLOGFILES parameter, 2-35
MAXLOGHISTORY parameter, 2-35
MAXLOGMEMBERS parameter, 2-35
memory
estimating usage, 2-13
SGA tuning, 3-5
shared, 2-16
tuning, 3-3
virtual, 2-13
memory management, 3-3
control paging, 3-4
single shared memory segment, 3-5
swap space, 3-4
UNIX kernel, 3-5
multiple databases
shared password file, 2-27
multiple signal handlers, 5-12
multi-thread server, 6-4

N

naming adapters, 6-9
National Language Support (NLS)
variable, 2-8
Net8
adapters utility, 6-3
automatic logins, 2-24
BEQ protocol adapter, 6-5
files and utilities, 6-3
IPC protocol adapter, 6-7
multi-thread server, 6-4
naming adapters, 6-9
oracle connection manager, 6-4
oracle enterprise manager intelligent agent, 6-9
oracle names, 6-4
products and features, 6-3
protocol adapters, 6-4
README files, 6-2
TCP/IP protocol adapter, 6-8
Net8 configuration files
location of, 6-3
network
dba privileges, 2-23
passwords, 2-23
security, 2-23
NLS_LANG
environment variable, 2-8

O

operating system commands
running from SQL*Plus, 4-7
ORA_NLS
environment variable, 2-8
Oracle
memory usage, 2-14
oracle account
set authorization, 2-23
oracle call interface, 5-6
demonstration programs, 5-6
user programs, 5-7
using, 5-6
oracle connection manager, 6-4
oracle enterprise manager intelligent agent, 6-9
agent service discovery and auto-configuration, 6-9
debugging tcl scripts, 6-9
Oracle environment variables
EPC_DISABLED, 2-7
NLS_LANG, 2-8
ORA_NLS33, 2-8
ORACLE_BASE, 2-8
ORACLE_HELP, 2-8
ORACLE_HOME, 2-8
ORACLE_PATH, 2-8
ORACLE_SID, 2-8
ORACLE_TERM, 2-9
ORACLE_TERMINAL, 2-9
ORACLE_TRACE, 2-9
ORAENV_ASK, 2-9
TNS_ADMIN, 2-9
TWO_TASK, 2-10
oracle group
permissions and executables, 2-21
oracle libraries
oracle shared library, 5-10
static and dynamic linking, 5-10
oracle names, 6-4
oracle precompiler and OCI linking and makefiles, 5-8
custom makefiles, 5-8
undefined symbols, 5-9
Oracle Server
accounts, 2-20
oracle software owner, 2-20
special accounts, 2-20
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
ORAENV_ASK, 2-9
setting, 2-6
orainst, 2-9
orapwd command, 2-26
oreclen, 5-3

P

paging space
tuning, 3-3, 3-4
password files
shared, 2-27
passwords
remote, 2-26
PATH, 2-11
permissions
dba group, 2-21
granting, 2-21
PL/SQL
demonstrations
loading, 2-30
precompiler
relinking executables, 5-2
running demonstration, 2-31
value of ireclen and oreclen, 5-3
precompiler configuration files, 5-3
precompilers
overview, 5-2
signals, 5-12
uppercase to lowercase conversion, 5-3
values, 5-3
vendor debugger programs, 5-3
preface
Send Us Your Comments, vii
PRINTER, 2-12
Pro*C/C++
administering, 5-4
demonstration programs, 5-4
makefiles, 5-4, 5-5
signals, 5-12
system configuration file, 5-4
user programs, 5-5
using, 5-4
PRODUCT_USER_PROFILE Table
SQL*Plus, 4-3
protocol adapters, 6-4
ADDRESS specification, 6-5
pupbld.sql, 4-3

Q

question mark
example of use, 2-10

R

raw devices
buffer cache size, 3-9
README files
Net8, 6-2
related documentation, xii
relinking precompiler executables, 5-2
remote
connect
as INTERNAL, 2-28
as OPERATOR, 2-28
login
security, 2-24
parameter
REMOTE_OS_AUTHENT, 2-24
remote connections parameters
OS_AUTHENT_PREFIX, 2-28
REMOTE_OS_AUTHENT, 2-28
REMOTE_OS_ROLES, 2-28
resource contention
kernel parameters, 3-8
tuning, 3-8
resource definition, 2-12
resource limits, 2-14
restrictions (SQL*Plus), 4-8
COPY command, 4-8
resizing windows, 4-8
return codes, 4-9
root
user, 2-20

S

sar command, 3-4
security
assigning permissions, 2-21
CONNECT INTERNAL, 2-22
default group names, 2-21
file ownership, 2-21
group accounts, 2-21
network, 2-23
Server Manager access, 2-22
SHUTDOWN command, 2-22
STARTUP command, 2-22
two-task architecture, 2-21
Send Us Your Comments, vii
Server Manager
commands, 2-22
security, 2-22
SHOW PARAMETERS, 2-15
setup files
SQL*Plus, 4-2
SGA
estimating size, 3-5
relocating, 2-18
tuning, 3-5
shadow process
security, 2-21
shared
library loader, 2-11
object library, 2-11
shared memory
SGA, 2-16
SGA tuning, 3-5
shared object library, 2-11
SHELL, 2-12
SHUTDOWN command, 2-22
security, 2-22
SIGCLD two-task signal, 5-12
SIGINT two-task signal, 5-12
SIGIO two-task signal, 5-12
signal handlers
signals, 5-11
using, 5-11
signal routine
example, 5-12
signals
creating handlers, 5-11
two-task, 5-11
SIGPIPE two-task signal, 5-12
SIGTERM two-task signal, 5-12
SIGURG two-task signal, 5-12
single shared memory segment, 3-5
site profile
SQL*Plus, 4-2
software distribution, 2-8
special accounts, 2-20
special groups
root, 2-20
SPOOL command
SQL*Plus, 4-8
using, 4-8
SQL
administering, 4-2
SQL scripts, 3-3
utlbstat and utlestat, 3-3
SQL*DBA, 2-9
SHOW PARAMETERS, 2-15
SQL*Plus
COPY command, 4-8
default editor, 4-6
demonstration tables, 4-3
editor, 4-6
environment variables, 4-7
help facility, 4-4
interrupting, 4-7, 4-8
PRODUCT_USER_PROFILE Table, 4-3
restrictions, 4-8
sample setup files, 4-3
setup files, 4-2
site profile, 4-2
SPOOL command, 4-8
system editor, 4-6
UNIX commands, 4-7
user profile, 4-2
using, 4-6
STARTUP command
security, 2-22
static and dynamic linking
oracle libraries, 5-10
sub-shell
creating in SQL*Plus, 4-7
superuser, 2-20
swap, 3-3
swap space
tuning, 3-3
SYS account
privileges, 2-20
SYSDATE
and TZ, 2-13
SYSTEM account
privileges, 2-20
system configuration file
Pro*C/C++, 5-4
system editor
default settings, 4-7
setting the order of, 4-6
SQL*Plus, 4-6
System Global Area (SGA)
relocating, 2-18
requirements, 2-16
system time
setting, 2-12
System V, 2-11

T

TCP/IP protocol adapter, 6-8
ADDRESS, 6-8
overview, 6-8
temporary disk file, 2-12
TERM
environment variable, 2-12
thread support, 5-9
time zone
setting with TZ, 2-12
TMPDIR, 2-12
TNS listener
configuring for Oracle TCP/IP Protocol Adapter, 6-8
TNS_ADMIN
environment variable, 2-9
Toolkit II resource file, 2-9
tools, 3-2
swap, 3-3
vmstat, 3-2
trace and alert files
alert files, 3-10
trace file names, 3-10
using, 3-9, 3-10
tracing Bourne shell scripts, 2-9
tuning
block and file size, 3-9
buffer cache size, 3-9
CPU usage, 3-7
disk I/O, 3-5
I/O bottlenecks, 3-5
memory management, 3-3
resource contention, 3-8
trace and alert files, 3-9, 3-10
TWO_TASK
environment variable, 2-10
two-task
architecture
security, 2-21
signals, 5-11
TZ
and SYSDATE, 2-12
environment variable, 2-12

U

UNIX
security, 2-21
UNIX commands
running from SQL*Plus, 4-7
UNIX environment variables used with Oracle8
ADA_PATH, 2-11
DISPLAY, 2-11
HOME, 2-11
LANG, 2-11
LD_LIBRARY_PATH, 2-11
LDOPTS, 2-11
LDPATH, 2-11
LPDEST, 2-11
PATH, 2-11
PRINTER, 2-12
SHELL, 2-12
TERM, 2-12
TMPDIR, 2-12
XENVIRONMENT, 2-12
UNIX kernel
tuning, 3-8
user interrupt handler, 5-12
user profile
SQL*Plus, 4-2
user programs
oracle call interface, 5-7
Pro*C/C++, 5-5
users
sample script, 2-30
using SQL*Plus, 4-6
utlbstat and utlestat SQL scripts, 3-3

V

vmstat, 3-2
vmstat command, 3-4

W

writer activity
tuning, 3-5

X

X Windows, 2-11, 2-12
XA functionality, 5-14
XENVIRONMENT
environment variable, 2-12


Prev
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents