Skip Headers
Oracle® Database Administrator's Guide
12c Release 1 (12.1)

E41484-10
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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  Z 

Symbols

?, 2.3.11
@, 2.3.11

A

abort response, 34.3.1.1.3
two-phase commit, 34.3.1.1.3
accounts
DBA operating system account, 1.5.1
ADD LOGFILE clause
ALTER DATABASE statement, 11.3.1
ADD LOGFILE MEMBER clause
ALTER DATABASE statement, 11.3.2
adding
columns, 20.6.6
columns in compressed tables, 20.6.6.1
ADMIN_TABLES procedure
creating admin table, 25.3.1.1
DBMS_REPAIR package, 25.2.1
example, 25.4.1.1, 25.4.1.2
ADMINISTER_RESOURCE_MANAGER system privilege, 27.1.3
administering
the Scheduler, 30
administration
distributed databases, 32
administrative user accounts
SYS, 1.5.2, 1.5.2
SYSBACKUP, 1.5.2
SYSDG, 1.5.2
SYSKM, 1.5.2
administrator passwords, synchronizing password file and data dictionary, 1.7.2.2
ADR
See automatic diagnostic repository
ADR base, 9.1.4
ADR home, 9.1.4
ADRCI utility, 9.1.3.8
advanced index compression, 21.3.7.2
advanced row compression, 20.2.6
Advisor
Data Repair, 9.1.1
Undo, 16.4
AFTER SUSPEND system event, 19.2.4.1
AFTER SUSPEND trigger, 19.2.4.1
example of registering, 19.2.6
agent
Heterogeneous Services, definition of, 31.1.2
aggregate functions
statement transparency in distributed databases, 32.7
alert log, 9.1.3.2
about, 8.1.1
size of, 8.1.1.1
using, 8.1.1
viewing, 9.5
when written, 8.1.1.3
alert thresholds
setting for locally managed tablespaces, 19.1.1
alerts
server-generated, 8.1.2
tablespace space usage, 19.1.1
threshold-based, 8.1.2
viewing, 19.1.2
ALL_DB_LINKS view, 32.5.1, 32.5.1
allocation
extents, 20.6.4
ALTER CLUSTER statement
ALLOCATE EXTENT clause, 22.4
using for hash clusters, 23.4
using for index clusters, 22.4
ALTER DATABASE ADD LOGFILE statement
using Oracle Managed Files, 17.3.6.1
ALTER DATABASE statement
ADD LOGFILE clause, 11.3.1
ADD LOGFILE MEMBER clause, 11.3.2
ARCHIVELOG clause, 12.3.2
CDBs, 40.4, 40.4
CLEAR LOGFILE clause, 11.8
CLEAR UNARCHIVED LOGFILE clause, 11.2.1.1
data files online or offline, 14.4.3
database partially available to users, 3.2.1
DATAFILE...OFFLINE DROP clause, 14.4.2
DROP LOGFILE clause, 11.5.1
DROP LOGFILE MEMBER clause, 11.5.2
MOUNT clause, 3.2.1
NOARCHIVELOG clause, 12.3.2
OPEN clause, 3.2.2
READ ONLY clause, 3.2.3
RENAME FILE clause, 14.5.2.2
temp files online or offline, 14.4.3
UNRECOVERABLE DATAFILE clause, 11.8
ALTER INDEX statement
COALESCE clause, 21.2.13
MONITORING USAGE clause, 21.4.6
ALTER PLUGGABLE DATABASE statement, 40.4, 42.3.1.2
UNPLUG INTO clause, 38.7
ALTER SEQUENCE statement, 24.2.3
ALTER SESSION statement
ADVISE clause, 35.4.3.3
CLOSE DATABASE LINK clause, 33.2
Enabling resumable space allocation, 19.2.2.2
SET CONTAINER clause, 40.2.2
SET SQL_TRACE initialization parameter, 8.1.1.3
setting time zone, 2.4.9.1
ALTER SYSTEM statement
ARCHIVE LOG ALL clause, 12.3.3
CDBs, 40.5
CONTAINER clause, 40.5
DISABLE DISTRIBUTED RECOVERY clause, 35.9.2
ENABLE DISTRIBUTED RECOVERY clause, 35.9.2
ENABLE RESTRICTED SESSION clause, 3.2.4
enabling Database Resource Manager, 27.6
PDBs, 42.4
QUIESCE RESTRICTED, 3.4.1
RESUME clause, 3.5
SCOPE clause for SET, 2.6.5.1
SET RESOURCE_MANAGER_PLAN, 27.6
SET SHARED_SERVERS initialization parameter, 5.3.3.2
setting initialization parameters, 2.6.5
SUSPEND clause, 3.5
SWITCH LOGFILE clause, 11.6
UNQUIESCE, 3.4.2
ALTER TABLE statement
ADD (column) clause, 20.6.6
ALLOCATE EXTENT clause, 20.6.4
DEALLOCATE UNUSED clause, 20.6.4
DISABLE ALL TRIGGERS clause, 18.4.2
DISABLE integrity constraint clause, 18.5.3.1
DROP COLUMN clause, 20.6.8.1
DROP integrity constraint clause, 18.5.3.3
DROP UNUSED COLUMNS clause, 20.6.8.2
ENABLE ALL TRIGGERS clause, 18.4.1
ENABLE integrity constraint clause, 18.5.3.1, 18.5.3.1
external tables, 20.13.3
MODIFY (column) clause, 20.6.5
modifying index-organized table attributes, 20.12.3.1
MOVE clause, 20.6.3, 20.6.3, 20.6.3.1, 20.6.3.2, 20.6.3.2, 20.12.3.2
reasons for use, 20.6.1
RENAME COLUMN clause, 20.6.7
SET UNUSED clause, 20.6.8.2
ALTER TABLESPACE statement
adding an Oracle managed data file, example, 17.3.3.3
adding an Oracle managed temp file, example, 17.3.4.2
ONLINE clause, example, 13.6.2
READ ONLY clause, 13.7.1
READ WRITE clause, 13.7.2
RENAME DATAFILE clause, 14.5.2.1.1
RENAME TO clause, 13.9
taking data files/temp files online/offline, 14.4.3
ALTER TRIGGER statement
DISABLE clause, 18.4.2
ENABLE clause, 18.4.1
altering
(Scheduler) windows, 29.7.3.3
event schedule, 29.5.2.4
event-based job, 29.5.2.2
indexes, 21.4
job classes, 29.7.1.3
jobs, 29.2.3
programs, 29.3.3
schedules, 29.4.3
ANALYZE statement
CASCADE clause, 18.2.2
CASCADE clause, FAST option, 18.2.2
corruption reporting, 25.3.1.3
listing chained rows, 18.2.3
remote tables, 33.4.2.2.2
validating structure, 18.2.2, 25.3.1
analyzing schema objects, 18.2
analyzing tables
distributed processing, 33.4.2.2.2
APPEND hint, 20.2.6.1
Application Continuity, 2.8.4
application development
distributed databases, 31.5, 33, 33.5
application development for distributed databases, 33
analyzing execution plan, 33.4.4
database links, controlling connections, 33.2
handling errors, 33.3, 33.5
handling remote procedure errors, 33.5
managing distribution of data, 33.1
managing referential integrity constraints, 33.3
terminating remote connections, 33.2
tuning distributed queries, 33.4
tuning using collocated inline views, 33.4.1
using cost-based optimization, 33.4.2
using hints to tune queries, 33.4.3
ARCHIVE_LAG_TARGET initialization parameter, 11.2.6.1
archived redo log files
alternate destinations, 12.4.3
archiving modes, 12.3.2
data dictionary views, 12.8.1
destination availability state, controlling, 12.4.2
destination status, 12.4.2
destinations, specifying, 12.4
failed destinations and, 12.6
mandatory destinations, 12.6.1.1
minimum number of destinations, 12.6.1
multiplexing, 12.4.1
normal transmission of, 12.5
re-archiving to failed destination, 12.6.2
sample destination scenarios, 12.6.1.2
standby transmission of, 12.5
status information, 12.8.1
transmitting, 12.5
ARCHIVELOG mode, 12.2.2
advantages, 12.2.2
archiving, 12.2
automatic archiving in, 12.2.2
definition of, 12.2.2
distributed databases, 12.2.2
enabling, 12.3.2
manual archiving in, 12.2.2
running in, 12.2.2
switching to, 12.3.2
taking data files offline and online in, 14.4.1
archiver process (ARCn), 5.5
trace output (controlling), 12.7
archiving
alternate destinations, 12.4.3
changing archiving mode, 12.3.2
controlling number of processes, 12.3.4
destination availability state, controlling, 12.4.2
destination failure, 12.6
destination status, 12.4.2
manual, 12.3.3, 12.3.3
NOARCHIVELOG vs. ARCHIVELOG mode, 12.2
setting initial mode, 12.3.1
to failed destinations, 12.6.2
trace output, controlling, 12.7
viewing information on, 12.8.1
at-sign, 2.3.11
attribute-clustered tables, 20.2.9
auditing
database links, 31.3.3
authentication
database links, 31.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, 26.5
AUTOEXTEND clause, 14.3.1
for bigfile tablespaces, 13.8.3
automatic big table cache, 6.2
automatic diagnostic repository, 9.1.1, 9.1.3.1
in Oracle Client, 9.1.4
in Oracle Clusterware, 9.1.4
in Oracle Real Application Clusters, 9.1.4
structure, contents and location of, 9.1.4
automatic file extension, 14.3.1
automatic maintenance tasks
assigning to maintenance windows, 26.3.2
definition, 26.1
enabling and disabling, 26.3.1
predefined, 26.1
resource allocation, 26.5.1
Scheduler job names, 26.2
automatic segment space management, 13.2.1.2
automatic undo management, 2.4.4, 16.2, 16.2
migrating to, 16.6

B

background processes, 5.5
FMON, 14.9.2.1.1
BACKGROUND_DUMP_DEST initialization parameter, 9.1.3.1
backups
after creating new databases, 2.3.13
effects of archiving on, 12.2.1
batch jobs, authenticating users in, 2.8.3
big table cache, 6.2, 6.2
bigfile tablespaces
creating, 13.2.2.1
creating temporary, 13.2.5.2
description, 13.2.2
setting database default, 2.4.8.1
BLANK_TRIMMING initialization parameter, 20.6.5
BLOB data type, 20.3.1
block size, redo log files, 11.2.4
BLOCKSIZE clause
of CREATE TABLESPACE, 13.4

C

