Index

Symbols 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.4.12
.trm files 9.1.3.3
@ 2.4.12

A

abort response 34.3.2.2.3
- two-phase commit 34.3.2.2.3
accounts
- creating for materialized views 38.2.4.1
- DBA operating system account 1.5.1
adaptive query optimization
- adaptive plans 9.3.4.2.2
adaptive query plans 9.3.4.2.2
adding
- columns 20.7.6
- columns in compressed tables 20.7.6
ADD LOGFILE clause
- ALTER DATABASE statement 11.3.1
ADD LOGFILE MEMBER clause
- ALTER DATABASE statement 11.3.2
ADMIN_TABLES procedure
- DBMS_REPAIR package 25.2.1
- example 25.4.1.2, 25.4.1.3
ADMINISTER_RESOURCE_MANAGER system privilege 27.1.3
administering
- the Scheduler 30
administration
- distributed databases 32
administrative user accounts 1.5.2.1
- SYS 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.4
ADR
- See: automatic diagnostic repository
ADR base 9.1.4
ADRCI utility 9.1.3.8
ADR home 9.1.4
advanced index compression 21.3.8.2
advanced row compression 20.2.6.1
Advisor
- Data Repair 9.1.1
- Undo 16.4
AFTER SUSPEND trigger
- example of registering 19.2.6
agent
- Heterogeneous Services, definition of 31.1.2.1
aggregate functions
- statement transparency in distributed databases 32.7
alert log 9.1.3.2
- about 8.1.1.1
- size of 8.1.1.2
- using 8.1.1.1
- viewing 9.3.3.1
- when written 8.1.1.4
alerts
- server-generated 8.1.2.1
- tablespace space usage 19.1.2
- threshold-based 8.1.2.1
- viewing 19.1.3
alert thresholds
- setting for locally managed tablespaces 19.1.2
ALL_DB_LINKS view 32.5.1
allocation
- extents 20.7.4
ALTER CLUSTER statement
- ALLOCATE EXTENT clause 22.4.1
- using for hash clusters 23.4
- using for index clusters 22.4.1
ALTER DATABASE statement
- ADD LOGFILE clause 11.3.1
- ADD LOGFILE MEMBER clause 11.3.2
- ARCHIVELOG clause 12.3.2
- CLEAR LOGFILE clause 11.8
- database partially available to users 3.2.1
- DATAFILE...OFFLINE DROP clause 14.4.3
- 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
- UNRECOVERABLE DATAFILE clause 11.8
ALTER INDEX statement
- COALESCE clause 21.2.13
- MONITORING USAGE clause 21.4.7
altering
- (Scheduler) windows 29.9.3.4
- event-based job 29.5.2.3
- event schedule 29.5.2.5
- indexes 21.4.1
- job classes 29.9.1.3
- jobs 29.2.3
- programs 29.3.3
- schedules 29.4.3
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.3
- setting time zone 2.5.10.1
ALTER SYSTEM FLUSH FLASH_CACHE 6.6.3
ALTER SYSTEM statement
- ARCHIVE LOG ALL clause 12.3.3
- 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
- QUIESCE RESTRICTED 3.4.2
- RESUME clause 3.5
- SET RESOURCE_MANAGER_PLAN 27.6
- SET SHARED_SERVERS initialization parameter 5.4.3.2
- SUSPEND clause 3.5
- SWITCH LOGFILE clause 11.6
- UNQUIESCE 3.4.3
ALTER TABLESPACE statement
- adding an Oracle managed data file, example 17.3.4.4
- adding an Oracle managed temp file, example 17.3.5.3
- ONLINE clause, example 13.6.2
- READ ONLY clause 13.7.2
- RENAME DATAFILE clause 14.5.2.1.1
ALTER TABLE statement
- ALLOCATE EXTENT clause 20.7.4
- DEALLOCATE UNUSED clause 20.7.4
- DISABLE ALL TRIGGERS clause 18.4.3
- DISABLE integrity constraint clause 18.5.3.1
- DROP COLUMN clause 20.7.8.1
- DROP integrity constraint clause 18.5.3.3
- DROP UNUSED COLUMNS clause 20.7.8.2
- ENABLE ALL TRIGGERS clause 18.4.2
- ENABLE integrity constraint clause 18.5.3.1
- external tables 20.15.3
- modifying index-organized table attributes 20.13.3.1
- MOVE clause 20.7.3.1, 20.7.3.2, 20.7.3.3, 20.13.3.2
- reasons for use 20.7.1
- SET UNUSED clause 20.7.8.2
ALTER TRIGGER statement
- DISABLE clause 18.4.3
- ENABLE clause 18.4.2
ANALYZE statement
- CASCADE clause 18.2.3
- CASCADE clause, FAST option 18.2.3
- corruption reporting 25.3.1.4
- listing chained rows 18.2.5
- remote tables 33.4.2.3.2
- validating structure 18.2.3, 25.3.1.1
analyzing schema objects 18.2.1
analyzing tables
- distributed processing 33.4.2.3.2
AND condition
- for simple subquery materialized views 36.6.3
APPEND hint 20.2.6.2
Application Continuity 2.9.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.2
- using hints to tune queries 33.4.3.1
archived redo log files
- alternate destinations 12.4.4
- archiving modes 12.3.2
- data dictionary views 12.8.1
- destination availability state, controlling 12.4.3
- destinations, groups 12.4.2
- destinations, specifying 12.4
- destination status 12.4.3
- failed destinations and 12.6
- mandatory destinations 12.6.1.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.2
archiver process (ARCn) 5.6
- trace output (controlling) 12.7
archiving
- alternate destinations 12.4.4
- changing archiving mode 12.3.2
- controlling number of processes 12.3.4
- destination availability state, controlling 12.4.3
- destination failure 12.6
- destination status 12.4.3
- manual 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.4.12
attribute-clustered tables 20.2.9
auditing
- database links 31.3.3
authentication
- database administrators 1.6.3
- database links 31.3.2.1
- operating system 1.6.4.2
- password files 1.6.5
- selecting a method 1.6.3.1
- using password file 1.6.5.1
AUTO_TASK_CONSUMER_GROUP
- of Resource Manager 26.5
AUTOEXTEND clause 14.3.1
auto indexes 21.7, 21.7.1
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 indexes
- views 21.7.5
automatic indexing
- about 21.7.1
- configuring 21.7.3
- generating reports 21.7.4
- how automatic indexing works 21.7.2
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.2.3
automatic undo management 2.5.5, 16.2
- migrating to 16.6

B

BACKGROUND_DUMP_DEST initialization parameter 9.1.3.1
background processes 5.6
- FMON 14.9.2.1.1
backups
- after creating new databases 2.4.14
- effects of archiving on 12.2.1
batch jobs, authenticating users in 2.9.3
bigfile tablespaces
- creating 13.2.3.2
- creating temporary 13.2.6.3
- description 13.2.3.1
- setting database default 2.5.9.1
big table cache 6.2
BLOB data type 20.3.1
block size, redo log files 11.2.4
BLOCKSIZE clause
- of CREATE TABLESPACE 13.4

C

caches
- sequence numbers 24.2.4.2.1
calendaring expressions 29.4.5.2
calls
- remote procedure 31.5.2
cancelling SQL statements 5.10.5
capacity planning
- space management
  - capacity planning 19.7
CASCADE clause
- when dropping unique or primary keys 18.5.3.1
catalog.sql 2.4.12
CATBLOCK.SQL script 8.2.1
catctl.pl 2.4.12
catpcat.sql 2.4.12
catproc.sql 2.4.12
centralized user management
- distributed systems 31.3.2.4.1
chain condition syntax 29.6.5
chained rows
- eliminating from table, procedure 18.2.5.2
chain rules 29.6.5
chains
- creating 29.6.3
- creating and managing job 29.6
- creating jobs for 29.6.8
- disabling 29.6.12
- dropping 29.6.9
- dropping rules from 29.6.11
- enabling 29.6.7
- handling stalled 29.6.20
- monitoring running 29.6.19
- overview 28.2.8
- pausing 29.6.16
- running 29.6.10
- setting privileges 30.1.1
- steps
  - pausing 29.6.16
  - skipping 29.6.17
- stopping 29.6.14
- stopping individual steps 29.6.15
chain steps
- defining 29.6.4
change vectors 11.1.2
character set
- choosing 2.2.1
character sets 2.2.2
CHAR data type
- increasing column length 20.7.5
CHECK_OBJECT procedure
- DBMS_REPAIR package 25.2.1
- example 25.4.2
- finding extent of corruption 25.3.2
checkpoint process (CKPT) 5.6
checksums
- for data blocks 14.7
- redo log blocks 11.7
clearing redo log files 11.8
CLEAR LOGFILE clause
- ALTER DATABASE statement 11.8
client/server architectures
- distributed databases 31.1.3
- globalization support 31.6.2
CloneDB 2.10.1
clonedb.pl Perl script 2.10.1.2
cloning
- a database 1.2.11, 2.10
- an Oracle home 1.2.11
CLOSE DATABASE LINK clause
- ALTER SESSION statement 33.2
closing database links 32.4.1
closing windows 29.9.3.6
clusters
- about 22.1
- allocating extents 22.4.1
- altering 22.4.1
- analyzing 18.2.1
- clustered tables 22.1, 22.2.1, 22.3.2, 22.4.2, 22.5.2
- cluster indexes 22.5
- cluster keys 22.1, 22.2.2
- columns for cluster key 22.2.2
- creating 22.3.1
- data dictionary views reference 22.6
- deallocating extents 22.4.1
- dropping 22.5
- estimating space 22.2.3, 22.2.5
- guidelines for managing 22.2
- location 22.2.4
- privileges 22.3.1, 22.4.1, 22.5.2
- selecting tables 22.2.1
- single-table hash clusters 23.3.3
- truncating 18.3
- validating structure 18.2.3
coalescing indexes
- costs 21.2.13
cold backup
- performing with a detached Oracle Scheduler job 29.2.2.8
collections
- materialized views 36.10.5
  - restrictions 36.10.5.1
- replication 36.10.5
collocated inline views
- tuning distributed queries 33.4.1
column encryption 2.9.2
column objects
- materialized views
  - column subsetting 36.10.3
- replication 36.10.1
columns
- adding 20.7.6
- adding to compressed table 20.7.6
- displaying information about 20.17
- dropping 20.7.8, 20.7.8.3
- dropping in compressed tables 20.7.8.4
- encrypted 20.2.13
- increasing length 20.7.5
- invisible 20.2.12.1
- modifying definition 20.7.5
- renaming 20.7.7
- virtual 20.1
- virtual, indexing 21.2.2
column subsetting
- materialized views
  - column objects 36.10.3
commands
- submitting 1.3.1
comments
- adding to problem activity log 9.2.7
COMMENT statement 20.17
COMMIT_POINT_STRENGTH initialization parameter 34.2.6.3
commit phase 34.3.2.1, 34.5.5
- in two-phase commit 34.3.3, 34.3.3.2
commit point site 34.2.6.1
- commit point strength 34.2.6.3, 35.1
- determining 34.2.6.3
- distributed transactions 34.2.6.1, 34.2.6.3
- how the database determines 34.2.6.3
commit point strength
- definition 34.2.6.3
- specifying 35.1
COMMIT statement
- FORCE clause 35.5, 35.5.1.2, 35.5.2
- forcing 35.4.2
- two-phase commit and 31.4.6
committing transactions
- commit point site for distributed transactions 34.2.6.1
compatibility level 2.6.9.1
COMPATIBLE Initialization Parameter 2.6.9.1
complete refresh 36.7, 37.4.2.1
complex materialized views 36.4.5.1, 36.4.5.2
- value for PCTUSED 37.4.2.1
components
- srvctl component names and abbreviations 4.5
compression 38.1.4
- indexes 21.3.8
  - advanced compression 21.3.8.2
  - prefix compression 21.3.8.1
- levels 20.2.6.1
- tables 20.2.6.1
  - adding a column 20.7.6
  - dropping columns in 20.7.8.4
- tablespaces 13.2.4
configuring
- an Oracle database 2
- Oracle Scheduler 30.1
CONNECT command
- starting an instance 3.1.4
CONNECT command, SQL*Plus 1.3.3.5, 1.3.3.5.1
connected user database links 32.2.3.2
- advantages and disadvantages 31.2.8.2
- definition 31.2.8.1
- REMOTE_OS_AUTHENT initialization parameter 31.2.8.2
connecting
- with SQL*Plus 1.3.3.1
connection qualifiers
- database links and 32.2.4
- diagnosing problems with 40.1
connections
- terminating remote 33.2
constraints 18.5
- See also: integrity constraints
- deferrable 37.4.4
- 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.4
- enabling example 18.5.2.2
- enabling when violations exist 18.5.1.4
- exceptions 18.5.1.3, 18.5.5
- exceptions to integrity constraints 18.5.5
- integrity constraint states 18.5.1.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.2
CONTROL_FILES initialization parameter
- overwriting existing control files 2.6.4
- specifying file names 10.2.1
- when creating a database 2.6.4, 10.3.1
CONTROLFILE REUSE clause 2.6.4
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.6.1
- data dictionary views reference 10.8
- default name 2.6.4, 10.3.1
- dropping 10.7
- errors during creation 10.4.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.6.4, 10.2.2
- moving 10.3.2
- multiplexed 10.2.2
- names 10.2.1
- number of 10.2.2
- overwriting existing 2.6.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.6.4
- troubleshooting 10.4
- unavailable during startup 3.1.5.1
copying jobs 29.2.13
core files 9.1.3.3
corruption
- repairing data block 25.1
cost-based optimization 33.4.2.2
- distributed databases 31.5.3
- hints 33.4.3.1
- using for distributed queries 33.4.2.2
CREATE_CREDENTIAL procedure 5.9.2, 29.2.2.3
CREATE_SIMPLE_PLAN procedure
- Database Resource Manager 27.4
CREATE BIGFILE TABLESPACE statement 13.2.3.2
CREATE BIGFILE TEMPORARY TABLESPACE statement 13.2.6.3
CREATE CLUSTER statement
- creating clusters 22.3.1
- example 22.3.1
- for hash clusters 23.3.1
- HASH IS clause 23.3.1, 23.3.4.2
- HASHKEYS clause 23.3.1, 23.3.4.4
CREATE CONTROLFILE statement
- about 10.3.3.2
- checking for inconsistencies 10.4.1
- NORESETLOGS clause 10.3.3.3
- Oracle Managed Files, using 17.3.6.1
- RESETLOGS clause 10.3.3.3
CREATE DATABASE LINK statement 32.2.2.1
CREATE DATABASE statement 2.4.1
- clauses 2.5.1
- CONTROLFILE REUSE clause 10.3.1
- DEFAULT TEMPORARY TABLESPACE clause 2.5.7
- example of database creation 2.4.10
- MAXLOGFILES parameter 11.2.5
- MAXLOGMEMBERS parameter 11.2.5
- password for SYS 2.5.2
- password for SYSTEM 2.5.2
- setting time zone 2.5.10.1
- specifying FORCE LOGGING 2.5.11
- UNDO TABLESPACE clause 2.5.5
- used to create an undo tablespace 16.5.1.2
- using Oracle Managed Files 17.3.3
- using Oracle Managed Files, examples 17.5.1, 17.5.2
CREATE INDEX statement
- NOLOGGING 21.2.10
- ON CLUSTER clause 22.3.3
- with a constraint 21.3.4.2
CREATE PFILE FROM MEMORY statement 2.7.8
CREATE SCHEMA statement
- multiple tables and views 18.1
CREATE SEQUENCE statement 24.2.2
- CACHE option 24.2.4.2.3
CREATE SYNONYM statement 24.3.2
CREATE TABLESPACE statement
- BLOCKSIZE CLAUSE, using 13.4
- FORCE LOGGING clause, using 13.5
- LOST WRITE PROTECTION clause 13.11.2
- using Oracle Managed Files 17.3.4.1
- using Oracle Managed Files, examples 17.3.4.2
CREATE TABLE statement
- CLUSTER clause 22.3.2
- creating a private temporary table 20.3.2.4
- creating global temporary table 20.3.2.3
- example of 20.3.1
- INCLUDING clause 20.13.2.6
- MONITORING clause 20.6
- NOLOGGING clause 20.2.5
- ORGANIZATION EXTERNAL clause 20.15.2
- PCTTHRESHOLD clause 20.13.2.5
CREATE TEMPORARY TABLESPACE statement 13.2.6.2
- using Oracle Managed Files 17.3.5.1
- using Oracle managed files, example 17.3.5.2
CREATE UNDO TABLESPACE statement
- using Oracle Managed Files 17.3.4.1
- using Oracle Managed Files, example 17.3.4.3
- using to create an undo tablespace 16.5.1.3
CREATE VIEW statement
- about 24.1.2.1
- OR REPLACE clause 24.1.3
- WITH CHECK OPTION 24.1.2.1, 24.1.4
creating
- an Oracle database 2
- chains 29.6.3
- control files 10.3
- databases 2.1
- database services 2.8.1.4
- event-based job 29.5.2.2
- event schedule 29.5.2.4
- indexes 21.3
  - after inserting table data 21.2.1
  - associated with integrity constraints 21.3.4.1
  - NOLOGGING 21.2.10
  - online 21.3.6
  - prerequisites 21.3.1
  - USING INDEX clause 21.3.4.2
- job classes 29.9.1.2
- jobs 29.2.2
- programs 29.3.2.1
- Scheduler windows 29.9.3.3
- schedules 29.4.2
- sequences 24.2.4.2.3
- window groups 29.9.4.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.9
- 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.4.14
- default temporary tablespace, specifying 2.5.7
- example 2.4.10
- manually from a script 2.1
- overriding default tablespace type 2.5.9.2
- planning 2.2
- preparing to 2.2
- prerequisites for 2.2.4
- setting default tablespace type 2.5.9.1
- specifying bigfile tablespaces 2.5.9, 2.5.9.2
- UNDO TABLESPACE clause 2.5.5
- upgrading to a new release 2.1
- using Oracle Managed Files 2.5.8, 17.3.3
- with DBCA 2.3.1
creating data files 14.2
creating sequences 24.2.2
creating synonyms 24.3.2
creating views 24.1.2.1
credentials, Oracle Scheduler
- about 28.2.7
- granting privileges on 28.2.7
critical errors
- diagnosing 9.1.1
CRSCTL utility
- Oracle Restart 4.1.4
current user database links
- advantages and disadvantages 31.2.8.4
- cannot access in shared schema 31.3.2.4.3
- definition 31.2.8.1
- shared schema 31.3.2.4.3
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.4.3.2
customizing an incident package 9.4.3, 9.4.3.2

D

data
- loading using external tables 20.15.2
database
- cloning 1.2.11, 2.10
- cloning in a multitenant environment 2.10.2
- cloning with CloneDB 2.10.1
- cloning with Oracle ASM 2.10.3
- creating 2.1
- creating and configuring 2
- creating with DBCA 2.3.1
- data dictionary views reference 2.12
- starting up 3.1
database administrators
- authentication 1.6.3
- DBA role 1.5.2.5
- operating system account 1.5.1
- password files for 1.6.3.2
- 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.8.2
Database Configuration Assistant 2.1
- shared server configuration 5.4.4
database destinations, Oracle Scheduler
- about 28.2.5.1
- creating 29.2.2.4.2
Database In-Memory
- See: Oracle Database In-Memory
database jobs, Oracle Scheduler 28.3.1.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.8.1, 31.2.8.2, 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, examples 31.2.9
- creating, scenarios 32.8
- creating shared 32.3.2
- current user 31.2.8.1, 31.2.8.4, 32.2.3.2
- data dictionary USER views 32.5.1
- definition 31.2.1
- diagnosing problems with 40.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.3
- fixed user 31.2.8.1, 31.2.8.3, 32.8.1
- global 31.2.7
- global names 31.2.4
  - loopback 31.2.5
- global object names 31.4.7.1
- handling errors 33.3
- host name 32.5.3
- incoming database links 32.5.4
- limiting number of connections 32.4.3
- listing 32.5.1, 35.3.1, 35.3.2
- loopback 31.2.5
- managing 32.4
- materialized view sites 38.2.4.2
- minimizing network connections 32.3
- name resolution 31.4.7.1
- names for 31.2.6
- private 31.2.7
- public 31.2.7
- referential integrity in 33.3
- remote transactions 31.4.1, 31.4.4
- resolution 31.4.7.1
- restrictions 31.2.11
- roles on remote database 31.2.11
- schema objects and 31.2.10
- SCN activity 32.5.5
- 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.10.3
- tuning distributed queries 33.4
- tuning queries with hints 33.4.3.1
- tuning using collocated inline views 33.4.1
- types of links 31.2.7
- types of users 31.2.8.1
- users, specifying 32.2.3
- using cost-based optimization 33.4.2.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.5.2.1
- configuring the connection pool 5.5.2
- data dictionary views reference 5.5.3
- disabling 5.5.1
- enabling 5.5.1
- triggers 5.2
Database Resource Manager
- active session pool with queuing 27.3.6
- administering system privilege 27.1.3
- and operating system control 27.12
- automatic consumer group switching 27.3.5.1
- CREATE_SIMPLE_PLAN procedure 27.4
- data dictionary views reference 27.13.3
- description 27.1
- enabling 27.6
- execution time limit 27.3.5.3
- resource allocation methods 27.5.5
- resource consumer groups 27.1.2.1, 27.2, 27.5.3
- resource plan directives 27.1.2.1, 27.5.6, 27.5.7
- resource plans 27.1.2.1, 27.1.2.7, 27.3.1.1, 27.4, 27.6, 27.7, 27.7.5
- STATISTICS_LEVEL parameter 27.1.1
- undo pool 27.3.7
- used for quiescing a database 3.4.1
- validating plan schema changes 27.5.7
databases
- administering 1
- administration of distributed 32
- altering availability 3.2
- backing up 2.4.14
- default temporary tablespace, specifying 2.5.7
- dropping 2.11
- mounting a database 3.1.5.4
- mounting to an instance 3.2.1
- opening a closed database 3.2.2
- planning 1.2.3
- planning creation 2.2
- quiescing 3.4.1
- read-only, opening 3.2.3
- recovery 3.1.5.7
- 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.6.4
- suspending 3.5
- undo management 2.5.5
- upgrading 2.1
database services
- about 2.8.1.1
- controlling automatic startup of 3.1.3
- creating 2.8.1.4
- data dictionary views 2.8.3
- managing application workloads with 2.8
Database Smart Flash Cache 6.6
- flushing 6.6.3
- tuning 6.6.3
database writer process
- calculating checksums for data blocks 14.7
database writer process (DBWn) 5.6
data block corruption
- repairing 25.1
data blocks
- altering size of 2.6.5.1
- nonstandard block size 2.6.5.2
- shadow lost write protection 13.11
- shared in clusters 22.1
- specifying size of 2.6.5
- standard block size 2.6.5
- verifying 14.7
data dictionary 2.12
- See also: views, data dictionary
- conflicts with control files 10.4.1
- purging pending rows from 35.6.1, 35.6.3
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.1
- checking associated tablespaces 13.15.3
- copying using database 14.8.1
- creating 14.2
- creating Oracle Managed Files 17.3, 17.3.7.2
- database administrators access 1.5.1
- data dictionary views reference 14.10
- default directory 14.2
- definition 14.1.1
- deleting 13.10
- dropping 14.4.3, 14.6
- dropping Oracle managed 17.4.1
- file numbers 14.1.1
- fully specifying file names 14.2
- guidelines for managing 14.1.1
- headers when renaming tablespaces 13.9
- identifying OS file names 14.5.2.1.2
- location 14.1.4
- mapping files to physical devices 14.9
- minimum number of 14.1.2.1
- MISSING 10.4.1
- offline
  - relocating 14.5.2
  - renaming 14.5.2
- online 14.4.3
  - relocating 14.5.1
  - renaming 14.5.1
