Index
A
- abort response 34.3.2.2.3
- two-phase commit 34.3.2.2.3
- accounts
- adaptive query optimization
- adaptive plans 7.3.4.2.2
- adaptive query plans 7.3.4.2.2
- adding
- ADD LOGFILE clause
- ALTER DATABASE statement 9.3.1
- ADD LOGFILE MEMBER clause
- ALTER DATABASE statement 9.3.2
- ADMIN_TABLES procedure
- ADMINISTER_RESOURCE_MANAGER system privilege 26.1.4.1
- administering
- the Scheduler 29
- administration
- distributed databases 32
- administrative user accounts 1.6.2.1
- 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
- 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
- alerts
- 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
- ALTER DATABASE statement
- ALTER INDEX statement
- COALESCE clause 20.2.13
- altering
- ALTER SEQUENCE statement 23.2.3
- ALTER SESSION statement
- ALTER SYSTEM FLUSH FLASH_CACHE 4.7.3
- ALTER SYSTEM statement
- 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
- ANALYZE statement
- 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
- 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
- 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
- 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
- automatic error mitigation 7.5.1
- automatic file extension 12.3.1
- automatic indexes 20.7
- views 20.7.5
- automatic indexing
- automatic maintenance tasks
- 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
- 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
- space management
- 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
- 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
- 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
- checkpoint process (CKPT) 3.6
- checksums
- clearing redo log files 9.8
- CLEAR LOGFILE clause
- ALTER DATABASE statement 9.8
- client/server architectures
- cloning
- 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
- collocated inline views
- tuning distributed queries 33.4.1
- column objects
- columns
- column subsetting
- materialized views
- column objects 36.10.3
- materialized views
- 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
- commit point site 34.2.6.1
- commit point strength
- COMMIT statement
- 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
- 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
- connecting
- with SQL*Plus 1.4.3.1
- connection qualifiers
- 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
- 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
- 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
- CREATE BIGFILE TABLESPACE statement 11.2.3.2
- CREATE BIGFILE TEMPORARY TABLESPACE statement 11.2.6.3
- CREATE CLUSTER statement
- CREATE CONTROLFILE statement
- CREATE DATABASE LINK statement 32.2.2.1
- CREATE DATABASE statement
- CREATE INDEX statement
- 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
- CREATE TABLE statement
- CREATE TEMPORARY TABLESPACE statement 11.2.6.2
- CREATE UNDO TABLESPACE statement
- CREATE VIEW statement
- creating
- 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
- 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
- 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
- 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
- Database Smart Flash Cache 4.7
- database writer process
- calculating checksums for data blocks 12.7
- database writer process (DBWn) 3.6
- data block corruption
- repairing 24.1
- data blocks
- data dictionary
- 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
- online 12.4.3
- 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
- DBMS_METADATA package
- DBMS_MVIEW package 36.11.3
- DBMS_PROCESS package 3.7.2
- DBMS_REDEFINITION package
- performing online redefinition with 19.8.6.1
- DBMS_REFRESH package
- DBMS_REPAIR
- logical corruptions 24.3.2
- DBMS_REPAIR package
- 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
- DBMS_SPACE package 18.3.4
- 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
- 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
- deferred segments
- materializing 19.2.15
- defining
- chain steps 28.6.4
- deleting
- certificates 19.18.10
- dependencies
- 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
- 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
- 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
- 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
- DUMP_ORPHAN_KEYS procedure
- dumps 7.1.3.4
- dynamic statistics 7.3.4.2.2
E
- ECID 7.1.2.3
- editions
- e-mail notifications, Scheduler 28.10.5
- EMPHASIS resource allocation method 26.4.4.5
- empty tables
- dropping segments 18.4
- enabling
- enabling recoverer process
- distributed transactions 35.9.2
- encryption
- 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
- 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
- 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
- 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
- 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
- external tables
F
- fast recovery area
- fast refresh 36.4.2, 36.7, 37.4.2.2
- fault diagnosability infrastructure 7.1.1, 7.1.3
- file mapping
- file names
- Oracle Managed Files 15.3.2
- files
- file system
- used for Oracle managed files 15.1.4
- file watchers
- 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
- fixed user database links
- flashback data archive 38.1.4
- Flashback Drop
- Flashback Table
- overview 19.10
- flood-controlled incidents
- FMON background process 12.9.2.1.1
- FORCE clause
- force full database caching mode 4.6
- FORCE LOGGING
- precedence of settings 9.9
- FORCE LOGGING clause
- CREATE TABLESPACE 11.5
- force refresh 36.7, 37.4.2.3
- forcing
- forcing a log switch 9.6
- foreign keys
- replicated tables 38.1.2
- forget phase
- in two-phase commit 34.3.4
- free space
- 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
- globalization support
- global object names
- 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
- heterogeneous distributed systems
- definition 31.1.2.1
- Heterogeneous Services
- overview 31.1.2.1
- hints 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
- Import
- materialized view logs 37.1.4.3
- import operations
- Incident Manager, accessing 7.3.4.3.1.1
- incident package
- incident packages 7.4.1
- incident packaging service 7.1.1
- incidents
- incidents, SQL 7.3.4.2.1
- incompatibilities
- 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
- 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
- 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
- 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
- joins
- statement transparency in distributed databases 32.7
- join views
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
- local temporary tablespaces 11.2.6.1
- location transparency in distributed databases
- locks
- lock timeout interval
- distributed transactions 35.8
- log
- window (Scheduler) 28.9.3.1
- LOG_ARCHIVE_DEST_n initialization parameter 10.4.1
- 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
- LOGON trigger
- setting resumable mode 18.2.3
- logs
- log sequence number
- control files 9.1.3.2
- log switches
- log writer process (LGWR) 3.6
- 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
- MAKE procedure 39.2
- managing
- 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
- master tables
- materialized view logs 36.9, 37.1.4.1
- column logging 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
- refresher 36.5.1
- refresh groups 36.8, 37.3.1
- size 37.3.2
- refreshing 36.7, 37.4.1
- REFs 36.10.6.1
- 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
- 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
- BUILD DEFERRED
- materialized view sites 36.1
- 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
- MAXLOGHISTORY parameter
- changing 8.3.3.2
- MAXLOGMEMBERS parameter
- MAXTRANS parameter
- altering 19.7.2
- media recovery
- effects of archiving on 10.2.1
- MEMOPTIMIZE_POOL_SIZE initialization parameter 4.10
- Memoptimized Rowstore
- memory
- migrated rows
- eliminating from table, procedure 17.4.5.2
- MINEXTENTS parameter
- cannot alter 19.7.2
- mirrored files
- MISSING data files 8.4.1
- monitoring
- 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
N
- name resolution in distributed databases
- nested tables
- networks
- 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
- 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
- offline tablespaces
- 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
- 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
- Oracle home
- cloning 1.3.11
- Oracle managed files
- 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
- 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
- packaging and uploading problems 7.4.2
- parallel execution
- 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
- password file
- password file authentication 1.7.5, 1.7.5.1
- passwords
- patches
- installing
- Oracle Restart 2.3
- installing
- 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
- 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
- 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
- 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
- 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
- problems (critical errors)
- packaging and uploading 7.4.2
- procedures
- 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
- proxy resident connection pooling 3.3
- public database links 31.2.7
- public fixed user database links 32.8.1
- public synonyms 23.3.1
- PURGE_LOST_DB_ENTRY procedure
- DBMS_TRANSACTION package 35.6.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
- registration
- 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
- rebuilding indexes 20.4.3
- reclaiming unused space 18.3
- recoverer process 3.6
- recovering
- Scheduler jobs 29.4.1.4
- recovery
- creating new control files 8.3.3.2
- recycle bin
- REDEF_TABLE procedure 19.8.5
- example 19.8.15
- redefining tables
- online
- replication 37.1.4.1
- online
- 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
- 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
- REFRESH procedure 37.4.3.2, 39.3
- REFs
- REGISTER_MVIEW procedure 36.11.3
- release numbers 1.5.1
- releases 1.5
- 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
- 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
- unsupported table types 38.1.4
- user-defined data types 36.10.1
- virtual private database (VPD) 38.2.4.2
- replication catalog
- replication objects
- 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
- resource plans 26.1.3.1, 26.1.3.5.1
- resources (job)
- 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
- rollbacks
- ORA-02 33.3
- ROLLBACK statement
- 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
- running
S
- savepoints
- 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
- 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
- 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
- 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
- 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
- session trees for distributed transactions
- 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
- SHARED_POOL_SIZE parameter 26.1.4.3.2
- shared database links
- shared server 3.1.2
- 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
- skipping chain steps 28.6.17
- SORT_AREA_SIZE initialization parameter
- index creation and 20.2.1
- space
- space allocation
- resumable 18.2
- space management
- space usage alerts for tablespaces 18.1.2
- SQL
- SQL_TRACE initialization parameter
- trace files and 6.1.1.1
- SQL*Loader
- SQL*Plus 1.4.1
- SQL failure
- repairing with SQL Repair Advisor 7.5.2
- SQL incidents 7.3.4.2.1
- SQL patch
- SQL Repair Advisor
- SQL statements
- 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
- 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
- for local external jobs 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
- for local external jobs 27.3.1.2.2, 27.3.1.2.3
- steps, chain
- dropping 28.6.13
- stopping
- storage parameters
- storage subsystems
- stored procedures
- submitting SQL and commands to the database 1.4.1
- subqueries
- subsetting
- SunSoft SunNet Manager 31.3.4.3
- Support Workbench 7.1.3.8
- 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
- SYSBACKUP account 1.6.2, 1.6.2.4
- connecting as 1.7.1
- SYSDBA account
- connecting as 1.7.1
- SYSDBA administrative privilege
- 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
- 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
- system global area
- holds sequence number cache 23.2.4.2.1
- system monitor process (SMON) 3.6
- system privileges
- SYSTEM tablespace
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
- 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
- temporary segments
- index creation and 20.2.1
- temporary tables 38.1.4
- temporary tablespace, default
- specifying at database creation 15.3.3.5
- temporary tablespaces
- temporary undo 14.7
- terminating user sessions
- 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
- 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
- transmitting archived redo log files 10.5
- Transparent Data Encryption
- 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.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
- XMLTypes in 13.1.4
- triggers
- True Cache
- configuring and using 4.12
- TRUNCATE statement
- 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
- undo retention
- 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
- unions
- UNIQUE key constraints
- UNRECOVERABLE DATAFILE clause
- ALTER DATABASE statement 9.8
- UNREGISTER_MVIEW procedure 36.11.3
- unusable indexes 20.2.11
- updates
- 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
- users
- utilities
- 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
- 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
- verifying blocks
- redo log files 9.7
- viewing
- 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