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, 6.3.1

ADD LOGFILE MEMBER clause

ALTER DATABASE statement, 6.3.2

ADD PARTITION clause, 17.4.2.1

ADD SUBPARTITION clause, 17.4.2.4.2, 17.4.2.5.2

adding

templates to a disk group, 12.4.10.1

ADMIN_TABLES procedure

creating admin table, 21.3.1.1

DBMS_REPAIR package, 21.2.1

example, 21.4.1.1, 21.4.1.2

ADMINISTER_RESOURCE_MANAGER system privilege, 24.2

administering

disk groups, 12.4

the Scheduler, 28

administration

distributed databases, 30

AFTER SUSPEND system event, 14.4.4.1

AFTER SUSPEND trigger, 14.4.4.1

example of registering, 14.4.6

agent

Heterogeneous Services, definition of, 29.1.2

aggregate functions

statement transparency in distributed databases, 30.7

alert log

about, 4.7.2

location of, 4.7.2.2

size of, 4.7.2.3

using, 4.7.2

when written, 4.7.2.4

alert thresholds

setting for locally managed tablespaces, 14.1.1

alerts

server-generated, 4.7.1

threshold-based, 4.7.1

viewing, 14.1.2

aliases

dropping from a disk group, 12.4.9

aliases, managing Automatic Storage Management, 12.4.8

ALL_DB_LINKS view, 30.5.1, 30.5.1

allocation

extents, 15.6.4

ALTER CLUSTER statement

ALLOCATE EXTENT clause, 18.4

using for hash clusters, 19.4

using for index clusters, 18.4

ALTER DATABASE ADD LOGFILE statement

using Oracle-managed files, 11.3.6.1

ALTER DATABASE statement

ADD LOGFILE clause, 6.3.1

ADD LOGFILE MEMBER clause, 6.3.2

ARCHIVELOG clause, 7.3.2

CLEAR LOGFILE clause, 6.8

CLEAR UNARCHIVED LOGFILE clause, 6.2.1.1

database partially available to users, 3.2.1

DATAFILE...OFFLINE DROP clause, 9.4.2

datafiles online or offline, 9.4.3

default temporary tablespace, specifying, 2.3.6

DROP LOGFILE clause, 6.5.1

DROP LOGFILE MEMBER clause, 6.5.2

MOUNT clause, 3.2.1

NOARCHIVELOG clause, 7.3.2

OPEN clause, 3.2.2

READ ONLY clause, 3.2.3

RENAME FILE clause, 9.5.2

tempfiles online or offline, 9.4.3

UNRECOVERABLE DATAFILE clause, 6.8

ALTER DISKGROUP command, 12.4.3

ALTER FUNCTION statement

COMPILE clause, 13.7.3

ALTER INDEX statement

COALESCE clause, 16.2.10

for maintaining partitioned indexes, 17.4

MONITORING USAGE clause, 16.4.3

ALTER PACKAGE statement

COMPILE clause, 13.7.4

ALTER PROCEDURE statement

COMPILE clause, 13.7.3

ALTER SEQUENCE statement, 20.2.3

ALTER SESSION

Enabling resumable space allocation, 14.4.2.2

ALTER SESSION statement

ADVISE clause, 33.4.3.3

CLOSE DATABASE LINK clause, 31.2

SET SQL_TRACE initialization parameter, 4.7.2.4

setting time zone, 2.3.9.1

ALTER SYSTEM statement

ARCHIVE LOG ALL clause, 7.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, 24.6

QUIESCE RESTRICTED, 3.4.1

RESUME clause, 3.5

SCOPE clause for SET, 2.7.5.1

SET RESOURCE_MANAGER_PLAN, 24.6

SET SHARED_SERVERS initialization parameter, 4.2.2.2

setting initialization parameters, 2.7.5

SUSPEND clause, 3.5

SWITCH LOGFILE clause, 6.6

UNQUIESCE, 3.4.2

ALTER TABLE

MODIFY DEFAULT ATTRIBUTES FOR PARTITION clause, 17.4.7.2, 17.4.7.3

ALTER TABLE statement

ADD (column) clause, 15.6.6

ALLOCATE EXTENT clause, 15.6.4

DEALLOCATE UNUSED clause, 15.6.4

DISABLE ALL TRIGGERS clause, 13.4.2

DISABLE integrity constraint clause, 13.5.3.1

DROP COLUMN clause, 15.6.8.1

