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

.trm files 7.1.3.4

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.6.1
adaptive query optimization
- adaptive plans 7.3.4.2.2
adaptive query plans 7.3.4.2.2
adding
- columns 19.7.6
- columns in compressed tables 19.7.6
ADD LOGFILE clause
- ALTER DATABASE statement 9.3.1
ADD LOGFILE MEMBER clause
- ALTER DATABASE statement 9.3.2
ADMIN_TABLES procedure
- DBMS_REPAIR package 24.2.1
- example 24.4.1.2, 24.4.1.3
ADMINISTER_RESOURCE_MANAGER system privilege 26.1.4.1
administering
- the Scheduler 29
administration
- distributed databases 32
administrative user accounts 1.6.2.1
- SYS 1.6.2
- SYSBACKUP 1.6.2
- SYSDG 1.6.2
- SYSKM 1.6.2
administrator passwords, synchronizing password file and data dictionary 1.8.4
ADR
- See: automatic diagnostic repository
ADR base 7.1.4
ADRCI utility 7.1.3.9
ADR home 7.1.4
advanced index compression 20.3.8.2
advanced row compression 19.2.6.1
Advisor
- Data Repair 7.1.1
- Undo 14.4
AFTER SUSPEND trigger
- example of registering 18.2.6
agent
- Heterogeneous Services, definition of 31.1.2.1
aggregate functions
- statement transparency in distributed databases 32.7
alert log 7.1.3.2
- about 6.1.1.1
- size of 6.1.1.2
- using 6.1.1.1
- viewing 7.3.3.1
- when written 6.1.1.4
alerts
- server-generated 6.1.2.1
- tablespace space usage 18.1.2
- threshold-based 6.1.2.1
- viewing 18.1.3
alert thresholds
- setting for locally managed tablespaces 18.1.2
ALL_DB_LINKS view 32.5.1
allocation
- extents 19.7.4
ALTER CLUSTER statement
- ALLOCATE EXTENT clause 21.4.1
- using for hash clusters 22.4
- using for index clusters 21.4.1
ALTER DATABASE statement
- ADD LOGFILE clause 9.3.1
- ADD LOGFILE MEMBER clause 9.3.2
- ARCHIVELOG clause 10.3.2
- CLEAR LOGFILE clause 9.8
- DATAFILE...OFFLINE DROP clause 12.4.3
- DROP LOGFILE clause 9.5.1
- DROP LOGFILE MEMBER clause 9.5.2
- NOARCHIVELOG clause 10.3.2
- RENAME FILE clause 12.5.2.2
- UNRECOVERABLE DATAFILE clause 9.8
ALTER INDEX statement
- COALESCE clause 20.2.13
altering
- (Scheduler) windows 28.9.3.4
- event-based job 28.5.2.3
- event schedule 28.5.2.5
- indexes 20.4.1
- job classes 28.9.1.3
- jobs 28.2.3
- programs 28.3.3
- schedules 28.4.3
ALTER SEQUENCE statement 23.2.3
ALTER SESSION statement
- ADVISE clause 35.4.3.3
- CLOSE DATABASE LINK clause 33.2
- Enabling resumable space allocation 18.2.2.3
ALTER SYSTEM FLUSH FLASH_CACHE 4.7.3
ALTER SYSTEM statement
- ARCHIVE LOG ALL clause 10.3.3
- DISABLE DISTRIBUTED RECOVERY clause 35.9.2
- ENABLE DISTRIBUTED RECOVERY clause 35.9.2
- enabling Database Resource Manager 26.2
- SET RESOURCE_MANAGER_PLAN 26.2
- SET SHARED_SERVERS initialization parameter 3.4.3.2
- SWITCH LOGFILE clause 9.6
ALTER TABLESPACE statement
- adding an Oracle managed data file, example 15.3.4.4
- adding an Oracle managed temp file, example 15.3.5.3
- ONLINE clause, example 11.6.2
- READ ONLY clause 11.7.2
- RENAME DATAFILE clause 12.5.2.1.1
ALTER TABLE statement
- ALLOCATE EXTENT clause 19.7.4
- DEALLOCATE UNUSED clause 19.7.4
- DISABLE ALL TRIGGERS clause 17.6.3
- DISABLE integrity constraint clause 17.7.3.1
- DROP COLUMN clause 19.7.8.1
- DROP integrity constraint clause 17.7.3.3
- DROP UNUSED COLUMNS clause 19.7.8.2
- ENABLE ALL TRIGGERS clause 17.6.2
- ENABLE integrity constraint clause 17.7.3.1
- external tables 19.15.3
- modifying index-organized table attributes 19.13.3.1
- MOVE clause 19.7.3.1, 19.7.3.2, 19.7.3.3, 19.13.3.2
- reasons for use 19.7.1
- SET UNUSED clause 19.7.8.2
ALTER TRIGGER statement
- DISABLE clause 17.6.3
- ENABLE clause 17.6.2
ANALYZE statement
- CASCADE clause 17.4.3
- CASCADE clause, FAST option 17.4.3
- corruption reporting 24.3.1.4
- listing chained rows 17.4.5
- remote tables 33.4.2.3.2
- validating structure 17.4.3, 24.3.1.1
analyzing schema objects 17.4.1
analyzing tables
- distributed processing 33.4.2.3.2
AND condition
- for simple subquery materialized views 36.6.3
APPEND hint 19.2.6.2
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 10.4.4
- archiving modes 10.3.2
- data dictionary views 10.8.1
- destination availability state, controlling 10.4.3
- destinations, groups 10.4.2
- destinations, specifying 10.4
- destination status 10.4.3
- failed destinations and 10.6
- mandatory destinations 10.6.1.1
- multiplexing 10.4.1
- normal transmission of 10.5
- re-archiving to failed destination 10.6.2
- sample destination scenarios 10.6.1.2
- standby transmission of 10.5
- status information 10.8.1
- transmitting 10.5
ARCHIVELOG mode 10.2.2
- advantages 10.2.2
- archiving 10.2
- automatic archiving in 10.2.2
- definition of 10.2.2
- distributed databases 10.2.2
- enabling 10.3.2
- manual archiving in 10.2.2
- running in 10.2.2
- switching to 10.3.2
- taking data files offline and online in 12.4.2
archiver process (ARCn) 3.6
- trace output (controlling) 10.7
archiving
- alternate destinations 10.4.4
- changing archiving mode 10.3.2
- controlling number of processes 10.3.4
- destination availability state, controlling 10.4.3
- destination failure 10.6
- destination status 10.4.3
- manual 10.3.3
- NOARCHIVELOG vs. ARCHIVELOG mode 10.2
- setting initial mode 10.3.1
- to failed destinations 10.6.2
- trace output, controlling 10.7
- viewing information on 10.8.1
attribute-clustered tables 19.2.9
auditing
- database links 31.3.3
authentication
- database administrators 1.7.3
- database links 31.3.2.1
- operating system 1.7.4.2
- password files 1.7.5
- selecting a method 1.7.3.1
- using password file 1.7.5.1
AUTO_TASK_CONSUMER_GROUP
- of Resource Manager 25.5
AUTOEXTEND clause 12.3.1
auto indexes 20.7.1
automatic big table cache 4.2
automatic diagnostic repository 7.1.1, 7.1.3.1
- in Oracle Client 7.1.4
- in Oracle Clusterware 7.1.4
- in Oracle Real Application Clusters 7.1.4
- structure, contents and location of 7.1.4
automatic error mitigation 7.5.1
automatic file extension 12.3.1
automatic indexes 20.7
- views 20.7.5
automatic indexing
- about 20.7.1
- configuring 20.7.3
- generating reports 20.7.4
- how automatic indexing works 20.7.2
automatic maintenance tasks
- assigning to maintenance windows 25.3.2
- definition 25.1
- enabling and disabling 25.3.1
- predefined 25.1
- resource allocation 25.5.1
- Scheduler job names 25.2
automatic segment space management 11.2.2.3
automatic undo management 14.2
- migrating to 14.6

B

BACKGROUND_DUMP_DEST initialization parameter 7.1.3.1
background processes 3.6
- FMON 12.9.2.1.1
backups
- effects of archiving on 10.2.1
bigfile tablespaces
- altering 11.8.3
- creating 11.2.3.2
- creating temporary 11.2.6.3
- description 11.2.3.1
big table cache 4.2
BLOB data type 19.3.1
blockchain tables
- about 19.18.1
- adding user columns 19.18.4
- altering 19.18.7
- benefits 19.18.1.1
- countersigning rows 19.18.13
- creating 19.18.3
- creating certificates 19.18.8
- creating row versions 19.18.5
- creating user chains 19.18.6
- data dictionary views 19.18.23
- delegate signing rows 19.18.12
- deleting rows 19.18.16
- dropping 19.18.17
- dropping user columns 19.18.4
- getting bytes for hash 19.18.19
- getting bytes for signature 19.18.20
- getting byte values 19.18.21
- hidden columns 19.18.1.3
- restrictions 19.18.2.4
- retention period 19.18.2.1
- retention period for rows 19.18.2.2
- signing rows 19.18.11
- using for log history 19.18.22
- validating data 19.18.14
block size, redo log files 9.2.4
BLOCKSIZE clause
- of CREATE TABLESPACE 11.4

C

caches
- sequence numbers 23.2.4.2.1
calendaring expressions 28.4.5.2
calls
- remote procedure 31.5.2
cancelling SQL statements 3.10.5
capacity planning
- space management
  - capacity planning 18.7
CASCADE clause
- when dropping unique or primary keys 17.7.3.1
CATBLOCK.SQL script 6.2.1
CDB resource plans 26.1.3.4.1
- PDB performance profiles 26.4.1.3, 26.4.1.6.3
CDBs
- CDB resource plans
  - viewing information about 26.4.1.8
- Database Resource Manager 26.4
- resource management 26.1.1
centralized user management
- distributed systems 31.3.2.4.1
certificates
- creating 19.18.8
chain condition syntax 28.6.5
chained rows
- eliminating from table, procedure 17.4.5.2
chain rules 28.6.5
chains
- creating 28.6.3
- creating and managing job 28.6
- creating jobs for 28.6.8
- disabling 28.6.12
- dropping 28.6.9
- dropping rules from 28.6.11
- enabling 28.6.7
- handling stalled 28.6.20
- monitoring running 28.6.19
- overview 27.2.8
- pausing 28.6.16
- running 28.6.10
- setting privileges 29.1.1
- steps
  - pausing 28.6.16
  - skipping 28.6.17
- stopping 28.6.14
- stopping individual steps 28.6.15
chain steps
- defining 28.6.4
change vectors 9.1.2
CHAR data type
- increasing column length 19.7.5
CHECK_OBJECT procedure
- DBMS_REPAIR package 24.2.1
- example 24.4.2
- finding extent of corruption 24.3.2
checkpoint process (CKPT) 3.6
checksums
- for data blocks 12.7
- redo log blocks 9.7
clearing redo log files 9.8
CLEAR LOGFILE clause
- ALTER DATABASE statement 9.8
client/server architectures
- distributed databases 31.1.3
- globalization support 31.6.2
cloning
- a database 1.3.11
- an Oracle home 1.3.11
CLOSE DATABASE LINK clause
- ALTER SESSION statement 33.2
closing database links 32.4.1
closing windows 28.9.3.6
clusters
- about 21.1
- allocating extents 21.4.1
- altering 21.4.1
- analyzing 17.4.1
- clustered tables 21.1, 21.2.1, 21.3.2, 21.4.2, 21.5.2
- cluster indexes 21.5
- cluster keys 21.1, 21.2.2
- columns for cluster key 21.2.2
- creating 21.3.1
- data dictionary views reference 21.6
- deallocating extents 21.4.1
- dropping 21.5
- estimating space 21.2.3, 21.2.5
- guidelines for managing 21.2
- location 21.2.4
- privileges 21.3.1, 21.4.1, 21.5.2
- selecting tables 21.2.1
- single-table hash clusters 22.3.3
- truncating 17.5
- validating structure 17.4.3
coalescing indexes
- costs 20.2.13
cold backup
- performing with a detached Oracle Scheduler job 28.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 objects
- materialized views
  - column subsetting 36.10.3
- replication 36.10.1
columns
- adding 19.7.6
- adding to compressed table 19.7.6
- displaying information about 19.19
- dropping 19.7.8, 19.7.8.3
- dropping in compressed tables 19.7.8.4
- encrypted 19.2.13
- increasing length 19.7.5
- invisible 19.2.12.1
- modifying definition 19.7.5
- renaming 19.7.7
- virtual 19.1
- virtual, indexing 20.2.2
column subsetting
- materialized views
  - column objects 36.10.3
commands
- submitting 1.4.1
comments
- adding to problem activity log 7.2.7
COMMENT statement 19.19
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
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 2.5
compression 38.1.4
- indexes 20.3.8
  - advanced compression 20.3.8.2
  - prefix compression 20.3.8.1
- levels 19.2.6.1
- tables 19.2.6.1
  - adding a column 19.7.6
  - dropping columns in 19.7.8.4
- tablespaces 11.2.4
configuring
- Oracle Scheduler 29.1
CONNECT command, SQL*Plus 1.4.3.5, 1.4.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.4.3.1
connection qualifiers
- database links and 32.2.4
- diagnosing problems with 40.1
connections
- terminating remote 33.2
constraints 17.7
- See also: integrity constraints
- deferrable 37.4.4
- disabling at table creation 17.7.2.1
- distributed system application development issues 33.3
- dropping integrity constraints 17.7.3.3
- enable novalidate state 17.7.1.4
- enabling example 17.7.2.2
- enabling when violations exist 17.7.1.4
- exceptions 17.7.1.3, 17.7.5
- exceptions to integrity constraints 17.7.5
- integrity constraint states 17.7.1.1
- keeping index when disabling 17.7.3
- keeping index when dropping 17.7.3
- ORA-02055 constraint violation 33.3
- renaming 17.7.3.2
- setting at table creation 17.7.2
- when to disable 17.7.1.2
CONTROL_FILES initialization parameter
- specifying file names 8.2.1
- when creating a database 8.3.1
control files
- adding 8.3.2
- changing size 8.3.1
- conflicts with data dictionary 8.4.1
- creating 8.1, 8.3, 8.3.3.2
- creating as Oracle Managed Files 15.3.6.1
- data dictionary views reference 8.8
- default name 8.3.1
- dropping 8.7
- errors during creation 8.4.2
- importance of multiplexed 8.2.2
- initial creation 8.3.1
- location of 8.2.2
- log sequence numbers 9.1.3.2
- mirroring 8.2.2
- moving 8.3.2
- multiplexed 8.2.2
- names 8.2.1
- number of 8.2.2
- relocating 8.3.2
- renaming 8.3.2
- requirement of one 8.1
- size of 8.2.4
- troubleshooting 8.4
copying jobs 28.2.13
core files 7.1.3.4
corruption
- repairing data block 24.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
CPU_COUNT initialization parameter 26.1.4.3.1
cpu resource management
- CPU scope 26.11
CREATE_CREDENTIAL procedure 3.9.2, 28.2.2.3
CREATE_SIMPLE_PLAN procedure
- Database Resource Manager 26.4.2.1, 26.4.3
CREATE BIGFILE TABLESPACE statement 11.2.3.2
CREATE BIGFILE TEMPORARY TABLESPACE statement 11.2.6.3
CREATE CLUSTER statement
- creating clusters 21.3.1
- example 21.3.1
- for hash clusters 22.3.1
- HASH IS clause 22.3.1, 22.3.4.2
- HASHKEYS clause 22.3.1, 22.3.4.4
CREATE CONTROLFILE statement
- about 8.3.3.2
- checking for inconsistencies 8.4.1
- NORESETLOGS clause 8.3.3.3
- Oracle Managed Files, using 15.3.6.1
- RESETLOGS clause 8.3.3.3
CREATE DATABASE LINK statement 32.2.2.1
CREATE DATABASE statement
- CONTROLFILE REUSE clause 8.3.1
- MAXLOGFILES parameter 9.2.5
- MAXLOGMEMBERS parameter 9.2.5
- used to create an undo tablespace 14.5.1.2
- using Oracle Managed Files 15.3.3
- using Oracle Managed Files, examples 15.5.1, 15.5.2
CREATE INDEX statement
- NOLOGGING 20.2.10
- ON CLUSTER clause 21.3.3
- with a constraint 20.3.4.2
CREATE SCHEMA statement
- multiple tables and views 17.3
CREATE SEQUENCE statement 23.2.2
- CACHE option 23.2.4.2.4
CREATE SYNONYM statement 23.3.2
CREATE TABLESPACE statement
- BLOCKSIZE CLAUSE, using 11.4
- FORCE LOGGING clause, using 11.5
- LOST WRITE PROTECTION clause 11.11.2
- using Oracle Managed Files 15.3.4.1
- using Oracle Managed Files, examples 15.3.4.2
CREATE TABLE statement
- CLUSTER clause 21.3.2
- creating a private temporary table 19.3.2.4
- creating global temporary table 19.3.2.3
- example of 19.3.1
- INCLUDING clause 19.13.2.6
- MONITORING clause 19.6
- NOLOGGING clause 19.2.5
- ORGANIZATION EXTERNAL clause 19.15.2
- PCTTHRESHOLD clause 19.13.2.5
CREATE TEMPORARY TABLESPACE statement 11.2.6.2
- using Oracle Managed Files 15.3.5.1
- using Oracle managed files, example 15.3.5.2
CREATE UNDO TABLESPACE statement
- using Oracle Managed Files 15.3.4.1
- using Oracle Managed Files, example 15.3.4.3
- using to create an undo tablespace 14.5.1.3
CREATE VIEW statement
- about 23.1.2.1
- OR REPLACE clause 23.1.3
- WITH CHECK OPTION 23.1.2.1, 23.1.4
creating
- chains 28.6.3
- control files 8.3
- event-based job 28.5.2.2
- event schedule 28.5.2.4
- indexes 20.3
  - after inserting table data 20.2.1
  - associated with integrity constraints 20.3.4.1
  - NOLOGGING 20.2.10
  - online 20.3.6
  - prerequisites 20.3.1
  - USING INDEX clause 20.3.4.2
- job classes 28.9.1.2
- jobs 28.2.2
- programs 28.3.2.1
- Scheduler windows 28.9.3.3
- schedules 28.4.2
- sequences 23.2.4.2.4
- window groups 28.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
- using Oracle Managed Files 15.3.3
creating data files 12.2
creating sequences 23.2.2
creating synonyms 23.3.2
creating views 23.1.2.1
credentials, Oracle Scheduler
- about 27.2.7
- granting privileges on 27.2.7
critical errors
- diagnosing 7.1.1
CRSCTL utility
- Oracle Restart 2.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 23.2.4.1
- restrictions 23.2.4.1.3
cursors
- and closing database links 33.2
customize package page, accessing 7.4.3.2
customizing an incident package 7.4.3, 7.4.3.2

D

data
- loading using external tables 19.15.2
database
- cloning 1.3.11
database administrators
- authentication 1.7.3
- DBA role 1.6.2.5
- operating system account 1.6.1
- password files for 1.7.3.2
- responsibilities of 1.2.1
- security and privileges of 1.6
- security officer versus 5.1
- task definitions 1.3
- utilities for 1.9
Database Configuration Assistant
- shared server configuration 3.4.4
database destinations, Oracle Scheduler
- about 27.2.5.1
- creating 28.2.2.4.2
Database In-Memory
- See: Oracle Database In-Memory
database jobs, Oracle Scheduler 27.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 18.7.3
database program unit, definition 27.1
database resident connection pooling 3.2
- advantages 3.2
- configuration parameters 3.5.3.1
- configuring the connection pool 3.5.3
- data dictionary views reference 3.5.5
- determining the state of 3.5.6
- disabling 3.5.2
- enabling 3.5.2
- multi-pool, using 3.5.4
- triggers 3.2
Database Resource Manager
- active session pool with queuing 26.1.3.3.1.6
- administering system privilege 26.1.4.1
- and operating system control 26.9
- automatic consumer group switching 26.1.3.3.1.5.1
- CDB resource plans 26.1.3.4.1
- CDBs 26.1.1, 26.4
- CREATE_SIMPLE_PLAN procedure 26.4.2.1, 26.4.3
- data dictionary views reference 26.10.3
- description 26.1
- enabling 26.2
- execution time limit 26.1.3.3.1.5.3
- monitoring PDBs 26.8.6
- PDB resource plans 26.1.3.4.2
- PDBs 26.4
- resource allocation methods 26.4.4.5
- resource consumer groups 26.1.3.1, 26.3, 26.4.4.3
- resource plan directives 26.1.3.1, 26.4.4.6, 26.4.4.7
- resource plans 26.1.3.1, 26.1.3.3.1.1.1, 26.1.3.5.1, 26.2, 26.4.3, 26.5, 26.5.5
- STATISTICS_LEVEL parameter 26.1.2.1
- undo pool 26.1.3.3.1.7
- validating plan schema changes 26.4.4.7
databases
- administering 1
- administration of distributed 32
- planning 1.3.3
- renaming 8.3.3.2, 8.3.3.3
Database Smart Flash Cache 4.7
- flushing 4.7.3
- tuning 4.7.3
database writer process
- calculating checksums for data blocks 12.7
database writer process (DBWn) 3.6
data block corruption
- repairing 24.1
data blocks
- shadow lost write protection 11.11
- shared in clusters 21.1
- verifying 12.7
data dictionary
- conflicts with control files 8.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 11.9
data files
- adding to a tablespace 12.2
- bringing online and offline 12.4.1
- checking associated tablespaces 11.15.3
- copying using database 12.8.1
- creating 12.2
- creating Oracle Managed Files 15.3, 15.3.7.2
- database administrators access 1.6.1
- data dictionary views reference 12.10
- default directory 12.2
- definition 12.1.1
- deleting 11.10
- dropping 12.4.3, 12.6
- dropping Oracle managed 15.4.1
- file numbers 12.1.1
- fully specifying file names 12.2
- guidelines for managing 12.1.1
- headers when renaming tablespaces 11.9
- identifying OS file names 12.5.2.1.2
- location 12.1.4
- mapping files to physical devices 12.9
- minimum number of 12.1.2.1
- MISSING 8.4.1
- offline
  - relocating 12.5.2
  - renaming 12.5.2
- online 12.4.3
  - relocating 12.5.1
  - renaming 12.5.1
