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

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

default temporary tablespace, specifying, 2.3.6

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.3.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.7.6.1

SET RESOURCE_MANAGER_PLAN, 25.5

SET SHARED_SERVERS initialization parameter, 4.3.2.2

setting initialization parameters, 2.7.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.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_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.3.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.2.2.11

effects of archiving on, 11.2.1

batch jobs, authenticating users in, 2.9.3

bigfile tablespaces

creating, 12.2.2.1

creating temporary, 12.2.4.2

description, 12.2.2

setting database default, 2.3.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.2.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.9.2

columns

adding, 18.6.6

displaying information about, 18.14

dropping, 18.6.8, 18.6.8.3

increasing length, 18.6.5

modifying definition, 18.6.5

renaming, 18.6.7

virtual, 18.1

virtual, indexing, 19.2.2

columns, encrypted, 18.6.3

colums, encrypted, 18.2.7

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

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

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.4.4.1

managing space in, 17.2

nonstandard block size, 2.4.4.2

shared in clusters, 20.1

specifying size of, 2.4.4

standard block size, 2.4.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.9.2

enterprise users

definition, 29.3.2.4.2

environment variables

selecting an instance with, 1.3

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.5

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.3.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.4.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

Flashback Transaction Query, 18.8

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.3.10.1

CREATE DATABASE, 2.3.10

CREATE TABLESPACE, 12.4

performance considerations, 2.3.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, 8.3

index clusters. See clusters.

indexes

altering, 19.4

analyzing, 16.2

choosing columns to index, 19.2.2

cluster indexes, 20.3.2, 20.4.1, 20.5

coalescing, 19.2.10, 19.4.2

column order for performance, 19.2.3

creating, 19.3

data dictionary views reference, 19.7

disabling and dropping constraints cost, 19.2.11

dropping, 19.2.5, 19.6, 19.6

estimating size, 19.2.6

estimating space use, 17.8.2

explicitly creating a unique index, 19.3.2

function-based, 19.3.7

guidelines for managing, 19.1

invisible, 19.3.9, 19.4.3

keeping when disabling constraint, 16.5.3

keeping when dropping constraint, 16.5.3

key compression, 19.3.8

limiting for a table, 19.2.4

monitoring space use of, 19.5

monitoring usage, 19.4.4

parallelizing index creation, 19.2.8

rebuilding, 19.2.10, 19.4.2, 19.4.2

rebuilt after direct-path INSERT, 18.4.2.5.1

setting storage parameters for, 19.2.6

shrinking, 17.5.3

space used by, 19.5

statement for creating, 19.3.1

tablespace for, 19.2.7

temporary segments and, 19.2.1

validating structure, 16.2.2

when to create, 19.2.2

index-organized tables

analyzing, 18.12.5

AS subquery, 18.12.2.6

converting to heap, 18.12.7

creating, 18.12.2

described, 18.12.1

INCLUDING clause, 18.12.2.5

key compression, 18.12.2.7

maintaining, 18.12.3

ORDER BY clause, using, 18.12.6

overflow clause, 18.12.2.3

parallel creation, 18.12.2.6

rebuilding with MOVE clause, 18.12.3.2

storing nested tables, 18.12.2.2

storing object types, 18.12.2.2

threshold value, 18.12.2.4

in-doubt transactions, 32.4

after a system failure, 33.4.1

automatic resolution, 32.4.1, 32.4.1.1

deciding how to handle, 33.4

deciding whether to perform manual override, 33.4.2

defined, 32.3.1.2

manual resolution, 32.4.2

manually committing, 33.5.1

manually committing, example, 33.7

manually overriding, 33.4.2, 33.5

manually overriding, scenario, 33.7

manually rolling back, 33.5.2

overview, 32.4

pending transactions table, 33.7.6

purging rows from data dictionary, 33.6, 33.6.2

recoverer process and, 33.9.2

rolling back, 33.5, 33.5.1.1, 33.5.2, 33.5.2

SCNs and, 32.4.3

simulating, 33.9

tracing session tree, 33.3.2

viewing database links, 33.3.1

INITIAL parameter

cannot alter, 17.3.7, 18.6.2

description, 17.3.1

initialization parameter file

and Automatic Storage Management, 3.1.2

creating, 2.2.2.3

creating by copying and pasting from alert log, 2.7.10

creating for database creation, 2.2.2.3

editing before database creation, 2.4

individual parameter names, 2.4.1

server parameter file, 2.7

understanding, 3.1.2

initialization parameters

ARCHIVE_LAG_TARGET, 10.2.5.1

