Oracle7 Server Concepts Manual

Library

Product

---

• Oracle7^(tm) Server Concepts

• Preface
  • Audience
  • How Oracle7 Server Concepts Is Organized
  • How to Use This Manual
  • Conventions Used in This Manual
  • Your Comments Are Welcome

• What Is Oracle?

• Introduction to the Oracle Server
  • Databases and Information Management
  • The Oracle Server
  • Database Structure and Space Management
  • Oracle Server Architecture
  • Data Access
  • Data Concurrency and Consistency
  • Database Security
  • Database Backup and Recovery
  • Distributed Processing and Distributed Databases

• Basic Database Operation

• Database and Instance Startup and Shutdown
  • Introduction to Database Startup and Database Shutdown
  • Database and Instance Startup
  • Database and Instance Shutdown
  • Parameter Files

• Database Structures

• Data Blocks, Extents, and Segments
  • The Relationships Between Data Blocks, Extents, and Segments
  • Data Blocks
  • Extents
  • Segments
  • Temporary Segments

• Tablespaces and Datafiles
  • An Introduction to Tablespaces and Datafiles
  • Tablespaces
  • Datafiles

• Schema Objects
  • Overview of Schema Objects
  • Tables
  • Views
  • The Sequence Generator
  • Synonyms
  • Indexes
  • Clusters
  • Hash Clusters

• Datatypes
  • Oracle Datatypes
  • ANSI, DB2, and SQL/DS Datatypes
  • Data Conversion

• Data Integrity
  • Definition of Data Integrity
  • An Introduction to Integrity Constraints
  • Types of Integrity Constraints
  • The Mechanisms of Constraint Checking

• The Data Dictionary
  • An Introduction to the Data Dictionary
  • The Structure of the Data Dictionary
  • SYS, the Owner of the Data Dictionary
  • How the Data Dictionary Is Used
  • The Dynamic Performance Tables

• System Architecture

• Memory Structures and Processes
  • An Oracle Instance
  • Process Structure
  • Oracle Memory Structures
  • Variations in Oracle Configuration
  • Examples of How Oracle Works
  • The Program Interface

• Data Concurrency
  • Data Concurrency in a Multi-user Environment
  • How Oracle Controls Data Concurrency
  • How Oracle Locks Data

• Data Access

• SQL and PL/SQL
  • Structured Query Language (SQL)
  • PL/SQL

• Transaction Management
  • Introduction to Transactions
  • Oracle and Transaction Management
  • Discrete Transaction Management

• The Optimizer
  • What Is Optimization?
  • How Oracle Optimizes SQL Statements

• Programmatic Constructs

• Procedures and Packages
  • An Introduction to Stored Procedures and Packages
  • Procedures and Functions
  • Packages
  • How Oracle Stores Procedures and Packages
  • How Oracle Executes Procedures and Packages

• Database Triggers
  • An Introduction to Triggers
  • Parts of a Trigger
  • Trigger Execution

• Dependencies Among Schema Objects
  • An Introduction to Dependency Issues
  • Advanced Dependency Management Topics

• Database Security

• Database Access
  • Schemas, Database Users, and Security Domains
  • User Authentication
  • User Tablespace Settings and Quotas
  • The User Group PUBLIC
  • User Resource Limits and Profiles
  • Licensing

• Privileges and Roles
  • Privileges
  • Roles

• Auditing
  • Introduction to Auditing
  • Statement Auditing
  • Privilege Auditing
  • Object Auditing
  • Focusing Statement, Privilege, and Object Auditing

• Distributed Processing and Distributed Databases

• Client/Server Architecture
  • The Oracle Client/Server Architecture
  • SQL*Net

• Distributed Databases
  • An Introduction to Distributed Databases
  • Replicating Data

• Database Backup and Recovery

• Recovery Structures
  • An Introduction to Database Recovery and Recovery Structures
  • The Online Redo Log
  • The Archived Redo Log
  • Control Files
  • Survivability

• Database Backup
  • An Introduction to Database Backups
  • Read-Only Tablespaces and Backup

• Database Recovery
  • Recovery Procedures
  • Recovery Features
  • An Introduction to Database Recovery
  • Performing Recovery in Parallel
  • Recovery from Instance Failure
  • Recovery from Media Failure

• Operating System-Specific Information

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product