DROP integrity constraint clause, 13.5.3.3

DROP UNUSED COLUMNS clause, 15.6.8.2

ENABLE ALL TRIGGERS clause, 13.4.1

ENABLE integrity constraint clause, 13.5.3.1, 13.5.3.1

external tables, 15.13.2

for maintaining partitions, 17.4

MODIFY (column) clause, 15.6.5

MODIFY DEFAULT ATTRIBUTES clause, 17.4.7.1

modifying index-organized table attributes, 15.12.3.1

MOVE clause, 15.6.3, 15.6.3, 15.12.3.2

reasons for use, 15.6.1

RENAME COLUMN clause, 15.6.7

SET UNUSED clause, 15.6.8.2

ALTER TABLESPACE statement

adding an Oracle-managed datafile, example, 11.3.3.3

adding an Oracle-managed tempfile, example, 11.3.4.2

ONLINE clause, example, 8.5.2

READ ONLY clause, 8.6.1

READ WRITE clause, 8.6.2

RENAME DATAFILE clause, 9.5.1.1

RENAME TO clause, 8.7

taking datafiles/tempfiles online/offline, 9.4.3

ALTER TRIGGER statement

DISABLE clause, 13.4.2

ENABLE clause, 13.4.1

ALTER VIEW statement

COMPILE clause, 13.7.2

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, 16.4, 16.4.2

ANALYZE statement

CASCADE clause, 13.2.2

corruption reporting, 21.3.1.3

listing chained rows, 13.2.3

remote tables, 31.4.2.2.2

validating structure, 13.2.2, 21.3.1

analyzing schema objects, 13.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.8.2

defining, 2.8

deploying, 2.8.1

using, 2.8.3

using, client side, 2.8.3.1

using, server side, 2.8.3.2

archive log files

creating in Automatic Storage Management, 12.5.9

ARCHIVE_LAG_TARGET initialization parameter, 6.2.5.1

archived redo logs

archiving modes, 7.3.2

destination availability state, controlling, 7.4.2

destination status, 7.4.2

destinations, specifying, 7.4

failed destinations and, 7.6

mandatory destinations, 7.6.1.1

minimum number of destinations, 7.6.1

multiplexing, 7.4.1

normal transmission of, 7.5

re-archiving to failed destination, 7.6.2

sample destination scenarios, 7.6.1.2

standby transmission of, 7.5

status information, 7.8.1

transmitting, 7.5

ARCHIVELOG mode, 7.2.2

advantages, 7.2.2

archiving, 7.2

automatic archiving in, 7.2.2

definition of, 7.2.2

distributed databases, 7.2.2

enabling, 7.3.2

manual archiving in, 7.2.2

running in, 7.2.2

switching to, 7.3.2

taking datafiles offline and online in, 9.4.1

archiver process

trace output (controlling), 7.7

archiver process (ARCn), 4.3

archiving

changing archiving mode, 7.3.2

controlling number of processes, 7.3.4

destination availability state, controlling, 7.4.2

destination failure, 7.6

destination status, 7.4.2

manual, 7.3.3, 7.3.3

NOARCHIVELOG vs. ARCHIVELOG mode, 7.2

setting initial mode, 7.3.1

to failed destinations, 7.6.2

trace output, controlling, 7.7

viewing information on, 7.8.1

ASM

see Automatic Storage Management

ASM_DISKGROUPS, 12.3.3.1

ASM_DISKSTRING, 12.3.3.1

ASM_POWER_LIMIT, 12.3.3.1

ASMLib, 12.3.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, 23.3

AUTOEXTEND clause

for bigfile tablespaces, 8.2.2.2

automatic segment space management, 8.2.1.2

Automatic Storage Management

accessing files with the XML DB virtual folder, 12.7

administering, 12.3

aliases, 12.4.8

authentication, 12.3.2

creating a database in, 12.5.5

creating archive log files in, 12.5.9

creating control file in, 12.5.8

creating files in the database, 12.5.4

creating redo logs in, 12.5.7

creating tablespaces in, 12.5.6

disk discovery, 12.2, 12.3.4.3

disk failures in, 12.4.1.4

filenames, 12.5.2

initialization files and, 3.1.2

initialization parameters, 12.3.3, 12.3.3.1

installation tips, 12.3.1

installing, 12.3.1

migrating a database to, 12.6

operating system authentication for, 12.3.2.1

overview, 12.1

overview of components, 12.2

password file authentication for, 12.3.2.2

shutting down, 12.3.5

starting up, 12.3.4

using in database, 12.5

views, 12.8

XML DB virtual folder, 12.7

automatic undo management, 2.3.4, 10.2

B

background processes, 4.3

FMON, 9.9.2.1.1

BACKGROUND_DUMP_DEST initialization parameter, 4.7.2.2

backups

after creating new databases, 2.2.2.11

effects of archiving on, 7.2.1

batch jobs, authenticating users in, 2.9.3

bigfile tablespaces

creating, 8.2.2.1

creating temporary, 8.2.3.2

description, 8.2.2

setting database default, 2.3.8.1

BLANK_TRIMMING initialization parameter, 15.6.5

BLOCKSIZE clause

of CREATE TABLESPACE, 8.3

BUFFER_POOL parameter

description, 14.3.1

buffers

buffer cache in SGA, 2.4.5.4.1

C

CACHE option

CREATE SEQUENCE statement, 20.2.4.2.2

caches

sequence numbers, 20.2.4.2

calendaring expressions, 27.4.5.1

calls

remote procedure, 29.5.2

capacity planning

space management

capacity planning, 14.8

capacity, managing in disk groups, 12.4.1.6

CASCADE clause

when dropping unique or primary keys, 13.5.3.1

CATBLOCK.SQL script, 4.7.3

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, 13.2.3.2

CHAINED_ROWS table

used by ANALYZE statement, 13.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.13

overview, 26.2.5

running, 27.9.8

stalled, 27.9.13

using, 27.9

change vectors, 6.1.2

CHAR datatype

increasing column length, 15.6.5

character set

choosing, 2.2.1.1

CHECK_OBJECT procedure

DBMS_REPAIR package, 21.2.1

example, 21.4.2

finding extent of corruption, 21.3.2

checkpoint process (CKPT), 4.3

checksums

for data blocks, 9.7

redo log blocks, 6.7, 6.7

CLEAR LOGFILE clause

ALTER DATABASE statement, 6.8, 6.8

clearing redo log files, 6.2.1.1, 6.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, 18.1

allocating extents, 18.4

altering, 18.4

analyzing, 13.2

cluster indexes, 18.5

cluster keys, 18.1, 18.2.2, 18.2.3

clustered tables, 18.1, 18.2.1, 18.3.1, 18.4.1, 18.5.1

columns for cluster key, 18.2.2

creating, 18.3

deallocating extents, 18.4

dropping, 18.5

estimating space, 18.2.3, 18.2.5

guidelines for managing, 18.2, 18.2.5

hash clusters, 19

location, 18.2.4

privileges, 18.3, 18.4, 18.5.1

selecting tables, 18.2.1

single-table hash clusters, 19.3.2

sorted hash, 19.3.1

truncating, 13.3

validating structure, 13.2.2

COALESCE PARTITION clause, 17.4.3.1

coalescing indexes

costs, 16.2.10

collocated inline views

tuning distributed queries, 31.4.1

column encryption, 2.9.2

columns

adding, 15.6.6

displaying information about, 15.14

dropping, 15.6.8, 15.6.8.3

increasing length, 15.6.5

modifying definition, 15.6.5

renaming, 15.6.7

COMMENT statement, 15.14

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

composite partitioning

default partition, 17.2.5

range-hash, 17.2.4, 17.3.4

range-list, 17.2.5, 17.3.5

subpartition template, modifying, 17.4.11

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

connection qualifiers

database links and, 30.2.4

connections

terminating remote, 31.2

constraints

D

data

loading using external tables, 15.13.1

data block corruption

repairing, 21.1

data blocks

altering size of, 2.4.4.1

managing space in, 14.2

nonstandard block size, 2.4.4.2

shared in clusters, 18.1

specifying size of, 2.4.4

standard block size, 2.4.4

transaction entry settings, 14.2.1

verifying, 9.7

data dictionary

conflicts with control files, 5.4.1

purging pending rows from, 33.6, 33.6.2

schema object views, 13.10, 14.7

data encryption

distributed systems, 29.3.2.5

data manipulation language

statements allowed in distributed transactions, 29.4.1

database

cloning, 1.2.11

monitoring, 4.7

starting up, 3.1

database administrators

DBA role, 1.5.2.3

operating system account, 1.5.1

password files for, 1.6.2.1

responsibilities of, 1.1.1

security and privileges of, 1.5

security officer versus, 22.1

