Oracle9<i>i</i> Administrator's Reference -- Index

Ada, 9-5

ADDRESS specification protocols, 11-3

administering SQL, 8-2

AGENT_START.COM, 10-25

ALTER DATABASE command, 6-4, 7-2

ALTER SYSTEM command, 3-5

ALTER TABLESPACE command, 6-3

ANO, 10-30

de-installation, 10-35

requirements, 10-31

with Oracle Names, 10-34

Appendices, 9

ARCH process, 7-4

ARCHIVELOG mode, 1-5

authentication, 10-31

usage notes, 10-37

authorization, 1-9

AUTHORIZE utility, 3-3

BACKGROUND_DUMP_DEST, 10-20

Backup procedures, 1-5

BEQ protocol, 11-4

Bequeath Adapter, 10-11

Bequeath Listener, 10-12

privileges, 10-15

problem resolution, 10-13

shutting down, 10-13

starting, 10-12

Binary integers, 9-15

block size

tuning, 2-4

Blocksize, 6-3

buffer manager, 2-3

Buffers

database buffer pool, 1-4

redo log buffers, 1-4

C Language

precompiling, 9-5

Centralized configuration, 10-3

checksumming, 10-30

Client-server configuration, 10-4

COBOL, 9-5, 9-16

Commands

ALTER DATABASE, 6-4

CONNECT INTERNAL, B-2

CREATE TABLE, 6-4

DROP TABLESPACE, 6-4

Communities

protocol-dependent groups, 10-8

Compiling with programmatic interfaces, 9-7

Configuration, 10-2

centralized, 10-3

client-server, 10-4

distributed, 10-4

configuration

encapsulator, 11-7

master agent, 11-6

configuration files

Net8, 11-2

Oracle Net, 11-2

precompiler, 9-2

CONNECT INTERNAL, B-2

CONTINUE command, C-2

Control files

creating, 6-3

identifying, 6-3

CPU usage

priority level of processes, 2-5

tuning, 2-4

CREATE CONTROLFILE parameters, 1-7

CREATE DATABASE parameters, 1-7

Database

automatic recovery, 7-12

granting access to, 3-3

opening in exclusive mode, 4-4

Database files

defined, 1-4

database files, 1-9

Database links

creating, 6-2

Database verification utility, 6-8

database verification utility, 6-8

Datafiles, 1-6

Datatypes, 9-15

DB_BLOCK_BUFFERS parameter, 1-4

DB_dbname directory, 6-3

DBSNMPJ.COM, 10-25

DEBUG qualifier, 9-6

Demo files

programmatic interfaces, 9-9

demonstration

the procedural option, PL/SQL, 1-16

demonstration tables

creating manually, 8-3

deleting, 8-3

SQL*Plus, 8-3

Detached processes, 7-12

identification, A-6

Discovery option, 10-25

disk

monitoring performance, 2-4

disk I/O

tuning, 2-4

distributed database, 10-4

Distributed database configuration, 10-4

documentation

accessing, xv

navigation files, xv

on administration and tuning, xvi

on migrating and upgrading from previous release, xvi

related, xvi

where installed, xv

DROP TABLESPACE command, 6-4

editor SQL*Plus, 8-5

encapsulator configuration, 11-7

encryption, 10-30

Errors

ORA-00921, 6-4

Ethernet, 10-2

event flags

restrictions, 9-6

Exclusive mode, 4-4

Export utility, 7-8

files

trace files, 2-5

FORTRAN, 9-5, 9-15

glogin.sql file, 8-2

help facility, 8-4

HOST

, 9-6

Import utility

for recovery, 7-14

INCLUDE option, 9-6

initialization parameters

BACKGROUND_DUMP_DEST, 2-6

BITMAP_MERGE_AREA_SIZE, 1-10

COMMIT_POINT_STRENGTH, 1-10

CONTROL_FILES, 1-10

CREATE_BITMAP_AREA_SIZE, 1-10

DB_BLOCK_BUFFERS, 1-10

DB_BLOCK_SIZE, 1-10

DB_FILE_DIRECT_IO_COUNT, 1-10

DB_FILE_MULTIBLOCK_READ_COUNT, 1-10

DISTRIBUTED_TRANSACTIONS, 1-10

HASH_AREA_SIZE, 1-10

HASH_MULTIBLOCK_IO_COUNT, 1-10

JAVA_POOL_SIZE, 1-10

LOG_BUFFER, 1-11

LOG_CHECKPOINT_INTERVAL, 1-11

MAX_DISPATCHERS, 1-11

MAX_DUMP_FILE, 2-6

MAX_SERVERS, 1-11

NLS_LANGUAGE, 1-11

NLS_TERRITORY, 1-11

OBJECT_CACHE_MAX_SIZE_PERCENT, 1-11

OBJECT_CACHE_OPTIMAL_SIZE, 1-11

OPEN_CURSORS, 1-11

OS_AUTHENT_PREFIX, 1-11

PROCESSES, 1-11

SHARED_POOL_SIZE, 1-11

SHARED_SERVERS, 1-11

SORT_AREA_SIZE, 1-11

USER_DUMP_DEST, 2-5

INIT.ORA file

location, A-5

INIT.ORA files