BUFFER_POOL_KEEP, 5.4.2.2.2

BUFFER_POOL_RECYCLE, 5.4.2.2.2

changing, 2.7.6.1

clearing, 2.7.7

COMMIT_POINT_STRENGTH, 32.2.5.2, 33.1

CONTROL_FILES, 2.4.3, 2.4.3, 2.4.3, 9.2.1, 9.3.1

DB_BLOCK_CHECKING, 23.3.1.4

DB_BLOCK_CHECKSUM, 10.7, 13.7

DB_BLOCK_SIZE, 2.4.4, 12.3

DB_CACHE_SIZE, 12.3

DB_DOMA, 2.4.1

DB_DOMAIN, 2.4.1.2

DB_FILES, 13.1.1.1

DB_NAME, 2.4.1

DB_nK_CACHE_SIZE, 12.3, 12.13.5.5

DISPATCHERS, 4.3.3.3

FILE_MAPPING, 13.9.3.1

for buffer cache, 5.4.2.2

GLOBAL_NAMES, 29.2.5

HI_SHARED_MEMORY_ADDRESS, 5.4.2.8.2

LOCK_SGA, 5.4.2.8.1

LOG_ARCHIVE_DEST, 11.4.1

LOG_ARCHIVE_DEST_n, 11.4.1, 11.6.2

LOG_ARCHIVE_DEST_STATE_n, 11.4.2

LOG_ARCHIVE_MAX_PROCESSES, 11.3.4

LOG_ARCHIVE_MIN_SUCCEED_DEST, 11.6.1

LOG_ARCHIVE_TRACE, 11.7

MAX_DUMP_FILE_SIZE, 7.1.1.1

OPEN_LINKS, 30.4.3

PROCESSES, 2.4.5

REMOTE_LOGIN_PASSWORDFILE, 1.7.2

REMOTE_OS_AUTHENT, 29.2.7.1

resetting, 2.7.7

RESOURCE_MANAGER_PLAN, 25.5, 25.5

server parameter file and, 2.7, 2.7.11

SET SQL_TRACE, 7.1.1.2

setting, 2.7.6.1

shared server and, 4.3.1

SHARED_MEMORY_ADDRESS, 5.4.2.8.2

SHARED_SERVERS, 4.3.2.2

SORT_AREA_SIZE, 19.2.1

SPFILE, 2.7.5, 3.1.2

SQL_TRACE, 7.1.1

STATISTICS_LEVEL, 18.5

UNDO_MANAGEMENT, 2.3.4

UNDO_TABLESPACE, 2.4.7.2, 14.2.1

USE_INDIRECT_DATA_BUFFERS, 5.4.2.8.3

INITRANS parameter

altering, 18.6.2

guidelines for setting, 17.2.1

INSERT statement

with DML error logging, 18.4.1

installing

patches, 1.2.10

instance

selecting with environment variables, 1.3

instances

aborting, 3.3.4

shutting down immediately, 3.3.2

shutting down normally, 3.3.1

transactional shutdown, 3.3.3

integrity constraints

J

job classes

altering, 27.5.3

creating, 27.5.2

dropping, 27.5.4

overview, 26.3.1

using, 27.5

job coordinator, 26.4.2

job recovery (Scheduler), 28.5.2

jobs

altering, 27.2.4

copying, 27.2.3

creating, 27.2.2

creating for chains, 27.9.6

disabling, 27.2.8

dropping, 27.2.7

enabling, 27.2.9

external, 26.3.4

failed Scheduler, 28.5.1

lightweight jobs, 26.2.3

overview, 26.2.3

priorities, 28.2.4

remote external

about, 26.3.4.3

creating, 27.2.2.4

running, 27.2.2.4

running, 27.2.5

stopping, 27.2.6

using, 27.2

viewing information on running, 28.2.2

join views

definition, 22.1.2.1

DELETE statements, 22.1.5.2.2

key-preserved tables in, 22.1.5.1

modifying, 22.1.5

rules for modifying, 22.1.5.2

updating, 22.1.5

joins

statement transparency in distributed databases, 30.7

K

key compression, 18.12.2.7

indexes, 19.3.8

key-preserved tables

in join views, 22.1.5.1

in outer joins, 22.1.5.3

keys

cluster, 20.1, 20.2.3

L

large objects, 18.3.1

lightweight jobs

example, 27.2.2.3.1

example of setting attributes, 28.6.6

examples, 27.2.2.3.3, 28.6.1

links

See database links

LIST CHAINED ROWS clause

of ANALYZE statement, 16.2.3.1