- relocating 14.5
- renaming 14.5
- reusing 14.2
- shadow lost write protection 13.11
- size of 14.1.3
- statements to create 14.2
- storing separately from redo log files 14.1.5
- unavailable when database is opened 3.1.5.1
- verifying data blocks 14.7
data manipulation language
- statements allowed in distributed transactions 31.4.1
Data Recovery Advisor, repairing data corruptions with 9.5.2
Data Repair Advisor 9.1.1
date expressions 37.4.3.1
DB_BLOCK_CHECKING initialization parameter 25.3.1.1, 25.3.1.5
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.6.5
DB_CACHE_SIZE initialization parameter
- specifying multiple block sizes 13.4
DB_CREATE_FILE_DEST initialization parameter
- setting 17.2.2
DB_CREATE_ONLINE_LOG_DEST_n initialization parameter
- setting 17.2.4
DB_DOMAIN initialization parameter
- setting for database creation 2.6.2
DB_FILES initialization parameter
- determining value for 14.1.2.2
DB_NAME initialization parameter
- setting before database creation 2.6.2
DB_nK_CACHE_SIZE initialization parameter
- specifying multiple block sizes 13.4
DB_RECOVERY_FILE_DEST initialization parameter
- setting 17.2.3
DB_UNRECOVERABLE_SCN_TRACKING initialization parameter 20.4.2.4.2
DBA
- See: database administrators
DBA_2PC_NEIGHBORS view 35.3.2
- using to trace session tree 35.3.2
DBA_2PC_PENDING view 35.3.1, 35.6.1, 35.7.6
- using to list in-doubt transactions 35.3.1
DBA_DB_LINK_SOURCES view 32.5.4, 32.5.5
DBA_DB_LINKS view 32.5.1
DBA_DB_LINK view 32.5.5
DBA_EXTERNAL_SCN_ACTIVITY view 32.5.5
DBA_REGISTERED_MVIEWS view 36.11.1
DBA_TYPE_VERSIONS
- replication 36.10.2
DBA role 1.5.2.5
DBCA
- See: Database Configuration Assistant
DBMS_CREDENTIAL package 5.9.2
DBMS_FILE_TRANSFER package
- copying data files 14.7
DBMS_JOB
- about A.1
- moving jobs to Oracle Scheduler A.2
DBMS_METADATA package
- GET_DDL function 18.11.1
- using for object definition 18.11.1
DBMS_MVIEW package 36.11.3
- EXPLAIN_MVIEW procedure 39.4
- REFRESH procedure 39.3
- REGISTER_MVIEW procedure 36.11.3
DBMS_PROCESS package 5.7.2
DBMS_REDEFINITION package
- performing online redefinition with 20.8.6.1
DBMS_REFRESH package
- MAKE procedure 39.2
- REFRESH procedure 39.3
DBMS_REPAIR
- logical corruptions 25.3.2
DBMS_REPAIR package
- examples 25.4
- procedures 25.2.1
- using 25.3, 25.4.5
DBMS_RESOURCE_MANAGER_PRIVS package 27.1.3
- procedures (table of) 27.1.3
DBMS_RESOURCE_MANAGER package 27.1.2.1, 27.1.3, 27.2.4.1.1
- 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.1
DBMS_SPACE_ADMIN
- DROP_EMPTY_SEGMENTS procedure 19.4
- MATERIALIZE_DEFERRED_SEGMENTS procedure 20.2.15
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_SQLDIAG package 9.3.4.3.2
DBMS_TNS package 32.5.3
DBMS_TRANSACTION package
- PURGE_LOST_DB_ENTRY procedure 35.6.2
DBVERIFY utility 25.3.1.1, 25.3.1.3
DDL_LOCK_TIMEOUT initialization parameter 2.6.7
DDL lock timeout 2.6.7
DDL log 9.1.3.4
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.1
DEFAULT_CONSUMER_GROUP for Database Resource Manager 27.2.6.1, 27.9.2
default temporary tablespace
- renaming 13.9
default temporary tablespaces
- specifying at database creation 2.4.10, 2.5.7
- specifying bigfile temp file 2.5.9.2
deferred segment creation
- indexes 21.2.6
- in tables 20.2.14
deferred segments
- materializing 20.2.15
defining
- chain steps 29.6.4
dependencies
- between schema objects 18.7
- displaying 18.11.2.2
destinations, Oracle Scheduler
- about 28.2.5.1
- creating 29.2.2.4.2
detached jobs 28.3.1.5
- creating 29.2.2.8
DIAGNOSTIC_DEST initialization parameter 8.1.1.1, 9.1.4
dictionary-managed tablespaces
- migrating SYSTEM to locally managed 13.14
Digital POLYCENTER Manager on NetView 31.3.4.3
directory objects
- external procedures 5.9.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
direct path load
- fast refresh 37.4.2.2
disabling
- chains 29.6.12
- jobs 29.2.11
- programs 29.3.5
- window groups 29.9.4.7
- windows 29.9.3.8
disabling recoverer process 35.9.2
dispatcher process (Dnnn) 5.6
dispatcher processes 5.4.4.3, 5.4.6
DISPATCHERS initialization parameter
- setting initially 5.4.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.6.3
- cost-based optimization 31.5.3
- database clouds 2.8.2
- direct and indirect connections 31.1.3
- distributed processing 31.1.1.2
- distributed queries 31.4.2
- distributed updates 31.4.2
- exclusively mapped global users 31.3.2.4.2
- forming global database names 32.1.1
- Global Data Services 2.8.2
- globalization support 31.6.1
- global object names 31.2.10.4, 32.1
- 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.1
- remote object security 32.6.1
- remote queries and updates 31.4.1
- replicated databases and 31.1.1.3
- 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.1
- security 31.3.2
- shared schema users 31.3.2.4.3
- site autonomy of 31.3.1
- SQL transparency 31.5.1.2
- starting a remote instance 3.1.5.9
- transaction processing 31.4
- transparency 31.5.1
distributed processing
- distributed databases 31.1.1.2
distributed queries 31.4.2
- analyzing tables 33.4.2.3.2
- application development issues 33.4
- cost-based optimization 33.4.2.2
- optimizing 31.5.3
distributed systems
- data encryption 31.3.2.5
distributed transactions 31.4.5
- case study 34.5.1
- commit point site 34.2.6.1
- commit point strength 34.2.6.3, 35.1
- committing 34.2.6.2
- database server role 34.2.3
- defined 34.1
- DML and DDL 34.1.1
- failure during 35.8.1
- global coordinator 34.2.5
- locked resources 35.8
- locks for in-doubt 35.8.2
- lock timeout interval 35.8
- manually overriding in-doubt 35.4.2
- naming 35.2, 35.4.3.2
- session trees 34.2.1, 34.2.3, 34.2.4, 34.2.5, 34.2.6.1, 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.1, 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.1
DRIVING_SITE hint 33.4.3.3
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.11
DROP LOGFILE clause
- ALTER DATABASE statement 11.5.1
DROP LOGFILE MEMBER clause
- ALTER DATABASE statement 11.5.2
dropping
- chains 29.6.9
- chain steps 29.6.13
- columns
  - marking unused 20.7.8.2
  - remove unused columns 20.7.8.2
- columns in compressed tables 20.7.8.4
- database links 32.4.2
- data files 14.6
- data files, Oracle managed 17.4.1
- job classes 29.9.1.4
- jobs 29.2.8
- programs 29.3.4
- rules from chains 29.6.11
- schedules 29.4.4
- tables
  - consequences of 20.11
- temp files 14.6
  - Oracle managed 17.4.1
- window groups 29.9.4.3
- windows 29.9.3.7
dropping multiple jobs 29.2.10
DROP SYNONYM statement 24.3.4
DROP TABLESPACE statement 13.10
DROP TABLE statement
- about 20.11
- CASCADE CONSTRAINTS clause 20.11
- for clustered tables 22.5.2
DUMP_ORPHAN_KEYS procedure
- DBMS_REPAIR package 25.2.1
- example 25.4.4
- recovering data 25.3.4.1
dumps 9.1.3.3
dynamic statistics 9.3.4.2.2

E

ECID 9.1.2.3
editions
- in CONNECT command 1.3.3.5
- managing 18.10
e-mail notifications, Scheduler 29.10.5
EMPHASIS resource allocation method 27.5.5
empty tables
- dropping segments 19.4
enabling
- chains 29.6.7
- jobs 29.2.12
- programs 29.3.6
- window groups 29.9.4.6
- windows 29.9.3.9
enabling recoverer process
- distributed transactions 35.9.2
encryption
- column 20.2.13
- tablespace 13.2.5.1
encryption, transparent data 2.9.2
enterprise users
- definition 31.3.2.4.3
environment variables
- ORACLE_SID 2.4.2
error logging, DML
- inserting data with 20.4.4.1
errors
- alert log and 8.1.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.10.3
- ORA-01090 3.3.1
- 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-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.1
- when creating control file 10.4.2
- while starting a database 3.1.5.6
- while starting an instance 3.1.5.6
event-based job
- altering 29.5.2.3
- creating 29.5.2.2
- passing event messages to 29.5.2.6
event message
- passing to event-based job 29.5.2.6
events
- using to start Scheduler jobs 29.5
events (Scheduler)
- overview 29.5.1
event schedule
- altering 29.5.2.5
- creating 29.5.2.4
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
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.3
execution plans
- analyzing for distributed queries 33.4.4
EXISTS condition
- materialized views with subqueries 36.6.3
EXPLAIN_MVIEW procedure 39.4
export operations
- restricted mode and 3.1.5.5
expressions, calendaring 29.4.5.2
extents
- allocating cluster extents 22.4.1
- allocating for tables 20.7.4
- data dictionary views for 19.6.2
- deallocating cluster extents 22.4.1
- displaying free extents 19.6.2.3
external destinations, Oracle Scheduler
- about 28.2.5.1
- creating 29.2.2.4.2
external jobs
- retrieving stdout and stderr 28.3.1.2.2, 28.3.1.2.3, 29.2.2.10
external jobs, Oracle Scheduler 28.3.1.2.1
external procedures
- credentials 5.9.2
- directory objects 5.9.2
- managing processes for 5.9.1
external tables
- altering 20.15.3
- creating 20.15.2
- defined 20.15.1
- dropping 20.15.8
- Hadoop 20.15.1
- inline 20.15.1, 20.15.6
- partitioned 20.15.7
  - altering 20.15.7.4
  - creating 20.15.7.3
  - restrictions 20.15.7.2
- privileges required 20.15.9
- querying 20.15.5
- uploading data example 20.15.2

F

fast recovery area
- as archive log destination 12.4.1.1
- initialization parameters to specify 2.6.3
- with Oracle managed files 17.2.1
fast refresh 36.4.2, 36.7, 37.4.2.2
- avoiding problems 39.5
- determining possibility of 39.4
- direct path load 37.4.2.2
fault diagnosability infrastructure 9.1.1, 9.1.3
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 names
- Oracle Managed Files 17.3.2
files
- creating Oracle Managed Files 17.3, 17.3.7.2
file system
- used for Oracle managed files 17.1.4
file watchers
- about 29.5.3.1
- changing detection interval 29.5.3.5
- creating 29.5.3.3
- managing 29.5.3.5
filter columns 37.1.4.2
finalizing
- an incident package, definition 9.4.1.2
FINISH_REDEF_TABLE procedure
- dml_lock_timeout parameter 20.8.6.1
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.8.3
- creating 32.2.3.1
- definition 31.2.8.1
flashback data archive 38.1.4
Flashback Drop
- about 20.12
- purging recycle bin 20.12.4
- querying recycle bin 20.12.3
- recycle bin 20.12.1
- restoring objects 20.12.5
Flashback Table
- overview 20.10
flood-controlled incidents
- defined 9.1.2.2
- viewing 9.3.1.1
FMON background process 14.9.2.1.1
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
- precedence of settings 11.9
FORCE LOGGING clause
- CREATE DATABASE 2.5.11
- CREATE TABLESPACE 13.5
- performance considerations 2.5.11.2
force refresh 36.7, 37.4.2.3
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
foreign keys
- replicated tables 38.1.2
forget phase
- in two-phase commit 34.3.4
free space
- listing free extents 19.6.2.3
- tablespaces and 13.15.4
full transportable export/import 15.2
function-based indexes 21.3.7

G

GDS configuration 2.8.2
generic connectivity
- definition 31.1.2.4
GLOBAL_NAMES initialization parameter
- database links 31.2.6
GLOBAL_NAME view
- using to determine global database name 32.1.3
global coordinators 34.2.5
- distributed transactions 34.2.5
global database consistency
- distributed databases and 34.3.3.2
global database links 31.2.7
- creating 32.2.2.3
global database names
- changing the domain 32.1.4
- database links 31.2.4
  - loopback 31.2.5
- enforcing for database links 31.2.6
- enforcing global naming 32.1.2
- forming distributed database names 32.1.1
- impact of changing 31.4.9.2
- querying 32.1.3
Global Data Services 2.8.2
globalization support
- client/server architectures 31.6.2
- distributed databases 31.6.1
global object names
- database links 31.4.7.1
- distributed databases 32.1
global temporary tables
- assigning to a tablespace 20.3.2.3.2
- creating 20.3.2.3
global users 32.8.5
- exclusively mapped in distributed systems 31.3.2.4.2
- shared schema in distributed systems 31.3.2.4.3
granting privileges and roles
- SYSOPER/SYSDBA privileges 1.7.6
GRANT statement
- SYSOPER/SYSDBA privileges 1.7.6
groups, Oracle Scheduler 28.2.11.1
growth trends
- of database objects 19.7.3
GV$DBLINK view 32.5.2

H

Hadoop
- external tables 20.15.1
hash clusters
- advantages and disadvantages 23.1
- altering 23.4
- choosing key 23.3.4.1
- contrasted with index clusters 23.1
- controlling space use of 23.3.4
- creating 23.3.1
- data dictionary views reference 23.6
- dropping 23.5
- estimating storage 23.3.5
- examples 23.3.4.5.1
- hash function 23.1, 23.2.2, 23.3.1, 23.3.4.1, 23.3.4.2, 23.3.4.3
- HASH IS clause 23.3.1, 23.3.4.2
- HASHKEYS clause 23.3.1, 23.3.4.4
- single-table 23.3.3
- sorted 23.3.2
hash functions
- for hash cluster 23.1
health checks 9.1.1
Health Monitor 9.3.2
- checks 9.3.2.1.1
  - generating reports 9.3.2.3
  - viewing reports 9.3.2.3
  - viewing reports using ADRCI 9.3.2.3.4
heterogeneous distributed systems
- definition 31.1.2.1
Heterogeneous Services
- overview 31.1.2.1
hints 33.4.3.1
- DRIVING_SITE 33.4.3.3
- NO_MERGE 33.4.3.2
- using to tune distributed queries 33.4.3.1
horizontal partitioning
- See: row subsetting
HP OpenView 31.3.4.3
Hybrid Columnar Compression 20.2.6.1

I

IBM NetView/6000 31.3.4.3
IM column store
- See: In-Memory Column Store
Import
- materialized view logs 37.1.4.3
import operations
- PDBs 15.2.3, 15.2.4
- restricted mode and 3.1.5.5
Incident Manager, accessing 9.3.4.3.1.1
incident package
- correlated 9.4.1.4
- correlated, creating, editing, and uploading 9.4.4
- correlated, deleting 9.4.5
- customizing 9.4.3, 9.4.3.2
- defined 9.1.1
- viewing 9.4.3.1
incident packages 9.4.1
incident packaging service 9.1.1
incidents
- about 9.1.2.1
- flood-controlled 9.1.2.2
  - viewing 9.3.1.1
incidents, SQL 9.3.4.2.1
incompatibilities
- adding job or program 29.7.2
- dropping 29.7.4
- job or program 29.7.1
- removing job or program 29.7.3
- using 29.7
index clusters
- See: clusters
indexes
- advanced index compression 21.3.8.2
- altering 21.4.1
- analyzing 18.2.1
- auto indexes 21.7
- choosing columns to index 21.2.2
- cluster indexes 22.3.3, 22.4.2, 22.5
- coalescing 21.2.13, 21.4.3
- column order for performance 21.2.3
- creating 21.3
  - prerequisites 21.3.1
- data dictionary views reference 21.8
- deferred segment creation 21.2.6
- determining unusable status of 21.4.4
- disabling and dropping constraints cost 21.2.14
- dropping 21.2.5, 21.6
- estimating size 21.2.7
- estimating space use 19.7.2
- function-based 21.3.7
- guidelines for managing 21.1
- invisible 21.2.11, 21.3.10, 21.4.5
- keeping when disabling constraint 18.5.3
- keeping when dropping constraint 18.5.3
- limiting for a table 21.2.4
- materialized view sites 37.2.1
- monitoring space use of 21.5
- monitoring usage 21.4.7
- multiple on a set of columns 21.2.12
- on foreign keys 38.1.2
- parallelizing index creation 21.2.9
- rebuilding 21.2.13, 21.4.3
- rebuilt after direct-path INSERT 20.4.2.5.2
- renaming 21.4.6
- setting storage parameters for 21.2.7
- shrinking 19.3.3
- space used by 21.5
- tablespace for 21.2.8
- temporary segments and 21.2.1
- unusable 21.2.11, 21.3.9, 21.4.4
- validating structure 18.2.3
- when to create 21.2.2
index-organized tables
- analyzing 20.13.5
- AS subquery 20.13.2.7
- converting to heap 20.13.7
- creating 20.13.2.1
- described 20.13.1
- INCLUDING clause 20.13.2.6
- maintaining 20.13.3
- ORDER BY clause, using 20.13.6
- parallel creation 20.13.2.7
- prefix compression 20.13.2.8
- rebuilding with MOVE clause 20.13.3.2
- storing nested tables 20.13.2.4
- storing object types 20.13.2.4
- threshold value 20.13.2.5
in-doubt transactions 34.4.1
- after a system failure 35.4.1
- automatic resolution 34.4.2, 34.4.2.1
- deciding how to handle 35.4
- deciding whether to perform manual override 35.4.2
- defined 34.3.2.3
- manually committing 35.5.1.1
- manually committing, example 35.7
- manually overriding 35.4.2, 35.5
- manually overriding, scenario 35.7
- manually rolling back 35.5.2
- manual resolution 34.4.3
- overview 34.4.1
- pending transactions table 35.7.6
- purging rows from data dictionary 35.6.1, 35.6.3
- recoverer process and 35.9.2
- rolling back 35.5, 35.5.1.2, 35.5.2
- SCNs and 34.4.4
- simulating 35.9
- tracing session tree 35.3.2
- viewing database links 35.3.1
initialization parameter file
- about 2.6.1
- creating 2.4.5
- creating by copying and pasting from alert log 2.7.10
- creating for database creation 2.4.5
- default locations 3.1.2.1
- editing before database creation 2.6
- individual parameter names 2.6.2
- sample 2.6.1.1
- search order 3.1.2.1
- server parameter file 2.7
initialization parameters
- about 2.6.1
- and database startup 3.1.2.1
- changing 2.7.6.2
- changing values 2.7.6.1
- clearing 2.7.7
- COMMIT_POINT_STRENGTH 34.2.6.3
- CONTROL_FILES 2.6.4, 10.2.1, 10.3.1
- DB_BLOCK_CHECKING 25.3.1.5
- DB_BLOCK_CHECKSUM 11.7, 14.7
- DB_BLOCK_SIZE 2.6.5, 13.4
- DB_CACHE_SIZE 13.4
- DB_DOMA 2.6.2
- DB_FILES 14.1.2.2
- DB_NAME 2.6.2
- DB_nK_CACHE_SIZE 13.4
- DISPATCHERS 5.4.4.3
- editing 38.2.4.4
- GLOBAL_NAMES 31.2.6
- LOG_ARCHIVE_DEST 12.4.1
- LOG_ARCHIVE_DEST_n 12.4.1, 12.6.2
- LOG_ARCHIVE_DEST_STATE_n 12.4.3
- 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.6.6
- REMOTE_LOGIN_PASSWORDFILE 1.7.3
- REMOTE_OS_AUTHENT 31.2.8.2
- resetting 2.7.7
- RESOURCE_MANAGER_PLAN 27.6
- server parameter file and 2.7, 2.7.11
- setting 2.7.6.2
- SHARED_SERVERS 5.4.3.2
- shared server and 5.4.1
- SORT_AREA_SIZE 21.2.1
- SPFILE 2.7.5
- SQL_TRACE 8.1.1.1
- UNDO_MANAGEMENT 2.5.5
- UNDO_TABLESPACE 2.6.8.2
INITIAL parameter
- cannot alter 20.7.2
INITRANS parameter
- altering 20.7.2
inline external tables 20.15.1, 20.15.6
In-Memory Column Store 6.7
in-memory full jobs
- example of creating 29.2.2.2.2
in-memory jobs 28.3.1.7
in-memory runtime, jobs
- example of creating 29.2.2.2.2
INSERT statement
- with DML error logging 20.4.4.1
installing
- Release Update Revisions (Revisions) 1.2.10
- Release Updates (Updates) 1.2.10
instance_abort_delay_time parameter 3.6
instance caging 27.8.1
- with maximum utilization limit 27.8.1
instances
- aborting 3.3.5
- managing CPU for multiple 27.8.1
- shutting down immediately 3.3.3
- shutting down normally 3.3.2
- transactional shutdown 3.3.4
integrity constraints 18.5
- See also: constraints
- cost of disabling 21.2.14
- cost of dropping 21.2.14
- creating indexes associated with 21.3.4.1
- dropping tablespaces and 13.10
- ORA-02055 constraint violation 33.3
INTERNAL username
- connecting for shutdown 3.3.1
invisible columns 20.2.12.1
invisible indexes 21.2.11, 21.4.5
- creating 21.3.10
IOT
- See: index-organized tables
IPS 9.1.1

J

JOB_QUEUE_PROCESSES initialization parameter 28.4.3.3, 38.2.4.4, A.1.2
job classes
- altering 29.9.1.3
- creating 29.9.1.2
- dropping 29.9.1.4
- managing Scheduler job attributes, resources, and priorities with 29.9.1
- overview 28.2.9
- viewing 28.2.9
job coordinator 28.4.3.1
job credentials 29.2.2.3
job destination ID, defined 29.2.5, 29.10.3
job log, Scheduler
- viewing 29.10.2.1
job recovery (Scheduler) 30.4.1.4
job resources
- managing 29.8
jobs 29.2.2.2.2
- adding to an incompatibility 29.7.2
- altering 29.2.3
- copying 29.2.13
- creating 29.2.2
- creating and managing Scheduler 29.2
- creating for chains 29.6.8
- credentials 28.2.7
- database 28.3.1.1.1
- detached 28.3.1.5
- disabling 29.2.11
- dropping 29.2.8
- dropping an incompatibility 29.7.4
- e-mail notifications 29.10.5
- enabling 29.2.12
- event-based 29.5.2.2
- external 28.3.1.2.1
- incompatibilities 29.7.1
- in-memory 28.3.1.7
- in-memory full, example of creating 29.2.2.2.2
- in-memory runtime, example of creating 29.2.2.2.2
- lightweight 28.3.1.6
- lightweight, example of creating 29.2.2.2.2
- monitoring 29.10.1
- monitoring with events raised by the Scheduler 29.10.4
- multiple-destination 28.3.2
  - status of child jobs 30.2.2
- overview 28.2.4.1
- priorities 29.9.2
- remote database 28.3.1.1.1
- remote external
  - about 28.3.1.2.3
- removing from an incompatibility 29.7.3
- resources 29.8.1, 29.8.2, 29.8.3
- running 29.2.4
- script jobs 28.3.1.8
- starting when a file arrives on a system 29.5.3
- starting with events raised by your application 29.5.2.1
- status 29.10.1, 30.6.2
- stopping 29.2.5
- troubleshooting remote 30.4.1.3
- viewing information on running 30.2.2
job scheduling
- dependency 28.1
- event-based 28.1
- time-based 28.1
job slaves
- replication 38.2.4.4
joins
- statement transparency in distributed databases 32.7
join views
- definition 24.1.2.2
- DELETE statements 24.1.5.3.2
- key-preserved tables in 24.1.5.2
- modifying 24.1.5.1
- rules for modifying 24.1.5.3
- updating 24.1.5.1

K

key-preserved tables
- in join views 24.1.5.2
- in outer joins 24.1.5.4
keys
- cluster 22.1
keystore 13.2.5.1, 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.5.1
listeners
- removing with srvctl 4.5.8.4
listing database links 32.5.1, 35.3.1, 35.3.2
loading data
- using external tables 20.15.2
LOBs 20.3.1
local coordinators
- distributed transactions 34.2.4
locally managed tablespaces 13.2.2.1
- automatic segment space management in 13.2.2.3
- DBMS_SPACE_ADMIN package 13.13.1
- detecting and repairing defects 13.13.1
- migrating SYSTEM from dictionary-managed 13.14
- shrinking, temporary 13.8.5
- temp files 13.2.6.2
- temporary, creating 13.2.6.2
local temporary tablespaces 13.2.6.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
locks
- in-doubt distributed transactions 35.8, 35.8.2
- monitoring 8.2.1
lock timeout interval
- distributed transactions 35.8
log
- window (Scheduler) 29.9.3.1
LOG_ARCHIVE_DEST_n initialization parameter 12.4.1
- GROUP attribute 12.4.2.1, 12.4.2.2
- PRIORITY attribute 12.4.2.1, 12.4.2.2
- REOPEN attribute 12.6.2
LOG_ARCHIVE_DEST_STATE_n initialization parameter 12.4.3
LOG_ARCHIVE_DEST initialization parameter
- specifying destinations using 12.4.1
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
log archive destination groups 12.4.2
LOGGING clause
- CREATE TABLESPACE 13.5
logging mode
- direct-path INSERT 20.4.2.4
- NOARCHIVELOG mode and 20.4.2.4.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.3
LOGON trigger
- setting resumable mode 19.2.3
logs
- job 30.2.3
- window (Scheduler) 29.9.3.1, 30.2.3
log sequence number
- control files 11.1.3.2
log switches
- description 11.1.3.2
- forcing 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.6
- 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
LONG columns 32.7
LONG RAW columns 32.7
lost write protection
- shadow lost write protection 13.11
LOST WRITE PROTECTION clause 13.11.2

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
MAKE procedure 39.2
managing
- indexes automatically 21.7
- 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
many to many subqueries
- materialized views 36.6.2.3
many to one subqueries
- materialized views 36.6.2.1
master materialized views 37.1.2
- materialized view logs 37.1.4.1
master materialized view sites 37.1.1
master sites 36.1
- advantages of 38.2.2
- compared with materialized view sites 38.2
- internal triggers 37.1.3
- materialized view registration 36.11
- materialized views 37.1.1
master tables
- materialized view logs 37.1.4.1
- materialized views 37.1.2
- redefining online 37.1.4.1
- reorganizing 37.1.4.1
materialized view logs 36.9, 37.1.4.1
- column logging 36.6.3
  - many to many subqueries 36.6.3
  - many to one subqueries 36.6.3
  - one to many subqueries 36.6.3
  - ON PREBUILT TABLE clause 36.6.3
- combination 37.1.4.1
- creating 38.2.5
- filter columns 37.1.4.2
- Import 37.1.4.3
- join columns 37.1.4.2
- logging columns 37.1.4.2
- object ID 37.1.4.1
- object tables 38.2.5
- primary key 37.1.4.1
- privileges required to create 38.2.5
- REFs 36.10.6.4
- ROWID 37.1.4.1
- trigger 37.1.3
- troubleshooting 40.3.5
- underlying table for 37.1.4.1
materialized views
- BUILD DEFERRED
  - troubleshooting 40.4
- capabilities 39.4
- collection columns
  - restrictions 36.10.5.1
- column objects
  - column subsetting 36.10.3
- column subsetting
  - column objects 36.10.3
- complex 36.4.5.1, 36.4.5.2
  - value for PCTUSED 37.4.2.1
- constraints
  - deferrable 37.4.4
- creating schemas for 38.2.4.1
- creator 36.5.1
- data subsetting 36.3.2, 36.6.1
- disconnected computing 36.3.3
- index 37.2.1
- master materialized views 37.1.2
- master materialized view sites 37.1.1
- master sites 37.1.1
- master tables 37.1.2
- materialized view logs 36.9, 37.1.4.1
- monitoring 39.7, 39.7.1
- nested tables
  - restrictions 36.10.5.1
- network loads 36.3.1
- object materialized views 39.1
  - OID preservation 36.10.4.3
- object tables 36.10.4.1
- owner 36.5.1
- Partition Change Tracking (PCT) 37.4.2.2
- preparing for 38.2.4
- primary key 36.4.2
- privileges 36.5.1, 38.2.4.3
- read-only , 36.2
  - registration 36.11.3
  - unregistering 36.11.3
- refresher 36.5.1
- refresh groups 36.8, 37.3.1
  - size 37.3.2
- refreshing 36.7, 37.4.1
  - complete 37.4.2.1
  - failures 40.3.2
  - fast 36.4.2, 37.4.2.2, 39.4
  - force 37.4.2.3
  - initiating 37.4.3
  - interval 37.4.3.1
  - on-demand 37.4.3.2
  - retries 40.3.2
  - troubleshooting 40.3, 40.3.4
- REFs 36.10.6.1
  - logging 36.10.6.4
  - scoped 36.10.6.2
  - unscoped 36.10.6.3
  - WITH ROWID clause 36.10.6.5
- registration 36.11
- reorganizing 37.1.4.1
- rowid 36.4.4
- row subsetting 36.6.1
- simple 36.4.5.2
- simple subquery
  - AND condition 36.6.3
- subqueries 36.6.2
  - column logging 36.6.3
  - EXISTS condition 36.6.3
  - joins 36.6.3
  - many to many 36.6.2.3
  - many to one 36.6.2.1
  - one to many 36.6.2.2
  - OR condition 36.6.3
  - restrictions 36.6.3
- trace file 40.3.2
- types of 36.4.1
- unions with subqueries 36.6.2.4
  - restrictions 36.6.4
- user-define 36.10.1
- user-defined data types
  - ON COMMIT REFRESH clause 36.10.1
- uses for 36.3
- varrays
  - r 36.10.5.1
materialized view sites 36.1
- adding
  - avoiding problems 39.5
- advantages of 38.2.3
- compared with master sites 38.2
- database links 38.2.4.2
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
MAXTRANS parameter
- altering 20.7.2
media recovery
- effects of archiving on 12.2.1
MEMOPTIMIZE_POOL_SIZE initialization parameter 6.8
Memoptimized Rowstore
- about 6.8
- fast ingest 6.8
- fast lookup 6.8
- MEMOPTIMIZE_POOL_SIZE initialization parameter 6.8
memory
- automatic shared memory management 6.4.2
- Database Smart Flash Cache 6.6
- managing 6.1
- manual memory management 6.4
- manual shared memory management 6.4.3
migrated rows
- eliminating from table, procedure 18.2.5.2
MINEXTENTS parameter
- cannot alter 20.7.2
mirrored files
- control files 2.6.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.19
MONITORING clause
- CREATE TABLE 20.6
MONITORING USAGE clause
- of ALTER INDEX statement 21.4.7
mounting a database 3.1.5.4
moving control files 10.3.2
multiple-destination jobs, Oracle Scheduler 28.3.2
- status of child jobs 30.2.2
multiple instances, managing CPU for 27.8.1
multiple jobs
- dropping 29.2.10
multiple temporary tablespaces 13.2.7.1, 13.2.7.4
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

N

named user limits
- setting initially 2.6.10
name resolution in distributed databases
- database links 31.4.7.1
- impact of global name changes 31.4.9.2
- procedures 31.4.9.1
- schema objects 31.2.10.4, 31.4.8.1
- synonyms 31.4.9.1
- views 31.4.9.1
- when global database name is complete 31.4.7.2
- when global database name is partial 31.4.7.3
- when no global database name is specified 31.4.7.4
nested tables
- materialized views 36.10.5
  - restrictions 36.10.5.1
- replication 36.10.5
networks
- connections, minimizing 32.3
- distributed databases use of 31.1.1.1
NEXTVAL pseudo-column 24.2.4.1, 24.2.4.1.1
- restrictions 24.2.4.1.3
NFS support 2.9.5
NO_DATA_FOUND keyword 33.5
NO_MERGE hint 33.4.3.2
NOARCHIVELOG mode
- archiving 12.2
- definition 12.2.1
- dropping data files 14.4.3
- 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.3
NOLOGGING clause
- CREATE TABLESPACE 13.5
NOLOGGING mode
- direct-path INSERT 20.4.2.4
normal transmission mode
- definition 12.5.1
Novell NetWare Management System 31.3.4.3

O

object identifiers
- agreement for replication 36.10.2
object materialized views 39.1
- OID preservation 36.10.4.3
object privileges
- for external tables 20.15.9
object quarantine 3.6, 8.3
object-relational model
- replication 36.10.1
objects
- See: schema objects
object tables
- materialized view logs 38.2.5
- materialized views 36.10.4.1
offline tablespaces
- priorities 13.6.1
- taking offline 13.6.1
OF object_type clause
- object materialized views 39.1
ON COMMIT REFRESH clause
- of CREATE MATERIALIZED VIEW 36.10.1
one to many subqueries
- materialized views 36.6.2.2
online redefinition of tables 20.8.1, 37.1.4.1
- abort and cleanup 20.8.13
- examples 20.8.15
- features of 20.8.2
- intermediate synchronization 20.8.8
- monitoring 20.8.10
- redefining a single partition
  - rules for 20.8.14.1
- redefining partitions 20.8.14
- refreshing dependent materialized views 20.8.9
- restarting after failure 20.8.11
- restrictions 20.8.4
- rolling back 20.8.12.2
- Virtual Private Database policies 20.8.6.3
- with DBMS_REDEFINITION 20.8.6.1
online redo log files
- See: online redo logs
online redo logs 11
- See also: redo log files]
- creating groups 11.3
- creating members 11.3.2
- data dictionary views reference 11.10
- 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
ON PREBUILT TABLE clause 36.6.3
OPEN_LINKS initialization parameter 32.4.3
opening windows 29.9.3.5
operating system authentication 1.6.4, 1.6.4.2
operating systems
- database administrators requirements for 1.5.1
- renaming and relocating files 14.5.2
optimizer statistics
- dynamic 9.3.4.2.2
ORA-01013 error message 3.3.6
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_SID environment variable 2.4.2
Oracle Call Interface
- See: OCI
Oracle Database In-Memory 6.7
Oracle Database users
- types of 1.1
Oracle Data Guard
- support by the Scheduler 28.5, 30.5.5
Oracle Enterprise Manager Cloud Control 3.1.1.3
Oracle home
- cloning 1.2.11
Oracle managed files
- naming 17.3.2
- scenarios for using 17.5
Oracle Managed Files
- adding to an existing database 17.5.3
- behavior 17.4
- benefits 17.1.5
- CREATE DATABASE statement 17.3.3
- creating 17.3
- creating control files 17.3.6.1
- creating data files 17.3.4.1
- creating online redo log files 17.3.7
- creating temp files 17.3.5.1
- described 17.1.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.1
- introduction 2.5.8
- renaming 17.4.3
Oracle Managed Files feature
- See: Oracle managed files
Oracle release numbers 1.4.1
Oracle Restart
- about 4.1.1
- configuration
  - adding components to 4.2.4
  - modifying 4.2.9
  - removing components from 4.2.5
  - viewing for a component 4.2.8
- configuring 4.2
- CRSCTL utility 4.1.4
- disabling and enabling management for a component 4.2.6
- environment variables in 4.2.10
- patches
  - installing 4.3
- registering a component with 4.2.4
- starting 4.1.4
- starting and stopping components managed by 4.3
  - Oracle home 4.3
- status of components 4.2.7
- 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
OracleSchedulerExecutionAgent 30.1.3.3.2
Oracle Universal Installer 2.1
ORADIM
- creating an instance 2.4.6
- enabling automatic instance startup 2.4.15
ORAPWD utility 1.7.2
OR condition
- materialized views with subqueries 36.6.3
ORGANIZATION EXTERNAL clause
- of CREATE TABLE 20.15.2
orphan key table
- example of building 25.4.1.3
OSBACKUPDBA group 1.6.4.1
OSDBA group 1.6.4.1
OSDGDBA group 1.6.4.1
OSKMDBA group 1.6.4.1
OSOPER group 1.6.4.1
OTHER_GROUPS
- for Database Resource Manager 27.1.2.2
OTHER_GROUPS for Database Resource Manager 27.5.6, 27.5.7, 27.7.5
outer joins 24.1.5.4
- key-preserved tables in 24.1.5.4
overlapping windows 28.2.10.2

P

packages
- DBMS_FILE_TRANSFER 14.7
- DBMS_METADATA 18.11.1
- DBMS_REPAIR 25.2
- DBMS_RESOURCE_MANAGER 27.1.2.1, 27.1.3, 27.2.4.1.1
- DBMS_RESOURCE_MANAGER_PRIVS 27.1.3
- DBMS_RESUMABLE 19.2.4.3
- DBMS_SPACE 19.3.4, 19.6.1
- DBMS_STORAGE_MAP 14.9.3.2
packaging and uploading problems 9.4.2
parallel execution
- managing 5.8
- parallel hints 5.8.1
- parallelizing index creation 21.2.9
- resumable space allocation 19.2.1.5
parallel hints 5.8.1
parallelizing table creation 20.2.4, 20.3.3
parallel statement execution
- directive attributes for managing 27.7.4
- managing using Resource Manager 27.3.3.3
parameter files
- See: initialization parameter file
partitioned tables
- moving a partition online 20.7.3.3
- redefining partitions online 20.8.14
  - rules for 20.8.14.1
password
- setting for SYSTEM account in CREATE DATABASE statement 2.5.2
- setting SYS in CREATE DATABASE statement 2.5.2
password file
- adding users 1.7.5
- creating 1.7.2
- ORAPWD utility 1.7.2
- removing 1.7.8
- setting REMOTE_LOGIN_PASSWORD 1.7.3
- synchronizing administrator passwords with the data dictionary 1.7.4
- viewing members 1.7.7
password file authentication 1.6.5, 1.6.5.1
passwords
- case sensitivity of 1.6.3.1, 1.6.5.1, 1.6.5.2
- password file 1.7.5
- setting REMOTE_LOGIN_PASSWORD parameter 1.7.3
patches
- installing
  - Oracle Restart 4.3
