Apress

Expert Oracle Database Architecture

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

2nd Edition

By Thomas Kyte

Expert Oracle Database Architecture Cover Image

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

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

Related Titles

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.

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

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

however,
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 ..."
but
following referential constraints work on Oracle 10.2.0.4.0, 11.2.0.1.0, 11.2.0.2.0.

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:
http://ksun-oracle.blogspot.com/2011/05/foreign-key-on-nested-table.html