listing database links, 30.5.1, 33.3.1, 33.3.2

loading data

using external tables, 18.13.1

LOBs, 18.3.1

storage parameters for, 17.3.6

local coordinators, 32.2.3

distributed transactions, 32.2.3

locally managed tablepsaces

shrinking, temporary, 12.7.4

locally managed tablespaces, 12.2.1

automatic segment space management in, 12.2.1.2

DBMS_SPACE_ADMIN package, 12.11

detecting and repairing defects, 12.11

migrating SYSTEM from dictionary-managed, 12.12

tempfiles, 12.2.4.1

temporary, creating, 12.2.4.1

location transparency in distributed databases

creating using synonyms, 30.6.2

creating using views, 30.6.1

restrictions, 30.7

using procedures, 30.6.3.3

lock timeout interval

distributed transactions, 33.8

LOCK_SGA parameter, 5.4.2.8.1

locks

in-doubt distributed transactions, 33.8, 33.8.2

monitoring, 7.2.1

log

window (Scheduler), 27.6

log sequence number

control files, 10.1.3.2

log switches

description, 10.1.3.2

forcing, 10.6, 10.6

log sequence numbers, 10.1.3.2

multiplexed redo log files and, 10.2.1.1

privileges, 10.6

using ARCHIVE_LAG_TARGET, 10.2.5

waiting for archiving to complete, 10.2.1.1

log writer process (LGWR), 4.5

multiplexed redo log files and, 10.2.1.1

online redo logs available for use, 10.1.3

trace files and, 10.2.1.1

writing to online redo log files, 10.1.3

LOG_ARCHIVE_DEST initialization parameter

specifying destinations using, 11.4.1

LOG_ARCHIVE_DEST_n initialization parameter, 11.4.1

REOPEN attribute, 11.6.2

LOG_ARCHIVE_DEST_STATE_n initialization parameter, 11.4.2

LOG_ARCHIVE_DUPLEX_DEST initialization parameter

specifying destinations using, 11.4.1

LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 11.3.4

LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 11.6.1

LOG_ARCHIVE_TRACE initialization parameter, 11.7

LOGGING clause

CREATE TABLESPACE, 12.4

logging mode

direct-path INSERT, 18.4.2.4

NOARCHIVELOG mode and, 18.4.2.4.1

logical corruptions from DBMS_REPAIR, 23.3.2

logical volume managers

mapping files to physical devices, 13.9, 13.9.4.3

used for Oracle-managed files, 15.1.1.1

LOGON trigger

setting resumable mode, 17.4.3

logs

job, 28.2.3

window (Scheduler), 27.6, 28.2.3

LONG columns, 30.7

LONG RAW columns, 30.7

M

maintenance window

creating, 24.4.2

definition, 24.1

MAINTENANCE_WINDOW_GROUP, 24.2

modifying, 24.4.1

predefined, 24.6.1

removing, 24.4.3

maintenance windows

Scheduler, 24.2

managing

memory, 5

space threshold alerts for the undo tablespace, 14.5.6

managing datafiles, 13

managing sequences, 22.2.1

managing synonyms, 22.3.1

managing tables, 18

managing views, 22.1

manual archiving

in ARCHIVELOG mode, 11.3.3

manual overrides

in-doubt transactions, 33.5

MAX_DUMP_FILE_SIZE initialization parameter, 7.1.1.1

MAXDATAFILES parameter

changing, 9.3.3.2

MAXINSTANCES, 9.3.3.2

MAXLOGFILES parameter

changing, 9.3.3.2

CREATE DATABASE statement, 10.2.4

MAXLOGHISTORY parameter

changing, 9.3.3.2

MAXLOGMEMBERS parameter

changing, 9.3.3.2

CREATE DATABASE statement, 10.2.4, 10.2.4

MAXTRANS parameter

altering, 18.6.2

media recovery

effects of archiving on, 11.2.1

memory

extended buffer cache (32-bit), 5.4.2.8.3

managing, 5

overview of architecture of, 5.2

system global area (SGA)

initialization parameters, 5.4.2.8

locking into physical memory, 5.4.2.8.1

starting address, 5.4.2.8.2

memory management

about, 5.1

automatic, 5.1, 5.3.2

data dictionary views reference, 5.5.2

MEMORY_MAX_TARGET parameter, 5.3.1

MEMORY_TARGET parameter, 5.3.1

migrated rows

eliminating from table, procedure, 16.2.3.2

MINEXTENTS parameter

cannot alter, 17.3.7, 18.6.2

description, 17.3.1

mirrored files

control files, 2.4.3, 9.2.2