CACHE option
CREATE SEQUENCE statement, 24.2.4.2.2
caches
sequence numbers, 24.2.4.2
calendaring expressions, 29.4.5.1
calls
remote procedure, 31.5.2
capacity planning
space management
capacity planning, 19.7
CASCADE clause
when dropping unique or primary keys, 18.5.3.1
CATBLOCK.SQL script, 8.2.1
catcon.pl, 40.7
CDB resource plans, 44.1.2
CDB_PDB_HISTORY view, 43.11
CDB_PDBS view, 43.5
CDBs, 35.10, 36.1
administering, 40, 41
ALTER DATABASE statement, 40.4
ALTER PLUGGABLE DATABASE statement, 40.4
ALTER SYSTEM statement, 40.5
CDB resource plans
viewing information about, 44.8
common users
definition, 36.1.2
compatibility violations, 40.4.5.1
connecting to, 40.2
ALTER SESSION statement, 40.2.2
CONNECT command, 40.2.1
container data objects, 43.1.1
querying, 43.7
containers, 36.1.1, 43.4
CONTAINERS clause, 43.8
creating, 37
current container, 40.1.1, 43.9
data definition language (DDL), 40.6
Database Resource Manager, 44
DBMS_SQL package, 40.3
EM Express, 37.5
ENABLE PLUGGABLE DATABASE clause, 37.4.1.1
executing PL/SQL code, 40.3
initialization parameters, 43.10
local users
definition, 36.1.2
modifying, 40.4, 40.4.3, 40.5
monitoring, 43
Oracle Database Vault, 40.1.2
Oracle Managed Files, 37.4.1.2.2
PDB_FILE_NAME_CONVERT initialization parameter, 37.4.1.2.3
PDBs
modifying, 40.4
planning creation, 37.2
plugging in PDBs
CREATE PLUGGABLE DATABASE statement, 38.1.2
methods for, 38.1.1
preparing for, 38.2
prerequisites for, 36.3
purpose of, 36.2
root container
definition, 36.1.1
modifying, 40.4.4
SEED FILE_NAME_CONVERT clause, 37.4.1.2.1
seed PDB, 36.1.1
shutting down, 40.8
SQL scripts, 40.7
standby database, 40.1.2
tools for, 36.4.2
Transparent Data Encryption, 40.1.2
unplugging PDBs, 38.7
viewing information about, 43
views, 43.2
centralized user management
distributed systems, 31.3.2.4
chain condition syntax, 29.6.4
chain rules, 29.6.4
chain steps
defining, 29.6.3
chained rows
eliminating from table, procedure, 18.2.3.2
CHAINED_ROWS table
used by ANALYZE statement, 18.2.3.1
chains
creating, 29.6.2
creating and managing job, 29.6
creating jobs for, 29.6.6
disabling, 29.6.10
dropping, 29.6.7
dropping rules from, 29.6.9
enabling, 29.6.5
handling stalled, 29.6.18
monitoring running, 29.6.17
overview, 28.2.7
pausing, 29.6.14
running, 29.6.8
setting privileges, 30.1.1
steps
pausing, 29.6.14
skipping, 29.6.15
stopping, 29.6.12
stopping individual steps, 29.6.13
change vectors, 11.1.2
CHAR data type
increasing column length, 20.6.5
character set
choosing, 2.1.1.1
CHECK_OBJECT procedure
DBMS_REPAIR package, 25.2.1
example, 25.4.2
finding extent of corruption, 25.3.2
checkpoint process (CKPT), 5.5
checksums
for data blocks, 14.7
redo log blocks, 11.7, 11.7
CLEAR LOGFILE clause
ALTER DATABASE statement, 11.8, 11.8
clearing redo log files, 11.2.1.1, 11.8
client/server architectures
distributed databases, 31.1.3, 31.1.3
globalization support, 31.6.1
CloneDB, 2.9
CLONEDB parameter, 38.4.1
clonedb.pl Perl script, 2.9.2
cloning
a database, 1.2.11, 2.9
an Oracle home, 1.2.11
CLOSE DATABASE LINK clause
ALTER SESSION statement, 33.2
closing database links, 32.4.1
closing windows, 29.7.3.5
clusters
about, 22.1
allocating extents, 22.4
altering, 22.4
analyzing, 18.2
cluster indexes, 22.5
cluster keys, 22.1, 22.2.2, 22.2.3
clustered tables, 22.1, 22.2.1, 22.3.1, 22.4.1, 22.5.1
columns for cluster key, 22.2.2
creating, 22.3
data dictionary views reference, 22.6
deallocating extents, 22.4
dropping, 22.5
estimating space, 22.2.3, 22.2.5
guidelines for managing, 22.2
location, 22.2.4
privileges, 22.3, 22.4, 22.5.1
selecting tables, 22.2.1
single-table hash clusters, 23.3.2
truncating, 18.3
validating structure, 18.2.2
coalescing indexes
costs, 21.2.13
cold backup
performing with a detached Oracle Scheduler job, 29.2.2.8
collocated inline views
tuning distributed queries, 33.4.1
column encryption, 2.8.2
columns
adding, 20.6.6
adding to compressed table, 20.6.6.1
displaying information about, 20.14
dropping, 20.6.8, 20.6.8.3
dropping in compressed tables, 20.6.8.4
encrypted, 20.2.13
increasing length, 20.6.5
invisible, 20.2.12
modifying definition, 20.6.5
renaming, 20.6.7
virtual, 20.1
virtual, indexing, 21.2.2
commands
submitting, 1.3
COMMENT statement, 20.14
comments
adding to problem activity log, 9.2.7
COMMIT COMMENT statement
used with distributed transactions, 35.2, 35.4.3.2
commit phase, 34.3.1, 34.5.4
in two-phase commit, 34.3.2, 34.3.2.2
commit point site, 34.2.5
commit point strength, 34.2.5.2, 35.1
determining, 34.2.5.2
distributed transactions, 34.2.5, 34.2.5.2
how the database determines, 34.2.5.2
commit point strength
definition, 34.2.5.2
specifying, 35.1
COMMIT statement
FORCE clause, 35.5, 35.5.1.1, 35.5.2
forcing, 35.4.2
two-phase commit and, 31.4.6
COMMIT_POINT_STRENGTH initialization parameter, 34.2.5.2, 35.1
committing transactions
commit point site for distributed transactions, 34.2.5
common users
definition, 36.1.2
prefix, 40.6.1
COMMON_USER_PREFIX parameter, 40.6.1
compatibility level, 2.5.9
COMPATIBLE Initialization Parameter, 2.5.9
components
srvctl component names and abbreviations, 4.4
compression
indexes, 21.3.7
advanced compression, 21.3.7.2
prefix compression, 21.3.7.1
levels, 20.2.6
tables, 20.2.6
adding a column, 20.6.6.1
dropping columns in, 20.6.8.4
tablespaces, 13.2.3
CON_DBID_TO_ID function, 43.9
CON_GUID_TO_ID function, 43.9
CON_NAME_TO_ID function, 43.9
CON_UID_TO_ID function, 43.9
configuring
an Oracle database, 2
Oracle Scheduler, 30.1
CONNECT command
starting an instance, 3.1.4
CONNECT command, SQL*Plus, 1.3.2.4
CDBs, 40.2.1
connected user database links, 32.2.3.2
advantages and disadvantages, 31.2.7.1
definition, 31.2.7
example, 31.2.8
REMOTE_OS_AUTHENT initialization parameter, 31.2.7.1
connecting
with SQL*Plus, 1.3.2
connection qualifiers
database links and, 32.2.4
connections
terminating remote, 33.2
constraints
See also integrity constraints
disabling at table creation, 18.5.2.1
distributed system application development issues, 33.3
dropping integrity constraints, 18.5.3.3
enable novalidate state, 18.5.1.3
enabling example, 18.5.2.2
enabling when violations exist, 18.5.1.3
exceptions, 18.5.1.2, 18.5.5
exceptions to integrity constraints, 18.5.5
integrity constraint states, 18.5.1
keeping index when disabling, 18.5.3
keeping index when dropping, 18.5.3
ORA-02055 constraint violation, 33.3
renaming, 18.5.3.2
setting at table creation, 18.5.2
when to disable, 18.5.1.1
container data objects, 43.1.1
definition, 43.1.1
querying, 43.7
CONTAINERS clause, 43.8
containers, CDB, 36.1.1
control files
adding, 10.3.2
changing size, 10.3.1
conflicts with data dictionary, 10.4.1
creating, 10.1, 10.3, 10.3.3.2
creating as Oracle Managed Files, 17.3.5
creating as Oracle Managed Files, examples, 17.5.1
data dictionary views reference, 10.8
default name, 2.5.4, 10.3.1
dropping, 10.7
errors during creation, 10.4.2
guidelines for, 10.2
importance of multiplexed, 10.2.2
initial creation, 10.3.1
location of, 10.2.2
log sequence numbers, 11.1.3.2
mirroring, 2.5.4, 10.2.2
moving, 10.3.2
multiplexed, 10.2.2
names, 10.2.1
number of, 10.2.2
overwriting existing, 2.5.4
relocating, 10.3.2
renaming, 10.3.2
requirement of one, 10.1
size of, 10.2.4
specifying names before database creation, 2.5.4
troubleshooting, 10.4
unavailable during startup, 3.1.5
CONTROL_FILES initialization parameter
overwriting existing control files, 2.5.4
specifying file names, 10.2.1
when creating a database, 2.5.4, 10.3.1
CONTROLFILE REUSE clause, 2.5.4
copying jobs, 29.2.9
coraenv and oraenv, 1.3.2.2
core files, 9.1.3.3
corruption
repairing data block, 25.1
cost-based optimization, 33.4.2
distributed databases, 31.5.3
hints, 33.4.3
using for distributed queries, 33.4.2
CREATE BIGFILE TABLESPACE statement, 13.2.2.1
CREATE BIGFILE TEMPORARY TABLESPACE statement, 13.2.5.2
CREATE CLUSTER statement
creating clusters, 22.3
example, 22.3
for hash clusters, 23.3
HASH IS clause, 23.3, 23.3.3.2
HASHKEYS clause, 23.3, 23.3.3.4
SIZE clause, 23.3.3.3
CREATE CONTROLFILE statement
about, 10.3.3.2
checking for inconsistencies, 10.4.1
creating as Oracle Managed Files, examples, 17.3.5, 17.5.1
NORESETLOGS clause, 10.3.3.3
Oracle Managed Files, using, 17.3.5
RESETLOGS clause, 10.3.3.3
CREATE DATABASE LINK statement, 32.2.2.1
CREATE DATABASE statement
CDBs, 37.4
CONTROLFILE REUSE clause, 10.3.1
DEFAULT TEMPORARY TABLESPACE clause, 2.3.9, 2.4.6, 37.4.2, 37.4.2
ENABLE PLUGGABLE DATABASE clause, 37.4.1.1
example of database creation, 2.3.9
EXTENT MANAGEMENT LOCAL clause, 2.4.2
MAXLOGFILES parameter, 11.2.5
MAXLOGMEMBERS parameter, 11.2.5, 11.2.5
password for SYS, 2.4.1
password for SYSTEM, 2.4.1
SEED FILE_NAME_CONVERT clause, 37.4.1.2.1
setting time zone, 2.4.9.1
specifying FORCE LOGGING, 2.4.10
SYSAUX DATAFILE clause, 2.3.9, 37.4.2
UNDO TABLESPACE clause, 2.3.9, 2.4.4, 37.4.2, 37.4.2
used to create an undo tablespace, 16.5.1.1
using Oracle Managed Files, 17.3.2
using Oracle Managed Files, examples, 17.3.2.6, 17.5.1, 17.5.2
CREATE INDEX statement
NOLOGGING, 21.2.10
ON CLUSTER clause, 22.3.2
using, 21.3.1
with a constraint, 21.3.3.1
CREATE PFILE FROM MEMORY statement, 2.6.7
CREATE PLUGGABLE DATABASE statement, 38.1.2
logging_clause, 38.1.2.7, 42.3.1.1
NO DATA clause, 38.1.2.9, 38.4.2
PATH_PREFIX clause, 38.1.2.3
pdb_force_logging_clause, 42.3.1.1
SNAPSHOT COPY clause, 38.4.1
SOURCE_FILE_NAME_CONVERT clause, 38.1.2.4
STANDBYS clause, 38.1.2.8
STORAGE clause, 38.1.2.1
USER_TABLESPACES clause, 38.1.2.6
CREATE SCHEMA statement
multiple tables and views, 18.1
CREATE SEQUENCE statement, 24.2.2
CACHE option, 24.2.4.2.2
examples, 24.2.4.2.2
NOCACHE option, 24.2.4.2.2
CREATE SPFILE statement, 2.6.3
CREATE SYNONYM statement, 24.3.2
CREATE TABLE statement
AS SELECT clause, 20.2.4, 20.3.3
CLUSTER clause, 22.3.1
COMPRESS clause, 20.12.2.7
creating temporary table, 20.3.2
example of, 20.3.1
INCLUDING clause, 20.12.2.5
index-organized tables, 20.12.2
MONITORING clause, 20.5
NOLOGGING clause, 20.2.5
ORGANIZATION EXTERNAL clause, 20.13.2
parallelizing, 20.3.3
PCTTHRESHOLD clause, 20.12.2.4
TABLESPACE clause, specifying, 20.2.3
CREATE TABLESPACE statement
BLOCKSIZE CLAUSE, using, 13.4
FORCE LOGGING clause, using, 13.5
using Oracle Managed Files, 17.3.3
using Oracle Managed Files, examples, 17.3.3.1
CREATE TEMPORARY TABLESPACE statement, 13.2.5.1
using Oracle Managed Files, 17.3.4
using Oracle managed files, example, 17.3.4.1
CREATE UNDO TABLESPACE statement
using Oracle Managed Files, 17.3.3
using Oracle Managed Files, example, 17.3.3.2
using to create an undo tablespace, 16.5.1.2
CREATE UNIQUE INDEX statement
using, 21.3.2
CREATE VIEW statement
about, 24.1.2
OR REPLACE clause, 24.1.3
WITH CHECK OPTION, 24.1.2, 24.1.4
CREATE_CREDENTIAL procedure, 5.7.2, 29.2.2.3
CREATE_SIMPLE_PLAN procedure
Database Resource Manager, 27.4, 44.5
creating
an Oracle database, 2
CDBs, 37
chains, 29.6.2
control files, 10.3
database services, 2.7.1.4
databases, 2.1
event schedule, 29.5.2.3
event-based job, 29.5.2.1
indexes, 21.3
after inserting table data, 21.2.1
associated with integrity constraints, 21.3.3
NOLOGGING, 21.2.10
online, 21.3.5
USING INDEX clause, 21.3.3.1
job classes, 29.7.1.2
jobs, 29.2.2
programs, 29.3.2
Scheduler windows, 29.7.3.2
schedules, 29.4.2
sequences, 24.2.4.2.2, 24.2.4.2.2
window groups, 29.7.4.2
creating CDBs
CREATE DATABASE statement, 37.4
Database Configuration Assistant, 37.3
ENABLE PLUGGABLE DATABASE clause, 37.4.1.1
manually from a script, 37.4
Oracle Managed Files, 37.4.1.2.2
PDB_FILE_NAME_CONVERT initialization parameter, 37.4.1.2.3
planning, 37.2
SEED FILE_NAME_CONVERT clause, 37.4.1.2.1
creating data files, 14.2
creating database links, 32.2
connected user, 32.2.3.2.1
connected user scenarios, 32.8.3
current user, 32.2.3.2.2
current user scenario, 32.8.5
examples, 31.2.8
fixed user, 32.2.3.1
fixed user scenario, 32.8.1, 32.8.2
obtaining necessary privileges, 32.2.1
private, 32.2.2.1
public, 32.2.2.2
service names within link names, 32.2.4
shared, 32.3
shared connected user scenario, 32.8.4
specifying types, 32.2.2
creating databases
backing up the new database, 2.3.13
default temporary tablespace, specifying, 2.4.6
example, 2.3.9
manually from a script, 2.1
overriding default tablespace type, 2.4.8.2
planning, 2.1.1
preparing to, 2.1.1
prerequisites for, 2.1.1.2
setting default tablespace type, 2.4.8.1
specifying bigfile tablespaces, 2.4.8, 2.4.8.2
UNDO TABLESPACE clause, 2.4.4
upgrading to a new release, 2.1
using Oracle Managed Files, 2.4.7, 17.3.2
with DBCA, 2.2
with locally managed tablespaces, 2.4.2
creating sequences, 24.2.2
creating synonyms, 24.3.2
creating views, 24.1.2
credentials, Oracle Scheduler
about, 28.2.6
granting privileges on, 28.2.6
critical errors
diagnosing, 9.1.1
CRSCTL utility
Oracle Restart, 4.1.4
current container, 40.1.1
current user database links
advantages and disadvantages, 31.2.7.3
cannot access in shared schema, 31.3.2.4.2
definition, 31.2.7
example, 31.2.8
schema independence, 31.3.2.4.2
CURRVAL pseudo-column, 24.2.4.1
restrictions, 24.2.4.1.3
cursors
and closing database links, 33.2
customize package page, accessing, 9.10.3.2
customizing an incident package, 9.10.3, 9.10.3.2

D

