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

A

abort response, 32.3.1.1.3

two-phase commit, 32.3.1.1.3

accounts

DBA operating system account, 1.5.1

users SYS and SYSTEM, 1.5.2

ADD LOGFILE clause

ALTER DATABASE statement, 10.3.1

ADD LOGFILE MEMBER clause

ALTER DATABASE statement, 10.3.2

adding

columns, 18.6.6

columns in compressed tables, 18.6.6.1

ADMIN_TABLES procedure

creating admin table, 23.3.1.1

DBMS_REPAIR package, 23.2.1

example, 23.4.1.1, 23.4.1.2

ADMINISTER_RESOURCE_MANAGER system privilege, 25.1.5

administering

the Scheduler, 28

administration

distributed databases, 30

ADR

See automatic diagnostic repository

ADR base, 8.1.4

ADR home, 8.1.4

ADRCI utility, 8.1.3.6

Advisor

Data Repair, 8.1.1

Undo, 14.4

AFTER SUSPEND system event, 17.4.4.1

AFTER SUSPEND trigger, 17.4.4.1

example of registering, 17.4.6

agent

Heterogeneous Services, definition of, 29.1.2

aggregate functions

statement transparency in distributed databases, 30.7

alert log, 8.1.3.2

about, 7.1.1

size of, 7.1.1.1

using, 7.1.1

when written, 7.1.1.2

alert thresholds

setting for locally managed tablespaces, 17.1.1

alerts

server-generated, 7.1.2

threshold-based, 7.1.2

viewing, 17.1.2

ALL_DB_LINKS view, 30.5.1, 30.5.1

allocation

extents, 18.6.4

ALTER CLUSTER statement

ALLOCATE EXTENT clause, 20.4

using for hash clusters, 21.4

using for index clusters, 20.4

ALTER DATABASE ADD LOGFILE statement

using Oracle-managed files, 15.3.6.1

ALTER DATABASE statement

ADD LOGFILE clause, 10.3.1

ADD LOGFILE MEMBER clause, 10.3.2

ARCHIVELOG clause, 11.3.2

CLEAR LOGFILE clause, 10.8

CLEAR UNARCHIVED LOGFILE clause, 10.2.1.1

database partially available to users, 3.2.1

DATAFILE...OFFLINE DROP clause, 13.4.2

datafiles online or offline, 13.4.3

DROP LOGFILE clause, 10.5.1

DROP LOGFILE MEMBER clause, 10.5.2

MOUNT clause, 3.2.1

NOARCHIVELOG clause, 11.3.2

OPEN clause, 3.2.2

READ ONLY clause, 3.2.3

RENAME FILE clause, 13.5.2

tempfiles online or offline, 13.4.3

UNRECOVERABLE DATAFILE clause, 10.8

ALTER INDEX statement

COALESCE clause, 19.2.10

MONITORING USAGE clause, 19.4.4

ALTER SEQUENCE statement, 22.2.3

ALTER SESSION

Enabling resumable space allocation, 17.4.2.2

ALTER SESSION statement

ADVISE clause, 33.4.3.3

CLOSE DATABASE LINK clause, 31.2

SET SQL_TRACE initialization parameter, 7.1.1.2

setting time zone, 2.4.9.1

ALTER SYSTEM statement

ARCHIVE LOG ALL clause, 11.3.3

DISABLE DISTRIBUTED RECOVERY clause, 33.9.2

ENABLE DISTRIBUTED RECOVERY clause, 33.9.2

ENABLE RESTRICTED SESSION clause, 3.2.4

enabling Database Resource Manager, 25.5

QUIESCE RESTRICTED, 3.4.1

RESUME clause, 3.5

SCOPE clause for SET, 2.8.6.1

SET RESOURCE_MANAGER_PLAN, 25.5

SET SHARED_SERVERS initialization parameter, 4.3.2.2

setting initialization parameters, 2.8.6

SUSPEND clause, 3.5