online redo log, 10.2.1.1

online redo log location, 10.2.2

online redo log size, 10.2.3

MISSING datafiles, 9.4.1

monitoring

chains, 28.2.5

performance, 7.2

MONITORING clause

CREATE TABLE, 18.5

MONITORING USAGE clause

of ALTER INDEX statement, 19.4.4

mounting a database, 3.1.4.3

moving control files, 9.3.2

multiple temporary tablespaces, 12.2.5, 12.2.5.3

multiplexed control files

importance of, 9.2.2

multiplexing

archived redo logs, 11.4.1

control files, 9.2.2

redo log file groups, 10.2.1

redo log files, 10.2.1, 10.2.1

N

name resolution in distributed databases

database links, 29.4.7

impact of global name changes, 29.4.9.1

procedures, 29.4.9

schema objects, 29.2.9.4, 29.4.8

synonyms, 29.4.9

views, 29.4.9

when global database name is complete, 29.4.7.1

when global database name is partial, 29.4.7.2

when no global database name is specified, 29.4.7.3

named user limits

setting initially, 2.4.9

nested tables

storage parameters for, 17.3.6

networks

connections, minimizing, 30.3

distributed databases use of, 29.1.1

new features, Preface

NEXT parameter

altering, 17.3.7, 18.6.2

NEXTVAL pseudo-column, 22.2.4.1, 22.2.4.1.1

restrictions, 22.2.4.1.3

NO_DATA_FOUND keyword, 31.5

NO_MERGE hint, 31.4.3.1

NOARCHIVELOG mode

archiving, 11.2

definition, 11.2.1

dropping datafiles, 13.4.2

LOGGING mode and, 18.4.2.4.1

media failure, 11.2.1

no hot backups, 11.2.1

running in, 11.2.1

switching to, 11.3.2

taking datafiles offline in, 13.4.2

NOCACHE option

CREATE SEQUENCE statement, 22.2.4.2.2

NOLOGGING clause

CREATE TABLESPACE, 12.4

NOLOGGING mode

direct-path INSERT, 18.4.2.4

NOMOUNT clause

STARTUP command, 3.1.4.2

normal transmission mode

definition, 11.5.1

Novell NetWare Management System, 29.3.4.3

O

object privileges

for external tables, 18.13.4

objects

P

package

Q

queries

distributed, 29.4.2

distributed application development issues, 31.4

location transparency and, 29.5.1.2

remote, 29.4.1

quiescing a database, 3.4

quotas

tablespace, 12.1.2

R

RAISE_APPLICATION_ERROR() procedure, 31.5

read consistency

managing in distributed databases, 33.10

read-only database

opening, 3.2.3

read-only response

two-phase commit, 32.3.1.1.2

read-only tables, 18.6.9

read-only tablespaces

datafile headers when rename, 12.8

delaying opening of datafiles, 12.6.4

making read-only, 12.6.1

making writable, 12.6.2

WORM devices, 12.6.3

Real Application Clusters

allocating extents for cluster, 20.4

sequence numbers and, 22.2.2

threads of online redo log, 10.1.1

rebuilding indexes, 19.4.2

costs, 19.2.10

online, 19.4.2

reclaiming unused space, 17.5

RECOVER clause

STARTUP command, 3.1.4.6

recoverer process

disabling, 33.9.2

distributed transaction recovery, 33.9.2

enabling, 33.9.2

pending transaction table, 33.9.2

recoverer process (RECO), 4.5

recovering

Scheduler jobs, 28.5.2

recovery

creating new control files, 9.3.3.2

Recovery Manager

starting a database, 3.1.1.2

starting an instance, 3.1.1.2

recycle bin

about, 18.11.1

purging, 18.11.4

renamed objects, 18.11.1

restoring objects from, 18.11.5

viewing, 18.11.3

redefining tables online

See online redefinition of tables

redo log files

S

Sample Schemas

description, 2.9.4

savepoints

in-doubt transactions, 33.5, 33.5.2

Scheduler

administering, 28

architecture, 26.4

configuring, 28.1

credentials for remote external jobs, 26.3.4.1

data dictionary views reference, 28.7.2

examples of using, 28.6

import and export, 28.4

maintenance windows, 24.2

monitoring and managing, 28.2

overview, 26.1

security, 28.2.6

support for Oracle Data Guard, 26.3.5, 28.6.9

using, 27

using in RAC, 26.4.5

Scheduler agent

defined, 26.3.4.3

scheduler agent

setup, 28.3.2

Scheduler objects, naming, 27.1

Scheduler privileges reference, 28.7.1

Scheduler privileges, setting, 28.1

schedules

altering, 27.4.3

creating, 27.4.2

dropping, 27.4.4

overview, 26.2.2

using, 27.4

schema objects

analyzing, 16.2

creating multiple objects, 16.1

data dictionary views reference, 16.10.2

defining using DBMS_METADATA package, 16.10.1

dependencies between, 16.7

distributed database naming conventions for, 29.2.9.4

global names, 29.2.9.4

listing by type, 16.10.2.1

name resolution in distributed databases, 29.2.9.4, 29.4.8

name resolution in SQL statements, 16.8

privileges to rename, 16.6

referencing with synonyms, 30.6.2.1

renaming, 16.6, 16.6

validating structure, 16.2.2

viewing information, 16.10, 17.7

schema objects space usage

data dictionary views reference, 17.7.2

SCN. See system change number.

SCOPE clause

ALTER SYSTEM SET, 2.7.6.1

scripts, authenticating users in, 2.9.3

SEC_CASE_SENSITIVE_LOGON initialization parameter, 1.6.2, 1.6.4.1

security

accessing a database, 6.1

administrator of, 6.1

centralized user management in distributed databases, 29.3.2.4

database security, 6.1

distributed databases, 29.3.2

establishing policies, 6

privileges, 6.1

remote objects, 30.6.1

Scheduler, 28.2.6

using synonyms, 30.6.2.2

Segment Advisor, 17.5.2

configuring Scheduler job, 17.5.2.4

invoking with Enterprise Manager, 17.5.2.2.1

invoking with PL/SQL, 17.5.2.2.2

running manually, 17.5.2.2

viewing results, 17.5.2.3

views, 17.5.2.5

SEGMENT_FIX_STATUS procedure

DBMS_REPAIR, 23.2.1

segments

available space, 17.7.1

data dictionary views for, 17.7.2

deallocating unused space, 17.5

displaying information on, 17.7.2.1

shrinking, 17.5.3

storage parameters for temporary, 17.3.8

SELECT statement

FOR UPDATE clause and location transparency, 30.7

selecting an instance with environment variables, 1.3

SEQUENCE_CACHE_ENTRIES parameter, 22.2.4.2.2

sequences

accessing, 22.2.4

altering, 22.2.3

caching sequence numbers, 22.2.4.2

creating, 22.2.2, 22.2.4.2.2, 22.2.4.2.2

CURRVAL, 22.2.4.1.2

data dictionary views reference, 22.4

dropping, 22.2.5

managing, 22.2.1

NEXTVAL, 22.2.4.1.1

Oracle Real Applications Clusters and, 22.2.2

SERVER parameter

net service name, 30.3.3.1

server parameter file

and Automatic Storage Management, 3.1.2

creating, 2.7.3

defined, 2.7.1

exporting, 2.7.8

migrating to, 2.7.2

recovering, 2.7.10

RMAN backup, 2.7.9

setting initialization parameter values, 2.7.6

SPFILE initialization parameter, 2.7.5

STARTUP command behavior, 2.7.1

viewing parameter settings, 2.7.11

server processes

archiver (ARCn), 4.5

background, 4.5

checkpoint (CKPT), 4.5

database writer (DBWn), 4.5

dedicated, 4.1.1

dispatcher (Dnnn), 4.5

dispatchers, 4.3.3.3

global cache service (LMS), 4.5

log writer (LGWR), 4.5

monitoring locks, 7.2.1

process monitor (PMON), 4.5

recoverer (RECO), 4.5

shared server, 4.1.2

system monitor (SMON), 4.5

trace files for, 7.1.1

server-generated alerts, 7.1.2

servers

role in two-phase commit, 32.2.2

service names

database links and, 30.2.4

services

application, 2.8

application, configuring, 2.8.2

application, deploying, 2.8.1

application, using, 2.8.3

session trees for distributed transactions

clients, 32.2.1

commit point site, 32.2.5, 32.2.5.2

database servers, 32.2.2

definition, 32.2

global coordinators, 32.2.4

local coordinators, 32.2.3

tracing transactions, 33.3.2

sessions

active, 4.8.2

inactive, 4.8.3

setting advice for transactions, 33.4.3.3

terminating, 4.8

SET TIME_ZONE clause

ALTER SESSION, 2.3.9.1

CREATE DATABASE, 2.3.9.1

SET TRANSACTION statement

naming transactions, 33.2

setting

Scheduler privileges, 28.1

SGA

T

tables

about, 18.1

adding columns, Preface, 18.6.6

allocating extents, 18.6.4

altering, 18.6.1