- relocating 12.5
- renaming 12.5
- reusing 12.2
- shadow lost write protection 11.11
- size of 12.1.3
- statements to create 12.2
- storing separately from redo log files 12.1.5
- verifying data blocks 12.7
data manipulation language
- statements allowed in distributed transactions 31.4.1
Data Recovery Advisor, repairing data corruptions with 7.5.3
Data Repair Advisor 7.1.1
date expressions 37.4.3.1
DB_BLOCK_CHECKING initialization parameter 24.3.1.1, 24.3.1.5
DB_BLOCK_CHECKSUM initialization parameter 12.7
- enabling redo block checking with 9.7
DB_BLOCK_SIZE initialization parameter
- and nonstandard block sizes 11.4
DB_CACHE_SIZE initialization parameter
- specifying multiple block sizes 11.4
DB_CACHE_SIZE parameter 26.1.4.3.2
DB_CREATE_FILE_DEST initialization parameter
- setting 15.2.2
DB_CREATE_ONLINE_LOG_DEST_n initialization parameter
- setting 15.2.4
DB_FILES initialization parameter
- determining value for 12.1.2.2
DB_nK_CACHE_SIZE initialization parameter
- specifying multiple block sizes 11.4
DB_PERFORMANCE_PROFILE parameter 26.4.1.4
DB_RECOVERY_FILE_DEST initialization parameter
- setting 15.2.3
DB_UNRECOVERABLE_SCN_TRACKING initialization parameter 19.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.6.2.5
DBMS_CREDENTIAL package 3.9.2
DBMS_FILE_TRANSFER package
- copying data files 12.7
DBMS_JOB
- about A.1
- moving jobs to Oracle Scheduler A.2
DBMS_METADATA package
- GET_DDL function 17.13.1
- using for object definition 17.13.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 3.7.2
DBMS_REDEFINITION package
- performing online redefinition with 19.8.6.1
DBMS_REFRESH package
- MAKE procedure 39.2
- REFRESH procedure 39.3
DBMS_REPAIR
- logical corruptions 24.3.2
DBMS_REPAIR package
- examples 24.4
- procedures 24.2.1
- using 24.3, 24.4.5
DBMS_RESOURCE_MANAGER_PRIVS package 26.1.4.1
- procedures (table of) 26.1.4.1
DBMS_RESOURCE_MANAGER package 26.1.3.1, 26.1.4.1, 26.3.4.1.1
- procedures (table of) 26.1.4.1
DBMS_RESUMABLE package 18.2.4.3
DBMS_SCHEDULER
- in-memory trace 29.2.4
DBMS_SCHEDULER.GET_FILE, retrieving external job stdout with 28.2.2.10
DBMS_SERVER_ALERT package
- setting alert thresholds 18.1.1
DBMS_SPACE_ADMIN
- DROP_EMPTY_SEGMENTS procedure 18.4
- MATERIALIZE_DEFERRED_SEGMENTS procedure 19.2.15
DBMS_SPACE package 18.3.4
- example for unused space 18.6.1
- FREE_BLOCK procedure 18.6.1
- SPACE_USAGE procedure 18.6.1
- UNUSED_SPACE procedure 18.6.1
DBMS_SQLDIAG package 7.3.4.3.2
DBMS_TNS package 32.5.3
DBMS_TRANSACTION package
- PURGE_LOST_DB_ENTRY procedure 35.6.2
DBVERIFY utility 24.3.1.1, 24.3.1.3
DDL log 7.1.3.5
DEALLOCATE UNUSED clause 18.3.4
deallocating unused space 18.3
- DBMS_SPACE package 18.3.4
- DEALLOCATE UNUSED clause 18.3.4
debug log 7.1.3.6
declarative referential integrity constraints 33.3
dedicated server processes 3.1.1
- trace files for 6.1.1.1
DEFAULT_CONSUMER_GROUP for Database Resource Manager 26.3.6.1, 26.7.2
default temporary tablespace
- renaming 11.9
deferred segment creation
- indexes 20.2.6
- in tables 19.2.14
deferred segments
- materializing 19.2.15
defining
- chain steps 28.6.4
deleting
- certificates 19.18.10
dependencies
- between schema objects 17.9
- displaying 17.13.2.2
destinations, Oracle Scheduler
- about 27.2.5.1
- creating 28.2.2.4.2
detached jobs 27.3.1.5
- creating 28.2.2.8
DIAGNOSTIC_DEST initialization parameter 6.1.1.1, 7.1.3.1, 7.1.4
dictionary-managed tablespaces
- migrating SYSTEM to locally managed 11.14
Digital POLYCENTER Manager on NetView 31.3.4.3
directory objects
- external procedures 3.9.2
direct-path INSERT
- benefits 19.4.2.1
- how it works 19.4.2.2
- index maintenance 19.4.2.5.2
- locking considerations 19.4.2.5.4
- logging mode 19.4.2.4
- parallel INSERT 19.4.2.3.2
- parallel load compared with parallel INSERT 19.4.2.1
- space considerations 19.4.2.5.3
direct path load
- fast refresh 37.4.2.2
disabling
- chains 28.6.12
- jobs 28.2.11
- programs 28.3.5
- window groups 28.9.4.7
- windows 28.9.3.8
disabling recoverer process 35.9.2
dispatcher process (Dnnn) 3.6
dispatcher processes 3.4.4.3, 3.4.6
DISPATCHERS initialization parameter
- setting initially 3.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
- direct and indirect connections 31.1.3
- distributed processing 31.1.1.2
- distributed queries 31.4.2
- distributed updates 31.4.2
- enhancing security 35.11
- exclusively mapped global users 31.3.2.4.2
- forming global database names 32.1.1
- 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 18.2.1.4
- running in ARCHIVELOG mode 10.2.2
- running in NOARCHIVELOG mode 10.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
- 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
- enhancing security 35.11
- 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 19.4.4.1
DRCP
- initialization parameters 3.5.1
DRIVING_SITE hint 33.4.3.3
DROP ALL STORAGE clause 17.5.3
DROP CLUSTER statement
- CASCADE CONSTRAINTS clause 21.5
- dropping cluster 21.5
- dropping cluster index 21.5
- dropping hash cluster 22.5
- INCLUDING TABLES clause 21.5
DROP LOGFILE clause
- ALTER DATABASE statement 9.5.1
DROP LOGFILE MEMBER clause
- ALTER DATABASE statement 9.5.2
dropping
- chains 28.6.9
- chain steps 28.6.13
- columns
  - marking unused 19.7.8.2
  - remove unused columns 19.7.8.2
- columns in compressed tables 19.7.8.4
- database links 32.4.2
- data files 12.6
- data files, Oracle managed 15.4.1
- job classes 28.9.1.4
- jobs 28.2.8
- programs 28.3.4
- rules from chains 28.6.11
- schedules 28.4.4
- tables
  - consequences of 19.11
- temp files 12.6
  - Oracle managed 15.4.1
- window groups 28.9.4.3
- windows 28.9.3.7
dropping multiple jobs 28.2.10
DROP SYNONYM statement 23.3.4
DROP TABLESPACE statement 11.10
DROP TABLE statement
- about 19.11
- CASCADE CONSTRAINTS clause 19.11
- for clustered tables 21.5.2
DUMP_ORPHAN_KEYS procedure
- DBMS_REPAIR package 24.2.1
- example 24.4.4
- recovering data 24.3.4.1
dumps 7.1.3.4
dynamic statistics 7.3.4.2.2

E

ECID 7.1.2.3
editions
- in CONNECT command 1.4.3.5
- managing 17.12
e-mail notifications, Scheduler 28.10.5
EMPHASIS resource allocation method 26.4.4.5
empty tables
- dropping segments 18.4
enabling
- chains 28.6.7
- jobs 28.2.12
- programs 28.3.6
- window groups 28.9.4.6
- windows 28.9.3.9
enabling recoverer process
- distributed transactions 35.9.2
encryption
- column 19.2.13
- tablespace 11.2.5.1
enterprise users
- definition 31.3.2.4.3
error logging, DML
- inserting data with 19.4.4.1
errors
- alert log and 6.1.1.1
- assigning names with PRAGMA_EXCEPTION_INIT 33.5
- critical 7.1.1
- exception handler 33.5
- integrity constrain violation 33.3
- ORA-00028 3.10.3
- ORA-01173 8.4.2
- ORA-01176 8.4.2
- ORA-01177 8.4.2
- ORA-01215 8.4.2
- ORA-01216 8.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 6.1.1.1
- when creating control file 8.4.2
event-based job
- altering 28.5.2.3
- creating 28.5.2.2
- passing event messages to 28.5.2.6
event message
- passing to event-based job 28.5.2.6
events
- using to start Scheduler jobs 28.5
events (Scheduler)
- overview 28.5.1
event schedule
- altering 28.5.2.5
- creating 28.5.2.4
example
- setting maximum utilization limit for plans and subplans 26.5.2
examples
- managing parallel statement execution using Resource Manager 26.5.4
exception handler 33.5
exceptions
- assigning names with PRAGMA_EXCEPTION_INIT 33.5
- integrity constraints 17.7.5
- user-defined 33.5
executing
- remote external jobs 29.1.3
execution context identifier 7.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
expressions, calendaring 28.4.5.2
extents
- allocating cluster extents 21.4.1
- allocating for tables 19.7.4
- data dictionary views for 18.6.2
- deallocating cluster extents 21.4.1
- displaying free extents 18.6.2.3
external destinations, Oracle Scheduler
- about 27.2.5.1
- creating 28.2.2.4.2
external jobs
- retrieving stdout and stderr 27.3.1.2.2, 27.3.1.2.3, 28.2.2.10
external jobs, Oracle Scheduler 27.3.1.2.1
external procedures
- credentials 3.9.2
- directory objects 3.9.2
- managing processes for 3.9.1
external tables
- altering 19.15.3
- creating 19.15.2
- defined 19.15.1
- dropping 19.15.8
- Hadoop 19.15.1
- inline 19.15.1, 19.15.6
- partitioned 19.15.7
  - altering 19.15.7.4
  - creating 19.15.7.3
  - restrictions 19.15.7.2
- partition values in file paths 19.15.10
- privileges required 19.15.9
- querying 19.15.5
- uploading data example 19.15.2

F

fast recovery area
- as archive log destination 10.4.1.1
- with Oracle managed files 15.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 7.1.1, 7.1.3
file mapping
- examples 12.9.4
- how it works 12.9.2
- how to use 12.9.3
- overview 12.9.1
- structures 12.9.2.2
- views 12.9.3.3
file names
- Oracle Managed Files 15.3.2
files
- creating Oracle Managed Files 15.3, 15.3.7.2
file system
- used for Oracle managed files 15.1.4
file watchers
- about 28.5.3.1
- changing detection interval 28.5.3.5
- creating 28.5.3.3
- managing 28.5.3.5
filter columns 37.1.4.2
finalizing
- an incident package, definition 7.4.1.2
FINISH_REDEF_TABLE procedure
- dml_lock_timeout parameter 19.8.6.1
FIX_CORRUPT_BLOCKS procedure
- DBMS_REPAIR 24.2.1
- example 24.4.3
- marking blocks corrupt 24.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 19.12
- purging recycle bin 19.12.4
- querying recycle bin 19.12.3
- recycle bin 19.12.1
- restoring objects 19.12.5
Flashback Table
- overview 19.10
flood-controlled incidents
- defined 7.1.2.2
- viewing 7.3.1.1
FMON background process 12.9.2.1.1
FORCE clause
- COMMIT statement 35.5
- ROLLBACK statement 35.5
force full database caching mode 4.6
- disabling 4.6.4
- enabling 4.6.3
- prerequisites 4.6.2
FORCE LOGGING
- precedence of settings 9.9
FORCE LOGGING clause
- CREATE TABLESPACE 11.5
force refresh 36.7, 37.4.2.3
forcing
- COMMIT or ROLLBACK 35.3.1, 35.4.2
forcing a log switch 9.6
- using ARCHIVE_LAG_TARGET 9.2.6
- with the ALTER SYSTEM statement 9.6
foreign keys
- replicated tables 38.1.2
forget phase
- in two-phase commit 34.3.4
free space
- listing free extents 18.6.2.3
- tablespaces and 11.15.4
full transportable export/import 13.2
function-based indexes 20.3.7

G

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
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 19.3.2.3.2
- creating 19.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.8.6
GRANT statement
- SYSOPER/SYSDBA privileges 1.8.6
groups, Oracle Scheduler 27.2.11.1
growth trends
- of database objects 18.7.3
GV$DBLINK view 32.5.2

H

Hadoop
- external tables 19.15.1
hash clusters
- advantages and disadvantages 22.1
- altering 22.4
- choosing key 22.3.4.1
- contrasted with index clusters 22.1
- controlling space use of 22.3.4
- creating 22.3.1
- data dictionary views reference 22.6
- dropping 22.5
- estimating storage 22.3.5
- examples 22.3.4.5.1
- hash function 22.1, 22.2.2, 22.3.1, 22.3.4.1, 22.3.4.2, 22.3.4.3
- HASH IS clause 22.3.1, 22.3.4.2
- HASHKEYS clause 22.3.1, 22.3.4.4
- single-table 22.3.3
- sorted 22.3.2
hash functions
- for hash cluster 22.1
health checks 7.1.1
Health Monitor 7.3.2
- checks 7.3.2.1.1
  - generating reports 7.3.2.3
  - viewing reports 7.3.2.3
  - viewing reports using ADRCI 7.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 19.2.6.1

I

IBM NetView/6000 31.3.4.3
IM column store
- See: In-Memory Column Store
immutable table
- retention period 19.17.2.1
immutable tables
- about 19.17.1
- adding user columns 19.17.5
- altering 19.17.4
- creating 19.17.3
- creating row versions 19.17.6
- deleting rows 19.17.7
- dropping 19.17.8
- dropping user columns 19.17.5
- restrictions 19.17.2.3
- row retention period 19.17.2.2
Import
- materialized view logs 37.1.4.3
import operations
- PDBs 13.2.3, 13.2.4
Incident Manager, accessing 7.3.4.3.1.1
incident package
- correlated 7.4.1.4
- correlated, creating, editing, and uploading 7.4.4
- correlated, deleting 7.4.5
- customizing 7.4.3, 7.4.3.2
- defined 7.1.1
- viewing 7.4.3.1
incident packages 7.4.1
incident packaging service 7.1.1
incidents
- about 7.1.2.1
- flood-controlled 7.1.2.2
  - viewing 7.3.1.1
