Oracle Essentials : Oracle9i, Oracle8i & Oracle8 (2nd Edition) [Paperback]

Rick Greenwald (Author), Robert Stackowiak (Author), Jonathan Stern (Author)

Book Description

ISBN-10: 0596001797 | ISBN-13: 978-0596001797 | Publication Date: June 15, 2001 | Edition: Second Edition

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.

Editorial Reviews

Review

'excellent overview'. Computer Bulletin, November 2001 (****)

About the Author

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.

Product Details

• Paperback: 450 pages
• Publisher: O'Reilly Media; Second Edition edition (June 15, 2001)
• Language: English
• ISBN-10: 0596001797
• ISBN-13: 978-0596001797
• Product Dimensions: 9.1 x 7.1 x 1.1 inches
• Shipping Weight: 1.4 pounds
• Average Customer Review: 4.1 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #2,270,512 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

22 of 23 people found the following review helpful:

3.0 out of 5 stars Essential...if you're familiar with Oracle already, July 12, 2001

By A Customer

This review is from: Oracle Essentials : Oracle9i, Oracle8i & Oracle8 (2nd Edition) (Paperback)

Having read the first chapter and a half in this book, I find this book harder to read than other books. It assumes that you are somehow familiar with the mechanics of how Oracle systems work. I guess if you are already familiar with Oracle, this book would be a good companion book; but if you're like me...trying to learn Oracle, you will need to read this book over VERY carefully since the author is not really clear in what he has to say. Therefore I recommend this book for seasoned professionals, but not beginners trying to learn Oracle.

3 of 4 people found the following review helpful:

5.0 out of 5 stars Clear, concise, and very informative!!, January 7, 2002

By A Customer

This review is from: Oracle Essentials : Oracle9i, Oracle8i & Oracle8 (2nd Edition) (Paperback)

I picked this book up to re-aquaint myself with Oracle. As a developer, I typically only dive into SQL-PLUS and data modeling. This book explains everything a developer needs to know about the vast, and I mean VAST feature set of Oracle. Plus this book brought me up to speed on 9i... Such as features in 9i such as Real Application Clusters, a new XML datatype, and the CREATE TABLE... AS SELECT.

This book is perfect for an application developer, an IT manager, or a beginning DBA new to Oracle. This book is worth twice its price!! Kudos to Greenwald, Stern, and Stackowiak.

2 of 3 people found the following review helpful:

4.0 out of 5 stars Nice book to keep for reference, February 20, 2003

By 

"conniezhao" (pittsburgh, PA) - See all my reviews

This review is from: Oracle Essentials : Oracle9i, Oracle8i & Oracle8 (2nd Edition) (Paperback)

This book gives you not only detailed explaination on very facet of Oracle in a plain, easy to understand language but also displays a clear map of how each components related and how they work together. That is, in my opinion, very important to understand Oracle.

The book gives a high-level overview of almost everything. Totally worth the money.