altering physical attributes, 18.6.2

analyzing, 16.2

clustered (hash). See hash clusters

compressed, 18.2.6

creating, 18.3

data dictionary views reference, 18.14

designing before creating, 18.2.1

dropping, 18.10

dropping columns, 18.6.8

estimating size, 18.2.8

estimating space use, 17.8.1

external, 18.13

Flashback Drop, 18.11

Flashback Table, 18.9

Flashback Transaction Query, 18.8

guidelines for managing, 18.2

hash clustered. See hash clusters

increasing column length, 18.6.5

index-organized, 18.12

key-preserved, 22.1.5.1

limiting indexes on, 19.2.4

managing, 18

modifying column definition, 18.6.5

moving, 18.6.3

parallelizing creation, 18.2.4, 18.3.3

read-only, 18.6.9

redefining online, 18.7

renaming columns, 18.6.7

restrictions when creating, 18.2.9

setting storage parameters, 18.2.8

shrinking, 17.5.3

specifying location, 18.2.3

statistics collection, automatic, 18.5

temporary, 18.3.2

truncating, 16.3

unrecoverable (NOLOGGING), 18.2.5

validating structure, 16.2.2

tablespace set, 12.13.5.2

tablespaces

adding datafiles, 13.2

assigning user quotas, 12.1.2

automatic segment space management, 12.2.1.2

bigfile, 2.3.8, 12.2.2

checking default storage parameters, 12.14.1

containing XMLTypes, 12.13.3

creating undo tablespace at database creation, 2.3.4, 2.3.8.2

data dictionary views reference, 12.14

DBMS_SPACE_ADMIN package, 12.11

default temporary tablespace, creating, 2.3.6, 2.3.8.2

detecting and repairing defects, 12.11

diagnosing and repairing problems in locally managed, 12.11

dictionary managed, 12.2.2.2

dropping, 12.9

guidelines for managing, 12.1

listing files of, 12.14.2

listing free space in, 12.14.3

locally managed, 12.2.1

locally managed SYSTEM, 2.3.2

locally managed temporary, 12.2.4.1

location, 13.1.3

migrating SYSTEM to locally managed, 12.12

multiple block sizes, 12.13.5.5

on a WORM device, 12.6.3

Oracle-managed files, managing, 15.5.1, 15.5.2

overriding default type, 2.3.8.2

quotas, assigning, 12.1.2

read-only, 12.6

renaming, 12.8

setting default type, 2.3.8.1

single-file, 2.3.8, 2.3.8.2, 12.2.2, 12.7.2

specifying nonstandard block sizes, 12.3

SYSAUX, 12.2, 12.8

SYSAUX creation, 2.3.3

SYSAUX, managing, 12.10

SYSTEM, 12.2, 12.2.1, 12.6.1, 12.12

taking offline normal, 12.5.1

taking offline temporarily, 12.5.1

tempfiles in locally managed, 12.2.4.1

temporary, 12.2.4, 12.2.5.3

temporary bigfile, 12.2.4.2

temporary for creating large indexes, 19.3.5

transportable

see transportable tablespaces

undo, 14.1

using multiple, 12.1.1

using Oracle-managed files, 15.3.3

tablespaces, encrypted, 12.2.3

tempfiles, 12.2.4.1

creating as Oracle-managed, 15.3.4

dropping, 13.6

dropping Oracle-managed tempfiles, 15.4.1

temporary segments

index creation and, 19.2.1

temporary tables

assigning to a tablespace, 18.3.2

creating, 18.3.2

temporary tablespace, default

specifying at database creation, 15.3.2.5

temporary tablespaces

altering, 12.7.3

bigfile, 12.2.4.2

creating, 12.2.4.1

groups, 12.2.5

renaming default, 12.8

shrinking, locally managed, 12.7.4

terminating user sessions

active sessions, 4.8.2

identifying sessions, 4.8.1

inactive session, example, 4.8.3

inactive sessions, 4.8.3

test case

builder, SQL, 8.1.1

threads

online redo log, 10.1.1

threshold based alerts

managing with Oracle Enterprise Manager, 7.1.2.1

threshold-based alerts

server-generated, 7.1.2

thresholds

setting alert, 17.1.1

time zone

files, 2.3.9.2

setting for database, 2.3.9.1

TNSNAMES.ORA file, 11.4.1.1

trace files, 8.1.3.3

location of, 7.1.1

log writer process and, 10.2.1.1

size of, 7.1.1.1

using, 7.1.1

when written, 7.1.1.2

trace files, finding, 8.6

traces, 8.1.3.3

