Cover image for Oracle essentials : Oracle8 and Oracle8i
Oracle essentials : Oracle8 and Oracle8i
Greenwald, Rick.
Personal Author:
First edition.
Publication Information:
Sebastopol, CA : O'Reilly, 1999.
Physical Description:
xvi, 355 pages : illustrations ; 24 cm
General Note:
"What you need to know about oracle database architecture and features"--Cover.
Title Subject:
Subject Term:
Added Corporate Author:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 G74 1999 Adult Non-Fiction Central Closed Stacks

On Order



Oracle is an enormous system with myriad technologies, options, and releases. Most users--even experienced developers and database administrators--find it difficult to get a handle on the full scope of the Oracle system. And as each new version of the database is released, users find themselves under increasing pressure to learn about a whole range of new technologies.This book distills the enormous amount of information about what Oracle is, where it came from, and what the latest releases do--and packages it into a compact, easy-to-read volume filled with focused text, illustrations and helpful hints. It explains what's new and important about Oracle's revolutionary releases, Oracle8 (the "object-relational database") and Oracle8 i (the "Internet database"). It covers:

Oracle products, options, and overall architecture Installing and running Oracle (creating databases, configuring Net8, starting up and shutting down Oracle) Oracle data structures Managing Oracle (implementing security, using the Oracle Enterprise Manager, dealing with fragmentation and reorganization, and performing backup and recovery) Oracle networking Monitoring and tuning Multi-user concurrency and online transaction processing (OLTP) Special issues for high-availability systems Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle Data warehousing Distributed databases Extensions for Oracle8 and Oracle8 i , including the latest Java and web technologies It also includes an appendix full of references to additional online and offline resources.For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies. But even if you already have a library full of Oracle documentation and books, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference.

Table of Contents

Prefacep. xi
1. Introducing Oraclep. 1
The Evolution of the Relational Databasep. 2
The Oracle8 Familyp. 2
Summary of Oracle8/8i Featuresp. 8
Database Application Development Featuresp. 9
Database Connection Featuresp. 14
Distributed Database Featuresp. 17
Data Movement Featuresp. 19
Performance Featuresp. 21
Database Management Featuresp. 23
Oracle8i Litep. 28
2. Oracle8 Architecturep. 29
Instances and Databasesp. 29
The Components of a Databasep. 30
The Components of an Instancep. 45
3. Installing and Running Oracle8p. 51
Installing Oracle8ip. 51
Creating a Databasep. 54
Configuring Net8p. 57
Starting Up the Databasep. 61
Shutting Down the Databasep. 63
Accessing a Databasep. 64
Oracle at Workp. 71
4. Data Structuresp. 75
Datatypesp. 75
Basic Data Structuresp. 83
Additional Data Structuresp. 90
Data Designp. 92
Constraintsp. 95
Triggersp. 97
Query Optimizationp. 99
Understanding the Execution Planp. 107
Data Dictionary Tablesp. 110
5. Managing Oracle8p. 113
Implementing Securityp. 114
Management Through the Oracle Enterprise Managerp. 123
Options for Oracle Enterprise Managerp. 128
Fragmentation and Reorganizationp. 132
Backup and Recoveryp. 136
Working with Oracle Supportp. 139
6. Oracle8 Performancep. 140
Performance Tuning Basicsp. 140
Oracle8 and Disk I/O Resourcesp. 144
Oracle and Parallelismp. 152
Oracle8 and Memory Resourcesp. 161
Oracle8 and CPU Resourcesp. 167
7. Multiuser Concurrencyp. 170
Basics of Concurrent Accessp. 171
Oracle and Concurrent User Accessp. 174
Oracle8's Isolation Levelsp. 175
Oracle8 Concurrency Featuresp. 176
How Oracle8 Handles SQL Operationsp. 178
Concurrent Access and Performancep. 180
8. Oracle8 and Transaction Processingp. 183
OLTP Basicsp. 184
Oracle's OLTP Heritagep. 187
Architectures for OLTPp. 188
Oracle8 and ERP Solutionsp. 191
Oracle8 Features for OLTPp. 192
High Availabilityp. 197
Oracle8 Advanced Queuingp. 200
Object Technologies and Distributed Componentsp. 202
9. Oracle8 and Data Warehousingp. 204
Data Warehousing Basicsp. 205
Data Warehouse Designp. 209
Query Optimizationp. 211
OLAP in the Databasep. 214
Managing the Data Warehousep. 215
Other Data Warehouse Softwarep. 216
The Metadata Challengep. 224
Best Practicesp. 225
10. Oracle8 and High Availabilityp. 229
What Is High Availability?p. 230
System Crashesp. 234
Protecting Against System Crashesp. 238
Recovering from Disastersp. 252
Complete Site Failurep. 257
Data Redundancy Solutionsp. 261
11. Oracle8 and Hardware Architecturep. 265
System Basicsp. 265
Uniprocessor Systemsp. 267
Symmetric Multiprocessing Systemsp. 268
Clustersp. 270
Massively Parallel Processing Systemsp. 271
NUMA Systemsp. 273
Disk Technologyp. 274
Which Hardware Solution?p. 276
12. Distributed Databases and Distributed Datap. 279
Accessing Multiple Databases as a Single Entityp. 279
Two-Phase Commitsp. 282
Moving Data Between Distributed Systemsp. 284
Advanced Queuingp. 287
13. Oracle8/8i Extensionsp. 291
Object-Oriented Developmentp. 291
Extensibility Optionsp. 297
Using the Extensibility Framework in Oracle8ip. 303
14. Oracle8i and the Webp. 304
The Internet Computing Platformp. 304
Oracle8i as an Internet Serverp. 308
Oracle in the Middle Tierp. 312
Oracle Tools and the Internet Clientp. 317
Appendix Additional Resourcesp. 327
Web Sitesp. 327
Books and Oracle Documentationp. 328
Indexp. 335