Oracle Database 10g Insider Solutions [Paperback]

Arun Kumar (Author), John Kanagaraj (Author), Richard Stroupe (Author)

Book Description

Publication Date: September 2, 2005 | ISBN-10: 0672327910 | ISBN-13: 978-0672327919 | Edition: 1

Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors will also address common and not-so-common installation concerns, database administration, development, and tuning. Oracle Database 10g Insider Solutions will bring you the insider information that you can't get anywhere else.

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.

Introduction

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.

Product Details

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

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

10 of 10 people found the following review helpful:

5.0 out of 5 stars A mandatory 'must have' for any Oracle DBA, September 30, 2005

By 

kimdba "kimdba" - See all my reviews

This review is from: Oracle Database 10g Insider Solutions (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

9 of 9 people found the following review helpful:

5.0 out of 5 stars Best new features book for Oracle 10g!, October 30, 2005

By 

Benjamin S. Prusinski "real dba" (san diego, ca) - See all my reviews
(REAL NAME)   

This review is from: Oracle Database 10g Insider Solutions (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.

9 of 9 people found the following review helpful:

5.0 out of 5 stars Outstanding Oracle Reference, September 27, 2005

By 

John H. (Reston, VA) - See all my reviews

This review is from: Oracle Database 10g Insider Solutions (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.