tracing

archivelog process, 11.7

transaction control statements

distributed transactions and, 32.1.2

transaction failures

simulating, 33.9

transaction management

overview, 32.3

transaction processing

distributed systems, 29.4

transactions

closing database links, 31.2

distributed and two-phase commit, 29.4.6

in-doubt, 32.3.1.2, 32.4, 32.4.3, 33.4

naming distributed, 33.2, 33.4.3.2

remote, 29.4.4

transmitting archived redo logs, 11.5

transparent data encryption, 2.9.2, 12.2.3, 18.2.7

transportable set

See transportable tablespace set

transportable tablespace set

defined, 12.13.5

transportable tablespaces, 12.13

compatibility considerations, 12.13.4

from backup, 12.13.1

introduction, 12.13.1

limitations, 12.13.3

multiple block sizes, 12.13.5.5

procedure, 12.13.5

when to use, 12.13.6

wizard in Enterprise Manager, 12.13.1

XMLTypes in, 12.13.3

transporting tablespaces between databases

See transportable tablespaces

triggers

disabling, 16.4.2

enabling, 16.4.1

.trm files, 8.1.3.3

TRUNCATE statement, 16.3.3

DROP STORAGE clause, 16.3.3

REUSE STORAGE clause, 16.3.3

vs. dropping table, 18.10

tuning

analyzing tables, 31.4.2.2.2

cost-based optimization, 31.4.2

two-phase commit

case study, 32.5

commit phase, 32.3.2, 32.5.4

described, 29.4.6

discovering problems with, 33.4.1

distributed transactions, 32.3

example, 32.5

forget phase, 32.3.3

in-doubt transactions, 32.4, 32.4.3

phases, 32.3

prepare phase, 32.3.1, 32.3.1.2

recognizing read-only nodes, 32.3.1.1.2

specifying commit point strength, 33.1

steps in commit phase, 32.3.2.1

tracing session tree in distributed transactions, 33.3.2

viewing database links, 33.3.1

U

Undo Advisor, 14.4

undo management

automatic, 14.2

described, 14.1

initialization parameters for, 14.2.1

undo retention

automatic tuning of, 14.2.2.1

explained, 14.2.2

guaranteeing, 14.2.2.2

setting, 14.3

undo segments

in-doubt distributed transactions, 33.4.2

undo space

data dictionary views reference, 14.7

undo space management

automatic undo management mode, 14.2

Undo tablespace

specifying at database creation, 15.3.2.4

undo tablespace

managing, 14.5

managing space threshold alerts, 14.5.6

sizing a fixed-size, 14.4

undo tablespaces

altering, 14.5.2

creating, 14.5.1

data dictionary views reference, 14.7

dropping, 14.5.3

monitoring, 14.7

PENDING OFFLINE status, 14.5.4

renaming, 12.8

specifying at database creation, 2.2.2.7, 2.3.4, 2.3.8.2

statistics for, 14.7

switching, 14.5.4

user quotas, 14.5.5

UNDO_MANAGEMENT initialization parameter, 2.3.4

UNDO_TABLESPACE initialization parameter

for undo tablespaces, 2.4.7.2

starting an instance using, 14.2.1

UNIQUE key constraints

associated indexes, 19.3.3.1

dropping associated indexes, 19.6

enabling on creation, 19.3.3

foreign key references when dropped, 16.5.3.1

indexes associated with, 19.3.3

UNRECOVERABLE DATAFILE clause

ALTER DATABASE statement, 10.8

updates

location transparency and, 29.5.1.2

upgrading a database, 2.1

USE_INDIRECT_DATA_BUFFERS parameter, 5.4.2.8.3

user accounts

predefined, 2.9.1, 6.5

USER_DB_LINKS view, 30.5.1, 30.5.1

USER_DUMP_DEST initialization parameter, 8.1.3.1

USER_RESUMABLE view, 17.4.4.1

usernames

SYS and SYSTEM, 1.5.2

users

assigning tablespace quotas, 12.1.2

in a newly created database, 2.9.1

limiting number of, 2.4.9

predefined, 2.9.1

session, terminating, 4.8.3

utilities

for the database administrator, 1.8

SQL*Loader, 1.8

UTLCHAIN.SQL script

listing chained rows, 16.2.3.1

UTLCHN1.SQL script

listing chained rows, 16.2.3.1

UTLLOCKT.SQL script, 7.2.1

V

V$ARCHIVE view, 11.8

V$ARCHIVE_DEST view

obtaining destination status, 11.4.2

V$BLOCKING_QUIESCE view, 3.4.1

