Oracle Essentials : Oracle Database 10g

by Greenwald, Rick

• ISBN13: 9780596005856
• ISBN10: 0596005857
• Edition: 3rd
• Format: Paperback
• Copyright: 2004-02-01
• Publisher: Oreilly & Associates Inc

Summary

Written by experienced Oracle insiders, this introduction distills a vast amount of information into an easy-to- read volume that covers every aspect of the Oracle database. Readers of all technical levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning and much more. Augmented with illustrations and helpful hints, the third edition of Oracle Essentials offers a valuable overview of Oracle Database 10g, the industry's first database to support "grid computing", which reduces IT costs by clustering servers together to act as a single large computer. Recent releases such as Oracle 9i and 8i are also covered.

Author Biography

has been active in the world of computer software for nearly two decades, including stints with Data General, Cognos, and Gupta. He is currently an analyst with Oracle Corporation. He has been a principal author of ten books and countless articles on a variety of technical topics, and has spoken at conferences and training sessions across six continents. In addition to Oracle in a Nutshell, Rick's books include Oracle Essentials: Oracle9i, Oracle8i, and Oracle8 (principal author with Robert Stackowiak and Jonathan Stern, O'Reilly & Associates, 2001), Oracle Power Objects Developer's Guide (principal author with Kasu Sista and Richard Finklestein, Oracle Press, 1995); Mastering Oracle Power Objects (principal author with Robert Hoskins, O'Reilly & Associates, 1996); Using Oracle Web Server (principal author with many others, Que Publishing, 1997); The Oracle WebDB Bible (principal author with Jim Milbery, IDG Books Worldwide, 1999); and Administering Exchange Server (principal author with Walter Glenn, Microsoft Press, 1999).

Oracle Power Objects Developer's Guide, principal author with Kasu Sista and Richard Finklestein (Oracle Press, 1995) Mastering Oracle Power Objects, principal author with Robert Hoskins (O'Reilly & Associates, 1996) Special Edition: Using Oracle Web Server, principal author with many others (Que Publishing, 1997) The Oracle WebDB Bible, principal author with Jim Milbery (IDG Books Worldwide, 1999) Administering Exchange Server, principal author with Walter Glenn (1999) Robert Stackowiak has worked for 20 years in IT industry related roles that have included software development, management of software development, systems engineering, sales and sales consulting, and business development. He currently is recognized worldwide as a field sales expert in data warehousing at Oracle, and previously was well recognized for his work at IBM's RISC System/6000 Division, Harris Computer Systems, and the U.S. Army Corps of Engineers. Bob has spoken at numerous computer related conferences and has conducted briefings with companies based around the world. His papers regarding data warehousing and computer and software technology have appeared in publications such as The Data Warehousing Institute's Journal of Data Warehousing, Informix Tech Notes, and AIXcellence Magazine.

Jonathan Stern has over 11 years of IT experience, including senior positions in consulting, systems architecture, and technical sales. He has in-depth experience with the Oracle RDBMS across all major open systems hardware and operating systems, covering tuning, scaling and parallelism, Parallel Server, high availability, data warehousing, OLTP, object-relational databases, N-tier architectures, and emerging trends such as Java and CORBA. He is the Central USA Technical Team Leader at Ariba, Inc., the leading vendor of electronic commerce solutions for strategic procurement. Previously, he led a team of highly experienced database specialists at Oracle Corporation providing technical depth and strategic assistance to Oracle's largest customers in the North Central USA. Jonathan has authored papers and presented at internal and external conferences on topics such as scaling with Oracle's dynamic parallelism and the role of reorganizing segments in an Oracle database.

Table of Contents

