Re: Any book on Oracle DBMS's internals?
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Mon, 24 May 2010 06:43:25 -0700 (PDT)
Message-ID: <ebdb164a-4ac0-48ab-8cb0-48787f68d256_at_y12g2000vbr.googlegroups.com>
On May 23, 4:49�pm, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> 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 --
Date: Mon, 24 May 2010 06:43:25 -0700 (PDT)
Message-ID: <ebdb164a-4ac0-48ab-8cb0-48787f68d256_at_y12g2000vbr.googlegroups.com>
On May 23, 4:49�pm, Mark D Powell <Mark.Powe..._at_hp.com> wrote:
> 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 --
I do not know if it is still in print but Steve Adams wrote a book that discusses the Oracle layered architecture and went into detail on a slew of the X$ views that underlay the GV$ views upon which the V$ views The X$ views are actually Oracle program memory structures.
HTH -- Mark D Powell -- Received on Mon May 24 2010 - 08:43:25 CDT