SYS and SYSTEM accounts, 1.5.2

task definitions, 1.2

utilities for, 1.8.2

Database Configuration Assistant, 2.1

shared server configuration, 4.2.3

database links

advantages, 29.2.3

auditing, 29.3.3

authentication, 29.3.2.1

authentication without passwords, 29.3.2.2

closing, 30.4.1, 31.2

connected user, 29.2.7, 29.2.7.1, 30.2.3.2, 30.8.3

connections, determining open, 30.5.2

controlling connections, 31.2

creating, 30.2, 30.8.1, 30.8.3, 30.8.4, 30.8.5

creating shared, 30.3.2

creating, examples, 29.2.8

creating, scenarios, 30.8

current user, 29.2.7, 29.2.7.3, 30.2.3.2

data dictionary USER views, 30.5.1

definition, 29.2.1

distributed queries, 29.4.2

distributed transactions, 29.4.5

dropping, 30.4.2, 30.4.2

enforcing global naming, 30.1.2

enterprise users and, 29.3.2.4.2

fixed user, 29.2.7, 29.2.7.2, 30.8.1

global, 29.2.6

global names, 29.2.4

global object names, 29.4.7

handling errors, 31.3

limiting number of connections, 30.4.3

listing, 30.5.1, 33.3.1, 33.3.2

managing, 30.4

minimizing network connections, 30.3

name resolution, 29.4.7

names for, 29.2.5

private, 29.2.6

public, 29.2.6

referential integrity in, 31.3

remote transactions, 29.4.1, 29.4.4

resolution, 29.4.7

restrictions, 29.2.10

roles on remote database, 29.2.10

schema objects and, 29.2.9

service names used within link names, 30.2.4

shared, 29.2.2, 30.3.1, 30.3.3, 30.3.3.1, 30.3.3.2

shared SQL, 29.4.3

synonyms for schema objects, 29.2.9.3

tuning distributed queries, 31.4

tuning queries with hints, 31.4.3

tuning using collocated inline views, 31.4.1

types of links, 29.2.6

types of users, 29.2.7

users, specifying, 30.2.3

using cost-based optimization, 31.4.2

viewing, 30.5, 30.5.1

database objects

obtaining growth trends for, 14.8.3

Database Resource Manager

active session pool with queuing, 24.1.4.4.2

administering system privilege, 24.2

and operating system control, 24.9

automatic consumer group switching, 24.1.4.4.4

CREATE_SIMPLE_PLAN procedure, 24.3

description, 24.1

enabling, 24.6

execution time limit, 24.1.4.4.6

pending area, 24.4.1

resource allocation methods, 24.1.3, 24.4.2, 24.4.2, 24.4.2, 24.4.2, 24.4.2, 24.4.2, 24.4.2, 24.4.3

resource consumer groups, 24.1.3, 24.4.3, 24.5

resource plan directives, 24.1.3, 24.4.1.2, 24.4.4

resource plans, 24.1.3, 24.1.4.1, 24.1.4.2, 24.1.4.2, 24.1.4.2, 24.1.4.4.1, 24.3, 24.4.3, 24.6, 24.6, 24.7, 24.7.3, 24.10

specifying a parallel degree limit, 24.1.4.4.3

undo pool, 24.1.4.4.7

used for quiescing a database, 3.4

validating plan schema changes, 24.4.1.2

views, 24.10

database writer process

calculating checksums for data blocks, 9.7

database writer process (DBWn), 4.3

DATABASE_PROPERTIES view

name of default temporary tablespace, 2.3.6

rename of default temporary tablespace, 8.7

databases

administering, 1

administration of distributed, 30

altering availability, 3.2

backing up, 2.2.2.11

control files of, 5.2

creating manually, 2.2

default temporary tablespace, specifying, 2.3.6

dropping, 2.6

global database names in distributed systems, 2.4.1.2

mounting a database, 3.1.4.3

mounting to an instance, 3.2.1

names, about, 2.4.1.1

names, conflicts in, 2.4.1.1

opening a closed database, 3.2.2

planning, 1.2.3

planning creation, 2.2.1

quiescing, 3.4

read-only, opening, 3.2.3

recovery, 3.1.4.6

renaming, 5.3.3.1, 5.3.3.2, 5.3.3.3

restricting access, 3.2.4

resuming, 3.5

shutting down, 3.3

specifying control files, 2.4.3

starting up, 3.1.2

suspending, 3.5

