Index

A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Z  

Symbols

  • ? 1
  • .trm files 1
  • @ 1

A

  • abort response
    • two-phase commit 1
  • accounts
    • DBA operating system account 1
  • adding
    • columns 1
    • columns in compressed tables 1
  • ADD LOGFILE clause
    • ALTER DATABASE statement 1
  • ADD LOGFILE MEMBER clause
    • ALTER DATABASE statement 1
  • ADMIN_TABLES procedure
    • DBMS_REPAIR package 1
    • example 1 , 2
  • ADMINISTER_RESOURCE_MANAGER system privilege 1
  • administering
    • the Scheduler 1
  • administration
    • distributed databases 1
  • administrative user accounts
    • SYS 1
    • SYSBACKUP 1
    • SYSDG 1
    • SYSKM 1
  • administrator passwords, synchronizing password file and data dictionary 1
  • ADR
    • See: automatic diagnostic repository
  • ADR base 1
  • ADRCI utility 1
  • ADR home 1
  • advanced index compression 1
  • advanced row compression 1
  • Advisor
    • Data Repair 1
    • Undo 1
  • AFTER SUSPEND trigger
    • example of registering 1
  • agent
    • Heterogeneous Services, definition of 1
  • aggregate functions
    • statement transparency in distributed databases 1
  • alert log
    • about 1
    • size of 1
    • using 1
    • viewing 1
    • when written 1
  • alerts
    • server-generated 1
    • tablespace space usage 1
    • threshold-based 1
    • viewing 1
  • alert thresholds
    • setting for locally managed tablespaces 1
  • ALL_DB_LINKS view 1
  • allocation
    • extents 1
  • ALTER CLUSTER statement
    • ALLOCATE EXTENT clause 1
    • using for hash clusters 1
    • using for index clusters 1
  • ALTER DATABASE statement
    • ADD LOGFILE clause 1
    • ADD LOGFILE MEMBER clause 1
    • ARCHIVELOG clause 1
    • CDBs 1
    • CLEAR LOGFILE clause 1
    • database partially available to users 1
    • DATAFILE...OFFLINE DROP clause 1
    • DROP LOGFILE clause 1
    • DROP LOGFILE MEMBER clause 1
    • MOUNT clause 1
    • NOARCHIVELOG clause 1
    • OPEN clause 1
    • READ ONLY clause 1
    • RENAME FILE clause 1
    • UNRECOVERABLE DATAFILE clause 1
  • ALTER INDEX statement
    • COALESCE clause 1
    • MONITORING USAGE clause 1
  • altering
    • (Scheduler) windows 1
    • event-based job 1
    • event schedule 1
    • indexes 1
    • job classes 1
    • jobs 1
    • programs 1
    • schedules 1
  • ALTER PLUGGABLE DATABASE statement
    • UNPLUG INTO clause 1
  • ALTER SEQUENCE statement 1
  • ALTER SESSION statement
    • ADVISE clause 1
    • CLOSE DATABASE LINK clause 1
    • Enabling resumable space allocation 1
    • SET CONTAINER clause 1
    • setting time zone 1
  • ALTER SYSTEM statement
    • ARCHIVE LOG ALL clause 1
    • CDBs 1
    • CONTAINER clause 1
    • DISABLE DISTRIBUTED RECOVERY clause 1
    • ENABLE DISTRIBUTED RECOVERY clause 1
    • ENABLE RESTRICTED SESSION clause 1
    • enabling Database Resource Manager 1
    • PDBs 1
    • QUIESCE RESTRICTED 1
    • RESUME clause 1
    • SET RESOURCE_MANAGER_PLAN 1
    • SET SHARED_SERVERS initialization parameter 1
    • SUSPEND clause 1
    • SWITCH LOGFILE clause 1
    • UNQUIESCE 1
  • ALTER TABLESPACE statement
    • adding an Oracle managed data file, example 1
    • adding an Oracle managed temp file, example 1
    • ONLINE clause, example 1
    • READ ONLY clause 1
    • RENAME DATAFILE clause 1
  • ALTER TABLE statement
    • ALLOCATE EXTENT clause 1
    • DEALLOCATE UNUSED clause 1
    • DISABLE ALL TRIGGERS clause 1
    • DISABLE integrity constraint clause 1
    • DROP COLUMN clause 1
    • DROP integrity constraint clause 1
    • DROP UNUSED COLUMNS clause 1
    • ENABLE ALL TRIGGERS clause 1
    • ENABLE integrity constraint clause 1
    • external tables 1
    • modifying index-organized table attributes 1
    • MOVE clause 1 , 3 , 4 , 6
    • reasons for use 1
    • SET UNUSED clause 1
  • ALTER TRIGGER statement
    • DISABLE clause 1
    • ENABLE clause 1
  • ANALYZE statement
    • CASCADE clause 1
    • CASCADE clause, FAST option 1
    • corruption reporting 1
    • listing chained rows 1
    • remote tables 1
    • validating structure 1 , 2
  • analyzing schema objects 1
  • analyzing tables
    • distributed processing 1
  • APPEND hint 1
  • Application Continuity 1
  • application development
    • distributed databases 1 , 2 , 3
  • application development for distributed databases
    • analyzing execution plan 1
    • database links, controlling connections 1
    • handling errors 1 , 2
    • handling remote procedure errors 1
    • managing distribution of data 1
    • managing referential integrity constraints 1
    • terminating remote connections 1
    • tuning distributed queries 1
    • tuning using collocated inline views 1
    • using cost-based optimization 1
    • using hints to tune queries 1
  • archived redo log files
    • alternate destinations 1
    • archiving modes 1
    • data dictionary views 1
    • destination availability state, controlling 1
    • destinations, specifying 1
    • destination status 1
    • failed destinations and 1
    • mandatory destinations 1
    • multiplexing 1
    • normal transmission of 1
    • re-archiving to failed destination 1
    • sample destination scenarios 1
    • standby transmission of 1
    • status information 1
    • transmitting 1
  • ARCHIVELOG mode
    • advantages 1
    • archiving 1
    • automatic archiving in 1
    • definition of 1
    • distributed databases 1
    • enabling 1
    • manual archiving in 1
    • running in 1
    • switching to 1
    • taking data files offline and online in 1
  • archiver process (ARCn)
    • trace output (controlling) 1
  • archiving
    • alternate destinations 1
    • changing archiving mode 1
    • controlling number of processes 1
    • destination availability state, controlling 1
    • destination failure 1
    • destination status 1
    • manual 1
    • NOARCHIVELOG vs. ARCHIVELOG mode 1
    • setting initial mode 1
    • to failed destinations 1
    • trace output, controlling 1
    • viewing information on 1
  • at-sign 1
  • attribute-clustered tables 1
  • auditing
    • database links 1
  • authentication
    • database administrators 1
    • database links 1
    • operating system 1
    • password files 1
    • selecting a method 1
    • using password file 1
  • AUTO_TASK_CONSUMER_GROUP
    • of Resource Manager 1
  • AUTOEXTEND clause 1
  • automatic big table cache 1
  • automatic diagnostic repository
    • in Oracle Client 1
    • in Oracle Clusterware 1
    • in Oracle Real Application Clusters 1
    • structure, contents and location of 1
  • automatic file extension 1
  • automatic maintenance tasks
    • assigning to maintenance windows 1
    • definition 1
    • enabling and disabling 1
    • predefined 1
    • resource allocation 1
    • Scheduler job names 1
  • automatic segment space management 1
  • automatic undo management
    • migrating to 1

B

  • BACKGROUND_DUMP_DEST initialization parameter 1
  • background processes
    • FMON 1
  • backups
    • after creating new databases 1
    • effects of archiving on 1
  • batch jobs, authenticating users in 1
  • bigfile tablespaces
    • creating 1
    • creating temporary 1
    • description 1
    • setting database default 1
  • big table cache 1
  • BLOB data type 1
  • block size, redo log files 1
  • BLOCKSIZE clause
    • of CREATE TABLESPACE 1

