Effective Oracle by Design [NOOK Book]

Overview

Streamline Application Development with Help from an Oracle Expert



Oracle guru Tom Kyte has written the definitive guide to designing and building high-performance, scalable Oracle applications. Providing detailed code examples throughout, Tom teaches proactive and efficient methods to develop and tune Oracle applications that fully exploit the database. You'll learn how to maximize the built-in ...

See more details below
Effective Oracle by Design

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$35.49
BN.com price
(Save 42%)$62.00 List Price

Overview

Streamline Application Development with Help from an Oracle Expert



Oracle guru Tom Kyte has written the definitive guide to designing and building high-performance, scalable Oracle applications. Providing detailed code examples throughout, Tom teaches proactive and efficient methods to develop and tune Oracle applications that fully exploit the database. You'll learn how to maximize the built-in functionality of the tools you're using in order to achieve the best results possible. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.



  • Use SQL*Plus, TKPROF, STATSPACK, JDeveloper, and other tools


  • Take advantage of Oracle's scalable architectural implementations


  • Handle administration with SPFILES, Oracle Managed Files, and Automatic Segment Space Management


  • Use archivelog mode, RMAN, and Data Guard for bulletproof backup and recovery


  • Improve statement processing by using bind variables and reducing parsing


  • Make full use of the Cost Based Optimizer (CBO)


  • Choose data structures that result in effectively designed schemas


  • Write efficient SQL statements and high-performance PL/SQL code


  • Learn invaluable techniques from an Oracle insider


Read More Show Less

Product Details

  • ISBN-13: 9780071776783
  • Publisher: McGraw-Hill Education
  • Publication date: 8/22/2003
  • Series: Oracle Press
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 688
  • File size: 33 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Thomas Kyte (Leesburg, VA) is among the most knowledgeable Oracle professionals in the world. He is Vice President in the Oracle Government, Education, and Health group and is the “Tom” behind the Ask Tom column in Oracle Magazine and the online forum at http://asktom.oracle.com. He has answered thousands of technical questions that sparked the creation of this book and is the author of Expert One-on-One Oracle (Wrox).

Read More Show Less

Table of Contents

1: The Right Approach to Building Applications 2: Your Performance Toolkit 3: Architectural Decisions 4: Effective Administration 5: Statement Processing 6: Getting the Most Out of the Cost-Based Optimizer 7: Effective Schema Design 8: Effective SQL 9: Effective PL/SQL Programming 10: So, You Had an Accident Appendix A: Setting Up and Some Scripts



















Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star

(1)

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
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted May 20, 2004

    Excellent Oracle design book

    If you¿ve ever looked over anything about the Oracle database, you¿ve likely come across the name of this book¿s author, Tom Kyte. Like his articles, this book is designed to help the reader get the most out of the Oracle database. This is an excellent book for understanding the inner workings of Oracle database engine. The theme of this book is that by understanding how Oracle works, you can write highly scalable, high performing applications. If you don¿t know how your database works, you¿ll always be frustrated and less likely to have a well-performing database. The author is absolutely serious about this point and drives it home by dispelling many myths surrounding Oracle (e.g. partitioning is always better than not partitioning). By discussing these technical details, the reader is equipped with the knowledge to build an application designed to perform. If you¿re looking for a book to learn how to write effective PL/SQL, then you might be slightly disappointed by this book. While there is a great chapter on the Oracle specifics of writing SQL, this book is designed to architecting the entire database, not just the SQL statements run inside the database. I think this a very effective (and sadly novel) approach to database design. There are all too many books out there which concentrate on writing fast SQL, with little regard for the underlying data design and structure. This is by far the best book I have read on understanding how Oracle works. The author covers everything from design to disaster recovery. If you are responsible for maintaining an Oracle database, I would highly recommend this book.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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