Index
Symbols
- & command (SQL*Plus), &
A
- A (APPEND) command (SQL*Plus), APPEND
- ACC[EPT] command (SQL*Plus), ACCEPT
- access method hints, Access method hints–Access method hints
- access path, Types of Join Access Paths
- access to databases, User access to the database
- auditing, Scope of Auditing
- ACCOUNT LOCK parameter
- ACCOUNT UNLOCK parameter
- actions, privileges and roles for, Actions, Privileges, and Roles–Actions, Privileges, and Roles
- ADD DATAFILE parameter (ALTER TABLESPACE), Keywords
- ADD parameter (ALTER TABLE), Keywords
- ADD PARTITION parameter (ALTER TABLE), Keywords
- Administration Manager (Server Manager), Graphical Version
- administrators (database), job description, Oracle Database Administration–A DBA Job Description
- Advanced Networking Option (see ANO)
- Advanced Queuing facility, data dictionary views for, Advanced Queuing, Advanced Queuing
- advanced replication, Replication, Advanced replication
- ADVISE parameter (ALTER SESSION), Keywords
- AFTER parameter (CREATE TRIGGER), Keywords
- ALL_ARGUMENTS view, PL/SQL
- ALL_DEF_AUDIT_OPTS view, Views containing auditing specifications, Audit trail
- ALL_INDEXES view, ANALYZE INDEX
- ALL auditing shortcut, Statement Auditing
- ALL clause (ARCHIVE_LOG, ALTER SYSTEM), Keywords
- ALL parameter (SET ROLE), Keywords
- ALL system privilege auditing shortcut, System Privilege Auditing
- ALL PRIVILEGES auditing shortcut, System Privilege Auditing
- ALL_ROWS value (OPTIMIZER_MODE), Goal hints, Keywords
- ALL_TAB_COLUMNS view, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- ALL_TABLES view, ANALYZE TABLE
- ALLOCATE EXTENT parameter
- allocating
- disk allocation, Disk Allocation–About RAID
- memory (see memory)
- storage (see storage)
- ALLOW_PARTIAL_SN_RESULTS parameter, ALLOW_PARTIAL_SN_RESULTS
- ALTER ANY CLUSTER privilege, Summary of System Privileges
- ALTER ANY INDEX privilege, Summary of System Privileges
- ALTER ANY LIBRARY privilege, Summary of System Privileges
- ALTER ANY PROCEDURE privilege, Summary of System Privileges
- ALTER ANY ROLE privilege, Summary of System Privileges
- ALTER ANY SEQUENCE privilege, Summary of System Privileges
- ALTER ANY SNAPSHOT privilege, Summary of System Privileges
- ALTER ANY TABLE privilege, Summary of System Privileges
- ALTER ANY TRIGGER privilege, Summary of System Privileges
- ALTER ANY TYPE privilege, Summary of System Privileges
- ALTER DATABASE command
- ARCHIVELOG keyword, ARCH—the Archiver process, Keywords
- ALTER DATABASE privilege, Summary of System Privileges
- ALTER privilege, Object Privileges
- ALTER PROFILE command, Profiles
- ALTER PROFILE privilege, Summary of System Privileges
- ALTER RESOURCE COST privilege, Summary of System Privileges
- ALTER ROLE command, Password-enabled roles
- ALTER ROLLBACK SEGMENT privilege, Summary of System Privileges
- ALTER SESSION privilege, Summary of System Privileges
- ALTER SYSTEM privilege, Summary of System Privileges
- ALTER TABLESPACE command, Hot Backup, ALTER TABLESPACE
- ALTER TABLESPACE privilege, Summary of System Privileges
- ALTER TRIGGER command, ALTER TRIGGER
- ALTER USER command, ALTER USER
- ALTER USER privilege, Summary of System Privileges
- ALTER VIEW command, ALTER VIEW
- ALWAYS_ANTI_JOIN parameter, Initialization Parameters, ALWAYS_ANTI_ JOIN
- ANALYZE ANY privilege, Summary of System Privileges
- ANALYZE CLUSTER command, ANALYZE CLUSTER
- ANALYZE INDEX command, ANALYZE INDEX, ANALYZE INDEX
- ANALYZE= parameter (IMP), Import Parameters
- ANALYZE TABLE command, ANALYZE TABLE, ANALYZE TABLE
- COMPUTE clause vs. ESTIMATE clause, ESTIMATE versus COMPUTE
- STATISTICS FOR COLUMNS clause, ANALYZE TABLE . . . STATISTICS FOR COLUMNS–Script to automate the ANALYZE process
- AND_EQUAL hint, Access method hints
- ANO (Advanced Networking Option), Options, Advanced Networking Option–DCE naming adapter
- APPEND command (SQL*Plus), APPEND
- APPEND hint, Parallel operation hints
- APPEND parameter (SQL*Loader), Control File Syntax
- APP[INFO] command (SQL*Plus), APPINFO
- applications, Oracle, Applications
- AQ_ADMINISTRATOR_ROLE role, Optional Roles
- AQ_TM_PROCESSES parameter, QMNn—the Queue Monitor process, AQ_TM_PROCESSES (Oracle8 Only)
- AQ_USER_ROLE role, Optional Roles
- ARCH (Archiver) process, Archive Log Destination, Archivelog Mode, ARCH—the Archiver process, Redo log files
- ARCHIVE_LOG_DEST parameter, Archive Log Destination
- ARCHIVE_LOG parameter (ALTER SYSTEM), Keywords
- archive logs, Archive Log Destination
- unrecoverable operations, Unrecoverable operations
- ARCHIVELOG clause
- archivelog mode, Archivelog mode, Archivelog Mode, ARCH—the Archiver process, Redo log files
- ARCHIVELOG parameter (ALTER DATABASE), ARCH—the Archiver process, Keywords
- Archiver (see ARCH process)
- ARCH_IO_SLAVES parameter, ARCH_IO_SLAVES (Oracle8 Only)
- ARRAY[SIZE] command (SQL*Plus), ARRAYSIZE
- AS parameter
- AUDIT_ACTIONS view, Lookup Tables, Audit trail
- AUDIT ANY privilege, Summary of System Privileges
- AUDIT_FILE_DEST parameter, AUDIT_FILE_DEST
- AUDIT command (schema objects), AUDIT (Schema Objects)
- AUDIT command (SQL statements), Forms of the AUDIT Statement–System Privilege Auditing, AUDIT (SQL Statements)
- audit policy, Audit policy
- AUDIT SYSTEM privilege, Summary of System Privileges
- AUDIT_TRAIL parameter, Implementing Auditing, AUDIT_TRAIL
- auditing, Auditing–Row-Level Auditing
- audit trail views, Audit Trail Views and Lookup Tables–Views containing auditing specifications
- data dictionary views for, Audit trail
- lookup tables, Lookup Tables
- maintaining audit trail, Maintaining the Audit Trail–Example Script to Clean Out the Audit Trail
- policy for, Establishing an Audit Policy–Establishing an Audit Policy
- row-level auditing, Limitations of Auditing, Row-Level Auditing–Row-Level Auditing
- schema object auditing, Types of Auditing Supported , Schema Object Auditing–Examples of schema object auditing
- scope, Scope of Auditing
- SQL statement auditing, Types of Auditing Supported , Statement Auditing–Examples of statement auditing
- system privileges, Types of Auditing Supported , System Privilege Auditing
- AUTHENTICATED BY clause (CONNECT TO), Keywords
- authentication, DCE integration–DCE integration
- AUTO value (SORT_DIRECT_WRITES)
- AUTO[COMMIT] command (SQL*Plus), AUTOCOMMIT
- autoextend_clause parameter
- ALTER TABLESPACE command, Keywords, auto_extend_clause
- CREATE DATABASE command, Keywords
- CREATE TABLESPACE command, Keywords, autoextend_clause
- automatic roles, Automatic Roles
- AUTOP[RINT] command (SQL*Plus), AUTOPRINT
- AUTOT[RACE] command (SQL*Plus), AUTOTRACE
- AUTOTRACE facility, SQL*Plus AUTOTRACE
- availability of database information, Availability
- AVG_DATA_BLOCKS_PER_KEY column, ANALYZE INDEX
- AVG_LEAF_BLOCKS_PER_KEY column, ANALYZE INDEX
- AVG_ROW_LEN column, ANALYZE TABLE
- AVG_SPACE column, ANALYZE TABLE
- AVG_SPACE_FREELIST_BLOCKS column, ANALYZE TABLE
B
- B_TREE_BITMAP_PLANS parameter (ALTER SESSION), Initialization Parameters, B_TREE_BITMAP_PLANS , Keywords
- BACKGROUND_CORE_DUMP parameter, BACKGROUND_CORE_DUMP
- BACKGROUND_DUMP_DEST parameter, Control files, BACKGROUND_DUMP_DEST
- background processes, Background Processes, Processes, Standard Background Processes– SNPn—the Job Queue process
- backup and recovery, Backup and Recovery–Recovery Manager (RMAN), Preventing Data Loss–Other Techniques
- cold (offline) backups, Cold backup, Cold Backup, Hot or Cold Backups
- Export/Import utilities, Export/import, EXPort/IMPort–Other uses for Export, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- practice scenarios, Export/Import
- hot (online) backups, Hot backup, Hot Backup, Hot or Cold Backups
- incremental backups, Incremental Backups
- logical backups, Export/import, Logical Backups
- logs (see log files)
- offline redo (archive) logs, Archivelog mode, Archive Log Destination, Archivelog Mode, ARCH—the Archiver process
- online redo logs, Redo Logs
- physical backups, Cold backup, Physical Backups
- RAID options, A note about RAID, About RAID–About RAID
- recovery-related V$ views, Recovery
- redo log buffer, Redo log buffer
- RMAN (Recovery Manager), Recovery Manager (RMAN), Oracle Recovery Manager, Summary of Initial Users
- scenarios for, Types of Backups, Recovery Scenarios–Data corruption, Practice Scenarios
- tablespace point-in-time recovery, Tablespace Point-in-Time Recovery–Data dictionary views, Tablespace point-in-time recovery
- unrecoverable operations, Unrecoverable operations
- writing to redo logs, LGWR—the Log Writer
- BACKUP ANY TABLE privilege, Summary of System Privileges
- BACKUP_DISK_IO_SLAVES parameter (ALTER SYSTEM), BACKUP_DISK_IO_SLAVES (Oracle8 Only) , Keywords
- BACKUP_TAPE_IO_SLAVES parameter (ALTER SYSTEM), BACKUP_TAPE_IO_SLAVES (Oracle8 Only), Keywords
- bad file, SQL*Loader, SQL*Loader Files
- BAD parameter (SQL*Loader), Command-Line Syntax
- BADDN parameter (SQL*Loader), Control File Syntax
- BADFILE parameter (SQL*Loader), Control File Syntax
- base product of Oracle RDBMS, Base Product
- baseline for monitoring, Getting a baseline
- BECOME USER privilege, Summary of System Privileges
- BEFORE parameter (CREATE TRIGGER), Keywords
- BEGIN BACKUP parameter (ALTER TABLESPACE), Keywords
- BINDSIZE parameter (SQL*Loader), Command-Line Syntax
- bitmap indexes, Bitmap indexes
- BITMAP parameter (CREATE INDEX), Bitmap indexes, Keywords
- BITMAP_MERGE_AREA_SIZE parameter, Initialization Parameters, BITMAP_MERGE_AREA_SIZE
- BLANK_TRIMMING parameter, BLANK_TRIMMING
- BLEVEL column, ANALYZE INDEX
- blocks, Data Storage Files, Oracle Blocks–Data storage area
- BLOCKS column, ANALYZE TABLE
- blocksize, Choosing a blocksize
- BLO[CKTERMINATOR] command (SQL*Plus), BLOCKTERMINATOR
- BODY parameter
- BRE[AK] command (SQL*Plus), BREAK
- BTI[TLE] command (SQL*Plus), BTITLE
- buckets for data distribution, ANALYZE TABLE . . . STATISTICS FOR COLUMNS–Script to automate the ANALYZE process
- BUFFER= parameter (EXP), Export Parameters
- BUFFER= parameter (IMP), Import Parameters
- buffers
- database buffer cache, Database buffer cache–Database buffer cache
- redo log buffer, Redo log buffer
- for writing to databases, DBWR—the Database Writer
- BY ACCESS parameter, Scope of Auditing
- BY parameter (NOAUDIT), Keywords
- BY SESSION parameter, Scope of Auditing
- BY user parameter (AUDIT), Scope of Auditing, Keywords
C
- C (CHANGE) command (SQL*Plus), CHANGE
- CA (certificate authority), Network security
- CACHE_INSTANCES parameter (ALTER SYSTEM), Keywords
- cache miss, cache hit, Database buffer cache
- CACHE hint, Additional hints
- CACHE parameter
- CACHE_SIZE_THRESHOLD parameter, CACHE_SIZE_THRESHOLD
- Cartesian products, Cartesian Product
- CASCADE CONSTRAINTS parameter
- CASCADE parameter
- CBO (cost-based optimizer), Cost-Based Optimizer–Additional hints
- data dictionary requirements, Data Dictionary Requirements–Script to automate the ANALYZE process
- hints, specifying, Specifying Hints
- initialization parameters, Initialization Parameters–Initialization Parameters
- certificate authority (CA), Network security
- certificates, Network security
- CHAINED_ROWS view, Others
- CHAIN_CNT column, ANALYZE TABLE
- CHANGE clause (ARCHIVE_LOG, ALTER SYSTEM), Keywords
- CHANGE command (SQL*Plus), CHANGE
- character mode (Oracle installation), The Oracle Installer
- CHARACTER SET parameter (CREATE DATABASE), Keywords
- CHARSET= parameter (IMP), Import Parameters
- CHECK DATAFILES parameter (ALTER SYSTEM), Keywords
- CHECK clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- CHECKPOINT parameter (ALTER SYSTEM), Keywords
- CHECKPOINT_PROCESS parameter, Redo Logs, CHECKPOINT_PROCESS (Oracle7 Only)
- CHOOSE value (OPTIMIZER_MODE), Goal hints, Keywords
- CKPT (Checkpoint) process, CKPT—the Checkpoint process
- cleaning out audit trail, Example Script to Clean Out the Audit Trail
- CLEANUP_ROLLBACK_ENTRIES parameter, CLEANUP_ROLLBACK_ENTRIES
- CL[EAR] command (SQL*Plus), CLEAR, CLEAR
- CLOSE_CACHED_OPEN_CURSORS parameter (ALTER SESSION), CLOSE_CACHED_OPEN_CURSORS
- CLOSE_CACHED_OPEN_CURSORS parameter (ALTER SESSION), Keywords
- CLOSE DATABASE LINK parameter (ALTER SESSION), Keywords
- CLUSTER auditing shortcut, Statement Auditing
- CLUSTER hint, Access method hints
- CLUSTER parameter
- CLUSTERING_FACTOR column, ANALYZE INDEX
- clusters, data dictionary views for, Tables, clusters, and views
- cman.ora file, Files Created by Network Manager
- CMDS[EP] command (SQL*Plus), CMDSEP
- COALESCE parameter (ALTER TABLESPACE), Keywords
- code areas, Software Code Areas
- cold (offline) backups, Cold backup, Cold Backup
- practice scenarios, Hot or Cold Backups
- COLSEP command (SQL*Plus), COLSEP
- COL[UMN] command (SQL*Plus), COLUMN
- COLUMN parameter (COMMENT), Keywords
- column_constraint_clause parameter
- ALTER TABLE command, Keywords, column_constraint_clause
- CREATE TABLE command, Keywords, column_constraint_clause
- column_ref_clause parameter (CREATE TABLE), Keywords, column_ref_clause
- COMMENT ANY TABLE privilege, Summary of System Privileges
- COMMENT command, COMMENT
- COMMENT TABLE auditing shortcut, Statement Auditing
- COMMIT= parameter (IMP), Import Parameters
- COMMIT_POINT_STRENGTH parameter, COMMIT_POINT_STRENGTH
- COM[PATIBILITY] command (SQL*Plus), COMPATIBILITY
- COMPATIBLE parameter, COMPATIBLE
- COMPATIBLE_NO_RECOVERY parameter, COMPATIBLE_NO_RECOVERY
- COMPILE parameter (ALTER TRIGGER), Keywords
- COMPLEX_VIEW_MERGING parameter, Initialization Parameters, Additional hints, COMPLEX_VIEW_MERGING
- components, Oracle, Installable Components
- COMPOSITE_LIMIT parameter
- COMPOSITE_LIMIT resource limit, Resource control
- COMPRESS= parameter (EXP), Export Parameters
- COMPUTE clause (ANALYZE TABLE), ESTIMATE versus COMPUTE
- COMP[UTE] command (SQL*Plus), COMPUTE
- COMPUTE STATISTICS parameter
- CON[CAT] command (SQL*Plus), CONCAT
- CONCATENATE parameter (SQL*Loader), Control File Syntax
- concurrent user licenses, Licensing by the User
- CONFIG.ORA file, Configuration file
- configuration file (see CONFIG.ORA file INIT.ORA file)
- configuring, Configuring Oracle–Parallel Server Configuration
- database objects, Sizing and Configuring Database Objects–Archive Log Destination
- databases, Configuration and Tuning—What’s the Difference?–What Can Be Tuned?
- MTS (Multi-Threaded Server), Multi-Threaded Server Configuration
- networks
- manual configuration, Manual Network Configuration
- Oracle Net8 Assistant, Oracle Net8 Assistant
- Oracle Network Manager, Oracle Network Manager–Files Created by Network Manager
- SQL*Net files for, Files Created by Network Manager, Sample SQL*Net Files– sqlnet.ora
- operating system, Configuring the Operating System
- Oracle, Configuration Planning–Disk layout
- Oracle Parallel Server, Parallel Server Configuration–Parallel Server Configuration
- PQO (Parallel Query Option), Parallel Query Configuration
- SQL*Net/Net8, SQL*Net Configuration
- V$ views for, Configuration
- CONN[ECT] command (SQL*Plus), CONNECT
- CONNECT role, Automatic Roles
- CONNECT system privilege auditing shortcut, System Privilege Auditing
- CONNECT_TIME parameter, Resource control
- CONNECT TO parameter (CREATE DATABASE LINK), Keywords
- connectivity (see networking)
- CONSISTENT= parameter (EXP), Export Parameters
- Console, OEM, Oracle Enterprise Manager
- CONSTANT parameter (SQL*Loader), Control File Syntax
- CONSTRAINT clause (WITH CHECK OPTION, CREATE VIEW), Keywords, Keywords
- CONSTRAINT parameter (ALTER SESSION), Keywords
- CONSTRAINTS= parameter (EXP), Export Parameters
- constraints, data dictonary views for, Constraints
- Context Cartridge, Data Cartridges
- CONTINUEIF parameter (SQL*Loader), Control File Syntax
- CONTROL_FILE_RECORD_KEEP_TIME parameter (ALTER SYSTEM), CONTROL_FILE_RECORD_KEEP_TIME (Oracle8 Only), Keywords
- control files, Files, Control files–Control files
- editing or replacing, Control files
- name and location specifications, Creating the parameter file, Determine control file locations
- SQL*Loader, SQL*Loader Files
- CONTROL_FILES parameter, Creating the parameter file, Control files, CONTROL_FILES
- CONTROL parameter (SQL*Loader), Command-Line Syntax
- control structures, Control structures.
- CONTROLFILE parameter (CREATE DATABASE), Keywords
- conventional path export method, Direct path versus conventional path
- conventional path loading, Conventional and Direct Path Loading
- COPY command (SQL*Plus), COPY
- COPYC[OMMIT] command (SQL*Plus), COPYCOMMIT
- COPYTYPECHECK command (SQL*Plus), COPYTYPECHECK
- CORE_DUMP_DEST parameter, CORE_DUMP_DEST
- correlated subqueries, Correlated Subqueries
- corrupted data/databases, recovery from, Database corruption
- cost-based optimizer, Cost-Based Optimizer–Additional hints
- data dictionary requirements, Data Dictionary Requirements–Script to automate the ANALYZE process
- hints, specifying, Specifying Hints
- initialization parameters, Initialization Parameters–Initialization Parameters
- cost-based query processing, Query processing
- CPU_COUNT parameter, CPU_COUNT
- CPU_PER_CALL parameter, Resource control
- CPU_PER_SESSION parameter, Resource control
- CREATE_BITMAP_AREA_SIZE parameter, CREATE_BITMAP_AREA_SIZE
- create directory, Building Database Creation Scripts
- CREATE commands, How Oracle Allocates Storage
- CREATE CLUSTER, CREATE CLUSTER
- CREATE CONTROLFILE, CREATE CONTROLFILE
- CREATE DATABASE, Choosing the name, CREATE DATABASE
- CREATE DATABASE LINK, CREATE DATABASE LINK
- CREATE DIRECTORY, CREATE DIRECTORY
- CREATE FUNCTION, CREATE FUNCTION
- CREATE INDEX, CREATE INDEX
- LOCAL and GLOBAL keywords, Partitioned tables
- CREATE LIBRARY, CREATE LIBRARY
- CREATE PACKAGE, CREATE PACKAGE
- CREATE PROCEDURE, CREATE PROCEDURE
- CREATE PROFILE, Profiles, CREATE PROFILE
- CREATE ROLE, Password-enabled roles, CREATE ROLE
- CREATE ROLLBACK SEGMENT, CREATE ROLLBACK SEGMENT
- CREATE SCHEMA, CREATE SCHEMA
- CREATE SEQUENCE, CREATE SEQUENCE
- CREATE SNAPSHOT, CREATE SNAPSHOT
- CREATE SNAPSHOT LOG, CREATE SNAPSHOT LOG
- CREATE SYNONYM, CREATE SYNONYM
- CREATE TABLE, Partitioned tables, Index-only tables, CREATE TABLE
- CREATE TABLESPACE, Tables, Temporary tablespaces, Oracle Tablespaces, CREATE TABLESPACE
- CREATE TRIGGER, CREATE TRIGGER
- CREATE USER, Creating Users, CREATE USER
- CREATE VIEW
- object views, CREATE VIEW (Object)
- relational views, CREATE VIEW (Relational)
- CREATE privileges
- CREATE ANY CLUSTER, Summary of System Privileges
- CREATE ANY DIRECTORY, Summary of System Privileges
- CREATE ANY INDEX, Summary of System Privileges
- CREATE ANY LIBRARY, Summary of System Privileges
- CREATE ANY PROCEDURE, Summary of System Privileges
- CREATE ANY SEQUENCE, Summary of System Privileges
- CREATE ANY SNAPSHOT, Summary of System Privileges
- CREATE ANY SYNONYM, Summary of System Privileges
- CREATE ANY TABLE, Summary of System Privileges
- CREATE ANY TRIGGER, Summary of System Privileges
- CREATE ANY TYPE, Summary of System Privileges
- CREATE ANY USER, Creating Users, CREATE USER
- CREATE ANY VIEW, Summary of System Privileges
- CREATE CLUSTER, Summary of System Privileges
- CREATE DATABASE LINK, Summary of System Privileges
- CREATE LIBRARY, Summary of System Privileges
- CREATE PACKAGE BODY, CREATE PACKAGE BODY
- CREATE PROCEDURE, Summary of System Privileges
- CREATE PROFILE, Summary of System Privileges
- CREATE PUBLIC DATABASE, Summary of System Privileges
- CREATE PUBLIC SYNONYM, Summary of System Privileges
- CREATE ROLE, Roles, Summary of System Privileges
- CREATE ROLLBACK, Summary of System Privileges
- CREATE SEQUENCE, Summary of System Privileges
- CREATE SESSION, Summary of System Privileges
- CREATE SNAPSHOT, Summary of System Privileges
- CREATE SYNONYM, Summary of System Privileges
- CREATE TABLE, Summary of System Privileges
- CREATE TABLESPACE, Summary of System Privileges
- CREATE TRIGGER, Summary of System Privileges
- CREATE TYPE, Summary of System Privileges
- CREATE USER, Summary of System Privileges
- CREATE VIEW, Summary of System Privileges
- CREATE TABLE parameter (CREATE SCHEMA), Keywords
- CREATE VIEW parameter (CREATE SCHEMA), Keywords
- CTXSYS user, Summary of Initial Users
- cumulative exports, Using incremental exports
- CURRENT clause (ARCHIVE_LOG, ALTER SYSTEM), Keywords
- CURRENT USER clause (CONNECT TO, CREATE DATABASE LINK), Keywords
- CURSOR_SPACE_FOR_TIME parameter, CURSOR_SPACE_FOR_TIME
- CYCLE parameter
D
- Dnnn (Dispatcher) processes, Dnnn—the Dispatcher process
- data cartridges, Oracle, Data Cartridges
- data corruption, recovery from, Database corruption
- data dictionary, Dictionary cache., The Oracle Data Dictionary–System environment
- cache, V$ views for, Data dictionary cache
- corrupted, recovery from, Database corruption
- dynamic views (V$ views), Dynamic Performance Data Dictionary Views–System environment
- objects in, views for, Dictionary
- static views, Static Data Dictionary Views–Trusted Oracle
- view families and subjects, Families of Views–Families of Views
- data gateways, Gateways
- data loss (see backup and recovery)
- DATA parameter (SQL*Loader), Command-Line Syntax
- DATA tablespace, disk allocation, Disk Layout
- data privacy/security, DCE integration
- data pump (MPI), MultiProtocol Interchange
- data storage area (blocks), Data storage area
- data storage files, Data Storage Files, Data storage area
- (see also storage)
- data striping, A note about RAID
- database administration
- administrator job description, Oracle Database Administration–A DBA Job Description
- resources on, Appendix:Resources for the DBA–List Servers
- SQL commands for (reference)
- listed by command, SQL Command Syntax–Example
- listed by task, SQL Commands by Task–SQL Commands by Task
- tools for, Oracle Tools–Third-Party Tools, Tools and Utilities–datatype_spec
- database aliases, Oracle services, Oracle Names
- database coordination files, Database Coordination Files–Redo log files
- DATABASE LINK auditing shortcut, Statement Auditing
- DATABASE parameter (CREATE CONTROLFILE), Keywords
- database sessions (see sessions)
- Database Writer (DBWR), DBWR—the Database Writer
- databases
- actions, privileges and roles for, Actions, Privileges, and Roles–Actions, Privileges, and Roles
- availability of information in, Availability
- backups (see backup and recovery)
- buffer cache, Database buffer cache–Database buffer cache
- bulk loading (SQL*Loader), SQL*Loader–SQL*Loader Files
- configuring and sizing database objects, Sizing and Configuring Database Objects–Archive Log Destination, Object Storage Sizing–The highwater mark
- configuring and tuning, Configuration and Tuning—What’s the Difference?–What Can Be Tuned?
- corrupted, recovery from, Database corruption
- creating after installation, Creating a Database–Creating the parameter file
- creation scripts, Building Database Creation Scripts–A sample script
- files for, Files
- instances vs., Database Versus Instance, The Oracle Instance, The Oracle Instance
- (see also instances)
- logical structure, Logical Database Structures
- monitoring, Monitoring
- naming, Choosing the name
- non-Oracle, connecting to, Connecting to Non-Oracle Databases–Gateways
- object privileges, Object Privileges
- redundant (see replication)
- schema object auditing, Types of Auditing Supported , Schema Object Auditing–Examples of schema object auditing
- security (see security)
- starter (initial) database, The Starter Database
- status, data dictionary views for, Server management
- V$ views for, Database–Database
- DATAFILE clause (ALLOCATE EXTENT), Keywords, Keywords
- DATAFILE parameter
- datafiles, Files, Oracle Directory Structure
- maximum open, Creating the parameter file
- monitoring storage utilization, Storage utilization–SQL queries to monitor storage utilization , SQL queries to monitor storage utilization
- updating headers of, CKPT—the Checkpoint process
- writing to, DBWR—the Database Writer
- DB_BLOCK_BUFFERS parameter, Memory utilization, Database buffer cache, DB_BLOCK_BUFFERS
- DB_BLOCK_CHECKPOINT_BATCH parameter (ALTER SYSTEM), DB_BLOCK_CHECKPOINT_BATCH, Keywords
- DB_BLOCK_CHECKSUM parameter (ALTER SYSTEM), DB_BLOCK_CHECKSUM, Keywords
- DB_BLOCK_LRU_EXTENDED_STATISTICS parameter, DB_BLOCK_LRU_EXTENDED_STATISTICS
- DB_BLOCK_LRU_LATCHES parameter, DB_BLOCK_LRU_LATCHES
- DB_BLOCK_LRU_STATISTICS parameter, DB_BLOCK_LRU_STATISTICS
- DB_BLOCK_MAX_DIRTY_TARGET parameter (ALTER SYSTEM), DB_BLOCK_MAX_DIRTY_TARGET (Oracle8 Only), Keywords
- DB_BLOCK_SIZE parameter, Choosing a blocksize, Creating the parameter file, Database buffer cache, Oracle Tablespaces, Oracle Blocks, DB_BLOCK_SIZE
- DB_DOMAIN parameter, DB_DOMAIN
- DB_FILE_DIRECT_IO_COUNT parameter, DB_FILE_DIRECT_IO_COUNT (Oracle8 Only)
- DB_FILE_MULTIBLOCK_READ_COUNT parameter, Initialization Parameters, DB_FILE_MULTIBLOCK_READ_COUNT
- DB_FILE_MULTIBLOCK_READ_COUNT parameter
- DB_FILE_NAME_CONVERT parameter, DB_FILE_NAME_CONVERT (Oracle8 Only)
- DB_FILE_SIMULTANEOUS_WRITES parameter, DB_FILE_SIMULTANEOUS_WRITES
- DB_FILE_STANDBY_NAME_CONVERT parameter, DB_FILE_STANDBY_NAME_CONVERT (Oracle7 Only)
- DB_FILES parameter, Creating the parameter file, Program Global Area (PGA), DB_FILES
- DB_NAME parameter, Choosing the name, Creating the parameter file, DB_NAME
- DB_WRITERS parameter, DB_WRITERS (Oracle7 Only)
- DBA job description, Oracle Database Administration–A DBA Job Description
- DBA privilege shortcut, System Privilege Auditing
- DBA role, Automatic Roles
- DBA_2PC_NEIGHBORS view, Net8
- DBA_2PC_PENDING view, Net8
- DBA_ALL_TABLES view, Tables, clusters, and views
- DBA_AUDIT_EXISTS view, Views containing audit trail information, Audit trail
- DBA_AUDIT_OBJECT view, Views containing audit trail information, Audit trail
- DBA_AUDIT_SESSION view, Views containing audit trail information, Audit trail
- DBA_AUDIT_STATEMENT view, Views containing audit trail information, Audit trail
- DBA_AUDIT_TRAIL view, Views containing audit trail information, Audit trail
- DBA_BLOCKERS view, Locks
- DBA_CATALOG view, Dictionary
- DBA_CLUSTERS view, Tables, clusters, and views
- DBA_CLUSTER_HASH_EXPRESSIONS view, Tables, clusters, and views
- DBA_CLU_COLUMNS view, Tables, clusters, and views
- DBA_COL_COMMENTS view, Tables, clusters, and views
- DBA_COL_PRIVS view, Security
- DBA_COLL_TYPES view, Objects Option
- DBA_CONSTRAINTS view, Constraints
- DBA_CONS_COLUMNS view, Constraints
- DBA_DATA_FILES view, Storage
- DBA_DB_LINKS view, Net8
- DBA_DDL_LOCKS view, Locks
- DBA_DEPENDENCIES view, Dictionary
- DBA_DIRECTORIES view, Large objects (LOBs)
- DBA_DML_LOCKS view, Locks
- DBA_ERRORS view, PL/SQL
- DBA_EXP_FILES view, Using the EXP tables
- DBA_EXP_OBJECTS view, Using the EXP tables
- DBA_EXP_VERSION view, Using the EXP tables
- DBA_EXTENTS view, Storage
- DBA_FREE_SPACE view, Storage
- DBA_FREE_SPACE_COALESCED view, Storage
- DBA_IND_PARTITIONS view, Partitioning
- DBA_INDEXES view, ANALYZE INDEX, Indexes
- DBA_IND_COLUMNS view, Indexes
- DBA_KGLLOCK view, Locks
- DBA_LIBRARIES view, PL/SQL
- DBA_LOBS view, Large objects (LOBs)
- DBA_LOCKS view, Locks
- DBA_LOCK_INTERNAL view, Locks
- DBA_METHOD_PARAMS view, Objects Option
- DBA_METHOD_RESULTS view, Objects Option
- DBA_NESTED_TABLES view, Objects Option
- DBA_OBJECT_SIZE view, PL/SQL
- DBA_OBJECT_TABLES view, Objects Option
- DBA_OBJECTS view, Dictionary
- DBA_OBJ_AUDIT_OPTS view, Views containing auditing specifications, Audit trail
- DBA_PART_COL_STATISTICS view, ANALYZE TABLE . . . STATISTICS FOR COLUMNS, Partitioning
- DBA_PART_HISTOGRAMS view, Partitioning
- DBA_PART_INDEXES view, Partitioning
- DBA_PART_KEY_COLUMNS view, Partitioning
- DBA_PART_TABLES view, Partitioning
- DBA_PENDING_TRANSACTIONS view, Net8
- DBA_PRIV_AUDIT_OPTS view, Views containing auditing specifications, Audit trail
- DBA_PROFILES view, Security
- DBA_QUEUE_SCHEDULES view, Advanced Queuing
- DBA_QUEUE_TABLES view, Advanced Queuing
- DBA_QUEUES view, Advanced Queuing
- DBA_REFS view, Objects Option
- DBA_ROLES view, Security
- DBA_ROLE_PRIVS view, Security
- DBA_ROLLBACK_SEGS view, Storage
- DBA_SEGMENTS view, Storage
- DBA_SEQUENCES view, Sequences
- DBA_SOURCE view, PL/SQL
- DBA_STMT_AUDIT_OPTS view, Views containing auditing specifications, Audit trail
- DBA_SYNONYMS, Synonyms
- DBA_SYS_PRIVS view, Security
- DBA_TAB_COL_STATISTICS view, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- DBA_TAB_COLUMNS view, ANALYZE TABLE . . . STATISTICS FOR COLUMNS, Tables, clusters, and views
- DBA_TAB_COMMENTS view, Tables, clusters, and views
- DBA_TAB_HISTOGRAMS view, Tables, clusters, and views
- DBA_TAB_PARTITIONS view, Partitioning
- DBA_TAB_PRIVS view, Security
- DBA_TABLES view, ANALYZE TABLE, Tables, clusters, and views
- DBA_TABLESPACES view, Storage
- DBA_TAB_COL_STATISTICS view, Tables, clusters, and views
- DBA_TRIGGERS view, PL/SQL
- DBA_TRIGGER_COLS view, PL/SQL
- DBA_TS_QUOTAS view, Storage
- DBA_TYPES view, Objects Option
- DBA_TYPE_ATTRS view, Objects Option
- DBA_TYPE_METHODS view, Objects Option
- DBA_UPDATABLE_COLUMNS view, Tables, clusters, and views
- DBA_USERS view, Security
- DBA_VIEWS view, Tables, clusters, and views
- DBA_WAITERS view, Locks
- DBLINK_ENCRYPT_LOGIN parameter, DBLINK_ENCRYPT_LOGIN
- DBMS_ JOBS package, Jobs
- DBMS_LOCK_ALLOCATED view, Locks
- DBSNMP user, Summary of Initial Users
- DBWR (Database Writer) process, DBWR—the Database Writer
- DBWR_IO_SLAVES parameter, DBWR_IO_SLAVES (Oracle8 Only)
- DCE CDS Naming Adapter, DCE naming adapter
- DCE (Distributed Computing Environment), DCE integration
- DEALLOCATE UNUSED parameter
- DEBUG parameter (ALTER TRIGGER), Keywords
- DEFAULT clause (CONSTRAINT), Keywords
- DEFAULT parameter
- ALTER TABLE comma, Keywords
- AUDIT command (schema objects), Schema Object Auditing, Keywords
- DEFAULT user profile, Default profile
- DEFAULT value, Resource control, ALTER PROFILE , CREATE PROFILE
- DEFAULT ROLE parameter
- DEFAULT STORAGE parameter, Tables
- DEFAULT TABLESPACE parameter
- DEFAULTIF parameter (SQL*Loader), Control File Syntax
- DEFERRABLE clause
- column_constraint_clause parameter, column_constraint_clause
- table_constraint_clause parameter, table_constraint_clause
- DEFERRED clause (CONSTRAINT, ALTER SESSION), Keywords
- DEF[INE] command (SQL*Plus), DEFINE, DEFINE
- DEGREE clause (PARALLEL), Keywords, Keywords
- (see also PARALLEL parameter)
- DEL command (SQL*Plus), DEL
- DELAYED_LOGGING_BLOCK_CLEANOUTS parameter, DELAYED_LOGGING_BLOCK_CLEANOUTS
- DELETE ANY TABLE privilege, Summary of System Privileges
- DELETE_CATALOG_ROLE role, Automatic Roles
- DELETE clause (INSTEAD OF), Keywords
- DELETE privilege, Object Privileges
- DELETE STATISTICS parameter
- DELETE TABLE auditing shortcut, Statement Auditing
- DENSITY column, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- dependencies of Oracle components, Dependencies
- DESC[RIBE] command (SQL*Plus), DESCRIBE
- DESTROY= parameter (IMP), Import Parameters
- development tools, Oracle, Development Tools
- DICTIONARY view, Dictionary
- DICT_COLUMNS view, Dictionary
- digital certificates, Network security
- digital signatures, Network security
- DIRECT= parameter (EXP), Export Parameters
- DIRECT parameter (SQL*Loader), Command-Line Syntax
- direct path export method, Direct path versus conventional path
- direct path loading, Conventional and Direct Path Loading
- directive structure, Oracle Directory Structure
- DIRECTORY auditing shortcut, Statement Auditing
- DIRECTORY parameter (GRANT), Keywords
- DISABLE COMMIT IN PROCEDURE parameter (ALTER SESSION), Keywords
- DISABLE DISTRIBUTED RECOVERY parameter (ALTER SYSTEM), Keywords
- DISABLE clause (column_constraint_clause), column_constraint_clause
- DISABLE parameter
- ALTER TABLE command, Keywords
- ALTER TRIGGER command, Keywords
- CREATE TABLE command, Keywords
- table_constraint_clause (CREATE TABLE), table_constraint_clause
- DISABLE PARALLEL DML parameter (ALTER SESSION), Keywords
- DISABLE RESTRICTED SESSION parameter (ALTER SYSTEM), Keywords
- DISABLE TABLE LOCK parameter (ALTER TABLE), Keywords
- discard file, SQL*Loader, SQL*Loader Files
- DISCARD parameter (SQL*Loader), Command-Line Syntax , Control File Syntax
- DISCARDDN parameter (SQL*Loader), Control File Syntax
- DISCARDFILE parameter (SQL*Loader), Control File Syntax
- DISCARDMAX parameter (SQL*Loader), Command-Line Syntax , Control File Syntax
- DISC[ONNECT] command (SQL*Plus), DISCONNECT
- DISCONNECT SESSION parameter (ALTER SYSTEM), Keywords
- DISCRETE_TRANSACTIONS_ENABLED parameter, DISCRETE_TRANSACTIONS_ENABLED
- DISK_ASYNCH_IO parameter, DISK_ASYNCH_IO (Oracle8 Only)
- disk I/O
- layout of, Disk layout
- mirroring, A note about RAID
- recovery from disk failure, Disk failure
- resource allocation and, Disk Allocation–About RAID
- tuning, Disk I/O
- disk space (see storage)
- Dispatcher (Dnnn) processes, Dnnn—the Dispatcher process
- DISTINCT_KEYS column, ANALYZE INDEX
- Distributed Computing Environment (DCE), DCE integration
- DISTRIBUTED_LOCK_TIMEOUT parameter, DISTRIBUTED_LOCK_TIMEOUT
- DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME parameter, DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME
- DISTRIBUTED_TRANSACTIONS parameter, DISTRIBUTED_TRANSACTIONS
- DML_LOCKS parameter, DML_LOCKS
- documentation on Oracle, Check the documentation
- down time, planning for, Availability
- DRIVING_SITE hint, Join operation hints
- DROP ANY CLUSTER privilege, Summary of System Privileges
- DROP ANY DIRECTORY privilege, Summary of System Privileges
- DROP ANY INDEX privilege, Summary of System Privileges
- DROP ANY LIBRARY privilege, Summary of System Privileges
- DROP ANY PROCEDURE privilege, Summary of System Privileges
- DROP ANY ROLE privilege, Summary of System Privileges
- DROP ANY SEQUENCE privilege, Summary of System Privileges
- DROP ANY SNAPSHOT privilege, Summary of System Privileges
- DROP ANY SYNONYM privilege, Summary of System Privileges
- DROP ANY TABLE privilege, Summary of System Privileges
- DROP ANY TRIGGER privilege, Summary of System Privileges
- DROP ANY TYPE privilege, Summary of System Privileges
- DROP ANY VIEW privilege, Summary of System Privileges
- DROP CLUSTER command, DROP CLUSTER
- DROP CONSTRAINT parameter (ALTER TABLE), Keywords
- DROP DATABASE LINK command, DROP DATABASE LINK
- DROP DIRECTORY command, DROP DIRECTORY
- DROP FUNCTION command, DROP FUNCTION
- DROP INDEX command, DROP INDEX
- DROP LIBRARY command, DROP LIBRARY
- DROP PACKAGE command, DROP PACKAGE
- DROP PARTITION parameter
- DROP PRIMARY KEY parameter (ALTER TABLE), Keywords
- DROP PROCEDURE command, DROP PROCEDURE
- DROP PROFILE command, DROP PROFILE
- DROP PROFILE privilege, Summary of System Privileges
- DROP PUBLIC DATABASE LINK privilege, Summary of System Privileges
- DROP PUBLIC SYNONYM privilege, Summary of System Privileges
- DROP ROLE command, DROP ROLE
- DROP ROLLBACK SEGMENT command, DROP ROLLBACK SEGMENT
- DROP ROLLBACK SEGMENT privilege, Summary of System Privileges
- DROP SEQUENCE command, DROP SEQUENCE
- DROP SNAPSHOT command, DROP SNAPSHOT
- DROP SNAPSHOT LOG command, DROP SNAPSHOT LOG
- DROP STORAGE parameter
- DROP SYNONYM command, DROP SYNONYM
- DROP TABLE command, DROP TABLE
- DROP TABLESPACE command, DROP TABLESPACE
- DROP TABLESPACE privilege, Summary of System Privileges
- DROP TRIGGER command, DROP TRIGGER
- DROP UNIQUE parameter (ALTER TABLE), Keywords
- DROP USER command, DROP USER
- DROP USER privilege, Summary of System Privileges
- DROP VIEW command, DROP VIEW
- dynamic performance data dictionary views (see GV$ views V$ views)
- dynamically modifiable initialization parameters, Dynamically Modifiable Parameters–Dynamically Modifiable Parameters
E
- Easy Config utility (Net8), SQL*Net Troubleshooting
- EBU (Enterprise Backup Utility), Oracle Enterprise Backup Utility
- ECHO command (SQL*Plus), ECHO
- EDIT command (SQL*Plus), EDIT
- EDITF[ILE] command (SQL*Plus), EDITFILE
- EMB[EDDED] command (SQL*Plus), EMBEDDED
- EMPTY_BLOCKS column, ANALYZE TABLE
- ENABLE ALL TRIGGERS parameter (CREATE TABLE), Keywords
- ENABLE COMMIT IN PROCEDURE parameter (ALTER SESSION), Keywords
- ENABLE CONSTRAINT parameter (CREATE TABLE), Keywords
- ENABLE DISTRIBUTED RECOVERY parameter (ALTER SYSTEM), Keywords
- ENABLE clause (column_constraint_clause, CREATE TABLE), column_constraint_clause
- ENABLE parameter
- ALTER TABLE command, Keywords
- ALTER TRIGGER command, Keywords
- table_constraint_clause parameter, table_constraint_clause
- ENABLE PARALLEL DML parameter (ALTER SESSION), Keywords
- ENABLE PRIMARY KEY parameter (CREATE TABLE), Keywords
- ENABLE RESTRICTED SESSION parameter (ALTER SYSTEM), Keywords
- ENABLE TABLE LOCK parameter (ALTER TABLE), Keywords
- ENABLE UNIQUE parameter (CREATE TABLE), Keywords
- encryption, Network security
- END BACKUP parameter (ALTER TABLESPACE), Keywords
- ENQUEUE_RESOURCES parameter, ENQUEUE_RESOURCES
- Enterprise Backup Utility (EBU), Oracle Enterprise Backup Utility
- Enterprise Server version of Oracle, Base Product
- ENTRY value (FLAGGER, ALTER SESSION), Keywords
- environment, data dictionary views for, System environment
- ERRORS parameter (SQL*Loader), Command-Line Syntax
- ESC[APE] command (SQL*Plus), ESCAPE
- ESTIMATE clause (ANALYZE TABLE), ESTIMATE versus COMPUTE
- ESTIMATE STATISTICS parameter
- Event Management System (OEM), Oracle Enterprise Manager
- EVENT parameter, EVENT
- EXCEPTIONS INTO clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- EXCEPTIONS view, Others
- EXCHANGE PARTITION parameter (ALTER TABLE), Keywords
- EXCLUDING INDEXES clause (EXCHANGE PARTITION), Keywords
- EXCLUSIVE parameter (ALTER DATABASE MOUNT), Keywords
- EXECUTE ANY LIBRARY privilege, Summary of System Privileges
- EXECUTE ANY PROCEDURE privilege, Summary of System Privileges
- EXECUTE ANY TYPE privilege, Summary of System Privileges
- EXECUTE_CATALOG_ROLE role, Automatic Roles
- EXE[CUTE] command (SQL*Plus), EXECUTE
- EXECUTE privilege, Object Privileges
- EXECUTE PROCEDURE auditing shortcut, Statement Auditing
- EXIT command (SQL*Plus), EXIT
- EXP (Export) utility, Export/import, EXPort/IMPort–Other uses for Export, ANALYZE TABLE . . . STATISTICS FOR COLUMNS, Export
- basic reference, Export–Export Parameters
- practice scenarios, Export/Import
- EXPLAIN PLAN command, The EXPLAIN PLAN Statement, EXPLAIN PLAN
- Top Session monitor for, Oracle Enterprise Manager Top Sessions
- EXPLAIN PLAN command (SQL*Plus), Query processing
- EXPLAIN_PLAN process, Others
- Export utility, Export/import, EXPort/IMPort–Other uses for Export, ANALYZE TABLE . . . STATISTICS FOR COLUMNS, Export
- basic reference, Export–Export Parameters
- practice scenarios, Export/Import
- EXP_FULL_DATABASE role, Optional Roles
- extents, Logical Database Structures, How Oracle Allocates Storage
- multiple, Sizing and Configuring Database Objects
F
- FAILED_LOGIN_ATTEMPTS parameter, Password control
- FALSE value (SORT_DIRECT_WRITES)
- families of data dictionary views, Families of Views
- FAST_FULL_SCAN_ENABLED parameter, Initialization Parameters, FAST_FULL_SCAN_ENABLED
- FDSs (foreign data sources), Gateways
- FEED[BACK] command (SQL*Plus), FEEDBACK
- FEEDBACK= parameter (EXP), Export Parameters
- FEEDBACK= parameter (IMP), Import Parameters
- FIELDS parameter (SQL*Loader), Control File Syntax
- FILE= parameter (EXP), Export Parameters
- FILE= parameter (IMP), Import Parameters
- FILE parameter (SQL*Loader), Command-Line Syntax
- files, Files
- operating system files, Types of Database Files–Data Storage Files
- data storage files, Data Storage Files
- database coordination files, Database Coordination Files–Redo log files
- parameter storage files, Parameter Storage Files–Configuration file
- SQL*Loader-related, SQL*Loader Files
- filespec parameter (CREATE DATABASE), Keywords
- filesystem structure, Oracle Directory Structure
- FIRST_ROWS value (OPTIMIZER_MODE), Goal hints, Keywords
- fixed block header, Fixed block header
- FIXED_DATE parameter (ALTER SYSTEM), FIXED_DATE, Keywords
- FLAGGER command (SQL*Plus), FLAGGER
- FLAGGER parameter (ALTER SESSION), Keywords
- FLU[SH] command (SQL*Plus), FLUSH
- FLUSH SHARED POOL parameter (ALTER SYSTEM), Keywords
- FOR ALL COLUMNS clause (ANALYZE TABLE), for_clause
- FOR ALL INDEXES clause (ANALYZE TABLE), for_clause
- for_clause parameter (ANALYZE TABLE), Keywords
- FOR COLUMNS clause (ANALYZE TABLE), for_clause
- FOR EACH ROW parameter (CREATE TRIGGER), Keywords
- FOR parameter
- FOR TABLE clause (ANALYZE TABLE), for_clause
- FOR UPDATE parameter (CREATE SNAPSHOT), Keywords
- FORCE ANY TRANSACTION privilege, Summary of System Privileges
- FORCE parameter
- FORCE PARALLEL DML parameter (ALTER SESSION), Keywords
- FORCE TRANSACTION privilege, Summary of System Privileges
- foreign data sources (FDSs), Gateways
- FOREIGN KEY clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- fragmented tablespaces, Sizing and Configuring Database Objects
- free block lists, Free lists
- FREELIST GROUPS clause, Keywords, Keywords
- (see also DEFAULT STORAGE parameter; STORAGE parameter)
- FREELISTS clause, Keywords, Keywords
- (see also DEFAULT STORAGE parameter; STORAGE parameter)
- FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY parameter (ALTER SYSTEM), FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY (Oracle8 Only), Keywords
- FROMUSER= parameter (IMP), Import Parameters
- full backups, Limitations
- full exports, Using incremental exports
- FULL hint, Access method hints
- FULL= parameter (EXP), Export Parameters
- FULL= parameter (IMP), Import Parameters
- FULL value (FLAGGER, ALTER SESSION), Keywords
G
- gateways, Gateways, Gateways
- GC_DB_LOCKS parameter, Parallel Server Configuration, GC_DB_LOCKS (Oracle7 Only)
- GC_DEFER_TIME parameter (ALTER SYSTEM), GC_DEFER_TIME (Oracle8 Only), Keywords
- GC_FILES_TO_LOCKS parameter, Parallel Server Configuration, GC_FILES_TO_LOCKS
- GC_LCK_PROCS parameter, Parallel Server Configuration, GC_LCK_PROCS
- GC_RELEASABLE_LOCKS parameter, GC_RELEASABLE_LOCKS
- GC_ROLLBACK_LOCKS parameter, Parallel Server Configuration, GC_ROLLBACK_LOCKS
- GC_ROLLBACK_SEGMENTS parameter, GC_ROLLBACK_SEGMENTS (Oracle7 Only)
- GC_SAVE_ROLLBACK_LOCKS parameter, Parallel Server Configuration, GC_SAVE_ROLLBACK_LOCKS (Oracle7 Only)
- GC_SEGMENTS parameter, Parallel Server Configuration, GC_SEGMENTS (Oracle7 Only)
- GC_TABLESPACES parameter, GC_TABLESPACES (Oracle7 Only)
- GET command (SQL*Plus), GET
- global_index_clause parameter (CREATE INDEX), Partitioned tables
- GLOBAL_NAME view, Net8
- global names (service names), Oracle services, Oracle Names
- GLOBAL_NAMES parameter, GLOBAL_NAMES
- GLOBAL keyword (CREATE INDEX), Partitioned tables
- GLOBAL value
- global_index_clause parameter (CREATE INDEX), Keywords, global_index_clause
- goal hints, Goal hints
- GRANT ANY PRIVILEGE privilege, Summary of System Privileges
- GRANT ANY ROLE privilege, Roles, Summary of System Privileges
- GRANT DIRECTORY auditing shortcut, Statement Auditing
- GRANT command (object privileges), GRANT (Object Privileges)
- GRANT command (system privileges, roles), GRANT (System Privilege or Role)
- GRANT parameter (CREATE SCHEMA), Keywords
- GRANT PROCEDURE auditing shortcut, Statement Auditing
- GRANT SEQUENCE auditing shortcut, Statement Auditing
- GRANT TABLE auditing shortcut, Statement Auditing
- GRANT TYPE auditing shortcut, Statement Auditing
- GRANTS= parameter (EXP), Export Parameters
- GRANTS= parameter (IMP), Import Parameters
- GROUP clause (ARCHIVE_LOG), Keywords
- group commits, LGWR—the Log Writer
- GV$ views, The Global Dynamic Performance Data Dictionary Views (GV$ Views)
H
- HASH_AJ hint, Access method hints
- HASH_AREA_SIZE parameter (ALTER SESSION), Initialization Parameters, HASH_AREA_SIZE, Keywords
- HASH IS parameter (CREATE CLUSTER), Keywords
- HASH_JOIN_ENABLED parameter (ALTER SESSION), Initialization Parameters, HASH_JOIN_ENABLED, Keywords
- hash joins, Hash Joins
- HASH_MULTIBLOCK_IO_COUNT parameter, Initialization Parameters, HASH_MULTIBLOCK_IO_COUNT
- HASH hint, Access method hints
- HASH_SJ hint, Access method hints
- HASHKEYS parameter (CREATE CLUSTER), Keywords
- headers of datafiles, updating, CKPT—the Checkpoint process
- HEA[DING] command (SQL*Plus), HEADING
- HEADS[EP] command (SQL*Plus), HEADSEP
- HELP command (SQL*Plus), HELP
- HELP= parameter (EXP), Export Parameters
- HELP= parameter (IMP), Import Parameters
- highwater mark, The highwater mark
- HIGH_VALUE column, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- hints, specifying, Specifying Hints
- histograms for ANALYZE TABLE command, ANALYZE TABLE . . . STATISTICS FOR COLUMNS–Script to automate the ANALYZE process
- hit/miss ratio, Database buffer cache
- HO[ST] command (SQL*Plus), HOST
- hot (online) backups, Hot backup, Hot Backup
- practice scenarios, Hot or Cold Backups
- hot standby database, Hot standby database
- HS_ADMIN_ROLE role, Optional Roles
I
- I (INPUT) command (SQL*Plus), INPUT
- I/O system
- disk resource allocation and, Disk Allocation–About RAID
- layout of, Disk layout
- recovery from disk failure, Disk failure
- tuning, Disk I/O
- IDENTIFIED BY clause (CONNECT TO), Keywords
- IDENTIFIED BY parameter
- ALTER ROLE command, Password-enabled roles, Keywords
- ALTER USER command, Keywords
- CREATE ROLE command, Password-enabled roles, Keywords
- CREATE USER command, Keywords
- SET ROLE command, Keywords
- IDENTIFIED EXTERNALLY parameter
- IDENTIFIED GLOBALLY parameter
- IDLE_TIME parameter
- IDLE_TIME resource limit, Resource control
- IFILE parameter, IFILE
- IGNORE= parameter (IMP), Import Parameters
- Image Cartridge, Data Cartridges
- IMMEDIATE clause (CONSTRAINT, ALTER SESSION), Keywords
- IMMEDIATE value (OFFLINE, ALTER TABLESPACE), Keywords
- IMP (Import) utility, Export/import, EXPort/IMPort, ANALYZE TABLE . . . STATISTICS FOR COLUMNS, Export
- basic reference, Import–Import Parameters
- IMP_FULL_DATABASE role, Optional Roles
- IN parameter
- IN OUT parameter (CREATE PROCEDURE), Keywords
- INCLUDING CONTENTS parameter (DROP TABLESPACE), Keywords
- INCLUDING INDEXES clause (EXCHANGE PARTITION, ALTER TABLE), Keywords
- INCLUDING clause (index_organization_clause, CREATE TABLE), index_organization_clause
- INCLUDING TABLES parameter (DROP CLUSTER), Keywords
- INCREMENT BY parameter
- incremental backups, Incremental Backups
- incremental exports, Using incremental exports
- INCTYPE parameter, Using incremental exports
- INCTYPE= parameter (EXP), Export Parameters
- INCTYPE= parameter (IMP), Import Parameters
- INDEX_ASC hint, Access method hints
- INDEX_COMBINE hint, Access method hints
- INDEX_DESC hint, Access method hints
- INDEX_FFS hint, Access method hints
- INDEX_HISTOGRAM view, Indexes
- INDEX auditing shortcut, Statement Auditing
- INDEX hint, Access method hints
- index-only tables, Index-only tables
- INDEX parameter (CREATE CLUSTER), Keywords
- INDEX privilege, Object Privileges
- index_organization_clause parameter (CREATE TABLE), Keywords, index_organization_clause
- INDEX tablespace, disk allocation, Disk Layout
- INDEX_STATS view, Indexes
- indexes, Logical Database Structures
- bitmap indexes, Bitmap indexes
- configuring and sizing, Indexes
- corrupted, Database corruption
- data dictionary views for, Indexes
- disabling redo logs, Unrecoverable operations–Unrecoverable operations
- INDEXES= parameter (EXP), Export Parameters
- INDEXES= parameter (IMP), Import Parameters
- INDEXFILE= parameter (IMP), Import Parameters
- INIT.ORA (initialization) file, Files, Initialization file
- creating, Creating the parameter file
- parameters for, Initialization Parameters–Parameters New in Oracle8
- initial (starter) database, The Starter Database
- INITIAL clause
- initial roles, Initial Roles
- initial users, Initial Users–Cross-Reference: System Privileges Assigned to Initial Users
- roles assigned to (list), Cross-Reference: Roles Assigned to Initial Users
- system privileges of (list), Cross-Reference: System Privileges Assigned to Initial Users–Cross-Reference: System Privileges Assigned to Initial Users
- initialization
- CBO (cost-based optimizer), Initialization Parameters–Initialization Parameters
- parameters for, Initialization Parameters–Parameters New in Oracle8
- dynamically modifiable (list), Dynamically Modifiable Parameters–Dynamically Modifiable Parameters
- list of, Summary of Initialization Parameters–UTL_FILE_DIR
- Oracle7-only (list), Parameters Used Only in Oracle7
- Oracle8-only (list), Parameters New in Oracle8
- initialization (INIT.ORA) file, Files, Initialization file
- creating, Creating the parameter file
- parameters for, Initialization Parameters–Parameters New in Oracle8
- INITIALLY DEFERRED clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- INITIALLY IMMEDIATE clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- INITRANS parameter, Tables
- ALTER CLUSTER command, Keywords
- ALTER INDEX command, Keywords
- ALTER INDEX REBUILD command, Keywords, Keywords
- ALTER SESSION command, Keywords
- ALTER SNAPSHOT LOG command, Keywords
- ALTER TABLE command, Keywords
- CREATE CLUSTER command, Keywords
- CREATE INDEX command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE SNAPSHOT LOG command, Keywords
- CREATE TABLE command, Fixed block header
- segment_attrib_clause (CREATE TABLE), segment_attrib_clause
- USING INDEX clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- INPUT command (SQL*Plus), INPUT
- INSERT ANY TABLE privilege, Summary of System Privileges
- INSERT clause (INSTEAD OF), Keywords
- INSERT parameter (SQL*Loader), Control File Syntax
- INSERT privilege, Object Privileges
- INSERT TABLE auditing shortcut, Statement Auditing
- installing Oracle, Installation–A sample script
- component selection, Installable Components
- critical decisions for, Critical Decisions–Oracle Directory Structure
- orainst utility, The Oracle Installer
- post-installation tasks, Post-Installation Tasks–A sample script
- pre-installation checklist, Pre-Installation Checklist
- selecting installation medium, Media Selection
- INSTANCE_GROUPS parameter, Parallel Server Configuration, INSTANCE_GROUPS (Oracle8 Only)
- INSTANCE_NUMBER parameter, INSTANCE_NUMBER
- INSTANCE_NUMBER parameter, Parallel Server Configuration
- INSTANCE clause (ALLOCATE EXTENT parameter), Keywords, Keywords
- INSTANCE parameter (ALTER SESSION), Keywords
- instances, Database Versus Instance, The Oracle Instance–Sort Areas
- database coordination files for, Database Coordination Files–Redo log files
- databases vs., The Oracle Instance, The Oracle Instance
- (see also databases)
- elements of, Elements of the Instance
- files for, Files
- memory structures, About Memory Structures–Sort Areas
- naming, Choosing the name
- processes, About Processes–Multi-Threaded Server
- tuning, Oracle Instance Tuning–Oracle striping
- V$ views for, Instance
- INSTANCES clause (PARALLEL), Keywords, Keywords
- (see also PARALLEL parameter)
- INSTEAD OF parameter (CREATE TRIGGER), Keywords
- intchg.ora file, Files Created by Network Manager
- intctl program, MultiProtocol Interchange
- integrity, data, DCE integration
- INTERMEDIATE value (FLAGGER, ALTER SESSION), Keywords
- INTO parameter (EXPLAIN PLAN), Keywords
- INTO TABLE parameter (SQL*Loader), Control File Syntax
- IPX/SPX protocol, Determine basic client connectivity
- ISOLATION_LEVEL parameter
J
- JOB_QUEUE_INTERVAL parameter, JOB_QUEUE_INTERVAL
- Job Queue processes, SNPn—the Job Queue process
- JOB_QUEUE_PROCESSES parameter (ALTER SYSTEM), SNPn—the Job Queue process, JOB_QUEUE_PROCESSES, Keywords
- Job Scheduling System (OEM), Oracle Enterprise Manager
- JOBS view, Jobs
- jobs, data dictionary views for, Jobs
- JOBS_RUNNING view, Jobs
- joins, Joins
- join operation hints, Join operation hints
- join order hints, Join order hints
- types of access paths, Types of Join Access Paths
K
L
- L (LIST) command (SQL*Plus), LIST
- large objects (LOBs), data dictionary views for, Large objects (LOBs)
- LARGE_POOL_MIN_ALLOC parameter, LARGE_POOL_MIN_ALLOC (Oracle8 Only)
- LARGE_POOL_SIZE parameter, LARGE_POOL_SIZE (Oracle8 Only)
- LAST parameter (SQL*Loader), Control File Syntax
- LAST_ANALYZED column, ANALYZE TABLE, ANALYZE INDEX, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- latches, V$ views for, Locks and latches–Locks and latches
- LCKn (Lock) process, LCKn—the Lock process
- LEAF_BLOCKS column, ANALYZE INDEX
- LGWR (Log Writer) process, LGWR—the Log Writer, Redo log files
- LGWR_IO_SLAVES parameter, LGWR_IO_SLAVES (Oracle8 Only)
- library cache, Library cache.
- LICENSE_MAX_SESSIONS parameter (ALTER SYSTEM), LICENSE_MAX_SESSIONS, Keywords
- LICENSE_MAX_USERS parameter (ALTER SYSTEM), LICENSE_MAX_USERS, Keywords
- LICENSE_SESSIONS_WARNING parameter (ALTER SYSTEM), LICENSE_SESSIONS_WARNING, Keywords
- licensing Oracle, Licensing by the User
- LIN[ESIZE] command (SQL*Plus), LINESIZE
- LIST CHAINED ROWS parameter
- LIST command (SQL*Plus), LIST
- listener, MPI, MultiProtocol Interchange
- listener.ora file, SQL*Net Configuration, Files Created by Network Manager, listener.ora
- LM_LOCKS parameter, Parallel Server Configuration, LM_LOCKS (Oracle8 Only)
- LM_PROCS parameter, Parallel Server Configuration, LM_PROCS (Oracle8 Only)
- LM_RESS parameter, Parallel Server Configuration, LM_RESS (Oracle8 Only)
- LOAD parameter (SQL*Loader), Command-Line Syntax , Control File Syntax
- LOBOF[FSET] command (SQL*Plus), LOBOFFSET
- LOBs, data dictionary views for, Large objects (LOBs)
- local_index_clause parameter (CREATE INDEX), Partitioned tables, Keywords, local_index_clause
- LOCAL_LISTENER parameter, LOCAL_LISTENER (Oracle8 Only)
- LOCAL keyword (CREATE INDEX), Partitioned tables
- LOCAL value
- location transparency, SQL*Net functionality
- Lock (LCKn) process, LCKn—the Lock process
- LOCK ANY TABLE privilege, Summary of System Privileges
- LOCK_NAME_SPACE parameter, LOCK_NAME_SPACE (Oracle8 Only)
- LOCK TABLE auditing shortcut, Statement Auditing
- locks, data dictionary views for, Locks, Locks and latches–Locks and latches
- LOG_ARCHIVE_BUFFER_SIZE parameter, LOG_ARCHIVE_BUFFER_SIZE
- LOG_ARCHIVE_BUFFERS parameter, LOG_ARCHIVE_BUFFERS
- LOG_ARCHIVE_DEST parameter, LOG_ARCHIVE_DEST
- LOG_ARCHIVE_DUPLEX_DEST parameter (ALTER SYSTEM), LOG_ARCHIVE_DUPLEX_DEST (Oracle8 Only), Keywords
- LOG_ARCHIVE_FORMAT parameter, LOG_ARCHIVE_FORMAT
- LOG_ARCHIVE_MIN_SUCCEED_DEST parameter (ALTER SYSTEM), LOG_ARCHIVE_MIN_SUCCEED_DEST (Oracle8 Only), Keywords
- LOG_ARCHIVE_START parameter, LOG_ARCHIVE_START
- LOG_BLOCK_CHECKSUM parameter, LOG_BLOCK_CHECKSUM
- LOG_BUFFER parameter, Memory utilization, Redo log buffer, LOG_BUFFER
- LOG_CHECKPOINT_INTERVAL parameter (ALTER SYSTEM), Redo Logs, LOG_CHECKPOINT_INTERVAL, Keywords
- LOG_CHECKPOINT_TIMEOUT parameter (ALTER SYSTEM), LOG_CHECKPOINT_TIMEOUT, Keywords
- LOG_CHECKPOINTS_TO_ALERT parameter, LOG_CHECKPOINTS_TO_ALERT
- LOG_FILE_NAME_CONVERT parameter, LOG_FILE_NAME_CONVERT (Oracle8 Only)
- LOG_FILE_STANDBY_NAME_CONVERT parameter, LOG_FILE_STANDBY_NAME_CONVERT (Oracle7 Only)
- log files, Files, Redo log files–Redo log files
- archive (offline redo) logs, Archivelog mode, Archive Log Destination, Archivelog Mode, ARCH—the Archiver process
- buffer space for, Memory utilization
- online redo logs, Redo Logs
- performance (log waits), Sizing and Configuring Database Objects
- redo log buffer, Redo log buffer
- SQL*Loader, SQL*Loader Files
- unrecoverable operations, Unrecoverable operations
- writing to, LGWR—the Log Writer
- LOG_FILES parameter, Program Global Area (PGA), LOG_FILES
- LOG= parameter (EXP), Export Parameters
- LOG= parameter (IMP), Import Parameters
- LOG parameter (SQL*Loader), Command-Line Syntax
- LOG_SIMULTANEOUS_COPIES parameter, LOG_SIMULTANEOUS_COPIES
- LOG_SMALL_ENTRY_MAX_SIZE parameter (ALTER SYSTEM), LOG_SMALL_ENTRY_MAX_SIZE, Keywords
- Log Writer (LGWR) process, LGWR—the Log Writer, Redo log files
- LOGFILE clause (ARCHIVE_LOG, ALTER SYSTEM), Keywords
- LOGFILE parameter
- LOGGING parameter
- ALTER INDEX command, Keywords
- ALTER INDEX REBUILD command, Keywords
- ALTER INDEX REBUILD PARTITION command, Keywords
- ALTER SESSION command, Keywords
- ALTER TABLE command, Keywords
- ALTER TABLESPACE command, Keywords
- CREATE INDEX command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE TABLESPACE command, Keywords
- segment_attrib_clause (CREATE TABLE), segment_attrib_clause
- USING INDEX clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- logical backups, Export/import, Logical Backups, Incremental Backups
- logical database structure, Logical Database Structures
- LOGICAL_READS_PER_CALL parameter, Resource control
- LOGICAL_READS_PER_SESSION parameter, Resource control
- LONG command (SQL*Plus), LONG
- LONGC[HUNKSIZE] command (SQL*Plus), LONGCHUNKSIZE
- loss of data (see backup and recovery)
- LOW_VALUE column, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- LU6.2 protocol, How SQL*Net works
M
- MANAGE TABLESPACE privilege, Summary of System Privileges
- manual network configuration, Manual Network Configuration
- Map component (OEM), Oracle Enterprise Manager
- MAX_COMMIT_PROPAGATION_DELAY parameter, MAX_COMMIT_PROPAGATION_DELAY
- MAX_DUMP_FILE_SIZE parameter, Initialization parameters, MAX_DUMP_FILE_SIZE
- MAX_ENABLED_ROLES parameter, Maximum number of enabled roles, MAX_ENABLED_ROLES
- MAX_ROLLBACK_SEGMENTS parameter, MAX_ROLLBACK_SEGMENTS
- MAX_TRANSACTION_BRANCHES parameter, MAX_TRANSACTION_BRANCHES
- MAXDATAFILES clause, Creating the parameter file
- MAXEXTENTS clause (ALTER CLUSTER), Keywords, Keywords
- (see also DEFAULT STORAGE parameter; STORAGE parameter)
- MAXEXTENTS parameter (ALTER CLUSTER), Tables
- maximizing performance (see performance)
- MAXINSTANCES clause
- MAXLOGFILES clause
- MAXLOGHISTORY clause
- MAXLOGMEMBERS clause
- MAXSIZE clause (autoextend_clause)
- ALTER TABLESPACE command, auto_extend_clause
- CREATE DATABASE command, autoextend_clause
- CREATE TABLESPACE command, autoextend_clause
- MAXTRANS parameter, Tables
- ALTER CLUSTER command, Keywords
- ALTER INDEX command, Keywords
- ALTER INDEX REBUILD command, Keywords
- ALTER INDEX REBUILD PARTITION command, Keywords
- ALTER SESSION command, Keywords
- ALTER SNAPSHOT LOG command, Keywords
- ALTER TABLE command, Keywords
- CREATE CLUSTER command, Keywords
- CREATE INDEX command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE SNAPSHOT LOG command, Keywords
- segment_attrib_clause parameter (CREATE TABLE), segment_attrib_clause
- USING INDEX clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- MAXVALUE parameter
- MDSYS user, Summary of Initial Users
- medium for Oracle installation, Media Selection
- memory, Memory
- database blocksize, Choosing a blocksize
- monitoring, Memory utilization–SQL queries to monitor SGA utilization
- sort areas, Sort Areas
- structures for, Memory Structures, About Memory Structures–Sort Areas
- user resource control, Resource control–Resource control
- utilization, tuning, Memory utilization
- MERGE_AJ hint, Access method hints
- merge joins, Merge Joins
- MERGE hint, Additional hints, Rule-Based Optimizer
- MERGE_SJ hint, Access method hints
- message queues, data dictionary views for, Advanced Queuing, Advanced Queuing
- MINEXTENTS clause, MINEXTENTS
- MINIMUM EXTENT parameter
- MINVALUE parameter
- MODIFY parameter (ALTER TABLE), Keywords
- MODIFY PARTITION parameter (ALTER TABLE), Keywords
- monitoring, Monitoring, Monitoring
- (see also auditing; security)
- Motif mode (Oracle installation), The Oracle Installer
- MPI (MultiProtocol Interchange), MultiProtocol Interchange–MultiProtocol Interchange
- MTS (Multi-Threaded Server)
- configuring, Multi-Threaded Server Configuration
- data dictionary views for, Multi-Threaded Server
- Dispatcher processes, Dnnn—the Dispatcher process
- Shared Server processes, Snnn—the Shared Server process
- user processes and, Multi-Threaded Server
- MTS_DISPATCHERS parameter (ALTER SYSTEM), MTS_DISPATCHERS, Keywords
- MTS_LISTENER_ADDRESS parameter, MTS_LISTENER_ADDRESS
- MTS_MAX_DISPATCHERS parameter, Dnnn—the Dispatcher process, MTS_MAX_DISPATCHERS
- MTS_MAX_SERVERS parameter, Snnn—the Shared Server process, MTS_MAX_SERVERS
- MTS_MULTIPLE_LISTENERS parameter, MTS_MULTIPLE_LISTENERS
- MTS_RATE_LOG_SIZE parameter, MTS_RATE_LOG_SIZE (Oracle8 Only)
- MTS_RATE_SCALE parameter, MTS_RATE_SCALE (Oracle8 Only)
- MTS_SERVERS parameter (ALTER SYSTEM), Snnn—the Shared Server process, MTS_SERVERS, Keywords
- MTS_SERVICE parameter, MTS_SERVICE
- Multi-Threaded Server (MTS)
- configuring, Multi-Threaded Server Configuration
- Dispatcher processes, Dnnn—the Dispatcher process
- Shared Server processes, Snnn—the Shared Server process
- user processes and, Multi-Threaded Server
- MultiProtocol Interchange (MPI), MultiProtocol Interchange–MultiProtocol Interchange
N
- name resolution, Oracle Names
- named user licenses, Licensing by the User
- names.ora file, Files Created by Network Manager
- naming
- control files, Creating the parameter file
- databases and instances, Choosing the name
- directories, Oracle Directory Structure
- network services, Oracle services, Oracle Names
- NATIONAL CHARACTER SET parameter (CREATE DATABASE), Keywords
- native mode ODBC, Open DataBase Connectivity
- Navigator component (OEM), Oracle Enterprise Manager
- nested loops, Nested Loops
- Net8, SQL*Net Configuration
- (see also SQL*Net)
- configuring, SQL*Net Configuration
- data dictionary views for, Net8
- Easy Config utility, SQL*Net Troubleshooting
- Oracle Net8 Assistant, Oracle Net8 Assistant
- Network Manager, Oracle Network Manager
- network transparency, SQL*Net functionality
- networking, Oracle Networking–Determine basic client connectivity
- ANO (Advanced Networking Option), Advanced Networking Option–DCE naming adapter
- configuring networks
- manual configuration, Manual Network Configuration
- Oracle Net8 Assistant, Oracle Net8 Assistant
- Oracle Network Manager, Oracle Network Manager–Files Created by Network Manager
- connecting to non-Oracle databases, Connecting to Non-Oracle Databases–Gateways
- MPI (MultiProtocol Interchange), MultiProtocol Interchange–MultiProtocol Interchange
- Oracle architecture for, Oracle Network Architecture–DCE naming adapter
- Oracle Network Manager, Oracle Network Manager
- security, Network security
- services, Oracle services
- SQL*Net (see SQL*Net)
- NEW[PAGE] command (SQL*Plus), NEWPAGE
- NEXT clause, Keywords, Keywords
- (see also DEFAULT STORAGE parameter; STORAGE parameter)
- ARCHIVE_LOG parameter, Keywords
- autoextend_clause parameter
- ALTER TABLESPACE command, auto_extend_clause
- CREATE DATABASE command, autoextend_clause
- CREATE TABLESPACE command, autoextend_clause
- DEFAULT STORAGE parameter, Tables
- REFRESH parameter, Keywords, Keywords
- NEXT parameter (SQL*Loader), Control File Syntax
- NEXT parameter (STORAGE clause), NEXT
- NLS_CALENDAR parameter (ALTER SESSION), Keywords
- NLS_CURRENCY parameter (ALTER SESSION), NLS_CURRENCY, Keywords
- NLS_DATABASE_PARAMETERS view, Server management
- NLS_DATE_FORMAT parameter (ALTER SESSION), NLS_DATE_FORMAT, Keywords
- NLS_DATE_LANGUAGE parameter (ALTER SESSION), NLS_DATE_LANGUAGE, Keywords
- NLS_INSTANCE_PARAMETERS view, Server management
- NLS_ISO_CURRENCY parameter (ALTER SESSION), NLS_ISO_CURRENCY, Keywords
- NLS_LANGUAGE parameter (ALTER SESSION), NLS_LANGUAGE, Keywords
- NLS_NUMERIC_CHARACTERS parameter (ALTER SESSION), NLS_NUMERIC_CHARACTERS, Keywords
- NLS_SESSION_PARAMETERS view, Server management
- NLS_SORT parameter (ALTER SESSION), NLS_SORT, Keywords
- NLS_TERRITORY parameter (ALTER SESSION), NLS_TERRITORY, Keywords
- nmcbild.sql script, Network Manager Data Storage
- nmcdrop.sql script, Network Manager Data Storage
- nmcgrnt.sql script, Network Manager Data Storage
- nmcrvke.sql script, Network Manager Data Storage
- NO FORCE parameter (CREATE VIEW), Keywords, Keywords
- NO_PUSH_JOIN_PRED hint, Additional hints
- NOAPPEND hint, Parallel operation hints
- NOARCHIVELOG clause
- NOARCHIVELOG parameter (ALTER DATABASE ARCHIVELOG), Keywords
- NOAUDIT command, Disabling Auditing, NOAUDIT
- NOCACHE hint, Additional hints
- NOCACHE parameter
- NOCYCLE parameter
- NOLOGGING parameter, Unrecoverable operations–Unrecoverable operations
- ALTER INDEX command, Keywords
- ALTER INDEX REBUILD command, Keywords
- ALTER INDEX REBUILD PARTITION command, Keywords
- ALTER SESSION command, Keywords
- ALTER TABLE command, Keywords
- ALTER TABLESPACE command, Keywords
- CREATE INDEX command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE TABLESPACE command, Keywords
- segment_attrib_clause (CREATE TABLE), segment_attrib_clause
- USING INDEX clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- NOMERGE hint, Additional hints
- NONE parameter (SET ROLE), Keywords
- NOORDER parameter
- NOPARALLEL hint, Parallel operation hints
- NOPARALLEL parameter
- NOPARALLEL_INDEX hint, Parallel operation hints
- NORESETLOGS clause (LOGFILE, CREATE CONTROLFILE), Keywords
- NORESETLOGS parameter (ALTER DATABASE OPEN), Keywords
- NOREVERSE parameter
- NORMAL value (OFFLINE), Keywords
- NOSORT parameter
- CREATE INDEX command, Keywords
- USING INDEX clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- NOT DEFERRABLE clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- NOT EXISTS auditing shortcut, Statement Auditing
- NOT IDENTIFIED parameter
- NOT NULL clause
- column_constraint_clause parameter, column_constraint_clause
- table_constraint_clause parameter, table_constraint_clause
- NOVALIDATE parameter (ENABLE clause)
- ALTER TABLE command, column_constraint_clause
- CREATE TABLE command, table_constraint_clause
- NULL clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- NULL command (SQL*Plus), NULL
- NULLIF parameter (SQL*Loader), Control File Syntax
- NUM_BUCKETS column, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- NUM_DISTINCT column, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- NUM_FREELIST_BLOCKS column, ANALYZE TABLE
- NUM_NULLS column, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- NUM_ROWS column, ANALYZE TABLE, ANALYZE INDEX
- NUMF[ORMAT] command (SQL*Plus), NUMFORMAT–NUMWIDTH
- NUM[WIDTH] command (SQL*Plus), NUMWIDTH
O
- O7_DICTIONARY_ACCESSIBILITY parameter, O7_DICTIONARY_ACCESSIBILITY (Oracle8 Only)
- OBJECT_CACHE_MAX_SIZE_PERCENT parameter, OBJECT_CACHE_MAX_SIZE_PERCENT (Oracle8 Only)
- OBJECT_CACHE_OPTIMAL_SIZE parameter, OBJECT_CACHE_OPTIMAL_SIZE (Oracle8 Only)
- object privileges, Object Privileges, Roles
- (see also roles)
- Objects Option, Options
- data dictionary views for, Objects Option
- objects, database (see databases)
- ODBC (Open Database Connectivity), Open DataBase Connectivity
- OEM (Oracle Enterprise Manager), Oracle Enterprise Manager–Oracle Enterprise Manager
- OF parameter (CREATE VIEW), Keywords
- OFA (Optimal Flexible Architecture), Oracle Directory Structure
- OFF value (autoextend_clause)
- ALTER TABLESPACE command, auto_extend_clause
- CREATE DATABASE command, autoextend_clause
- CREATE TABLESPACE command, autoextend_clause
- OFF value (FLAGGER, ALTER SESSION), Keywords
- offline (cold) backups, Cold backup, Cold Backup
- practice scenarios, Hot or Cold Backups
- OFFLINE parameter
- offline redo (archive) logs, Archivelog mode, Archivelog Mode, ARCH—the Archiver process, Redo log files–Redo log files
- destination size, Archive Log Destination
- unrecoverable operations, Unrecoverable operations
- writing to, LGWR—the Log Writer
- ON DELETE CASCADE clause (REFERENCES)
- ALTER TABLE command, column_constraint_clause
- CREATE TABLE command, table_constraint_clause
- ON parameter (CREATE TRIGGER), Keywords
- ON value (autoextend_clause)
- ALTER TABLESPACE command, auto_extend_clause
- CREATE DATABASE command, autoextend_clause
- CREATE TABLESPACE command, autoextend_clause
- online (hot) backups, Hot backup, Hot Backup
- practice scenarios, Hot or Cold Backups
- ONLINE parameter
- online redo logs, ARCH—the Archiver process, Redo log files–Redo log files
- buffer for, Redo log buffer
- configuring, Redo Logs
- unrecoverable operations, Unrecoverable operations
- writing to, LGWR—the Log Writer
- OPEN_CURSORS parameter, OPEN_CURSORS
- Open Database Connectivity (ODBC), Open DataBase Connectivity
- OPEN_LINKS parameter, Program Global Area (PGA), OPEN_LINKS
- OPEN_LINKS_PER_INSTANCE parameter, OPEN_LINKS_PER_INSTANCE (Oracle8 Only)
- operating system
- configuring, Configuring the Operating System
- files of, Types of Database Files–Data Storage Files
- striping, Operating system striping
- OPS (Oracle Parallel Server), Options, Oracle Parallel Server
- configuring, Parallel Server Configuration–Parallel Server Configuration
- data dictionary views for, Oracle Parallel Server, Oracle Parallel Server
- OPS_ADMIN_GROUP parameter, Parallel Server Configuration, OPS_ADMIN_GROUP (Oracle8 Only)
- OPTIMAL clause (STORAGE), Keywords, Keywords
- Optimal Flexible Architecture (OFA), Oracle Directory Structure
- OPTIMIZER_FEATURES_ENABLE parameter, Initialization Parameters, OPTIMIZER_FEATURES_ENABLE
- OPTIMIZER_GOAL parameter (ALTER SESSION), Keywords
- OPTIMIZER_MODE parameter (ALTER SESSION), Initialization Parameters, OPTIMIZER_MODE, Keywords
- OPTIMIZER_PERCENT_PARALLEL parameter (ALTER SESSION), Initialization Parameters, OPTIMIZER_PERCENT_PARALLEL, Keywords
- OPTIMIZER_SEARCH_LIMIT parameter (ALTER SESSION), Initialization Parameters, OPTIMIZER_SEARCH_LIMIT, Keywords
- optimizing performance (see performance)
- optimizing queries, Query Optimization
- cost-based optimizer for, Cost-Based Optimizer–Additional hints
- rule-based optimizer for, Rule-Based Optimizer–Examples
- options for Oracle RDBMS, Options
- OPTIONS parameter (SQL*Loader), Control File Syntax
- OR REPLACE parameter
- ORA-##### errors (list), Some Common ORA Errors, Causes, and Corrective Actions
- Oracle
- architecture of, Oracle Architecture–Logical Database Structures
- common errors (list), Some Common ORA Errors, Causes, and Corrective Actions
- configuration planning, Configuration Planning–Disk layout
- configuring, Configuring Oracle–Parallel Server Configuration
- database administration tools, Oracle Tools–Third-Party Tools
- installing, Installation–A sample script
- instances (see instances)
- network architecture, Oracle Network Architecture–DCE naming adapter
- processes (see processes)
- security holes, Common Security Holes
- software options, Software Options–Licensing by the User
- striping, Oracle striping
- tuning, Tuning Oracle–Unrecoverable operations
- versions of, Versions of Oracle, Version Numbers, Oracle Directory Structure
- oracle directory, Oracle Directory Structure
- Oracle Enterprise Manager (OEM), Oracle Enterprise Manager–Oracle Enterprise Manager
- Tuning Pack, Options
- ORACLE_HOME directory, Oracle Directory Structure
- Oracle Installer (orainst), The Oracle Installer
- Oracle Names, Oracle Names
- Oracle Net8 Assistant, Oracle Net8 Assistant
- Easy Config utility, SQL*Net Troubleshooting
- Oracle Network Manager, Oracle Network Manager–Files Created by Network Manager, Oracle Network Manager
- Oracle Parallel Server (see OPS)
- Oracle Server Manager, Oracle Server Manager–The Future of Server Manager
- SQLDBA utility vs., SQLDBA
- Oracle7 initialization parameters, Parameters Used Only in Oracle7
- Oracle8
- initialization parameters, Parameters New in Oracle8
- password control, Password control–Password control
- system privileges, New System Privileges in Oracle8
- ORACLE_TRACE_COLLECTION_NAME parameter, ORACLE_TRACE_COLLECTION_NAME
- ORACLE_TRACE_COLLECTION_PATH parameter, ORACLE_TRACE_COLLECTION_PATH
- ORACLE_TRACE_COLLECTION_SIZE parameter, ORACLE_TRACE_COLLECTION_SIZE
- ORACLE_TRACE_ENABLE parameter, ORACLE_TRACE_ENABLE
- ORACLE_TRACE_FACILITY_NAME parameter, ORACLE_TRACE_FACILITY_NAME
- ORACLE_TRACE_FACILITY_PATH parameter, ORACLE_TRACE_FACILITY_PATH
- oradata directory, Oracle Directory Structure
- orainst utility, The Oracle Installer
- ORDER parameter
- ORDERED hint, Join order hints
- ORDSYS user, Summary of Initial Users
- ORGANIZATION HEAP parameter (CREATE TABLE), Keywords
- ORGANIZATION INDEX parameter (CREATE TABLE), Index-only tables, Keywords
- OS_AUTHENT_PREFIX parameter, OS_AUTHENT_PREFIX
- OS_ROLES parameter, OS_ROLES
- OUT parameter (CREATE PROCEDURE), Keywords
- OVERFLOW parameter (index_organization_clause), index_organization_clause
- OWNER= parameter (EXP), Export Parameters
P
- Pnnn (Parallel Query) processes, Pnnn—the Parallel Query process
- PACKAGE parameter (ALTER PACKAGE), Keywords
- PAGES[IZE] command (SQL*Plus), PAGESIZE
- PARALLEL_TRANSACTION_RESOURCE_TIMEOUT parameter (ALTER SYSTEM), Keywords
- PARALLEL_DEFAULT_MAX_INSTANCES parameter, PARALLEL_DEFAULT_MAX_INSTANCES
- PARALLEL_INDEX hint, Parallel operation hints
- PARALLEL_INSTANCE_GROUP parameter, Parallel Server Configuration, PARALLEL_INSTANCE_GROUP (Oracle8 Only)
- PARALLEL_MAX_SERVERS parameter, Pnnn—the Parallel Query process, PARALLEL_MAX_SERVERS
- PARALLEL_MIN_MESSAGE_POOL parameter, PARALLEL_MIN_MESSAGE_POOL (Oracle8 Only)
- PARALLEL_MIN_PERCENT parameter (ALTER SESSION), PARALLEL_MIN_PERCENT, Keywords
- PARALLEL_MIN_SERVERS parameter, Pnnn—the Parallel Query process, PARALLEL_MIN_SERVERS
- PARALLEL hint, Parallel operation hints
- PARALLEL parameter
- ALTER CLUSTER command, Keywords
- ALTER DATABASE MOUNT command, Keywords
- ALTER INDEX command, Keywords
- ALTER INDEX REBUILD command, Keywords
- ALTER INDEX REBUILD PARTITION command, Keywords
- ALTER SESSION command, Keywords
- ALTER TABLE command, Keywords
- CREATE CLUSTER command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE TABLE command, Keywords
- SQL*Loader, Command-Line Syntax
- parallel operation hints, Parallel operation hints
- Parallel Query Option (PQO)
- configuring, Parallel Query Configuration
- data dictionary views for, Parallel Query
- processes, Pnnn—the Parallel Query process
- PARALLEL_SERVER_IDLE_TIME parameter, Pnnn—the Parallel Query process, PARALLEL_SERVER_IDLE_TIME
- PARALLEL_SERVER parameter, Parallel Server Configuration, PARALLEL_SERVER (Oracle8 Only)
- Parallel Server option, Options, Oracle Parallel Server
- configuring, Parallel Server Configuration–Parallel Server Configuration
- data dictionary views for, Oracle Parallel Server, Oracle Parallel Server
- PARALLEL_TRANSACTION_RESOURCE_TIMEOUT parameter (ALTER SYSTEM), PARALLEL_TRANSACTION_RESOURCE_TIMEOUT (Oracle8 Only)
- parameter storage files, Files, Parameter Storage Files–Configuration file
- creating, Creating the parameter file
- PARFILE= parameter (EXP), Export Parameters
- PARFILE= parameter (IMP), Import Parameters
- PARFILE parameter (SQL*Loader), Command-Line Syntax
- partial backups, Benefits
- partioning, data dictionary views for, Partitioning
- PARTITION BY RANGE parameter (partition_clause, CREATE TABLE), partition_clause
- partition_clause parameter (CREATE TABLE), Keywords
- partition_clause parameter (CREATE TABLE), partition_clause
- partition elimination, Options
- partition key, Options
- PARTITION clause (global_index_clause, CREATE INDEX), global_index_clause
- PARTITION parameter
- ANALYZE INDEX command, Keywords
- ANALYZE TABLE command, Keywords
- partition_clause (CREATE TABLE), partition_clause
- PARTITION_VIEW_ENABLED parameter (ALTER SESSION), PARTITION_VIEW_ENABLED, Keywords
- partitioned tables, Partitioned tables
- Partitioning Option, Options
- PASSWORD EXPIRE parameter
- passwords
- roles that require, Password-enabled roles
- security holes because of, Not changing privileged user passwords–Using the same password in all databases
- security policy for, Password control–Password control
- PASSWORD_GRACE_TIME parameter, Password control
- PASSWORD_LIFE_TIME parameter, Password control
- PASSWORD_LOCK_TIME parameter, Password control
- PASSWORD_REUSE_MAX parameter, Password control
- PASSWORD_REUSE_TIME parameter, Password control
- PASSWORD_VERIFY_FUNCTION parameter, Password control
- PAU[SE] command (SQL*Plus), PAUSE
- PCTFREE parameter, Tables, Storage Allocation Parameters
- ALTER CLUSTER command, Keywords
- ALTER INDEX command, Keywords
- ALTER INDEX REBUILD command, Keywords
- ALTER INDEX REBUILD PARTITION command, Keywords
- ALTER SESSION command, Keywords
- ALTER SNAPSHOT LOG command, Keywords
- ALTER TABLE command, Keywords
- CREATE CLUSTER command, Keywords
- CREATE INDEX command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE SNAPSHOT LOG command, Keywords
- segment_attrib_clause (CREATE TABLE), segment_attrib_clause
- USING INDEX clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- PCTINCREASE clause, Tables, PCTINCREASE, PCTINCREASE, Keywords
- (see also DEFAULT STORAGE parameter; STORAGE parameter)
- PCTTHRESHOLD parameter (index_organization_clause, CREATE TABLE), index_organization_clause
- PCTUSED parameter
- ALTER CLUSTER command, Keywords
- ALTER SESSION command, Keywords
- ALTER SNAPSHOT LOG command, Keywords
- ALTER TABLE command, Keywords
- CREATE CLUSTER command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE SNAPSHOT LOG command, Keywords
- segment_attrib_clause (CREATE TABLE), segment_attrib_clause
- USING INDEX clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- performance, Performance–Disk layout, Maximizing Oracle Performance–Unrecoverable operations
- database blocksize, Choosing a blocksize
- database configuration and tuning, Configuration and Tuning—What’s the Difference?–What Can Be Tuned?
- operating system configuration, Configuring the Operating System
- Oracle configuration, Configuring Oracle–Parallel Server Configuration
- query optimization (see queries)
- tuning, Oracle Instance Tuning–Unrecoverable operations
- user resource control, Resource control–Resource control
- PERMANENT parameter
- PGA (Program Global Area), Initialization Parameters, Program Global Area (PGA)
- physical backups, Cold backup, Physical Backups, Incremental Backups
- PIECED parameter (SQL*Loader), Control File Syntax
- ping utility (Unix), SQL*Net Troubleshooting
- PL/SQL, data dictionary views for, PL/SQL
- PLAN_TABLE table, The PLAN_TABLE Table
- PLAN_TABLE view, Others
- platform-specific initialization parameters, Platform-Specific Parameters
- PLSQL_V2_COMPATIBILITY parameter, PLSQL_V2_COMPATIBILITY (Oracle8 Only)
- PLUSTRACE role, SQL*Plus AUTOTRACE, Optional Roles
- PMON (Process Monitor) process, PMON—the Process Monitor
- point-in-time recovery, Tablespace Point-in-Time Recovery–Data dictionary views, Tablespace point-in-time recovery
- POINT_IN_TIME_RECOVER= parameter (EXP), Export Parameters
- POINT_IN_TIME_RECOVER= parameter (IMP), Import Parameters
- POSITION parameter (SQL*Loader), Control File Syntax
- post-installation tasks, Post-Installation Tasks–A sample script
- PQO (Parallel Query Option)
- configuring, Parallel Query Configuration
- data dictionary views, Parallel Query
- Pnnn processes, Pnnn—the Parallel Query process
- pre-installation checklist, Pre-Installation Checklist
- PRESERVE BLANKS parameter (SQL*Loader), Control File Syntax
- PRESERVE SNAPSHOT LOG parameter
- TRUNCATE TABLE command, Keywords
- PRE_PAGE_SGA parameter, PRE_PAGE_SGA
- PRIMARY KEY clause
- column_constraint_clause (ALTER TABLE), column_constraint_clause
- table_constraint_clause (CREATE TABLE), table_constraint_clause
- PRI[NT] command (SQL*Plus), PRINT
- privacy of data, DCE integration
- PRIVATE_SGA parameter, Resource control
- privileges, Check system privileges
- data dictionary views for, Security
- object privileges, Object Privileges
- roles (see roles)
- system privileges, System Privileges, System Privileges and Initial Roles–New System Privileges in Oracle8
- affecting whole database, Privileges That Affect the Entire Database
- assigned to initial users (list), Cross-Reference: System Privileges Assigned to Initial Users–Cross-Reference: System Privileges Assigned to Initial Users
- auditing, Types of Auditing Supported , System Privilege Auditing
- creating objects, Privileges That Allow You to Create Objects in Your Own Schema
- list of, Summary of System Privileges–Summary of System Privileges
- manipulating any objects, Privileges That Allow You to Manipulate Objects in Any Schema
- for various roles, Cross-Reference: Roles and System Privileges
- PROCEDURE auditing shortcut, Statement Auditing
- Process Monitor (PMON) process, PMON—the Process Monitor
- processes, Processes–Multi-Threaded Server
- background processes, Processes
- server processes, Processes, Server Processes
- user processes, Processes, User Processes
- PROCESSES parameter, PROCESSES
- PRODUCT_COMPONENT_VERSION view, Server management
- product directory, Oracle Directory Structure
- PROFILE auditing shortcut, Statement Auditing
- PROFILE parameter
- profiles, user, Profiles–Implementing profiles
- default, Default profile
- password control, Password control–Password control
- resource control, Resource control–Resource control
- Program Global Area (PGA), Initialization Parameters, Program Global Area (PGA)
- PUBLIC DATABASE LINK auditing shortcut, Statement Auditing
- PUBLIC_DEPENDENCY view, PL/SQL
- PUBLIC parameter
- CREATE DATABASE LINK command, Keywords
- CREATE ROLLBACK SEGMENT command, Keywords
- CREATE SYNONYM command, Keywords
- DROP DATABASE LINK command, Keyword
- DROP SYNONYM command, Keyword
- GRANT command (object privileges), Keywords
- GRANT command (system privileges, roles), Keywords
- REVOKE command (object privileges), Keywords
- REVOKE command (system privileges, roles), Keywords
- PUBLIC SYNONYM auditing shortcut, Statement Auditing
- PURGE SNAPSHOT LOG parameter (TRUNCATE TABLE), Keywords
- PUSH_JOIN_PRED hint, Additional hints
- PUSH_JOIN_PREDICATE parameter, Initialization Parameters, PUSH_JOIN_PREDICATE
- PUSH_SUBQ hint, Additional hints
Q
- QMNn (Queue Monitor) processes, QMNn—the Queue Monitor process
- queries, SQL, Query processing
- (see also SQL)
- determining access plan, Determining the Access Plan–Oracle Enterprise Manager Top Sessions
- hint specification, Specifying Hints
- optimizing, Query Optimization
- cost-based optimizer for, Cost-Based Optimizer–Additional hints
- rule-based optimizer for, Rule-Based Optimizer–Examples
- processing, Query processing
- types of, Types of Queries–Cartesian Product
- Queue Monitor (QMNn) processes, QMNn—the Queue Monitor process
- queueing, data dictionary views for, Advanced Queuing, Advanced Queuing
- QUOTA parameter
R
- RAID (redundant arrays of inexpensive disks), A note about RAID, About RAID–About RAID
- RBO (rule-based optimizer), Rule-Based Optimizer–Examples
- RDBMS (see Oracle)
- READ COMMITTED clause (ISOLATION_LEVEL), Keywords
- READ_COMMITTED value (FLAGGER), Keywords
- READ ONLY parameter
- READ privilege, Object Privileges
- read sensitivity of data, Read sensitivity of the data
- READ WRITE parameter
- READBUFFERS parameter (SQL*Loader), Control File Syntax
- REBUILD clause (MODIFY PARTITION), Keywords
- REBUILD parameter (ALTER INDEX REBUILD), Keywords
- REBUILD PARTITION parameter (ALTER INDEX REBUILD PARTITION), Keywords
- RECNUM parameter (SQL*Loader), Control File Syntax
- RECO (Recoverer) process, RECO—the Recoverer process
- RECORD= parameter (EXP), Using the EXP tables, Export Parameters
- RECORDLENGTH= parameter (EXP), Export Parameters
- RECORDLENGTH= parameter (IMP), Import Parameters
- RECOVERABLE parameter (SQL*Loader), Control File Syntax
- recovery (see backup and recovery)
- RECOVERY_CATALOG_OWNER role, Optional Roles
- Recovery Manager (see RMAN)
- RECOVERY_PARALLELISM parameter, RECOVERY_PARALLELISM
- recovery set, Tablespace Point-in-Time Recovery
- RECOVERY_TABLESPACES= parameter (EXP)[RECOVERY_TABLESPACES parameter (EXP)[, Export Parameters
- RECSEP command (SQL*Plus), RECSEP
- RECSEPCHAR command (SQL*Plus), RECSEPCHAR
- redo logs, ARCH—the Archiver process, Redo log files–Redo log files
- buffer for, Redo log buffer
- entries, Redo log buffer
- offline (archive logs), Archivelog mode, Archive Log Destination, Archivelog Mode
- online, Redo Logs
- unrecoverable operations, Unrecoverable operations
- writing to, LGWR—the Log Writer
- redundant databases (see replication)
- REENABLE parameter (SQL*Loader), Control File Syntax
- REF WITH ROWID parameter (table_constraint_clause, CREATE TABLE), table_ref_clause
- REFERENCES clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- REFERENCES privilege, Object Privileges
- REFERENCING parameter (CREATE TRIGGER), Keywords
- REFRESH parameter
- REM[ARK] command (SQL*Plus), REMARK
- REMOTE_DEPENDENCIES_MODE parameter, REMOTE_DEPENDENCIES_MODE
- REMOTE_LOGIN_PASSWORDFILE parameter, REMOTE_LOGIN_PASSWORDFILE
- REMOTE_OS_AUTHENT parameter, REMOTE_OS_AUTHENT
- REMOTE_OS_ROLES parameter, REMOTE_OS_ROLES
- remote procedure calls (RPCs), DCE integration, Remote procedure calls
- RENAME command, RENAME
- RENAME parameter
- RENAME PARTITION parameter
- RENAME TO parameter (ALTER TABLE), Keywords
- REPLACE parameter (SQL*Loader), Control File Syntax
- replication, Replication, Advanced replication
- REPLICATION_DEPENDENCY_TRACKING parameter, REPLICATION_DEPENDENCY_TRACKING (Oracle8 Only)
- reports (SQL*Plus), Producing Reports
- repository, OEM, Oracle Enterprise Manager
- RESETLOGS clause (LOGFILE, CREATE CONTROLFILE), Keywords
- RESETLOGS parameter (ALTER DATABASE OPEN), Keywords
- resource control, Resource control–Resource control
- RESOURCE_COST view, Security
- RESOURCE_LIMIT parameter (ALTER SYSTEM), RESOURCE_LIMIT, Keywords, Keywords
- RESOURCE_MAP view, Security
- RESOURCE auditing shortcut, System Privilege Auditing
- RESOURCE role, Automatic Roles
- resource requirements, Check resource requirements
- RETURN parameter (CREATE FUNCTION), Keywords
- REUSE clause (filespec), filespec
- REUSE parameter
- REUSE STORAGE parameter
- REVERSE parameter
- REVOKE command (object privileges), REVOKE (Object Privileges)
- REVOKE command (system privileges, roles), REVOKE (System Privilege or Role)
- RMAN (Recovery Manager), Recovery Manager (RMAN), Oracle Recovery Manager, Summary of Initial Users
- data dictionary views for, Recovery
- ROLE auditing shortcut, Statement Auditing
- ROLE_SYS_PRIVS view, Security
- ROLE_TAB_PRIVS view, Security
- roles, Roles–The WITH ADMIN OPTION clause, Roles, Initial Roles
- (see also privileges)
- assigned to initial users (list), Cross-Reference: Roles Assigned to Initial Users
- automatic, Automatic Roles
- optional, Optional Roles
- system privileges of (list), Cross-Reference: Roles and System Privileges
- ROLE_ROLE_PRIVS view, Security
- ROLLBACK tablespace, disk allocation, Disk Layout
- ROLLBACK SEGMENT auditing shortcut, Statement Auditing
- rollback segments, Logical Database Structures
- configuring and sizing, Rollback Segments
- corrupted, recovery from, Database corruption
- failure to extend, Sizing and Configuring Database Objects
- ROLLBACK_SEGMENTS parameter, Parallel Server Configuration, ROLLBACK_SEGMENTS
- root.sh script (Unix), Post-Installation Tasks
- rosbild.sql script, Network Manager Data Storage
- rosdrop.sql script, Network Manager Data Storage
- rosgrnt.sql script, Network Manager Data Storage
- rosrvke.sql script, Network Manager Data Storage
- row cache, Dictionary cache.
- ROW_CACHE_CURSORS parameter, ROW_CACHE_CURSORS
- row chaining, Sizing and Configuring Database Objects, Storage Allocation Parameters
- row-level auditing, Limitations of Auditing, Row-Level Auditing–Row-Level Auditing
- ROW_LOCKING parameter, Parallel Server Configuration, ROW_LOCKING
- ROWID hint, Access method hints
- ROWS= parameter (EXP), Export Parameters
- ROWS= parameter (IMP), Import Parameters
- ROWS parameter (SQL*Loader), Command-Line Syntax
- RPCs (remote procedure calls), DCE integration, Remote procedure calls
- RULE value (OPTIMIZER_MODE), Goal hints, Keywords
- rule-based optimizer (RBO), Rule-Based Optimizer–Examples
- rule-based query processing, Query processing
S
- Snnn (Shared Server) processes, Snnn—the Shared Server process
- SAMPLE_SIZE column, ANALYZE TABLE, ANALYZE INDEX, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- SAVE command (SQL*Plus), SAVE
- SCAN_INSTANCES parameter (ALTER SYSTEM), Keywords
- schema object auditing, Types of Auditing Supported , Schema Object Auditing–Examples of schema object auditing
- schemas, Logical Database Structures
- SCOPE FOR IS parameter (table_ref_clause, CREATE TABLE), table_ref_clause
- SCOPE IS parameter (column_ref_clause, CREATE TABLE), column_ref_clause
- scope of auditing, Scope of Auditing
- scope (hint), Scope of a hint
- SCOTT user, The SCOTT/TIGER account, Summary of Initial Users
- scripts, SQL (see SQL)
- security, Preventing Data Loss, Security–Auditing
- (see also backup and recovery)
- auditing, Auditing–Row-Level Auditing
- common Oracle holes, Common Security Holes
- control files, Control files
- data dictionary views for, Security, Security
- monitoring, Monitoring
- networking, Network security
- policy for, Security Policy–Audit policy
- privileges (see privileges)
- redo logs, protecting, Redo log files
- roles (see roles)
- user profiles, Profiles–Implementing profiles
- segments, Logical Database Structures
- segment_attrib_clause parameter (CREATE TABLE), Keywords, segment_attrib_clause
- SELECT ANY SEQUENCE privilege, Summary of System Privileges
- SELECT ANY TABLE privilege, Summary of System Privileges
- SELECT_CATALOG_ROLE role, Automatic Roles
- SELECT COUNT command, The highwater mark
- SELECT privilege, Object Privileges
- SELECT SEQUENCE auditing shortcut, Statement Auditing
- SELECT TABLE auditing shortcut, Statement Auditing
- SEQ clause (ARCHIVE_LOG), Keywords
- SEQUENCE auditing shortcut, Statement Auditing
- SEQUENCE parameter (SQL*Loader), Control File Syntax
- sequences view (DBA_SEQUENCES), Sequences
- SEQUENCE_CACHE_ENTRIES parameter, SEQUENCE_CACHE_ENTRIES
- SEQUENCE_CACHE_HASH_BUCKET parameter, SEQUENCE_CACHE_HASH_BUCKET
- SERIAL_REUSE parameter, SERIAL_REUSE (Oracle8 Only)
- SERIALIZABLE clause (ISOLATION_LEVEL), Parallel Server Configuration, Keywords, Keywords
- server management, data dictionary views for, Server management
- Server Manager, Oracle Server Manager–The Future of Server Manager
- SQLDBA utility vs., SQLDBA
- server processes, Processes, Server Processes
- Server version of Oracle, Base Product
- SERVEROUT[PUT] command (SQL*Plus), SERVEROUTPUT
- services, Oracle services
- names for, Oracle services, Oracle Names
- SESSION auditing shortcut, Statement Auditing
- sessions
- auditing by, Scope of Auditing
- enabling SQL Trace for, Enabling SQL Trace for a specific session
- SESSIONS parameter, SESSIONS
- SESSIONS_PER_USER parameter, Resource control
- SESSION_CACHED_CURSORS parameter (ALTER SESSION), SESSION_CACHED_CURSORS, Keywords
- SESSION_MAX_OPEN_FILES parameter, SESSION_MAX_OPEN_FILES (Oracle8 Only)
- SESSION_PRIVS view, Security
- SESSION_ROLES view, Maximum number of enabled roles, Security
- SET command (SQL*Plus), SET
- SET parameter
- SET ROLE command, Default roles, SET ROLE
- SET STATEMENT_ID parameter (EXPLAIN PLAN), Keywords
- SET TRANSACTION command, SET TRANSACTION
- SGA (System Global Area), System Global Area (SGA), Memory Structures, System Global Area (SGA)– Control structures.
- SHADOW_CORE_DUMP parameter, SHADOW_CORE_DUMP
- SHARED parameter (CREATE DATABASE LINK), Keywords
- SHARED_POOL_RESERVED_MIN_ALLOC parameter, SHARED_POOL_RESERVED_MIN_ALLOC
- SHARED_POOL_RESERVED_SIZE parameter, SHARED_POOL_RESERVED_SIZE
- SHARED_POOL_SIZE parameter, SHARED_POOL_SIZE
- SHARED_POOL_SIZE parameter, Memory utilization, Shared pool
- shared pools, Memory utilization, Shared pool
- Shared Server (Snnn) processes, Snnn—the Shared Server process
- SHIFT[INOUT] command (SQL*Plus), SHIFTINOUT
- SHO[W] command (SQL*Plus), SHOW
- SHOW= parameter (IMP), Import Parameters
- SHOW[MODE] command (SQL*Plus), SHOWMODE
- SHRINK parameter (ALTER ROLLBACK SEGMENT), Keywords
- SIGNATURE value (REMOTE_DEPENDENCIES_MODE), Keywords, Keywords
- SILENT parameter (SQL*Loader), Command-Line Syntax
- simple queries, Simple Queries
- SINGLE_IMAGE parameter, Background Processes
- SINGLE_PROCESS parameter, Parallel Server Configuration
- single sign-on feature, Single sign-on
- SINGLEROW parameter (SQL*Loader), Control File Syntax
- site licenses, Licensing by the User
- SIZE clause
- SIZE parameter
- sizing database objects, Sizing and Configuring Database Objects–Archive Log Destination, Object Storage Sizing–The highwater mark
- SKIP parameter (SQL*Loader), Command-Line Syntax , Control File Syntax
- SKIP_INDEX_MAINTENANCE parameter (SQL*Loader), Command-Line Syntax
- SKIP_UNUSABLE_INDEXES parameter
- ALTER SESSION command, Keywords
- IMP utility, Import Parameters
- SQL*Loader, Command-Line Syntax
- SM$VERSION view, Server management
- SMON (System Monitor) process, SMON—the System Monitor
- Snapshot Refresh Process, SNPn—the Job Queue process
- snapshots, data dictionary views for, Snapshots
- SNAPSHOT_REFRESH_PROCESS parameter, SNPn—the Job Queue process
- SNMPAGENT role, Optional Roles
- SNPn processes, SNPn—the Job Queue process
- software (product) directory, Oracle Directory Structure
- software code areas, Software Code Areas
- SORT_AREA_RETAINED_SIZE parameter, Sort Areas, SORT_AREA_RETAINED_SIZE
- SORT_AREA_SIZE parameter, Sort Areas, Initialization Parameters, Sort Areas, SORT_AREA_SIZE
- sort areas, Sort Areas, Sort Areas
- SORT_DIRECT_WRITES parameter, Initialization Parameters, SORT_DIRECT_WRITES
- SORT_READ_FAC parameter, SORT_READ_FAC
- SORT_SPACEMAP_SIZE parameter, SORT_SPACEMAP_SIZE
- SORT_WRITE_BUFFER_SIZE parameter, SORT_WRITE_BUFFER_SIZE
- SORT_WRITE_BUFFERS parameter, SORT_WRITE_BUFFERS
- SORTED INDEXES parameter (SQL*Loader), Control File Syntax
- Spatial Cartridge, Data Cartridges
- SPIN_COUNT parameter, SPIN_COUNT
- SPLIT PARTITION parameter (ALTER INDEX), Keywords
- SPO[OL] command (SQL*Plus), SPOOL
- SPX/IPX protocol, How SQL*Net works
- SQL
- command reference
- listed by command, SQL Command Syntax–Example
- listed by task, SQL Commands by Task–SQL Commands by Task
- creating with SQL, SQL from SQL
- database creation scripts, Building Database Creation Scripts–A sample script
- join access paths, Types of Join Access Paths
- library cache, Library cache.
- monitoring SGA utilization, SQL queries to monitor SGA utilization
- monitoring storage utilization, SQL queries to monitor storage utilization
- PL/SQL, data dictionaries view for, PL/SQL
- processing, V$ views for, SQL
- queries
- determining access plan, Determining the Access Plan–Oracle Enterprise Manager Top Sessions
- hint specification, Specifying Hints
- optimizing, Query Optimization, Cost-Based Optimizer–Examples
- types of, Types of Queries–Cartesian Product
- statement auditing, Types of Auditing Supported , Statement Auditing–Examples of statement auditing
- tuning, SQL Tuning–Query processing
- SQL Trace facility, SQL Trace and TKPROF
- SQL_TRACE parameter, Initialization parameters, SQL_TRACE
- SQL Worksheet (Server Manager), Graphical Version
- SQL*Loader utility, SQL*Loader–SQL*Loader Files
- basic reference, SQL*Loader–datatype_spec
- data dictionary views for, SQL*Loader, SQL*Loader direct path
- SQL*Net, SQL*Net and Net8–Oracle services
- configuring, SQL*Net Configuration
- MPI (MultiProtocol Interchange), MultiProtocol Interchange–MultiProtocol Interchange
- ODBC driver interface to, Open DataBase Connectivity
- sample files, Files Created by Network Manager, Sample SQL*Net Files– sqlnet.ora
- troubleshooting, SQL*Net Troubleshooting–Determine basic client connectivity
- SQL*Plus, SQL*Plus–Producing Reports
- AUTOTRACE facility, SQL*Plus AUTOTRACE
- basic reference, SQL*Plus–WRAP
- sql.bsq script, Initial Roles
- SQL92_SECURITY parameter, SQL92_SECURITY
- SQLC[ASE] command (SQL*Plus), SQLCASE
- SQLCO[NTINUE] command (SQL*Plus), SQLCONTINUE
- SQLDBA utility, SQLDBA–SQLDBA
- sqlnet.ora file, SQL*Net Configuration, Files Created by Network Manager, sqlnet.ora
- SQLN[UMBER] command (SQL*Plus), SQLNUMBER
- SQLPRE[FIX] command (SQL*Plus), SQLPREFIX
- SQLP[ROMPT] command (SQL*Plus), SQLPROMPT
- SQL[TERMINATOR] command (SQL*Plus), SQLTERMINATOR
- STAR hint, Join order hints
- STAR_TRANSFORMATION_ENABLED parameter (ALTER SESSION), STAR_TRANSFORMATION_ENABLED (Oracle8 Only)
- STAR_TRANSFORMATION hint, Additional hints
- START clause (ARCHIVE_LOG, ALTER SYSTEM), Keywords
- START command (SQL*Plus), START
- START WITH clause (REFRESH)
- START WITH parameter (CREATE SEQUENCE), Keywords
- starter (initial) database, The Starter Database
- STAR_TRANSFORMATION_ENABLED parameter (ALTER SESSION), Keywords
- statement auditing, Types of Auditing Supported , Statement Auditing–Examples of statement auditing
- static data dictionary views, The Oracle Data Dictionary, Static Data Dictionary Views–Trusted Oracle
- STATISTICS= parameter (EXP), Export Parameters
- STMT_AUDIT_OPTION_MAP view, Lookup Tables, Audit trail
- STOP clause (ARCHIVE_LOG, ALTER SYSTEM), Keywords
- storage
- allocation parameters, Storage Allocation Parameters
- allocation process, How Oracle Allocates Storage–A Space Allocation Example
- data dictionary views for, Storage
- data storage files, Data Storage Files
- disk allocation, Disk Allocation–About RAID
- monitoring, Storage utilization–SQL queries to monitor storage utilization , SQL queries to monitor storage utilization
- Network Manager data, Network Manager Data Storage
- parameter data, Parameter Storage Files–Configuration file
- sizing database objects, Sizing and Configuring Database Objects–Archive Log Destination, Object Storage Sizing–The highwater mark
- tablespaces (see tablespaces)
- STORAGE parameter
- ALTER CLUSTER command, Keywords
- ALTER INDEX command, Keywords
- ALTER INDEX REBUILD command, Keywords
- ALTER INDEX REBUILD PARTITION command, Keywords
- ALTER ROLLBACK SEGMENT command, Keywords
- ALTER SESSION command, Keywords
- ALTER SNAPSHOT LOG command, Keywords
- ALTER TABLE command, Keywords
- CREATE CLUSTER command, Keywords
- CREATE INDEX command, Keywords
- CREATE command, How Oracle Allocates Storage
- CREATE ROLLBACK SEGMENT command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE SNAPSHOT LOG command, Keywords
- segment_attrib_clause (CREATE TABLE), segment_attrib_clause
- USING INDEX
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- USING INDEX clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- STORE command (SQL*Plus), STORE
- striping of data, A note about RAID
- Structured Query Language (see SQL)
- subqueries, Subqueries
- SUF[FIX] command (SQL*Plus), SUFFIX
- SWITCH LOGFILE parameter (ALTER SYSTEM), Keywords
- SYNONYM auditing shortcut, Statement Auditing
- synonyms view (DBA_SYNONYMS), Synonyms
- SYS user, Summary of Initial Users
- SYSDATE parameter (SQL*Loader), Control File Syntax
- SYSTEM AUDIT auditing shortcut, Statement Auditing
- system failure, recovery from, System failure
- System Global Area (see SGA)
- SYSTEM GRANT auditing shortcut, Statement Auditing
- System Monitor (Server Manager), Graphical Version, SMON—the System Monitor
- SYSTEM tablespace, Logical Database Structures, Oracle Tablespaces
- SYSTEM user, Summary of Initial Users
- SYSTEM_PRIVILEGE_MAP view, Lookup Tables, Audit trail
- system privileges, System Privileges, Roles, System Privileges and Initial Roles–New System Privileges in Oracle8
- (see also roles)
- affecting whole database, Privileges That Affect the Entire Database
- assigned to initial users (list), Cross-Reference: System Privileges Assigned to Initial Users–Cross-Reference: System Privileges Assigned to Initial Users
- auditing, Types of Auditing Supported , System Privilege Auditing
- creating objects, Privileges That Allow You to Create Objects in Your Own Schema
- list of, Summary of System Privileges–Summary of System Privileges
- manipulating any objects, Privileges That Allow You to Manipulate Objects in Any Schema
- V$ENABLEDPRIVS view, Security
- for various roles, Cross-Reference: Roles and System Privileges
- system resource requirements, Check resource requirements
T
- TAB command (SQL*Plus), TAB
- table_constraint_clause parameter (CREATE TABLE), Keywords, table_constraint_clause
- TABLE auditing shortcut, Statement Auditing
- TABLE parameter (COMMENT), Keywords
- TABLE_PRIVILEGE_MAP view, Lookup Tables, Audit trail
- table_ref_clause parameter (CREATE TABLE), Keywords, table_ref_clause
- tables, Logical Database Structures
- configuring and sizing, Tables
- corrupted, recovery from, Database corruption
- data dictionary views for, Tables, clusters, and views
- disabling redo logs, Unrecoverable operations–Unrecoverable operations
- index-only, Index-only tables
- partitioned, Partitioned tables
- TABLES= parameter (EXP), Export Parameters
- TABLES= parameter (IMP), Import Parameters
- TABLESPACE auditing shortcut, Statement Auditing
- TABLESPACE parameter
- ALTER INDEX REBUILD command, Keywords
- ALTER INDEX REBUILD PARTITION command, Keywords
- CREATE CLUSTER command, Keywords
- CREATE INDEX command, Keywords
- CREATE ROLLBACK SEGMENT command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE SNAPSHOT LOG command, Keywords
- segment_attrib_clause (CREATE TABLE), segment_attrib_clause
- USING INDEX clause
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause (CREATE TABLE), table_constraint_clause
- tablespaces, Logical Database Structures, Oracle Tablespaces–The highwater mark, Oracle Tablespaces
- (see also storage)
- fragmented, Sizing and Configuring Database Objects
- point-in-time recovery, Tablespace Point-in-Time Recovery–Data dictionary views, Tablespace point-in-time recovery
- temporary, Temporary Tablespaces, Temporary tablespaces
- TAPE_ASYNCH_IO parameter, TAPE_ASYNCH_IO (Oracle8 Only)
- TCP/IP protocol, How SQL*Net works, Determine basic client connectivity
- TEMPORARY parameter
- ALTER TABLESPACE command, Keywords
- CREATE TABLESPACE command, Temporary tablespaces, Keywords
- TEMPORARY value (OFFLINE, ALTER TABLESPACE), Keywords
- temporary segments, Logical Database Structures
- TEMPORARY_TABLE_LOCKS parameter, TEMPORARY_TABLE_LOCKS
- TEMPORARY TABLESPACE parameter, Temporary Tablespaces
- temporary tablespaces, Temporary Tablespaces, Temporary tablespaces
- TERM[OUT] command (SQL*Plus), TERMOUT
- TEXT_ENABLED parameter
- third-party administration tools, Third-Party Tools
- THIS parameter (SQL*Loader), Control File Syntax
- THREAD clause (ARCHIVE_LOG), Keywords
- THREAD parameter, Parallel Server Configuration, THREAD
- TIGER password, The SCOTT/TIGER account
- TI[ME] command (SQL*Plus), TIME
- Time Series Cartridge, Data Cartridges
- TIMED_OS_STATISTICS parameter (ALTER SYSTEM), TIMED_OS_STATISTICS (Oracle8 Only), Keywords
- TIMED_STATISTICS parameter, Initialization parameters, TIMED_STATISTICS
- TIMESTAMP value (REMOTE_DEPENDENCIES_MODE), Keywords, Keywords
- TIMI[NG] command (SQL*Plus), TIMING, TIMING
- TKPROF utility, SQL Trace and TKPROF–Postprocessing with TKPROF
- TKPROFER role, Optional Roles
- tnsnames.ora file, SQL*Net Configuration, Oracle Names, Files Created by Network Manager, tnsnames.ora
- tnsnav.ora file, Files Created by Network Manager
- tnsnet.ora file, Files Created by Network Manager
- tnsping, tnsping80 utilities, SQL*Net Troubleshooting
- TO parameter (GRANT), Keywords
- tools for database administration, Oracle Tools–Third-Party Tools
- Top Sessions monitor, Oracle Enterprise Manager Top Sessions
- TOUSER= parameter (IMP), Import Parameters
- tracing SQL statements, SQL Trace and TKPROF–Postprocessing with TKPROF
- TRAILING NULLCOLS parameter (SQL*Loader), Control File Syntax
- TRANSACTIONS parameter, TRANSACTIONS
- TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter, TRANSACTIONS_PER_ROLLBACK_SEGMENT
- TRANSACTION_AUDITING parameter (ALTER SYSTEM), TRANSACTION_AUDITING (Oracle8 Only), Keywords
- TRIGGER auditing shortcut, Statement Auditing
- triggers, row-level auditing with, Limitations of Auditing, Row-Level Auditing–Row-Level Auditing
- TRIM[OUT] command (SQL*Plus), TRIMOUT
- TRIMS[POOL] command (SQL*Plus), TRIMSPOOL
- troubleshooting
- backups (see backup and recovery)
- pre-installation checklist, Pre-Installation Checklist
- redundant databases (see replication)
- SQL*Net, SQL*Net Troubleshooting–Determine basic client connectivity
- TRUE value (SORT_DIRECT_WRITES)
- TRUNCATE CLUSTER command, TRUNCATE CLUSTER
- TRUNCATE parameter (SQL*Loader), Control File Syntax
- TRUNCATE PARTITION parameter (ALTER TABLE), Keywords
- TRUNCATE TABLE command, TRUNCATE TABLE
- Trusted Oracle (ALL_LABELS view), Trusted Oracle
- TRUSTED_SERVERS view, Net8
- TS_PITR_CHECK view, Data dictionary views
- TS_PITR_OBJECTS_TO_BE_DROPPED view, Data dictionary views
- TTI[TLE] command (SQL*Plus), TTITLE
- tuning, Configuration and Tuning—What’s the Difference?–What Can Be Tuned?, Tuning Oracle–Unrecoverable operations
- queries (see queries)
- TYPE auditing shortcut, Statement Auditing
U
- UNDEF[INE] command (SQL*Plus), UNDEFINE
- UND[ERLINE] command (SQL*Plus), UNDERLINE
- UNIQUE clause (column_constraint_clause, ALTER TABLE), column_constraint_clause
- UNIQUE parameter
- CREATE INDEX command, Keywords
- table_constraint_clause (CREATE TABLE), table_constraint_clause
- UNLIMITED clause (autoextend_clause)
- ALTER TABLESPACE command, auto_extend_clause
- CREATE DATABASE command, autoextend_clause
- CREATE TABLESPACE command, autoextend_clause
- UNLIMITED value, Resource control, ALTER PROFILE , CREATE PROFILE
- UNLIMITED TABLESPACE privilege, Summary of System Privileges
- UNRECOVERABLE parameter
- CREATE INDEX command, Unrecoverable operations–Unrecoverable operations, Keywords
- SQL*Loader, Control File Syntax
- unrecoverable operations, Unrecoverable operations
- UNUSABLE LOCAL INDEXES clause (MODIFY PARTITION, ALTER TABLE), Keywords
- UNUSABLE parameter (ALTER INDEX), Keywords
- UPDATE ANY TABLE privilege, Summary of System Privileges
- UPDATE clause (INSTEAD OF), Keywords
- UPDATE privilege, Object Privileges
- UPDATE TABLE auditing shortcut, Statement Auditing
- updating datafile headers, CKPT—the Checkpoint process
- USE_CONCAT hint, Access method hints
- USE_HASH hint, Join operation hints
- USE_ISM parameter, USE_ISM (Oracle8 Only)
- USE_MERGE hint, Join operation hints
- USE_NL hint, Join operation hints
- USE ROLLBACK SEGMENT parameter (SET TRANSACTION), Keywords
- USER_AUDIT_OBJECT view, Views containing audit trail information
- USER_AUDIT_SESSION view, Views containing audit trail information
- USER_AUDIT_STATEMENT view, Views containing audit trail information
- USER_AUDIT_TRAIL view, Views containing audit trail information
- USER_DUMP_DEST parameter (ALTER SYSTEM), Initialization parameters, USER_DUMP_DEST, Keywords
- USER_INDEXES view, ANALYZE INDEX
- user licenses, Licensing by the User
- USER auditing shortcut, Statement Auditing
- USER_OBJ_AUDIT_OPTS view, Views containing auditing specifications
- USER_PASSWORD_LIMITS view, Security
- user processes, Processes, User Processes
- USER_TAB_COLUMNS view, ANALYZE TABLE . . . STATISTICS FOR COLUMNS
- USER_TABLES view, ANALYZE TABLE
- USERID= parameter (EXP), Export Parameters
- USERID= parameter (IMP) , Import Parameters
- USERID parameter (SQL*Loader), Command-Line Syntax
- users, Initial Users–Cross-Reference: System Privileges Assigned to Initial Users
- auditing by, Scope of Auditing, Keywords
- creating, Creating Users, CREATE USER
- profiles for, Profiles–Implementing profiles
- default, Default profile
- password control, Password control–Password control
- resource control, Resource control–Resource control
- roles (see roles)
- system privileges of (list), Cross-Reference: System Privileges Assigned to Initial Users–Cross-Reference: System Privileges Assigned to Initial Users
- USING clause (CONNECT TO), Keywords
- USING DEFAULT ROLLBACK SEGMENT clause (REFRESH, CREATE SNAPSHOT), Keywords
- USING DEFAULT ROLLBACK SEGMENT parameter (ALTER SESSION), Keywords
- USING INDEX parameter
- ALTER SESSION command, Keywords
- column_constraint_clause (ALTER TABLE), column_constraint_clause
- CREATE SNAPSHOT command, Keywords
- table_constraint_clause (CREATE TABLE), table_constraint_clause
- USING ROLLBACK SEGMENT clause (REFRESH, CREATE SNAPSHOT), Keywords
- USING ROLLBACK SEGMENT parameter (ALTER SESSION), Keywords
- UTLBSTAT script, SQL queries to monitor storage utilization
- UTLESTAT script, SQL queries to monitor storage utilization
- UTL_FILE package, Shared UTL_FILE access to directories
- UTL_FILE_DIR parameter, UTL_FILE_DIR
V
- V$ACCESS view, Locks and latches
- V$ACTIVE_INSTANCES view, Oracle Parallel Server
- V$AQ view, Advanced Queuing
- V$ARCHIVE view, Recovery
- V$ARCHIVED_LOG view, Recovery
- V$ARCHIVE_DEST view, Recovery
- V$BACKUP view, Recovery
- V$BACKUP_CORRUPTION view, Recovery
- V$BACKUP_DATAFILE view, Recovery
- V$BACKUP_DEVICE view, Recovery
- V$BACKUP_PIECE view, Recovery
- V$BACKUP_REDOLOG view, Recovery
- V$BACKUP_SET view, Recovery
- V$BGPROCESS view, Instance
- V$BH view, Oracle Parallel Server
- V$BUFFER_POOL view, Locks and latches
- V$CACHE view, Oracle Parallel Server
- V$CACHE_LOCK view, Oracle Parallel Server
- V$CIRCUIT view, Multi-Threaded Server
- V$CLASS_PING view, Oracle Parallel Server
- V$COMPATIBILITY view, Configuration
- V$COMPATSEG view, Configuration
- V$CONTROLFILE view, Database
- V$CONTROLFILE_RECORD_SECTION view, Database
- V$COPY_CORRUPTION view, Recovery
- V$CURRENT_BUCKET view, SGA
- V$DATABASE view, Database
- V$DATAFILE view, Database
- V$DATAFILE_COPY view, Recovery
- V$DATAFILE_HEADER view, Database
- V$DB_OBJECT_CACHE view, Data dictionary cache
- V$DB_PIPES view, System environment
- V$DBFILE view, Database
- V$DBLINK view, System environment
- V$DELETED_OBJECT view, Recovery
- V$DISPATCHER view, Multi-Threaded Server
- V$DISPATCHER_RATE view, Multi-Threaded Server
- V$DLM_CONVERT_LOCAL view, Oracle Parallel Server
- V$DLM_CONVERT_REMOTE view, Oracle Parallel Server
- V$DLM_LATCH view, Oracle Parallel Server
- V$DLM_LOCKS view, Oracle Parallel Server
- V$DLM_MISC view, Oracle Parallel Server
- V$ENABLEDPRIVS view, Security
- V$ENQUEUE_LOCK view, Locks and latches
- V$EVENT_NAME view, Configuration
- V$EXECUTION view, Parallel Query
- V$FALSE_PING view, Oracle Parallel Server
- V$FILESTAT view, System environment
- V$FILE_PING view, Oracle Parallel Server
- V$FIXED_TABLE view, System environment
- V$FIXED_VIEW_DEFINITION view, How the Dynamic Performance Data Dictionary Views Are Built, System environment
- V$GLOBAL_TRANSACTION view, System environment
- V$INDEXED_FIXED_COLUMN view, System environment
- V$INSTANCE view, Instance
- V$LATCH_CHILDREN view, Locks and latches
- V$LATCH_MISSES view, Locks and latches
- V$LATCH view, Locks and latches
- V$LATCH_PARENT view, Locks and latches
- V$LATCHHOLDER view, Locks and latches
- V$LATCHNAME view, Locks and latches
- V$LIBRARYCACHE view, Data dictionary cache
- V$LICENSE view, Configuration
- V$LOADCSTAT view, SQL*Loader direct path
- V$LOADPSTAT view, SQL*Loader direct path
- V$LOADTSTAT view, SQL*Loader direct path
- V$LOCK_ELEMENT view, Oracle Parallel Server
- V$LOCK view, Locks and latches
- V$LOCKED_OBJECT view, Locks and latches
- V$LOCKS_WITH_COLLISIONS view, Oracle Parallel Server
- V$LOCK_ACTIVITY view, Oracle Parallel Server
- V$LOG_HISTORY view, Recovery
- V$LOG view, Recovery
- V$LOGFILE view, Recovery
- V$LOGHIST view, Recovery
- V$MLS_PARAMETERS view, Configuration
- V$MTS view, Multi-Threaded Server
- V$MYSTAT view, Session
- V$NLS_PARAMETERS view, Configuration
- V$NLS_VALID_VALUES view, Configuration
- V$OBJECT_DEPENDENCY view, SQL
- V$OFFLINE_RANGE view, Database
- V$OPEN_CURSOR view, SQL
- V$OPTION view, Configuration
- V$ views, The Oracle Data Dictionary, Dynamic Performance Data Dictionary Views–System environment
- V$PARAMETER view, Configuration
- V$PING view, Oracle Parallel Server
- V$PQ_SESSTAT view, Parallel Query
- V$PQ_SLAVE view, Parallel Query
- V$PQ_SYSSTAT view, Parallel Query
- V$PQ_TQSTAT view, Parallel Query
- V$PROCESS view, Session
- V$PWFILE_USERS view, Security
- V$QUEUE view, Multi-Threaded Server
- V$RECENT_BUCKET view, SGA
- V$RECOVERY_FILE_STATUS view, Recovery
- V$RECOVERY_LOG view, Recovery
- V$RECOVERY_PROGRESS view, Recovery
- V$RECOVERY_STATUS view, Recovery
- V$RECOVER_FILE view, Recovery
- V$REQDIST view, Multi-Threaded Server
- V$RESOURCE view, Locks and latches
- V$RESOURCE_LIMIT view, SQL queries to monitor SGA utilization, System environment
- V$ROLLNAME view, System environment
- V$ROLLSTAT view, System environment
- V$ROWCACHE view, Data dictionary cache
- V$SESS_IO view, Session
- V$SESSION_CONNECT_INFO view, Session
- V$SESSION_CURSOR_CACHE view, Session
- V$SESSION_EVENT view, Session
- V$SESSION_LONGOPS view, Session
- V$SESSION_OBJECT_CACHE view, Session
- V$SESSION_WAIT view, Session
- V$SESSTAT view, Session
- V$SGA view, SGA
- V$SGASTAT view, SQL queries to monitor SGA utilization, SGA
- V$SHARED_POOL_RESERVED view, SGA
- V$SHARED_SERVER view, Multi-Threaded Server
- V$SORT_SEGMENT view, SQL
- V$SORT_USAGE view, SQL
- V$SQL_BIND_DATA view, SQL
- V$SQL_BIND_METADATA view, SQL
- V$SQL_CURSOR view, SQL
- V$SQL view, SQL
- V$SQL_SHARED_MEMORY view, SQL
- V$SQLAREA view, SQL
- V$SQLTEXT view, SQL
- V$SQLTEXT_WITH_NEWLINES view, SQL
- V$STATNAME view, Configuration
- V$SUBCACHE view, Data dictionary cache
- V$SYSSTAT view, System environment
- V$SYSTEM_EVENT view, System environment
- V$SYSTEM_PARAMETER view, Configuration
- V$TABLESPACE view, Database
- V$THREAD view, Recovery
- V$TIMER view, System environment
- V$TRANSACTION view, System environment
- V$TRANSACTION_ENQUEUE view, System environment
- V$TYPE_SIZE view, Database
- V$VERSION view, Configuration
- V$WAITSTAT view, System environment
- V$SESSION view[V SESSION view[, Session
- V$SYSTEM_CURSOR_CACHE view[V SYSTEM_CURSOR_CACHE view, System environment
- VALIDATE parameter (ENABLE clause)
- column_constraint_clause parameter (ALTER TABLE), column_constraint_clause
- table_constraint_clause parameter (CREATE TABLE), table_constraint_clause
- VALIDATE REF UPDATE parameter (ANALYZE TABLE), Keywords
- VALIDATE STRUCTURE parameter
- VALUES LESS THAN clause
- ADD PARTITION parameter, Keywords
- global_index_clause parameter (CREATE INDEX), global_index_clause
- PARTITION parameter (CREATE TABLE), partition_clause
- variable block header, Variable block header
- VAR[IABLE] command (SQL*Plus), VARIABLE
- VER[IFY] command (SQL*Plus), VERIFY
- versions of Oracle, Versions of Oracle, Software Options–Version Numbers, Oracle Directory Structure
- Video Cartridge, Data Cartridges
- VIEW auditing shortcut, Statement Auditing
- views of data dictionary (see data dictionary)
- views, data dictionary views for, Tables, clusters, and views
- Visual Image Cartridge, Data Cartridges
W
- WHEN parameter (SQL*Loader), Control File Syntax
- WHENEVER NOT SUCCESSFUL parameter, Scope of Auditing
- WHENEVER OSERROR command (SQL*Plus), WHENEVER OSERROR
- WHENEVER SQLERROR command (SQL*Plus), WHENEVER SQLERROR
- WHENEVER SUCCESSFUL parameter, Scope of Auditing
- Windows mode (Oracle installation), The Oracle Installer
- WITH ADMIN OPTION parameter (GRANT), The WITH ADMIN OPTION clause, Keywords
- WITH CHECK OPTION parameter (CREATE VIEW)
- WITH GRANT OPTION parameter (GRANT), The WITH GRANT OPTION clause, Keywords
- WITH OBJECT OID parameter (CREATE VIEW), Keywords
- WITH PRIMARY KEY clause (REFRESH, CREATE SNAPSHOT), Keywords
- WITH READ ONLY parameter (CREATE VIEW)
- WITH ROWID clause
- column_ref_clause parameter (CREATE TABLE), column_ref_clause
- REFRESH parameter (CREATE SNAPSHOT), Keywords
- WITH VALIDATION clause (EXCHANGE PARTITION, ALTER TABLE), Keywords
- WITHOUT VALIDATION clause (EXCHANGE PARTITION, ALTER TABLE), Keywords
- WRA[P] command (SQL*Plus), WRAP
- write sensitivity of data, Write sensitivity of the data
- writing to database files, DBWR—the Database Writer
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.