Special Edition Using Oracle8/8I

by Page, William G.; Austin, David; Baird, Willard; Burke, Mathew; Chase, Nicholas; Duer, Joe; Gasper, Tomas; Hotka, Dan

• ISBN13: 9780789719751
• ISBN10: 0789719754
• Edition: CD
• Format: Paperback
• Copyright: 1999-06-01
• Publisher: Que Pub

Summary

Special Edition Using Oracle8i provides you with a one-stop reference on the latest Oracle database--complete with real-life experiences and practical examples. Key updates that are covered for Oracle8I include SQLJ programming, JavaBeans, CORBA, and Java Virtual Machine. You will learn the fundamentals of Oracle database design, development and administration and progress quickly to using Oracle's tools and products to make these tasks easier and faster.

Table of Contents

I Principles of Database Management
Database, DBMS Principles and the Relational Model	11	(10)
Logical Database Design and Normalization	21	(10)
Physical Database Design, Hardware, and Related Issues	31	(14)
The Oracle Solution	45	(10)
II The Oracle 7.x RDBMS
The Oracle Database Architecture	55	(20)
The Oracle Instance Architecture	75	(22)
Exploring the Oracle Environment	97	(26)
Oracle Database Administration Overview	123	(14)
III The Oracle 8.x RDBMS
Migrating Oracle 7.x to Oracle 8.x	137	(10)
Partitioning	147	(14)
The History of Large Objects	161	(14)
Object-Oriented Features	175	(12)
Networking with Net8: New Features and Concepts	187	(10)
Oracle8i Additional Topics	197	(14)
Oracle8i Overview	211	(24)
IV Performance Tuning
Performance Tuning Fundamentals	235	(22)
Application Tuning	257	(24)
Tuning Memory	281	(22)
Tuning I/O	303	(18)
Oracle 8.x Tuning Considerations	321	(14)
V Managing the Oracle Database
Managing Database Storage	335	(38)
Identifying Heavy Resource Users	373	(46)
Security Management	419	(22)
Backup and Recovery	441	(46)
Integrity Management	487	(44)
VI Oracle Interfaces and Utilities
SQL *Plus for Administrators	531	(30)
Oracle Enterprise Manager	561	(26)
PL/SQL Fundamentals	587	(68)
Using Stored Subprograms, Packages, and the Supplied Packages	655	(32)
Using Import/Export	687	(26)
SQL *Loader	713	(26)
Designer for Administrators	739	(46)
VII Oracle Networking
Oracle Networking Fundamentals	785	(24)
The Advanced Security Option	809	(22)
VIII Oracle Application Server
Oracle Application Server (OAS)	831	(8)
Oracle Application Server Componenets	839	(32)
Installing and Configuring the OAS	871	(18)
IX Parallel and Distributed Environments
Parallel Query Management	889	(14)
Parallel Server Management	903	(48)
Distributed Database Management	951	(24)
Replication Management	975	(64)
Appendices
A Oracle on Solaris	1003	(14)
B Oracle on Windows NT	1017	(22)
Index	1039