Apress Access

Expert Oracle Database Architecture

Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions

2nd Edition

By Thomas Kyte

  • eBook Price: $41.99
Buy eBook Buy Print Book
Expert Oracle Database Architecture provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-2946-9
  • User Level: Intermediate to Advanced
  • Publication Date: July 25, 2010
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • Pro Oracle Identity and Access Management Suite
  • Mastering Oracle GoldenGate
  • Oracle Application Express Administration
  • Expert Oracle Indexing and Access Paths, 2nd Edition
  • Pro Oracle GoldenGate for the DBA
  • Relational Database Programming
Full Description

Now in its second edition, this best-selling book by Tom Kyte of "Ask Tom" fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you’ll find that there are few information management problems that you cannot solve quickly and elegantly.

This fully revised second edition covers the developments up to Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

Don’t treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.

  • Fully revised to cover Oracle Database 11g
  • Proof-by-example approach: Let the evidence be your guide
  • Dives deeply into Oracle Database’s most powerful features

What you’ll learn

  • Develop an evidence-based approach to problem solving
  • Manage transactions in highly concurrent environments
  • Speed access to data through table and index design
  • Manage files and memory structures for performance and reliability
  • Scale up through partitioning and parallel processing
  • Load and unload data to interface with external systems
  • Think for yourself; don’t take Tom’s word for it!

Who this book is for

This book is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go-to book for those wishing to create efficient and scalable applications.

Table of Contents

Table of Contents

  1. Developing Successful Oracle Applications
  2. Architecture Overview
  3. Files
  4. Memory Structures
  5. Oracle Processes
  6. Locking and Latching
  7. Concurrency and Multi-versioning
  8. Transactions
  9. Redo and Undo
  10. Database Tables
  11. Indexes
  12. Datatypes
  13. Partitioning
  14. Parallel Execution
  15. Data Loading and Unloading
  16. Data Encryption
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.

On page xli:
Line 84:
to_char( round( run1/decode( run2, 0, to_number(0), run2) *100,2 ), '99,999.99' )

to_number(0) is not correct, should be something else.

On page 335:
First bullet point on the page mentions "V$UNDOSTATUNDOSTAT" which should read "V$UNDOSTAT".

On page 399:

"Nested tables do not support referential integrity constraints ..."
following referential constraints work on Oracle,,

alter table emps_nt add constraint emps_nt_fk foreign key(nested_table_id)
references dept_and_emp(sys_nc0000400005$);

One can verify it by:

select constraint_name, constraint_type, table_name
from dba_constraints where table_name = 'EMPS_NT';

I tried to write more details in:


    1. Troubleshooting Oracle Performance


      View Book

    2. Expert Indexing in Oracle Database 11g


      View Book

    3. Oracle Core: Essential Internals for DBAs and Developers


      View Book

    4. Oracle Database Transactions and Locking Revealed


      View Book