data
loading using external tables, 20.13.2
data block corruption
repairing, 25.1
data blocks
altering size of, 2.5.5.1
nonstandard block size, 2.5.5.2
shared in clusters, 22.1
specifying size of, 2.5.5
standard block size, 2.5.5
verifying, 14.7
data definition language (DDL)
CDBs, 40.6
data dictionary
conflicts with control files, 10.4.1
purging pending rows from, 35.6, 35.6.2
See also views, data dictionary
data encryption
distributed systems, 31.3.2.5
data file headers
when renaming tablespaces, 13.9
data files
adding to a tablespace, 14.2
bringing online and offline, 14.4
checking associated tablespaces, 13.14.2
copying using database, 14.8
creating, 14.2
creating Oracle Managed Files, 17.3, 17.3.6.2
data dictionary views reference, 14.10
database administrators access, 1.5.1
default directory, 14.2
definition, 14.1
deleting, 13.10
dropping, 14.4.2, 14.6
dropping Oracle managed, 17.4.1
file numbers, 14.1
fully specifying filenames, 14.2
guidelines for managing, 14.1
headers when renaming tablespaces, 13.9
identifying OS filenames, 14.5.2.1.2
location, 14.1.3
mapping files to physical devices, 14.9
minimum number of, 14.1.1
MISSING, 10.4.1
offline
relocating, 14.5.2
renaming, 14.5.2
online, 14.4.2
relocating, 14.5.1
renaming, 14.5.1
relocating, 14.5
renaming, 14.5
reusing, 14.2
size of, 14.1.2
statements to create, 14.2
storing separately from redo log files, 14.1.4
unavailable when database is opened, 3.1.5
verifying data blocks, 14.7
data manipulation language
statements allowed in distributed transactions, 31.4.1
Data Recovery Advisor, repairing data corruptions with, 9.9
Data Repair Advisor, 9.1.1
database
cloning, 1.2.11, 2.9
creating, 2.1
creating and configuring, 2
creating with DBCA, 2.2
data dictionary views reference, 2.11
starting up, 3.1
database administrators
DBA role, 1.5.2.4
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, 7.1
task definitions, 1.2
utilities for, 1.8
database clouds, 2.7.2
Database Configuration Assistant, 2.1
CDBs, 37.3
shared server configuration, 5.3.4
database destinations, Oracle Scheduler
about, 28.2.4
creating, 29.2.2.4.2
database jobs, Oracle Scheduler, 28.3.1.1
database links
advantages, 31.2.3
auditing, 31.3.3
authentication, 31.3.2.1
authentication without passwords, 31.3.2.2
closing, 32.4.1, 33.2
connected user, 31.2.7, 31.2.7.1, 32.2.3.2, 32.8.3
connections, determining open, 32.5.2
controlling connections, 33.2
creating, 32.2, 32.8.1, 32.8.3, 32.8.4, 32.8.5
creating shared, 32.3.2
creating, examples, 31.2.8
creating, scenarios, 32.8
current user, 31.2.7, 31.2.7.3, 32.2.3.2
data dictionary USER views, 32.5.1
definition, 31.2.1
distributed queries, 31.4.2
distributed transactions, 31.4.5
dropping, 32.4.2
enforcing global naming, 32.1.2
enterprise users and, 31.3.2.4.2
fixed user, 31.2.7, 31.2.7.2, 32.8.1
global, 31.2.6
global names, 31.2.4
loopback, 31.2.4.1
global object names, 31.4.7
handling errors, 33.3
limiting number of connections, 32.4.3
listing, 32.5.1, 35.3.1, 35.3.2
loopback, 31.2.4.1
managing, 32.4
minimizing network connections, 32.3
name resolution, 31.4.7
names for, 31.2.5
private, 31.2.6
public, 31.2.6
referential integrity in, 33.3
remote transactions, 31.4.1, 31.4.4
resolution, 31.4.7
restrictions, 31.2.10
roles on remote database, 31.2.10
schema objects and, 31.2.9
service names used within link names, 32.2.4
shared, 31.2.2, 32.3.1, 32.3.3, 32.3.3.1, 32.3.3.2
shared SQL, 31.4.3
synonyms for schema objects, 31.2.9.3
tuning distributed queries, 33.4
tuning queries with hints, 33.4.3
tuning using collocated inline views, 33.4.1
types of links, 31.2.6
types of users, 31.2.7
users, specifying, 32.2.3
using cost-based optimization, 33.4.2
viewing, 32.5, 32.5.1
database objects
obtaining growth trends for, 19.7.3
database program unit, definition, 28.1
database resident connection pooling, 5.2
advantages, 5.2
configuration parameters, 5.4.2
configuring the connection pool, 5.4.2
data dictionary views reference, 5.4.3
disabling, 5.4.1
enabling, 5.4.1
triggers, 5.2
Database Resource Manager
active session pool with queuing, 27.3.5
administering system privilege, 27.1.3
and operating system control, 27.12
automatic consumer group switching, 27.3.4.1
CDB resource plans, 44.1.2
CDBs, 44
CREATE_SIMPLE_PLAN procedure, 27.4, 44.5
data dictionary views reference, 27.13.3
description, 27.1
enabling, 27.6
execution time limit, 27.3.4.3
PDB resource plans, 44.1.3
PDBs, 44
resource allocation methods, 27.5.3, 27.5.5, 27.5.5, 27.5.5, 27.5.5, 27.5.5, 27.5.5, 27.5.5, 27.5.5
resource consumer groups, 27.1.2, 27.2, 27.5.3
resource plan directives, 27.1.2, 27.5.6, 27.5.7
resource plans, 27.1.2, 27.1.2.6, 27.3.1.1, 27.4, 27.6, 27.6, 27.7, 27.7.5
STATISTICS_LEVEL parameter, 27.1.1
undo pool, 27.3.6
used for quiescing a database, 3.4
validating plan schema changes, 27.5.7
database services
about, 2.7.1.1
controlling automatic startup of, 3.1.3
creating, 2.7.1.4
data dictionary views, 2.7.3
managing application workloads with, 2.7
database writer process
calculating checksums for data blocks, 14.7
database writer process (DBWn), 5.5
DATABASE_PROPERTIES view
rename of default temporary tablespace, 13.9
databases
administering, 1
administration of distributed, 32
altering availability, 3.2
backing up, 2.3.13
control files of, 10.2
default temporary tablespace, specifying, 2.4.6
dropping, 2.10
global database names in distributed systems, 2.5.2.2
mounting a database, 3.1.5.3
mounting to an instance, 3.2.1
names, about, 2.5.2.1
names, conflicts in, 2.5.2.1
opening a closed database, 3.2.2
planning, 1.2.3
planning creation, 2.1.1
quiescing, 3.4
read-only, opening, 3.2.3
recovery, 3.1.5.6
renaming, 10.3.3.2, 10.3.3.3
restricting access, 3.2.4
resuming, 3.5
shutting down, 3.3
specifying control files, 2.5.4
suspending, 3.5
undo management, 2.4.4
upgrading, 2.1
with locally managed tablespaces, 2.4.2
DB_BLOCK_CHECKING initialization parameter, 25.3.1, 25.3.1.4
DB_BLOCK_CHECKSUM initialization parameter, 14.7
enabling redo block checking with, 11.7
DB_BLOCK_SIZE initialization parameter
and nonstandard block sizes, 13.4
setting, 2.5.5
DB_CACHE_SIZE initialization parameter
specifying multiple block sizes, 13.4
DB_CREATE_FILE_DEST initialization parameter, 17.2
setting, 17.2.1
DB_CREATE_ONLINE_LOG_DEST_n initialization parameter, 17.2
setting, 17.2.3
DB_DOMAIN initialization parameter
setting for database creation, 2.5.2, 2.5.2.2
DB_FILES initialization parameter
determining value for, 14.1.1.1
DB_NAME initialization parameter
setting before database creation, 2.5.2
DB_nK_CACHE_SIZE initialization parameter
specifying multiple block sizes, 13.4
transporting data, 15.6
DB_RECOVERY_FILE_DEST initialization parameter, 17.2
setting, 17.2.2
DB_UNRECOVERABLE_SCN_TRACKING initialization parameter, 20.4.2.4.2
DBA
See database administrators
DBA role, 1.5.2.4
DBA_2PC_NEIGHBORS view, 35.3.2
using to trace session tree, 35.3.2
DBA_2PC_PENDING view, 35.3.1, 35.6, 35.7.6
using to list in-doubt transactions, 35.3.1
DBA_DB_LINKS view, 32.5.1, 32.5.1, 32.5.1
DBA_PDB_SAVED_STATES view, 40.4.6
DBA_RESUMABLE view, 19.2.4.1
DBA_UNDO_EXTENTS view
undo tablespace extents, 16.8
DBCA
See Database Configuration Assistant
DBMS_CREDENTIAL package, 5.7.2
DBMS_FILE_TRANSFER package
copying data files, 14.7
DBMS_JOB
about, A.1
moving jobs to Oracle Scheduler, A.2
using with PDB, 46.3
DBMS_METADATA package
GET_DDL function, 18.11.1
using for object definition, 18.11.1
DBMS_REDEFINITION package
performing online redefinition with, 20.7.3
required privileges, 20.7.10, 20.7.10
DBMS_REPAIR
logical corruptions, 25.3.2
DBMS_REPAIR package
examples, 25.4
limitations, 25.2.2
procedures, 25.2.1
using, 25.3, 25.4.5
DBMS_RESOURCE_MANAGER package, 27.1.2, 27.1.3, 27.2.4.1
procedures (table of), 27.1.3
DBMS_RESOURCE_MANAGER_PRIVS package, 27.1.3
procedures (table of), 27.1.3
DBMS_RESUMABLE package, 19.2.4.3
DBMS_SCHEDULER.GET_FILE, retrieving external job stdout with, 29.2.2.10
DBMS_SERVER_ALERT package
setting alert thresholds, 19.1
DBMS_SPACE package, 19.3.4
example for unused space, 19.6.1
FREE_BLOCK procedure, 19.6.1
SPACE_USAGE procedure, 19.6.1
UNUSED_SPACE procedure, 19.6.1
DBMS_SPACE_ADMIN
DROP_EMPTY_SEGMENTS procedure, 19.4
MATERIALIZE_DEFERRED_SEGMENTS procedure, 20.2.15
DBMS_SQL package
CDBs, 40.3
DBMS_STATS package, 18.2.1
MONITORING clause of CREATE TABLE, 20.5
DBMS_STORAGE_MAP package
invoking for file mapping, 14.9.3.1
views detailing mapping information, 14.9.3.3
DBMS_TRANSACTION package
PURGE_LOST_DB_ENTRY procedure, 35.6.1
DBVERIFY utility, 25.3.1, 25.3.1.2
DDL lock timeout, 2.5.7
DDL log, 9.1.3.4
DDL_LOCK_TIMEOUT initialization parameter, 2.5.7
DEALLOCATE UNUSED clause, 19.3.4
deallocating unused space, 19.3
DBMS_SPACE package, 19.3.4
DEALLOCATE UNUSED clause, 19.3.4
debug log, 9.1.3.5
declarative referential integrity constraints, 33.3
dedicated server processes, 5.1.1
trace files for, 8.1.1
default temporary tablespace
renaming, 13.9
default temporary tablespaces
specifying at database creation, 2.3.9, 2.4.6
specifying bigfile temp file, 2.4.8.2
specifying for CDBs, 37.4.2, 37.4.2
DEFAULT_CONSUMER_GROUP for Database Resource Manager, 27.2.6, 27.9.2
deferred segment creation
in tables, 20.2.14
indexes, 21.2.6
deferred segments
materializing, 20.2.15
defining
chain steps, 29.6.3
dependencies
between schema objects, 18.7
displaying, 18.11.2.2
DESCRIBE procedure, 38.6.1, 38.6.1
destinations, Oracle Scheduler
about, 28.2.4
creating, 29.2.2.4.2
detached jobs, 28.3.1.5
creating, 29.2.2.8
DIAGNOSTIC_DEST initialization parameter, 8.1.1, 9.1.4
dictionary-managed tablespaces
migrating SYSTEM to locally managed, 13.13
Digital POLYCENTER Manager on NetView, 31.3.4.3
directory objects
external procedures, 5.7.2
direct-path INSERT
benefits, 20.4.2.1
how it works, 20.4.2.2
index maintenance, 20.4.2.5.2
locking considerations, 20.4.2.5.4
logging mode, 20.4.2.4
parallel INSERT, 20.4.2.3.2
parallel load compared with parallel INSERT, 20.4.2.1
space considerations, 20.4.2.5.3
disabling
chains, 29.6.10
jobs, 29.2.7
programs, 29.3.5
SQL patch, 9.8.3
window groups, 29.7.4.7
windows, 29.7.3.7
disabling recoverer process, 35.9.2
dispatcher process (Dnnn), 5.5
dispatcher processes, 5.3.4.3, 5.3.6
DISPATCHERS initialization parameter
setting attributes of, 5.3.4.1
setting initially, 5.3.4.3
distributed applications
distributing data, 33.1
distributed databases
administration overview, 31.3
application development, 31.5, 33, 33.5
client/server architectures, 31.1.3
commit point strength, 34.2.5.2
cost-based optimization, 31.5.3
database clouds, 2.7.2
direct and indirect connections, 31.1.3
distributed processing, 31.1.1.1
distributed queries, 31.4.2
distributed updates, 31.4.2, 31.4.2
forming global database names, 32.1.1
Global Data Services, 2.7.2
global object names, 31.2.9.4, 32.1
globalization support, 31.6
location transparency, 31.5.1.1, 32.6
management tools, 31.3.4
managing read consistency, 35.10
nodes of, 31.1.3
overview, 31.1.1
remote object security, 32.6.1
remote queries and updates, 31.4.1
replicated databases and, 31.1.1.2
resumable space allocation, 19.2.1.4
running in ARCHIVELOG mode, 12.2.2
running in NOARCHIVELOG mode, 12.2.2
scenarios, 32.8
schema object name resolution, 31.4.8
schema-dependent global users, 31.3.2.4.1
schema-independent global users, 31.3.2.4.2
security, 31.3.2
site autonomy of, 31.3.1
SQL transparency, 31.5.1.2
starting a remote instance, 3.1.5.8
transaction processing, 31.4
transparency, 31.5.1
distributed processing
distributed databases, 31.1.1.1
distributed queries, 31.4.2
analyzing tables, 33.4.2.2.2
application development issues, 33.4
cost-based optimization, 33.4.2
optimizing, 31.5.3
distributed systems
data encryption, 31.3.2.5
distributed transactions, 31.4.5
case study, 34.5
commit point site, 34.2.5
commit point strength, 34.2.5.2, 35.1
committing, 34.2.5.1
database server role, 34.2.2
defined, 34.1
DML and DDL, 34.1.1
failure during, 35.8.1
global coordinator, 34.2.4
local coordinator, 34.2.3
lock timeout interval, 35.8
locked resources, 35.8
locks for in-doubt, 35.8.2
manually overriding in-doubt, 35.4.2
naming, 35.2, 35.4.3.2
session trees, 34.2, 34.2.2, 34.2.3, 34.2.4, 34.2.5, 35.3.2
setting advice, 35.4.3.3
transaction control statements, 34.1.2
transaction timeouts, 35.8.1
two-phase commit, 34.5, 35.4.1
viewing database links, 35.3.1
distributed updates, 31.4.2
DML
See data manipulation language
DML error logging, inserting data with, 20.4.4
DRIVING_SITE hint, 33.4.3.2
DROP ALL STORAGE clause, 18.3.3
DROP CLUSTER statement
CASCADE CONSTRAINTS clause, 22.5
dropping cluster, 22.5
dropping cluster index, 22.5
dropping hash cluster, 23.5
INCLUDING TABLES clause, 22.5
DROP DATABASE statement, 2.10
DROP LOGFILE clause
ALTER DATABASE statement, 11.5.1
DROP LOGFILE MEMBER clause
ALTER DATABASE statement, 11.5.2
DROP PLUGGABLE DATABASE statement, 38.8
DROP SYNONYM statement, 24.3.4
DROP TABLE statement
about, 20.10
CASCADE CONSTRAINTS clause, 20.10
for clustered tables, 22.5.1
DROP TABLESPACE statement, 13.10
dropping
chain steps, 29.6.11
chains, 29.6.7
columns
marking unused, 20.6.8.2
remove unused columns, 20.6.8.2
columns in compressed tables, 20.6.8.4
data files, 14.6
data files, Oracle managed, 17.4.1
database links, 32.4.2
job classes, 29.7.1.4
jobs, 29.2.6
programs, 29.3.4
rules from chains, 29.6.9
schedules, 29.4.4
SQL patch, 9.8.3
tables
CASCADE clause, 20.10
consequences of, 20.10
temp files, 14.6
Oracle managed, 17.4.1
window groups, 29.7.4.3
windows, 29.7.3.6
dropping multiple jobs, 29.2.6.2
DUMP_ORPHAN_KEYS procedure, 25.3.2
checking sync, 25.3.2
DBMS_REPAIR package, 25.2.1
example, 25.4.4
recovering data, 25.3.4.1
dumps, 9.1.3.3

E