incidents, SQL 7.3.4.2.1
incompatibilities
- adding job or program 28.7.2
- dropping 28.7.4
- job or program 28.7.1
- removing job or program 28.7.3
- using 28.7
index clusters
- See: clusters
indexes
- advanced index compression 20.3.8.2
- altering 20.4.1
- analyzing 17.4.1
- automatic indexes 20.7
- choosing columns to index 20.2.2
- cluster indexes 21.3.3, 21.4.2, 21.5
- coalescing 20.2.13, 20.4.3
- column order for performance 20.2.3
- creating 20.3
  - prerequisites 20.3.1
- data dictionary views reference 20.8
- deferred segment creation 20.2.6
- determining unusable status of 20.4.4
- disabling and dropping constraints cost 20.2.14
- dropping 20.2.5, 20.6
- estimating size 20.2.7
- estimating space use 18.7.2
- function-based 20.3.7
- guidelines for managing 20.1
- invisible 20.2.11, 20.3.10, 20.4.5
- keeping when disabling constraint 17.7.3
- keeping when dropping constraint 17.7.3
- limiting for a table 20.2.4
- materialized view sites 37.2.1
- monitoring space use of 20.5
- monitoring usage 20.4.7
- multiple on a set of columns 20.2.12
- on foreign keys 38.1.2
- parallelizing index creation 20.2.9
- rebuilding 20.2.13, 20.4.3
- rebuilt after direct-path INSERT 19.4.2.5.2
- renaming 20.4.6
- setting storage parameters for 20.2.7
- shrinking 18.3.3
- space used by 20.5
- tablespace for 20.2.8
- temporary segments and 20.2.1
- unusable 20.2.11, 20.3.9, 20.4.4
- validating structure 17.4.3
- when to create 20.2.2
index-organized tables
- analyzing 19.13.5
- AS subquery 19.13.2.7
- converting to heap 19.13.7
- creating 19.13.2.1
- described 19.13.1
- INCLUDING clause 19.13.2.6
- maintaining 19.13.3
- ORDER BY clause, using 19.13.6
- parallel creation 19.13.2.7
- prefix compression 19.13.2.8
- rebuilding with MOVE clause 19.13.3.2
- storing nested tables 19.13.2.4
- storing object types 19.13.2.4
- threshold value 19.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 parameters
- COMMIT_POINT_STRENGTH 34.2.6.3
- CONTROL_FILES 8.2.1, 8.3.1
- DB_BLOCK_CHECKING 24.3.1.5
- DB_BLOCK_CHECKSUM 9.7, 12.7
- DB_BLOCK_SIZE 11.4
- DB_CACHE_SIZE 11.4
- DB_FILES 12.1.2.2
- DB_nK_CACHE_SIZE 11.4
- DISPATCHERS 3.4.4.3
- editing 38.2.4.4
- GLOBAL_NAMES 31.2.6
- LOG_ARCHIVE_DEST 10.4.1
- LOG_ARCHIVE_DEST_n 10.4.1, 10.6.2
- LOG_ARCHIVE_DEST_STATE_n 10.4.3
- LOG_ARCHIVE_MAX_PROCESSES 10.3.4
- LOG_ARCHIVE_MIN_SUCCEED_DEST 10.6.1
- LOG_ARCHIVE_TRACE 10.7
- OPEN_LINKS 32.4.3
- REMOTE_LOGIN_PASSWORDFILE 1.8.3
- REMOTE_OS_AUTHENT 31.2.8.2
- RESOURCE_MANAGER_PLAN 26.2
- SHARED_SERVERS 3.4.3.2
- shared server and 3.4.1
- SORT_AREA_SIZE 20.2.1
- SQL_TRACE 6.1.1.1
INITIAL parameter
- cannot alter 19.7.2
INITRANS parameter
- altering 19.7.2
inline external tables 19.15.1, 19.15.6
In-Memory Column Store 4.9
in-memory full jobs
- example of creating 28.2.2.2.2
in-memory jobs 27.3.1.7
in-memory runtime, jobs
- example of creating 28.2.2.2.2
INSERT statement
- with DML error logging 19.4.4.1
installing
- Release Update Revisions (Revisions) 1.3.10
- Release Updates (Updates) 1.3.10
instance caging 26.6.1
- with maximum utilization limit 26.6.1
instances
- managing CPU for multiple 26.6.1
integrity constraints 17.7
- See also: constraints
- cost of disabling 20.2.14
- cost of dropping 20.2.14
- creating indexes associated with 20.3.4.1
- dropping tablespaces and 11.10
- ORA-02055 constraint violation 33.3
invisible columns 19.2.12.1
invisible indexes 20.2.11, 20.4.5
- creating 20.3.10
IOT
- See: index-organized tables
IPS 7.1.1

J

JOB_QUEUE_PROCESSES initialization parameter 27.4.3.3, 38.2.4.4, A.1.2
job child processes
- replication 38.2.4.4
job classes
- altering 28.9.1.3
- creating 28.9.1.2
- dropping 28.9.1.4
- managing Scheduler job attributes, resources, and priorities with 28.9.1
- overview 27.2.9
- viewing 27.2.9
job coordinator 27.4.3.1
job credentials 28.2.2.3
job destination ID, defined 28.2.5, 28.10.3
job log, Scheduler
- viewing 28.10.2.1
job recovery (Scheduler) 29.4.1.4
job resources
- managing 28.8
jobs 28.2.2.2.2
- adding to an incompatibility 28.7.2
- altering 28.2.3
- copying 28.2.13
- creating 28.2.2
- creating and managing Scheduler 28.2
- creating for chains 28.6.8
- credentials 27.2.7
- database 27.3.1.1.1
- detached 27.3.1.5
- disabling 28.2.11
- dropping 28.2.8
- dropping an incompatibility 28.7.4
- e-mail notifications 28.10.5
- enabling 28.2.12
- event-based 28.5.2.2
- external 27.3.1.2.1
- incompatibilities 28.7.1
- in-memory 27.3.1.7
- in-memory full, example of creating 28.2.2.2.2
- in-memory runtime, example of creating 28.2.2.2.2
- lightweight 27.3.1.6
- lightweight, example of creating 28.2.2.2.2
- monitoring 28.10.1
- monitoring with events raised by the Scheduler 28.10.4
- multiple-destination 27.3.2
  - status of child jobs 29.2.2
- overview 27.2.4.1
- priorities 28.9.2
- remote database 27.3.1.1.1
- remote external
  - about 27.3.1.2.3
- removing from an incompatibility 28.7.3
- resources 28.8.1, 28.8.2, 28.8.3
- running 28.2.4
- script jobs 27.3.1.8
- starting when a file arrives on a system 28.5.3
- starting with events raised by your application 28.5.2.1
- status 28.10.1, 29.6.2
- stopping 28.2.5
- trace messages 29.2.4
- troubleshooting remote 29.4.1.3
- viewing information on running 29.2.2
job scheduling
- dependency 27.1
- event-based 27.1
- time-based 27.1
joins
- statement transparency in distributed databases 32.7
join views
- definition 23.1.2.2
- DELETE statements 23.1.5.3.2
- key-preserved tables in 23.1.5.2
- modifying 23.1.5.1
- rules for modifying 23.1.5.3
- updating 23.1.5.1

K

key-preserved tables
- in join views 23.1.5.2
- in outer joins 23.1.5.4
keys
- cluster 21.1
keystore 11.2.5.1, 19.2.13

L

large objects 19.3.1
lightweight jobs 27.3.1.6
- example of creating 28.2.2.2.2
links
- See: database links
LIST CHAINED ROWS clause
- of ANALYZE statement 17.4.5.1
listeners
- removing with srvctl 2.5.8.4
listing database links 32.5.1, 35.3.1, 35.3.2
loading data
- using external tables 19.15.2
LOBs 19.3.1
local coordinators
- distributed transactions 34.2.4
locally managed tablespaces 11.2.2.1
- automatic segment space management in 11.2.2.3
- DBMS_SPACE_ADMIN package 11.13.1
- detecting and repairing defects 11.13.1
- migrating SYSTEM from dictionary-managed 11.14
- shrinking, temporary 11.8.6
- temp files 11.2.6.2
- temporary, creating 11.2.6.2
local temporary tablespaces 11.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 6.2.1
lock timeout interval
- distributed transactions 35.8
log
- window (Scheduler) 28.9.3.1
LOG_ARCHIVE_DEST_n initialization parameter 10.4.1
- GROUP attribute 10.4.2.1, 10.4.2.2
- PRIORITY attribute 10.4.2.1, 10.4.2.2
- REOPEN attribute 10.6.2
LOG_ARCHIVE_DEST_STATE_n initialization parameter 10.4.3
LOG_ARCHIVE_DEST initialization parameter
- specifying destinations using 10.4.1
LOG_ARCHIVE_DUPLEX_DEST initialization parameter
- specifying destinations using 10.4.1
LOG_ARCHIVE_MAX_PROCESSES initialization parameter 10.3.4
LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter 10.6.1
LOG_ARCHIVE_TRACE initialization parameter 10.7
log archive destination groups 10.4.2
LOGGING clause
- CREATE TABLESPACE 11.5
logging mode
- direct-path INSERT 19.4.2.4
- NOARCHIVELOG mode and 19.4.2.4.1
logical corruptions from DBMS_REPAIR 24.3.2
logical standby 27.6
logical volume managers
- mapping files to physical devices 12.9, 12.9.4.3
- used for Oracle Managed Files 15.1.3
LOGON trigger
- setting resumable mode 18.2.3
logs
- job 29.2.3
- window (Scheduler) 28.9.3.1, 29.2.3
log sequence number
- control files 9.1.3.2
log switches
- description 9.1.3.2
- forcing 9.6
- log sequence numbers 9.1.3.2
- multiplexed redo log files and 9.2.1.1
- privileges 9.6
- using ARCHIVE_LAG_TARGET 9.2.6
- waiting for archiving to complete 9.2.1.1
log writer process (LGWR) 3.6
- multiplexed redo log files and 9.2.1.1
- online redo logs available for use 9.1.3
- trace files and 9.2.1.1
- writing to online redo log files 9.1.3
LONG columns 32.7
LONG RAW columns 32.7
lost write protection
- shadow lost write protection 11.11
LOST WRITE PROTECTION clause 11.11.2

M

maintenance tasks, automatic
- See: automatic maintenance tasks
maintenance window
- creating 25.4.2
- definition 25.1
- MAINTENANCE_WINDOW_GROUP 25.2
- modifying 25.4.1
- predefined 25.6.1
- removing 25.4.3
- Scheduler 25.2
MAKE procedure 39.2
managing
- indexes automatically 20.7
- sequences 23.2.1
- space threshold alerts for the undo tablespace 14.5.6
- synonyms 23.3.1
- tables 19
- transactions 30
- views 23.1
manual archiving
- in ARCHIVELOG mode 10.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
- Logical Partition Change Tracking (LPCT) 37.4.2.2
- 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 VI, 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 19.2.15
MAX_DUMP_FILE_SIZE initialization parameter 6.1.1.3.1, 7.1.3.1
MAX_IOPS parameter 26.1.4.3.4
MAX_MBPS parameter 26.1.4.3.4
MAXDATAFILES parameter
- changing 8.3.3.2
MAXINSTANCES 8.3.3.2
MAXLOGFILES parameter
- changing 8.3.3.2
- CREATE DATABASE statement 9.2.5
MAXLOGHISTORY parameter
- changing 8.3.3.2
MAXLOGMEMBERS parameter
- changing 8.3.3.2
- CREATE DATABASE statement 9.2.5
MAXTRANS parameter
- altering 19.7.2
media recovery
- effects of archiving on 10.2.1
MEMOPTIMIZE_POOL_SIZE initialization parameter 4.10
Memoptimized Rowstore
- about 4.10
- fast ingest 4.10
- fast lookup 4.10
- MEMOPTIMIZE_POOL_SIZE initialization parameter 4.10
memory
- automatic memory management 4.4
- automatic shared memory management 4.5.2
- Database Smart Flash Cache 4.7
- managing 4.1
- manual memory management 4.5
- manual shared memory management 4.5.3
- unified memory management 4.3
migrated rows
- eliminating from table, procedure 17.4.5.2
MINEXTENTS parameter
- cannot alter 19.7.2
mirrored files
- control files 8.2.2
- online redo log 9.2.1.1
- online redo log location 9.2.2
- online redo log size 9.2.3
MISSING data files 8.4.1
monitoring
- performance 6.2
- running chains 28.6.19
MONITORING clause
- CREATE TABLE 19.6
MONITORING USAGE clause
- of ALTER INDEX statement 20.4.7
Monthly Recommended Patches (MRP) 1.5.1
moving control files 8.3.2
multiple-destination jobs, Oracle Scheduler 27.3.2
- status of child jobs 29.2.2
multiple instances, managing CPU for 26.6.1
multiple jobs
- dropping 28.2.10
multiple temporary tablespaces 11.2.7.1, 11.2.7.4
multiplexed control files
- importance of 8.2.2
multiplexing
- archived redo log files 10.4.1
- control files 8.2.2
- redo log file groups 9.2.1
- redo log files 9.2.1