pausing chains and chain steps 29.6.16
PCTINCREASE parameter 20.7.2
PCTUSED parameter
- value for complex materialized views 37.4.2.1
PDBs
- import operations 15.2.3, 15.2.4
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.4
- monitoring 8.2
PL/SQL
- replaced views and program units 24.1.3
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
PRAGMA_EXCEPTION_INIT procedure
- assigning exception names 33.5
predefined user accounts 2.9.1
prefix compression 20.13.2.8, 21.3.8.1
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.2.2.1
prepare phase
- abort response 34.3.2.2.3
- in two-phase commit 34.3.2.1
- prepared response 34.3.2.2.1
- read-only response 34.3.2.2.2
- recognizing read-only nodes 34.3.2.2.2
- steps 34.3.2.3
prerequisites
- for creating a database 2.2.4
prespawned processes 5.7
PRIMARY KEY constraints
- associated indexes 21.3.4.2
- dropping associated indexes 21.6
- enabling on creation 21.3.4.1
- foreign key references when dropped 18.5.3.1
- indexes associated with 21.3.4.1
- materialized views 36.4.2
- replicated tables 38.1.1
priorities
- job 29.9.2
private database links 31.2.7
private synonyms 24.3.1
private temporary tables
- creating 20.3.2.4
privileges
- adding redo log groups 11.3
- altering index 21.4.1
- altering tables 20.7
- closing a database link 33.2
- creating database links 32.2.1
- creating tables 20.3
- creating tablespaces 13.2.1
- database administrator 1.5
- dropping indexes 21.6
- dropping online redo log members 11.5.2
- dropping redo log groups 11.5.1
- drop table 20.11
- enabling and disabling triggers 18.4.1
- forcing a log switch 11.6
- for external tables 20.15.9
- 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
- materialized views 36.5.1, 38.2.4.3
- renaming objects 18.6
- renaming redo log members 11.4
- RESTRICTED SESSION system privilege 3.1.5.5
- Scheduler 30.6.1
- sequences 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.1, 24.1.3, 24.1.7
problem activity log
- adding comments to 9.2.7
problems
- about 9.1.2.1
- adding comments to activity log 9.2.7
problems (critical errors)
- packaging and uploading 9.4.2
procedures
- external 5.9.1
- location transparency in distributed databases 32.6.3
- name resolution in distributed databases 31.4.9.1
- remote calls 31.5.2
processes
- See: server processes
- prespawned 5.7
PROCESSES initialization parameter
- setting before database creation 2.6.6
process manager (PMAN) 5.6
process monitor (PMON) 5.6
PRODUCT_COMPONENT_VERSION view 1.4.2
programs
- altering 29.3.3
- creating 29.3.2.1
- creating and managing, to define Scheduler jobs 29.3
- disabling 29.3.5
- dropping 29.3.4
- enabling 29.3.6
- overview 28.2.2
proxy resident connection pooling 5.3
public database links 31.2.7
- connected user 32.8.3
- fixed user 32.8.1
public fixed user database links 32.8.1
public synonyms 24.3.1
pupbld.sql 2.4.12
PURGE_LOST_DB_ENTRY procedure
- DBMS_TRANSACTION package 35.6.2

Q

quarantine
- objects 8.3
- SQL statements 9.5.3
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.4.12
quiescing a database 3.4.1
quotas
- tablespace 13.1.2

R

RAISE_APPLICATION_ERROR() procedure 33.5
read consistency
- managing in distributed databases 35.10
read-o 36.11.3
read-only database
- opening 3.2.3
read-only databases
- limitations 3.2.3
read-only materialized views , 36.2
- registration
  - manual 36.11.3
read-only Oracle home 2.2.3
read-only response
- two-phase commit 34.3.2.2.2
read-only tables 20.7.9
read-only tablespaces
- data file headers when rename 13.9
- delaying opening of data files 13.7.5
- making read-only 13.7.2
- making writable 13.7.3
- WORM devices 13.7.4
Real Application Clusters
- allocating extents for cluster 22.4.1
- sequence numbers and 24.2.2
- threads of online redo log 11.1.1
rebuilding indexes 21.4.3
- costs 21.2.13
- online 21.4.3
reclaiming unused space 19.3
RECOVER clause
- STARTUP command 3.1.5.7
recoverer process 5.6
- 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.12.1
- purging 20.12.4
- renamed objects 20.12.1
- restoring objects from 20.12.5
- viewing 20.12.3
REDEF_TABLE procedure 20.8.5
- example 20.8.15
redefining tables
- online
  - replication 37.1.4.1
redefining tables online
- See online redefinition of tables 20.8.1
redo log files 11.1
- 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.8
- contents of 11.1.2
- creating as Oracle Managed Files 17.3.7
- 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
- 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.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.3.2
- storing separately from data files 14.1.5
- threads 11.1.1
- unavailable when database is opened 3.1.5.1
- verifying blocks 11.7
redo logs
- See: online redo logredo log files
redo records 11.1.2
- LOGGING and NOLOGGING 13.5
referential integrity
- distributed database application development 33.3
refresh
- automatic 37.4.3.1
- complete 37.4.2.1
- failures 40.3.2
- fast 37.4.2.2
  - determining possibility of 39.4
- force 37.4.2.3
- group 37.4.3.1
- initiating 37.4.3
- interval 37.4.3.1
- manual 37.4.3.2
- materialized views 36.7, 37.4.1
- monitoring 39.7.3, 39.7.4
- on-demand 37.4.3.2
- retries 40.3.2
- rollback segments
  - troubleshooting 40.4
- scheduling 37.4.3.1
  - troubleshooting 40.4
- troubleshooting
  - ORA-12004 error 40.4
  - ORA-942 error 40.4
- truncating materialized views
  - troubleshooting 40.4
REFRESH_ALL_MVIEWS procedure 37.4.3.2, 39.3
REFRESH_DEPENDENT procedure 37.4.3.2, 39.3
refresh groups 36.1, 36.8, 37.3.1
- monitoring 39.7.2
- size considerations 37.3.2
- troubleshooting 40.3
REFRESH procedure 37.4.3.2, 39.3
REFs
- materialized views 36.10.6.1
- replication 36.10.6.1
REGISTER_MVIEW procedure 36.11.3
release numbers 1.4.1
releases 1.4
- checking the Oracle Database release number 1.4.2
- definition 1.4.1
release update (Update) 1.4.1
release update revision (Revision) 1.4.1
Release Update Revisions (Revisions)
- installing 1.2.10
Release Updates (Updates)
- installing 1.2.10
relocating control files 10.3.2
REMOTE_LOGIN_PASSWORDFILE initialization parameter 1.7.3
REMOTE_OS_AUTHENT initialization parameter
- connected user database links 31.2.8.2
remote data
- querying 32.7
- updating 32.7
remote database jobs 28.3.1.1.1
- Scheduler agent setup 30.1.3.2
remote external jobs
- about 28.3.1.2.3
- executing 30.1.3
- Scheduler agent setup 30.1.3.2
remote procedure calls 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
RENAME statement 18.6
renaming control files 10.3.2
renaming files
- Oracle Managed Files 17.4.3
renaming indexes 21.4.6
REOPEN attribute
- LOG_ARCHIVE_DEST_n initialization parameter 12.6.2
repairing data block corruption
- DBMS_REPAIR 25.1
repair table
- example of building 25.4.1.2
repeat interval, schedule 29.4.5.1
replication
- filter columns 37.1.4.2
- job slaves 38.2.4.4
- master sites
  - advantages 38.2.2
- materialized view logs 36.9
- materialized view sites
  - advantages 38.2.3
- monitoring
  - materialized view environments 39.7
- read-only materialized views 36.2
- refresh 36.7
- refresh groups 36.1, 36.8
- sites 36.1
  - choosing 38.2
- tables 38.1
- unsupported data types
  - BFILE 38.1.3
  - LONG 38.1.3
- unsupported table types 38.1.4
- user-defined data types 36.10.1
- virtual private database (VPD) 38.2.4.2
replication catalog
- DBA_REGISTERED_MVIEWS 36.11.1
- USER_REFRESH 40.3.2
- USER_REFRESH_CHILDREN 40.3.2
replication objects
- at materialized view sites
  - problems creating 40.2
- indexes
  - on foreign keys 38.1.2
- tables 38.1
  - foreign keys 38.1.2
  - primary keys 38.1.1
reporting problems to Oracle Support 9.4
RESOLVE_TNSNAME function 32.5.3
RESOURCE_MANAGER_PLAN initialization parameter 27.6
resource allocation methods
- ACTIVE_SESS_POOL_MTH 27.5.5
- active session pool 27.5.5
- CPU 27.3.1
- CPU resource 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_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
- PGA 27.3.4
- QUEUEING_MTH 27.5.5
- queuing resource allocation method 27.5.5
resource consumer groups 27.1.2.1
- changing 27.2.4.1.1
- creating 27.5.3
- DEFAULT_CONSUMER_GROUP 27.2.6.1, 27.9.2
- deleting 27.9.2
- granting the switch privilege 27.2.6.1
- managing 27.2, 27.2.4.2
- OTHER_GROUPS 27.1.2.2, 27.5.6, 27.5.7, 27.7.5
- parameters 27.5.3
- revoking the switch privilege 27.2.6.3
- setting initial 27.2.2
- switching a session 27.2.4.1.2
- switching sessions for a user 27.2.4.1.3
- SYS_GROUP 27.7.5
- updating 27.9.1
Resource Manager
- AUTO_TASK_CONSUMER_GROUP consumer group 26.5
- canceling long-running SQL statements 27.3.5.2
- managing parallel statement execution 27.3.3.3
- quarantine SQL statements 27.3.5.2
resource plan directives 27.1.2.1, 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.1, 27.1.2.7
- 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
- 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
resources (job)
- altering 29.8.2
- creating 29.8.1
- managing 29.8
- specifying for jobs 29.8.3
RESTRICTED SESSION system privilege
- restricted mode and 3.1.5.5
result sets, SQL 20.3.2.1
RESUMABLE_TIMEOUT initialization parameter
- setting 19.2.2.2
resumable space allocation
- correctable errors 19.2.1.3
- detecting suspended statements 19.2.4
- disabling 19.2.2.1
- distributed databases 19.2.1.4
- enabling 19.2.2.1
- example 19.2.6
- how resumable statements work 19.2.1.1
- naming statements 19.2.2.3.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.3.1, 19.2.4.1
retention guarantee (for undo) 16.2.2.3
reversing table changes 20.9
RMAN
- See: Recovery Manager
roles
- DBA role 1.5.2.5
- obtained through database links 31.2.11
rollbacks
- ORA-02 33.3
ROLLBACK statement
- FORCE clause 35.5, 35.5.1.2, 35.5.2
- forcing 35.4.2
rolling upgrade 28.5
rowids
- rowid materialized views 36.4.4
rows
- listing chained or migrated 18.2.5
row subsetting
- materialized views 36.6.1
rules
- adding to a chain 29.6.5
- dropping from chains 29.6.11
running
- chains 29.6.10
- jobs 29.2.4

S