V$BUFFER_POOL view, 5.4.2.2.1

V$DATABASE view, 11.8.1

V$DBLINK view, 30.5.2

V$DIAG_INFO view, 8.1.4

V$DISPATCHER view

monitoring shared server dispatchers, 4.3.3.4

V$DISPATCHER_RATE view

monitoring shared server dispatchers, 4.3.3.4

V$ENCRYPTED_TABLESPACES view, 12.2.3, 12.14

V$INSTANCE view

for database quiesce state, 3.4.3

V$LOG view, 10.9, 11.8

displaying archiving status, 11.8

V$LOG_HISTORY view, 10.9

V$LOGFILE view, 10.9

log file status, 10.5.2

V$OBJECT_USAGE view

for monitoring index usage, 19.4.4

V$PWFILE_USERS view, 1.7.3.2

V$QUEUE view

monitoring shared server dispatchers, 4.3.3.4

V$RESULT_CACHE_STATISTICS view, 5.4.2.7, 5.4.2.7

V$ROLLSTAT view

undo segments, 14.7

V$SESSION view, 4.8.3

V$SYSAUX_OCCUPANTS view

occupants of SYSAUX tablespace, 12.10.2

V$THREAD view, 10.9

V$TIMEZONE_NAMES view

time zone table information, 2.3.9.2

V$TRANSACTION view

undo tablespaces information, 14.7

V$UNDOSTAT view

statistics for undo tablespaces, 14.7

V$VERSION view, 1.4.2

VALIDATE STRUCTURE clause

of ANALYZE statement, 16.2.2

VALIDATE STRUCTURE ONLINE clause

of ANALYZE statement, 16.2.2

varrays

storage parameters for, 17.3.6

verifying blocks

redo log files, 10.7

viewing

alerts, 17.1.2

incident package details, 8.10.3.1

SQL patch, 8.8.3

views

creating, 22.1.2

creating with errors, 22.1.2.3

data dictionary

for archived redo logs, 11.8.1

for clusters, 20.6

for control files, 9.8

for database, 2.10

for database resident connection pooling, 4.4.3

for Database Resource Manager, 25.11.3

for datafiles, 13.10

for hash clusters, 21.6

for indexes, 19.7

for memory management, 5.5.2

for Oracle Scheduler, 28.7.2

for redo log, 10.9

for schema objects, 16.10.2

for sequences, 22.4

for shared server, 4.3.4

for space usage in schema objects, 17.7.2

for synonyms, 22.4

for tables, 18.14

for tablespaces, 12.14

for undo space, 14.7

for views, 22.4

data dictionary views for, 22.4

DATABASE_PROPERTIES, 2.3.6

DBA_2PC_NEIGHBORS, 33.3.2

DBA_2PC_PENDING, 33.3.1

DBA_DB_LINKS, 30.5.1

DBA_RESUMABLE, 17.4.4.1

displaying dependencies of, 16.10.2.2

dropping, 22.1.7

file mapping views, 13.9.3.3

FOR UPDATE clause and, 22.1.2

invalid, 22.1.4

join. See join views.

location transparency in distributed databases, 30.6.1

managing, 22.1, 22.1.3

managing privileges with, 30.6.1

name resolution in distributed databases, 29.4.9

ORDER BY clause and, 22.1.2

remote object security, 30.6.1

restrictions, 22.1.4

USER_RESUMABLE, 17.4.4.1

using, 22.1.4

V$ARCHIVE, 11.8

V$ARCHIVE_DEST, 11.4.2

V$DATABASE, 11.8.1

V$LOG, 11.8

V$LOGFILE, 10.5.2

V$OBJECT_USAGE, 19.4.4

wildcards in, 22.1.2.2

WITH CHECK OPTION, 22.1.2

virtual columns, 18.1

indexing, 19.2.2

W

wallet, Oracle, 12.2.3, 18.2.7

wildcards

in views, 22.1.2.2

window groups

creating, 27.7.2

disabling, 27.7.7

dropping, 27.7.3

dropping a member from, 27.7.5

enabling, 27.7.6

overview, 26.3.3

using, 27.7

window logs, 27.6

windows (Scheduler)

altering, 27.6.3

closing, 27.6.5

creating, 27.6.2

disabling, 27.6.7

dropping, 27.6.6

enabling, 27.6.8

opening, 27.6.4

overlapping, 27.6.9

overview, 26.3.2

using, 27.6

WORM devices

and read-only tablespaces, 12.6.3

WRH$_UNDOSTAT view, 14.7

X

XMLTypes

in transportable tablespaces, 12.13.3