N

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 23.2.4.1, 23.2.4.1.1
- restrictions 23.2.4.1.3
NO_DATA_FOUND keyword 33.5
NO_MERGE hint 33.4.3.2
NOARCHIVELOG mode
- archiving 10.2
- definition 10.2.1
- dropping data files 12.4.3
- LOGGING mode and 19.4.2.4.1
- media failure 10.2.1
- no hot backups 10.2.1
- running in 10.2.1
- switching to 10.3.2
- taking data files offline in 12.4.3
NOLOGGING clause
- CREATE TABLESPACE 11.5
NOLOGGING mode
- direct-path INSERT 19.4.2.4
normal transmission mode
- definition 10.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 19.15.9
object quarantine 6.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 11.6.1
- taking offline 11.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 19.8.1, 37.1.4.1
- examples 19.8.15
- features of 19.8.2
- intermediate synchronization 19.8.8
- monitoring 19.8.10
- redefining a single partition
  - rules for 19.8.14.1
- redefining partitions 19.8.14
- refreshing dependent materialized views 19.8.9
- restarting after failure 19.8.11
- restrictions 19.8.4
- rolling back 19.8.12.2
- terminate and cleanup 19.8.13
- Virtual Private Database policies 19.8.6.3
- with DBMS_REDEFINITION 19.8.6.1
online redo log files
- See: online redo logs
online redo logs 9
- See also: redo log files]
- creating groups 9.3
- creating members 9.3.2
- data dictionary views reference 9.10
- dropping groups 9.5
- dropping members 9.5
- forcing a log switch 9.6
- guidelines for configuring 9.2
- INVALID members 9.5.2
- location of 9.2.2
- managing 9
- moving files 9.4
- number of files in the 9.2.5
- optimum configuration for the 9.2.5
- renaming files 9.4
- renaming members 9.4
- specifying ARCHIVE_LAG_TARGET 9.2.6
- STALE members 9.5.2
online segment shrink 18.3.3
ON PREBUILT TABLE clause 36.6.3
OPEN_LINKS initialization parameter 32.4.3
opening windows 28.9.3.5
operating system authentication 1.7.4, 1.7.4.2
operating systems
- database administrators requirements for 1.6.1
- renaming and relocating files 12.5.2
optimizer statistics
- dynamic 7.3.4.2.2
ORA-02055 error
- integrity constraint violation 33.3
ORA-02067 error
- rollback required 33.3
ORA-12838 error, direct path insert 19.4.2.3.2
Oracle Call Interface
- See: OCI
Oracle Database In-Memory 4.9
Oracle Database users
- types of 1.2
Oracle Data Guard
- support by the Scheduler 27.6, 29.5.5
Oracle home
- cloning 1.3.11
Oracle managed files
- naming 15.3.2
- scenarios for using 15.5
Oracle Managed Files
- adding to an existing database 15.5.3
- behavior 15.4
- benefits 15.1.5
- CREATE DATABASE statement 15.3.3
- creating 15.3
- creating control files 15.3.6.1
- creating data files 15.3.4.1
- creating online redo log files 15.3.7
- creating temp files 15.3.5.1
- described 15.1.1
- dropping data file 15.4.1
- dropping online redo log files 15.4.2
- dropping temp file 15.4.1
- initialization parameters 15.2.1
- renaming 15.4.3
Oracle Managed Files feature
- See: Oracle managed files
Oracle release numbers 1.5.1
Oracle Restart
- about 2.1.1
- configuration
  - adding components to 2.2.4
  - modifying 2.2.9
  - removing components from 2.2.5
  - viewing for a component 2.2.8
- configuring 2.2
- CRSCTL utility 2.1.4
- disabling and enabling management for a component 2.2.6
- environment variables in 2.2.10
- patches
  - installing 2.3
- registering a component with 2.2.4
- starting 2.1.4
- starting and stopping components managed by 2.3
  - Oracle home 2.3
- status of components 2.2.7
- stopping 2.1.4
Oracle Scheduler
- creating credentials 28.2.2.3
Oracle Scheduler agent
- on Windows 29.1.3.3.2
- OracleSchedulerExecutionAgent 29.1.3.3.2
- tasks 29.1.3.3
- Windows Service 29.1.3.3.2
Oracle Scheduler Agent 29.1.3
Oracle Scheduler agents
- registering with databases 29.1.3.3.5
OracleSchedulerExecutionAgent 29.1.3.3.2
ORAPWD utility 1.8.2
OR condition
- materialized views with subqueries 36.6.3
ORGANIZATION EXTERNAL clause
- of CREATE TABLE 19.15.2
orphan key table
- example of building 24.4.1.3
OSBACKUPDBA group 1.7.4.1
OSDBA group 1.7.4.1
OSDGDBA group 1.7.4.1
OSKMDBA group 1.7.4.1
OSOPER group 1.7.4.1
OTHER_GROUPS
- for Database Resource Manager 26.1.3.2
OTHER_GROUPS for Database Resource Manager 26.4.4.6, 26.4.4.7, 26.5.5
outer joins 23.1.5.4
- key-preserved tables in 23.1.5.4
overlapping windows 27.2.10.2

P

packages
- DBMS_FILE_TRANSFER 12.7
- DBMS_METADATA 17.13.1
- DBMS_REPAIR 24.2
- DBMS_RESOURCE_MANAGER 26.1.3.1, 26.1.4.1, 26.3.4.1.1
- DBMS_RESOURCE_MANAGER_PRIVS 26.1.4.1
- DBMS_RESUMABLE 18.2.4.3
- DBMS_SPACE 18.3.4, 18.6.1
- DBMS_STORAGE_MAP 12.9.3.2
packaging and uploading problems 7.4.2
parallel execution
- managing 3.8
- parallel hints 3.8.1
- parallelizing index creation 20.2.9
- resumable space allocation 18.2.1.5
parallel hints 3.8.1
parallelizing table creation 19.2.4, 19.3.3
parallel statement execution
- directive attributes for managing 26.5.4
- managing using Resource Manager 26.1.3.3.1.3.3
partitioned tables
- moving a partition online 19.7.3.3
- redefining partitions online 19.8.14
  - rules for 19.8.14.1
password file
- adding users 1.8.5
- creating 1.8.2
- ORAPWD utility 1.8.2
- removing 1.8.8
- setting REMOTE_LOGIN_PASSWORD 1.8.3
- synchronizing administrator passwords with the data dictionary 1.8.4
- viewing members 1.8.7
password file authentication 1.7.5, 1.7.5.1
passwords
- case sensitivity of 1.7.3.1, 1.7.5.1, 1.7.5.2
- password file 1.8.5
- setting REMOTE_LOGIN_PASSWORD parameter 1.8.3
patches
- installing
  - Oracle Restart 2.3
patch sets 1.5.1
pausing chains and chain steps 28.6.16
PCTINCREASE parameter 19.7.2
PCTUSED parameter
- value for complex materialized views 37.4.2.1
PDB performance profiles 26.4.1.3
- managing 26.4.1.6.3
PDB resource plans 26.1.3.4.2
PDBs
- buffer pool size 26.1.4.3.2
- CDB resource plans 26.1.3.4.1
  - creating 26.4.1.1, 26.4.1.3
  - directives 26.1.3.4.1.3
  - disabling 26.4.1.7
  - enabling 26.4.1.5
  - managing 26.4.1.6
  - shares 26.1.3.4.1.1
  - utilization limits 26.1.3.4.1.2
  - viewing information about 26.4.1.8
- CPU limits 26.1.4.3.1
- Database Resource Manager 26.4
- I/O limits 26.1.4.3.4
- import operations 13.2.3, 13.2.4
- PDB resource plans 26.1.3.4.2
  - creating 26.4.2.1
  - disabling 26.4.2.4
  - enabling 26.4.2.2
  - modifying 26.4.2.3
- PGA size 26.1.4.3.2
- resource management 26.1.1
- SGA size 26.1.4.3.2
- shared pool size 26.1.4.3.2
pending area for Database Resource Manager plans 26.4.4.9
- validating plan schema changes 26.4.4.7
pending transaction tables 35.7.6
performance
- index column order 20.2.3
- location of data files and 12.1.4
- monitoring 6.2
PGA_AGGREGATE_LIMIT parameter 26.1.4.3.2
PGA_AGGREGATE_TARGET parameter 26.1.4.3.2
PL/SQL
- replaced views and program units 23.1.3
plan schemas for Database Resource Manager 26.1.3.3.1.1.1, 26.2, 26.7.4
- validating plan changes 26.4.4.7
plans for Database Resource Manager
- examples 26.5
PRAGMA_EXCEPTION_INIT procedure
- assigning exception names 33.5
prefix compression 19.13.2.8, 20.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
prespawned processes 3.7
PRIMARY KEY constraints
- associated indexes 20.3.4.2
- dropping associated indexes 20.6
- enabling on creation 20.3.4.1
- foreign key references when dropped 17.7.3.1
- indexes associated with 20.3.4.1
- materialized views 36.4.2
- replicated tables 38.1.1
priorities
- job 28.9.2
priority transactions
- acknowledging rollback 30.1.1.3
- behavior 30.1.3, 30.1.3.2
- determining system-level wait targets 30.1.1.5
- distributed transaction behavior 30.1.3.1
- monitoring 30.1.2
- restrictions 30.1.4
- setting mode 30.1.1.4
- setting system-level wait targets 30.1.1.2
- setting transaction priority 30.1.1.1
- statistics incremented in ROLLBACK mode 30.1.2.1
- statistics incremented in TRACK mode 30.1.2.2
- using 30.1.1
private database links 31.2.7
private synonyms 23.3.1
private temporary tables
- creating 19.3.2.4
privileges
- adding redo log groups 9.3
- altering index 20.4.1
- altering tables 19.7
- closing a database link 33.2
- creating database links 32.2.1
- creating tables 19.3
- creating tablespaces 11.2.1
- database administrator 1.6
- dropping indexes 20.6
- dropping online redo log members 9.5.2
- dropping redo log groups 9.5.1
- drop table 19.11
- enabling and disabling triggers 17.6.1
- forcing a log switch 9.6
- for external tables 19.15.9
- managing with procedures 32.6.3.4
- managing with synonyms 32.6.2.2
- managing with views 32.6.1
- manually archiving 10.3.3
- materialized views 36.5.1, 38.2.4.3
- renaming objects 17.8
- renaming redo log members 9.4
- Scheduler 29.6.1
- sequences 23.2.2, 23.2.5
- setting chain (Scheduler) 29.1.1
- synonyms 23.3.2, 23.3.4
- taking tablespaces offline 11.6.1
- truncating 17.5.3
- using a view 23.1.4
- using sequences 23.2.4
- views 23.1.2.1, 23.1.3, 23.1.7
problem activity log
- adding comments to 7.2.7
problems
- about 7.1.2.1
- adding comments to activity log 7.2.7
problems (critical errors)
- packaging and uploading 7.4.2
procedures
- external 3.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 3.7
process manager (PMAN) 3.6
process monitor (PMON) 3.6
PRODUCT_COMPONENT_VERSION view 1.5.2
programs
- altering 28.3.3
- creating 28.3.2.1
- creating and managing, to define Scheduler jobs 28.3
- disabling 28.3.5
- dropping 28.3.4
- enabling 28.3.6
- overview 27.2.2
proxy resident connection pooling 3.3
- per-PDB 3.3
- per-service 3.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 23.3.1
PURGE_LOST_DB_ENTRY procedure
- DBMS_TRANSACTION package 35.6.2