ECID, 9.1.2.2
editions
in CONNECT command, 1.3.2.4
managing, 18.10
e-mail notifications, Scheduler, 29.8.4
EMPHASIS resource allocation method, 27.5.5
empty tables
dropping segments, 19.4
ENABLE PLUGGABLE DATABASE clause, 37.4.1.1
ENABLE_PLUGGABLE_DATABASE initialization parameter, 37.4.2
enabling
chains, 29.6.5
jobs, 29.2.8
programs, 29.3.6
window groups, 29.7.4.6
windows, 29.7.3.8
enabling recoverer process
distributed transactions, 35.9.2
encryption
column, 20.2.13
tablespace, 13.2.4
encryption, transparent data, 2.8.2
enterprise users
definition, 31.3.2.4.2
environment variables
ORACLE_SID, 2.3.1
error logging, DML
inserting data with, 20.4.4
errors
alert log and, 8.1.1
assigning names with PRAGMA_EXCEPTION_INIT, 33.5
critical, 9.1.1
exception handler, 33.5
integrity constrain violation, 33.3
ORA-00028, 5.8.2
ORA-01090, 3.3
ORA-01173, 10.4.2
ORA-01176, 10.4.2
ORA-01177, 10.4.2
ORA-01215, 10.4.2
ORA-01216, 10.4.2
ORA-01578, 14.7
ORA-01591, 35.8.2
ORA-02049, 35.8.1
ORA-02050, 35.4.1
ORA-02051, 35.4.1
ORA-02054, 35.4.1
RAISE_APPLICATION_ERROR() procedure, 33.5
remote procedure, 33.5
rollback required, 33.3
trace files and, 8.1.1
when creating control file, 10.4.2
while starting a database, 3.1.5.5
while starting an instance, 3.1.5.5
event message
passing to event-based job, 29.5.2.5
event schedule
altering, 29.5.2.4
creating, 29.5.2.3
event-based job
altering, 29.5.2.2
creating, 29.5.2.1
passing event messages to, 29.5.2.5
events
using to start Scheduler jobs, 29.5
events (Scheduler)
overview, 29.5.1
example
setting maximum utilization limit for plans and subplans, 27.7.2
examples
managing parallel statement execution using Resource Manager, 27.7.4
exception handler, 33.5
EXCEPTION keyword, 33.5
exceptions
assigning names with PRAGMA_EXCEPTION_INIT, 33.5
integrity constraints, 18.5.5
user-defined, 33.5
executing
remote external jobs, 30.1.3
execution context identifier, 9.1.2.2
execution plans
analyzing for distributed queries, 33.4.4
export operations
restricted mode and, 3.1.5.4
expressions, calendaring, 29.4.5.1
EXTENT MANAGEMENT LOCAL clause
CREATE DATABASE, 2.4.2
extents
allocating cluster extents, 22.4
allocating for tables, 20.6.4
data dictionary views for, 19.6.2
deallocating cluster extents, 22.4
displaying free extents, 19.6.2.3
external destinations, Oracle Scheduler
about, 28.2.4
creating, 29.2.2.4.2
external jobs
retrieving stdout and stderr, 28.3.1.2.1, 28.3.1.2.2, 29.2.2.10
external jobs, Oracle Scheduler, 28.3.1.2
external procedures
credentials, 5.7.2
directory objects, 5.7.2
managing processes for, 5.7.1
external tables
altering, 20.13.3
creating, 20.13.2
defined, 20.13.1
dropping, 20.13.5
privileges required, 20.13.6
uploading data example, 20.13.2

F

fast recovery area
as archive log destination, 12.4.1.1
initialization parameters to specify, 2.5.3
with Oracle managed files, 17.2
fault diagnosability infrastructure, 9.1.1
file mapping
examples, 14.9.4
how it works, 14.9.2
how to use, 14.9.3
overview, 14.9.1
structures, 14.9.2.2
views, 14.9.3.3
file system
used for Oracle managed files, 17.1.1.2
file watchers
about, 29.5.3.1
changing detection interval, 29.5.3.5
creating, 29.5.3.3
managing, 29.5.3.5
FILE_MAPPING initialization parameter, 14.9.3.1
filenames
Oracle Managed Files, 17.3.1
files
creating Oracle Managed Files, 17.3, 17.3.6.2
finalizing
an incident package, definition, 9.10.1.1
FINISH_REDEF_TABLE procedure
dml_lock_timeout parameter, 20.7.3
FIX_CORRUPT_BLOCKS procedure
DBMS_REPAIR, 25.2.1
example, 25.4.3
marking blocks corrupt, 25.3.3.1
fixed user database links
advantages and disadvantages, 31.2.7.2
creating, 32.2.3.1
definition, 31.2.7
example, 31.2.8
Flashback Drop
about, 20.11
purging recycle bin, 20.11.4
querying recycle bin, 20.11.3
recycle bin, 20.11.1
restoring objects, 20.11.5
Flashback Table
overview, 20.9
flood-controlled incidents
defined, 9.1.2.1
viewing, 9.3
FMON background process, 14.9.2.1.1
FMPUTL external process
used for file mapping, 14.9.2.1.2
FORCE clause
COMMIT statement, 35.5
ROLLBACK statement, 35.5
force full database caching mode, 6.5
disabling, 6.5.4
enabling, 6.5.3
prerequisites, 6.5.2
FORCE LOGGING clause
CREATE CONTROLFILE, 2.4.10.1
CREATE DATABASE, 2.4.10
CREATE TABLESPACE, 13.5
performance considerations, 2.4.10.2
FORCE LOGGING mode, 20.4.2.4
forcing
COMMIT or ROLLBACK, 35.3.1, 35.4.2
forcing a log switch, 11.6
using ARCHIVE_LAG_TARGET, 11.2.6
with the ALTER SYSTEM statement, 11.6
forget phase
in two-phase commit, 34.3.3
free space
listing free extents, 19.6.2.3
tablespaces and, 13.14.3
full transportable export/import, 15.2
function-based indexes, 21.3.6

G

GDS configuration, 2.7.2
generic connectivity
definition, 31.1.2.3
global coordinators, 34.2.4
distributed transactions, 34.2.4
Global Data Services, 2.7.2
global database consistency
distributed databases and, 34.3.2.2
global database links, 31.2.6
creating, 32.2.2.3
global database names
changing the domain, 32.1.4
database links, 31.2.4
loopback, 31.2.4.1
enforcing for database links, 31.2.5
enforcing global naming, 32.1.2
forming distributed database names, 32.1.1
impact of changing, 31.4.9.1
querying, 32.1.3
global object names
database links, 31.4.7
distributed databases, 32.1
global users, 32.8.5
schema-dependent in distributed systems, 31.3.2.4.1
schema-independent in distributed systems, 31.3.2.4.2
GLOBAL_NAME view
using to determine global database name, 32.1.3
GLOBAL_NAMES initialization parameter
database links, 31.2.5
globalization support
client/server architectures, 31.6.1
distributed databases, 31.6
GRANT statement
SYSOPER/SYSDBA privileges, 1.7.3.1
granting privileges and roles
SYSOPER/SYSDBA privileges, 1.7.3.1
groups, Oracle Scheduler, 28.2.10
growth trends
of database objects, 19.7.3
GUID
PDBs, 36.1.1
GV$DBLINK view, 32.5.2

H

hash clusters
advantages and disadvantages, 23.1
altering, 23.4
choosing key, 23.3.3.1
contrasted with index clusters, 23.1
controlling space use of, 23.3.3
creating, 23.3
data dictionary views reference, 23.6
dropping, 23.5
estimating storage, 23.3.4
examples, 23.3.3.5.1
hash function, 23.1, 23.2.2, 23.3, 23.3.3.1, 23.3.3.2, 23.3.3.3
HASH IS clause, 23.3, 23.3.3.2
HASHKEYS clause, 23.3, 23.3.3.4
single-table, 23.3.2
SIZE clause, 23.3.3.3
sorted, 23.3.1
hash functions
for hash cluster, 23.1
health checks, 9.1.1
Health Monitor, 9.7
checks, 9.7.1.1
generating reports, 9.7.3
running, 9.7.2
viewing reports, 9.7.3
viewing reports using ADRCI, 9.7.3.3
heterogeneous distributed systems
definition, 31.1.2
Heterogeneous Services
overview, 31.1.2
hints, 33.4.3
DRIVING_SITE, 33.4.3.2
NO_MERGE, 33.4.3.1
using to tune distributed queries, 33.4.3
HP OpenView, 31.3.4.3
Hybrid Columnar Compression, 20.2.6

I

IBM NetView/6000, 31.3.4.3
IM column store
See In-Memory Column Store
import operations
PDBs, 15.2.3, 15.2.4
restricted mode and, 3.1.5.4
incident package
correlated, 9.10.1.3
correlated, creating, editing, and uploading, 9.10.4
correlated, deleting, 9.10.5
creating, editing and uploading custom, 9.10
customizing, 9.10.3, 9.10.3.2
defined, 9.1.1
viewing, 9.10.3.1
incident packaging service, 9.1.1
incidents
about, 9.1.2
flood-controlled, 9.1.2.1
viewing, 9.3
index clusters
See clusters
indexes
advanced index compression, 21.3.7.2
altering, 21.4
analyzing, 18.2
choosing columns to index, 21.2.2
cluster indexes, 22.3.2, 22.4.1, 22.5
coalescing, 21.2.13, 21.4.2
column order for performance, 21.2.3
creating, 21.3
data dictionary views reference, 21.7
deferred segment creation, 21.2.6
determining unusable status of, 21.4.3, 21.4.3
disabling and dropping constraints cost, 21.2.14
dropping, 21.2.5, 21.6, 21.6
estimating size, 21.2.7
estimating space use, 19.7.2
explicitly creating a unique index, 21.3.2
function-based, 21.3.6
guidelines for managing, 21.1
invisible, 21.2.11, 21.2.11
keeping when disabling constraint, 18.5.3
keeping when dropping constraint, 18.5.3
limiting for a table, 21.2.4
monitoring space use of, 21.5
monitoring usage, 21.4.6
multiple on a set of columns, 21.2.12
parallelizing index creation, 21.2.9
rebuilding, 21.2.13, 21.4.2, 21.4.2
rebuilt after direct-path INSERT, 20.4.2.5.2
renaming, 21.4.5
setting storage parameters for, 21.2.7
shrinking, 19.3.3
space used by, 21.5
statement for creating, 21.3.1
tablespace for, 21.2.8
temporary segments and, 21.2.1
unusable, 21.2.11, 21.3.8, 21.4.3
validating structure, 18.2.2
when to create, 21.2.2
index-organized tables
analyzing, 20.12.5
AS subquery, 20.12.2.6
converting to heap, 20.12.7
creating, 20.12.2
described, 20.12.1
INCLUDING clause, 20.12.2.5
maintaining, 20.12.3
ORDER BY clause, using, 20.12.6
parallel creation, 20.12.2.6
prefix compression, 20.12.2.7
rebuilding with MOVE clause, 20.12.3.2
storing nested tables, 20.12.2.3
storing object types, 20.12.2.3
threshold value, 20.12.2.4
in-doubt transactions, 34.4
after a system failure, 35.4.1
automatic resolution, 34.4.1, 34.4.1.1
deciding how to handle, 35.4
deciding whether to perform manual override, 35.4.2
defined, 34.3.1.2
manual resolution, 34.4.2
manually committing, 35.5.1
manually committing, example, 35.7
manually overriding, 35.4.2, 35.5
manually overriding, scenario, 35.7
manually rolling back, 35.5.2
overview, 34.4
pending transactions table, 35.7.6
purging rows from data dictionary, 35.6, 35.6.2
recoverer process and, 35.9.2
rolling back, 35.5, 35.5.1.1, 35.5.2, 35.5.2
SCNs and, 34.4.3
simulating, 35.9
tracing session tree, 35.3.2
viewing database links, 35.3.1
INITIAL parameter
cannot alter, 20.6.2
initialization parameter file
about, 2.5.1
creating, 2.3.4
creating by copying and pasting from alert log, 2.6.9
creating for database creation, 2.3.4
default locations, 3.1.2.1
editing before database creation, 2.5
individual parameter names, 2.5.2
sample, 2.5.1.2
search order, 3.1.2.1
server parameter file, 2.6
initialization parameters
about, 2.5.1
and database startup, 3.1.2.1
ARCHIVE_LAG_TARGET, 11.2.6.1
changing, 2.6.5.1
clearing, 2.6.6
COMMIT_POINT_STRENGTH, 34.2.5.2, 35.1
CONTROL_FILES, 2.5.4, 2.5.4, 10.2.1, 10.3.1
DB_BLOCK_CHECKING, 25.3.1.4
DB_BLOCK_CHECKSUM, 11.7, 14.7
DB_BLOCK_SIZE, 2.5.5, 13.4
DB_CACHE_SIZE, 13.4
DB_DOMA, 2.5.2
DB_DOMAIN, 2.5.2.2
DB_FILES, 14.1.1.1
DB_NAME, 2.5.2
DB_nK_CACHE_SIZE, 13.4, 15.6
DISPATCHERS, 5.3.4.3
FILE_MAPPING, 14.9.3.1
GLOBAL_NAMES, 31.2.5
LOG_ARCHIVE_DEST, 12.4.1
LOG_ARCHIVE_DEST_n, 12.4.1, 12.6.2
LOG_ARCHIVE_DEST_STATE_n, 12.4.2
LOG_ARCHIVE_MAX_PROCESSES, 12.3.4
LOG_ARCHIVE_MIN_SUCCEED_DEST, 12.6.1
LOG_ARCHIVE_TRACE, 12.7
OPEN_LINKS, 32.4.3
PROCESSES, 2.5.6
REMOTE_LOGIN_PASSWORDFILE, 1.7.2
REMOTE_OS_AUTHENT, 31.2.7.1
resetting, 2.6.6
RESOURCE_MANAGER_PLAN, 27.6, 27.6
server parameter file and, 2.6, 2.6.10
SET SQL_TRACE, 8.1.1.3
setting, 2.6.5.1
shared server and, 5.3.1
SHARED_SERVERS, 5.3.3.2
SORT_AREA_SIZE, 21.2.1
SPFILE, 2.6.4, 3.1.2.2
SQL_TRACE, 8.1.1
STATISTICS_LEVEL, 20.5
UNDO_MANAGEMENT, 2.4.4
UNDO_TABLESPACE, 2.5.8.2, 16.2.1
INITRANS parameter
altering, 20.6.2
In-Memory Column Store
compression, 6.7.1.2
enabling for a database, 6.7.3
enabling for materialized views, 6.7.6
enabling for tables, 6.7.4
enabling for tablespaces, 6.7.5
Oracle Data Pump, 6.7.7
Oracle Enterprise Manager Cloud Control, 6.7.8
population options, 6.7.1.3
INMEMORY_CLAUSE_DEFAULT parameter, 6.7.2
INMEMORY_FORCE parameter, 6.7.2
INMEMORY_MAX_POPULATE_SERVERS parameter, 6.7.2
INMEMORY_QUERY parameter, 6.7.2
INMEMORY_SIZE parameter, 6.7.2
INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT parameter, 6.7.2
INSERT statement
with DML error logging, 20.4.4
installing
patches, 1.2.10
instance caging, 27.8.1
with maximum utilization limit, 27.8.1
instances
aborting, 3.3.4
managing CPU for multiple, 27.8.1
shutting down immediately, 3.3.2
shutting down normally, 3.3.1
transactional shutdown, 3.3.3
integrity constraints
See also constraints
cost of disabling, 21.2.14
cost of dropping, 21.2.14
creating indexes associated with, 21.3.3
dropping tablespaces and, 13.10
ORA-02055 constraint violation, 33.3
INTERNAL username
connecting for shutdown, 3.3
invisible columns, 20.2.12
invisible indexes, 21.2.11, 21.2.11
IOT
See index-organized tables
IPS, 9.1.1

J

