Friday, August 19, 2005

Download part of the new book

If you are interested in seeing the table of contents, description of each chapter, the most amazing foreword (I could not have paid someone for a nicer, better one) by Ken Jacobs (also known as "Dr. DBA") and other bits about the new book, I've made the pdf of it available here.

I would like to point out a comment to this blog by one of the technical reviewers of the book - Gabe Romanescu.  While reviewing, I could not help but notice that Gabe seemed to have had the old book next to the new based on his comments. If anyone is able to give a fairly unbiased “how different is it” overview, I think it would be him. I fell myself the new material was a rewrite more than an “improved, now mentions 9i and 10g!” book. But I am very biased (obviously). And now you might be able to figure out who thought one of the chapters was “weak” :)

Each of the four reviewers had distinctly different personalities, I would be hard pressed to stack rank them as each had their time to put it back on the correct path. I take their input very seriously. Gabe was outstanding, I hope he stays on for the next one.

768 pages. And that was just the first third of the old book (which was 1,265 all together). I’m afraid but at the same time looking sort of forward to doing the second half. The goal will be to make it 1,000 or less pages (in my mind) but to fit in as much as I can. Lots of new ideas – instrumentation will definitely be a new chapter, the new tools available with 9i and 10g that didn’t really exist before as well.

We just sent it off to be turned into paper tonight. No more changes, no more updates, no more reviews.

I am going to reproduce a bit of the content you can download from the above link here:

First, I would like to thank Tony Davis for his work making my work read well. If you enjoy
the flow of the sections, the number of section breaks, and the clarity, then that is probably in
some part due to him. I have worked with Tony writing technical material since the year 2000
and have watched his knowledge of Oracle grow over that time. He now has the ability to not
only “edit” the material, but in many cases “tech edit” it as well. Many of the examples in this
book are there because of him (pointing out that the casual reader was not going to “get it”
without them). This book would not be what it is without him.

I consider Tony not only the editor of this book and the original Expert One on One Oracle, but a good friend as well. It is good to work with people you like. So, to Dr. Tony Davis – thanks much (what a Dr. is doing editing books I still have yet to figure out but hey, it works for me).  I owe him a martini or two at Oracle Open World.

But first, two weeks, no writing. I’m excited to go to Prague next weekend.  I have Saturday and Sunday to be “tourist”, something I don’t get the chance to do often. There will be pictures of that I am sure. (I am less excited to be having to speak all day for 7 days in the next two weeks but…)



Blogger R Menon said....

Congrats again to you, Tony and everyone for the book which (from amazon rankings at least) looks like will outsell your previous bestseller classic (Expert one on one)! Great forward from Ken (how do people start and end so nicely) - I loved his theme in the forward.

I hope to catch you and Tony at OOW.

Sat Aug 20, 11:45:00 AM EDT  

Anonymous Anonymous said....

And that was just the first third of the old book (which was 1,265 all together). I’m afraid but at the same time looking sort of forward to doing the second half. The goal will be to make it 1,000 or less pages (in my mind) but to fit in as much as I can.

I know your family will hate me for saying so, but I (and I suspect most of your readers) would vastly prefer that you have three volumes over 2 years rather than leave anything out.

If I could offer a back-seat-driving suggestion: perhaps you could lighten your workload in the long run by having one of your books be about overall design principles, without version-specific (or even Oracle-specific examples). Your design lessons should be as applicable 20 years from now as today. In fact you could probably co-market such a book as a textbook for collges and programming schools (although you would probably have to include examples from multiple platforms in that case.)

Just a thought.


Sat Aug 20, 01:33:00 PM EDT  

Blogger Alberto Dell'Era said....

The goal will be to make it 1,000 or less pages (in my mind) but to fit in as much as I can.

Why - go instead for three books if you'll end having a lot of relevant things to say. Ditch the non relevant, write about all the rest - if at the end it's 1500 pages, so be it, and split the book.

Since you said that the 1st edition was "three books in one" and the first book covers 1/3rd of the old book ... 3 books seems to be very natural.

Don't compress to fit - enlarge the container instead!

Sat Aug 20, 03:18:00 PM EDT  

Anonymous Ric said....

Tom, in your post you mention the book is 700+ pages but on it says the book is 1200+ pages - i take it you (and are correct but i think you need to tell us Brits to count properly.


Mon Aug 22, 05:52:00 AM EDT  

Blogger Thomas Kyte said....

in your post you mention the book is 700+

We've been working on getting the various "amazons" synced up with the right information. It is 768 pages in english.

Mon Aug 22, 06:45:00 AM EDT  

Blogger Noons said....

Good to see Ken Jacobs hasn't lost his "touch": stunning intro indeed.
Ah well, now to wait for the book to percolate Down Under...

Mon Aug 22, 09:17:00 PM EDT  

Anonymous Quadro said....

Reading through "example pdf" i noticed what in the "Install StatsPack" section you have used Oracle 10G as an example. I think this can lead to patential confusion as 10G comes alone with AWR and you never need to install StatsPack in 10G.

Tue Aug 23, 04:47:00 AM EDT  

Blogger Thomas Kyte said....

There is a big difference between not necessary and should not/could not be done.

I used statspack purposely because AWR is an option extra cost option for 10gR1 and above and the book is for everyone using 9i and above

Tue Aug 23, 06:41:00 AM EDT  

Blogger Kalita said....

The name of the book in amazon is different from the one in the cover of the book.

Wed Aug 24, 12:45:00 AM EDT  

Blogger Lou said....


Congrats on your new book. We can wait to have it down here in NY! Maybe some day you and Jonathan can put something together.

Fri Aug 26, 10:48:00 AM EDT  

Blogger Thomas Kyte said....

We can wait to have it down here in NY!

If NY is New York that'll be "up there" from my perspective and I'll be doing a training day in January for the NYOUG.

Fri Aug 26, 01:12:00 PM EDT  

Anonymous Anonymous said....

This book is already in should have been in NY..before that.


Mon Aug 29, 03:35:00 AM EDT  

Blogger Thomas Kyte said....

This book is already in India.

That book cannot be in India, I don't even have a copy yet!

Mon Aug 29, 04:44:00 AM EDT  

Blogger Arindam said....

On 29th Aug you said the books can't be in India. But on saturday (10th Sep) I have seen both the books in a Bookshop in Kolkata, India.
Anyways, Congrats for the new books. When I bought your Expert One on One I felt we need the same type of books on 9i and 10g too.

Mon Sep 12, 07:04:00 AM EDT  

Blogger Thomas Kyte said....

Arindam --

the new book is what we were discussing on this page...

The old books are available, the new book however, is not yet (Sept 19th is ship date).

I don't even have a copy of the new book yet myself.

Mon Sep 12, 07:24:00 AM EDT  

Anonymous Anonymous said....


I like your new version of Expert Oracle Database Architecture but why is it not available in hardback? The current version is rather flimsily bound in cheapy paperback format. With over 700 pages, this version won't last a month before the spine breaks! It's good to se a pdf version but most of us would like to read a book in held in our hands too. How can I read in bed? How can I read in the "holiest sanctuary of all mankind" (i.e. on the toilet)?

Will we see a hardback version of all of your books? The extra cost is worth it to me.

with respects
Wayne Rooney

Wed Sep 21, 10:00:00 AM EDT  

Anonymous Anonymous said....

Hey Tom,

Great book, but when will the scripts/errata be posted on

Or can I get them somewhere else?


Tue Oct 04, 10:34:00 AM EDT  

Anonymous EscVector42 said....

I couldn't find the scripts on Apress, so I typed in the show_space proc myself.
I found that it didn't work with partitioned tables until I added partition_name => p_partition);

Is there a reason it is missing?

segment_owner => p_owner,
segment_name => p_segname,
segment_type => p_type,
freelist_group_id => 0,
free_blks => l_free_blks,
partition_name => p_partition);
p( 'Free Blocks', l_free_blks);
end if;

Tue Oct 11, 04:09:00 PM EDT  

Anonymous Anonymous said....

I tried opening the PDF but Acrobat can't seem to open it. May be the file is corrupted???

Thu Oct 20, 01:24:00 PM EDT  

Blogger Thomas Kyte said....

Adobe reader 7.0 opened it fine - no one else has said anything - I think the pdf is OK.

I just tested it.

Thu Oct 20, 01:30:00 PM EDT  

Anonymous Anonymous said....



or is there ny other way to get that pdf????

Fri Oct 28, 02:59:00 AM EDT  

Blogger Thomas Kyte said....


Fri Oct 28, 04:40:00 AM EDT  

Blogger Dilip said....

I also had similar problem opening the pdf.
Installed 5 patches from Adobe, can open the book now

Sat Oct 29, 06:45:00 PM EDT  

Anonymous Vijay said....

Hi Tom,

This is vijay from India. Still the book is not available here. Any idea when we will get this book?

Thanks & Regards

Fri Dec 09, 02:36:00 AM EST  

Blogger Thomas Kyte said....

Any idea when we will get this book?

No, as I've said before - I don't have any control over this. As I understand, it very much comes down to "economics".

I can say however, that there are "E" versions of the book available from that list for 50% the price of the hardcopy book and are available immediately if that is of interest to you.

Fri Dec 09, 06:26:00 AM EST  

Anonymous Sandeep said....

Thanks Tom. eBook Helps !! ..Can I print the pages which I need to read in detail ?


