Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Oracle Database 10g Insider Solutions 1st Edition

5.0 out of 5 stars 9 customer reviews
ISBN-13: 978-0672327919
ISBN-10: 0672327910
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
In Stock. Sold by hippo_books
Condition: Used: Very Good
Comment: Very Good: Cover and pages show some wear from reading and storage.
Access codes and supplements are not guaranteed with used items.
16 Used from $0.05
+ $3.99 shipping
More Buying Choices
11 New from $18.18 16 Used from $0.05 1 Collectible from $9.85
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

The Amazon Book Review
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
click to open popover

Editorial Reviews

About the Author

Dr. Arun Kumar has 10+ years of experience in Oracle Database Administration, including multidimensional, decision support systems and ERP software. He has worked on a wide variety of projects and environments ranging from client-server, E-Business to managed services across database systems. John Kanagaraj is a Principal Consultant with DB Soft Inc. He has been working with various flavors of UNIX since '84 and with Oracle since '88, mostly as a Developer/DBA/Apps DBA and System Administrator. Richard Stroupe is President of TRS Consulting LLC, a Northern Virginia based consulting firm that specializes in Oracle development, administration and training for the Federal government.

Excerpt. © Reprinted by permission. All rights reserved.



Oracle Corporation released its flagship Oracle Database 10g relational database management system in February of 2004. This new version not only arrived with a slew of features, it fundamentally changed the way certain functions and operations are done in the database. When combined with the comprehensive but voluminous documentation set, it is no wonder that first-time users and even experienced Oracle technicians stumble during implementation of this new version. They want to get the best of Oracle Database 10g, but are faced with plowing through the thousands of pages in the 150-odd manuals, searching for nuggets to implement and exploit.

If this describes you, a solution to this problem is now in your hands. This book has been written by a trio of experienced Oracle professionals who have faced and overcome the very same issues you face. Having worked in the trenches with previous versions of Oracle products, and now with this new version, they have distilled their combined real-life experiences into this tome. We hope you enjoy reading this book and discovering the nuggets that the authors have laid out for you in the subsequent pages!

Who Should Read This Book

This book is for anyone who has to work with Oracle Database 10g. Primarily written for database administrators, it caters to database architects as well as developers who would like to know how this new version affects their enterprise and their applications. The chapters are replete with examples and code that the authors themselves have used and tested so you can apply them confidently in a real-life situation.

This book, however, is not designed to act as an introductory book or even a comprehensive reference of new features in Oracle Database 10g. Only those features that are useful and have the most bang-for-the-buck in practical terms are listed and discussed. Such topics are covered in depth and, where warranted, additional sources for reading from manuals and MetaLink notes are recommended.

What You Need to Use This Book

This book covers Oracle Database 10g Release 1 as well as Release 2 of the product, making specific reference to the latter where necessary. Hence, you need to use a supported version of Oracle Database 10g Release 1 at the least. By default, the features and code listed would work for installations that use Oracle Database Release 1 on any operating-system platform unless specifically mentioned otherwise. All SQL code listed is operating-system neutral unless UNIX-style directories are referred to within the code. In certain cases, UNIX-based shell scripts have been used as wrappers around SQL code to demonstrate a few features in principle. These scripts can easily be adapted to Windows and should work without change if they are executed under an emulator such as CygWin or MKS Toolkit. Please note that some of the database features are available only when licensed separately. These are specifically indicated.

Throughout the text, we refer to a number of manuals and MetaLink notes. Although the manuals are available both online at http://tahiti.oracle.com and with the software distribution, all readers may not have access to MetaLink. If you do not have a MetaLink account that can be used to access these notes, you can easily create one at http://metalink.oracle.com using your Customer Support Identifier (CSI). This should be available from whomever administers your Oracle Support Contract.

How This Book Is Organized