job classes
altering, 29.7.1.3
creating, 29.7.1.2
dropping, 29.7.1.4
managing Scheduler job attributes, resources, and priorities with, 29.7.1
overview, 28.2.8
viewing, 28.2.8
job coordinator, 28.4.2
job credentials, 29.2.2.3
job destination ID, defined, 29.2.5, 29.8.2
job log, Scheduler
viewing, 29.8.1
job recovery (Scheduler), 30.4.1.4
job scheduling
dependency, 28.1
event-based, 28.1
time-based, 28.1
JOB_QUEUE_PROCESSES initialization parameter, 28.4.2.2, A.1.2
jobs
altering, 29.2.3
copying, 29.2.9
creating, 29.2.2
creating and managing Scheduler, 29.2
creating for chains, 29.6.6
credentials, 28.2.6
database, 28.3.1.1
detached, 28.3.1.5
disabling, 29.2.7
dropping, 29.2.6
e-mail notifications, 29.8.4
enabling, 29.2.8
event-based, 29.5.2.1
external, 28.3.1.2
lightweight, 28.3.1.6
lightweight, example of creating, 29.2.2.2.2
monitoring, 29.8
monitoring with events raised by the Scheduler, 29.8.3
multiple-destination, 28.3.2
status of child jobs, 30.2.2
overview, 28.2.3
priorities, 29.7.2
remote database, 28.3.1.1
remote external
about, 28.3.1.2.2
running, 29.2.4
script jobs, 28.3.1.7
starting when a file arrives on a system, 29.5.3
starting with events raised by your application, 29.5.2
status, 29.8, 30.6.2
stopping, 29.2.5
troubleshooting remote, 30.4.1.3
viewing information on running, 30.2.2
join views
definition, 24.1.2.1
DELETE statements, 24.1.5.2.2
key-preserved tables in, 24.1.5.1
modifying, 24.1.5
rules for modifying, 24.1.5.2
updating, 24.1.5
joins
statement transparency in distributed databases, 32.7

K

key-preserved tables
in join views, 24.1.5.1
in outer joins, 24.1.5.3
keys
cluster, 22.1, 22.2.3
keystore, 13.2.4, 20.2.13

L

large objects, 20.3.1
lightweight jobs, 28.3.1.6
example of creating, 29.2.2.2.2
links
See database links
LIST CHAINED ROWS clause
of ANALYZE statement, 18.2.3.1
listeners
removing with srvctl, 4.4
listing database links, 32.5.1, 35.3.1, 35.3.2
loading data
using external tables, 20.13.2
LOBs, 20.3.1
local coordinators, 34.2.3
distributed transactions, 34.2.3
local users
definition, 36.1.2
locally managed tablespaces, 13.2.1
automatic segment space management in, 13.2.1.2
DBMS_SPACE_ADMIN package, 13.12
detecting and repairing defects, 13.12
migrating SYSTEM from dictionary-managed, 13.13
shrinking, temporary, 13.8.5
temp files, 13.2.5.1
temporary, creating, 13.2.5.1
location transparency in distributed databases
creating using synonyms, 32.6.2
creating using views, 32.6.1
restrictions, 32.7
using procedures, 32.6.3.3
lock timeout interval
distributed transactions, 35.8
locks
in-doubt distributed transactions, 35.8, 35.8.2
monitoring, 8.2.1
log
window (Scheduler), 29.7.3
log sequence number
control files, 11.1.3.2
log switches
description, 11.1.3.2
forcing, 11.6, 11.6
log sequence numbers, 11.1.3.2
multiplexed redo log files and, 11.2.1.1
privileges, 11.6
using ARCHIVE_LAG_TARGET, 11.2.6
waiting for archiving to complete, 11.2.1.1
log writer process (LGWR), 5.5
multiplexed redo log files and, 11.2.1.1
online redo logs available for use, 11.1.3
trace files and, 11.2.1.1
writing to online redo log files, 11.1.3
LOG_ARCHIVE_DEST initialization parameter
specifying destinations using, 12.4.1
LOG_ARCHIVE_DEST_n initialization parameter, 12.4.1
REOPEN attribute, 12.6.2
LOG_ARCHIVE_DEST_STATE_n initialization parameter, 12.4.2
LOG_ARCHIVE_DUPLEX_DEST initialization parameter
specifying destinations using, 12.4.1
LOG_ARCHIVE_MAX_PROCESSES initialization parameter, 12.3.4
LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter, 12.6.1
LOG_ARCHIVE_TRACE initialization parameter, 12.7
LOGGING clause
CREATE TABLESPACE, 13.5
logging mode
direct-path INSERT, 20.4.2.4
NOARCHIVELOG mode and, 20.4.2.4.1
logging_clause, 38.1.2.7, 42.3.1.1
logical corruptions from DBMS_REPAIR, 25.3.2
logical standby, 28.5
logical volume managers
mapping files to physical devices, 14.9, 14.9.4.3
used for Oracle Managed Files, 17.1.1.1
LOGON trigger
setting resumable mode, 19.2.3
logs
job, 30.2.3
window (Scheduler), 29.7.3, 30.2.3
LONG columns, 32.7
LONG RAW columns, 32.7

M

maintenance tasks, automatic
See automatic maintenance tasks
maintenance window
creating, 26.4.2
definition, 26.1
MAINTENANCE_WINDOW_GROUP, 26.2
modifying, 26.4.1
predefined, 26.6.1
removing, 26.4.3
Scheduler, 26.2
managing
sequences, 24.2.1
space threshold alerts for the undo tablespace, 16.5.6
synonyms, 24.3.1
tables, 20
views, 24.1
manual archiving
in ARCHIVELOG mode, 12.3.3
manual overrides
in-doubt transactions, 35.5
materialized views
In-Memory Column Store, 6.7.6
materializing deferred segments, 20.2.15
MAXDATAFILES parameter
changing, 10.3.3.2
MAXINSTANCES, 10.3.3.2
MAXLOGFILES parameter
changing, 10.3.3.2
CREATE DATABASE statement, 11.2.5
MAXLOGHISTORY parameter
changing, 10.3.3.2
MAXLOGMEMBERS parameter
changing, 10.3.3.2
CREATE DATABASE statement, 11.2.5, 11.2.5
MAXTRANS parameter
altering, 20.6.2
media recovery
effects of archiving on, 12.2.1
migrated rows
eliminating from table, procedure, 18.2.3.2
MINEXTENTS parameter
cannot alter, 20.6.2
mirrored files
control files, 2.5.4, 10.2.2
online redo log, 11.2.1.1
online redo log location, 11.2.2
online redo log size, 11.2.3
MISSING data files, 10.4.1
monitoring
performance, 8.2
running chains, 29.6.17
MONITORING clause
CREATE TABLE, 20.5
MONITORING USAGE clause
of ALTER INDEX statement, 21.4.6
mounting a database, 3.1.5.3
moving control files, 10.3.2
multiple instances, managing CPU for, 27.8.1
multiple jobs
dropping, 29.2.6.2
multiple temporary tablespaces, 13.2.6, 13.2.6.3
multiple-destination jobs, Oracle Scheduler, 28.3.2
status of child jobs, 30.2.2
multiplexed control files
importance of, 10.2.2
multiplexing
archived redo log files, 12.4.1
control files, 10.2.2
redo log file groups, 11.2.1
redo log files, 11.2.1, 11.2.1
multitenant architecture, 35.10, 36.1
purpose of, 36.2
multitenant container databases
See CDBs
multitenant environment, 36.1

N

name resolution in distributed databases
database links, 31.4.7
impact of global name changes, 31.4.9.1
procedures, 31.4.9
schema objects, 31.2.9.4, 31.4.8
synonyms, 31.4.9
views, 31.4.9
when global database name is complete, 31.4.7.1
when global database name is partial, 31.4.7.2
when no global database name is specified, 31.4.7.3
named user limits
setting initially, 2.5.10
networks
connections, minimizing, 32.3
distributed databases use of, 31.1.1
NEXT parameter
altering, 20.6.2
NEXTVAL pseudo-column, 24.2.4.1, 24.2.4.1.1
restrictions, 24.2.4.1.3
NO DATA clause, 38.1.2.9, 38.4.2
NO_DATA_FOUND keyword, 33.5
NO_MERGE hint, 33.4.3.1
NOARCHIVELOG mode
archiving, 12.2
definition, 12.2.1
dropping data files, 14.4.2
LOGGING mode and, 20.4.2.4.1
media failure, 12.2.1
no hot backups, 12.2.1
running in, 12.2.1
switching to, 12.3.2
taking data files offline in, 14.4.2
NOCACHE option
CREATE SEQUENCE statement, 24.2.4.2.2
NOLOGGING clause
CREATE TABLESPACE, 13.5
NOLOGGING mode
direct-path INSERT, 20.4.2.4
noncdb_to_pdb.sql script, 38.4.3, 38.6.1.2
non-CDBs
cloning as PDBs, 38.4
moving to PDBs, 38.6
normal transmission mode
definition, 12.5.1
Novell NetWare Management System, 31.3.4.3

O

object privileges
for external tables, 20.13.6
objects
See schema objects
offline tablespaces
priorities, 13.6.1
taking offline, 13.6.1
online redefinition of tables, 20.7
abort and cleanup, 20.7.6
examples, 20.7.9
features of, 20.7.1
intermediate synchronization, 20.7.5
redefining a single partition
rules for, 20.7.8.1
redefining partitions, 20.7.8
restrictions, 20.7.7
Virtual Private Database policies, 20.7.3.2
with DBMS_REDEFINITION, 20.7.3
online redo log files
See online redo logs
online redo logs
See also redo log files
creating groups, 11.3
creating members, 11.3.2
data dictionary views reference, 11.9
dropping groups, 11.5
dropping members, 11.5
forcing a log switch, 11.6
guidelines for configuring, 11.2
INVALID members, 11.5.2
location of, 11.2.2
managing, 11
moving files, 11.4
number of files in the, 11.2.5
optimum configuration for the, 11.2.5
renaming files, 11.4
renaming members, 11.4
specifying ARCHIVE_LAG_TARGET, 11.2.6
STALE members, 11.5.2
online segment shrink, 19.3.3
open modes
PDBs, 40.4.5
OPEN_LINKS initialization parameter, 32.4.3
opening windows, 29.7.3.4
operating system authentication, 1.6.3.2
operating systems
database administrators requirements for, 1.5.1
renaming and relocating files, 14.5.2
OPTIMIZER_INMEMORY_AWARE parameter, 6.7.2
ORA-01013 error message, 3.3.5
ORA-02055 error
integrity constraint violation, 33.3
ORA-02067 error
rollback required, 33.3
ORA-12838 error, direct path insert, 20.4.2.3.2
Oracle Call Interface
See OCI
Oracle Data Guard
CDBs, 40.1.2
support by the Scheduler, 28.5, 30.5.5
Oracle Data Pump
In-Memory Column Store, 6.7.7
Oracle Database
release numbers, 1.4.1
Oracle Database users
types of, 1.1
Oracle Database Vault
CDBs, 40.1.2
Oracle Enterprise Manager Cloud Control, 3.1.1.3
In-Memory Column Store, 6.7.8
Oracle Enterprise Manager Database Express
CDBs, 37.5
Oracle home
cloning, 1.2.11
Oracle managed files
naming, 17.3.1
scenarios for using, 17.5
Oracle Managed Files, 37.4.1.2.2
adding to an existing database, 17.5.3
behavior, 17.4
benefits, 17.1.2
CREATE DATABASE statement, 17.3.2
creating, 17.3
creating control files, 17.3.5
creating data files, 17.3.3
creating online redo log files, 17.3.6
creating temp files, 17.3.4
described, 17.1
dropping data file, 17.4.1
dropping online redo log files, 17.4.2
dropping temp file, 17.4.1
initialization parameters, 17.2
introduction, 2.4.7
renaming, 17.4.3
Oracle Managed Files feature
See Oracle managed files
Oracle Multitenant option, 35.10
Oracle Restart
about, 4.1.1
configuration
adding components to, 4.2.3
modifying, 4.2.8
removing components from, 4.2.4
viewing for a component, 4.2.7
configuring, 4.2
CRSCTL utility, 4.1.4
disabling and enabling management for a component, 4.2.5
environment variables in, 4.2.9
patches
installing, 4.3
registering a component with, 4.2.3
starting, 4.1.4
starting and stopping components managed by, 4.3
Oracle home, 4.3
status of components, 4.2.6
stopping, 4.1.4
Oracle Scheduler
creating credentials, 29.2.2.3
Oracle Scheduler agent
on Windows, 30.1.3.3.2
OracleSchedulerExecutionAgent, 30.1.3.3.2
tasks, 30.1.3.3
Windows Service, 30.1.3.3.2
Oracle Scheduler Agent, 30.1.3
Oracle Scheduler agents
registering with databases, 30.1.3.3.5
Oracle Universal Installer, 2.1, 37.1
ORACLE_SID environment variable, 2.3.1
OracleSchedulerExecutionAgent, 30.1.3.3.2
ORADIM
creating an instance, 2.3.5
enabling automatic instance startup, 2.3.14
oraenv and coraenv, 1.3.2.2
ORAPWD utility, 1.7.1
ORGANIZATION EXTERNAL clause
of CREATE TABLE, 20.13.2
orphan key table
example of building, 25.4.1.2
OSBACKUPDBA group, 1.6.3.1
OSDBA group, 1.6.3.1
OSDGDBA group, 1.6.3.1
OSKMDBA group, 1.6.3.1
OSOPER group, 1.6.3.1
OTHER_GROUPS
for Database Resource Manager, 27.1.2.1
OTHER_GROUPS for Database Resource Manager, 27.5.6, 27.5.7, 27.7.5
outer joins, 24.1.5.3
key-preserved tables in, 24.1.5.3
overlapping windows, 28.2.9.1

P