at start-up, 1-3

setting SGA size, 1-3

initsid.ora file, 1-9

INSORACLE.COM file

run as a batch job, 4-10

installation

Oracle Internet Directory, xvi

Oracle Workflow, xvi

Intelligent Agent

configuration on SNMP, 11-6

interrupting SQL*Plus, 8-6

I/O

improving, 1-3

tuning, 2-4

IPC protocol, 11-4

Kerberos5, 10-31

linker directives

with Oracle programming interfaces, 9-9

Linking

, 9-8

LOUTL.COM, 9-10

OCI routines, 9-12, 9-14

LISTENER.ORA, 10-9

LNOCIC.COM, 9-13

LNOCI.COM, 9-14

log writer process (LGWR), 2-5

LOG_BUFFER parameter, 1-4

LOG_CHECKPOINT_INTERVAL parameter, 1-5, 7-2

Logical names

alphabetical listing, A-3

command files that define, A-2

Logicals

identification, 1-6

using to specify files, 1-6

LOGIN.COM file

of ORACLE users, 3-2

LOGINOUT, C-3

login.sql file, 8-2

LRS

See Log roll-forward server (LRS), A-1, B-1, C-1

Mailbox Adapter, 10-9

Mailbox protocol adapter, 10-9

Managing Instances, 5-1

master agent configuration, 11-6

MAXDATAFILES parameter, 1-7

MAXINSTANCES parameter, 1-7

MAXLOGFILES parameter, 1-7

MAXLOGHISTORY parameter, 1-7

MAXLOGMEMBERS parameter, 1-7

memory

tuning, 2-3

memory management, 2-3

control paging, 2-3

swap space, 2-3

Multiple protocols

on single machine, 10-8

multithreaded servers, 10-3

Names Server

Oracle Names

introduction, 10-20

privileges, 10-21

namesctl, 10-20

NAMES.ORA, 10-23

Net8

ADDRESS specification, 11-3

BEQ protocol, 11-4

files and utilities, 11-2

IPC protocol, 11-4

oracle enterprise manager intelligent agent, 11-6

protocol support, 11-3

protocols, 11-3

TCP/IP protocol, 11-5

Net8 configuration files, 11-2

NMICONF.TCL, 10-25

NOARCHIVELOG mode, 1-5

OCI routines, 9-12, 9-14

options file

using for linker directives, 9-9

ORA_DUMP directory, 7-4

ORA_INSTALL logical name, A-4

ORA_LSNR, 10-18

ORA_SID logical, 4-5

default value, 1-2

ORA_USER.COM file, A-6

ORA-00921 error, 6-4

ORACLE call interface

OCI routines, 9-12

Oracle Enterprise Manager (OEM), 10-23

oracle enterprise manager intelligent agent, 11-6

Oracle Intelligent Agent, 10-24

maintenance, 10-29

shutdown, 10-28, 10-29

startup, 10-28

Oracle Names

with ANO, 10-34

Oracle Net

products and features, 11-2

Oracle Net configuration files, 11-2

ORACLE programmatic interfaces

compiling, 9-7

datatypes, 9-15

FORTRAN %REF directive, 9-15

HOST option, 9-6

linking, 9-8

LNOCIC.COM, 9-13

LNOCI.COM, 9-14

, 9-8

OCI routines, 9-12, 9-14

optional call parameters, 9-15

precompiling, 9-5

, 9-6

Oracle Protocol Adapters, 10-7

role in TNS network, 10-7

oracle software owner, 1-8

special accounts, 1-8

Oracle Text, D-1

Oracle7

granting access privileges, 3-3

linked as shared image, 1-2

logical names, A-2

relinking, 1-2

Spatial, D-1

ORACLE.EXE file

defined, 1-2

ORACLEINS

to shut down Oracle7, 4-13

ORACLEINS.COM file

logical assignments made, A-2

ORAMBX, 6-9

orapwd command, 1-11

orapwd utility, 1-11

ORAUSER_instance.COM file, 3-2

running for ORACLE users, 3-2

page-out activity, 2-4

paging, 2-3

paging space, 2-3

tuning, 2-3

Parallel Query, 5-4

Parameters

optional with programmatic interfaces, 9-15

Pascal, 9-5

password utility, 3-3

PEER master agent, 10-29

PL/I, 9-5

PL/SQL demonstrations

loading, 1-16

precompiler configuration files, 9-2

precompilers

overview, 9-2

Precompiling

guidelines and restrictions, 9-6

options, 9-6

syntax and example, 9-5

preferred credentials, 10-27

Privileges

and Process Rights Identifier, B-1

Process Rights Identifier, B-1

PRODUCT_USER_PROFILE Table, 8-3

Programmatic Interfaces

ORACLE programmatic interfaces, 9-4

Protocol Adapters, 10-7

Bequeath Adapter, 10-11

Mailbox Adapter, 10-9

TCP/IP Adapter, 10-10

Protocol API differences

TNS implementation, 10-8

Protocol implementations, 10-8

protocols, 11-3

ADDRESS specification, 11-3

Redo log file

mode of use, 7-2

Redo log files

default names for, 1-5

defining, 1-5

modes of, 1-5

moving, 6-6

reusing, 1-5

size of, 1-6