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
- ALTER USER command, Keywords
- CREATE USER command, Keywords
- ACCOUNT UNLOCK parameter
- ALTER USER command, Keywords
- CREATE USER command, Keywords
- 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
- ALTER CLUSTER command, Keywords
- ALTER INDEX command, Keywords
- ALTER TABLE command, Keywords
- allocating
- disk
allocation, Disk Allocation–About RAID
- memory (see memory)
- storage (see storage)
- ALLOW_PARTIAL_SN_RESULTS parameter, ALLOW_PARTIAL_SN_RESULTS
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- DATAFILE parameter (CREATE CONTROL FILE), Keywords
- LOGFILE parameter (CREATE DATABASE), Keywords
- 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
- CREATE DIRECTORY command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE TABLE command, Keywords
- CREATE VIEW command, Keywords
- CREATE VIEW command (relational views), Keywords
- 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)
- ALTER SESSION
command, Keywords
- ALTER SYSTEM
command, Keywords
- 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
- ALTER PACKAGE
command, Keywords
- DROP PACKAGE command, Keyword
- 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
- AUDIT command (schema objects), Keywords
- AUDIT command (SQL statements), Keywords
- BY parameter (NOAUDIT), Keywords
- BY SESSION parameter, Scope of Auditing
- AUDIT command (schema objects), Keywords
- AUDIT command (SQL statements), Keywords
- 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
- ALTER SEQUENCE
command, Keywords
- ALTER SESSION command, Keywords
- ALTER TABLE command, Keywords
- CREATE CLUSTER command, Keywords
- CREATE SEQUENCE command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE TABLE command, Keywords
- CACHE_SIZE_THRESHOLD parameter, CACHE_SIZE_THRESHOLD
- Cartesian
products, Cartesian Product
- CASCADE CONSTRAINTS parameter
- DROP CLUSTER command, Keywords
- DROP TABLE command, Keyword
- DROP TABLESPACE command, Keywords
- CASCADE
parameter
- CREATE TABLE command, Keywords
- DROP
CONSTRAINT command, Keywords
- DROP PROFILE command, Keyword
- DROP USER command, Keyword
- 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
- CREATE INDEX command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE TABLE command, Keywords
- 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
- ALTER PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- 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
- ALTER CLUSTER command, Keywords
- ANALYZE INDEX command, Keywords
- ANALYZE TABLE command, Keywords
- 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
- ALTER PROFILE
command, Keywords
- ALTER
RESOURCE COST command, Keywords
- CREATE PROFILE command, Keywords
- 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
- ALTER
PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- CPU_PER_SESSION parameter, Resource control
- ALTER PROFILE
command, Keywords
- ALTER RESOURCE COST command, Keywords
- CREATE PROFILE command, Keywords
- 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
- ALTER
SEQUENCE command, Keywords
- CREATE SEQUENCE command, Keywords
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
- availability of, Availability of the Dynamic Performance Data Dictionary Views–Availability of the Dynamic Performance Data Dictionary Views
- global (GV$
views), The Global Dynamic Performance Data Dictionary Views (GV$ Views)
- Oracle8, New Views with Oracle8
- 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
- CREATE CONTROLFILE command, Keywords
- CREATE DATABASE command, Keywords
- CREATE TABLESPACE command, Keywords
- 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
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- ALTER CLUSTER command, Keywords
- ALTER INDEX, Keywords
- ALTER TABLE command, Keywords
- 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
- ALTER USER command, Keywords
- CREATE USER command, Keywords
- DEFAULT STORAGE parameter, Tables
- ALTER TABLESPACE command, Keywords
- CREATE TABLESPACE command, Keywords
- DEFAULT TABLESPACE parameter
- ALTER USER command, Keywords
- CREATE USER command, Keywords
- 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
- ALTER CLUSTER command, Keywords
- ANALYZE INDEX command, Keywords
- ANALYZE TABLE command, Keywords
- 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
- ALTER INDEX command, Keywords
- ALTER TABLE command, Keywords
- 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
- TRUNCATE CLUSTER command, Keywords
- TRUNCATE TABLE command, Keywords
- 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
- ALTER CLUSTER command, Keywords
- ANALYZE INDEX command, Keywords
- ANALYZE TABLE command, Keywords
- 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
- ALTER PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- FALSE value
(SORT_DIRECT_WRITES)
- ALTER SESSION
command, Keywords
- ALTER SYSTEM
command, Keywords
- 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
- CREATE SYNONYM
command, Keywords
- EXPLAIN PLAN command, Keywords
- FOR TABLE clause (ANALYZE TABLE), for_clause
- FOR UPDATE parameter (CREATE SNAPSHOT), Keywords
- FORCE ANY TRANSACTION privilege, Summary of System Privileges
- FORCE parameter
- CREATE VIEW command (object views), Keywords
- CREATE VIEW (relational views), Keywords
- 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
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- GLOBAL keyword
(CREATE INDEX), Partitioned tables
- GLOBAL
value
- CHECK DATAFILES
parameter, Keywords
- CHECKPOINT
parameter, Keywords
- 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
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- ALTER ROLE
command, Keywords
- ALTER USER command, Keywords
- CREATE ROLE command, Keywords
- CREATE USER command, Keywords
- IDENTIFIED GLOBALLY
parameter
- ALTER ROLE
command, Keywords
- ALTER USER command, Keywords
- CREATE ROLE command, Keywords
- CREATE USER command, Keywords
- IDLE_TIME parameter
- ALTER
PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- 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
- CREATE FUNCTION command, Keywords
- CREATE PROCEDURE command, Keywords
- 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
- ALTER
SEQUENCE command, Keywords
- CREATE SEQUENCE command, Keywords
- 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
- DEFAULT
STORAGE parameter, Tables, Keywords
- STORAGE
parameter, INITIAL, Keywords, Keywords
- (see also STORAGE
parameter)
- USING INDEX
parameter, Keywords
- 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
- ALTER SESSION command, Keywords
- SET TRANSACTION command, Keywords
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
- KEEP clause (DEALLOCATE
UNUSED)
- ALTER CLUSTER
command, Keywords
- ALTER INDEX command, Keywords
- ALTER TABLE
command, Keywords
- KILL SESSION parameter (ALTER SYSTEM), Keywords
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
- ALTER CLUSTER command, Keywords
- ANALYZE TABLE command, Keywords
- 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
- CHECK DATAFILES
parameter (ALTER SYSTEM), Keywords
- CHECKPOINT parameter
(ALTER SYSTEM), Keywords
- 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
- CREATE CONTROLFILE command, Keywords
- CREATE DATABASE command, Keywords
- 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
- ALTER PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- LOGICAL_READS_PER_SESSION parameter, Resource control
- ALTER PROFILE
command, Keywords
- ALTER RESOURCE COST
command, Keywords
- CREATE PROFILE command, Keywords
- 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
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- DATAFILE parameter (CREATE CONTROLFILE), Keywords
- LOGFILE parameter (CREATE DATABASE), Keywords
- MAXEXTENTS clause (ALTER
CLUSTER), Keywords, Keywords
- (see also DEFAULT STORAGE parameter; STORAGE
parameter)
- MAXEXTENTS parameter (ALTER
CLUSTER), Tables
- maximizing
performance (see performance)
- MAXINSTANCES clause
- DATAFILE parameter (CREATE CONTROLFILE), Keywords
- LOGFILE parameter (CREATE DATABASE), Keywords
- MAXLOGFILES clause
- DATAFILE parameter (CREATE CONTROLFILE), Keywords
- LOGFILE parameter (CREATE DATABASE), Keywords
- MAXLOGHISTORY clause
- DATAFILE parameter (CREATE CONTROLFILE), Keywords
- LOGFILE parameter (CREATE DATABASE), Keywords
- MAXLOGMEMBERS clause
- DATAFILE parameter (CREATE CONTROLFILE), Keywords
- LOGFILE parameter (CREATE DATABASE), Keywords
- 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
- ALTER
SEQUENCE command, Keywords
- CREATE SEQUENCE command, Keywords
- 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
- DEFAULT
STORAGE parameter (CREATE
TABLESPACE), Keywords
- STORAGE
parameter, Keywords
- (see also STORAGE
parameter)
- STORAGE
parameter (CREATE CLUSTER), Keywords
- USING INDEX
parameter (ALTER SNAPSHOT), Keywords
- MINIMUM EXTENT parameter
- ALTER TABLESPACE command, Keywords
- CREATE TABLESPACE command, Keywords
- MINVALUE parameter
- ALTER
SEQUENCE command, Keywords
- CREATE SEQUENCE command, Keywords
- 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
- DATAFILE parameter (CREATE CONTROLFILE), Keywords
- LOGFILE parameter (CREATE DATABASE), Keywords
- NOARCHIVELOG parameter (ALTER DATABASE
ARCHIVELOG), Keywords
- NOAUDIT command, Disabling Auditing, NOAUDIT
- NOCACHE hint, Additional hints
- NOCACHE parameter
- ALTER
SEQUENCE command, Keywords
- ALTER
SESSION command, Keywords
- ALTER TABLE command, Keywords
- CREATE CLUSTER command, Keywords
- CREATE SEQUENCE command, Keywords
- CREATE SNAPSHOT command, Keywords
- CREATE TABLE command, Keywords
- NOCYCLE parameter
- ALTER
SEQUENCE command, Keywords
- CREATE SEQUENCE command, Keywords
- 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
- ALTER
SEQUENCE command, Keywords
- CREATE SEQUENCE command, Keywords
- NOPARALLEL hint, Parallel operation hints
- NOPARALLEL parameter
- ALTER
CLUSTER 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
- NOPARALLEL_INDEX hint, Parallel operation hints
- NORESETLOGS clause (LOGFILE, CREATE
CONTROLFILE), Keywords
- NORESETLOGS parameter (ALTER DATABASE OPEN), Keywords
- NOREVERSE parameter
- ALTER INDEX REBUILD command, Keywords
- ALTER INDEX REBUILD PARTITION command, Keywords
- 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
- ALTER ROLE
command, Keywords
- CREATE ROLE command, Keywords
- 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)
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- OBJECT_CACHE_OPTIMAL_SIZE parameter, OBJECT_CACHE_OPTIMAL_SIZE (Oracle8 Only)
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- ALTER
ROLLBACK SEGMENT command, Keywords
- ALTER TABLESPACE command, Keywords
- CREATE TABLESPACE command, Keywords
- 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
- ALTER
ROLLBACK SEGMENT command, Keywords
- ALTER TABLESPACE command, Keywords
- CREATE TABLESPACE command, Keywords
- 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)
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- CREATE DIRECTORY command, Keywords
- CREATE FUNCTION command, Keywords
- CREATE PACKAGE BODY command, Keywords
- CREATE PACKAGE command, Keywords
- CREATE PROCEDURE command, Keywords
- CREATE TRIGGER command, Keywords
- CREATE VIEW command
- object views, Keywords
- relational views, Keywords
- 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
- ALTER
SEQUENCE command, Keywords
- CREATE SEQUENCE command, Keywords
- 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)
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- ALTER USER command, Keywords
- CREATE USER command, Keywords
- 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
- ALTER PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- PASSWORD_LIFE_TIME parameter, Password control
- ALTER PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- PASSWORD_LOCK_TIME parameter, Password control
- ALTER PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- PASSWORD_REUSE_MAX parameter, Password control
- ALTER PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- PASSWORD_REUSE_TIME parameter, Password control
- ALTER PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- PASSWORD_VERIFY_FUNCTION parameter, Password control
- ALTER PROFILE command, Keywords
- CREATE PROFILE command, Keywords
- 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
- ALTER TABLESPACE command, Keywords
- CREATE TABLESPACE command, Keywords
- 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)
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- ALTER PROFILE command, Keywords
- ALTER
RESOURCE COST command, Keywords
- CREATE PROFILE command, Keywords
- 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
- ALTER USER command, Keywords
- CREATE USER command, Keywords
- 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
- ALTER USER command, Keywords
- CREATE USER command, Keywords
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
- ALTER TABLESPACE command, Keywords
- SET TRANSACTION command, Keywords
- READ
privilege, Object Privileges
- read sensitivity of data, Read sensitivity of the data
- READ WRITE parameter
- ALTER TABLESPACE command, Keywords
- SET TRANSACTION command, Keywords
- 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
- ALTER SESSION command, Keywords
- CREATE SNAPSHOT command, Keywords
- REM[ARK] command (SQL*Plus), REMARK
- REMOTE_DEPENDENCIES_MODE parameter, REMOTE_DEPENDENCIES_MODE
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- ALTER INDEX command, Keywords
- ALTER TABLESPACE command, Keywords
- RENAME PARTITION parameter
- ALTER INDEX, Keywords
- ALTER TABLE command, Keywords
- 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
- CREATE CONTROLFILE command, Keywords
- CREATE DATABASE command, Keywords
- filespec parameter (CREATE LIBRARY), Keywords
- REUSE STORAGE parameter
- TRUNCATE CLUSTER command, Keywords
- TRUNCATE TABLE command, Keywords
- REVERSE parameter
- ALTER INDEX REBUILD command, Keywords
- ALTER INDEX REBUILD PARTITION command, Keywords
- CREATE INDEX command, Keywords
- 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
- ALTER PROFILE
command, Keywords
- CREATE PROFILE command, Keywords
- 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
- ALTER SESSION
command, Keywords
- ALTER SYSTEM
command, Keywords
- CREATE CONTROLFILE command, Keywords
- 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.
- monitoring, Memory utilization–SQL queries to monitor SGA utilization
- 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
- ALLOCATE EXTENT
parameter, Keywords, Keywords
- filespec
parameter (CREATE DATABASE), filespec
- filespec parameter (CREATE LIBRARY), Keywords
- SIZE parameter
- ALTER CLUSTER command, Keywords
- CREATE CLUSTER command, Keywords
- 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
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- SORT_AREA_SIZE
parameter, Sort Areas, Initialization Parameters, Sort Areas, SORT_AREA_SIZE
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- sort
areas, Sort Areas, Sort Areas
- SORT_DIRECT_WRITES parameter, Initialization Parameters, SORT_DIRECT_WRITES
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- SORT_READ_FAC parameter, SORT_READ_FAC
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- SORT_SPACEMAP_SIZE parameter, SORT_SPACEMAP_SIZE
- SORT_WRITE_BUFFER_SIZE parameter, SORT_WRITE_BUFFER_SIZE
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- SORT_WRITE_BUFFERS parameter, SORT_WRITE_BUFFERS
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- SORTED INDEXES parameter (SQL*Loader), Control File Syntax
- Spatial Cartridge, Data Cartridges
- SPIN_COUNT parameter, SPIN_COUNT
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- ALTER SESSION command, Keywords
- CREATE SCHEMA command, Keywords
- 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)
- ALTER SNAPSHOT
command, Keywords
- CREATE SNAPSHOT
command, Keywords
- 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
- ALTER USER command, Keywords
- CREATE USER command, Keywords
- temporary tablespaces, Temporary Tablespaces, Temporary tablespaces
- TERM[OUT] command (SQL*Plus), TERMOUT
- TEXT_ENABLED parameter
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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
- ALTER SESSION command, Keywords
- ALTER SYSTEM command, Keywords
- 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)
- ALTER SESSION
command, Keywords
- ALTER SYSTEM
command, Keywords
- 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
- availability
of, Availability of the Dynamic Performance Data Dictionary Views–Availability of the Dynamic Performance Data Dictionary Views
- global (GV$
views), The Global Dynamic Performance Data Dictionary Views (GV$ Views)
- Oracle8, New Views with Oracle8
- 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
- ALTER CLUSTER command, Keywords
- ANALYZE INDEX command, Keywords
- ANALYZE TABLE command, Keywords
- 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
- AUDIT command (schema objects), Keywords
- AUDIT command (SQL
statements), Keywords
- NOAUDIT command, Keywords
- WHENEVER OSERROR command (SQL*Plus), WHENEVER OSERROR
- WHENEVER SQLERROR command (SQL*Plus), WHENEVER SQLERROR
- WHENEVER SUCCESSFUL parameter, Scope of Auditing
- AUDIT command (schema objects), Keywords
- AUDIT command (SQL
statements), Keywords
- NOAUDIT command, Keywords
- Windows mode (Oracle
installation), The Oracle Installer
- WITH ADMIN OPTION parameter
(GRANT), The WITH ADMIN OPTION clause, Keywords
- WITH CHECK OPTION parameter (CREATE VIEW)
- object views, Keywords
- relational views, Keywords
- 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)
- object views, Keywords
- relational views, Keywords
- 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.