Effective Oracle by Design / Edition 1

Effective Oracle by Design / Edition 1

5.0 1
by Thomas Kyte
     
 

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

See more details below

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

Product Details

ISBN-13:
9780072230659
Publisher:
McGraw-Hill Professional Publishing
Publication date:
08/25/2003
Series:
Oracle Press Series
Pages:
688
Product dimensions:
7.10(w) x 9.10(h) x 1.00(d)

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

Table of Contents

1The right approach to building applications1
2Your performance toolkit75
3Architectural decisions161
4Effective administration201
5Statement processing241
6Getting the most out of the cost-based optimizer303
7Effective schema design367

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >