Expert Oracle

Thomas Kyte has a simple philosophy: You can treat Oracle as a black box and shove data inside of it, or you can learn how Oracle works and exploit it as a powerful computing environment. If you choose the latter, you will see there are few information management problems you cannot solve quickly an...

Full description

Bibliographic Details
Main Author: Kyte, Thomas (Author)
Corporate Author: SpringerLink (Online service)
Format: Electronic eBook
Language:English
Published: Berkeley, CA : A-Press, 2005.
Subjects:
Online Access:Full Text via HEAL-Link
Table of Contents:
  • Setting Up
  • Developing Successful Oracle Applications
  • Architecture
  • Locking and Concurrency
  • Transactions
  • Redo and Rollback
  • Database Tables
  • Indexes
  • Import and Export
  • Data Loading
  • Tuning Strategies and Tools
  • Optimizer Plan Stability
  • Analytic Functions
  • Materialized Views
  • Partitioning
  • Autonomous Transactions
  • Dynamic SQL
  • interMedia
  • C-Based External Procedures
  • Java Stored Procedures
  • Using Object Relational Features
  • Fine Grained Access Control
  • n-Tier Authentication
  • Invoker and Definer Rights.