C

  • caches
    • sequence numbers 1
  • calendaring expressions 1
  • calls
    • remote procedure 1
  • capacity planning
    • space management
      • capacity planning 1
  • CASCADE clause
    • when dropping unique or primary keys 1
  • CATBLOCK.SQL script 1
  • catcon.pl 1
  • CDB_PDB_HISTORY view 1
  • CDB_PDBS view 1
  • CDB resource plans 1
  • CDBs
    • administering 1 , 2
    • ALTER DATABASE statement 1
    • ALTER PLUGGABLE DATABASE statement 1
    • ALTER SYSTEM statement 1
    • CDB resource plans
      • viewing information about 1
    • common users
      • definition 1
    • compatibility violations 1
    • connecting to
      • ALTER SESSION statement 1
      • CONNECT command 1
    • container data objects
      • querying 1
    • containers 1 , 2
    • CONTAINERS clause 1
    • creating 1
    • current container 1 , 2
    • Database Resource Manager 1
    • data definition language (DDL) 1
    • DBMS_SQL package 1
    • EM Express 1
    • ENABLE PLUGGABLE DATABASE clause 1
    • executing PL/SQL code 1
    • initialization parameters 1
    • local users
      • definition 1
    • modifying 1 , 2 , 3
    • monitoring 1
    • Oracle Database Vault 1
    • Oracle Managed Files 1
    • PDB_FILE_NAME_CONVERT initialization parameter 1
    • PDBs
      • modifying 1
    • planning creation 1
    • plugging in PDBs
      • CREATE PLUGGABLE DATABASE statement 1
      • methods for 1
      • preparing for 1
    • prerequisites for 1
    • purpose of 1
    • root container
      • definition 1
      • modifying 1
    • SEED FILE_NAME_CONVERT clause 1
    • seed PDB 1
    • shutting down 1
    • SQL scripts 1
    • standby database 1
    • tools for 1
    • Transparent Data Encryption 1
    • unplugging PDBs 1
    • viewing information about 1
    • views 1
  • centralized user management
    • distributed systems 1
  • chain condition syntax 1
  • chained rows
    • eliminating from table, procedure 1
  • chain rules 1
  • chains
    • creating 1
    • creating and managing job 1
    • creating jobs for 1
    • disabling 1
    • dropping 1
    • dropping rules from 1
    • enabling 1
    • handling stalled 1
    • monitoring running 1
    • overview 1
    • pausing 1
    • running 1
    • setting privileges 1
    • steps
      • pausing 1
      • skipping 1
    • stopping 1
    • stopping individual steps 1
  • chain steps
    • defining 1
  • change vectors 1
  • character set
    • choosing 1
  • CHAR data type
    • increasing column length 1
  • CHECK_OBJECT procedure
    • DBMS_REPAIR package 1
    • example 1
    • finding extent of corruption 1
  • checkpoint process (CKPT) 1
  • checksums
    • for data blocks 1
    • redo log blocks 1
  • clearing redo log files 1
  • CLEAR LOGFILE clause
    • ALTER DATABASE statement 1
  • client/server architectures
    • distributed databases 1
    • globalization support 1
  • CloneDB 1
  • clonedb.pl Perl script 1
  • CLONEDB parameter 1
  • cloning
    • a database 1 , 2
    • an Oracle home 1
  • CLOSE DATABASE LINK clause
    • ALTER SESSION statement 1
  • closing database links 1
  • closing windows 1
  • clusters
    • about 1
    • allocating extents 1
    • altering 1
    • analyzing 1
    • clustered tables 1 , 2 , 3 , 4 , 5
    • cluster indexes 1
    • cluster keys 1 , 2
    • columns for cluster key 1
    • creating 1
    • data dictionary views reference 1
    • deallocating extents 1
    • dropping 1
    • estimating space 1 , 2
    • guidelines for managing 1
    • location 1
    • privileges 1 , 2 , 3
    • selecting tables 1
    • single-table hash clusters 1
    • truncating 1
    • validating structure 1
  • coalescing indexes
    • costs 1
  • cold backup
    • performing with a detached Oracle Scheduler job 1
  • collocated inline views
    • tuning distributed queries 1
  • column encryption 1
  • columns
    • adding 1
    • adding to compressed table 1
    • displaying information about 1
    • dropping 1 , 2
    • dropping in compressed tables 1
    • encrypted 1
    • increasing length 1
    • invisible 1
    • modifying definition 1
    • renaming 1
    • virtual 1
    • virtual, indexing 1
  • commands
    • submitting 1
  • comments
    • adding to problem activity log 1
  • COMMENT statement 1
  • COMMIT_POINT_STRENGTH initialization parameter 1
  • commit phase
    • in two-phase commit 1 , 2
  • commit point site
    • commit point strength 1 , 2
    • determining 1
    • distributed transactions 1 , 2
    • how the database determines 1
  • commit point strength
    • definition 1
    • specifying 1
  • COMMIT statement
    • FORCE clause 1 , 2 , 3
    • forcing 1
    • two-phase commit and 1
  • committing transactions
    • commit point site for distributed transactions 1
  • COMMON_USER_PREFIX parameter 1
  • common users
    • definition 1
    • prefix 1
  • compatibility level 1
  • COMPATIBLE Initialization Parameter 1
  • components
    • srvctl component names and abbreviations 1
  • compression
    • indexes
      • advanced compression 1
      • prefix compression 1
    • levels 1
    • tables
      • adding a column 1
      • dropping columns in 1
    • tablespaces 1
  • configuring
    • an Oracle database 1
    • Oracle Scheduler 1
  • CONNECT command
    • starting an instance 1
  • CONNECT command, SQL*Plus
    • CDBs 1
  • connected user database links
    • advantages and disadvantages 1
    • definition 1
    • REMOTE_OS_AUTHENT initialization parameter 1
  • connecting
    • with SQL*Plus 1
  • connection qualifiers
    • database links and 1
  • connections
    • terminating remote 1
  • constraints
    • disabling at table creation 1
    • distributed system application development issues 1
    • dropping integrity constraints 1
    • enable novalidate state 1
    • enabling example 1
    • enabling when violations exist 1
    • exceptions 1 , 2
    • exceptions to integrity constraints 1
    • integrity constraint states 1
    • keeping index when disabling 1
    • keeping index when dropping 1
    • ORA-02055 constraint violation 1
    • renaming 1
    • setting at table creation 1
    • when to disable 1
  • container data objects
    • definition 1
    • querying 1
  • containers, CDB 1
  • CONTAINERS clause 1
  • CONTROL_FILES initialization parameter
    • overwriting existing control files 1
    • specifying file names 1
    • when creating a database 1 , 2
  • CONTROLFILE REUSE clause 1
  • control files
    • adding 1
    • changing size 1
    • conflicts with data dictionary 1
    • creating 1 , 2 , 3
    • creating as Oracle Managed Files 1
    • data dictionary views reference 1
    • default name 1 , 2
    • dropping 1
    • errors during creation 1
    • importance of multiplexed 1
    • initial creation 1
    • location of 1
    • log sequence numbers 1
    • mirroring 1 , 2
    • moving 1
    • multiplexed 1
    • names 1
    • number of 1
    • overwriting existing 1
    • relocating 1
    • renaming 1
    • requirement of one 1
    • size of 1
    • specifying names before database creation 1
    • troubleshooting 1
    • unavailable during startup 1
  • copying jobs 1
  • core files 1
  • corruption
    • repairing data block 1
  • cost-based optimization
    • distributed databases 1
    • hints 1
    • using for distributed queries 1
  • CREATE_CREDENTIAL procedure 1 , 2
  • CREATE_SIMPLE_PLAN procedure
    • Database Resource Manager 1 , 2
  • CREATE BIGFILE TABLESPACE statement 1
  • CREATE BIGFILE TEMPORARY TABLESPACE statement 1
  • CREATE CLUSTER statement
    • creating clusters 1
    • example 1
    • for hash clusters 1
    • HASH IS clause 1 , 2
    • HASHKEYS clause 1 , 2
  • CREATE CONTROLFILE statement
    • about 1
    • checking for inconsistencies 1
    • NORESETLOGS clause 1
    • Oracle Managed Files, using 1
    • RESETLOGS clause 1
  • CREATE DATABASE LINK statement 1
  • CREATE DATABASE statement
    • CDBs 1
    • clauses 1
    • CONTROLFILE REUSE clause 1
    • DEFAULT TEMPORARY TABLESPACE clause 1
    • ENABLE PLUGGABLE DATABASE clause 1
    • example of database creation 1
    • MAXLOGFILES parameter 1
    • MAXLOGMEMBERS parameter 1
    • password for SYS 1
    • password for SYSTEM 1
    • SEED FILE_NAME_CONVERT clause 1
    • setting time zone 1
    • specifying FORCE LOGGING 1
    • UNDO TABLESPACE clause 1
    • used to create an undo tablespace 1
    • using Oracle Managed Files 1
    • using Oracle Managed Files, examples 1 , 2
  • CREATE INDEX statement
    • NOLOGGING 1
    • ON CLUSTER clause 1
    • with a constraint 1
  • CREATE PFILE FROM MEMORY statement 1
  • CREATE PLUGGABLE DATABASE statement
    • file locations 1
    • logging_clause 1 , 2
    • NO DATA clause 1 , 2
    • PATH_PREFIX clause 1
    • pdb_force_logging_clause 1
    • SERVICE_NAME_CONVERT clause 1
    • SNAPSHOT COPY clause 1
    • SOURCE_FILE_DIRECTORY clause 1
    • SOURCE_FILE_NAME_CONVERT clause 1
    • source file locations 1
    • STANDBYS clause 1
    • STORAGE clause 1
    • USER_TABLESPACES clause 1
  • CREATE SCHEMA statement
    • multiple tables and views 1
  • CREATE SEQUENCE statement
    • CACHE option 1
  • CREATE SYNONYM statement 1
  • CREATE TABLESPACE statement
    • BLOCKSIZE CLAUSE, using 1
    • FORCE LOGGING clause, using 1
    • using Oracle Managed Files 1
    • using Oracle Managed Files, examples 1
  • CREATE TABLE statement
    • CLUSTER clause 1
    • creating temporary table 1
    • example of 1
    • INCLUDING clause 1
    • MONITORING clause 1
    • NOLOGGING clause 1
    • ORGANIZATION EXTERNAL clause 1
    • PCTTHRESHOLD clause 1
  • CREATE TEMPORARY TABLESPACE statement
    • using Oracle Managed Files 1
    • using Oracle managed files, example 1
  • CREATE UNDO TABLESPACE statement
    • using Oracle Managed Files 1
    • using Oracle Managed Files, example 1
    • using to create an undo tablespace 1
  • CREATE VIEW statement
    • about 1
    • OR REPLACE clause 1
    • WITH CHECK OPTION 1 , 2
  • creating
    • an Oracle database 1
    • CDBs 1
    • chains 1
    • control files 1
    • databases 1
    • database services 1
    • event-based job 1
    • event schedule 1
    • indexes
      • after inserting table data 1
      • associated with integrity constraints 1
      • NOLOGGING 1
      • online 1
      • prerequisites 1
      • USING INDEX clause 1
    • job classes 1
    • jobs 1
    • programs 1
    • Scheduler windows 1
    • schedules 1
    • sequences 1
    • window groups 1
  • creating CDBs
    • CREATE DATABASE statement 1
    • Database Configuration Assistant 1
    • ENABLE PLUGGABLE DATABASE clause 1
    • manually from a script 1
    • Oracle Managed Files 1
    • PDB_FILE_NAME_CONVERT initialization parameter 1
    • planning 1
    • SEED FILE_NAME_CONVERT clause 1
  • creating database links
    • connected user 1
    • connected user scenarios 1
    • current user 1
    • current user scenario 1
    • examples 1
    • fixed user 1
    • fixed user scenario 1 , 2
    • obtaining necessary privileges 1
    • private 1
    • public 1
    • service names within link names 1
    • shared 1
    • shared connected user scenario 1
    • specifying types 1
  • creating databases
    • backing up the new database 1
    • default temporary tablespace, specifying 1
    • example 1
    • manually from a script 1
    • overriding default tablespace type 1
    • planning 1
    • preparing to 1
    • prerequisites for 1
    • setting default tablespace type 1
    • specifying bigfile tablespaces 1 , 2
    • UNDO TABLESPACE clause 1
    • upgrading to a new release 1
    • using Oracle Managed Files 1 , 2
    • with DBCA 1
  • creating data files 1
  • creating sequences 1
  • creating synonyms 1
  • creating views 1
  • credentials, Oracle Scheduler
    • about 1
    • granting privileges on 1
  • critical errors
    • diagnosing 1
  • CRSCTL utility
    • Oracle Restart 1
  • current container 1
  • current user database links
    • advantages and disadvantages 1
    • cannot access in shared schema 1
    • definition 1
    • schema independence 1
  • CURRVAL pseudo-column
    • restrictions 1
  • cursors
    • and closing database links 1
  • customize package page, accessing 1
  • customizing an incident package 1 , 2

D

  • data
    • loading using external tables 1
  • database
    • cloning 1 , 2
    • creating 1
    • creating and configuring 1
    • creating with DBCA 1
    • data dictionary views reference 1
    • starting up 1
  • database administrators
    • authentication 1
    • DBA role 1
    • operating system account 1
    • password files for 1
    • responsibilities of 1
    • security and privileges of 1
    • security officer versus 1
    • task definitions 1
    • utilities for 1
  • database clouds 1
  • Database Configuration Assistant
    • CDBs 1
    • shared server configuration 1
  • database destinations, Oracle Scheduler
    • about 1
    • creating 1
  • database jobs, Oracle Scheduler 1
  • database links
    • advantages 1
    • auditing 1
    • authentication 1
    • authentication without passwords 1
    • closing 1 , 2
    • connected user 1 , 2 , 3 , 4
    • connections, determining open 1
    • controlling connections 1
    • creating 1 , 2 , 3 , 4 , 5
    • creating, examples 1
    • creating, scenarios 1
    • creating shared 1
    • current user 1 , 2 , 3
    • data dictionary USER views 1
    • definition 1
    • distributed queries 1
    • distributed transactions 1
    • dropping 1
    • enforcing global naming 1
    • enterprise users and 1
    • fixed user 1 , 2 , 3
    • global 1
    • global names
      • loopback 1
    • global object names 1
    • handling errors 1
    • limiting number of connections 1
    • listing 1 , 2 , 3
    • loopback 1
    • managing 1
    • minimizing network connections 1
    • name resolution 1
    • names for 1
    • private 1
    • public 1
    • referential integrity in 1
    • remote transactions 1 , 2
    • resolution 1
    • restrictions 1
    • roles on remote database 1
    • schema objects and 1
    • service names used within link names 1
    • shared 1 , 2 , 3 , 4 , 5
    • shared SQL 1
    • synonyms for schema objects 1
    • tuning distributed queries 1
    • tuning queries with hints 1
    • tuning using collocated inline views 1
    • types of links 1
    • types of users 1
    • users, specifying 1
    • using cost-based optimization 1
    • viewing 1 , 2
  • database objects
    • obtaining growth trends for 1
  • database program unit, definition 1
  • database resident connection pooling
    • advantages 1
    • configuration parameters 1
    • configuring the connection pool 1
    • data dictionary views reference 1
    • disabling 1
    • enabling 1
    • triggers 1
  • Database Resource Manager
    • active session pool with queuing 1
    • administering system privilege 1
    • and operating system control 1
    • automatic consumer group switching 1
    • CDB resource plans 1
    • CDBs 1
    • CREATE_SIMPLE_PLAN procedure 1 , 2
    • data dictionary views reference 1
    • description 1
    • enabling 1
    • execution time limit 1
    • PDB resource plans 1
    • PDBs 1
    • resource allocation methods 1
    • resource consumer groups 1 , 2 , 3
    • resource plan directives 1 , 2 , 3
    • resource plans 1 , 2 , 3 , 4 , 5 , 7 , 8
    • STATISTICS_LEVEL parameter 1
    • undo pool 1
    • used for quiescing a database 1
    • validating plan schema changes 1
  • databases
    • administering 1
    • administration of distributed 1
    • altering availability 1
    • backing up 1
    • default temporary tablespace, specifying 1
    • dropping 1
    • mounting a database 1
    • mounting to an instance 1
    • opening a closed database 1
    • planning 1
    • planning creation 1
    • quiescing 1
    • read-only, opening 1
    • recovery 1
    • renaming 1 , 2
    • restricting access 1
    • resuming 1
    • shutting down 1
    • specifying control files 1
    • suspending 1
    • undo management 1
    • upgrading 1
  • database services
    • about 1
    • controlling automatic startup of 1
    • creating 1
    • data dictionary views 1
    • managing application workloads with 1
  • Database Smart Flash Cache 1
  • database writer process
    • calculating checksums for data blocks 1
  • database writer process (DBWn) 1
  • data block corruption
    • repairing 1
  • data blocks
    • altering size of 1
    • nonstandard block size 1
    • shared in clusters 1
    • specifying size of 1
    • standard block size 1
    • verifying 1
  • data definition language (DDL)
    • CDBs 1
  • data dictionary
    • conflicts with control files 1
    • purging pending rows from 1 , 2
  • data encryption
    • distributed systems 1
  • data file headers
    • when renaming tablespaces 1
  • data files
    • adding to a tablespace 1
    • bringing online and offline 1
    • checking associated tablespaces 1
    • copying using database 1
    • creating 1
    • creating Oracle Managed Files 1 , 2
    • database administrators access 1
    • data dictionary views reference 1
    • default directory 1
    • definition 1
    • deleting 1
    • dropping 1 , 2
    • dropping Oracle managed 1
    • file numbers 1
    • fully specifying filenames 1
    • guidelines for managing 1
    • headers when renaming tablespaces 1
    • identifying OS filenames 1
    • location 1
    • mapping files to physical devices 1
    • minimum number of 1
    • MISSING 1
    • offline
      • relocating 1
      • renaming 1
    • online
      • relocating 1
      • renaming 1
    • relocating 1
    • renaming 1
    • reusing 1
    • size of 1
    • statements to create 1
    • storing separately from redo log files 1
    • unavailable when database is opened 1
    • verifying data blocks 1
  • data manipulation language
    • statements allowed in distributed transactions 1
  • Data Recovery Advisor, repairing data corruptions with 1
  • Data Repair Advisor 1
  • DB_BLOCK_CHECKING initialization parameter 1 , 2
  • DB_BLOCK_CHECKSUM initialization parameter
    • enabling redo block checking with 1
  • DB_BLOCK_SIZE initialization parameter
    • and nonstandard block sizes 1
    • setting 1
  • DB_CACHE_SIZE initialization parameter
    • specifying multiple block sizes 1
  • DB_CREATE_FILE_DEST initialization parameter
    • setting 1
  • DB_CREATE_ONLINE_LOG_DEST_n initialization parameter
    • setting 1
  • DB_DOMAIN initialization parameter
    • setting for database creation 1
  • DB_FILES initialization parameter
    • determining value for 1
  • DB_NAME initialization parameter
    • setting before database creation 1
  • DB_nK_CACHE_SIZE initialization parameter
    • specifying multiple block sizes 1
  • DB_RECOVERY_FILE_DEST initialization parameter
    • setting 1
  • DB_UNRECOVERABLE_SCN_TRACKING initialization parameter 1
  • DBA
    • See: database administrators
  • DBA_2PC_NEIGHBORS view
    • using to trace session tree 1
  • DBA_2PC_PENDING view
    • using to list in-doubt transactions 1
  • DBA_DB_LINKS view 1
  • DBA_PDB_SAVED_STATES view 1
  • DBA role 1
  • DBCA
    • See: Database Configuration Assistant
  • DBMS_CREDENTIAL package 1
  • DBMS_FILE_TRANSFER package
    • copying data files 1
  • DBMS_JOB
    • about 1
    • moving jobs to Oracle Scheduler 1
    • using with PDB 1
  • DBMS_METADATA package
    • GET_DDL function 1
    • using for object definition 1
  • DBMS_REDEFINITION package
    • performing online redefinition with 1
  • DBMS_REPAIR
    • logical corruptions 1
  • DBMS_REPAIR package
    • examples 1
    • procedures 1
    • using 1 , 2
  • DBMS_RESOURCE_MANAGER_PRIVS package
    • procedures (table of) 1
  • DBMS_RESOURCE_MANAGER package
    • procedures (table of) 1
  • DBMS_RESUMABLE package 1
  • DBMS_SCHEDULER.GET_FILE, retrieving external job stdout with 1
  • DBMS_SERVER_ALERT package
    • setting alert thresholds 1
  • DBMS_SPACE_ADMIN
    • DROP_EMPTY_SEGMENTS procedure 1
    • MATERIALIZE_DEFERRED_SEGMENTS procedure 1
  • DBMS_SPACE package
    • example for unused space 1
    • FREE_BLOCK procedure 1
    • SPACE_USAGE procedure 1
    • UNUSED_SPACE procedure 1
  • DBMS_SQL package
    • CDBs 1
  • DBMS_TRANSACTION package
    • PURGE_LOST_DB_ENTRY procedure 1
  • DBVERIFY utility 1 , 2
  • DDL_LOCK_TIMEOUT initialization parameter 1
  • DDL lock timeout 1
  • DDL log 1
  • DEALLOCATE UNUSED clause 1
  • deallocating unused space
    • DBMS_SPACE package 1
    • DEALLOCATE UNUSED clause 1
  • debug log 1
  • declarative referential integrity constraints 1
  • dedicated server processes
    • trace files for 1
  • DEFAULT_CONSUMER_GROUP for Database Resource Manager 1 , 2
  • default temporary tablespace
    • renaming 1
  • default temporary tablespaces
    • specifying at database creation 1 , 2
    • specifying bigfile temp file 1
    • specifying for root 1
  • deferred segment creation
    • indexes 1
    • in tables 1
  • deferred segments
    • materializing 1
  • defining
    • chain steps 1
  • dependencies
    • between schema objects 1
    • displaying 1
  • DESCRIBE procedure 1
  • destinations, Oracle Scheduler
    • about 1
    • creating 1
  • detached jobs
    • creating 1
  • DIAGNOSTIC_DEST initialization parameter 1 , 2
  • dictionary-managed tablespaces
    • migrating SYSTEM to locally managed 1
  • Digital POLYCENTER Manager on NetView 1
  • directory objects
    • external procedures 1
  • direct-path INSERT
    • benefits 1
    • how it works 1
    • index maintenance 1
    • locking considerations 1
    • logging mode 1
    • parallel INSERT 1
    • parallel load compared with parallel INSERT 1
    • space considerations 1
  • disabling
    • chains 1
    • jobs 1
    • programs 1
    • SQL patch 1
    • window groups 1
    • windows 1
  • disabling recoverer process 1
  • dispatcher process (Dnnn) 1
  • dispatcher processes 1 , 2
  • DISPATCHERS initialization parameter
    • setting initially 1
  • distributed applications
    • distributing data 1
  • distributed databases
    • administration overview 1
    • application development 1 , 2 , 3
    • client/server architectures 1
    • commit point strength 1
    • cost-based optimization 1
    • database clouds 1
    • direct and indirect connections 1
    • distributed processing 1
    • distributed queries 1
    • distributed updates 1
    • forming global database names 1
    • Global Data Services 1
    • globalization support 1
    • global object names 1 , 2
    • location transparency 1 , 2
    • management tools 1
    • managing read consistency 1
    • nodes of 1
    • overview 1
    • remote object security 1
    • remote queries and updates 1
    • replicated databases and 1
    • resumable space allocation 1
    • running in ARCHIVELOG mode 1
    • running in NOARCHIVELOG mode 1
    • scenarios 1
    • schema-dependent global users 1
    • schema-independent global users 1
    • schema object name resolution 1
    • security 1
    • site autonomy of 1
    • SQL transparency 1
    • starting a remote instance 1
    • transaction processing 1
    • transparency 1
  • distributed processing
    • distributed databases 1
  • distributed queries
    • analyzing tables 1
    • application development issues 1
    • cost-based optimization 1
    • optimizing 1
  • distributed systems
    • data encryption 1
  • distributed transactions
    • case study 1
    • commit point site 1
    • commit point strength 1 , 2
    • committing 1
    • database server role 1
    • defined 1
    • DML and DDL 1
    • failure during 1
    • global coordinator 1
    • locked resources 1
    • locks for in-doubt 1
    • lock timeout interval 1
    • manually overriding in-doubt 1
    • naming 1 , 2
    • session trees 1 , 2 , 3 , 4 , 5 , 6
    • setting advice 1
    • transaction control statements 1
    • transaction timeouts 1
    • two-phase commit 1 , 2
    • viewing database links 1
  • distributed updates 1
  • DML
    • See: data manipulation language
  • DML error logging, inserting data with 1
  • DRIVING_SITE hint 1
  • DROP ALL STORAGE clause 1
  • DROP CLUSTER statement
    • CASCADE CONSTRAINTS clause 1
    • dropping cluster 1
    • dropping cluster index 1
    • dropping hash cluster 1
    • INCLUDING TABLES clause 1
  • DROP DATABASE statement 1
  • DROP LOGFILE clause
    • ALTER DATABASE statement 1
  • DROP LOGFILE MEMBER clause
    • ALTER DATABASE statement 1
  • dropping
    • chains 1
    • chain steps 1
    • columns
      • marking unused 1
      • remove unused columns 1
    • columns in compressed tables 1
    • database links 1
    • data files 1
    • data files, Oracle managed 1
    • job classes 1
    • jobs 1
    • programs 1
    • rules from chains 1
    • schedules 1
    • SQL patch 1
    • tables
      • consequences of 1
    • temp files
      • Oracle managed 1
    • window groups 1
    • windows 1
  • dropping multiple jobs 1
  • DROP PLUGGABLE DATABASE statement 1
  • DROP SYNONYM statement 1
  • DROP TABLESPACE statement 1
  • DROP TABLE statement
    • about 1
    • CASCADE CONSTRAINTS clause 1
    • for clustered tables 1
  • DUMP_ORPHAN_KEYS procedure
    • DBMS_REPAIR package 1
    • example 1
    • recovering data 1
  • dumps 1