Preface	xi
1. Introducing Oracle	1	(30)
The Evolution of the Relational Database	2	(4)
The Oracle Family	6	(2)
Summary of Oracle Features	8	(1)
Database Application Development Features	9	(4)
Database Connection Features	13	(4)
Distributed Database Features	17	(1)
Data Movement Features	18	(2)
Performance Features	20	(2)
Database Management Features	22	(5)
Oracle Developer Suite	27	(2)
Oracle Lite	29	(2)
2. Oracle Architecture	31	(22)
Instances and Databases	31	(1)
The Components of a Database	32	(14)
The Components of an Instance	46	(5)
The Data Dictionary	51	(2)
3. Installing and Running Oracle	53	(27)
Installing Oracle	53	(3)
Creating a Database	56	(4)
Configuring Oracle Net	60	(5)
Starting Up the Database	65	(2)
Shutting Down the Database	67	(1)
Accessing a Database	68	(7)
Oracle at Work	75	(5)
4. Data Structures	80	(38)
Datatypes	80	(8)
Basic Data Structures	88	(6)
Additional Data Structures	94	(3)
Data Design	97	(2)
Constraints	99	(3)
Triggers	102	(2)
Query Optimization	104	(8)
Understanding the Execution Plan	112	(3)
SQL Tuning Advisor	115	(1)
Data Dictionary Tables	116	(2)
5. Managing Oracle	118	(24)
Management and Enterprise Manager	119	(6)
Oracle Database 10g Self-Tuning and Management	125	(2)
Implementing Security	127	(9)
Fragmentation and Reorganization	136	(1)
Backup and Recovery	137	(3)
Working with Oracle Support	140	(2)
6. Oracle Performance	142	(33)
Performance Tuning Basics	142	(4)
Oracle and Disk I/O Resources	146	(9)
Oracle and Parallelism	155	(8)
Oracle and Memory Resources	163	(6)
Oracle and CPU Resources	169	(2)
Database Resource Manager	171	(1)
Monitoring	172	(2)
Real Application Clusters and Performance	174	(1)
7. Multiuser Concurrency	175	(15)
Basics of Concurrent Access	176	(3)
Oracle and Concurrent User Access	179	(1)
Oracle's Isolation Levels	180	(1)
Oracle Concurrency Features	181	(2)
How Oracle Handles Locking	183	(2)
Concurrent Access and Performance	185	(2)
Workspaces	187	(3)
8. Oracle and Transaction Processing	190	(21)
OLTP Basics	191	(3)
Oracle's OLTP Heritage	194	(1)
Architectures for OLTP	195	(5)
Oracle Features for OLTP	200	(5)
High Availability	205	(1)
Oracle Advanced Queuing and Streams	206	(3)
Object Technologies and Distributed Components	209	(2)
9. Oracle and Data Warehousing	211	(26)
Business Intelligence Basics	212	(4)
Data Warehouse Design	216	(2)
Query Optimization	218	(3)
Analytics, OLAP, and Data Mining in the Database	221	(2)
Managing the Data Warehouse	223	(1)
Other Data Warehouse Software	224	(8)
The Metadata Challenge	232	(1)
Best Practices	233	(4)
10. Oracle and High Availability	237	(37)
What Is High Availability?	237	(4)
System Crashes	241	(5)
Protecting Against System Crashes	246	(13)
Recovering from Disasters	259	(7)
Complete Site Failure	266	(4)
Data Redundancy Solutions	270	(4)
11. Oracle and Hardware Architecture	274	(15)
System Basics	274	(2)
Uniprocessor Systems	276	(1)
Symmetric Multiprocessing Systems	277	(2)
Clusters	279	(1)
Massively Parallel Processing Systems	280	(2)
Non-Uniform Memory Access Systems	282	(1)
Grid Computing	283	(2)
Disk Technology	285	(1)
Which Platform Deployment Solution?	286	(3)
12. Distributed Databases and Distributed Data	289	(13)
Accessing Multiple Databases as a Single Entity	289	(3)
Two-Phase Commits	292	(2)
Moving Data Between Distributed Systems	294	(3)
Advanced Queuing	297	(2)
Oracle Streams	299	(3)
13. Extending Oracle Datatypes	302	(12)
Object-Oriented Development	302	(6)
Extensibility Features and Options	308	(4)
Using the Extensibility Framework in Oracle	312	(2)
14. Network Deployment Models	314	(25)
The Impact of the Internet	314	(1)
The Oracle Database and the Internet	315	(6)
Oracle Application Server	321	(12)
Grid Computing	333	(6)
A. What's New in This Book for Oracle Database10g	339	(8)
B. Additional Resources	347	(10)
Index	357