Buy Used
Condition: Used: Very Good
Comment: **FAST SHIPPING!!** 100% satisfaction guaranteed!!** Looks like a typical used book with some shelf wear** We carefully inspected this item**
Access codes and supplements are not guaranteed with used items.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Oracle Database 10g Insider Solutions Paperback – September 2, 2005

9 customer reviews
ISBN-13: 978-0672327919 ISBN-10: 0672327910 Edition: 1st

Price: $4.10
10 New from $25.74 25 Used from $0.01
Amazon Price New from Used from
Paperback, September 2, 2005
$25.74 $0.01
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now

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


Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

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,761,768 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

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

Most Helpful Customer Reviews

11 of 11 people found the following review helpful By kimdba on September 30, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
10 of 10 people found the following review helpful By John H. on September 27, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
10 of 10 people found the following review helpful By Benjamin S. Prusinski on October 30, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
10 of 11 people found the following review helpful By Arjun Choubey on November 13, 2005
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
7 of 7 people found the following review helpful By Eric L. Yen on July 11, 2006
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again