Sample Schemas
- description 2.9.6
savepoints
- in-doubt transactions 35.5, 35.5.2
scalable sequences 24.2.4.3
schagent utility 30.1.3.3.1
Scheduler
- administering 30
- architecture 28.4.1
- configuring 30.1
- credentials for jobs 28.2.7
- data dictionary views reference 30.6.2
- e-mail notifications 29.10.5
- examples of using 30.5
- import and export 30.3
- maintenance window 26.2
- monitoring and managing 30.2
- monitoring jobs 29.10.1
- 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.6.1
SCHEDULER_BATCH_ERRORS view 29.2.10
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.5
Scheduler job credentials
- specifying 29.2.2.3
Scheduler objects, naming 29.1
Scheduler privileges reference 30.6.1
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.3
schema objects
- analyzing 18.2.1
- 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.10.4
- global names 31.2.10.4
- listing by type 18.11.2.1
- name resolution in distributed databases 31.2.10.4, 31.4.8.1
- name resolution in SQL statements 18.8
- privileges to rename 18.6
- referencing with synonyms 32.6.2.1
- renaming 18.6
- validating structure 18.2.3
- viewing information 18.11, 19.6
schema objects space usage
- data dictionary views reference 19.6.2
schemas
- creating for materialized views 38.2.4.1
SCN
- See: system change number
SCOPE clause 2.7.6.2.1
script jobs 28.3.1.8
scripts, authenticating users in 2.9.3
security
- accessing a database 7.1
- administrator of 7.1
- centralized user management in distributed databases 31.3.2.4.1
- 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
SEGMENT_FIX_STATUS procedure
- DBMS_REPAIR 25.2.1
Segment Advisor 19.3.2.1
- configuring Scheduler job 19.3.2.6
- invoking with Oracle Enterprise Manager Cloud Control 19.3.2.4.1
- invoking with PL/SQL 19.3.2.4.2
- running manually 19.3.2.4
- using 19.3.2.2
- viewing results 19.3.2.5
- views 19.3.2.7
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.3
sequences
- accessing 24.2.4
- altering 24.2.3
- caching sequence numbers 24.2.4.2.1
- creating 24.2.2, 24.2.4.2.3
- 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
- scalable 24.2.4.3
server-generated alerts 8.1.2.1
SERVER parameter
- net service name 32.3.3.1
server parameter file
- creating 2.7.4
- defined 2.7.1
- exporting 2.7.8
- migrating to 2.7.2
- recovering 2.7.10
- RMAN backup 2.7.9
- setting initialization parameter values 2.7.6
- SPFILE initialization parameter 2.7.5
- viewing parameter settings 2.7.11
server processes
- archiver (ARCn) 5.6
- background 5.6
- checkpoint (CKPT) 5.6
- database writer (DBWn) 5.6
- dedicated 5.1.1
- dispatcher (Dnnn) 5.6
- dispatchers 5.4.4.3
- log writer (LGWR) 5.6
- monitoring locks 8.2.1
- process monitor (PMON) 5.6
- recoverer (RECO) 5.6
- shared server 5.1.2
- system monitor (SMON) 5.6
- trace files for 8.1.1.1
servers
- role in two-phase commit 34.2.3
service names
- database links and 32.2.4
services
- controlling automatic startup of 3.1.3
- creating with SRVCTL and Oracle Restart 4.2.11
- role-based 3.1.3
sessions
- active 5.10.3
- inactive 5.10.4
- setting advice for transactions 35.4.3.3
- terminating 5.10
session trees for distributed transactions
- clients 34.2.2
- commit point site 34.2.6.1, 34.2.6.3
- database servers 34.2.3
- definition 34.2.1
- global coordinators 34.2.5
- local coordinators 34.2.4
- tracing transactions 35.3.2
SET TIME_ZONE clause
- ALTER SESSION 2.5.10.1
- CREATE DATABASE 2.5.10.1
SGA
- See: system global area
shadow lost write protection 13.11
- creating tablespaces for 13.11.2
- disabling 13.11.5
- dropping a shadow tablespace 13.11.7
- enabling for a database 13.11.3
- enabling for a data file 13.11.4
- enabling for a PDB 13.11.3
- enabling for a tablespace 13.11.4
- removing 13.11.6
- suspending 13.11.6
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.9
- shared servers, creating links to 32.3.3.2
shared server 5.1.2
- configuring dispatchers 5.4.4
- data dictionary views reference 5.4.6
- disabling 5.4.3.2, 5.4.5
- initialization parameters 5.4.1
- interpreting trace output 8.1.1.5
- setting minimum number of servers 5.4.3.2
- trace files for processes 8.1.1.1
shared SQL
- for remote and distributed statements 31.4.3
shared temporary tablespaces 13.2.6.1
shrinking segments online 19.3.3
shutdown
- default mode 3.3.2
SHUTDOWN command
- IMMEDIATE clause 3.3.3
- interrupting 3.3.6
- NORMAL clause 3.3.2
simple materialized views 36.4.5.2
Simple Network Management Protocol (SNMP) support
- database management 31.3.4.3
single-file tablespaces
- description 13.2.3.1
single-instance
- defined 2.4.1
single-table hash clusters 23.3.3
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.17
SORT_AREA_SIZE initialization parameter
- index creation and 21.2.1
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.2
SPFILE initialization parameter 2.7.5
SQL
- result sets 20.3.2.1
- submitting 1.3.1
- test cases 9.3.4
SQL_TRACE initialization parameter
- trace files and 8.1.1.1
SQL*Loader
- about 1.8, 20.4.1
SQL*Plus 1.3.1
- about 1.3.2
- connecting with 1.3.3.1
- starting 3.1.4
- starting a database 3.1.1.1
- starting an instance 3.1.1.1
SQL failure
- repairing with SQL Repair Advisor 9.5.1
SQL incidents 9.3.4.2.1
SQL patch
- disabling using Cloud Control 9.5.1.4
- disabling using DBMS_SQLDIAG package subprogram 9.5.1.5
- removing using Cloud Control 9.5.1.4
- removing using DBMS_SQLDIAG package subprogram 9.5.1.5
- viewing using Cloud Control 9.5.1.4
SQL Repair Advisor
- about 9.5.1.1
- exporting and importing a patch using the DBMS_SQLDIAG package subprograms 9.5.1.6
- repairing SQL failure with 9.5.1
- running using Cloud Control 9.5.1.2
- running using the DBMS_SQLDIAG package subprograms 9.5.1.3
SQL statements
- about quarantine 9.5.3.1
- cancelling 5.10.5
- distributed databases and 31.4.1
- quarantine 9.5.3
SQL test case builder 9.1.1
SQL Test Case Builder 9.3.4.1
- accessing the Incident Manager 9.3.4.3.1.1
- accessing the Support Workbench 9.3.4.3.1.2
- command-line interface 9.3.4.3.2
- gathering diagnostic data 9.3.4
- graphical interface 9.3.4.3.1
- key concepts 9.3.4.2
- output 9.3.4.2.3
- running 9.3.4.4
- SQL incidents 9.3.4.2.1
- user interfaces 9.3.4.3
- what it captures 9.3.4.2.2
SRVCTL
- add asm command 4.5.1.1.1
- add command, usage description 4.5.1
- add database command 4.5.1.2.1
- adding a disk group with 4.5.1
- add listener command 4.5.1.3.2
- add ons command 4.5.1.4
- case sensitivity 4.5, 4.6
- case sensitivity of commands 4.5, 4.6
- command reference 4.5
- commands
  - downgrade database 4.5.4.1
  - upgrade database 4.5.14.1, 4.5.15.1
- commands, case sensitivity 4.5, 4.6
- component names 4.5
- config asm command 4.5.2.1.1
- config command, usage description 4.5.2
- config database command 4.5.2.2.1
- config listener command 4.5.2.3.1
- config ons command 4.5.2.4
- config service command 4.5.2.5.1
- creating and deleting databases services with 4.2.11
- disable asm command 4.5.3.1.1
- disable command, usage description 4.5.3
- disable database command 4.5.3.2.1
- disable diskgroup command 4.5.3.3
- disable listener command 4.5.3.4
- disable ons command 4.5.3.5
- disable service command 4.5.3.6.1
- enable asm command 4.5.5.1.1
- enable command, usage description 4.5.5
- enable database command 4.5.5.2.1
- enable diskgroup command 4.5.5.3
- enable listener command 4.5.5.4
- enable ons command 4.5.5.5
- enable service command 4.5.5.6.1
- getenv asm command 4.5.6.1
- getenv command, usage description 4.5.6
- getenv database command 4.5.6.2
- getenv listener command 4.5.6.3
- help for 4.2.3
- modify asm command 4.5.7.1.1
- modify command, usage description 4.5.7
- modify database command 4.5.7.2.1
- modify listener command 4.5.7.3.1
- modify ons command 4.5.7.4
- modify service command 4.5.7.5
- preparing to run 4.2.2
- reference 4.5
- remove asm command 4.5.8.1.1
- remove command, usage description 4.5.8
- remove database command 4.5.8.2.1
- remove diskgroup command 4.5.8.3
- remove listener command 4.5.8.4
- remove ons command 4.5.8.5
- remove service command 4.5.8.6.1
- setenv asm command 4.5.9.1.2
- setenv command, usage description 4.5.9
- setenv database command 4.5.9.2.2
- setenv listener command 4.5.9.3.2
- start asm command 4.5.10.1.1
- start command, usage description 4.5.10
- start database command 4.5.10.2.1
- start diskgroup command 4.5.10.3
- start home command 4.5.10.4
- start listener command 4.5.10.5.1
- start ons command 4.5.10.6
- start service command 4.5.10.7.1
- status asm command 4.5.11.1.1
- status command, usage description 4.5.11
- status database command 4.5.11.2.1
- status diskgroup command 4.5.11.3
- status home command 4.5.11.4
- status listener command 4.5.11.5
- status ons command 4.5.11.6
- status service command 4.5.11.7.1
- stop asm command 4.5.12.1.1
- stop command, usage description 4.5.12
- stop database command 4.5.12.2.1
- stop diskgroup command 4.5.12.3
- stop home command 4.5.12.4
- stop listener command 4.5.12.5.1
- stop ons command 4.5.12.6
- stop service command 4.5.12.7.1
- unsetenv asm command 4.5.13.1.2
- unsetenv command, usage description 4.5.13
- unsetenv database command 4.5.13.2.2
- unsetenv listener command 4.5.13.3.2
SRVCTL stop option
- default 3.3.2
STALE status
- of redo log members 11.5.2
stalled chain (Scheduler) 29.6.20
standby transmission mode
- definition of 12.5.2
starting a database 3.1
- forcing 3.1.5.6
- Oracle Enterprise Manager Cloud Control 3.1.1.3
- recovery and 3.1.5.7
- Recovery Manager 3.1.1.2
- restricted mode 3.1.5.5
- SQL*Plus 3.1.1.1
- when control files unavailable 3.1.5.1
- when redo logs unavailable 3.1.5.1
starting an instance
- automatically at system startup 3.1.5.8
- database closed and mounted 3.1.5.4
- forcing 3.1.5.6
- mounting and opening the database 3.1.5.2
- normally 3.1.5.2
- Oracle Enterprise Manager Cloud Control 3.1.1.3
- recovery and 3.1.5.7
- Recovery Manager 3.1.1.2
- remote instance startup 3.1.5.9
- restricted mode 3.1.5.5
- SQL*Plus 3.1.1.1
- when control files unavailable 3.1.5.1
- when redo logs unavailable 3.1.5.1
- without mounting a database 3.1.5.3
startup
- of database services, controlling 3.1.3
STARTUP command
- NOMOUNT clause 2.4.9
- RECOVER clause 3.1.5.7
- starting a database 3.1.1.1, 3.1.5
statement transparency in distributed database
- managing 32.7
statistics
- automatically collecting for tables 20.6
STATISTICS_LEVEL initialization parameter
- Database Resource Manager 27.1.1
statistics, optimizer
- dynamic 9.3.4.2.2
stderr
- for local external jobs 28.3.1.2.2, 28.3.1.2.3
  - retrieving 28.3.1.2.2, 28.3.1.2.3
stdout
- for local external jobs 28.3.1.2.2, 28.3.1.2.3
  - retrieving 28.3.1.2.2, 28.3.1.2.3, 29.2.2.10
steps, chain
- dropping 29.6.13
stopping
- chains 29.6.14
- chain steps 29.6.15
- jobs 29.2.5
storage parameters
- INITIAL 20.7.2
- INITRANS, altering 20.7.2
- MAXTRANS, altering 20.7.2
- MINEXTENTS 20.7.2
- PCTINCREASE 20.7.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.1
subqueries
- in remote updates 31.4.1
- in unions
  - materialized views 36.6.2.4
- materialized views 36.6.2, 36.6.3
  - AND condition 36.6.3
  - column logging 36.6.3
  - EXISTS condition 36.6.3
  - joins 36.6.3
  - many to many 36.6.2.3
  - many to one 36.6.2.1
  - one to many 36.6.2.2
  - restrictions 36.6.3
- statement transparency in distributed databases 32.7
subsetting
- materialized views 36.6.1
  - column objects 36.10.3
SunSoft SunNet Manager 31.3.4.3
Support Workbench 9.1.3.7
- for Oracle ASM instance 9.3.1.1
- viewing problems with 9.3.1.1
Support Workbench, accessing 9.3.4.3.1.2
SWITCH LOGFILE clause
- ALTER SYSTEM statement 11.6
synonyms
- 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.1
- private 24.3.1
- public 24.3.1
- remote object security 32.6.2.2
SYS_GROUP for Database Resource Manager 27.7.5
SYS account 1.5.2
- objects owned 1.5.2.2
- specifying password for CREATE DATABASE statement 2.5.2
SYSAUX tablespace 13.2.1
- about 2.5.4.1
- cannot rename 13.9
- creating at database creation 2.5.4.1
- DATAFILE clause 2.5.4.1
- monitoring occupants 13.12.1
- moving occupants 13.12.2
SYSBACKUP account 1.5.2, 1.5.2.4
- connecting as 1.6.1
SYSDBA account
- connecting as 1.6.1
SYSDBA administrative privilege
- adding users to the password file 1.7.5
- determining who has privileges 1.7.7
- granting and revoking 1.7.6
SYSDG account 1.5.2, 1.5.2.4
- connecting as 1.6.1
SYSKM account 1.5.2, 1.5.2.4
- connecting as 1.6.1
SYSOPER account
- connecting as 1.6.1
SYSOPER administrative privilege
- adding users to the password file 1.7.5
- determining who has privileges 1.7.7
- granting and revoking 1.7.6
SYSRAC account 1.5.2.4
- connecting as 1.6.1
SYSTEM_PLAN for Database Resource Manager 27.7.5
SYSTEM account 1.5.2
- objects owned 1.5.2.3
- specifying password for CREATE DATABASE 2.5.2
system change numbers
- coordination in a distributed database system 34.3.3.2
- in-doubt transactions 35.5.1.3
- using V$DATAFILE to view information about 14.10
- when assigned 11.1.2
system global area
- holds sequence number cache 24.2.4.2.1
system monitor process (SMON) 5.6
system privileges
- ADMINISTER_RESOURCE_MANAGER 27.1.3
- for external tables 20.15.9
SYSTEM tablespace
- cannot rename 13.9
- creating locally managed 2.5.3
- restrictions on taking offline 14.4.1
- when created 13.2.1

T

table compression 38.1.4
tables
- about 20.1
- adding columns 20.7.6
- allocating extents 20.7.4
- altering 20.7.1
- altering physical attributes 20.7.2
- analyzing 18.2.1
- attribute-clustered 20.2.9
- bulk updates 20.5
- compressed 20.2.6.1
- creating 20.3
- data dictionary views reference 20.17
- deferred segment creation 20.2.14
- designing before creating 20.2.1
- dropping 20.11
- dropping columns 20.7.8
- estimating size 20.2.16
- estimating space use 19.7.1
- external 20.15
- Flashback Drop 20.12
- Flashback Table 20.10
- global temporary 20.3.2.3
- guidelines for managing 20.2
- hash clustered
  - See hash clusters 23.3.1
- hybrid partitioned 20.16
- increasing column length 20.7.5
- index-organized 20.13
- invisible columns 20.2.12.1
- key-preserved 24.1.5.2
- limiting indexes on 21.2.4
- managing 20
- modifying column definition 20.7.5
- moving 20.7.3.1
- parallelizing creation 20.2.4, 20.3.3
- partitioned 20.14
- partitions
  - moving online 20.7.3.3
- private temporary 20.3.2.4
- read-only 20.7.9
- redefining online 20.8.1
  - replication 37.1.4.1
- renaming columns 20.7.7
- replicating 38.1
- researching and reversing erroneous changes to 20.9
- 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.6
- temporary 20.3.2.1
- truncating 18.3
- types 20.2.2
- unrecoverable (NOLOGGING) 20.2.5
- validating structure 18.2.3
- zone maps 20.2.10
table size
- estimating 19.7.1
tablespaces
- adding data files 14.2
- assigning user quotas 13.1.2
- autoextending 13.8.1
- automatic segment space management 13.2.2.3
- bigfile 2.5.9, 13.2.3.1
- checking default storage parameters 13.15.2
- compressed 13.2.4
- containing XMLTypes 15.1.4
- creating undo tablespace at database creation 2.5.5, 2.5.9.2
- data dictionary views reference 13.15.1
- DBMS_SPACE_ADMIN package 13.13.1
- default temporary tablespace, creating 2.5.7, 2.5.9.2
- detecting and repairing defects 13.13.1
- diagnosing and repairing problems in locally managed 13.13.1
- dictionary managed 13.2.3.3
- dropping 13.10
- encrypted 13.2.5.1
  - creating 13.2.5.2
- guidelines for managing 13.1
- increasing size 13.8.1
- listing files of 13.15.3
- listing free space in 13.15.4
- locally managed 13.2.2.1
- locally managed temporary 13.2.6.2
- location 14.1.4
- migrating SYSTEM to locally managed 13.14
- on a WORM device 13.7.4
- Oracle Managed Files, managing 17.5.1, 17.5.2
- overriding default type 2.5.9.2
- quotas, assigning 13.1.2
- read-only 13.7.1
  - mounting 15.1.2.2.4
- renaming 13.8, 13.9
- setting default type 2.5.9.1
- single-file 2.5.9, 2.5.9.2, 13.2.3.1, 13.8.3
- space usage alerts 19.1.2
- specifying nonstandard block sizes 13.4
- SYSAUX 13.2.1, 13.9
- SYSAUX, managing 13.12
- SYSAUX creation 2.5.4.1
- SYSTEM 13.2.1, 13.2.2.1
- taking offline normal 13.6.1
- taking offline temporarily 13.6.1
- temp files in locally managed 13.2.6.2
- temporary 13.2.6.1, 13.2.7.4
- temporary bigfile 13.2.6.3
- temporary for creating large indexes 21.3.5
- undo 16.1
- using multiple 13.1.1
- using Oracle Managed Files 17.3.4.1
tablespace set 15.3.3.1
TEMP_UNDO_ENABLED parameter 16.7
temp files 13.2.6.2
- creating as Oracle managed 17.3.5.1
- dropping 14.6
- dropping Oracle managed 17.4.1
temporary segments
- index creation and 21.2.1
temporary tables 38.1.4
- global 20.3.2.1
- private 20.3.2.1
temporary tablespace, default
- specifying at database creation 17.3.3.5
temporary tablespaces
- altering 13.8.4
- bigfile 13.2.6.3
- creating 13.2.6.2
- groups 13.2.7.1
- renaming default 13.9
- shrinking, locally managed 13.8.5
temporary undo 16.7
terminating user sessions
- active sessions 5.10.3
- identifying sessions 5.10.2
- inactive session, example 5.10.4
- inactive sessions 5.10.4
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.2
threshold-based alerts
- server-generated 8.1.2.1
thresholds
- setting alert 19.1.2
time zone
- files 2.5.10.2
- setting for database 2.5.10.1
trace files 9.1.3.3
- location of 8.1.1.1
- log writer process and 11.2.1.1
- materialized views 40.3.2
- using 8.1.1.1
- when written 8.1.1.4
trace files, finding 9.3.3.2
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.9.4
transaction management
- overview 34.3.1
transaction processing
- distributed systems 31.4
transactions
- closing database links 33.2
- distributed and two-phase commit 31.4.6
- in-doubt 34.3.2.3, 34.4.1, 34.4.4, 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.9.2
- columns 20.2.13
- keystore 13.2.5.1, 20.2.13
- tablespaces 13.2.5.1
transporting data
- 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.3
- enabling 18.4.2
- for materialized view log 37.1.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
tuning
- analyzing tables 33.4.2.3.2
- cost-based optimization 33.4.2.2
two-phase commit
- case study 34.5.1
- commit phase 34.3.3, 34.5.5
- described 31.4.6
- discovering problems with 35.4.1
- distributed transactions 34.3.1
- example 34.5.1
- forget phase 34.3.4
- in-doubt transactions 34.4.1, 34.4.4
- phases 34.3.1
- prepare phase 34.3.2.1, 34.3.2.3
- recognizing read-only nodes 34.3.2.2.2
- specifying commit point strength 35.1
- steps in commit phase 34.3.3.1
- tracing session tree in distributed transactions 35.3.2
- viewing database links 35.3.1

U

UNDO_MANAGEMENT initialization parameter 2.5.5
UNDO_TABLESPACE initialization parameter
- for undo tablespaces 2.6.8.2
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.2
- explained 16.2.2.1
- guaranteeing 16.2.2.3
- 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.3.4
undo tablespaces
- altering 16.5.2
- creating 16.5.1.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.4.10, 2.5.5, 2.5.9.2
- switching 16.5.4
- user quotas 16.5.5
unions
- with subqueries
  - materialized views 36.6.2.4
  - restrictions for materialized views 36.6.4
UNIQUE key constraints
- associated indexes 21.3.4.2
- dropping associated indexes 21.6
- enabling on creation 21.3.4.1
- foreign key references when dropped 18.5.3.1
- indexes associated with 21.3.4.1
UNRECOVERABLE DATAFILE clause
- ALTER DATABASE statement 11.8
UNREGISTER_MVIEW procedure 36.11.3
unusable indexes 21.2.11
updates
- bulk 20.5
- location transparency and 31.5.1.2
upgrading a database 2.1
us 36.10.3
USER_DB_LINKS view 32.5.1
USER_DUMP_DEST initialization parameter 9.1.3.1
USER_REFRESH_CHILDREN view 40.3.2
USER_REFRESH view 40.3.2
user accounts
- predefined 2.9.1, 7.5
user-defined data types
- materialized views 36.10.1
  - collections 36.10.5
  - object tables 36.10.4.1
  - ON COMMIT REFRESH clause 36.10.1
  - REFs 36.10.6.1
  - type agreement 36.10.2
- replication 36.10.1
  - collections 36.10.5
  - column objects 36.10.1
  - REFs 36.10.6.1
  - type agreement 36.10.2
users
- assigning tablespace quotas 13.1.2
- in a newly created database 2.9.1
- limiting number of 2.6.10
- predefined 2.9.1
- session, terminating 5.10.4
- 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.5.1
UTLCHN1.SQL script
- listing chained rows 18.2.5.1
UTLLOCKT.SQL script 8.2.1
utlrp.sql 2.4.12

V

V$ARCHIVE view 12.8
V$CLONEDFILE view 2.10.1.3
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_RATE view
- monitoring shared server dispatchers 5.4.4.4
V$DISPATCHER view
- monitoring shared server dispatchers 5.4.4.4
V$ENCRYPTED_TABLESPACES view 13.2.5.3, 13.15.1
V$LOG_HISTORY view 11.10
V$LOGFILE view 11.10
- log file status 11.5.2
V$LOG view 11.10, 12.8
- displaying archiving status 12.8
V$PWFILE_USERS view 1.7.7
V$QUARANTINE view 8.3.2
V$QUEUE view
- monitoring shared server dispatchers 5.4.4.4
V$SESSION view 5.10.4
V$THREAD view 11.10
V$TIMEZONE_NAMES view
- time zone table information 2.5.10.2
V$VERSION view 1.4.2
VALIDATE STRUCTURE clause
- of ANALYZE statement 18.2.3
VALIDATE STRUCTURE ONLINE clause
- of ANALYZE statement 18.2.3
varrays
- materialized 36.10.5
- materialized views
  - restrictions 36.10.5.1
- replication 36.10.5
verifying blocks
- redo log files 11.7
viewing
- alerts 19.1.3
- incident package details 9.4.3.1
views
- creating 24.1.2.1
- creating with errors 24.1.2.4
- data dictionary
  - for archived redo log files 12.8.1
  - for clusters 22.6
  - for control files 10.8
  - for database 2.12
  - for database resident connection pooling 5.5.3
  - for Database Resource Manager 27.13.3
  - for data files 14.10
  - for hash clusters 23.6
  - for indexes 21.8
  - for Oracle Scheduler 30.6.2
  - for redo log 11.10
  - for schema objects 18.11.2
  - for sequences 24.4
  - for shared server 5.4.6
  - for space usage in schema objects 19.6.2
  - for synonyms 24.4
  - for tables 20.17
  - for tablespaces 13.15.1
  - 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
- 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.1
- invalid 24.1.4
- join
  - See join views 24.1.2.2
- 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.1
- ORDER BY clause and 24.1.2.1
- remote object security 32.6.1
- restrictions 24.1.4
- using 24.1.4
- V$ARCHIVE 12.8
- V$DATABASE 12.8.1
- V$LOG 12.8
- V$LOGFILE 11.5.2
- wildcards in 24.1.2.3
- WITH CHECK OPTION 24.1.2.1
virtual columns 20.1, 38.1.4
- indexing 21.2.2
Virtual Private Database
- redefining tables online 20.8.6.3
virtual private database (VPD) 38.2.4.2

W

wildcards
- in views 24.1.2.3
window groups
- creating 29.9.4.2
- disabling 29.9.4.7
- dropping 29.9.4.3
- dropping a member from 29.9.4.5
- enabling 29.9.4.6
- managing job scheduling and job priorities with 29.9.4
- overview 28.2.11.3
window logs 29.9.3.1
windows, managing job scheduling and resource allocation with 29.9.3.1
windows (Scheduler)
- altering 29.9.3.4
- closing 29.9.3.6
- creating 29.9.3.3
- disabling 29.9.3.8
- dropping 29.9.3.7
- enabling 29.9.3.9
- opening 29.9.3.5
- overlapping 28.2.10.2
- overview 28.2.10.1
WITH ROWID clause
- REFs 36.10.6.5
workloads
- managing with database services 2.8
WORM devices
- and read-only tablespaces 13.7.4
WRH$_UNDOSTAT view 16.8

X

XMLTypes
- transporting data 15.1.4

Z

zone maps 20.2.10