Index

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

Symbols


A

  • abort response 34.3.2.2.3
  • accounts
    • creating for materialized views 38.2.4.1
    • DBA operating system account 1.5.1
  • adaptive query optimization
  • adaptive query plans 9.3.4.2.2
  • adding
  • ADD LOGFILE clause
    • ALTER DATABASE statement 11.3.1
  • ADD LOGFILE MEMBER clause
    • ALTER DATABASE statement 11.3.2
  • ADMIN_TABLES procedure
  • ADMINISTER_RESOURCE_MANAGER system privilege 27.1.3
  • administering
    • the Scheduler 30
  • administration
    • distributed databases 32
  • administrative user accounts 1.5.2.1
  • administrator passwords, synchronizing password file and data dictionary 1.7.4
  • ADR
    • See: automatic diagnostic repository
  • ADR base 9.1.4
  • ADRCI utility 9.1.3.8
  • ADR home 9.1.4
  • advanced index compression 21.3.8.2
  • advanced row compression 20.2.6.1
  • Advisor
  • AFTER SUSPEND trigger
    • example of registering 19.2.6
  • agent
    • Heterogeneous Services, definition of 31.1.2.1
  • aggregate functions
    • statement transparency in distributed databases 32.7
  • alert log 9.1.3.2
  • alerts
  • alert thresholds
    • setting for locally managed tablespaces 19.1.2
  • ALL_DB_LINKS view 32.5.1
  • allocation
  • ALTER CLUSTER statement
    • ALLOCATE EXTENT clause 22.4.1
    • using for hash clusters 23.4
    • using for index clusters 22.4.1
  • ALTER DATABASE statement
    • ADD LOGFILE clause 11.3.1
    • ADD LOGFILE MEMBER clause 11.3.2
    • ARCHIVELOG clause 12.3.2
    • CLEAR LOGFILE clause 11.8
    • database partially available to users 3.2.1
    • DATAFILE...OFFLINE DROP clause 14.4.3
    • DROP LOGFILE clause 11.5.1
    • DROP LOGFILE MEMBER clause 11.5.2
    • MOUNT clause 3.2.1
    • NOARCHIVELOG clause 12.3.2
    • OPEN clause 3.2.2
    • READ ONLY clause 3.2.3
    • RENAME FILE clause 14.5.2.2
    • UNRECOVERABLE DATAFILE clause 11.8
  • ALTER INDEX statement
  • altering
  • ALTER SEQUENCE statement 24.2.3
  • ALTER SESSION statement
  • ALTER SYSTEM FLUSH FLASH_CACHE 6.6.3
  • ALTER SYSTEM statement
    • ARCHIVE LOG ALL clause 12.3.3
    • DISABLE DISTRIBUTED RECOVERY clause 35.9.2
    • ENABLE DISTRIBUTED RECOVERY clause 35.9.2
    • ENABLE RESTRICTED SESSION clause 3.2.4
    • enabling Database Resource Manager 27.6
    • QUIESCE RESTRICTED 3.4.2
    • RESUME clause 3.5
    • SET RESOURCE_MANAGER_PLAN 27.6
    • SET SHARED_SERVERS initialization parameter 5.4.3.2
    • SUSPEND clause 3.5
    • SWITCH LOGFILE clause 11.6
    • UNQUIESCE 3.4.3
  • ALTER TABLESPACE statement
    • adding an Oracle managed data file, example 17.3.4.4
    • adding an Oracle managed temp file, example 17.3.5.3
    • ONLINE clause, example 13.6.2
    • READ ONLY clause 13.7.2
    • RENAME DATAFILE clause 14.5.2.1.1
  • ALTER TABLE statement
  • ALTER TRIGGER statement
  • ANALYZE statement
  • analyzing schema objects 18.2.1
  • analyzing tables
  • AND condition
    • for simple subquery materialized views 36.6.3
  • APPEND hint 20.2.6.2
  • Application Continuity 2.9.4
  • 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 12.4.4
    • archiving modes 12.3.2
    • data dictionary views 12.8.1
    • destination availability state, controlling 12.4.3
    • destinations, groups 12.4.2
    • destinations, specifying 12.4
    • destination status 12.4.3
    • failed destinations and 12.6
    • mandatory destinations 12.6.1.1
    • multiplexing 12.4.1
    • normal transmission of 12.5
    • re-archiving to failed destination 12.6.2
    • sample destination scenarios 12.6.1.2
    • standby transmission of 12.5
    • status information 12.8.1
    • transmitting 12.5
  • ARCHIVELOG mode 12.2.2
  • archiver process (ARCn) 5.6
    • trace output (controlling) 12.7
  • archiving
    • alternate destinations 12.4.4
    • changing archiving mode 12.3.2
    • controlling number of processes 12.3.4
    • destination availability state, controlling 12.4.3
    • destination failure 12.6
    • destination status 12.4.3
    • manual 12.3.3
    • NOARCHIVELOG vs. ARCHIVELOG mode 12.2
    • setting initial mode 12.3.1
    • to failed destinations 12.6.2
    • trace output, controlling 12.7
    • viewing information on 12.8.1
  • at-sign 2.4.12
  • attribute-clustered tables 20.2.9
  • auditing
  • authentication
  • AUTO_TASK_CONSUMER_GROUP
    • of Resource Manager 26.5
  • AUTOEXTEND clause 14.3.1
  • auto indexes 21.7, 21.7.1
  • automatic big table cache 6.2
  • automatic diagnostic repository 9.1.1, 9.1.3.1
    • in Oracle Client 9.1.4
    • in Oracle Clusterware 9.1.4
    • in Oracle Real Application Clusters 9.1.4
    • structure, contents and location of 9.1.4
  • automatic file extension 14.3.1
  • automatic indexes
  • automatic indexing
  • automatic maintenance tasks
    • assigning to maintenance windows 26.3.2
    • definition 26.1
    • enabling and disabling 26.3.1
    • predefined 26.1
    • resource allocation 26.5.1
    • Scheduler job names 26.2
  • automatic segment space management 13.2.2.3
  • automatic undo management 2.5.5, 16.2