package
See incident package
packages
DBMS_FILE_TRANSFER, 14.7
DBMS_METADATA, 18.11.1
DBMS_REDEFINITION, 20.7.2, 20.7.3, 20.7.10, 20.7.10
DBMS_REPAIR, 25.2
DBMS_RESOURCE_MANAGER, 27.1.2, 27.1.3, 27.1.3, 27.2.4.1
DBMS_RESOURCE_MANAGER_PRIVS, 27.1.3, 27.1.3
DBMS_RESUMABLE, 19.2.4.3
DBMS_SPACE, 19.3.4, 19.6.1
DBMS_STATS, 18.2.1, 20.5
DBMS_STORAGE_MAP, 14.9.3.2, 14.9.3.3
packaging and uploading problems, 9.10.2
parallel execution
managing, 5.6
parallel hints, 5.6, 5.6
parallelizing index creation, 21.2.9
resumable space allocation, 19.2.1.5
parallel hints, 5.6, 5.6
parallel statement execution
directive attributes for managing, 27.7.4
managing using Resource Manager, 27.3.3.3
PARALLEL_DEGREE_LIMIT_ABSOLUTE resource allocation method, 27.5.5
parallelizing table creation, 20.2.4, 20.3.3
parameter files
See initialization parameter file
partitioned tables, 20.2.2
moving a partition online, 20.6.3.2
redefining partitions online, 20.7.8
rules for, 20.7.8.1
password
setting for SYSTEM account in CREATE DATABASE statement, 2.4.1
setting SYS in CREATE DATABASE statement, 2.4.1
password file
adding users, 1.7.3
creating, 1.7.1
ORAPWD utility, 1.7.1
removing, 1.7.4.2
setting REMOTE_LOGIN_PASSWORD, 1.7.2
synchronizing administrator passwords with the data dictionary, 1.7.2.2
viewing members, 1.7.3.2
password file authentication, 1.6.4.1
passwords
case sensitivity of, 1.6.2, 1.6.4.1, 1.6.4.2
password file, 1.7.3
setting REMOTE_LOGIN_PASSWORD parameter, 1.7.2
patches
installing, 1.2.10
Oracle Restart, 4.3
PATH_PREFIX clause, 38.1.2.3
pausing chains and chain steps, 29.6.14
PCTINCREASE parameter, 20.6.2
PDB resource plans, 44.1.3
PDB_FILE_NAME_CONVERT initialization parameter, 37.4.1.2.3
pdb_force_logging_clause, 42.3.1.1
PDB_PLUG_IN_VIOLATIONS view, 40.4.5.1
pdb_save_or_discard_state clause, 40.4.6
PDBs, 35.10, 36.1
administering, 42
ALTER SYSTEM statement, 42.4
CDB resource plans, 44.1.2
creating, 44.3
directives, 44.1.2.4
disabling, 44.4.2
enabling, 44.4.1
managing, 44.7.1
shares, 44.1.2.2
utilization limits, 44.1.2.3
viewing information about, 44.8
cloning, 38.4
compatibility violations, 40.4.5.1
connecting to, 40.2, 42.2
ALTER SESSION statement, 40.2.2
CONNECT command, 40.2.1
creating using the seed, 38.3
current container, 40.1.1
Database Resource Manager, 44
DBMS_SQL package, 40.3
definition, 36.1
dropping, 38.8
EM Express, 37.5
executing PL/SQL code, 40.3
GUID, 36.1.1
import operations, 15.2.3, 15.2.4
modifying, 42.3
moving non-CDBs into, 38.6, 38.6.1
open mode, 40.4.5, 43.6
preserving on restart, 40.4.6
PDB resource plans, 44.1.3
creating, 44.5
disabling, 44.6.2
modifying, 44.7.2
PDBs resource plans
enabling, 44.6.1
plugging in, 38.5
CREATE PLUGGABLE DATABASE statement, 38.1.2
methods for, 38.1.1
preparing for, 38.2
prerequisites for, 36.3
purpose of, 36.2
renaming, 42.3.1.3
services, 42.5
SHUTDOWN command, 42.3.2, 42.3.2.2
shutting down, 40.8
STARTUP command, 40.4.5.3, 42.3.2, 42.3.2.1
tools for, 36.4.2
unplugging, 38.7
views, 43.2
pending area for Database Resource Manager plans, 27.5.9
validating plan schema changes, 27.5.7
pending transaction tables, 35.7.6
performance
index column order, 21.2.3
location of data files and, 14.1.3
monitoring, 8.2
plan schemas for Database Resource Manager, 27.3.1.1, 27.6, 27.9.4
validating plan changes, 27.5.7
plans for Database Resource Manager
examples, 27.7
PL/SQL
replaced views and program units, 24.1.3
pluggable databases
See PDBs
PRAGMA_EXCEPTION_INIT procedure
assigning exception names, 33.5
predefined user accounts, 2.8.1
prefix compression, 20.12.2.7, 21.3.7.1
prepare phase
abort response, 34.3.1.1.3
in two-phase commit, 34.3.1
prepared response, 34.3.1.1.1
read-only response, 34.3.1.1.2
recognizing read-only nodes, 34.3.1.1.2
steps, 34.3.1.2
prepare/commit phases
effects of failure, 35.8.1
failures during, 35.4.1
locked resources, 35.8
pending transaction table, 35.7.6
prepared response
two-phase commit, 34.3.1.1.1
prerequisites
for creating a database, 2.1.1.2
PRIMARY KEY constraints
associated indexes, 21.3.3.1
dropping associated indexes, 21.6
enabling on creation, 21.3.3
foreign key references when dropped, 18.5.3.1
indexes associated with, 21.3.3
priorities
job, 29.7.2
private database links, 31.2.6
private synonyms, 24.3.1
privileges
adding redo log groups, 11.3
altering index, 21.4
altering tables, 20.6
closing a database link, 33.2
creating database links, 32.2.1
creating tables, 20.3
creating tablespaces, 13.2
database administrator, 1.5
drop table, 20.10
dropping indexes, 21.6
dropping online redo log members, 11.5.2
dropping redo log groups, 11.5.1
enabling and disabling triggers, 18.4
for external tables, 20.13.6
forcing a log switch, 11.6
managing with procedures, 32.6.3.4
managing with synonyms, 32.6.2.2
managing with views, 32.6.1
manually archiving, 12.3.3
renaming objects, 18.6
renaming redo log members, 11.4
RESTRICTED SESSION system privilege, 3.1.5.4
Scheduler, 30.6.1
sequences, 24.2.2, 24.2.2, 24.2.5
setting chain (Scheduler), 30.1.1
synonyms, 24.3.2, 24.3.4
taking tablespaces offline, 13.6.1
truncating, 18.3.3
using a view, 24.1.4
using sequences, 24.2.4
views, 24.1.2, 24.1.3, 24.1.7
problem activity log
adding comments to, 9.2.7
problems
about, 9.1.2
adding comments to activity log, 9.2.7
problems (critical errors)
packaging and uploading, 9.10.2
procedures
external, 5.7.1
location transparency in distributed databases, 32.6.3
name resolution in distributed databases, 31.4.9
remote calls, 31.5.2
process monitor (PMON), 5.5
processes
See server processes
PROCESSES initialization parameter
setting before database creation, 2.5.6
PRODUCT_COMPONENT_VERSION view, 1.4.2
programs
altering, 29.3.3
creating, 29.3.2
creating and managing, to define Scheduler jobs, 29.3
disabling, 29.3.5
dropping, 29.3.4
enabling, 29.3.6
overview, 28.2.1
public database links, 31.2.6
connected user, 32.8.3
fixed user, 32.8.1
public fixed user database links, 32.8.1
public synonyms, 24.3.1
PURGE_LOST_DB_ENTRY procedure
DBMS_TRANSACTION package, 35.6.1

Q

queries
distributed, 31.4.2
distributed application development issues, 33.4
location transparency and, 31.5.1.2
remote, 31.4.1
question mark, 2.3.11
quiescing a database, 3.4
quotas
tablespace, 13.1.2

R

RAISE_APPLICATION_ERROR() procedure, 33.5
read consistency
managing in distributed databases, 35.10
read-only database
opening, 3.2.3
read-only databases
limitations, 3.2.3
read-only response
two-phase commit, 34.3.1.1.2
read-only tables, 20.6.9
read-only tablespaces
data file headers when rename, 13.9
delaying opening of data files, 13.7.4
making read-only, 13.7.1
making writable, 13.7.2
WORM devices, 13.7.3
Real Application Clusters
allocating extents for cluster, 22.4
sequence numbers and, 24.2.2
threads of online redo log, 11.1.1
rebuilding indexes, 21.4.2
costs, 21.2.13
online, 21.4.2
reclaiming unused space, 19.3
RECOVER clause
STARTUP command, 3.1.5.6
recoverer process, 5.5
disabling, 35.9.2
distributed transaction recovery, 35.9.2
enabling, 35.9.2
pending transaction table, 35.9.2
recovering
Scheduler jobs, 30.4.1.4
recovery
creating new control files, 10.3.3.2
Recovery Manager
starting a database, 3.1.1.2
starting an instance, 3.1.1.2
recycle bin
about, 20.11.1
purging, 20.11.4
renamed objects, 20.11.1
restoring objects from, 20.11.5
viewing, 20.11.3
REDEF_TABLE procedure, 20.7.2
example, 20.7.9
redefining tables online
See online redefinition of tables
redo log files
See also online redo logs
active (current), 11.1.3.1
archiving, 12.2
available for use, 11.1.3
block size, setting, 11.2.4
circular use of, 11.1.3
clearing, 11.2.1.1, 11.8
contents of, 11.1.2
creating as Oracle Managed Files, 17.3.6
creating as Oracle Managed Files, example, 17.5.1
creating groups, 11.3
creating members, 11.3, 11.3.2
distributed transaction information in, 11.1.3
dropping groups, 11.5
dropping members, 11.5
group members, 11.2.1
groups, defined, 11.2.1
how many in redo log, 11.2.5
inactive, 11.1.3.1, 11.1.3.1
instance recovery use of, 11.1
legal and illegal configurations, 11.2.1.2
LGWR and the, 11.1.3
log switches, 11.1.3.2
maximum number of members, 11.2.5
members, 11.2.1
mirrored, log switches and, 11.2.1.1
multiplexed, 11.2.1, 11.2.1, 11.2.1.1
online, defined, 11.1
planning the, 11.2
redo entries, 11.1.2
requirements, 11.2.1.2
specifying at database creation, 17.3.2.2
storing separately from data files, 14.1.4
threads, 11.1.1
unavailable when database is opened, 3.1.5
verifying blocks, 11.7
redo logs
See online redo log
redo records, 11.1.2
LOGGING and NOLOGGING, 13.5
referential integrity
distributed database application development, 33.3
release number format, 1.4.1
releases, 1.4.1
checking the Oracle Database release number, 1.4.2
relocating control files, 10.3.2
remote data
querying, 32.7
updating, 32.7
remote database jobs, 28.3.1.1
Scheduler agent setup, 30.1.3.2
remote external jobs
about, 28.3.1.2.2
executing, 30.1.3
Scheduler agent setup, 30.1.3.2
remote procedure calls, 31.5.2, 31.5.2
distributed databases and, 31.5.2
remote queries
distributed databases and, 31.4.1
remote transactions, 31.4.4
defined, 31.4.4
REMOTE_LOGIN_PASSWORDFILE initialization parameter, 1.7.2
REMOTE_OS_AUTHENT initialization parameter
connected user database links, 31.2.7.1
RENAME statement, 18.6
renaming control files, 10.3.2
renaming files
Oracle Managed Files, 17.4.3
renaming indexes, 21.4.5
REOPEN attribute
LOG_ARCHIVE_DEST_n initialization parameter, 12.6.2
repair table
example of building, 25.4.1.1
repairing data block corruption
DBMS_REPAIR, 25.1
repeat interval, schedule, 29.4.5
RESIZE clause
for single-file tablespace, 13.8.3
resource allocation methods
active session pool, 27.5.5
ACTIVE_SESS_POOL_MTH, 27.5.5
CPU, 27.3.1
CPU resource, 27.5.5, 27.5.5
EMPHASIS, 27.5.5
limit on degree of parallelism, 27.5.5
MAX_UTILIZATION_METHOD, 27.3.1.2
PARALLEL_DEGREE_LIMIT_ABSOLUTE, 27.5.5
PARALLEL_DEGREE_LIMIT_MTH, 27.5.5
PARALLEL_DEGREE_LIMIT_P1, 27.3.3.1
PARALLEL_QUEUE_TIMEOUT, 27.3.3.3
PARALLEL_STMT_CRITICAL, 27.3.3.2
QUEUEING_MTH, 27.5.5
queuing resource allocation method, 27.5.5
ROUND-ROBIN, 27.5.3
resource consumer groups, 27.1.2
changing, 27.2.4.1
creating, 27.5.3
DEFAULT_CONSUMER_GROUP, 27.2.6, 27.9.2
deleting, 27.9.2
granting the switch privilege, 27.2.6
managing, 27.2, 27.2.4.2
OTHER_GROUPS, 27.1.2.1, 27.5.6, 27.5.7, 27.7.5
parameters, 27.5.3
revoking the switch privilege, 27.2.6.2
setting initial, 27.2.2
switching a session, 27.2.4.1.1
switching sessions for a user, 27.2.4.1.2
SYS_GROUP, 27.7.5
updating, 27.9.1
Resource Manager
AUTO_TASK_CONSUMER_GROUP consumer group, 26.5
managing parallel statement execution, 27.3.3.3
resource plan directives, 27.1.2, 27.5.7
deleting, 27.9.6
for managing parallel statement execution, 27.7.4
specifying, 27.5.6
updating, 27.9.5
resource plans, 27.1.2, 27.1.2.6
CDB, 44.1.2
creating, 27.4
DEFAULT_MAINTENANCE_PLAN, 26.5.1
DELETE_PLAN_CASCADE, 27.9.4
deleting, 27.9.4
examples, 27.7
parameters, 27.5.5
PDB, 44.1.3
plan schemas, 27.3.1.1, 27.6, 27.9.4
SYSTEM_PLAN, 27.7.5
top plan, 27.5.7, 27.6
updating, 27.9.3
validating, 27.5.7
RESOURCE_MANAGER_PLAN initialization parameter, 27.6, 27.6
RESTRICTED SESSION system privilege
restricted mode and, 3.1.5.4
resumable space allocation
correctable errors, 19.2.1.3
detecting suspended statements, 19.2.4
disabling, 19.2.2
distributed databases, 19.2.1.4
enabling, 19.2.2
example, 19.2.6
how resumable statements work, 19.2.1.1
naming statements, 19.2.2.2.2
parallel execution and, 19.2.1.5
resumable operations, 19.2.1.2
setting as default for session, 19.2.3
timeout interval, 19.2.2.2.1, 19.2.4.1
RESUMABLE_TIMEOUT initialization parameter, 19.2.1.1
setting, 19.2.2.1
retention guarantee (for undo), 16.2.2.2
reversing table changes, 20.8
RMAN
See Recovery Manager
roles
DBA role, 1.5.2.4
obtained through database links, 31.2.10
ROLLBACK statement
FORCE clause, 35.5, 35.5.1.1, 35.5.2
forcing, 35.4.2
rollbacks
ORA-02, 33.3
rolling upgrade, 28.5
root container
definition, 36.1.1
modifying, 40.4.4
ROUND-ROBIN resource allocation method, 27.5.3
rows
listing chained or migrated, 18.2.3
rules
adding to a chain, 29.6.4
dropping from chains, 29.6.9
running
chains, 29.6.8
jobs, 29.2.4
SQL Repair Advisor, 9.8.2

S

