Home
Customize
Help
Contact Us
Table of Contents for Oracle8
i
Concepts
Contents
Title Page
Index
Operating System-Specific Information
Introduction to the Oracle Server
Introduction to Databases and Information Management
Database Structure and Space Management
Memory Structure and Processes
The Object-Relational Model for Database Management
Data Concurrency and Consistency
Distributed Processing and Distributed Databases
Startup and Shutdown Operations
Database Security
Database Backup and Recovery
Data Access
Data Blocks, Extents, and Segments
Introduction to Data Blocks, Extents, and Segments
Data Blocks
Extents
Segments
Tablespaces and Datafiles
Introduction to Databases, Tablespaces, and Datafiles
Tablespaces
Datafiles
The Data Dictionary
Introduction to the Data Dictionary
How the Data Dictionary Is Used
The Dynamic Performance Tables
Database and Instance Startup and Shutdown
Introduction to an Oracle Instance
Instance and Database Startup
Database and Instance Shutdown
Memory Architecture
Introduction to Oracle Memory Structures
System Global Area (SGA)
Program Global Areas (PGA)
Sort Areas
Virtual Memory
Software Code Areas
Process Architecture
Introduction to Processes
User Processes
Oracle Processes
Multi-Threaded Server Configuration
Dedicated Server Configuration
The Program Interface
Schema Objects
Introduction to Schema Objects
Tables
Views
Materialized Views
Dimensions
The Sequence Generator
Synonyms
Indexes
Index-Organized Tables
Application Domain Indexes
Clusters
Hash Clusters
Partitioned Tables and Indexes
Introduction to Partitioning
Basic Partitioning Model
Rules for Partitioning Tables and Indexes
DML Partition Locks and Subpartition Locks
Maintenance Operations
Partition-Extended and Subpartition-Extended Table Names
Built-In Datatypes
Introduction to Oracle Datatypes
Character Datatypes
NUMBER Datatype
DATE Datatype
LOB Datatypes
RAW and LONG RAW Datatypes
ROWID and UROWID Datatypes
ANSI, DB2, and SQL/DS Datatypes
Data Conversion
User-Defined Datatypes
Introduction to User-Defined Datatypes
User-Defined Datatypes
Application Interfaces
Object Views
Introduction to Object Views
Defining Object Views
Using Object Views
Updating Object Views
SQL and PL/SQL
Introduction to Structured Query Language
SQL Processing
PL/SQL
PL/SQL Server Pages
Transaction Management
Introduction to Transactions
Oracle and Transaction Management
Discrete Transaction Management
Autonomous Transactions
Advanced Queuing
Introduction to Message Queuing
Oracle Advanced Queuing
Procedures and Packages
Introduction to Stored Procedures and Packages
Procedures and Functions
Packages
How Oracle Stores Procedures and Packages
How Oracle Executes Procedures and Packages
Triggers
Introduction to Triggers
Parts of a Trigger
Types of Triggers
Trigger Execution
Oracle Dependency Management
Introduction to Dependency Issues
Resolving Schema Object Dependencies
Dependency Management and Nonexistent Schema Objects
Shared SQL Dependency Management
Local and Remote Dependency Management
The Optimizer
Introduction to Optimization
Cost-Based Optimization
Extensible Optimization
Rule-Based Optimization
Direct-Load INSERT
Introduction to Direct-Load INSERT
Varieties of Direct-Load INSERT Statements
Additional Considerations for Direct-Load INSERT
Restrictions on Direct-Load INSERT
Parallel Execution of SQL Statements
Introduction to Parallel Execution of SQL Statements
Process Architecture for Parallel Execution
Setting the Degree of Parallelism
Parallel Query
Parallel DDL
Parallel DML
Parallel Execution of Functions
Affinity
Other Types of Parallelism
Data Concurrency and Consistency
Introduction to Data Concurrency and Consistency in a Multiuser Environment
How Oracle Manages Data Concurrency and Consistency
How Oracle Locks Data
Data Integrity
Introduction to Data Integrity
Introduction to Integrity Constraints
Types of Integrity Constraints
The Mechanisms of Constraint Checking
Deferred Constraint Checking
Constraint States
Controlling Database Access
Introduction to Database Security
Schemas, Database Users, and Security Domains
User Authentication
User Tablespace Settings and Quotas
The User Group PUBLIC
User Resource Limits and Profiles
Licensing
Privileges, Roles, and Security Policies
Introduction to Privileges
Roles
Fine-Grained Access Control
Application Context
Auditing
Introduction to Auditing
Statement Auditing
Privilege Auditing
Schema Object Auditing
Focusing Statement, Privilege, and Schema Object Auditing
Database Recovery
Introduction to Database Recovery
Structures Used for Database Recovery
Rolling Forward and Rolling Back
Improving Recovery Performance
Recovery Manager
Database Archiving Modes
Control Files
Database Backups
Survivability
Distributed Processing
Introduction to Oracle Client/Server Architecture
Distributed Processing
Net8
Multi-Tier Architecture
Replication
Introduction to Replication
Applications That Use Replication
Replication Objects, Groups, and Sites
Types of Replication Environments
Administration Tools for a Replication Environment
Replication Conflicts
Other Options for Multimaster Replication
Database Resource Management
Introduction to the Database Resource Manager
Resource Consumer Groups and Resource Plans
Resource Allocation Methods
Resource Plan Directives
Examples
Using the Database Resource Manager
Distributed Database Concepts
Introduction to Distributed Database Architecture
Database Links
Distributed Database Administration
Transaction Processing in a Distributed System
Distributed Database Application Development
National Language Support
What Is Oracle?
Database Structures
The Oracle Instance
The Object-Relational DBMS
Data Access
Optimization of SQL Statements
Parallel SQL and Direct-Load INSERT
Data Protection
Distributed Databases and Replication
Appendix
Preface
Send Us Your Comments
Copyright © 2024, Oracle and/or its affiliates. All rights reserved.