E

  • ECID 1
  • editions
    • in CONNECT command 1
    • managing 1
  • e-mail notifications, Scheduler 1
  • EMPHASIS resource allocation method 1
  • empty tables
    • dropping segments 1
  • ENABLE_PLUGGABLE_DATABASE initialization parameter 1
  • ENABLE PLUGGABLE DATABASE clause 1
  • enabling
    • chains 1
    • jobs 1
    • programs 1
    • window groups 1
    • windows 1
  • enabling recoverer process
    • distributed transactions 1
  • encryption
    • column 1
    • tablespace 1
  • encryption, transparent data 1
  • enterprise users
    • definition 1
  • environment variables
    • ORACLE_SID 1
  • error logging, DML
    • inserting data with 1
  • errors
    • alert log and 1
    • assigning names with PRAGMA_EXCEPTION_INIT 1
    • critical 1
    • exception handler 1
    • integrity constrain violation 1
    • ORA-00028 1
    • ORA-01090 1
    • ORA-01173 1
    • ORA-01176 1
    • ORA-01177 1
    • ORA-01215 1
    • ORA-01216 1
    • ORA-01591 1
    • ORA-02049 1
    • ORA-02050 1
    • ORA-02051 1
    • ORA-02054 1
    • RAISE_APPLICATION_ERROR() procedure 1
    • remote procedure 1
    • rollback required 1
    • trace files and 1
    • when creating control file 1
    • while starting a database 1
    • while starting an instance 1
  • event-based job
    • altering 1
    • creating 1
    • passing event messages to 1
  • event message
    • passing to event-based job 1
  • events
    • using to start Scheduler jobs 1
  • events (Scheduler)
    • overview 1
  • event schedule
    • altering 1
    • creating 1
  • example
    • setting maximum utilization limit for plans and subplans 1
  • examples
    • managing parallel statement execution using Resource Manager 1
  • exception handler 1
  • exceptions
    • assigning names with PRAGMA_EXCEPTION_INIT 1
    • integrity constraints 1
    • user-defined 1
  • executing
    • remote external jobs 1
  • execution context identifier 1
  • execution plans
    • analyzing for distributed queries 1
  • export operations
    • restricted mode and 1
  • expressions, calendaring 1
  • extents
    • allocating cluster extents 1
    • allocating for tables 1
    • data dictionary views for 1
    • deallocating cluster extents 1
    • displaying free extents 1
  • external destinations, Oracle Scheduler
    • about 1
    • creating 1
  • external jobs
    • retrieving stdout and stderr 1 , 2 , 3
  • external jobs, Oracle Scheduler 1
  • external procedures
    • credentials 1
    • directory objects 1
    • managing processes for 1
  • external tables
    • altering 1
    • creating 1
    • defined 1
    • dropping 1
    • privileges required 1
    • uploading data example 1

F

  • fast recovery area
    • as archive log destination 1
    • initialization parameters to specify 1
    • with Oracle managed files 1
  • fault diagnosability infrastructure 1 , 2
  • file mapping
    • examples 1
    • how it works 1
    • how to use 1
    • overview 1
    • structures 1
    • views 1
  • filenames
    • Oracle Managed Files 1
  • files
    • creating Oracle Managed Files 1 , 2
  • file system
    • used for Oracle managed files 1
  • file watchers
    • about 1
    • changing detection interval 1
    • creating 1
    • managing 1
  • finalizing
    • an incident package, definition 1
  • FINISH_REDEF_TABLE procedure
    • dml_lock_timeout parameter 1
  • FIX_CORRUPT_BLOCKS procedure
    • DBMS_REPAIR 1
    • example 1
    • marking blocks corrupt 1
  • fixed user database links
    • advantages and disadvantages 1
    • creating 1
    • definition 1
  • Flashback Drop
    • about 1
    • purging recycle bin 1
    • querying recycle bin 1
    • recycle bin 1
    • restoring objects 1
  • Flashback Table
    • overview 1
  • flood-controlled incidents
    • defined 1
    • viewing 1
  • FMON background process 1
  • FORCE clause
    • COMMIT statement 1
    • ROLLBACK statement 1
  • force full database caching mode
    • disabling 1
    • enabling 1
    • prerequisites 1
  • FORCE LOGGING
    • precedence of settings 1
  • FORCE LOGGING clause
    • CREATE DATABASE 1
    • CREATE TABLESPACE 1
    • performance considerations 1
  • forcing
    • COMMIT or ROLLBACK 1 , 2
  • forcing a log switch
    • using ARCHIVE_LAG_TARGET 1
    • with the ALTER SYSTEM statement 1
  • forget phase
    • in two-phase commit 1
  • free space
    • listing free extents 1
    • tablespaces and 1
  • full transportable export/import 1
  • function-based indexes 1

G

  • GDS configuration 1
  • generic connectivity
    • definition 1
  • GLOBAL_NAMES initialization parameter
    • database links 1
  • GLOBAL_NAME view
    • using to determine global database name 1
  • global coordinators
    • distributed transactions 1
  • global database consistency
    • distributed databases and 1
  • global database links
    • creating 1
  • global database names
    • changing the domain 1
    • database links
      • loopback 1
    • enforcing for database links 1
    • enforcing global naming 1
    • forming distributed database names 1
    • impact of changing 1
    • querying 1
  • Global Data Services 1
  • globalization support
    • client/server architectures 1
    • distributed databases 1
  • global object names
    • database links 1
    • distributed databases 1
  • global users
    • schema-dependent in distributed systems 1
    • schema-independent in distributed systems 1
  • granting privileges and roles
    • SYSOPER/SYSDBA privileges 1
  • GRANT statement
    • SYSOPER/SYSDBA privileges 1
  • groups, Oracle Scheduler 1
  • growth trends
    • of database objects 1
  • GUID
    • PDBs 1
  • GV$DBLINK view 1

H

  • hash clusters
    • advantages and disadvantages 1
    • altering 1
    • choosing key 1
    • contrasted with index clusters 1
    • controlling space use of 1
    • creating 1
    • data dictionary views reference 1
    • dropping 1
    • estimating storage 1
    • examples 1
    • hash function 1 , 2 , 3 , 4 , 5 , 6
    • HASH IS clause 1 , 2
    • HASHKEYS clause 1 , 2
    • single-table 1
    • sorted 1
  • hash functions
    • for hash cluster 1
  • health checks 1
  • Health Monitor
    • checks
      • generating reports 1
      • viewing reports 1
      • viewing reports using ADRCI 1
  • heterogeneous distributed systems
    • definition 1
  • Heterogeneous Services
    • overview 1
  • hints
    • DRIVING_SITE 1
    • NO_MERGE 1
    • using to tune distributed queries 1
  • HP OpenView 1
  • Hybrid Columnar Compression 1

I

  • IBM NetView/6000 1
  • IM column store
    • See: In-Memory Column Store
  • import operations
    • PDBs 1 , 2
    • restricted mode and 1
  • incident package
    • correlated 1
    • correlated, creating, editing, and uploading 1
    • correlated, deleting 1
    • creating, editing and uploading custom 1
    • customizing 1 , 2
    • defined 1
    • viewing 1
  • incident packages 1
  • incident packaging service 1
  • incidents
    • about 1
    • flood-controlled
      • viewing 1
  • index clusters
    • See: clusters
  • indexes
    • advanced index compression 1
    • altering 1
    • analyzing 1
    • choosing columns to index 1
    • cluster indexes 1 , 2 , 3
    • coalescing 1 , 2
    • column order for performance 1
    • creating
      • prerequisites 1
    • data dictionary views reference 1
    • deferred segment creation 1
    • determining unusable status of 1
    • disabling and dropping constraints cost 1
    • dropping 1 , 2
    • estimating size 1
    • estimating space use 1
    • function-based 1
    • guidelines for managing 1
    • invisible 1 , 3 , 4
    • keeping when disabling constraint 1
    • keeping when dropping constraint 1
    • limiting for a table 1
    • monitoring space use of 1
    • monitoring usage 1
    • multiple on a set of columns 1
    • parallelizing index creation 1
    • rebuilding 1 , 2
    • rebuilt after direct-path INSERT 1
    • renaming 1
    • setting storage parameters for 1
    • shrinking 1
    • space used by 1
    • tablespace for 1
    • temporary segments and 1
    • unusable 1 , 2 , 3
    • validating structure 1
    • when to create 1
  • index-organized tables
    • analyzing 1
    • AS subquery 1
    • converting to heap 1
    • creating 1
    • described 1
    • INCLUDING clause 1
    • maintaining 1
    • ORDER BY clause, using 1
    • parallel creation 1
    • prefix compression 1
    • rebuilding with MOVE clause 1
    • storing nested tables 1
    • storing object types 1
    • threshold value 1
  • in-doubt transactions
    • after a system failure 1
    • automatic resolution 1 , 2
    • deciding how to handle 1
    • deciding whether to perform manual override 1
    • defined 1
    • manually committing 1
    • manually committing, example 1
    • manually overriding 1 , 2
    • manually overriding, scenario 1
    • manually rolling back 1
    • manual resolution 1
    • overview 1
    • pending transactions table 1
    • purging rows from data dictionary 1 , 2
    • recoverer process and 1
    • rolling back 1 , 2 , 3
    • SCNs and 1
    • simulating 1
    • tracing session tree 1
    • viewing database links 1
  • initialization parameter file
    • about 1
    • creating 1
    • creating by copying and pasting from alert log 1
    • creating for database creation 1
    • default locations 1
    • editing before database creation 1
    • individual parameter names 1
    • sample 1
    • search order 1
    • server parameter file 1
  • initialization parameters
    • about 1
    • and database startup 1
    • changing 1
    • changing values 1
    • clearing 1
    • COMMIT_POINT_STRENGTH 1
    • CONTROL_FILES 1 , 3 , 4
    • DB_BLOCK_CHECKING 1
    • DB_BLOCK_CHECKSUM 1 , 2
    • DB_BLOCK_SIZE 1 , 2
    • DB_CACHE_SIZE 1
    • DB_DOMA 1
    • DB_FILES 1
    • DB_NAME 1
    • DB_nK_CACHE_SIZE 1
    • DISPATCHERS 1
    • GLOBAL_NAMES 1
    • LOG_ARCHIVE_DEST 1
    • LOG_ARCHIVE_DEST_n 1 , 2
    • LOG_ARCHIVE_DEST_STATE_n 1
    • LOG_ARCHIVE_MAX_PROCESSES 1
    • LOG_ARCHIVE_MIN_SUCCEED_DEST 1
    • LOG_ARCHIVE_TRACE 1
    • OPEN_LINKS 1
    • PROCESSES 1
    • REMOTE_LOGIN_PASSWORDFILE 1
    • REMOTE_OS_AUTHENT 1
    • resetting 1
    • RESOURCE_MANAGER_PLAN 1
    • server parameter file and 1 , 2
    • setting 1
    • SHARED_SERVERS 1
    • shared server and 1
    • SORT_AREA_SIZE 1
    • SPFILE 1
    • SQL_TRACE 1
    • UNDO_MANAGEMENT 1
    • UNDO_TABLESPACE 1
  • INITIAL parameter
    • cannot alter 1
  • INITRANS parameter
    • altering 1
  • INMEMORY_CLAUSE_DEFAULT parameter 1
  • INMEMORY_FORCE parameter 1
  • INMEMORY_MAX_POPULATE_SERVERS parameter 1
  • INMEMORY_QUERY parameter 1
  • INMEMORY_SIZE parameter 1
  • INMEMORY_TRICKLE_POPULATE_SERVERS_PERCENT parameter 1
  • In-Memory Column Store
    • compression 1
    • enabling for a database 1
    • enabling for materialized views 1
    • enabling for tables 1
    • enabling for tablespaces 1
    • initialization parameters 1
    • Oracle Data Pump 1
    • Oracle Enterprise Manager Cloud Control 1
    • population options 1
  • INSERT statement
    • with DML error logging 1
  • installing
    • patches 1
  • instance caging
    • with maximum utilization limit 1
  • instances
    • aborting 1
    • managing CPU for multiple 1
    • shutting down immediately 1
    • shutting down normally 1
    • transactional shutdown 1
  • integrity constraints
    • cost of disabling 1
    • cost of dropping 1
    • creating indexes associated with 1
    • dropping tablespaces and 1
    • ORA-02055 constraint violation 1
  • INTERNAL username
    • connecting for shutdown 1
  • invisible columns 1
  • invisible indexes
    • creating 1
  • IOT
    • See: index-organized tables
  • IPS 1

J

  • JOB_QUEUE_PROCESSES initialization parameter 1 , 2
  • job classes
    • altering 1
    • creating 1
    • dropping 1
    • managing Scheduler job attributes, resources, and priorities with 1
    • overview 1
    • viewing 1
  • job coordinator 1
  • job credentials 1
  • job destination ID, defined 1 , 2
  • job log, Scheduler
    • viewing 1
  • job recovery (Scheduler) 1
  • jobs
    • altering 1
    • copying 1
    • creating 1
    • creating and managing Scheduler 1
    • creating for chains 1
    • credentials 1
    • database 1
    • detached 1
    • disabling 1
    • dropping 1
    • e-mail notifications 1
    • enabling 1
    • event-based 1
    • external 1
    • lightweight 1
    • lightweight, example of creating 1
    • monitoring 1
    • monitoring with events raised by the Scheduler 1
    • multiple-destination
      • status of child jobs 1
    • overview 1
    • priorities 1
    • remote database 1
    • remote external
      • about 1
    • running 1
    • script jobs 1
    • starting when a file arrives on a system 1
    • starting with events raised by your application 1
    • status 1 , 2
    • stopping 1
    • troubleshooting remote 1
    • viewing information on running 1
  • job scheduling
    • dependency 1
    • event-based 1
    • time-based 1
  • joins
    • statement transparency in distributed databases 1
  • join views
    • definition 1
    • DELETE statements 1
    • key-preserved tables in 1
    • modifying 1
    • rules for modifying 1
    • updating 1

K

  • key-preserved tables
    • in join views 1
    • in outer joins 1
  • keys
    • cluster 1
  • keystore 1 , 2

L

  • large objects 1
  • lightweight jobs
    • example of creating 1
  • links
    • See: database links
  • LIST CHAINED ROWS clause
    • of ANALYZE statement 1
  • listeners
    • removing with srvctl 1
  • listing database links 1 , 2 , 3
  • loading data
    • using external tables 1
  • LOBs 1
  • local coordinators
    • distributed transactions 1
  • locally managed tablespaces
    • automatic segment space management in 1
    • DBMS_SPACE_ADMIN package 1
    • detecting and repairing defects 1
    • migrating SYSTEM from dictionary-managed 1
    • shrinking, temporary 1
    • temp files 1
    • temporary, creating 1
  • local users
    • definition 1
  • location transparency in distributed databases
    • creating using synonyms 1
    • creating using views 1
    • restrictions 1
    • using procedures 1
  • locks
    • in-doubt distributed transactions 1 , 2
    • monitoring 1
  • lock timeout interval
    • distributed transactions 1
  • log
    • window (Scheduler) 1
  • LOG_ARCHIVE_DEST_n initialization parameter
    • REOPEN attribute 1
  • LOG_ARCHIVE_DEST_STATE_n initialization parameter 1
  • LOG_ARCHIVE_DEST initialization parameter
    • specifying destinations using 1
  • LOG_ARCHIVE_DUPLEX_DEST initialization parameter
    • specifying destinations using 1
  • LOG_ARCHIVE_MAX_PROCESSES initialization parameter 1
  • LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter 1
  • LOG_ARCHIVE_TRACE initialization parameter 1
  • logging_clause 1 , 2
  • LOGGING clause
    • CREATE TABLESPACE 1
  • logging mode
    • direct-path INSERT 1
    • NOARCHIVELOG mode and 1
  • logical corruptions from DBMS_REPAIR 1
  • logical standby 1
  • logical volume managers
    • mapping files to physical devices 1 , 2
    • used for Oracle Managed Files 1
  • LOGON trigger
    • setting resumable mode 1
  • logs
    • job 1
    • window (Scheduler) 1 , 2
  • log sequence number
    • control files 1
  • log switches
    • description 1
    • forcing 1
    • log sequence numbers 1
    • multiplexed redo log files and 1
    • privileges 1
    • using ARCHIVE_LAG_TARGET 1
    • waiting for archiving to complete 1
  • log writer process (LGWR)
    • multiplexed redo log files and 1
    • online redo logs available for use 1
    • trace files and 1
    • writing to online redo log files 1
  • LONG columns 1
  • LONG RAW columns 1

M

  • maintenance tasks, automatic
    • See: automatic maintenance tasks
  • maintenance window
    • creating 1
    • definition 1
    • MAINTENANCE_WINDOW_GROUP 1
    • modifying 1
    • predefined 1
    • removing 1
    • Scheduler 1
  • managing
    • sequences 1
    • space threshold alerts for the undo tablespace 1
    • synonyms 1
    • tables 1
    • views 1
  • manual archiving
    • in ARCHIVELOG mode 1
  • manual overrides
    • in-doubt transactions 1
  • materialized views
    • In-Memory Column Store 1
  • materializing deferred segments 1
  • MAXDATAFILES parameter
    • changing 1
  • MAXINSTANCES 1
  • MAXLOGFILES parameter
    • changing 1
    • CREATE DATABASE statement 1
  • MAXLOGHISTORY parameter
    • changing 1
  • MAXLOGMEMBERS parameter
    • changing 1
    • CREATE DATABASE statement 1
  • MAXTRANS parameter
    • altering 1
  • media recovery
    • effects of archiving on 1
  • memory
    • automatic shared memory management 1
    • Database Smart Flash Cache 1
    • managing 1
    • manual memory management 1
    • manual shared memory management 1
  • migrated rows
    • eliminating from table, procedure 1
  • MINEXTENTS parameter
    • cannot alter 1
  • mirrored files
    • control files 1 , 2
    • online redo log 1
    • online redo log location 1
    • online redo log size 1
  • MISSING data files 1
  • monitoring
    • performance 1
    • running chains 1
  • MONITORING clause
    • CREATE TABLE 1
  • MONITORING USAGE clause
    • of ALTER INDEX statement 1
  • mounting a database 1
  • moving control files 1
  • multiple-destination jobs, Oracle Scheduler
    • status of child jobs 1
  • multiple instances, managing CPU for 1
  • multiple jobs
    • dropping 1
  • multiple temporary tablespaces 1 , 2
  • multiplexed control files
    • importance of 1
  • multiplexing
    • archived redo log files 1
    • control files 1
    • redo log file groups 1
    • redo log files 1
  • multitenant architecture
    • purpose of 1
  • multitenant container databases
    • See: CDBs
  • multitenant environment 1

N

  • named user limits
    • setting initially 1
  • name resolution in distributed databases
    • database links 1
    • impact of global name changes 1
    • procedures 1
    • schema objects 1 , 2
    • synonyms 1
    • views 1
    • when global database name is complete 1
    • when global database name is partial 1
    • when no global database name is specified 1
  • networks
    • connections, minimizing 1
    • distributed databases use of 1
  • NEXTVAL pseudo-column
    • restrictions 1
  • NO_DATA_FOUND keyword 1
  • NO_MERGE hint 1
  • NOARCHIVELOG mode
    • archiving 1
    • definition 1
    • dropping data files 1
    • LOGGING mode and 1
    • media failure 1
    • no hot backups 1
    • running in 1
    • switching to 1
    • taking data files offline in 1
  • NO DATA clause 1 , 2
  • NOLOGGING clause
    • CREATE TABLESPACE 1
  • NOLOGGING mode
    • direct-path INSERT 1
  • noncdb_to_pdb.sql script 1 , 2
  • non-CDBs
    • cloning as PDBs 1
    • moving to PDBs 1
  • normal transmission mode
    • definition 1
  • Novell NetWare Management System 1

O

  • object privileges
    • for external tables 1
  • objects
    • See: schema objects
  • offline tablespaces
    • priorities 1
    • taking offline 1
  • online redefinition of tables
    • abort and cleanup 1
    • examples 1
    • features of 1
    • intermediate synchronization 1
    • redefining a single partition
      • rules for 1
    • redefining partitions 1
    • restrictions 1
    • Virtual Private Database policies 1
    • with DBMS_REDEFINITION 1
  • online redo log files
    • See: online redo logs
  • online redo logs
    • creating groups 1
    • creating members 1
    • data dictionary views reference 1
    • dropping groups 1
    • dropping members 1
    • forcing a log switch 1
    • guidelines for configuring 1
    • INVALID members 1
    • location of 1
    • managing 1
    • moving files 1
    • number of files in the 1
    • optimum configuration for the 1
    • renaming files 1
    • renaming members 1
    • specifying ARCHIVE_LAG_TARGET 1
    • STALE members 1
  • online segment shrink 1
  • OPEN_LINKS initialization parameter 1
  • opening windows 1
  • open modes
    • PDBs 1
  • operating system authentication 1 , 2
  • operating systems
    • database administrators requirements for 1
    • renaming and relocating files 1
  • OPTIMIZER_INMEMORY_AWARE parameter 1
  • ORA-01013 error message 1
  • ORA-02055 error
    • integrity constraint violation 1
  • ORA-02067 error
    • rollback required 1
  • ORA-12838 error, direct path insert 1
  • ORACLE_SID environment variable 1
  • Oracle Call Interface
    • See: OCI
  • Oracle Database
    • release numbers 1
  • Oracle Database users
    • types of 1
  • Oracle Database Vault
    • CDBs 1
  • Oracle Data Guard
    • CDBs 1
    • support by the Scheduler 1 , 2
  • Oracle Data Pump
    • In-Memory Column Store 1
  • Oracle Enterprise Manager Cloud Control
    • In-Memory Column Store 1
  • Oracle Enterprise Manager Database Express
    • CDBs 1
  • Oracle home
    • cloning 1
  • Oracle managed files
    • naming 1
    • scenarios for using 1
  • Oracle Managed Files
    • adding to an existing database 1
    • behavior 1
    • benefits 1
    • CREATE DATABASE statement 1
    • creating 1
    • creating control files 1
    • creating data files 1
    • creating online redo log files 1
    • creating temp files 1
    • described 1
    • dropping data file 1
    • dropping online redo log files 1
    • dropping temp file 1
    • initialization parameters 1
    • introduction 1
    • renaming 1
  • Oracle Managed Files feature
    • See: Oracle managed files
  • Oracle Multitenant option 1
  • Oracle Restart
    • about 1
    • configuration
      • adding components to 1
      • modifying 1
      • removing components from 1
      • viewing for a component 1
    • configuring 1
    • CRSCTL utility 1
    • disabling and enabling management for a component 1
    • environment variables in 1
    • patches
      • installing 1
    • registering a component with 1
    • starting 1
    • starting and stopping components managed by
      • Oracle home 1
    • status of components 1
    • stopping 1
  • Oracle Scheduler
    • creating credentials 1
  • Oracle Scheduler agent
    • on Windows 1
    • OracleSchedulerExecutionAgent 1
    • tasks 1
    • Windows Service 1
  • Oracle Scheduler Agent 1
  • Oracle Scheduler agents
    • registering with databases 1
  • OracleSchedulerExecutionAgent 1
  • Oracle Universal Installer 1 , 2
  • ORADIM
    • creating an instance 1
    • enabling automatic instance startup 1
  • ORAPWD utility 1
  • ORGANIZATION EXTERNAL clause
    • of CREATE TABLE 1
  • orphan key table
    • example of building 1
  • OSBACKUPDBA group 1
  • OSDBA group 1
  • OSDGDBA group 1
  • OSKMDBA group 1
  • OSOPER group 1
  • OTHER_GROUPS
    • for Database Resource Manager 1
  • OTHER_GROUPS for Database Resource Manager 1 , 2 , 3
  • outer joins
    • key-preserved tables in 1
  • overlapping windows 1

P

  • package
    • See: incident package
  • packages
    • DBMS_FILE_TRANSFER 1
    • DBMS_METADATA 1
    • DBMS_REPAIR 1
    • DBMS_RESOURCE_MANAGER 1 , 2 , 4
    • DBMS_RESOURCE_MANAGER_PRIVS 1
    • DBMS_RESUMABLE 1
    • DBMS_SPACE 1 , 2
    • DBMS_STORAGE_MAP 1
  • packaging and uploading problems 1
  • parallel execution
    • managing 1
    • parallel hints 1
    • parallelizing index creation 1
    • resumable space allocation 1
  • parallel hints 1
  • parallelizing table creation 1 , 2
  • parallel statement execution
    • directive attributes for managing 1
    • managing using Resource Manager 1
  • parameter files
    • See: initialization parameter file
  • partitioned tables
    • moving a partition online 1
    • redefining partitions online
      • rules for 1
  • password
    • setting for SYSTEM account in CREATE DATABASE statement 1
    • setting SYS in CREATE DATABASE statement 1
  • password file
    • adding users 1
    • creating 1
    • ORAPWD utility 1
    • removing 1
    • setting REMOTE_LOGIN_PASSWORD 1
    • synchronizing administrator passwords with the data dictionary 1
    • viewing members 1
  • password file authentication 1 , 2
  • passwords
    • case sensitivity of 1 , 2 , 3
    • password file 1
    • setting REMOTE_LOGIN_PASSWORD parameter 1
  • patches
    • installing
      • Oracle Restart 1
  • PATH_PREFIX clause 1
  • pausing chains and chain steps 1
  • PCTINCREASE parameter 1
  • PDB_FILE_NAME_CONVERT initialization parameter 1
  • pdb_force_logging_clause 1
  • PDB_PLUG_IN_VIOLATIONS view 1
  • pdb_save_or_discard_state clause 1
  • PDB resource plans 1
  • PDBs
    • administering 1
    • ALTER SYSTEM statement 1
    • CDB resource plans
      • creating 1
      • directives 1
      • disabling 1
      • enabling 1
      • managing 1
      • shares 1
      • utilization limits 1
      • viewing information about 1
    • cloning 1
    • compatibility violations 1
    • connecting to
      • ALTER SESSION statement 1
      • CONNECT command 1
    • creating using the seed 1
    • current container 1
    • Database Resource Manager 1
    • DBMS_SQL package 1
    • definition 1
    • dropping 1
    • EM Express 1
    • executing PL/SQL code 1
    • GUID 1
    • import operations 1 , 2
    • modifying 1
    • moving non-CDBs into 1 , 2
    • open mode
      • preserving on restart 1
    • PDB resource plans
      • creating 1
      • disabling 1
      • modifying 1
    • PDBs resource plans
      • enabling 1
    • plugging in
      • CREATE PLUGGABLE DATABASE statement 1
      • methods for 1
      • preparing for 1
    • prerequisites for 1
    • purpose of 1
    • renaming 1
    • services 1
    • SHUTDOWN command 1 , 2
    • shutting down 1
    • STARTUP command 1 , 2 , 3
    • tools for 1
    • unplugging 1
    • views 1
  • pending area for Database Resource Manager plans
    • validating plan schema changes 1
  • pending transaction tables 1
  • performance
    • index column order 1
    • location of data files and 1
    • monitoring 1
  • PL/SQL
    • replaced views and program units 1
  • plan schemas for Database Resource Manager
    • validating plan changes 1
  • plans for Database Resource Manager
    • examples 1
  • pluggable databases
    • See: PDBs
  • PRAGMA_EXCEPTION_INIT procedure
    • assigning exception names 1
  • predefined user accounts 1
  • prefix compression 1 , 2
  • prepare/commit phases
    • effects of failure 1
    • failures during 1
    • locked resources 1
    • pending transaction table 1
  • prepared response
    • two-phase commit 1
  • prepare phase
    • abort response 1
    • in two-phase commit 1
    • prepared response 1
    • read-only response 1
    • recognizing read-only nodes 1
    • steps 1
  • prerequisites
    • for creating a database 1
  • PRIMARY KEY constraints
    • associated indexes 1
    • dropping associated indexes 1
    • enabling on creation 1
    • foreign key references when dropped 1
    • indexes associated with 1
  • priorities
    • job 1
  • private database links 1
  • private synonyms 1
  • privileges
    • adding redo log groups 1
    • altering index 1
    • altering tables 1
    • closing a database link 1
    • creating database links 1
    • creating tables 1
    • creating tablespaces 1
    • database administrator 1
    • dropping indexes 1
    • dropping online redo log members 1
    • dropping redo log groups 1
    • drop table 1
    • enabling and disabling triggers 1
    • forcing a log switch 1
    • for external tables 1
    • managing with procedures 1
    • managing with synonyms 1
    • managing with views 1
    • manually archiving 1
    • renaming objects 1
    • renaming redo log members 1
    • RESTRICTED SESSION system privilege 1
    • Scheduler 1
    • sequences 1 , 3
    • setting chain (Scheduler) 1
    • synonyms 1 , 2
    • taking tablespaces offline 1
    • truncating 1
    • using a view 1
    • using sequences 1
    • views 1 , 2 , 3
  • problem activity log
    • adding comments to 1
  • problems
    • about 1
    • adding comments to activity log 1
  • problems (critical errors)
    • packaging and uploading 1
  • procedures
    • external 1
    • location transparency in distributed databases 1
    • name resolution in distributed databases 1
    • remote calls 1
  • processes
    • See: server processes
  • PROCESSES initialization parameter
    • setting before database creation 1
  • process monitor (PMON) 1
  • PRODUCT_COMPONENT_VERSION view 1
  • programs
    • altering 1
    • creating 1
    • creating and managing, to define Scheduler jobs 1
    • disabling 1
    • dropping 1
    • enabling 1
    • overview 1
  • public database links
    • connected user 1
    • fixed user 1
  • public fixed user database links 1
  • public synonyms 1
  • PURGE_LOST_DB_ENTRY procedure
    • DBMS_TRANSACTION package 1

Q

  • queries
    • distributed 1
    • distributed application development issues 1
    • location transparency and 1
    • remote 1
  • question mark 1
  • quiescing a database 1
  • quotas
    • tablespace 1

R

  • RAISE_APPLICATION_ERROR() procedure 1
  • read consistency
    • managing in distributed databases 1
  • read-only database
    • opening 1
  • read-only databases
    • limitations 1
  • read-only response
    • two-phase commit 1
  • read-only tables 1
  • read-only tablespaces
    • data file headers when rename 1
    • delaying opening of data files 1
    • making read-only 1
    • making writable 1
    • WORM devices 1
  • Real Application Clusters
    • allocating extents for cluster 1
    • sequence numbers and 1
    • threads of online redo log 1
  • rebuilding indexes
    • costs 1
    • online 1
  • reclaiming unused space 1
  • RECOVER clause
    • STARTUP command 1
  • recoverer process
    • disabling 1
    • distributed transaction recovery 1
    • enabling 1
    • pending transaction table 1
  • recovering
    • Scheduler jobs 1
  • recovery
    • creating new control files 1
  • Recovery Manager
    • starting a database 1
    • starting an instance 1
  • recycle bin
    • about 1
    • purging 1
    • renamed objects 1
    • restoring objects from 1
    • viewing 1
  • REDEF_TABLE procedure
    • example 1
  • redefining tables online
    • See online redefinition of tables 1
  • redo log files
    • active (current) 1
    • archiving 1
    • available for use 1
    • block size, setting 1
    • circular use of 1
    • clearing 1
    • contents of 1
    • creating as Oracle Managed Files 1
    • creating as Oracle Managed Files, example 1
    • creating groups 1
    • creating members 1 , 2
    • distributed transaction information in 1
    • dropping groups 1
    • dropping members 1
    • group members 1
    • groups, defined 1
    • how many in redo log 1
    • inactive 1
    • instance recovery use of 1
    • legal and illegal configurations 1
    • LGWR and the 1
    • log switches 1
    • maximum number of members 1
    • members 1
    • mirrored, log switches and 1
    • multiplexed 1 , 3
    • online, defined 1
    • planning the 1
    • redo entries 1
    • requirements 1
    • specifying at database creation 1
    • storing separately from data files 1
    • threads 1
    • unavailable when database is opened 1
    • verifying blocks 1
  • redo logs
    • See: online redo logredo log files
  • redo records
    • LOGGING and NOLOGGING 1
  • referential integrity
    • distributed database application development 1
  • release number format 1
  • releases
    • checking the Oracle Database release number 1
  • relocating control files 1
  • REMOTE_LOGIN_PASSWORDFILE initialization parameter 1
  • REMOTE_OS_AUTHENT initialization parameter
    • connected user database links 1
  • remote data
    • querying 1
    • updating 1
  • remote database jobs
    • Scheduler agent setup 1
  • remote external jobs
    • about 1
    • executing 1
    • Scheduler agent setup 1
  • remote procedure calls
    • distributed databases and 1
  • remote queries
    • distributed databases and 1
  • remote transactions
    • defined 1
  • RENAME statement 1
  • renaming control files 1
  • renaming files
    • Oracle Managed Files 1
  • renaming indexes 1
  • REOPEN attribute
    • LOG_ARCHIVE_DEST_n initialization parameter 1
  • repairing data block corruption
    • DBMS_REPAIR 1
  • repair table
    • example of building 1
  • repeat interval, schedule 1
  • RESOURCE_MANAGER_PLAN initialization parameter 1
  • resource allocation methods
    • ACTIVE_SESS_POOL_MTH 1
    • active session pool 1
    • CPU 1
    • CPU resource 1
    • EMPHASIS 1
    • limit on degree of parallelism 1
    • MAX_UTILIZATION_METHOD 1
    • PARALLEL_DEGREE_LIMIT_MTH 1
    • PARALLEL_DEGREE_LIMIT_P1 1
    • PARALLEL_QUEUE_TIMEOUT 1
    • PARALLEL_STMT_CRITICAL 1
    • QUEUEING_MTH 1
    • queuing resource allocation method 1
  • resource consumer groups
    • changing 1
    • creating 1
    • DEFAULT_CONSUMER_GROUP 1 , 2
    • deleting 1
    • granting the switch privilege 1
    • managing 1 , 2
    • OTHER_GROUPS 1 , 2 , 3 , 4
    • parameters 1
    • revoking the switch privilege 1
    • setting initial 1
    • switching a session 1
    • switching sessions for a user 1
    • SYS_GROUP 1
    • updating 1
  • Resource Manager
    • AUTO_TASK_CONSUMER_GROUP consumer group 1
    • managing parallel statement execution 1
  • resource plan directives
    • deleting 1
    • for managing parallel statement execution 1
    • specifying 1
    • updating 1
  • resource plans
    • CDB 1
    • creating 1
    • DEFAULT_MAINTENANCE_PLAN 1
    • DELETE_PLAN_CASCADE 1
    • deleting 1
    • examples 1
    • parameters 1
    • PDB 1
    • plan schemas 1 , 2 , 3
    • SYSTEM_PLAN 1
    • top plan 1 , 2
    • updating 1
    • validating 1
  • RESTRICTED SESSION system privilege
    • restricted mode and 1
  • RESUMABLE_TIMEOUT initialization parameter
    • setting 1
  • resumable space allocation
    • correctable errors 1
    • detecting suspended statements 1
    • disabling 1
    • distributed databases 1
    • enabling 1
    • example 1
    • how resumable statements work 1
    • naming statements 1
    • parallel execution and 1
    • resumable operations 1
    • setting as default for session 1
    • timeout interval 1 , 2
  • retention guarantee (for undo) 1
  • reversing table changes 1
  • RMAN
    • See: Recovery Manager
  • roles
    • DBA role 1
    • obtained through database links 1
  • rollbacks
    • ORA-02 1
  • ROLLBACK statement
    • FORCE clause 1 , 2 , 3
    • forcing 1
  • rolling upgrade 1
  • root container
    • definition 1
    • modifying 1
  • rows
    • listing chained or migrated 1
  • rules
    • adding to a chain 1
    • dropping from chains 1
  • running
    • chains 1
    • jobs 1
    • SQL Repair Advisor 1

S

  • Sample Schemas
    • description 1
  • savepoints
    • in-doubt transactions 1 , 2
  • schagent utility 1
  • Scheduler
    • administering 1
    • architecture 1
    • CDB 1
    • closing a PDB 1
    • configuring 1
    • credentials for jobs 1
    • data dictionary views reference 1
    • e-mail notifications 1
    • examples of using 1
    • import and export 1
    • invocations to CDB 1
    • maintenance window 1
    • monitoring and managing 1
    • monitoring jobs 1
    • objects 1
    • overview 1
    • security 1
    • support for Oracle Data Guard 1 , 2
    • troubleshooting
      • job does not run 1
    • using in RAC 1
    • using job coordinator in CDB 1
    • using slave processes in CDB 1
    • Views, new and changed 1
  • SCHEDULER_BATCH_ERRORS view 1
  • Scheduler agent
    • configuration 1
    • installation 1
    • setup 1
  • Scheduler chain condition syntax 1
  • Scheduler job credentials
    • specifying 1
  • Scheduler objects, naming 1
  • Scheduler privileges reference 1
  • schedules
    • altering 1
    • creating 1
    • creating and managing, to define Scheduler jobs 1
    • dropping 1
    • overview 1
  • schema objects
    • analyzing 1
    • creating multiple objects 1
    • data dictionary views reference 1
    • defining using DBMS_METADATA package 1
    • dependencies between 1
    • distributed database naming conventions for 1
    • global names 1
    • listing by type 1
    • name resolution in distributed databases 1 , 2
    • name resolution in SQL statements 1
    • privileges to rename 1
    • referencing with synonyms 1
    • renaming 1
    • validating structure 1
    • viewing information 1 , 2
  • schema objects space usage
    • data dictionary views reference 1
  • SCN
    • See: system change number
  • SCOPE clause 1
  • script jobs 1
  • scripts, authenticating users in 1
  • security
    • accessing a database 1
    • administrator of 1
    • centralized user management in distributed databases 1
    • database security 1
    • distributed databases 1
    • establishing policies 1
    • privileges 1
    • remote objects 1
    • Scheduler 1
    • using synonyms 1
  • SEED FILE_NAME_CONVERT clause 1
  • seed PDB 1
  • SEGMENT_FIX_STATUS procedure
    • DBMS_REPAIR 1
  • Segment Advisor
    • configuring Scheduler job 1
    • invoking with Oracle Enterprise Manager Cloud Control 1
    • invoking with PL/SQL 1
    • running manually 1
    • using 1
    • viewing results 1
    • views 1
  • segments
    • available space 1
    • data dictionary views for 1
    • deallocating unused space 1
    • displaying information on 1
    • dropping for empty tables 1
    • shrinking 1
  • SELECT statement
    • FOR UPDATE clause and location transparency 1
  • SEQUENCE_CACHE_ENTRIES parameter 1
  • sequences
    • accessing 1
    • altering 1
    • caching sequence numbers 1
    • creating 1 , 2
    • CURRVAL 1
    • data dictionary views reference 1
    • dropping 1
    • managing 1
    • NEXTVAL 1
    • Oracle Real Applications Clusters and 1
  • server-generated alerts 1
  • SERVER parameter
    • net service name 1
  • server parameter file
    • creating 1
    • defined 1
    • exporting 1
    • migrating to 1
    • recovering 1
    • RMAN backup 1
    • setting initialization parameter values 1
    • SPFILE initialization parameter 1
    • viewing parameter settings 1
  • server processes
    • archiver (ARCn) 1
    • background 1
    • checkpoint (CKPT) 1
    • database writer (DBWn) 1
    • dedicated 1
    • dispatcher (Dnnn) 1
    • dispatchers 1
    • log writer (LGWR) 1
    • monitoring locks 1
    • process monitor (PMON) 1
    • recoverer (RECO) 1
    • shared server 1
    • system monitor (SMON) 1
    • trace files for 1
  • servers
    • role in two-phase commit 1
  • SERVICE_NAME_CONVERT clause 1
  • service names
    • database links and 1
  • services
    • controlling automatic startup of 1
    • creating with SRVCTL and Oracle Restart 1
    • PDBs 1
    • role-based 1
  • sessions
    • active 1
    • inactive 1
    • setting advice for transactions 1
    • terminating 1
  • session trees for distributed transactions
    • clients 1
    • commit point site 1 , 2
    • database servers 1
    • definition 1
    • global coordinators 1
    • local coordinators 1
    • tracing transactions 1
  • SET TIME_ZONE clause
    • ALTER SESSION 1
    • CREATE DATABASE 1
  • SGA
    • See: system global area
  • shared database links
    • configuring 1
    • creating 1
    • dedicated servers, creating links to 1
    • determining whether to use 1
    • example 1
    • shared servers, creating links to 1
  • shared server
    • configuring dispatchers 1
    • data dictionary views reference 1
    • disabling 1 , 2
    • initialization parameters 1
    • interpreting trace output 1
    • setting minimum number of servers 1
    • trace files for processes 1
  • shared SQL
    • for remote and distributed statements 1
  • shrinking segments online 1
  • shutdown
    • default mode 1
  • SHUTDOWN command
    • closing a PDB 1
    • IMMEDIATE clause 1
    • interrupting 1
    • NORMAL clause 1
    • PDBs 1
  • shutting down an instance
    • CDBs 1
  • Simple Network Management Protocol (SNMP) support
    • database management 1
  • single-file tablespaces
    • description 1
  • single-instance
    • defined 1
  • single-table hash clusters 1
  • site autonomy
    • distributed databases 1
  • SKIP_CORRUPT_BLOCKS procedure
    • DBMS_REPAIR 1
    • example 1
  • skipping chain steps 1
  • SNAPSHOT COPY clause 1
  • SORT_AREA_SIZE initialization parameter
    • index creation and 1
  • SOURCE_FILE_DIRECTORY clause 1
  • SOURCE_FILE_NAME_CONVERT clause 1
  • space
    • deallocating unused 1
    • reclaiming unused 1
  • space allocation
    • resumable 1
  • space management
    • data types, space requirements 1
    • deallocating unused space 1
    • Segment Advisor 1
    • shrink segment 1
  • space usage alerts for tablespaces 1
  • SPFILE initialization parameter 1
  • SQL
    • submitting 1
  • SQL_TRACE initialization parameter
    • trace files and 1
  • SQL*Loader
    • about 1 , 2
  • SQL*Plus
    • about 1
    • connecting with 1
    • starting 1
    • starting a database 1
    • starting an instance 1
  • SQL failure
    • repairing with SQL Repair Advisor 1
  • SQL patch
    • disabling 1
    • removing 1
    • viewing 1
  • SQL Repair Advisor
    • about 1
    • repairing SQL failure with 1
    • running 1
  • SQL scripts
    • CDBs 1
  • SQL statements
    • distributed databases and 1
  • SQL test case builder 1
  • SRVCTL
    • add asm command 1
    • add command, usage description 1
    • add database command 1
    • adding a disk group with 1
    • add listener command 1
    • add ons command 1
    • case sensitivity 1 , 2
    • case sensitivity of commands 1 , 2
    • command reference 1
    • commands
      • downgrade database 1
      • upgrade database 1 , 2
    • commands, case sensitivity 1 , 2
    • component names 1
    • config asm command 1
    • config command, usage description 1
    • config database command 1
    • config listener command 1
    • config ons command 1
    • config service command 1
    • creating and deleting databases services with 1
    • disable asm command 1
    • disable command, usage description 1
    • disable database command 1
    • disable diskgroup command 1
    • disable listener command 1
    • disable ons command 1
    • disable service command 1
    • enable asm command 1
    • enable command, usage description 1
    • enable database command 1
    • enable diskgroup command 1
    • enable listener command 1
    • enable ons command 1
    • enable service command 1
    • getenv asm command 1
    • getenv command, usage description 1
    • getenv database command 1
    • getenv listener command 1
    • help for 1
    • modify asm command 1
    • modify command, usage description 1
    • modify database command 1
    • modify listener command 1
    • modify ons command 1
    • modify service command 1
    • preparing to run 1
    • reference 1
    • remove asm command 1
    • remove command, usage description 1
    • remove database command 1
    • remove diskgroup command 1
    • remove listener command 1
    • remove ons command 1
    • remove service command 1
    • setenv asm command 1
    • setenv command, usage description 1
    • setenv database command 1
    • setenv listener command 1
    • start asm command 1
    • start command, usage description 1
    • start database command 1
    • start diskgroup command 1
    • start home command 1
    • start listener command 1
    • start ons command 1
    • start service command 1
    • status asm command 1
    • status command, usage description 1
    • status database command 1
    • status diskgroup command 1
    • status home command 1
    • status listener command 1
    • status ons command 1
    • status service command 1
    • stop asm command 1
    • stop command, usage description 1
    • stop database command 1
    • stop diskgroup command 1
    • stop home command 1
    • stop listener command 1
    • stop ons command 1
    • stop service command 1
    • unsetenv asm command 1
    • unsetenv command, usage description 1
    • unsetenv database command 1
    • unsetenv listener command 1
  • SRVCTL stop option
    • default 1
  • STALE status
    • of redo log members 1
  • stalled chain (Scheduler) 1
  • standby database
    • CDBs 1
  • STANDBYS clause 1
  • standby transmission mode
    • definition of 1
  • starting a database
    • forcing 1
    • Oracle Enterprise Manager Cloud Control 1
    • recovery and 1
    • Recovery Manager 1
    • restricted mode 1
    • SQL*Plus 1
    • when control files unavailable 1
    • when redo logs unavailable 1
  • starting an instance
    • automatically at system startup 1
    • database closed and mounted 1
    • forcing 1
    • mounting and opening the database 1
    • normally 1
    • Oracle Enterprise Manager Cloud Control 1
    • recovery and 1
    • Recovery Manager 1
    • remote instance startup 1
    • restricted mode 1
    • SQL*Plus 1
    • when control files unavailable 1
    • when redo logs unavailable 1
    • without mounting a database 1
  • startup
    • of database services, controlling 1
  • STARTUP command
    • NOMOUNT clause 1
    • PDBs 1 , 2
    • RECOVER clause 1
    • starting a database 1 , 2
    • starting a PDB 1
  • statement transparency in distributed database
    • managing 1
  • statistics
    • automatically collecting for tables 1
  • STATISTICS_LEVEL initialization parameter
    • Database Resource Manager 1
  • stderr
    • for local external jobs
      • retrieving 1 , 2
  • stdout
    • for local external jobs
      • retrieving 1 , 2 , 3
  • steps, chain
    • dropping 1
  • stopping
    • chains 1
    • chain steps 1
    • jobs 1
  • STORAGE clause 1
  • storage parameters
    • INITIAL 1
    • INITRANS, altering 1
    • MAXTRANS, altering 1
    • MINEXTENTS 1
    • PCTINCREASE 1
  • storage subsystems
    • mapping files to physical devices 1 , 2
  • stored procedures
    • managing privileges 1
    • remote object security 1
  • submitting SQL and commands to the database 1
  • subqueries
    • in remote updates 1
    • statement transparency in distributed databases 1
  • SunSoft SunNet Manager 1
  • Support Workbench
    • for Oracle ASM instance 1
    • viewing problems with 1
  • SWITCH LOGFILE clause
    • ALTER SYSTEM statement 1
  • synonyms
    • creating 1 , 2
    • data dictionary views reference 1
    • definition and creation 1
    • displaying dependencies of 1
    • dropping 1
    • examples 1
    • location transparency in distributed databases 1
    • managing 1 , 2
    • managing privileges in remote database 1
    • name resolution in distributed databases 1
    • private 1
    • public 1
    • remote object security 1
  • SYS_GROUP for Database Resource Manager 1
  • SYS account
    • objects owned 1
    • specifying password for CREATE DATABASE statement 1
  • SYSAUX tablespace
    • about 1
    • cannot rename 1
    • creating at database creation 1
    • DATAFILE clause 1
    • monitoring occupants 1
    • moving occupants 1
  • SYSBACKUP account
    • connecting as 1
  • SYSDBA account
    • connecting as 1
  • SYSDBA administrative privilege
    • adding users to the password file 1
    • determining who has privileges 1
    • granting and revoking 1
  • SYSDG account
    • connecting as 1
  • SYSKM account
    • connecting as 1
  • SYSOPER account
    • connecting as 1
  • SYSOPER administrative privilege
    • adding users to the password file 1
    • determining who has privileges 1
    • granting and revoking 1
  • SYSTEM_PLAN for Database Resource Manager 1
  • SYSTEM account
    • objects owned 1
    • specifying password for CREATE DATABASE 1
  • system change numbers
    • coordination in a distributed database system 1
    • in-doubt transactions 1
    • using V$DATAFILE to view information about 1
    • when assigned 1
  • system global area
    • holds sequence number cache 1
  • system monitor process (SMON) 1
  • system privileges
    • ADMINISTER_RESOURCE_MANAGER 1
    • for external tables 1
  • SYSTEM tablespace
    • cannot rename 1
    • creating locally managed 1
    • restrictions on taking offline 1
    • when created 1

