Expert Oracle Database Architecture: Oracle Database 9i, by Thomas Kyte

By Thomas Kyte

Now in its moment version, this best-selling booklet via Tom Kyte of Ask Tom reputation keeps to deliver you the superior pondering on tips on how to follow Oracle Database to provide scalable purposes that practice good and bring right effects. Tom has an easy philosophy: you could deal with Oracle as a black field and simply stick facts into it otherwise you can know the way it really works and take advantage of it as a strong computing setting. should you pick out the latter, then you’ll locate that there are few info administration difficulties that you just can't clear up fast and elegantly.

This totally revised moment version covers the newest advancements in Oracle Database 11g. each one characteristic is taught in a proof-by-example demeanour, not just discussing what it really is, but additionally the way it works, how one can enforce software program utilizing it, and the typical pitfalls linked to it.

Don’t deal with Oracle Database as a black-box. Get this booklet. Get below the hood. Turbo-charge your career.

  • Fully-revised to hide Oracle Database 11g
  • Proof-by-example procedure: permit the proof be your advisor
  • Dives deeply into Oracle Databases’s strongest positive factors

What you’ll learn

  • Develop an evidence-based method of challenge fixing
  • Manage transactions in hugely concurrent environments
  • Speed entry to info via desk and index layout
  • Manage documents and reminiscence buildings for functionality and reliability
  • Scale up via partitioning and parallel processing
  • Load and dump info to interface with exterior structures
  • Think for your self; don’t take Tom’s observe for it!

Who this publication is for

This booklet is geared toward Oracle Database directors, at PL/SQL and Java builders writing code to be deployed contained in the database, and at builders of exterior functions who use Oracle Database as a knowledge shop. it's the go to publication for these wishing to create effective and scalable functions.

Table of Contents

  1. Developing profitable 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

Show description

Read Online or Download Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions PDF

Best oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication allow real-time info entry and knowledge sharing throughout your dispensed framework utilizing the specialist info during this Oracle Press consultant. Oracle Streams 11g facts Replication explains tips to arrange and administer a unified firm information sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software exhibit four Recipes presents an example-based method of studying program show - the ground-breaking, speedy program improvement platform integrated with each Oracle Database license. The recipes structure is perfect for the quick-study who simply wishes an excellent instance or to kick begin their pondering and get pointed within the correct path.

Additional resources for Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions

Sample text

Depending on which system I use, this table has between one record and four million records and varies in size from 200MB to 800MB. In all cases, the table structure is the same. To create BIG_TABLE, I wrote a script that does the following: • Creates an empty table based on ALL_OBJECTS. This dictionary view is used to populate the BIG_TABLE. • Makes this table NOLOGGING. This is optional. I did it for performance. Using NOLOGGING mode for a test table is safe; you won't use it in a production system, so features like Oracle Data Guard will not be enabled.

To build the BIG_TABLE table, you can run the following script at the SQL*Plus prompt and pass in the number of rows you want in the table. The script will stop when it hits that number of rows. gather_table_stats( user, 'BIG_TABLE', estimate_percent=> 1); I estimated baseline statistics on the table. The index associated with the primary key will have statistics computed automatically when it is created. Coding Conventions The one coding convention I use in this book that I would like to point out is how I name variables in PL/SQL code.

0! It was all they had to work with, but this did not seem to concern them at all. Never mind the fact that the tool they really needed to know about for tracing and tuning didn’t really exist in version 6. Never mind the fact that features such as triggers, stored procedures, and many hundreds of others had been added in the five years since that documentation was written. It was very easy to determine why they needed help—fixing their problems was another issue all together. ■ Note Even today, I often find that the developers of database applications have spent no time reading the documentation.

Download PDF sample

Rated 4.19 of 5 – based on 42 votes