SWITCH LOGFILE clause, 10.6

UNQUIESCE, 3.4.2

ALTER TABLE ADD COLUMN command, Preface

ALTER TABLE statement

ADD (column) clause, 18.6.6

ALLOCATE EXTENT clause, 18.6.4

DEALLOCATE UNUSED clause, 18.6.4

DISABLE ALL TRIGGERS clause, 16.4.2

DISABLE integrity constraint clause, 16.5.3.1

DROP COLUMN clause, 18.6.8.1

DROP integrity constraint clause, 16.5.3.3

DROP UNUSED COLUMNS clause, 18.6.8.2

ENABLE ALL TRIGGERS clause, 16.4.1

ENABLE integrity constraint clause, 16.5.3.1, 16.5.3.1

external tables, 18.13.2

MODIFY (column) clause, 18.6.5

modifying index-organized table attributes, 18.12.3.1

MOVE clause, 18.6.3, 18.6.3, 18.12.3.2

reasons for use, 18.6.1

RENAME COLUMN clause, 18.6.7

SET UNUSED clause, 18.6.8.2

ALTER TABLESPACE statement

adding an Oracle-managed datafile, example, 15.3.3.3

adding an Oracle-managed tempfile, example, 15.3.4.2

ONLINE clause, example, 12.5.2

READ ONLY clause, 12.6.1

READ WRITE clause, 12.6.2

RENAME DATAFILE clause, 13.5.1.1

RENAME TO clause, 12.8

taking datafiles/tempfiles online/offline, 13.4.3

ALTER TRIGGER statement

DISABLE clause, 16.4.2

ENABLE clause, 16.4.1

altering

(Scheduler) windows, 27.6.3

chain steps, 27.9.12

event schedule, 27.8.2.4

event-based job, 27.8.2.2

job classes, 27.5.3

jobs, 27.2.4

programs, 27.3.3

schedules, 27.4.3

altering indexes, 19.4, 19.4.2

ANALYZE statement

CASCADE clause, 16.2.2

CASCADE clause, FAST option, 16.2.2

corruption reporting, 23.3.1.3

listing chained rows, 16.2.3

remote tables, 31.4.2.2.2

validating structure, 16.2.2, 23.3.1

analyzing schema objects, 16.2

analyzing tables

distributed processing, 31.4.2.2.2

application development

distributed databases, 29.5, 31, 31.5

application development for distributed databases, 31

analyzing execution plan, 31.4.4

database links, controlling connections, 31.2

handling errors, 31.3, 31.5

handling remote procedure errors, 31.5

managing distribution of data, 31.1

managing referential integrity constraints, 31.3

terminating remote connections, 31.2

tuning distributed queries, 31.4

tuning using collocated inline views, 31.4.1

using cost-based optimization, 31.4.2

using hints to tune queries, 31.4.3

application services

configuring, 2.9.2

defining, 2.9

deploying, 2.9.1

using, 2.9.3

using, client side, 2.9.3.1

using, server side, 2.9.3.2

ARCHIVE_LAG_TARGET initialization parameter, 10.2.5.1

archived redo logs

archiving modes, 11.3.2

data dictionary views, 11.8.1

destination availability state, controlling, 11.4.2

destination status, 11.4.2

destinations, specifying, 11.4

failed destinations and, 11.6

mandatory destinations, 11.6.1.1

minimum number of destinations, 11.6.1

multiplexing, 11.4.1

normal transmission of, 11.5

re-archiving to failed destination, 11.6.2

sample destination scenarios, 11.6.1.2

standby transmission of, 11.5

status information, 11.8.1

transmitting, 11.5

ARCHIVELOG mode, 11.2.2

advantages, 11.2.2

archiving, 11.2

automatic archiving in, 11.2.2

definition of, 11.2.2

distributed databases, 11.2.2

enabling, 11.3.2

manual archiving in, 11.2.2

running in, 11.2.2