T

  • tables
    • about 1
    • adding columns 1
    • allocating extents 1
    • altering 1
    • altering physical attributes 1
    • analyzing 1
    • attribute-clustered 1
    • compressed 1
    • creating 1
    • data dictionary views reference 1
    • deferred segment creation 1
    • designing before creating 1
    • dropping 1
    • dropping columns 1
    • estimating size 1
    • estimating space use 1
    • external 1
    • Flashback Drop 1
    • Flashback Table 1
    • guidelines for managing 1
    • hash clustered
      • See hash clusters 1
    • increasing column length 1
    • index-organized 1
    • In-Memory Column Store 1
    • invisible columns 1
    • key-preserved 1
    • limiting indexes on 1
    • managing 1
    • modifying column definition 1
    • moving 1
    • parallelizing creation 1 , 2
    • partitions
      • moving online 1
    • read-only 1
    • redefining online 1
    • renaming columns 1
    • researching and reversing erroneous changes to 1
    • restrictions when creating 1
    • setting storage parameters 1
    • shrinking 1
    • specifying location 1
    • statistics collection, automatic 1
    • temporary 1
    • truncating 1
    • unrecoverable (NOLOGGING) 1
    • validating structure 1
    • zone maps 1
  • table size
    • estimating 1
  • tablespaces
    • adding data files 1
    • assigning user quotas 1
    • autoextending 1
    • automatic segment space management 1
    • bigfile 1 , 2
    • checking default storage parameters 1
    • compressed 1
    • containing XMLTypes 1
    • creating undo tablespace at database creation 1 , 2
    • data dictionary views reference 1
    • DBMS_SPACE_ADMIN package 1
    • default temporary tablespace, creating 1 , 2
    • detecting and repairing defects 1
    • diagnosing and repairing problems in locally managed 1
    • dictionary managed 1
    • dropping 1
    • encrypted
      • creating 1
    • guidelines for managing 1
    • increasing size 1
    • In-Memory Column Store 1
    • listing files of 1
    • listing free space in 1
    • locally managed 1
    • locally managed temporary 1
    • location 1
    • migrating SYSTEM to locally managed 1
    • on a WORM device 1
    • Oracle Managed Files, managing 1 , 2
    • overriding default type 1
    • quotas, assigning 1
    • read-only 1
    • renaming 1 , 2
    • setting default type 1
    • single-file 1 , 2 , 3 , 4
    • space usage alerts 1
    • specifying nonstandard block sizes 1
    • SYSAUX 1 , 2
    • SYSAUX, managing 1
    • SYSAUX creation 1
    • SYSTEM 1 , 2
    • taking offline normal 1
    • taking offline temporarily 1
    • temp files in locally managed 1
    • temporary 1 , 2
    • temporary bigfile 1
    • temporary for creating large indexes 1
    • undo 1
    • using multiple 1
    • using Oracle Managed Files 1
  • tablespace set 1
  • TEMP_UNDO_ENABLED parameter 1
  • temp files
    • creating as Oracle managed 1
    • dropping 1
    • dropping Oracle managed 1
  • temporary segments
    • index creation and 1
  • temporary tables
    • assigning to a tablespace 1
    • creating 1
  • temporary tablespace, default
    • specifying at database creation 1
  • temporary tablespaces
    • altering 1
    • bigfile 1
    • creating 1
    • groups 1
    • renaming default 1
    • shrinking, locally managed 1
  • temporary undo 1
  • terminating user sessions
    • active sessions 1
    • identifying sessions 1
    • inactive session, example 1
    • inactive sessions 1
  • test case
    • builder, SQL 1
  • threads
    • online redo log 1
  • threshold based alerts
    • managing with Oracle Enterprise Manager Cloud Control 1
  • threshold-based alerts
    • server-generated 1
  • thresholds
    • setting alert 1
  • time zone
    • files 1
    • setting for database 1
  • trace files
    • location of 1
    • log writer process and 1
    • using 1
    • when written 1
  • trace files, finding 1
  • traces 1
  • tracing
    • archivelog process 1
  • transaction control statements
    • distributed transactions and 1
  • transaction failures
    • simulating 1
  • Transaction Guard 1
  • transaction management
    • overview 1
  • transaction processing
    • distributed systems 1
  • transactions
    • closing database links 1
    • distributed and two-phase commit 1
    • in-doubt 1 , 2 , 3 , 4
    • naming distributed 1 , 2
    • remote 1
  • transmitting archived redo log files 1
  • Transparent Data Encryption
    • CDBs 1
    • columns 1
    • keystore 1 , 2
    • tablespaces 1
  • transporting data
    • across platforms 1
    • character sets 1
    • compatibility considerations 1
    • full transportable export/import
      • limitations 1
      • when to use 1
    • limitations 1
    • national character sets 1
    • PDBs 1 , 2
    • transferring data files 1
    • transportable tables
      • limitations 1
    • transportable tablespaces
      • from backup 1 , 2
      • limitations 1
      • tablespace set 1
      • transportable set 1
      • when to use 1
      • wizard in Oracle Enterprise Manager Cloud Control 1
    • XMLTypes in 1
  • triggers
    • disabling 1
    • enabling 1
  • TRUNCATE statement
    • DROP ALL STORAGE 1
    • DROP STORAGE 1
    • DROP STORAGE clause 1
    • REUSE STORAGE 1
    • REUSE STORAGE clause 1
  • tuning
    • analyzing tables 1
    • cost-based optimization 1
  • two-phase commit
    • case study 1
    • commit phase 1 , 2
    • described 1
    • discovering problems with 1
    • distributed transactions 1
    • example 1
    • forget phase 1
    • in-doubt transactions 1 , 2
    • phases 1
    • prepare phase 1 , 2
    • recognizing read-only nodes 1
    • specifying commit point strength 1
    • steps in commit phase 1
    • tracing session tree in distributed transactions 1
    • viewing database links 1

U

  • UNDO_MANAGEMENT initialization parameter 1
  • UNDO_TABLESPACE initialization parameter
    • for undo tablespaces 1
  • Undo Advisor 1
  • undo management
    • automatic 1
    • described 1
    • initialization parameters for 1
    • temporary undo 1
  • undo retention
    • automatic tuning of 1
    • explained 1
    • guaranteeing 1
    • setting 1
  • undo segments
    • in-doubt distributed transactions 1
  • undo space
    • data dictionary views reference 1
  • undo space management
    • automatic undo management mode 1
  • Undo tablespace
    • specifying at database creation 1
  • undo tablespaces
    • altering 1
    • creating 1
    • data dictionary views reference 1
    • dropping 1
    • managing 1
    • managing space threshold alerts 1
    • monitoring 1
    • PENDING OFFLINE status 1
    • renaming 1
    • sizing a fixed-size 1
    • specifying at database creation 1 , 2 , 3
    • specifying for CDBs 1
    • switching 1
    • user quotas 1
  • UNIQUE key constraints
    • associated indexes 1
    • dropping associated indexes 1
    • enabling on creation 1
    • foreign key references when dropped 1
    • indexes associated with 1
  • unplugging 1
  • UNRECOVERABLE DATAFILE clause
    • ALTER DATABASE statement 1
  • unusable indexes 1
  • updates
    • location transparency and 1
  • upgrading a database 1
  • USER_DB_LINKS view 1
  • USER_DUMP_DEST initialization parameter 1
  • USER_TABLESPACES clause 1
  • user accounts
    • predefined 1 , 2
  • users
    • assigning tablespace quotas 1
    • in a newly created database 1
    • limiting number of 1
    • predefined 1
    • session, terminating 1
    • SYS 1
    • SYSBACKUP 1
    • SYSDG 1
    • SYSKM 1
    • SYSTEM 1
  • utilities
    • for the database administrator 1
    • SQL*Loader 1 , 2
  • UTLCHAIN.SQL script
    • listing chained rows 1
  • UTLCHN1.SQL script
    • listing chained rows 1
  • UTLLOCKT.SQL script 1

V

  • V$ARCHIVE view 1
  • V$CLONEDFILE view 1
  • V$CON_SYS_TIME_MODEL view 1
  • V$CON_SYSSTAT view 1
  • V$CON_SYSTEM_EVENT view 1
  • V$CON_SYSTEM_WAIT_CLASS view 1
  • V$CONTAINERS view 1
  • V$DATABASE view 1
  • V$DBLINK view 1
  • V$DIAG_CRITICAL_ERROR view 1
  • V$DIAG_INFO view 1
  • V$DISPATCHER_RATE view
    • monitoring shared server dispatchers 1
  • V$DISPATCHER view
    • monitoring shared server dispatchers 1
  • V$ENCRYPTED_TABLESPACES view 1 , 2
  • V$LOG_HISTORY view 1
  • V$LOGFILE view
    • log file status 1
  • V$LOG view
    • displaying archiving status 1
  • V$PDBS view 1 , 2
  • V$PWFILE_USERS view 1
  • V$QUEUE view
    • monitoring shared server dispatchers 1
  • V$SESSION view 1
  • V$THREAD view 1
  • V$TIMEZONE_NAMES view
    • time zone table information 1
  • V$VERSION view 1
  • VALIDATE STRUCTURE clause
    • of ANALYZE statement 1
  • VALIDATE STRUCTURE ONLINE clause
    • of ANALYZE statement 1
  • verifying blocks
    • redo log files 1
  • viewing
    • alerts 1
    • incident package details 1
    • SQL patch 1
  • views
    • creating 1
    • creating with errors 1
    • data dictionary
      • for archived redo log files 1
      • for clusters 1
      • for control files 1
      • for database 1
      • for database resident connection pooling 1
      • for Database Resource Manager 1
      • for data files 1
      • for hash clusters 1
      • for indexes 1
      • for Oracle Scheduler 1
      • for redo log 1
      • for schema objects 1
      • for sequences 1
      • for shared server 1
      • for space usage in schema objects 1
      • for synonyms 1
      • for tables 1
      • for tablespaces 1
      • for undo space 1
      • for views 1
    • data dictionary views for 1
    • DBA_2PC_NEIGHBORS 1
    • DBA_2PC_PENDING 1
    • DBA_DB_LINKS 1
    • displaying dependencies of 1
    • dropping 1
    • file mapping views 1
    • FOR UPDATE clause and 1
    • invalid 1
    • join
      • See join views 1
    • location transparency in distributed databases 1
    • managing 1 , 2
    • managing privileges with 1
    • name resolution in distributed databases 1
    • ORDER BY clause and 1
    • remote object security 1
    • restrictions 1
    • using 1
    • V$ARCHIVE 1
    • V$DATABASE 1
    • V$LOG 1
    • V$LOGFILE 1
    • wildcards in 1
    • WITH CHECK OPTION 1
  • virtual columns
    • indexing 1
  • Virtual Private Database
    • redefining tables online 1

W

  • wildcards
    • in views 1
  • window groups
    • creating 1
    • disabling 1
    • dropping 1
    • dropping a member from 1
    • enabling 1
    • managing job scheduling and job priorities with 1
    • overview 1
  • window logs 1
  • windows, managing job scheduling and resource allocation with 1
  • windows (Scheduler)
    • altering 1
    • closing 1
    • creating 1
    • disabling 1
    • dropping 1
    • enabling 1
    • opening 1
    • overlapping 1
    • overview 1
  • workloads
    • managing with database services 1
  • WORM devices
    • and read-only tablespaces 1
  • WRH$_UNDOSTAT view 1

X

  • XMLTypes
    • transporting data 1

Z

  • zone maps 1