troubleshooting creation problems, 2.5

undo management, 2.3.4

upgrading, 2.1

with locally managed tablespaces, 2.3.2

datafile headers

when renaming tablespaces, 8.7

datafiles

adding to a tablespace, 9.2

bringing online and offline, 9.4

checking associated tablespaces, 8.13.2

copying using database, 9.8

creating, 9.2

creating Oracle-managed files, 11.3, 11.3.6.2

database administrators access, 1.5.1

default directory, 9.2

definition, 9.1

deleting, 8.8

dropping, 9.4.2, 9.6

dropping Oracle-managed files, 11.4.1

file numbers, 9.1

fully specifying filenames, 9.2

guidelines for managing, 9.1

headers when renaming tablespaces, 8.7

identifying OS filenames, 9.5.1.2

location, 9.1.3

mapping files to physical devices, 9.9

minimum number of, 9.1.1

MISSING, 5.4.1

monitoring using views, 9.10

online, 9.4.2

Oracle-managed, 11

relocating, 9.5

renaming, 9.5

reusing, 9.2

size of, 9.1.2

statements to create, 9.2

storing separately from redo log files, 9.1.4

unavailable when database is opened, 3.1.4

verifying data blocks, 9.7

DB_BLOCK_CHECKING initialization parameter, 21.3.1, 21.3.1.4

DB_BLOCK_CHECKSUM initialization parameter, 9.7

enabling redo block checking with, 6.7

DB_BLOCK_SIZE initialization parameter

and nonstandard block sizes, 8.3

setting, 2.4.4

DB_CACHE_SIZE initialization parameter

setting, 2.4.5.4.1

specifying multiple block sizes, 8.3

DB_DOMAIN initialization parameter

setting for database creation, 2.4.1, 2.4.1.2

DB_FILES initialization parameter

determining value for, 9.1.1.1

DB_NAME initialization parameter

setting before database creation, 2.4.1

DB_nK_CACHE_SIZE initialization parameter

setting, 2.4.5.4.1

specifying multiple block sizes, 8.3

using with transportable tablespaces, 8.12.5.5

DBA role, 1.5.2.3

DBA. See database administrators.

DBA_2PC_NEIGHBORS view, 33.3.2

using to trace session tree, 33.3.2

DBA_2PC_PENDING view, 33.3.1, 33.6, 33.7.6

using to list in-doubt transactions, 33.3.1

DBA_DB_LINKS view, 30.5.1, 30.5.1, 30.5.1

DBA_RESUMABLE view, 14.4.4.1

DBA_UNDO_EXTENTS view

undo tablespace extents, 10.7

DBCA. See Database Configuration Assistant

DBMS_FILE_TRANSFER package

copying datafiles, 9.7

DBMS_METADATA package

GET_DDL function, 13.10.1

using for object definition, 13.10.1

DBMS_REDEFINITION package

performing online redefinition with, 15.7.2

required privileges, 15.7.9

DBMS_REPAIR

logical corruptions, 21.3.2

DBMS_REPAIR package

examples, 21.4

limitations, 21.2.2

procedures, 21.2.1

using, 21.3, 21.4.5

DBMS_RESOURCE_MANAGER package, 24.1.4, 24.2, 24.5, 24.5.2

procedures (table of), 24.2

DBMS_RESOURCE_MANAGER_PRIVS package, 24.2, 24.5

procedures (table of), 24.2

DBMS_RESUMABLE package, 14.4.4.3

DBMS_SERVER_ALERT package

setting alert thresholds, 14.1

DBMS_SESSION package, 24.5.2.3

DBMS_SPACE package, 14.5.4

example for unused space, 14.7.1

FREE_BLOCK procedure, 14.7.1

SPACE_USAGE procedure, 14.7.1

UNUSED_SPACE procedure, 14.7.1

DBMS_STATS package, 13.2.1

MONITORING clause of CREATE TABLE, 15.5

DBMS_STORAGE_MAP package

invoking for file mapping, 9.9.3.1

views detailing mapping information, 9.9.3.3

DBMS_TRANSACTION package

PURGE_LOST_DB_ENTRY procedure, 33.6.1

DBVERIFY utility, 21.3.1, 21.3.1.2

DEALLOCATE UNUSED clause, 14.5.4

deallocating unused space, 14.5

DBMS_SPACE package, 14.5.4

DEALLOCATE UNUSED clause, 14.5.4

declarative referential integrity constraints, 31.3

