RE: Oracle Book Mal-practice...

From: Kenneth Naim <>
Date: Fri, 22 May 2009 13:11:42 -0400
Message-ID: <011301c9db00$61e30280$25a90780$_at_com>

The next version of the book should indicate that table and index data be separated onto different solid state drives or ram modules when in memory :) Seriously these conversations give me such a headache, and usually I am able to point to the source being out of date, like a website that hasn't been updated since 1997. But this is made even more difficult with current sources (books/site/articles etc.) perpetuating these myths.

On the other hand if everyone learned the proper way to design, develop, test, tune and run their systems, the best dba's/developers among us would be common and our rate/salaries would reflect that.

Disclaimer: This post needs to be read with a level of sarcasm appropriate for a Friday before a holiday weekend.


-----Original Message-----

From: [] On Behalf Of Goulet, Richard
Sent: Friday, May 22, 2009 12:46 PM
To:; Oracle-L Freelists Subject: RE: Oracle Book Mal-practice...


        Some old myths will continue into eternity, this probably being one of them. Now I'll admit to liking indexes in a different tablespace from the data, but for a whole other reason, that being maintenance and sizing (I've become a real fanatic at locally managed uniform extent tablespaces). But on the other hand, even with SAN's, disk caches, large SGA's etc... A sysadmin can create a reason for following the old myths. I just had a recent experience of that with a san that's just mirrored, not stripped. Performance was poor because one drive set was being pounded. I moved one tablespace containing only table data to another drive & things are now flying.

        BTW: I don't write books. Principally because I don't like writing and secondly because I make mistakes myself. And I sure would not want some young poor soul following me on some of those blunders.

        Humm, maybe that's a book that should be written, a "How to mess up Oracle in one easy step"!!!

Dick Goulet
Senior Oracle DBA
PAREXEL International

-----Original Message-----

[] On Behalf Of Robert Freeman Sent: Thursday, May 21, 2009 9:11 PM
To: Oracle-L Freelists
Subject: Oracle Book Mal-practice...

So, I'm reading a particular book tonight. I don't want to say which one it is at the moment because I know one of the authors and I want to make sure that this author did not write this chapter.

My question is, what constitutes Oracle Book Writing mal-practice (and I pray I've never committed it). Certainly mistakes crop up in books all the time, I'm as guilty as any writer of this. This chapter I'm reading though, in an effort to get the reader to doing something quickly, does not lay any foundation, skips critical steps and actually prompts them to do what I consider some very dangerous things.

It would be one thing if the book said, "Look, this is not the way you should do this in production." but it does not. In this chapter, a very junior DBA might well follow the instructions and, having successfully completed everything, think that they are done. The truth, a nasty truth, is that all they have done is taken some very big risks and they have some nasty gottya's coming down the pike.

In my mind, this isn't a simple mistake. This isn't an editorial mis-step. This is someone trying to make something seem easy and leaving out some very sailient instructions without any warning.

Very bothersome.... For your Junior DBA's all I can say is buyer beware. Get yourself a good mentor to go with all these books.

Cheers all and buyer beware...


 Robert G. Freeman
Oracle ACE
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Other various titles out of print now... Blog: The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)


-- Received on Fri May 22 2009 - 12:11:42 CDT

Original text of this message