Download part of the new book
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…)
54 Comments:
Tom
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.
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.
Tom,
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.
sPh
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!
Tom, in your post you mention the book is 700+ pages but on Amazon.co.uk it says the book is 1200+ pages - i take it you (and Amazon.com) are correct but i think you need to tell us Brits to count properly.
Ric.
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.
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...
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.
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
The name of the book in amazon is different from the one in the cover of the book.
Tom,
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.
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.
This book is already in India..it should have been in NY..before that.
Ajeet
This book is already in India.
That book cannot be in India, I don't even have a copy yet!
Tom,
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.
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.
Tom
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
Hey Tom,
Great book, but when will the scripts/errata be posted on Apress.com?
Or can I get them somewhere else?
Cheers
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?
else
dbms_space.free_blocks(
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;
I tried opening the PDF but Acrobat can't seem to open it. May be the file is corrupted???
Adobe reader 7.0 opened it fine - no one else has said anything - I think the pdf is OK.
I just tested it.
AM NOT ABLE TO DOWNLOAD PART OF UR NEW BOOK.AM USING ACROBAT 6.00,BUT CAN'T OPEN IT????
IS THERE NY PROBLEM WITH THE FILE OR IT OPENS ONLY IN ACROBAT 7.00.
or is there ny other way to get that pdf????
I DON'T KNOW, I ONLY HAVE ADOBE 7.0
I also had similar problem opening the pdf.
Installed 5 patches from Adobe, can open the book now
Hi Tom,
This is vijay from India. Still the book is not available here. Any idea when we will get this book?
Thanks & Regards
Vijay
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 apress.com that list for 50% the price of the hardcopy book and are available immediately if that is of interest to you.
Thanks Tom. eBook Helps !! ..Can I print the pages which I need to read in detail ?
Thanks
Sandeep
Hi Tom,
I know i am asking for more. But do you any plans to put some sample chapters for free download?
Hi TOM
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
IT contains only 724 PAGES (in india)and not 768 pages.
.Can you please confirm how many pages it contains.......
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.
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.
Thanks
Matte Ravinder
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
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
how can I post my question in asktom.oracle.com
hi tom,
Your solution and idea is briliant. I am very fan.
how can i post my question in asktom.oracle.com.
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.
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 :)
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.
Tom,
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)
NAME VALUE DIFF
---------------------------------------------------------------- ---------- ----------
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)
NAME VALUE DIFF
---------------------------------------------------------------- ---------- ----------
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?
Thanks
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 : Gbolad@gmail.com.
Thanks I really appreciate your contributions. I am an everyday visitor to your site AskTom.com.
Thanks again
Is there a good Oracle Database Administration book you would recommend?
have you read the supplied administrators guide? I find it rather good actually.
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.
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.
http://www.khichdee.com/category-catid-11-paraid-0.htm
when will you update the other book effective oracle by design?
Hi Tom, when will you update your other book: effective oracle by design?
that update can only happen after I finish my current book - meaning, no idea yet.
...and how goes the current book?
Is it still part 2 of the 'Expert Oracle' trilogy?
these are gifts for everyone
Knowledge
Collection of books
Kitaben
Kitab ghar
Books and references
Liberary
booksshelf
Computer Science Reference Books
Rapidshare ebooks
Free collection of ebooks
Free Ebooks
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.
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
vinodd22@rediffmail.com
regards
vinod
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 youandme2@rediffmail.com
regards
sandeep
It's my time to read Expert Oracle: Database Architecture, thank you for a good book.
Tom,
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?
POST A COMMENT
<< Home