dedicated server processes, 4.1.1

trace files for, 4.7.2

DEFAULT keyword

list partitioning, 17.3.3

default partitions, 17.2.3

default subpartition, 17.2.5

default temporary tablespace

renaming, 8.7

default temporary tablespaces

specifying at database creation, 2.2.2.7, 2.3.6

specifying bigfile tempfile, 2.3.8.2

DEFAULT_CONSUMER_GROUP for Database Resource Manager, 24.4.3, 24.4.3.3, 24.5.3.2

defining

chain steps, 27.9.3

dependencies

between schema objects, 13.7

displaying, 13.10.2.2

dictionary-managed tablespaces

migrating SYSTEM to locally managed, 8.11

Digital POLYCENTER Manager on NetView, 29.3.4.3

directories

managing disk group, 12.4.7

direct-path INSERT

benefits, 15.4.2.1

how it works, 15.4.2.3

index maintenance, 15.4.2.5.1

locking considerations, 15.4.2.5.3

logging mode, 15.4.2.4

parallel INSERT, 15.4.2.2

parallel load compared with parallel INSERT, 15.4.2.1, 15.4.2.1

serial INSERT, 15.4.2.2

space considerations, 15.4.2.5.2

DISABLE ROW MOVEMENT clause, 17.3

disabling

chains, 27.9.10

jobs, 27.2.8

programs, 27.3.5

window groups, 27.7.7

windows, 27.6.7

disabling recoverer process, 33.9.2

disk discovery

in Automatic Storage Management, 12.2, 12.3.4.3

disk failure

in Automatic Storage Management, 12.4.1.4

disk group

adding templates to, 12.4.10.1

altering membership of, 12.4.3

creating, 12.4.2

dropping, 12.4.6

dropping disks from, 12.4.3.2

managing capacity in, 12.4.1.6

manually rebalancing, 12.4.3.5

mounting and dismounting, 12.4.4

resizing disks in, 12.4.3.3

undropping disks in, 12.4.3.4

disk groups, administering, 12.4

dispatcher process (Dnnn), 4.3

dispatcher processes, 4.2.3.3, 4.2.4

DISPATCHERS initialization parameter

setting attributes of, 4.2.3.1

setting initially, 4.2.3.3

distributed applications

distributing data, 31.1

distributed databases

administration overview, 29.3

application development, 29.5, 31, 31.5

client/server architectures, 29.1.3

commit point strength, 32.2.5.2

cost-based optimization, 29.5.3

direct and indirect connections, 29.1.3

distributed processing, 29.1.1.1

distributed queries, 29.4.2

distributed updates, 29.4.2, 29.4.2

forming global database names, 30.1.1

global object names, 29.2.9.4, 30.1

globalization support, 29.6

location transparency, 29.5.1.1, 30.6

management tools, 29.3.4

managing read consistency, 33.10

nodes of, 29.1.3

overview, 29.1.1

remote object security, 30.6.1

remote queries and updates, 29.4.1

replicated databases and, 29.1.1.2

resumable space allocation, 14.4.1.4

running in ARCHIVELOG mode, 7.2.2

running in NOARCHIVELOG mode, 7.2.2

scenarios, 30.8

schema object name resolution, 29.4.8

schema-dependent global users, 29.3.2.4.1

schema-independent global users, 29.3.2.4.2

security, 29.3.2

site autonomy of, 29.3.1

SQL transparency, 29.5.1.2

starting a remote instance, 3.1.4.8

transaction processing, 29.4

transparency, 29.5.1

distributed processing

distributed databases, 29.1.1.1

distributed queries, 29.4.2

analyzing tables, 31.4.2.2.2

application development issues, 31.4

cost-based optimization, 31.4.2

optimizing, 29.5.3

distributed systems

data encryption, 29.3.2.5

distributed transactions, 29.4.5

case study, 32.5

commit point site, 32.2.5

commit point strength, 32.2.5.2, 33.1

committing, 32.2.5.1

database server role, 32.2.2

defined, 32.1

DML and DDL, 32.1.1

failure during, 33.8.1

global coordinator, 32.2.4

local coordinator, 32.2.3

lock timeout interval, 33.8

locked resources, 33.8

locks for in-doubt, 33.8.2

manually overriding in-doubt, 33.4.2

naming, 33.2, 33.4.3.2

session trees, 32.2, 32.2.2, 32.2.3, 32.2.4, 32.2.5, 33.3.2

