Re: Any book on Oracle DBMS's internals?
Date: Mon, 24 May 2010 17:08:04 +0200
Message-ID: <0f5lv5l2v93lssvtajhl0glql6q1249paj_at_4ax.com>
On Mon, 24 May 2010 06:43:25 -0700 (PDT), Mark D Powell <Mark.Powell2_at_hp.com> wrote:
>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 --
>
>
>
>
You mean the 8i book? I wouldn't recommend that as much of the
algorithms discussed have evolved over time.
OP would better buy the Oracle Press book on the Oracle Wait
Interface.
-- Sybrand Bakker Senior Oracle DBAReceived on Mon May 24 2010 - 10:08:04 CDT