Oracle Essentials: Oracle9i, Oracle8i and Oracle8

Overview

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 ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (25) from $1.99   
  • New (7) from $1.99   
  • Used (18) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since 2005

Feedback rating:

(136)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
2001-06-15 Paperback New Never Used-No Marks or Highlights-Ships with Tracking #

Ships from: Zephyrhills, FL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$5.92
Seller since 2008

Feedback rating:

(177)

Condition: New
0596001797 BRAND NEW NEVER USED IN STOCK 125,000+ HAPPY CUSTOMERS SHIP EVERY DAY WITH FREE TRACKING NUMBER

Ships from: fallbrook, CA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$8.99
Seller since 2008

Feedback rating:

(0)

Condition: New
Book is new and unused. The pages are clean and crisp. Covers may show normal shelf wear. Spine and binding are excellent.

Ships from: Flemington, NJ

Usually ships in 1-2 business days

  • Standard, 48 States
$30.51
Seller since 2015

Feedback rating:

(367)

Condition: New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$45.00
Seller since 2015

Feedback rating:

(241)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$45.00
Seller since 2015

Feedback rating:

(241)

Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
$74.95
Seller since 2008

Feedback rating:

(220)

Condition: New

Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

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.
Read More Show Less

Product Details

  • ISBN-13: 9780596001797
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 6/19/2001
  • Edition description: Second Edition
  • Edition number: 2
  • Pages: 384
  • Product dimensions: 7.06 (w) x 9.18 (h) x 0.95 (d)

Meet 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.

Read More Show Less

Table of Contents

Dedication;
Preface;
Goals of This Book;
Audience for This Book;
About the Second Edition (Oracle9i);
Structure of This Book;
Conventions Used in This Book;
How to Contact Us;
Acknowledgments;
Chapter 1: Introducing Oracle;
1.1 The Evolution of the Relational Database;
1.2 The Oracle Family;
1.3 Summary of Oracle Features;
1.4 Database Application Development Features;
1.5 Database Connection Features;
1.6 Distributed Database Features;
1.7 Data Movement Features;
1.8 Performance Features;
1.9 Database Management Features;
1.10 Oracle Internet Developer Suite;
1.11 Oracle Lite;
Chapter 2: Oracle Architecture;
2.1 Instances and Databases;
2.2 The Components of a Database;
2.3 The Components of an Instance;
2.4 The Data Dictionary;
Chapter 3: Installing and Running Oracle;
3.1 Installing Oracle;
3.2 Creating a Database;
3.3 Configuring Oracle Net/Net8;
3.4 Starting Up the Database;
3.5 Shutting Down the Database;
3.6 Accessing a Database;
3.7 Oracle at Work;
Chapter 4: Data Structures;
4.1 Datatypes;
4.2 Basic Data Structures;
4.3 Additional Data Structures;
4.4 Data Design;
4.5 Constraints;
4.6 Triggers;
4.7 Query Optimization;
4.8 Understanding the Execution Plan;
4.9 Data Dictionary Tables;
Chapter 5: Managing Oracle;
5.1 Implementing Security;
5.2 Management Through the Oracle Enterprise Manager;
5.3 Options for Oracle Enterprise Manager;
5.4 Fragmentation and Reorganization;
5.5 Backup and Recovery;
5.6 Working with Oracle Support;
Chapter 6: Oracle Performance;
6.1 Performance Tuning Basics;
6.2 Oracle and Disk I/O Resources;
6.3 Oracle and Parallelism;
6.4 Oracle and Memory Resources;
6.5 Oracle and CPU Resources;
6.6 Avoiding Performance Problemswith Oracle9i;
6.7 Real Application Clustersand Performance;
Chapter 7: Multiuser Concurrency;
7.1 Basics of Concurrent Access;
7.2 Oracle and Concurrent User Access;
7.3 Oracle’s Isolation Levels;
7.4 Oracle Concurrency Features;
7.5 How Oracle Handles Locking;
7.6 Concurrent Access and Performance;
7.7 Workspaces;
Chapter 8: Oracle and Transaction Processing;
8.1 OLTP Basics;
8.2 Oracle’s OLTP Heritage;
8.3 Architectures for OLTP;
8.4 Oracle Features for OLTP;
8.5 High Availability;
8.6 Oracle Advanced Queuing;
8.7 Object Technologies and Distributed Components;
Chapter 9: Oracle and Data Warehousing;
9.1 Data Warehousing Basics;
9.2 Data Warehouse Design;
9.3 Query Optimization;
9.4 OLAP in the Database;
9.5 Managing the Data Warehouse;
9.6 Other Data Warehouse Software;
9.7 The Metadata Challenge;
9.8 Best Practices;
Chapter 10: Oracle and High Availability;
10.1 What Is High Availability?;
10.2 System Crashes;
10.3 Protecting Against System Crashes;
10.4 Recovering from Disasters;
10.5 Complete Site Failure;
10.6 Data Redundancy Solutions;
Chapter 11: Oracle and Hardware Architecture;
11.1 System Basics;
11.2 Uniprocessor Systems;
11.3 Symmetric Multiprocessing Systems;
11.4 Clusters;
11.5 Massively Parallel Processing Systems;
11.6 Nonuniform Memory Access Systems;
11.7 Disk Technology;
11.8 Which Hardware Solution?;
Chapter 12: Distributed Databases and Distributed Data;
12.1 Accessing Multiple Databases as a Single Entity;
12.2 Two-Phase Commits;
12.3 Moving Data Between Distributed Systems;
12.4 Advanced Queuing;
Chapter 13: Extending Oracle Datatypes;
13.1 Object-Oriented Development;
13.2 Extensibility Features and Options;
13.3 Using the Extensibility Framework in Oracle;
Chapter 14: Oracle and the Web;
14.1 The Internet Computing Platform;
14.2 Oracle as an Internet Server;
14.3 XML;
14.4 Dynamic Services;
14.5 Oracle Internet Application Server;
14.6 Oracle9iAS Portal;
What’s New in This Book for Oracle9i;
Chapter 1;
Chapter 2;
Chapter 3;
Chapter 4;
Chapter 5;
Chapter 6;
Chapter 7;
Chapter 8;
Chapter 9;
Chapter 10;
Chapter 11;
Chapter 12;
Chapter 13;
Chapter 14;
Additional Resources;
Web Sites;
Books and Oracle Documentation;
Colophon;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)