Q

quarantine
- objects 6.3
- SQL statements 7.5.4
queries
- distributed 31.4.2
- distributed application development issues 33.4
- location transparency and 31.5.1.2
- remote 31.4.1
quotas
- tablespace 11.1.2

R

RAISE_APPLICATION_ERROR() procedure 33.5
read consistency
- managing in distributed databases 35.10
read-o 36.11.3
read-only materialized views VI, 36.2
- registration
  - manual 36.11.3
read-only response
- two-phase commit 34.3.2.2.2
read-only tables 19.7.9
read-only tablespaces
- data file headers when rename 11.9
- delaying opening of data files 11.7.5
- enabling database for object storage 11.7.6.1
- making read-only 11.7.2
- making writable 11.7.3
- on object storage
  - accessing 11.7.6.2
  - creating default credential 11.7.6.2.1
  - deleting 11.7.6.3
  - moving 11.7.6.2.2
  - querying 11.7.6.2.3
  - setting ACE 11.7.6.1.2
  - setting HTTP proxy 11.7.6.1.1
  - using 11.7.6
- WORM devices 11.7.4
Real Application Clusters
- allocating extents for cluster 21.4.1
- sequence numbers and 23.2.2
- threads of online redo log 9.1.1
rebuilding indexes 20.4.3
- costs 20.2.13
- online 20.4.3
reclaiming unused space 18.3
recoverer process 3.6
- disabling 35.9.2
- distributed transaction recovery 35.9.2
- enabling 35.9.2
- pending transaction table 35.9.2
recovering
- Scheduler jobs 29.4.1.4
recovery
- creating new control files 8.3.3.2
recycle bin
- about 19.12.1
- purging 19.12.4
- renamed objects 19.12.1
- restoring objects from 19.12.5
- viewing 19.12.3
REDEF_TABLE procedure 19.8.5
- example 19.8.15
redefining tables
- online
  - replication 37.1.4.1
redefining tables online
- See online redefinition of tables 19.8.1
redo log files 9.1
- See also: online redo logs
- active (current) 9.1.3.1
- archiving 10.2
- available for use 9.1.3
- block size, setting 9.2.4
- circular use of 9.1.3
- clearing 9.8
- contents of 9.1.2
- creating as Oracle Managed Files 15.3.7
- creating as Oracle Managed Files, example 15.5.1
- creating groups 9.3
- creating members 9.3, 9.3.2
- distributed transaction information in 9.1.3
- dropping groups 9.5
- dropping members 9.5
- group members 9.2.1
- groups, defined 9.2.1
- how many in redo log 9.2.5
- inactive 9.1.3.1
- instance recovery use of 9.1
- LGWR and the 9.1.3
- log switches 9.1.3.2
- maximum number of members 9.2.5
- members 9.2.1
- mirrored, log switches and 9.2.1.1
- multiplexed 9.2.1, 9.2.1.1
- online, defined 9.1
- planning the 9.2
- redo entries 9.1.2
- requirements 9.2.1.2
- specifying at database creation 15.3.3.2
- storing separately from data files 12.1.5
- threads 9.1.1
- valid and invalid configurations 9.2.1.2
- verifying blocks 9.7
redo logs
- See: online redo logredo log files
redo records 9.1.2
- LOGGING and NOLOGGING 11.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.5.1
releases 1.5
- checking the Oracle Database release number 1.5.2
- definition 1.5.1
release update (Update, RU) 1.5.1
Release Update Revisions (Revisions)
- installing 1.3.10
Release Updates (Updates)
- installing 1.3.10
relocating control files 8.3.2
REMOTE_LOGIN_PASSWORDFILE initialization parameter 1.8.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 27.3.1.1.1
- Scheduler agent setup 29.1.3.2
remote external jobs
- about 27.3.1.2.3
- executing 29.1.3
- Scheduler agent setup 29.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 17.8
renaming control files 8.3.2
renaming files
- Oracle Managed Files 15.4.3
renaming indexes 20.4.6
REOPEN attribute
- LOG_ARCHIVE_DEST_n initialization parameter 10.6.2
repairing data block corruption
- DBMS_REPAIR 24.1
repair table
- example of building 24.4.1.2
repeat interval, schedule 28.4.5.1
replication
- filter columns 37.1.4.2
- job child processes 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 7.4
RESOLVE_TNSNAME function 32.5.3
RESOURCE_MANAGER_CPU_SCOPE
- initialization parameter 26.11
RESOURCE_MANAGER_PLAN initialization parameter 26.2
resource allocation methods
- ACTIVE_SESS_POOL_MTH 26.4.4.5
- active session pool 26.4.4.5
- CPU 26.1.3.3.1.1
- CPU resource 26.4.4.5
- EMPHASIS 26.4.4.5
- limit on degree of parallelism 26.4.4.5
- MAX_UTILIZATION_METHOD 26.1.3.3.1.1.2
- PARALLEL_DEGREE_LIMIT_MTH 26.4.4.5
- PARALLEL_DEGREE_LIMIT_P1 26.1.3.3.1.3.1
- PARALLEL_QUEUE_TIMEOUT 26.1.3.3.1.3.3
- PARALLEL_STMT_CRITICAL 26.1.3.3.1.3.2
- PGA 26.1.3.3.1.4
- QUEUEING_MTH 26.4.4.5
- queuing resource allocation method 26.4.4.5
resource consumer groups 26.1.3.1
- changing 26.3.4.1.1
- creating 26.4.4.3
- DEFAULT_CONSUMER_GROUP 26.3.6.1, 26.7.2
- deleting 26.7.2
- granting the switch privilege 26.3.6.1
- managing 26.3, 26.3.4.2
- OTHER_GROUPS 26.1.3.2, 26.4.4.6, 26.4.4.7, 26.5.5
- parameters 26.4.4.3
- revoking the switch privilege 26.3.6.3
- setting initial 26.3.2
- switching a session 26.3.4.1.2
- switching sessions for a user 26.3.4.1.3
- SYS_GROUP 26.5.5
- updating 26.7.1
Resource Manager
- AUTO_TASK_CONSUMER_GROUP consumer group 25.5
- canceling long-running SQL statements 26.1.3.3.1.5.2
- managing parallel statement execution 26.1.3.3.1.3.3
- quarantine SQL statements 26.1.3.3.1.5.2
resource plan directives 26.1.3.1, 26.4.4.7
- deleting 26.7.6
- for managing parallel statement execution 26.5.4
- specifying 26.4.4.6
- updating 26.7.5
resource plans 26.1.3.1, 26.1.3.5.1
- CDB 26.1.3.4.1
- creating 26.4.3
- DEFAULT_MAINTENANCE_PLAN 25.5.1
- DELETE_PLAN_CASCADE 26.7.4
- deleting 26.7.4
- examples 26.5
- parameters 26.4.4.5
- PDB 26.1.3.4.2
- plan schemas 26.1.3.3.1.1.1, 26.2, 26.7.4
- SYSTEM_PLAN 26.5.5
- top plan 26.2, 26.4.4.7
- updating 26.7.3
- validating 26.4.4.7
resources (job)
- altering 28.8.2
- creating 28.8.1
- managing 28.8
- specifying for jobs 28.8.3
result sets, SQL 19.3.2.1
RESUMABLE_TIMEOUT initialization parameter
- setting 18.2.2.2
resumable space allocation
- correctable errors 18.2.1.3
- detecting suspended statements 18.2.4
- disabling 18.2.2.1
- distributed databases 18.2.1.4
- enabling 18.2.2.1
- example 18.2.6
- how resumable statements work 18.2.1.1
- naming statements 18.2.2.3.2
- parallel execution and 18.2.1.5
- resumable operations 18.2.1.2
- setting as default for session 18.2.3
- timeout interval 18.2.2.3.1, 18.2.4.1
retention guarantee (for undo) 14.2.2.3
reversing table changes 19.9
roles
- DBA role 1.6.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 27.6
rowids
- rowid materialized views 36.4.4
rows
- listing chained or migrated 17.4.5
row subsetting
- materialized views 36.6.1
rsmgr:io rate limit 26.1.4.3.4
rules
- adding to a chain 28.6.5
- dropping from chains 28.6.11
running
- chains 28.6.10
- jobs 28.2.4

S

savepoints
- in-doubt transactions 35.5, 35.5.2
scalable sequences 23.2.4.3
schagent utility 29.1.3.3.1
Scheduler
- administering 29
- architecture 27.4.1
- closing a PDB 27.5
- configuring 29.1
- credentials for jobs 27.2.7
- data dictionary views reference 29.6.2
- e-mail notifications 28.10.5
- examples of using 29.5
- import and export 29.3
- maintenance window 25.2
- monitoring and managing 29.2
- monitoring jobs 28.10.1
- objects 27.2
- overview 27.1
- security 29.2.5
- support for Oracle Data Guard 27.6, 29.5.5
- troubleshooting 29.4
  - job does not run 29.4.1