Wed Dec 14, 05:12:00 AM EST  


Hi Tom,
I know i am asking for more. But do you any plans to put some sample chapters for free download?

Tue Jan 10, 10:08:00 PM EST  

Blogger Jatinder Kautish said....


Your pervious book Expert One to One is just like a BIBLE of Oracle Database. All major concepts have been covered with excellent examples. This book has changed many guys's life and quality of Oracle PL/SQL programming has also been immensely increased.

We all are expecting your 10G edition as another Milestone in Oracle Database history.

Tons of Congrats !!

Jatinder K Kautish from Capgemini,Mumbai, INDIA

Thu Jan 12, 05:35:00 AM EST  

Anonymous Anonymous said....

IT contains only 724 PAGES (in india)and not 768 pages.
.Can you please confirm how many pages it contains.......

Thu Jan 26, 11:40:00 PM EST  

Blogger Thomas Kyte said....

it contains only 724 pages (in india)

You yourself have just confirmed how many pages the India reprint contains??!?!

I've never seen, nor will I likely see a copy of the India reprint version.

Fri Jan 27, 06:50:00 AM EST  

Anonymous ravinder matte said....

Have you visited india?
There are more DBA's like you here!
A lot of Gurus. Common come here sometime, to share lot of new thoughts.

Matte Ravinder

Thu Mar 23, 05:26:00 PM EST  

Anonymous Anonymous said....

Hi tom,

It's very very useful when u come to India(BANGALORE)
make one free/paid seminar (u can't imagine the rush).
many people may understand the UNDO & REDO clearly .CAN YOU VISIT

Thu Apr 20, 02:56:00 AM EDT  

Blogger matte said....

I kindly request you Mr.Tom to india.

I am sure you have lot of fans here in south india more than Tom cruise.

"Tom kyte is more for us than Tom cruise"

I am sure you will also enjoy the trip.

Let me know if you are planning

Fri Apr 21, 01:45:00 PM EDT  

Anonymous Anonymous said....

how can I post my question in

Mon May 01, 05:19:00 AM EDT  

Blogger Sam India said....

hi tom,
Your solution and idea is briliant. I am very fan.
how can i post my question in

Mon May 01, 05:23:00 AM EDT  

Anonymous Anonymous said....

Hi tom,

I actually want to ask a question that you've talked about it in your book.

In chapter 3, you've written about the structure of a data block and in there you've mentioned that "data from more than one table may be stored on the same block". (that's why we have Table Dictionary component in a block).

I think I don't underestand that. A Block belongs to an Extent and an extent belongs to a Segment. So if we talk about a heap table, that segment belongs to that table. How a block in that hierarchy can store data from anothr table?

By the way, the book is perfect.

Sat Jun 03, 05:19:00 AM EDT  

Blogger Thomas Kyte said....

I actually want to ask a question that you've talked about it in your book.

it is true that a block belongs to an extent, an extent belongs to a segment - but a segment could be

a table segment
an index segment
a CLUSTER <<<=== segment
.... list goes on ....

If you create a CLUSTER, say a b*tree cluster, you can then create tables in that cluster and many tables will be able to share a single block.

Hopefully, when you get to chapter 10 on tables - all will become clear :)

Sat Jun 03, 08:27:00 AM EDT  

Anonymous Anonymous said....

Hai Tom,

How could I found the complete errata
for this book, because from Apress site, I Think, it is not
the complete one.

For example

-page 120
Is this correct ?
"Now if we run ... The session xxx memory max... " again "The session xxx memory max"

-page 171 on figure 5-4. RBCO -> RECO ?

I have question on top page of 120.
How much memory are we using between PGA and UGA for shared server when
we are actually running the query.
Your book tell me that the value is 487 KB of memory between the combined PGA
and UGA. Why not using this values 149+487 KB. Please give me explanations.

Thanks for your help.

Thu Jun 08, 02:01:00 AM EDT  

Anonymous Anonymous said....


I'm going to use this opportunity to ask a question about the Memory Management chapter in your book:

If you do remember, there is a sample of monitoring a session that's using Manual PGA management method with different sort_area_size.

The result that I got was weired. The PGA memory shrinks to less than what it was before sort operation:

(when sort_area_size = 64 KB)
---------------------------------------------------------------- ---------- ----------
physical reads direct temporary tablespace 1932 1932
physical writes direct temporary tablespace 1932 1932
session pga memory 585300 -131072
session pga memory max 847444 131072
session uga memory 221720 0
session uga memory max 352648 130928

(and when sort_area_size = 1MB)

---------------------------------------------------------------- ---------- ----------
physical reads direct temporary tablespace 696 696
physical writes direct temporary tablespace 696 696
session pga memory 585300 -131072
session pga memory max 1961556 1245184
session uga memory 287184 65464
session uga memory max 1400072 1178352

As you can see, the Diff column for PGA shows negative value.
If it can shrink more than what it was, why it didn't use that much at the begining?


Tue Aug 01, 11:04:00 AM EDT  

Anonymous Anonymous said....

Hi Tom,

I am a beginner. 'just got my certification as an OCA. I come from a couputer science background. I was at first scared of picking up your book -expert oracle-. But I was amazed at how very simple you kept it except for the fact that understanding some of the referenced codes was not as simpler.

I am really bent on understanding oracle to the fullest. Prior to securing a job as a dba, could you give me any tip[s] on what it'll take to become a Very Good DBA.
e.g.. Do I need to learn about developing [pl/sql]. etc..
email :
Thanks I really appreciate your contributions. I am an everyday visitor to your site

Thanks again

Fri Aug 04, 05:20:00 PM EDT  

Anonymous Mia said....

Is there a good Oracle Database Administration book you would recommend?

Tue Oct 17, 10:52:00 AM EDT  

Blogger Thomas Kyte said....

have you read the supplied administrators guide? I find it rather good actually.

Tue Oct 17, 10:56:00 AM EDT  

Anonymous Mia said....

Yes. So you think it is sufficient to use the Oracle Administrator's guide? I was under the impression that I should seek additional resources in addition to the Oracle documentation.

Tue Oct 17, 11:57:00 AM EDT  

Anonymous Anonymous said....

I visited a very interesting site, they have a vast collection of books which have been categories and are presented to viewers in an easy-to-search format. You should check it out.

Thu Nov 02, 02:21:00 AM EST  

Anonymous Anonymous said....

when will you update the other book effective oracle by design?

Tue Feb 06, 12:04:00 PM EST  

Anonymous Anonymous said....

Hi Tom, when will you update your other book: effective oracle by design?

Tue Feb 06, 12:06:00 PM EST  

Blogger Thomas Kyte said....

that update can only happen after I finish my current book - meaning, no idea yet.

Tue Feb 06, 12:32:00 PM EST  

Blogger Scott said....

...and how goes the current book?

Is it still part 2 of the 'Expert Oracle' trilogy?

Mon Feb 26, 12:29:00 PM EST  

Blogger Ayisha said....

these are gifts for everyone
Collection of books
Kitab ghar
Books and references
Computer Science Reference Books
Rapidshare ebooks
Free collection of ebooks
Free Ebooks

Mon Aug 13, 02:46:00 PM EDT  

Blogger P. HARRISON PICOT II said....

August 19, 2005, we were told to get ready for the next book, including a chapter on intstrumentation. While you may have job, and hope to have a life away from it, some of us have not been burdened by employment which has limited our trips to both Disney World AND Legoland, and replaced consumer aspirations with intellectual pursuits that cost almost nothing, like books. I recently got an interview (not the same as a job) where the technical representitive of the assessing group asked me what was the SQL to print out the version of Oracle. I had no idea so I said that the alertsid.ora file had all that and more, but he was not pleased, in fact he told me, v$version. I am now thinking that if that question comes up again, I can distract someone similar with a discourse on instrumentation. As I am starting to work backwards through your books, I think you can do the next one before I get back to book 1 on 1. What do you think? Also I am stealing as much stuff as I can from your site to fill out my lame blog, but I do put pictures of your books so that people don't confuse us. If this leads to a great increase in sales, I sure could use the money.

Thu Aug 28, 11:34:00 AM EDT  

Blogger sandeep said....

Dear Sir
Plese confirm weather indian editions of your new books "Effective Oracle by Design " and "expert oracle" are available.
List email me details of other books written by you and indian editions available or not at

Fri Oct 31, 02:36:00 PM EDT  

Blogger sandeep said....

ixtdear sir
I just want to know books publisehed by you and wether Indian Editions of these books are available or not.
I came to know about two books but both are in Non-Indian Edition
"Effective Oracle by Design "
adn "expert oracle"
I hope complete information like price in Indian Rupee and name of publisher will be emailed to me at

Fri Oct 31, 02:39:00 PM EDT  

Blogger HunterX said....

It's my time to read Expert Oracle: Database Architecture, thank you for a good book.

Mon Jan 26, 10:21:00 AM EST  

Blogger Phoenix said....

I want to know the difference between Expert one on one and Oracle Architecture which are both written by you of course.

I read the Oracle Architecture carefully row by row. I love it, it is like a novel drives me eagerly to know what is next chapter after chapter. It is really a great book!

And my question is: Is there a big difference between Expert one on one and this one? Do you think I should read it anyway?

Tue Sep 15, 04:49:00 AM EDT  


<< Home