B

  • BACKGROUND_DUMP_DEST initialization parameter 9.1.3.1
  • background processes 5.6
  • backups
    • after creating new databases 2.4.14
    • effects of archiving on 12.2.1
  • batch jobs, authenticating users in 2.9.3
  • bigfile tablespaces
  • big table cache 6.2
  • BLOB data type 20.3.1
  • block size, redo log files 11.2.4
  • BLOCKSIZE clause
    • of CREATE TABLESPACE 13.4

C


D


E


F


G

  • GDS configuration 2.8.2
  • generic connectivity
  • GLOBAL_NAMES initialization parameter
  • 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
  • global database links 31.2.7
  • global database names
  • Global Data Services 2.8.2
  • globalization support
    • client/server architectures 31.6.2
    • distributed databases 31.6.1
  • global object names
  • global temporary tables
  • global users 32.8.5
    • exclusively mapped in distributed systems 31.3.2.4.2
    • shared schema in distributed systems 31.3.2.4.3
  • granting privileges and roles
    • SYSOPER/SYSDBA privileges 1.7.6
  • GRANT statement
    • SYSOPER/SYSDBA privileges 1.7.6
  • groups, Oracle Scheduler 28.2.11.1
  • growth trends
  • GV$DBLINK view 32.5.2

H


I


J


K