setting advice, 33.4.3.3

transaction control statements, 32.1.2

transaction timeouts, 33.8.1

two-phase commit, 32.5, 33.4.1

viewing database links, 33.3.1

distributed updates, 29.4.2

DML error logging, inserting data with, 15.4.1

DML. See data manipulation language

DRIVING_SITE hint, 31.4.3.2

DROP CLUSTER statement

CASCADE CONSTRAINTS clause, 18.5

dropping cluster, 18.5

dropping cluster index, 18.5

dropping hash cluster, 19.5

INCLUDING TABLES clause, 18.5

DROP DATABASE statement, 2.6

DROP LOGFILE clause

ALTER DATABASE statement, 6.5.1

DROP LOGFILE MEMBER clause

ALTER DATABASE statement, 6.5.2

DROP PARTITION clause, 17.4.4.1

DROP SYNONYM statement, 20.3.4

DROP TABLE statement

about, 15.10

CASCADE CONSTRAINTS clause, 15.10

for clustered tables, 18.5.1

DROP TABLESPACE statement, 8.8

dropping

aliases from a disk group, 12.4.9

Automatic Storage Management template, 12.4.10.3

chain steps, 27.9.11

chains, 27.9.7

datafiles, 9.6

disk groups, 12.4.6

disks from a disk group, 12.4.3.2

files from a disk group, 12.4.9

job classes, 27.5.4

jobs, 27.2.7, 28.2.8

programs, 27.3.4

rules from chains, 27.9.9

running jobs, 28.2.9

schedules, 27.4.4

tempfiles, 9.6

window groups, 27.7.3

windows, 27.6.6

dropping columns from tables, 15.6.8.1

marking unused, 15.6.8.2

remove unused columns, 15.6.8.2

dropping database links, 30.4.2, 30.4.2

dropping datafiles

Oracle-managed, 11.4.1

dropping partitioned tables, 17.5

dropping tables

CASCADE clause, 15.10

consequences of, 15.10

dropping tempfiles

Oracle-managed, 11.4.1

DUMP_ORPHAN_KEYS procedure, 21.3.2

checking sync, 21.3.2

DBMS_REPAIR package, 21.2.1

example, 21.4.4

recovering data, 21.3.4.1

E

EMPHASIS resource allocation method, 24.4.2

ENABLE ROW MOVEMENT clause, 17.3, 17.3.1.1

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, transparent data, 2.9.2

enterprise users

definition, 29.3.2.4.2

environment variables

selecting an instance with, 1.3

error logging, DML

inserting data with, 15.4.1

errors

alert log and, 4.7.2

assigning names with PRAGMA_EXCEPTION_INIT, 31.5

exception handler, 31.5

integrity constrain violation, 31.3

ORA-00028, 4.6.2

ORA-01090, 3.3

ORA-01173, 5.4.2

ORA-01176, 5.4.2

ORA-01177, 5.4.2

ORA-01578, 9.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, 5.4.2

ORA-1216, 5.4.2

RAISE_APPLICATION_ERROR() procedure, 31.5

remote procedure, 31.5

rollback required, 31.3

trace files and, 4.7.2

when creating a database, 2.5

when creating control file, 5.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, 13.5.5

user-defined, 31.5

EXCHANGE PARTITION clause, 17.4.5.1, 17.4.5.3, 17.4.5.4, 17.4.5.5, 17.4.6

execution plans

analyzing for distributed queries, 31.4.4

export operations

restricted mode and, 3.1.4.4

export utilities

about, 1.8.2.2

expressions, calendaring, 27.4.5.1

EXTENT MANAGEMENT LOCAL clause

CREATE DATABASE, 2.3.2

extents

allocating cluster extents, 18.4

allocating for tables, 15.6.4

data dictionary views for, 14.7.2

deallocating cluster extents, 18.4

displaying free extents, 14.7.2.3

external jobs

running, 27.2.5.4

external procedures

managing processes for, 4.5

external tables

altering, 15.13.2

creating, 15.13.1

defined, 15.13

dropping, 15.13.3

privileges required, 15.13.4

uploading data example, 15.13.1

F

failure groups, 12.2, 12.4.1.5

features

new, Preface

file mapping

examples, 9.9.4

how it works, 9.9.2

how to use, 9.9.3

overview, 9.9.1

structures, 9.9.2.2

views, 9.9.3.3

file system

used for Oracle-managed files, 11.1.1.2

FILE_MAPPING initialization parameter, 9.9.3.1

filenames

Automatic Storage Management, 12.5.2

Oracle-managed files, 11.3.1

files

creating Oracle-managed files, 11.3, 11.3.6.2

FIX_CORRUPT_BLOCKS procedure

DBMS_REPAIR, 21.2.1

example, 21.4.3

marking blocks corrupt, 21.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.4.2

Flashback Drop

about, 15.11

purging recycle bin, 15.11.4

querying recycle bin, 15.11.3

recycle bin, 15.11.1

restoring objects, 15.11.5

Flashback Table

overview, 15.9

Flashback Transaction Query, 15.8

FMON background process, 9.9.2.1.1

FMPUTL external process

used for file mapping, 9.9.2.1.2

FOR PARTITION clause, 17.4.8.1

FORCE clause

COMMIT statement, 33.5

ROLLBACK statement, 33.5

FORCE LOGGING clause

CREATE CONTROLFILE, 2.3.10.1

CREATE DATABASE, 2.3.10

CREATE TABLESPACE, 8.4

performance considerations, 2.3.10.2

FORCE LOGGING mode, 15.4.2.4

forcing

COMMIT or ROLLBACK, 33.3.1, 33.4.2

forcing a log switch, 6.6

using ARCHIVE_LAG_TARGET, 6.2.5

with the ALTER SYSTEM statement, 6.6

forget phase

in two-phase commit, 32.3.3

free space

listing free extents, 14.7.2.3

tablespaces and, 8.13.3

function-based indexes, 16.3.7

functions

recompiling, 13.7.3

G

generic connectivity

definition, 29.1.2.3

global cache service (LMS), 4.3

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, 14.8.3

GV$DBLINK view, 30.5.2

H

hash clusters

advantages and disadvantages, 19.1

altering, 19.4

choosing key, 19.3.3.1

contrasted with index clusters, 19.1

controlling space use of, 19.3.3

creating, 19.3

dropping, 19.5

estimating storage, 19.3.4

examples, 19.3.3.5.1

hash function, 19.1, 19.2.2, 19.3, 19.3.3.1, 19.3.3.2, 19.3.3.3

HASH IS clause, 19.3, 19.3.3.2

HASHKEYS clause, 19.3, 19.3.3.4

single-table, 19.3.2

SIZE clause, 19.3.3.3

sorted, 19.3.1

hash functions

for hash cluster, 19.1

hash partitioning

creating tables using, 17.3.2

index-organized tables, 17.3.10.2, 17.3.10.3

multicolumn partitioning keys, 17.3.7

heterogeneous distributed systems

definition, 29.1.2

Heterogeneous Services

overview, 29.1.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

historical tables

moving time window, 17.6

HP OpenView, 29.3.4.3

I

IBM NetView/6000, 29.3.4.3

import operations

restricted mode and, 3.1.4.4

import utilities

about, 1.8.2.2

index clusters. See clusters.

indexes

altering, 16.4

analyzing, 13.2

choosing columns to index, 16.2.2

cluster indexes, 18.3.2, 18.4.1, 18.5

coalescing, 16.2.10, 16.4.2

column order for performance, 16.2.3

creating, 16.3

disabling and dropping constraints cost, 16.2.11

dropping, 16.2.5, 16.6, 16.6

estimating size, 16.2.6

estimating space use, 14.8.2

explicitly creating a unique index, 16.3.2

function-based, 16.3.7

guidelines for managing, 16.1

keeping when disabling constraint, 13.5.3

keeping when dropping constraint, 13.5.3

key compression, 16.3.8

limiting for a table, 16.2.4

monitoring space use of, 16.5

monitoring usage, 16.4.3

parallelizing index creation, 16.2.8

partitioned, 17.1

rebuilding, 16.2.10, 16.4.2, 16.4.2

rebuilt after direct-path INSERT, 15.4.2.5.1

setting storage parameters for, 16.2.6

shrinking, 14.5.3

space used by, 16.5

statement for creating, 16.3.1

tablespace for, 16.2.7

temporary segments and, 16.2.1

updating global indexes, 17.4.1

validating structure, 13.2.2

when to create, 16.2.2

index-organized tables

analyzing, 15.12.5

AS subquery, 15.12.2.6

converting to heap, 15.12.7

creating, 15.12.2

described, 15.12.1

INCLUDING clause, 15.12.2.5

key compression, 15.12.2.7</