Sample Schemas
description, 2.8.5
savepoints
in-doubt transactions, 35.5, 35.5.2
schagent utility, 30.1.3.3.1
Scheduler
administering, 30
architecture, 28.4
CDB, 46.1
closing a PDB, 46.4
configuring, 30.1
credentials for jobs, 28.2.6
data dictionary views reference, 30.6.2
e-mail notifications, 29.8.4
examples of using, 30.5
import and export, 30.3
invocations to CDB, 46.1
maintenance window, 26.2
monitoring and managing, 30.2
monitoring jobs, 29.8
objects, 28.2
overview, 28.1
security, 30.2.4
support for Oracle Data Guard, 28.5, 30.5.5
troubleshooting, 30.4
job does not run, 30.4.1
using in RAC, 28.4.5
using job coordinator in CDB, 46.2
using slave processes in CDB, 46.2
Views, new and changed, 46.5
Scheduler agent, 30.1.3
configuration, 30.1.3.2
installation, 30.1.3.2
setup, 30.1.3.2
Scheduler chain condition syntax, 29.6.4
Scheduler job credentials
specifying, 29.2.2.3
Scheduler objects, naming, 29.1
Scheduler privileges reference, 30.6.1
SCHEDULER_BATCH_ERRORS view, 29.2.6.2
schedules
altering, 29.4.3
creating, 29.4.2
creating and managing, to define Scheduler jobs, 29.4
dropping, 29.4.4
overview, 28.2.2
schema objects
analyzing, 18.2
creating multiple objects, 18.1
data dictionary views reference, 18.11.2
defining using DBMS_METADATA package, 18.11.1
dependencies between, 18.7
distributed database naming conventions for, 31.2.9.4
global names, 31.2.9.4
listing by type, 18.11.2.1
name resolution in distributed databases, 31.2.9.4, 31.4.8
name resolution in SQL statements, 18.8
privileges to rename, 18.6
referencing with synonyms, 32.6.2.1
renaming, 18.6, 18.6
validating structure, 18.2.2
viewing information, 18.11, 19.6
schema objects space usage
data dictionary views reference, 19.6.2
SCN
See system change number
SCOPE clause
ALTER SYSTEM SET, 2.6.5.1
script jobs, 28.3.1.7
scripts, authenticating users in, 2.8.3
security
accessing a database, 7.1
administrator of, 7.1
centralized user management in distributed databases, 31.3.2.4
database security, 7.1
distributed databases, 31.3.2
establishing policies, 7
privileges, 7.1
remote objects, 32.6.1
Scheduler, 30.2.4
using synonyms, 32.6.2.2
SEED FILE_NAME_CONVERT clause, 37.4.1.2.1
seed PDB, 36.1.1
Segment Advisor, 19.3.2
configuring Scheduler job, 19.3.2.4
invoking with Oracle Enterprise Manager Cloud Control, 19.3.2.2.1
invoking with PL/SQL, 19.3.2.2.2
running manually, 19.3.2.2
viewing results, 19.3.2.3
views, 19.3.2.5
SEGMENT_FIX_STATUS procedure
DBMS_REPAIR, 25.2.1
segments
available space, 19.6.1
data dictionary views for, 19.6.2
deallocating unused space, 19.3
displaying information on, 19.6.2.1
dropping for empty tables, 19.4
shrinking, 19.3.3
SELECT statement
FOR UPDATE clause and location transparency, 32.7
SEQUENCE_CACHE_ENTRIES parameter, 24.2.4.2.2
sequences
accessing, 24.2.4
altering, 24.2.3
caching sequence numbers, 24.2.4.2
creating, 24.2.2, 24.2.4.2.2, 24.2.4.2.2
CURRVAL, 24.2.4.1.2
data dictionary views reference, 24.4
dropping, 24.2.5
managing, 24.2.1
NEXTVAL, 24.2.4.1.1
Oracle Real Applications Clusters and, 24.2.2
SERVER parameter
net service name, 32.3.3.1
server parameter file
creating, 2.6.3
defined, 2.6.1
exporting, 2.6.7
migrating to, 2.6.2
recovering, 2.6.9
RMAN backup, 2.6.8
setting initialization parameter values, 2.6.5
SPFILE initialization parameter, 2.6.4
STARTUP command behavior, 2.6.1
viewing parameter settings, 2.6.10
server processes
archiver (ARCn), 5.5
background, 5.5
checkpoint (CKPT), 5.5
database writer (DBWn), 5.5
dedicated, 5.1.1
dispatcher (Dnnn), 5.5
dispatchers, 5.3.4.3
log writer (LGWR), 5.5
monitoring locks, 8.2.1
process monitor (PMON), 5.5
recoverer (RECO), 5.5
shared server, 5.1.2
system monitor (SMON), 5.5
trace files for, 8.1.1
server-generated alerts, 8.1.2
servers
role in two-phase commit, 34.2.2
service names
database links and, 32.2.4
services
controlling automatic startup of, 3.1.3
creating with SRVCTL and Oracle Restart, 4.2.10
PDBs, 42.5
role-based, 3.1.3
session trees for distributed transactions
clients, 34.2.1
commit point site, 34.2.5, 34.2.5.2
database servers, 34.2.2
definition, 34.2
global coordinators, 34.2.4
local coordinators, 34.2.3
tracing transactions, 35.3.2
sessions
active, 5.8.2
inactive, 5.8.3
setting advice for transactions, 35.4.3.3
terminating, 5.8
SET TIME_ZONE clause
ALTER SESSION, 2.4.9.1
CREATE DATABASE, 2.4.9.1
SET TRANSACTION statement
naming transactions, 35.2
SGA
See system global area
shared database links
configuring, 32.3.3
creating, 32.3.2
dedicated servers, creating links to, 32.3.3.1
determining whether to use, 32.3.1
example, 31.2.8
shared servers, creating links to, 32.3.3.2
SHARED keyword
CREATE DATABASE LINK statement, 32.3.2
shared server, 5.1.2
configuring dispatchers, 5.3.4
data dictionary views reference, 5.3.6
disabling, 5.3.3.2, 5.3.5
initialization parameters, 5.3.1
interpreting trace output, 8.1.1.4
setting minimum number of servers, 5.3.3.2
trace files for processes, 8.1.1
shared SQL
for remote and distributed statements, 31.4.3
shrinking segments online, 19.3.3
shutdown
default mode, 3.3.1
SHUTDOWN command
closing a PDB, 42.3.2
IMMEDIATE clause, 3.3.2
interrupting, 3.3.5
NORMAL clause, 3.3.1
PDBs, 42.3.2.2
shutting down an instance
CDBs, 40.8
Simple Network Management Protocol (SNMP) support
database management, 31.3.4.3
single-file tablespaces
description, 13.2.2
single-instance
defined, 2.3
single-table hash clusters, 23.3.2
site autonomy
distributed databases, 31.3.1
SKIP_CORRUPT_BLOCKS procedure, 25.3.3.1
DBMS_REPAIR, 25.2.1
example, 25.4.5
skipping chain steps, 29.6.15
SNAPSHOT COPY clause, 38.4.1
snapshot too old error, 16.2.2.1
SORT_AREA_SIZE initialization parameter
index creation and, 21.2.1
SOURCE_FILE_NAME_CONVERT clause, 38.1.2.4
space
deallocating unused, 19.3.4
reclaiming unused, 19.3
space allocation
resumable, 19.2
space management
data types, space requirements, 19.5
deallocating unused space, 19.3
Segment Advisor, 19.3
shrink segment, 19.3
space usage alerts for tablespaces, 19.1.1
SPACE_ERROR_INFO procedure, 19.2.4.1
SPFILE initialization parameter, 2.6.4
specifying from client system, 3.1.2.2
SQL
submitting, 1.3
SQL failure
repairing with SQL Repair Advisor, 9.8
SQL patch
disabling, 9.8.3
removing, 9.8.3
viewing, 9.8.3
SQL Repair Advisor
about, 9.8.1
repairing SQL failure with, 9.8
running, 9.8.2
SQL scripts
CDBs, 40.7
SQL statements
distributed databases and, 31.4.1
SQL test case builder, 9.1.1
SQL*Loader
about, 1.8, 20.4.1
SQL*Plus, 1.3
about, 1.3.1
connecting with, 1.3.2
starting, 3.1.4
starting a database, 3.1.1.1
starting an instance, 3.1.1.1
SQL_TRACE initialization parameter
trace files and, 8.1.1
SRVCTL
add asm command, 4.4
add command, usage description, 4.4
add database command, 4.4
add listener command, 4.4
add ons command, 4.4
adding a disk group with, 4.4
case sensitivity, 4.4, 4.4
case sensitivity of commands, 4.4, 4.4
command reference, 4.4
commands
downgrade database, 4.4
upgrade database, 4.4, 4.4
commands, case sensitivity, 4.4, 4.4
component names, 4.4
config asm command, 4.4
config command, usage description, 4.4
config database command, 4.4
config listener command, 4.4
config ons command, 4.4
config service command, 4.4
creating and deleting databases services with, 4.2.10
disable asm command, 4.4
disable command, usage description, 4.4
disable database command, 4.4
disable diskgroup command, 4.4
disable listener command, 4.4
disable ons command, 4.4
disable service command, 4.4
enable asm command, 4.4
enable command, usage description, 4.4
enable database command, 4.4
enable diskgroup command, 4.4
enable listener command, 4.4
enable ons command, 4.4
enable service command, 4.4
getenv asm command, 4.4
getenv command, usage description, 4.4
getenv database command, 4.4
getenv listener command, 4.4
help for, 4.2.2
modify asm command, 4.4
modify command, usage description, 4.4
modify database command, 4.4
modify listener command, 4.4
modify ons command, 4.4
modify service command, 4.4
preparing to run, 4.2.1
reference, 4.4
remove asm command, 4.4
remove command, usage description, 4.4
remove database command, 4.4
remove diskgroup command, 4.4
remove listener command, 4.4
remove ons command, 4.4
remove service command, 4.4
setenv asm command, 4.4
setenv command, usage description, 4.4
setenv database command, 4.4
setenv listener command, 4.4
start asm command, 4.4
start command, usage description, 4.4
start database command, 4.4
start diskgroup command, 4.4
start home command, 4.4
start listener command, 4.4
start ons command, 4.4
start service command, 4.4
status asm command, 4.4
status command, usage description, 4.4
status database command, 4.4
status diskgroup command, 4.4
status home command, 4.4
status listener command, 4.4
status ons command, 4.4
status service command, 4.4
stop asm command, 4.4
stop command, usage description, 4.4
stop database command, 4.4
stop diskgroup command, 4.4
stop home command, 4.4
stop listener command, 4.4
stop ons command, 4.4
stop service command, 4.4
unsetenv asm command, 4.4
unsetenv command, usage description, 4.4
unsetenv database command, 4.4
unsetenv listener command, 4.4
SRVCTL stop option
default, 3.3.1
STALE status
of redo log members, 11.5.2
stalled chain (Scheduler), 29.6.18
standby database
CDBs, 40.1.2
standby transmission mode
definition of, 12.5.2
STANDBYS clause, 38.1.2.8
starting a database, 3.1
forcing, 3.1.5.5
Oracle Enterprise Manager Cloud Control, 3.1.1.3
recovery and, 3.1.5.6
Recovery Manager, 3.1.1.2
restricted mode, 3.1.5.4
SQL*Plus, 3.1.1.1
when control files unavailable, 3.1.5
when redo logs unavailable, 3.1.5
starting an instance
automatically at system startup, 3.1.5.7
database closed and mounted, 3.1.5.3
database name conflicts and, 2.5.2.1
forcing, 3.1.5.5
mounting and opening the database, 3.1.5.1
normally, 3.1.5.1
Oracle Enterprise Manager Cloud Control, 3.1.1.3
recovery and, 3.1.5.6
Recovery Manager, 3.1.1.2
remote instance startup, 3.1.5.8
restricted mode, 3.1.5.4
SQL*Plus, 3.1.1.1
when control files unavailable, 3.1.5
when redo logs unavailable, 3.1.5
without mounting a database, 3.1.5.2
startup
of database services, controlling, 3.1.3
STARTUP command
default behavior, 2.6.1
NOMOUNT clause, 2.3.8
PDBs, 40.4.5.3, 42.3.2.1
RECOVER clause, 3.1.5.6
starting a database, 3.1.1.1, 3.1.5
starting a PDB, 42.3.2
statement transparency in distributed database
managing, 32.7
statistics
automatically collecting for tables, 20.5
STATISTICS_LEVEL initialization parameter
automatic statistics collection, 20.5
Database Resource Manager, 27.1.1
stderr
for local external jobs, 28.3.1.2.1, 28.3.1.2.2
retrieving, 28.3.1.2.1, 28.3.1.2.2
stdout
for local external jobs, 28.3.1.2.1, 28.3.1.2.2
retrieving, 28.3.1.2.1, 28.3.1.2.2, 29.2.2.10
steps, chain
dropping, 29.6.11
stopping
chain steps, 29.6.13
chains, 29.6.12
jobs, 29.2.5
STORAGE clause, 38.1.2.1
storage parameters
INITIAL, 20.6.2
INITRANS, altering, 20.6.2
MAXTRANS, altering, 20.6.2
MINEXTENTS, 20.6.2
NEXT, 20.6.2
PCTINCREASE, 20.6.2
storage subsystems
mapping files to physical devices, 14.9, 14.9.4.3
stored procedures
managing privileges, 32.6.3.4
remote object security, 32.6.3.4
submitting SQL and commands to the database, 1.3
subqueries
in remote updates, 31.4.1
statement transparency in distributed databases, 32.7
SunSoft SunNet Manager, 31.3.4.3
Support Workbench, 9.1.3.7
for Oracle ASM instance, 9.3
viewing problems with, 9.3
SWITCH LOGFILE clause
ALTER SYSTEM statement, 11.6
synonyms, 24.3.3
creating, 24.3.2, 32.6.2.1
data dictionary views reference, 24.4
definition and creation, 32.6.2.1
displaying dependencies of, 18.11.2.2
dropping, 24.3.4
examples, 32.6.2.1
location transparency in distributed databases, 32.6.2
managing, 24.3.1, 24.3.4
managing privileges in remote database, 32.6.2.2
name resolution in distributed databases, 31.4.9
private, 24.3.1
public, 24.3.1
remote object security, 32.6.2.2
SYS account, 1.5.2
objects owned, 1.5.2.1
specifying password for CREATE DATABASE statement, 2.4.1
SYS_GROUP for Database Resource Manager, 27.7.5
SYSAUX tablespace, 13.2
about, 2.4.3
cannot rename, 13.9
creating at database creation, 2.3.9, 2.4.3
creating for CDBs, 37.4.2
DATAFILE clause, 2.4.3
monitoring occupants, 13.11.1
moving occupants, 13.11.2
SYSBACKUP account, 1.5.2, 1.5.2.3
connecting as, 1.6.1
SYSBACKUP administrative privilege, 1.6.1.1
SYSDBA account
connecting as, 1.6.1
SYSDBA administrative privilege, 1.6.1.1
adding users to the password file, 1.7.3
determining who has privileges, 1.7.3.2
granting and revoking, 1.7.3.1
SYSDG account, 1.5.2, 1.5.2.3
connecting as, 1.6.1
SYSDG administrative privilege, 1.6.1.1
SYSKM account, 1.5.2, 1.5.2.3
connecting as, 1.6.1
SYSKM administrative privilege, 1.6.1.1
SYSOPER account
connecting as, 1.6.1
SYSOPER administrative privilege, 1.6.1.1
adding users to the password file, 1.7.3
determining who has privileges, 1.7.3.2
granting and revoking, 1.7.3.1
SYSTEM account, 1.5.2
objects owned, 1.5.2.2
specifying password for CREATE DATABASE, 2.4.1
system change numbers
coordination in a distributed database system, 34.3.2.2
in-doubt transactions, 35.5.1.2
using V$DATAFILE to view information about, 14.10
when assigned, 11.1.2
system global area
holds sequence number cache
system monitor process (SMON), 5.5
system privileges
ADMINISTER_RESOURCE_MANAGER, 27.1.3
for external tables, 20.13.6
SYSTEM tablespace
cannot rename, 13.9
creating at database creation, 2.3.9
creating for CDBs, 37.4.2
creating locally managed, 2.3.9, 2.4.2, 37.4.2
restrictions on taking offline, 14.4
when created, 13.2
SYSTEM_PLAN for Database Resource Manager, 27.7.5