L

  • large objects 20.3.1
  • lightweight jobs 28.3.1.6
  • links
    • See: database links
  • LIST CHAINED ROWS clause
  • listeners
  • listing database links 32.5.1, 35.3.1, 35.3.2
  • loading data
  • LOBs 20.3.1
  • local coordinators
    • distributed transactions 34.2.4
  • locally managed tablespaces 13.2.2.1
    • automatic segment space management in 13.2.2.3
    • DBMS_SPACE_ADMIN package 13.13.1
    • detecting and repairing defects 13.13.1
    • migrating SYSTEM from dictionary-managed 13.14
    • shrinking, temporary 13.8.5
    • temp files 13.2.6.2
    • temporary, creating 13.2.6.2
  • local temporary tablespaces 13.2.6.1
  • location transparency in distributed databases
  • locks
  • lock timeout interval
    • distributed transactions 35.8
  • log
  • LOG_ARCHIVE_DEST_n initialization parameter 12.4.1
  • LOG_ARCHIVE_DEST_STATE_n initialization parameter 12.4.3
  • LOG_ARCHIVE_DEST initialization parameter
    • specifying destinations using 12.4.1
  • LOG_ARCHIVE_DUPLEX_DEST initialization parameter
    • specifying destinations using 12.4.1
  • LOG_ARCHIVE_MAX_PROCESSES initialization parameter 12.3.4
  • LOG_ARCHIVE_MIN_SUCCEED_DEST initialization parameter 12.6.1
  • LOG_ARCHIVE_TRACE initialization parameter 12.7
  • log archive destination groups 12.4.2
  • LOGGING clause
    • CREATE TABLESPACE 13.5
  • logging mode
  • logical corruptions from DBMS_REPAIR 25.3.2
  • logical standby 28.5
  • logical volume managers
  • LOGON trigger
    • setting resumable mode 19.2.3
  • logs
  • log sequence number
  • log switches
  • log writer process (LGWR) 5.6
    • multiplexed redo log files and 11.2.1.1
    • online redo logs available for use 11.1.3
    • trace files and 11.2.1.1
    • writing to online redo log files 11.1.3
  • LONG columns 32.7
  • LONG RAW columns 32.7
  • lost write protection
    • shadow lost write protection 13.11
  • LOST WRITE PROTECTION clause 13.11.2

M


N


O

  • object identifiers
    • agreement for replication 36.10.2
  • object materialized views 39.1
  • object privileges
  • object quarantine 3.6, 8.3
  • object-relational model
  • 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
  • online redefinition of tables 20.8.1, 37.1.4.1
  • online redo log files
    • See: online redo logs
  • online redo logs 11
    • See also: redo log files]
    • creating groups 11.3
    • creating members 11.3.2
    • data dictionary views reference 11.10
    • dropping groups 11.5
    • dropping members 11.5
    • forcing a log switch 11.6
    • guidelines for configuring 11.2
    • INVALID members 11.5.2
    • location of 11.2.2
    • managing 11
    • moving files 11.4
    • number of files in the 11.2.5
    • optimum configuration for the 11.2.5
    • renaming files 11.4
    • renaming members 11.4
    • specifying ARCHIVE_LAG_TARGET 11.2.6
    • STALE members 11.5.2
  • online segment shrink 19.3.3
  • ON PREBUILT TABLE clause 36.6.3
  • OPEN_LINKS initialization parameter 32.4.3
  • opening windows 29.9.3.5
  • operating system authentication 1.6.4, 1.6.4.2
  • operating systems
    • database administrators requirements for 1.5.1
    • renaming and relocating files 14.5.2
  • optimizer statistics
  • ORA-01013 error message 3.3.6
  • ORA-02055 error
    • integrity constraint violation 33.3
  • ORA-02067 error
    • rollback required 33.3
  • ORA-12838 error, direct path insert 20.4.2.3.2
  • ORACLE_SID environment variable 2.4.2
  • Oracle Call Interface
    • See: OCI
  • Oracle Database In-Memory 6.7
  • Oracle Database users
  • Oracle Data Guard
  • Oracle Enterprise Manager Cloud Control 3.1.1.3
  • Oracle home
  • Oracle managed files
  • Oracle Managed Files
  • Oracle Managed Files feature
    • See: Oracle managed files
  • Oracle release numbers 1.4.1
  • Oracle Restart
    • about 4.1.1
    • configuration
      • adding components to 4.2.4
      • modifying 4.2.9
      • removing components from 4.2.5
      • viewing for a component 4.2.8
    • configuring 4.2
    • CRSCTL utility 4.1.4
    • disabling and enabling management for a component 4.2.6
    • environment variables in 4.2.10
    • patches
      • installing 4.3
    • registering a component with 4.2.4
    • starting 4.1.4
    • starting and stopping components managed by 4.3
      • Oracle home 4.3
    • status of components 4.2.7
    • stopping 4.1.4
  • Oracle Scheduler
  • Oracle Scheduler agent
  • Oracle Scheduler Agent 30.1.3
  • Oracle Scheduler agents
  • OracleSchedulerExecutionAgent 30.1.3.3.2
  • Oracle Universal Installer 2.1
  • ORADIM
    • creating an instance 2.4.6
    • enabling automatic instance startup 2.4.15
  • ORAPWD utility 1.7.2
  • OR condition
    • materialized views with subqueries 36.6.3
  • ORGANIZATION EXTERNAL clause
  • orphan key table
  • OSBACKUPDBA group 1.6.4.1
  • OSDBA group 1.6.4.1
  • OSDGDBA group 1.6.4.1
  • OSKMDBA group 1.6.4.1
  • OSOPER group 1.6.4.1
  • OTHER_GROUPS
    • for Database Resource Manager 27.1.2.2
  • OTHER_GROUPS for Database Resource Manager 27.5.6, 27.5.7, 27.7.5
  • outer joins 24.1.5.4
  • overlapping windows 28.2.10.2

