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 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 11g Anti-hacker's Cookbook
Make your Oracle database virtually impregnable to hackers using the knowledge in this book. With over …
book
Running Applications on Oracle Exadata
Maximize Application Performance on Oracle Exadata Written by an enterprise architect specializing in applications on Oracle's …
book
Pro Oracle Database 11g Administration
Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from …