Re: Any book on Oracle DBMS's internals?
Date: Sun, 23 May 2010 13:49:55 -0700 (PDT)
Message-ID: <09622dfd-a01d-429e-af9e-11ad02f7e701_at_z33g2000vbb.googlegroups.com>
On May 23, 8:04�am, dlion <n..._at_real.address> wrote:
> Are there any book on Oracle DBMS's internal? Like Microsoft Press's _Inside
> Microsoft SQL Server 2005_
Oracle provides afair amount of information about how Oracle works internally in the official documentation including the Conceptsl, DBA Administration, and Performance and Tuning Guide. Oracle has also provided views on Oracle's internal memory structures since at least version 6.3. You can find the dynamic performance views, v$, documented in the Oracle version# Reference manual along with the database parameters and rdbms dictionary views.
The Concepts manual includes the basic architecture, the relationship between blocks, extents, and segments, identifies numerous interal structure concpets such as free lists and interested transaction lists, and bit maps for space managment.
For more details on internal processing you can go to Oracle support where you will find numerous white papers that discuss specific features in detail such as additional information on index operations, sort segment usage, hash joins operations, and on the various Oracle wait events.
You can also find information on reading Oracle system state dumps, heap dumps, and session trace files. The first two of which contain information related to various Oracle memory structures and their contents at the time of the dump.
Numerous authors have written books that cover such topics as Oracle index processing and reading cost base optimizer traces. Two authors worth searching on are Jonathan Lewis who wrote the book on the Cost Based Optimizer - Fundamentals and Tom Kyte who wrote a couple of books on architecture and feature usage.
HTH -- Mark D Powell -- Received on Sun May 23 2010 - 15:49:55 CDT