- using in RAC 27.4.6.1
SCHEDULER_BATCH_ERRORS view 28.2.10
Scheduler agent 29.1.3
- configuration 29.1.3.2
- installation 29.1.3.2
- setup 29.1.3.2
Scheduler chain condition syntax 28.6.5
Scheduler job credentials
- specifying 28.2.2.3
Scheduler objects, naming 28.1
Scheduler privileges reference 29.6.1
schedules
- altering 28.4.3
- creating 28.4.2
- creating and managing, to define Scheduler jobs 28.4
- dropping 28.4.4
- overview 27.2.3
schema objects
- analyzing 17.4.1
- creating multiple objects 17.3
- data dictionary views reference 17.13.2
- defining using DBMS_METADATA package 17.13.1
- dependencies between 17.9
- distributed database naming conventions for 31.2.10.4
- global names 31.2.10.4
- listing by type 17.13.2.1
- name resolution in distributed databases 31.2.10.4, 31.4.8.1
- name resolution in SQL statements 17.10
- privileges to rename 17.8
- referencing with synonyms 32.6.2.1
- renaming 17.8
- validating structure 17.4.3
- viewing information 17.13, 18.6
schema objects space usage
- data dictionary views reference 18.6.2
schemas
- creating for materialized views 38.2.4.1
SCN
- See: system change number
script jobs 27.3.1.8
security
- accessing a database 5.1
- administrator of 5.1
- centralized user management in distributed databases 31.3.2.4.1
- database security 5.1
- distributed databases 31.3.2
- establishing policies 5
- privileges 5.1
- remote objects 32.6.1
- Scheduler 29.2.5
- using synonyms 32.6.2.2
SEGMENT_FIX_STATUS procedure
- DBMS_REPAIR 24.2.1
Segment Advisor 18.3.2.1
- configuring Scheduler job 18.3.2.6
- invoking with Oracle Enterprise Manager Cloud Control 18.3.2.4.1
- invoking with PL/SQL 18.3.2.4.2
- running manually 18.3.2.4
- using 18.3.2.2
- viewing results 18.3.2.5
- views 18.3.2.7
segments
- available space 18.6.1
- data dictionary views for 18.6.2
- deallocating unused space 18.3
- displaying information on 18.6.2.1
- dropping for empty tables 18.4
- shrinking 18.3.3
SELECT statement
- FOR UPDATE clause and location transparency 32.7
SEQUENCE_CACHE_ENTRIES parameter 23.2.4.2.4
sequences
- accessing 23.2.4
- altering 23.2.3
- caching sequence numbers 23.2.4.2.1
- creating 23.2.2, 23.2.4.2.4
- CURRVAL 23.2.4.1.2
- data dictionary views reference 23.4
- dropping 23.2.5
- managing 23.2.1
- NEXTVAL 23.2.4.1.1
- Oracle Real Applications Clusters and 23.2.2
- scalable 23.2.4.3
server-generated alerts 6.1.2.1
SERVER parameter
- net service name 32.3.3.1
server processes
- archiver (ARCn) 3.6
- background 3.6
- checkpoint (CKPT) 3.6
- database writer (DBWn) 3.6
- dedicated 3.1.1
- dispatcher (Dnnn) 3.6
- dispatchers 3.4.4.3
- log writer (LGWR) 3.6
- monitoring locks 6.2.1
- process monitor (PMON) 3.6
- recoverer (RECO) 3.6
- shared server 3.1.2
- system monitor (SMON) 3.6
- trace files for 6.1.1.1
servers
- role in two-phase commit 34.2.3
service names
- database links and 32.2.4
services
- creating with SRVCTL and Oracle Restart 2.2.11
sessions
- acknowledge priority transactions rollback 30.1.1.3
- active 3.10.3
- inactive 3.10.4
- priority transactions 30.1
- setting advice for transactions 35.4.3.3
- setting priority transaction mode 30.1.1.4
- setting system-level wait targets 30.1.1.2
- setting transaction priority 30.1.1.1
- terminating 3.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
SGA
- See: system global area
SGA_MIN_SIZE parameter 26.1.4.3.2
SGA_TARGET parameter 26.1.4.3.2
shadow lost write protection 11.11
- creating tablespaces for 11.11.2
- disabling 11.11.5
- dropping a shadow tablespace 11.11.7
- enabling for a database 11.11.3
- enabling for a data file 11.11.4
- enabling for a PDB 11.11.3
- enabling for a tablespace 11.11.4
- removing 11.11.6
- suspending 11.11.6
SHARED_POOL_SIZE parameter 26.1.4.3.2
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 3.1.2
- configuring dispatchers 3.4.4
- data dictionary views reference 3.4.6
- disabling 3.4.3.2, 3.4.5
- initialization parameters 3.4.1
- interpreting trace output 6.1.1.5
- setting minimum number of servers 3.4.3.2
- trace files for processes 6.1.1.1
shared SQL
- for remote and distributed statements 31.4.3
shared temporary tablespaces 11.2.6.1
shrinking segments online 18.3.3
simple materialized views 36.4.5.2
Simple Network Management Protocol (SNMP) support
- database management 31.3.4.3
single-file tablespaces
- description 11.2.3.1
single-table hash clusters 22.3.3
site autonomy
- distributed databases 31.3.1
SKIP_CORRUPT_BLOCKS procedure 24.3.3.1
- DBMS_REPAIR 24.2.1
- example 24.4.5
skipping chain steps 28.6.17
SORT_AREA_SIZE initialization parameter
- index creation and 20.2.1
space
- deallocating unused 18.3.4
- reclaiming unused 18.3
space allocation
- resumable 18.2
space management
- data types, space requirements 18.5
- deallocating unused space 18.3
- Segment Advisor 18.3
- shrink segment 18.3
space usage alerts for tablespaces 18.1.2
SQL
- result sets 19.3.2.1
- submitting 1.4.1
- test cases 7.3.4
SQL_TRACE initialization parameter
- trace files and 6.1.1.1
SQL*Loader
- about 1.9, 19.4.1
SQL*Plus 1.4.1
- about 1.4.2
- connecting with 1.4.3.1
SQL failure
- repairing with SQL Repair Advisor 7.5.2
SQL incidents 7.3.4.2.1
SQL patch
- disabling using Cloud Control 7.5.2.4
- disabling using DBMS_SQLDIAG package subprogram 7.5.2.5
- removing using Cloud Control 7.5.2.4
- removing using DBMS_SQLDIAG package subprogram 7.5.2.5
- viewing using Cloud Control 7.5.2.4
SQL Repair Advisor
- about 7.5.2.1
- exporting and importing a patch using the DBMS_SQLDIAG package subprograms 7.5.2.6
- repairing SQL failure with 7.5.2
- running using Cloud Control 7.5.2.2
- running using the DBMS_SQLDIAG package subprograms 7.5.2.3
SQL statements
- about quarantine 7.5.4.1
- cancelling 3.10.5
- distributed databases and 31.4.1
- quarantine 7.5.4
SQL test case builder 7.1.1
SQL Test Case Builder 7.3.4.1
- accessing the Incident Manager 7.3.4.3.1.1
- accessing the Support Workbench 7.3.4.3.1.2
- command-line interface 7.3.4.3.2
- gathering diagnostic data 7.3.4
- graphical interface 7.3.4.3.1
- key concepts 7.3.4.2
- output 7.3.4.2.3
- running 7.3.4.4
- SQL incidents 7.3.4.2.1
- user interfaces 7.3.4.3
- what it captures 7.3.4.2.2
SRVCTL
- add asm command 2.5.1.1.1
- add command, usage description 2.5.1
- add database command 2.5.1.2.1
- adding a disk group with 2.5.1
- add listener command 2.5.1.3.2
- add ons command 2.5.1.4
- case sensitivity 2.5, 2.6
- case sensitivity of commands 2.5, 2.6
- command reference 2.5
- commands
  - downgrade database 2.5.4.1
  - upgrade database 2.5.14.1, 2.5.15.1
- commands, case sensitivity 2.5, 2.6
- component names 2.5
- config asm command 2.5.2.1.1
- config command, usage description 2.5.2
- config database command 2.5.2.2.1
- config listener command 2.5.2.3.1
- config ons command 2.5.2.4
- config service command 2.5.2.5.1
- creating and deleting databases services with 2.2.11
- disable asm command 2.5.3.1.1
- disable command, usage description 2.5.3
- disable database command 2.5.3.2.1
- disable diskgroup command 2.5.3.3
- disable listener command 2.5.3.4
- disable ons command 2.5.3.5
- disable service command 2.5.3.6.1
- enable asm command 2.5.5.1.1
- enable command, usage description 2.5.5
- enable database command 2.5.5.2.1
- enable diskgroup command 2.5.5.3
- enable listener command 2.5.5.4
- enable ons command 2.5.5.5
- enable service command 2.5.5.6.1
- getenv asm command 2.5.6.1
- getenv command, usage description 2.5.6
- getenv database command 2.5.6.2
- getenv listener command 2.5.6.3
- help for 2.2.3
- modify asm command 2.5.7.1.1
- modify command, usage description 2.5.7
- modify database command 2.5.7.2.1
- modify listener command 2.5.7.3.1
- modify ons command 2.5.7.4
- modify service command 2.5.7.5
- preparing to run 2.2.2
- reference 2.5
- remove asm command 2.5.8.1.1
- remove command, usage description 2.5.8
- remove database command 2.5.8.2.1
- remove diskgroup command 2.5.8.3
- remove listener command 2.5.8.4
- remove ons command 2.5.8.5
- remove service command 2.5.8.6.1
- setenv asm command 2.5.9.1.2
- setenv command, usage description 2.5.9
- setenv database command 2.5.9.2.2
- setenv listener command 2.5.9.3.2
- start asm command 2.5.10.1.1
- start command, usage description 2.5.10
- start database command 2.5.10.2.1
- start diskgroup command 2.5.10.3
- start home command 2.5.10.4
- start listener command 2.5.10.5.1
- start ons command 2.5.10.6
- start service command 2.5.10.7.1
- status asm command 2.5.11.1.1
- status command, usage description 2.5.11
- status database command 2.5.11.2.1
- status diskgroup command 2.5.11.3
- status home command 2.5.11.4
- status listener command 2.5.11.5
- status ons command 2.5.11.6
- status service command 2.5.11.7.1
- stop asm command 2.5.12.1.1
- stop command, usage description 2.5.12
- stop database command 2.5.12.2.1
- stop diskgroup command 2.5.12.3
- stop home command 2.5.12.4
- stop listener command 2.5.12.5.1
- stop ons command 2.5.12.6
- stop service command 2.5.12.7.1
- unsetenv asm command 2.5.13.1.2
- unsetenv command, usage description 2.5.13
- unsetenv database command 2.5.13.2.2
- unsetenv listener command 2.5.13.3.2
STALE status
- of redo log members 9.5.2
stalled chain (Scheduler) 28.6.20
standby transmission mode
- definition of 10.5.2
statement transparency in distributed database
- managing 32.7
statistics
- automatically collecting for tables 19.6
STATISTICS_LEVEL initialization parameter
- Database Resource Manager 26.1.2.1
statistics, optimizer
- dynamic 7.3.4.2.2
stderr
- for local external jobs 27.3.1.2.2, 27.3.1.2.3
  - retrieving 27.3.1.2.2, 27.3.1.2.3
stdout
- for local external jobs 27.3.1.2.2, 27.3.1.2.3
  - retrieving 27.3.1.2.2, 27.3.1.2.3, 28.2.2.10
steps, chain
- dropping 28.6.13
stopping
- chains 28.6.14
- chain steps 28.6.15
- jobs 28.2.5
storage parameters
- INITIAL 19.7.2
- INITRANS, altering 19.7.2
- MAXTRANS, altering 19.7.2
- MINEXTENTS 19.7.2
- PCTINCREASE 19.7.2
storage subsystems
- mapping files to physical devices 12.9, 12.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.4.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 7.1.3.8
- for Oracle ASM instance 7.3.1.1
- viewing problems with 7.3.1.1
Support Workbench, accessing 7.3.4.3.1.2
SWITCH LOGFILE clause
- ALTER SYSTEM statement 9.6
synonyms
- creating 23.3.2, 32.6.2.1
- data dictionary views reference 23.4
- definition and creation 32.6.2.1
- displaying dependencies of 17.13.2.2
- dropping 23.3.4
- examples 32.6.2.1
- location transparency in distributed databases 32.6.2
- managing 23.3.1, 23.3.4
- managing privileges in remote database 32.6.2.2
- name resolution in distributed databases 31.4.9.1
- private 23.3.1
- public 23.3.1
- remote object security 32.6.2.2
SYS_GROUP for Database Resource Manager 26.5.5
SYS account 1.6.2
- objects owned 1.6.2.2
SYSAUX tablespace 11.2.1
- cannot rename 11.9
- monitoring occupants 11.12.1
- moving occupants 11.12.2
SYSBACKUP account 1.6.2, 1.6.2.4
- connecting as 1.7.1
SYSDBA account
- connecting as 1.7.1
SYSDBA administrative privilege
- adding users to the password file 1.8.5
- determining who has privileges 1.8.7
- granting and revoking 1.8.6
SYSDG account 1.6.2, 1.6.2.4
- connecting as 1.7.1
SYSKM account 1.6.2, 1.6.2.4
- connecting as 1.7.1
SYSOPER account
- connecting as 1.7.1
SYSOPER administrative privilege
- adding users to the password file 1.8.5
- determining who has privileges 1.8.7
- granting and revoking 1.8.6
SYSRAC account 1.6.2.4
- connecting as 1.7.1
SYSTEM_PLAN for Database Resource Manager 26.5.5
SYSTEM account 1.6.2
- objects owned 1.6.2.3
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 12.10
- when assigned 9.1.2
system global area
- holds sequence number cache 23.2.4.2.1
system monitor process (SMON) 3.6
system privileges
- ADMINISTER_RESOURCE_MANAGER 26.1.4.1
- for external tables 19.15.9
SYSTEM tablespace
- cannot rename 11.9
- restrictions on taking offline 12.4.1
- when created 11.2.1

T

table compression 38.1.4
tables
- about 19.1
- adding columns 19.7.6
- allocating extents 19.7.4
- altering 19.7.1
- altering physical attributes 19.7.2
- analyzing 17.4.1
- attribute-clustered 19.2.9
- bulk updates 19.5
- compressed 19.2.6.1
- creating 19.3
- data dictionary views reference 19.19
- deferred segment creation 19.2.14
- designing before creating 19.2.1
- dropping 19.11
- dropping columns 19.7.8
- estimating size 19.2.16
- estimating space use 18.7.1
- external 19.15
- Flashback Drop 19.12
- Flashback Table 19.10
- global temporary 19.3.2.3
- guidelines for managing 19.2
- hash clustered
  - See hash clusters 22.3.1
- hybrid partitioned 19.16
- increasing column length 19.7.5
- index-organized 19.13
- invisible columns 19.2.12.1
- key-preserved 23.1.5.2
- limiting indexes on 20.2.4
- managing 19
- modifying column definition 19.7.5
- moving 19.7.3.1
- parallelizing creation 19.2.4, 19.3.3
- partitioned 19.14
- partitions
  - moving online 19.7.3.3
- private temporary 19.3.2.4
- read-only 19.7.9
- redefining online 19.8.1
  - replication 37.1.4.1
- renaming columns 19.7.7
- replicating 38.1
- researching and reversing erroneous changes to 19.9
- restrictions when creating 19.2.17
- setting storage parameters 19.2.16
- shrinking 18.3.3
- specifying location 19.2.3
- statistics collection, automatic 19.6
- temporary 19.3.2.1
- truncating 17.5
- types 19.2.2
- unrecoverable (NOLOGGING) 19.2.5
- validating structure 17.4.3
- zone maps 19.2.10
table size
- estimating 18.7.1
tablespaces
- adding data files 12.2
- assigning user quotas 11.1.2
- autoextending 11.8.1
- automatic segment space management 11.2.2.3
- bigfile 11.2.3.1
- checking default storage parameters 11.15.2
- compressed 11.2.4
- containing XMLTypes 13.1.4
- data dictionary views reference 11.15.1
- DBMS_SPACE_ADMIN package 11.13.1
- detecting and repairing defects 11.13.1
- diagnosing and repairing problems in locally managed 11.13.1
- dictionary managed 11.2.3.3
- dropping 11.10
- encrypted 11.2.5.1
  - creating 11.2.5.2
- guidelines for managing 11.1
- increasing size 11.8.1
- listing files of 11.15.3
- listing free space in 11.15.4
- locally managed 11.2.2.1
- locally managed temporary 11.2.6.2
- location 12.1.4
- migrating SYSTEM to locally managed 11.14
- on a WORM device 11.7.4
- Oracle Managed Files, managing 15.5.1, 15.5.2
- quotas, assigning 11.1.2
- read-only 11.7.1
  - mounting 13.1.2.2.4
- renaming 11.8, 11.9
- shrinking 11.8.4
- single-file 11.2.3.1, 11.8.3
- space usage alerts 18.1.2
- specifying nonstandard block sizes 11.4
- SYSAUX 11.2.1, 11.9
- SYSAUX, managing 11.12
- SYSTEM 11.2.1, 11.2.2.1
- taking offline normal 11.6.1
- taking offline temporarily 11.6.1
- temp files in locally managed 11.2.6.2
- temporary 11.2.6.1, 11.2.7.4
- temporary bigfile 11.2.6.3
- temporary for creating large indexes 20.3.5
- undo 14.1
- using multiple 11.1.1
- using Oracle Managed Files 15.3.4.1
tablespace set 13.3.3.1
TEMP_UNDO_ENABLED parameter 14.7
temp files 11.2.6.2
- creating as Oracle managed 15.3.5.1
- dropping 12.6
- dropping Oracle managed 15.4.1
temporary segments
- index creation and 20.2.1
temporary tables 38.1.4
- global 19.3.2.1
- private 19.3.2.1
temporary tablespace, default
- specifying at database creation 15.3.3.5
temporary tablespaces
- altering 11.8.5
- bigfile 11.2.6.3
- creating 11.2.6.2
- groups 11.2.7.1
- renaming default 11.9
- shrinking, locally managed 11.8.6
temporary undo 14.7
terminating user sessions
- active sessions 3.10.3
- identifying sessions 3.10.2
- inactive session, example 3.10.4
- inactive sessions 3.10.4
test case
- builder, SQL 7.1.1
threads
- online redo log 9.1.1
threshold based alerts
- managing with Oracle Enterprise Manager Cloud Control 6.1.2.2
threshold-based alerts
- server-generated 6.1.2.1
thresholds
- setting alert 18.1.2
trace files 7.1.3.4
- location of 6.1.1.1
- log writer process and 9.2.1.1
- materialized views 40.3.2
- using 6.1.1.1
- when written 6.1.1.4
trace files, finding 7.3.3.2
trace file segmentation 6.1.1.3.1
traces 7.1.3.4
tracing
- archivelog process 10.7
transaction control statements
- distributed transactions and 34.1.2
transaction failures
- simulating 35.9
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
- managing 30
- naming distributed 35.2, 35.4.3.2
- remote 31.4.4
transmitting archived redo log files 10.5
Transparent Data Encryption
- columns 19.2.13
- keystore 11.2.5.1, 19.2.13
- tablespaces 11.2.5.1
transporting data
- across platforms 13.1.3
- character sets 13.1.4
- compatibility considerations 13.1.5
- full transportable export/import 13.2
  - limitations 13.2.2
  - when to use 13.1.2
- limitations 13.1.4
- national character sets 13.1.4
- PDBs 13.2.3, 13.2.4
- transferring data files 13.6
- transportable tables 13.4
  - limitations 13.4.2
- transportable tablespaces 13.3
  - from backup 13.2.1, 13.3.1
  - limitations 13.3.2
  - tablespace set 13.3.3.1
  - transportable set 13.3.3
  - when to use 13.1.2
  - wizard in Oracle Enterprise Manager Cloud Control 13.3.1
- XMLTypes in 13.1.4
triggers
- disabling 17.6.3
- enabling 17.6.2
- for materialized view log 37.1.3
True Cache
- configuring and using 4.12
TRUNCATE statement
- DROP ALL STORAGE 17.5.3
- DROP STORAGE 17.5.3
- DROP STORAGE clause 17.5.3
- REUSE STORAGE 17.5.3
- REUSE STORAGE clause 17.5.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 Advisor 14.4
undo management
- automatic 14.2
- described 14.1
- initialization parameters for 14.2.1
- temporary undo 14.7
undo retention
- automatic tuning of 14.2.2.2
- explained 14.2.2.1
- guaranteeing 14.2.2.3
- setting 14.3
undo segments
- in-doubt distributed transactions 35.4.2
undo space
- data dictionary views reference 14.8
undo space management
- automatic undo management mode 14.2
Undo tablespace
- specifying at database creation 15.3.3.4
undo tablespaces
- altering 14.5.2
- creating 14.5.1.1
- data dictionary views reference 14.8
- dropping 14.5.3
- managing 14.5
- managing space threshold alerts 14.5.6
- monitoring 14.8
- PENDING OFFLINE status 14.5.4
- renaming 11.9
- sizing a fixed-size 14.4
- switching 14.5.4
- user quotas 14.5.5
unions
- with subqueries
  - materialized views 36.6.2.4
  - restrictions for materialized views 36.6.4
UNIQUE key constraints
- associated indexes 20.3.4.2
- dropping associated indexes 20.6
- enabling on creation 20.3.4.1
- foreign key references when dropped 17.7.3.1
- indexes associated with 20.3.4.1
UNRECOVERABLE DATAFILE clause
- ALTER DATABASE statement 9.8
UNREGISTER_MVIEW procedure 36.11.3
unusable indexes 20.2.11
updates
- bulk 19.5
- location transparency and 31.5.1.2
us 36.10.3
USER_DB_LINKS view 32.5.1
USER_DUMP_DEST initialization parameter 7.1.3.1
USER_REFRESH_CHILDREN view 40.3.2
USER_REFRESH view 40.3.2
user accounts
- predefined 5.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 11.1.2
- session, terminating 3.10.4
- SYS 1.6.2
- SYSBACKUP 1.6.2
- SYSDG 1.6.2
- SYSKM 1.6.2
- SYSTEM 1.6.2
utilities
- for the database administrator 1.9
- SQL*Loader 1.9, 19.4.1
utilization limits for PDBs 26.1.3.4.1.2
UTLCHAIN.SQL script
- listing chained rows 17.4.5.1
UTLCHN1.SQL script
- listing chained rows 17.4.5.1
UTLLOCKT.SQL script 6.2.1

V

V$ARCHIVE view 10.8
V$DATABASE view 10.8.1
V$DBLINK view 32.5.2
V$DIAG_CRITICAL_ERROR view 7.1.4
V$DIAG_INFO view 7.1.4
V$DISPATCHER_RATE view
- monitoring shared server dispatchers 3.4.4.4
V$DISPATCHER view
- monitoring shared server dispatchers 3.4.4.4
V$ENCRYPTED_TABLESPACES view 11.2.5.3, 11.15.1
V$LOG_HISTORY view 9.10
V$LOGFILE view 9.10
- log file status 9.5.2
V$LOG view 9.10, 10.8
- displaying archiving status 10.8
V$PWFILE_USERS view 1.8.7
V$QUARANTINE view 6.3.2
V$QUEUE view
- monitoring shared server dispatchers 3.4.4.4
V$RSRCPDBMETRIC_HISTORY view 26.8.6
V$RSRCPDBMETRIC view 26.8.6
- CPU usage 26.8.6.2
- I/O generated 26.8.6.4
- memory usage 26.8.6.5
- parallel execution 26.8.6.3
V$SESSION view 3.10.4
V$THREAD view 9.10
V$VERSION view 1.5.2
VALIDATE STRUCTURE clause
- of ANALYZE statement 17.4.3
VALIDATE STRUCTURE ONLINE clause
- of ANALYZE statement 17.4.3
varrays
- materialized 36.10.5
- materialized views
  - restrictions 36.10.5.1
- replication 36.10.5
verifying blocks
- redo log files 9.7
viewing
- alerts 18.1.3
- incident package details 7.4.3.1
views
- creating 23.1.2.1
- creating with errors 23.1.2.4
- data dictionary
  - for archived redo log files 10.8.1
  - for clusters 21.6
  - for control files 8.8
  - for database resident connection pooling 3.5.5
  - for Database Resource Manager 26.10.3
  - for data files 12.10
  - for hash clusters 22.6
  - for indexes 20.8
  - for Oracle Scheduler 29.6.2
  - for redo log 9.10
  - for schema objects 17.13.2
  - for sequences 23.4
  - for shared server 3.4.6
  - for space usage in schema objects 18.6.2
  - for synonyms 23.4
  - for tables 19.19
  - for tablespaces 11.15.1
  - for undo space 14.8
  - for views 23.4
- data dictionary views for 23.4
- DBA_2PC_NEIGHBORS 35.3.2
- DBA_2PC_PENDING 35.3.1
- DBA_DB_LINKS 32.5.1
- displaying dependencies of 17.13.2.2
- dropping 23.1.7
- file mapping views 12.9.3.3
- FOR UPDATE clause and 23.1.2.1
- invalid 23.1.4
- join
  - See join views 23.1.2.2
- location transparency in distributed databases 32.6.1
- managing 23.1, 23.1.3
- managing privileges with 32.6.1
- name resolution in distributed databases 31.4.9.1
- ORDER BY clause and 23.1.2.1
- remote object security 32.6.1
- restrictions 23.1.4
- using 23.1.4
- V$ARCHIVE 10.8
- V$DATABASE 10.8.1
- V$LOG 10.8
- V$LOGFILE 9.5.2
- wildcards in 23.1.2.3
- WITH CHECK OPTION 23.1.2.1
virtual columns 19.1, 38.1.4
- indexing 20.2.2
Virtual Private Database
- redefining tables online 19.8.6.3
virtual private database (VPD) 38.2.4.2

W

wildcards
- in views 23.1.2.3
window groups
- creating 28.9.4.2
- disabling 28.9.4.7
- dropping 28.9.4.3
- dropping a member from 28.9.4.5
- enabling 28.9.4.6
- managing job scheduling and job priorities with 28.9.4
- overview 27.2.11.3
window logs 28.9.3.1
windows, managing job scheduling and resource allocation with 28.9.3.1
windows (Scheduler)
- altering 28.9.3.4
- closing 28.9.3.6
- creating 28.9.3.3
- disabling 28.9.3.8
- dropping 28.9.3.7
- enabling 28.9.3.9
- opening 28.9.3.5
- overlapping 27.2.10.2
- overview 27.2.10.1
WITH ROWID clause
- REFs 36.10.6.5
WORM devices
- and read-only tablespaces 11.7.4
WRH$_UNDOSTAT view 14.8

X

XMLTypes
- transporting data 13.1.4

Z

zone maps 19.2.10