Book description
The second edition of O'Reilly's bestselling Oracle Essentials has been updated to include the latest Oracle release, Oracle9i.Oracle Essentials distills an enormous amount of information about Oracle's myriad technologies and releases into a compact, easy-to-read volume filled with focused text, illustrations, and helpful hints. Oracle9i promises to be an even more significant upgrade than Oracle8i, offering such major features as Real Application Clusters, flashback queries, Oracle personalization, clickstream intelligence, and Oracle Database Cache and Web Cache; it also promises significant improvements in Oracle's business intelligence, XML integration, high availability, and management capabilities. The book includes overviews of these features, as well as the new Oracle9I Application Server (Oracle9iAS) and Oracle9i Portal. The book contains chapters on:
Oracle products, options, and overall architecture for Oracle9i and other recent releases
Installing and running Oracle: creating databases, configuring Net8 (known as Oracle Net in Oracle9i), starting up and shutting down Oracle
Oracle data structures, datatypes, and ways of extending datatypes
Managing Oracle: security, the Oracle Enterprise Manager, fragmentation and reorganization, and backup and recovery
Oracle networking, monitoring, and tuning
Multi-user concurrency, online transaction processing (OLTP), and high availability
Hardware architectures (e.g., SMP, MPP, NUMA) and their impact on Oracle
Data warehousing and distributed databases
Oracle9i, Oracle8i, and the Web, including the latest Java, web, and XML technologies, interMedia, Oracle9i Application Server, and Oracle9i Portal
For new Oracle users, DBAs, developers, and managers, Oracle Essentials is an all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle9i features. But even if you already have a library full of Oracle documentation, this compact book is the one you'll turn to, again and again, as your one-stop, truly essential reference.
Table of contents
-
Oracle Essentials: Oracle9i, Oracle8i & Oracle8, 2nd Edition
- Dedication
- Preface
-
1. Introducing Oracle
- The Evolution of the Relational Database
- The Oracle Family
- Summary of Oracle Features
- Database Application Development Features
- Database Connection Features
- Distributed Database Features
- Data Movement Features
- Performance Features
- Database Management Features
- Oracle Internet Developer Suite
- Oracle Lite
- 2. Oracle Architecture
-
3. Installing and Running Oracle
- Installing Oracle
- Creating a Database
- Configuring Oracle Net/Net8
- Starting Up the Database
- Shutting Down the Database
-
Accessing a Database
- Server Processes and Clients
- Application Servers and Web Servers as Clients
- Oracle Net and Establishing Network Connections
- The Shared Server/Multi-Threaded Server
- Session Memory for Shared Server Processes Versus Dedicated Server Processes
- Data Dictionary Information About the Multi-Threaded Server
- Oracle at Work
- 4. Data Structures
- 5. Managing Oracle
-
6. Oracle Performance
- Performance Tuning Basics
- Oracle and Disk I/O Resources
- Oracle and Parallelism
- Oracle and Memory Resources
- Oracle and CPU Resources
- Avoiding Performance Problemswith Oracle9i
- Real Application Clustersand Performance
- 7. Multiuser Concurrency
- 8. Oracle and Transaction Processing
- 9. Oracle and Data Warehousing
- 10. Oracle and High Availability
- 11. Oracle and Hardware Architecture
- 12. Distributed Databases and Distributed Data
- 13. Extending Oracle Datatypes
- 14. Oracle and the Web
- A. What’s New in This Book for Oracle9i
- B. Additional Resources
- Index
- Colophon
Product information
- Title: Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition
- Author(s):
- Release date: June 2001
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596001797
You might also like
book
Oracle Built-in Packages
Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal …
video
Oracle 11g
In this Oracle 11g video based training course, through the expert tutelage of Lewis Cunningham, you …
book
Oracle 11g R1/R2 Real Application Clusters Essentials
In this book you’ll find a practical tutorial on configuring, installing, and designing Oracle 11g Real …
book
Oracle Database 10g PL/SQL Programming
Create dynamic client/server applications using PL/SQL and the comprehensive information contained in this authoritative volume. Expert …