P

  • packages
  • packaging and uploading problems 9.4.2
  • parallel execution
  • parallel hints 5.8.1
  • parallelizing table creation 20.2.4, 20.3.3
  • parallel statement execution
    • directive attributes for managing 27.7.4
    • managing using Resource Manager 27.3.3.3
  • parameter files
    • See: initialization parameter file
  • partitioned tables
  • password
    • setting for SYSTEM account in CREATE DATABASE statement 2.5.2
    • setting SYS in CREATE DATABASE statement 2.5.2
  • password file
    • adding users 1.7.5
    • creating 1.7.2
    • ORAPWD utility 1.7.2
    • removing 1.7.8
    • setting REMOTE_LOGIN_PASSWORD 1.7.3
    • synchronizing administrator passwords with the data dictionary 1.7.4
    • viewing members 1.7.7
  • password file authentication 1.6.5, 1.6.5.1
  • passwords
  • patches
    • installing
      • Oracle Restart 4.3
  • pausing chains and chain steps 29.6.16
  • PCTINCREASE parameter 20.7.2
  • PCTUSED parameter
    • value for complex materialized views 37.4.2.1
  • PDBs
  • pending area for Database Resource Manager plans 27.5.9
    • validating plan schema changes 27.5.7
  • pending transaction tables 35.7.6
  • performance
    • index column order 21.2.3
    • location of data files and 14.1.4
    • monitoring 8.2
  • PL/SQL
    • replaced views and program units 24.1.3
  • plan schemas for Database Resource Manager 27.3.1.1, 27.6, 27.9.4
    • validating plan changes 27.5.7
  • plans for Database Resource Manager
  • PRAGMA_EXCEPTION_INIT procedure
    • assigning exception names 33.5
  • predefined user accounts 2.9.1
  • prefix compression 20.13.2.8, 21.3.8.1
  • prepare/commit phases
  • prepared response
  • prepare phase
  • prerequisites
    • for creating a database 2.2.4
  • prespawned processes 5.7
  • PRIMARY KEY constraints
  • priorities
  • private database links 31.2.7
  • private synonyms 24.3.1
  • private temporary tables
  • privileges
  • problem activity log
    • adding comments to 9.2.7
  • problems
  • problems (critical errors)
    • packaging and uploading 9.4.2
  • procedures
    • external 5.9.1
    • location transparency in distributed databases 32.6.3
    • name resolution in distributed databases 31.4.9.1
    • remote calls 31.5.2
  • processes
    • See: server processes
    • prespawned 5.7
  • PROCESSES initialization parameter
    • setting before database creation 2.6.6
  • process manager (PMAN) 5.6
  • process monitor (PMON) 5.6
  • PRODUCT_COMPONENT_VERSION view 1.4.2
  • programs
  • proxy resident connection pooling 5.3
  • public database links 31.2.7
  • public fixed user database links 32.8.1
  • public synonyms 24.3.1
  • pupbld.sql 2.4.12
  • PURGE_LOST_DB_ENTRY procedure
    • DBMS_TRANSACTION package 35.6.2

Q


R


S


T


U


V


W


X

  • XMLTypes

Z