T

table size
estimating, 19.7.1
tables
about, 20.1
adding columns, 20.6.6
allocating extents, 20.6.4
altering, 20.6.1
altering physical attributes, 20.6.2
analyzing, 18.2
attribute-clustered, 20.2.9
compressed, 20.2.6
creating, 20.3
data dictionary views reference, 20.14
deferred segment creation, 20.2.14
designing before creating, 20.2.1
dropping, 20.10
dropping columns, 20.6.8
estimating size, 20.2.16
estimating space use, 19.7.1
external, 20.13
Flashback Drop, 20.11
Flashback Table, 20.9
guidelines for managing, 20.2
hash clustered
See hash clusters
increasing column length, 20.6.5
index-organized, 20.12
In-Memory Column Store, 6.7.4
invisible columns, 20.2.12
key-preserved, 24.1.5.1
limiting indexes on, 21.2.4
managing, 20
modifying column definition, 20.6.5
moving, 20.6.3
parallelizing creation, 20.2.4, 20.3.3
partitions, 20.2.2
moving online, 20.6.3.2
read-only, 20.6.9
redefining online, 20.7
renaming columns, 20.6.7
researching and reversing erroneous changes to, 20.8
restrictions when creating, 20.2.17
setting storage parameters, 20.2.16
shrinking, 19.3.3
specifying location, 20.2.3
statistics collection, automatic, 20.5
temporary, 20.3.2
truncating, 18.3
unrecoverable (NOLOGGING), 20.2.5
validating structure, 18.2.2
zone maps, 20.2.10
tablespace set, 15.3.3.1
tablespaces
adding data files, 14.2
assigning user quotas, 13.1.2
autoextending, 13.8.1
automatic segment space management, 13.2.1.2
bigfile, 2.4.8, 13.2.2
checking default storage parameters, 13.14.1
compressed, 13.2.3
containing XMLTypes, 15.1.4
creating undo tablespace at database creation, 2.4.4, 2.4.8.2
data dictionary views reference, 13.14
DBMS_SPACE_ADMIN package, 13.12
default temporary tablespace, creating, 2.4.6, 2.4.8.2
detecting and repairing defects, 13.12
diagnosing and repairing problems in locally managed, 13.12
dictionary managed, 13.2.2.2
dropping, 13.10
encrypted, 13.2.4
guidelines for managing, 13.1
increasing size, 13.8.1
In-Memory Column Store, 6.7.5
listing files of, 13.14.2
listing free space in, 13.14.3
locally managed, 13.2.1
locally managed SYSTEM, 2.4.2
locally managed temporary, 13.2.5.1
location, 14.1.3
migrating SYSTEM to locally managed, 13.13
on a WORM device, 13.7.3
Oracle Managed Files, managing, 17.5.1, 17.5.2
overriding default type, 2.4.8.2
quotas, assigning, 13.1.2
read-only, 13.7
renaming, 13.8, 13.9
setting default type, 2.4.8.1
single-file, 2.4.8, 2.4.8.2, 13.2.2, 13.8.3
space usage alerts, 19.1.1
specifying nonstandard block sizes, 13.4
SYSAUX, 13.2, 13.9
SYSAUX creation, 2.4.3
SYSAUX, managing, 13.11
SYSTEM, 13.2, 13.2.1, 13.7.1, 13.13
taking offline normal, 13.6.1
taking offline temporarily, 13.6.1
temp files in locally managed, 13.2.5.1
temporary, 13.2.5, 13.2.6.3
temporary bigfile, 13.2.5.2
temporary for creating large indexes, 21.3.4
undo, 16.1
using multiple, 13.1.1
using Oracle Managed Files, 17.3.3
temp files, 13.2.5.1
creating as Oracle managed, 17.3.4
dropping, 14.6
dropping Oracle managed, 17.4.1
TEMP_UNDO_ENABLED parameter, 16.7
temporary segments
index creation and, 21.2.1
temporary tables
assigning to a tablespace, 20.3.2
creating, 20.3.2
temporary tablespace, default
specifying at database creation, 17.3.2.5
temporary tablespaces
altering, 13.8.4
bigfile, 13.2.5.2
creating, 13.2.5.1
groups, 13.2.6
renaming default, 13.9
shrinking, locally managed, 13.8.5
temporary undo, 16.7
statistics for, 16.8
terminating user sessions
active sessions, 5.8.2
identifying sessions, 5.8.1
inactive session, example, 5.8.3
inactive sessions, 5.8.3
test case
builder, SQL, 9.1.1
threads
online redo log, 11.1.1
threshold based alerts
managing with Oracle Enterprise Manager Cloud Control, 8.1.2.1
threshold-based alerts
server-generated, 8.1.2
thresholds
setting alert, 19.1.1
time zone
files, 2.4.9.2
setting for database, 2.4.9.1
trace files, 9.1.3.3
location of, 8.1.1
log writer process and, 11.2.1.1
using, 8.1.1
when written, 8.1.1.3
trace files, finding, 9.6
traces, 9.1.3.3
tracing
archivelog process, 12.7
transaction control statements
distributed transactions and, 34.1.2
transaction failures
simulating, 35.9
Transaction Guard, 2.8.4
transaction management
overview, 34.3
transaction processing
distributed systems, 31.4
transactions
closing database links, 33.2
distributed and two-phase commit, 31.4.6
in-doubt, 34.3.1.2, 34.4, 34.4.3, 35.4
naming distributed, 35.2, 35.4.3.2
remote, 31.4.4
transmitting archived redo log files, 12.5
Transparent Data Encryption, 2.8.2
CDBs, 40.1.2
columns, 20.2.13
keystore, 13.2.4, 20.2.13
tablespaces, 13.2.4
transporting data, 15
across platforms, 15.1.3
character sets, 15.1.4
compatibility considerations, 15.1.5
full transportable export/import, 15.2
limitations, 15.2.2
when to use, 15.1.2
limitations, 15.1.4
national character sets, 15.1.4
PDBs, 15.2.3, 15.2.4
transferring data files, 15.6
transportable tables, 15.4
limitations, 15.4.2
transportable tablespaces, 15.3
from backup, 15.2.1, 15.3.1
limitations, 15.3.2
tablespace set, 15.3.3.1
transportable set, 15.3.3
when to use, 15.1.2
wizard in Oracle Enterprise Manager Cloud Control, 15.3.1
XMLTypes in, 15.1.4
triggers
disabling, 18.4.2
enabling, 18.4.1
.trm files, 9.1.3.3
TRUNCATE statement
DROP ALL STORAGE, 18.3.3
DROP STORAGE, 18.3.3
DROP STORAGE clause, 18.3.3
REUSE STORAGE, 18.3.3
REUSE STORAGE clause, 18.3.3
vs. dropping table, 20.10
tuning
analyzing tables, 33.4.2.2.2
cost-based optimization, 33.4.2
two-phase commit
case study, 34.5
commit phase, 34.3.2, 34.5.4
described, 31.4.6
discovering problems with, 35.4.1
distributed transactions, 34.3
example, 34.5
forget phase, 34.3.3
in-doubt transactions, 34.4, 34.4.3
phases, 34.3
prepare phase, 34.3.1, 34.3.1.2
recognizing read-only nodes, 34.3.1.1.2
specifying commit point strength, 35.1
steps in commit phase, 34.3.2.1
tracing session tree in distributed transactions, 35.3.2
viewing database links, 35.3.1

U

Undo Advisor, 16.4
undo management
automatic, 16.2
described, 16.1
initialization parameters for, 16.2.1
temporary undo, 16.7
undo retention
automatic tuning of, 16.2.2.1
explained, 16.2.2
guaranteeing, 16.2.2.2
setting, 16.3
undo segments
in-doubt distributed transactions, 35.4.2
undo space
data dictionary views reference, 16.8
undo space management
automatic undo management mode, 16.2
Undo tablespace
specifying at database creation, 17.3.2.4
undo tablespaces
altering, 16.5.2
creating, 16.5.1
data dictionary views reference, 16.8
dropping, 16.5.3
managing, 16.5
managing space threshold alerts, 16.5.6
monitoring, 16.8
PENDING OFFLINE status, 16.5.4
renaming, 13.9
sizing a fixed-size, 16.4
specifying at database creation, 2.3.9, 2.4.4, 2.4.8.2
specifying for CDBs, 37.4.2, 37.4.2
statistics for, 16.8
switching, 16.5.4
user quotas, 16.5.5
UNDO_MANAGEMENT initialization parameter, 2.4.4
UNDO_TABLESPACE initialization parameter
for undo tablespaces, 2.5.8.2
starting an instance using, 16.2.1
UNIQUE key constraints
associated indexes, 21.3.3.1
dropping associated indexes, 21.6
enabling on creation, 21.3.3
foreign key references when dropped, 18.5.3.1
indexes associated with, 21.3.3
unplugging, 38.7
UNRECOVERABLE DATAFILE clause
ALTER DATABASE statement, 11.8
unusable indexes, 21.2.11
updates
location transparency and, 31.5.1.2
upgrading a database, 2.1
user accounts
predefined, 2.8.1, 7.5
USER_DB_LINKS view, 32.5.1, 32.5.1
USER_DUMP_DEST initialization parameter, 9.1.3.1
USER_OBJECT_USAGE view
for monitoring index usage, 21.4.6
USER_RESUMABLE view, 19.2.4.1
USER_TABLESPACES clause, 38.1.2.6
users
assigning tablespace quotas, 13.1.2
in a newly created database, 2.8.1
limiting number of, 2.5.10
predefined, 2.8.1
session, terminating, 5.8.3
SYS, 1.5.2
SYSBACKUP, 1.5.2
SYSDG, 1.5.2
SYSKM, 1.5.2
SYSTEM, 1.5.2
utilities
for the database administrator, 1.8
SQL*Loader, 1.8, 20.4.1
UTLCHAIN.SQL script
listing chained rows, 18.2.3.1
UTLCHN1.SQL script
listing chained rows, 18.2.3.1
UTLLOCKT.SQL script, 8.2.1

V

V$ARCHIVE view, 12.8
V$ARCHIVE_DEST view
obtaining destination status, 12.4.2
V$BLOCKING_QUIESCE view, 3.4.1
V$CLONEDFILE view, 2.9.3
V$CON_SYS_TIME_MODEL view, 43.1.1
V$CON_SYSSTAT view, 43.1.1
V$CON_SYSTEM_EVENT view, 43.1.1
V$CON_SYSTEM_WAIT_CLASS view, 43.1.1
V$CONTAINERS view, 43.4
V$DATABASE view, 12.8.1
V$DBLINK view, 32.5.2
V$DIAG_CRITICAL_ERROR view, 9.1.4
V$DIAG_INFO view, 9.1.4
V$DISPATCHER view
monitoring shared server dispatchers, 5.3.4.4
V$DISPATCHER_RATE view
monitoring shared server dispatchers, 5.3.4.4
V$ENCRYPTED_TABLESPACES view, 13.2.4, 13.14
V$INSTANCE view
for database quiesce state, 3.4.3
V$LOG view, 11.9, 12.8
displaying archiving status, 12.8
V$LOG_HISTORY view, 11.9
V$LOGFILE view, 11.9
log file status, 11.5.2
V$PDBS view, 43.5, 43.6
V$PWFILE_USERS view, 1.7.3.2
V$QUEUE view
monitoring shared server dispatchers, 5.3.4.4
V$ROLLSTAT view
undo segments, 16.8
V$SESSION view, 5.8.3
V$SYSAUX_OCCUPANTS view
occupants of SYSAUX tablespace, 13.11.2
V$TEMPUNDOSTAT view
statistics for temporary undo, 16.8
V$THREAD view, 11.9
V$TIMEZONE_NAMES view
time zone table information, 2.4.9.2
V$TRANSACTION view
undo tablespaces information, 16.8
V$UNDOSTAT view
statistics for undo tablespaces, 16.8
V$VERSION view, 1.4.2
VALIDATE STRUCTURE clause
of ANALYZE statement, 18.2.2
VALIDATE STRUCTURE ONLINE clause
of ANALYZE statement, 18.2.2
verifying blocks
redo log files, 11.7
viewing
alerts, 19.1.2
incident package details, 9.10.3.1
SQL patch, 9.8.3
views
creating, 24.1.2
creating with errors, 24.1.2.3
data dictionary
for archived redo log files, 12.8.1
for clusters, 22.6
for control files, 10.8
for data files, 14.10
for database, 2.11
for database resident connection pooling, 5.4.3
for Database Resource Manager, 27.13.3
for hash clusters, 23.6
for indexes, 21.7
for Oracle Scheduler, 30.6.2
for redo log, 11.9
for schema objects, 18.11.2
for sequences, 24.4
for shared server, 5.3.6
for space usage in schema objects, 19.6.2
for synonyms, 24.4
for tables, 20.14
for tablespaces, 13.14
for undo space, 16.8
for views, 24.4
data dictionary views for, 24.4
DBA_2PC_NEIGHBORS, 35.3.2
DBA_2PC_PENDING, 35.3.1
DBA_DB_LINKS, 32.5.1
DBA_RESUMABLE, 19.2.4.1
displaying dependencies of, 18.11.2.2
dropping, 24.1.7
file mapping views, 14.9.3.3
FOR UPDATE clause and, 24.1.2
invalid, 24.1.4
join
See join views
location transparency in distributed databases, 32.6.1
managing, 24.1, 24.1.3
managing privileges with, 32.6.1
name resolution in distributed databases, 31.4.9
ORDER BY clause and, 24.1.2
remote object security, 32.6.1
restrictions, 24.1.4
USER_OBJECT_USAGE, 21.4.6
USER_RESUMABLE, 19.2.4.1
using, 24.1.4
V$ARCHIVE, 12.8
V$ARCHIVE_DEST, 12.4.2
V$DATABASE, 12.8.1
V$LOG, 12.8
V$LOGFILE, 11.5.2
wildcards in, 24.1.2.2
WITH CHECK OPTION, 24.1.2
virtual columns, 20.1
indexing, 21.2.2
Virtual Private Database
redefining tables online, 20.7.3.2

W

wildcards
in views, 24.1.2.2
window groups
creating, 29.7.4.2
disabling, 29.7.4.7
dropping, 29.7.4.3
dropping a member from, 29.7.4.5
enabling, 29.7.4.6
managing job scheduling and job priorities with, 29.7.4
overview, 28.2.10.2
window logs, 29.7.3
windows (Scheduler)
altering, 29.7.3.3
closing, 29.7.3.5
creating, 29.7.3.2
disabling, 29.7.3.7
dropping, 29.7.3.6
enabling, 29.7.3.8
opening, 29.7.3.4
overlapping, 28.2.9.1
overview, 28.2.9
windows, managing job scheduling and resource allocation with, 29.7.3
workloads
managing with database services, 2.7
WORM devices
and read-only tablespaces, 13.7.3
WRH$_UNDOSTAT view, 16.8

X

XMLTypes
transporting data, 15.1.4

Z

zone maps, 20.2.10