switching to, 11.3.2

taking datafiles offline and online in, 13.4.1

archiver process

trace output (controlling), 11.7

archiver process (ARCn), 4.5

archiving

changing archiving mode, 11.3.2

controlling number of processes, 11.3.4

destination availability state, controlling, 11.4.2

destination failure, 11.6

destination status, 11.4.2

manual, 11.3.3, 11.3.3

NOARCHIVELOG vs. ARCHIVELOG mode, 11.2

setting initial mode, 11.3.1

to failed destinations, 11.6.2

trace output, controlling, 11.7

viewing information on, 11.8.1

auditing

database links, 29.3.3

authentication

database links, 29.3.2.1

operating system, 1.6.3.2

selecting a method, 1.6.2

using password file, 1.6.4.1

AUTO_TASK_CONSUMER_GROUP

of Resource Manager, 24.5

AUTOEXTEND clause

for bigfile tablespaces, 12.7.2

automatic diagnostic repository, 8.1.1, 8.1.3.1

structure, contents and location of, 8.1.4

Automatic Maintenance Tasks

assigning to maintenance windows, 24.3.2

definition, 24.1

enabling and disabling, 24.3.1

predefined, 24.1

resource allocation, 24.5.1

Automatic maintenance tasks

Scheduler job names, 24.2

automatic memory management, 5.1

about, 5.3.1

enabling, 5.3.2

supported platforms, 5.5.1

automatic segment space management, 12.2.1.2

Automatic Storage Management

initialization files and, 3.1.2

automatic undo management, 2.4.4, 14.2, 14.2

migrating to, 14.6

B

background processes, 4.5

FMON, 13.9.2.1.1

BACKGROUND_DUMP_DEST initialization parameter, 8.1.3.1

backups

after creating new databases, 2.3.13

effects of archiving on, 11.2.1

batch jobs, authenticating users in, 2.10.3

bigfile tablespaces

creating, 12.2.2.1

creating temporary, 12.2.4.2

description, 12.2.2

setting database default, 2.4.8.1

BLANK_TRIMMING initialization parameter, 18.6.5

BLOB datatype, 18.3.1

BLOCKSIZE clause

of CREATE TABLESPACE, 12.3

buffer caches

extended buffer cache (32-bit), 5.4.2.8.3

multiple buffer pools, 5.4.2.2.2

buffer pools, 5.4.2.2.2

BUFFER_POOL parameter

description, 17.3.1

BUFFER_POOL_KEEP initialization parameter, 5.4.2.2.2

BUFFER_POOL_RECYCLE initialization parameter, 5.4.2.2.2

buffers

buffer cache in SGA, 5.4.2.2

C

CACHE option

CREATE SEQUENCE statement, 22.2.4.2.2

caches

buffer

multiple buffer pools, 5.4.2.2.2

sequence numbers, 22.2.4.2

calendaring expressions, 27.4.5.1

calls

remote procedure, 29.5.2

capacity planning

space management

capacity planning, 17.8

CASCADE clause

when dropping unique or primary keys, 16.5.3.1

CATBLOCK.SQL script, 7.2.1

centralized user management

distributed systems, 29.3.2.4

chain rules, 27.9.4

chain steps

defining, 27.9.3

chained rows

eliminating from table, procedure, 16.2.3.2

CHAINED_ROWS table

used by ANALYZE statement, 16.2.3.1

chains

creating, 27.9.2

creating jobs for, 27.9.6

disabling, 27.9.10

dropping, 27.9.7

dropping rules from, 27.9.9

enabling, 27.9.5

monitoring, 28.2.5

overview, 26.2.5

running, 27.9.8

setting privileges, 28.1

stalled, 27.9.13

using, 27.9

change vectors, 10.1.2

CHAR datatype

increasing column length, 18.6.5

character set

choosing, 2.1.1.1

CHECK_OBJECT procedure

DBMS_REPAIR package, 23.2.1

example, 23.4.2

finding extent of corruption, 23.3.2

checkpoint process (CKPT), 4.5

checksums

for data blocks, 13.7

redo log blocks, 10.7, 10.7

CLEAR LOGFILE clause

ALTER DATABASE statement, 10.8, 10.8

clearing redo log files, 10.2.1.1, 10.8

client/server architectures

distributed databases, 29.1.3, 29.1.3

globalization support, 29.6.1

cloning

a database, 1.2.11

an Oracle home, 1.2.11

CLOSE DATABASE LINK clause

ALTER SESSION statement, 31.2

closing database links, 30.4.1

closing windows, 27.6.5

clusters

about, 20.1

allocating extents, 20.4

altering, 20.4

analyzing, 16.2

cluster indexes, 20.5

cluster keys, 20.1, 20.2.2, 20.2.3

clustered tables, 20.1, 20.2.1, 20.3.1, 20.4.1, 20.5.1

columns for cluster key, 20.2.2

creating, 20.3

data dictionary views reference, 20.6

deallocating extents, 20.4

dropping, 20.5

estimating space, 20.2.3, 20.2.5

guidelines for managing, 20.2, 20.2.5

hash clusters, 21

location, 20.2.4

privileges, 20.3, 20.4, 20.5.1

selecting tables, 20.2.1

single-table hash clusters, 21.3.2

sorted hash, 21.3.1

truncating, 16.3

validating structure, 16.2.2

coalescing indexes

costs, 19.2.10

collocated inline views

tuning distributed queries, 31.4.1

column encryption, 2.10.2

columns

adding, 18.6.6

adding to compressed table, 18.6.6.1

displaying information about, 18.14

dropping, 18.6.8, 18.6.8.3

dropping in compressed tables, 18.6.8.4

encrypted, 18.2.7, 18.6.3

increasing length, 18.6.5

modifying definition, 18.6.5

renaming, 18.6.7

virtual, 18.1

virtual, indexing, 19.2.2

commands

submitting, 1.3

COMMENT statement, 18.14

comments

adding to problem activity log, 8.2.7

COMMIT COMMENT statement

used with distributed transactions, 33.2, 33.4.3.2

commit phase, 32.3.1, 32.5.4

in two-phase commit, 32.3.2, 32.3.2.2

commit point site, 32.2.5

commit point strength, 32.2.5.2, 33.1

determining, 32.2.5.2

distributed transactions, 32.2.5, 32.2.5.2

how the database determines, 32.2.5.2

commit point strength

definition, 32.2.5.2

specifying, 33.1

COMMIT statement

FORCE clause, 33.5, 33.5.1.1, 33.5.2

forcing, 33.4.2

two-phase commit and, 29.4.6

COMMIT_POINT_STRENGTH initialization parameter, 32.2.5.2, 33.1

committing transactions

commit point site for distributed transactions, 32.2.5

compressed tables

adding a column, 18.6.6.1

dropping columns in, 18.6.8.4

compression, table, 18.2.6

configuring

Oracle Scheduler, 28.1

CONNECT command

starting an instance, 3.1.3

CONNECT INTERNAL

desupported, 1.6.2

connected user database links, 30.2.3.2

advantages and disadvantages, 29.2.7.1

definition, 29.2.7

example, 29.2.8

REMOTE_OS_AUTHENT initialization parameter, 29.2.7.1

connecting

with SQL*Plus, 1.3.2

connection qualifiers

database links and, 30.2.4

connections

terminating remote, 31.2

constraints

D

data

loading using external tables, 18.13.1

data block corruption

repairing, 23.1

data blocks

altering size of, 2.5.4.1

managing space in, 17.2

nonstandard block size, 2.5.4.2

shared in clusters, 20.1

specifying size of, 2.5.4

standard block size, 2.5.4

transaction entry settings, 17.2.1

verifying, 13.7

data dictionary

conflicts with control files, 9.4.1

purging pending rows from, 33.6, 33.6.2

E

EMPHASIS resource allocation method, 25.3.4

enabling

chains, 27.9.5

jobs, 27.2.9

programs, 27.3.6

window groups, 27.7.6

windows, 27.6.8

enabling recoverer process

distributed transactions, 33.9.2

encryption

column, 18.2.7

tablespace, 12.2.3

encryption, transparent data, 2.10.2

enterprise users

definition, 29.3.2.4.2

environment variables

ORACLE_SID, 2.3.1

error logging, DML

inserting data with, 18.4.1

errors

alert log and, 7.1.1

assigning names with PRAGMA_EXCEPTION_INIT, 31.5

critical, 8.1.1

exception handler, 31.5

integrity constrain violation, 31.3

ORA-00028, 4.8.2

ORA-01090, 3.3

ORA-01173, 9.4.2

ORA-01176, 9.4.2

ORA-01177, 9.4.2

ORA-01578, 13.7

ORA-01591, 33.8.2

ORA-02049, 33.8.1

ORA-02050, 33.4.1

ORA-02051, 33.4.1

ORA-02054, 33.4.1

ORA-1215, 9.4.2

ORA-1216, 9.4.2

RAISE_APPLICATION_ERROR() procedure, 31.5

remote procedure, 31.5

rollback required, 31.3

trace files and, 7.1.1

when creating a database, 2.6

when creating control file, 9.4.2

while starting a database, 3.1.4.5

while starting an instance, 3.1.4.5

event message

passing to event-based job, 27.8.2.5

event schedule

altering, 27.8.2.4

creating, 27.8.2.3

event-based job

altering, 27.8.2.2

creating, 27.8.2.1

passing event messages to, 27.8.2.5

events (Scheduler)

overview, 26.2.4

using, 27.8

exception handler, 31.5

EXCEPTION keyword, 31.5

exceptions

assigning names with PRAGMA_EXCEPTION_INIT, 31.5

integrity constraints, 16.5.5

user-defined, 31.5

executing

remote external jobs, 28.3

execution plans

analyzing for distributed queries, 31.4.4

export operations

restricted mode and, 3.1.4.4

expressions, calendaring, 27.4.5.1

EXTENT MANAGEMENT LOCAL clause

CREATE DATABASE, 2.4.2

extents

allocating cluster extents, 20.4

allocating for tables, 18.6.4

data dictionary views for, 17.7.2

deallocating cluster extents, 20.4

displaying free extents, 17.7.2.3

external jobs, 26.3.4

capturing standard error output for, 27.2.5.4

creating remote, 27.2.2.4

external procedures

managing processes for, 4.7

external tables

altering, 18.13.2

creating, 18.13.1

defined, 18.13

dropping, 18.13.3

privileges required, 18.13.4

uploading data example, 18.13.1

F

fault diagnosability infrastructure, 8.1.1

features

new, Preface

features, new, Preface

file mapping

examples, 13.9.4

how it works, 13.9.2

how to use, 13.9.3

overview, 13.9.1

structures, 13.9.2.2

views, 13.9.3.3

file system

used for Oracle-managed files, 15.1.1.2

FILE_MAPPING initialization parameter, 13.9.3.1

filenames

Oracle-managed files, 15.3.1

files

creating Oracle-managed files, 15.3, 15.3.6.2

finalizing

an incident package, definition, 8.10.1.1

FIX_CORRUPT_BLOCKS procedure

DBMS_REPAIR, 23.2.1

example, 23.4.3

marking blocks corrupt, 23.3.3.1

fixed user database links

advantages and disadvantages, 29.2.7.2

creating, 30.2.3.1

definition, 29.2.7

example, 29.2.8

flash recovery area

initialization parameters to specify, 2.5.2

with Oracle managed files, 15.2

Flashback Drop

about, 18.11

purging recycle bin, 18.11.4

querying recycle bin, 18.11.3

recycle bin, 18.11.1

restoring objects, 18.11.5

Flashback Table

overview, 18.9

flood-controlled incidents

defined, 8.1.2

viewing, 8.3

FMON background process, 13.9.2.1.1

FMPUTL external process

used for file mapping, 13.9.2.1.2

FORCE clause

COMMIT statement, 33.5

ROLLBACK statement, 33.5

FORCE LOGGING clause

CREATE CONTROLFILE, 2.4.10.1

CREATE DATABASE, 2.4.10

CREATE TABLESPACE, 12.4

performance considerations, 2.4.10.2

FORCE LOGGING mode, 18.4.2.4

forcing

COMMIT or ROLLBACK, 33.3.1, 33.4.2

forcing a log switch, 10.6

using ARCHIVE_LAG_TARGET, 10.2.5

with the ALTER SYSTEM statement, 10.6

forget phase

in two-phase commit, 32.3.3

free space

listing free extents, 17.7.2.3

tablespaces and, 12.14.3

function-based indexes, 19.3.7

G

generic connectivity

definition, 29.1.2.3

global cache service (LMS), 4.5

global coordinators, 32.2.4

distributed transactions, 32.2.4

global database consistency

distributed databases and, 32.3.2.2

global database links, 29.2.6

creating, 30.2.2.3

global database names

changing the domain, 30.1.4

database links, 29.2.4

enforcing for database links, 29.2.5

enforcing global naming, 30.1.2

forming distributed database names, 30.1.1

impact of changing, 29.4.9.1

querying, 30.1.3

global object names

database links, 29.4.7

distributed databases, 30.1

global users, 30.8.5

schema-dependent in distributed systems, 29.3.2.4.1

schema-independent in distributed systems, 29.3.2.4.2

GLOBAL_NAME view

using to determine global database name, 30.1.3

GLOBAL_NAMES initialization parameter

database links, 29.2.5

globalization support

client/server architectures, 29.6.1

distributed databases, 29.6

GRANT statement

SYSOPER/SYSDBA privileges, 1.7.3.1

granting privileges and roles

SYSOPER/SYSDBA privileges, 1.7.3.1

growth trends

of database objects, 17.8.3

GV$DBLINK view, 30.5.2

H

hash clusters

advantages and disadvantages, 21.1

altering, 21.4

choosing key, 21.3.3.1

contrasted with index clusters, 21.1

controlling space use of, 21.3.3

creating, 21.3

data dictionary views reference, 21.6

dropping, 21.5

estimating storage, 21.3.4

examples, 21.3.3.5.1

hash function, 21.1, 21.2.2, 21.3, 21.3.3.1, 21.3.3.2, 21.3.3.3

HASH IS clause, 21.3, 21.3.3.2

HASHKEYS clause, 21.3, 21.3.3.4

single-table, 21.3.2

SIZE clause, 21.3.3.3

sorted, 21.3.1

hash functions

for hash cluster, 21.1

health checks, 8.1.1

Health Monitor, 8.7

checks, 8.7.1.1

generating reports, 8.7.3

running, 8.7.2

viewing reports, 8.7.3

viewing reports using ADRCI, 8.7.3.3

heterogeneous distributed systems

definition, 29.1.2

Heterogeneous Services

overview, 29.1.2

HI_SHARED_MEMORY_ADDRESS parameter, 5.4.2.8.2

hints, 31.4.3

DRIVING_SITE, 31.4.3.2

NO_MERGE, 31.4.3.1

using to tune distributed queries, 31.4.3

HP OpenView, 29.3.4.3

I

IBM NetView/6000, 29.3.4.3

import operations

restricted mode and, 3.1.4.4

incident package

creating, editing and uploading custom, 8.10

customizing, 8.10.3, 8.10.3.2

defined, 8.1.1

viewing, 8.10.3.1

incident packaging service, 8.1.1

incidents

about, 8.1.2

flood-controlled, 8.1.2

viewing,