This book is divided into five logical parts. Chapters within these sections deal with specific topics related to that area. The parts are as follows:

  • Part I, "Getting Started with Oracle Database 10g." This part provides an introduction to the architecture of this version as well practical tips on installing and customizing your installation. If you are new to Oracle Database 10g or are installing it for the first time, you may find this section helpful when you get started. If you are currently using ASM or plan to use it later, Chapter 4 in this part, "Setting Up Automatic Storage Management," can provide some insider tips!

  • Part II, "Quick Wins Using Oracle Database 10g." This part launches straight away into a number of administrative tools and options that you can configure quickly and easily in Oracle Database 10g. This includes using Automatic Memory Management, Automatic Statistics Collection, Automatic Undo, Automatic Segment Management, as well as RMAN. This part shows how you can use these features that are already present in Oracle Database 10g to generate "quick wins."

  • Part III, "Tuning Oracle Database 10g." This part deals exclusively with topics related to tuning. Starting with a new approach to tuning, we deal with the workload repository and various tuning-related advisors in this part. The part is rounded off with a chapter on the Cost Based Optimizer.

  • Part IV, "Scaling and Availability with Oracle Database 10g." This part discusses products and options related to this topic. Oracle RAC (Real Application Clusters), Data Guard, and Flashback technologies are discussed in detail. We also introduce the concept and application of grid technologies now made possible with Oracle Data- base 10g.

  • Part V, "Using Oracle Database 10g Utilities and Other Advanced Features." This part discusses the new utilities provided by Oracle Database 10g. We wrap it up with a separate chapter listing a collection of interesting new features that are worth pursuing further.

About the Book's Sample Code

All sample code for this book can be downloaded on the Sams website at http://www.samspublishing.com. To access it, type this book's ISBN (without the hyphens) in the Search box and click Search. When the book's title is displayed, click the title to go to a page where you can download the code.

Conventions Used in This Book

The following typographic conventions are used in this book:

  • Code lines, commands, and programming-related language appears in a monospace typeface.

  • Placeholders in syntax descriptions appear in an italic monospace typeface.

  • The ¬ icon is used before a line of code that signifies to readers that the author meant for the continued code to appear on the same line.

In addition, this book contains the following special elements.

Note - Notes show how you can further explore the topic in question, or provide additional information about a particular topic being described.

Tip - Tips highlight shortcuts, convenient techniques, or tools that can make a task easier.

Sidebars - A large number of sidebar topics add value without distracting from the main flow.

Caution - Cautions alert you to common pitfalls you should avoid.

© Copyright Pearson Education. All rights reserved.


The latest book club pick from Oprah
"The Underground Railroad" by Colson Whitehead is a magnificent novel chronicling a young slave's adventures as she makes a desperate bid for freedom in the antebellum South. See more

Product Details

  • Paperback: 528 pages
  • Publisher: Sams; 1 edition (September 2, 2005)
  • Language: English
  • ISBN-10: 0672327910
  • ISBN-13: 978-0672327919
  • Product Dimensions: 7.4 x 1.1 x 9.1 inches
  • Shipping Weight: 1.9 pounds
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Best Sellers Rank: #2,907,758 in Books (See Top 100 in Books)

Customer Reviews

5 star
4 star
3 star
2 star
1 star
See all 9 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
A 'must have' for any Oracle DBA. A great reference book - liked the 'quick wins' section. Tuning oracle section was great. Easy to read, with lots of meat in it that you can use immediately. Comparison of stored outlines and sql profiles was excellent. Liked the Oracle Data Guard piece as well. Excellent coverage of all flashback technologies
Comment 11 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
If your a DBA and using 10g this book is THE RESOURCE for all dba's managing 10g databases. It's a very easy to follow, enjoyable read, especially the chapters covering Oracle RAC and the new 10g Self Management Framework. The general Oracle documentation is very good, however, 10g Insider really does a good job giving helpful advice and knowledgable insight to filling in the gaps that normal documentation typically leaves.
Comment 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I have most of the new features books for Oracle 10g and this one is the best one so far. It is well written and covers the key high points for 10g as well as release 2 which just came out recently. Other books either try to cover too much Oracle 10g or do not show enough detail. This book is great for experienced Oracle DBA like myself who needs to learn new stuff for 10g without wasting time in a beginner Oracle book.
Comment 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This book is easy to follow and drives straight into chapters essential for 10g. It does a wonderful job and covers installations on various platforms, new features and approach for identifying the performance issues. It provides practical advice using practical approach, tips and examples. I highly recommend this book to anyone who is learning or working with 10g.
Comment 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This book covers Release 2 of Oracle 10G. Concepts are presented in a clear manner. Each chapter can read in an hour or so. This is a great place to start for new DBAs. For experience DBAs, this a great book to get to know the New Features. Book is very easily read. Best book to learn Oracle 10g R2.
Comment 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse