Re: Learn Oracle From Home

takveen_at_gmail.com wrote:
> Learn Oracle From Home
>
>
> 1. Download this complete 376 page Book absolutely FREE
>
>
> http://www.takveen.com/ebooks/ebookp.pdf
>
>
> The password protected PDF file so you will need acrobat reader. get
> one free from www.adobe.com
>
>
> password: takveen
>
>
> 2. Ask Question to author on "Oracle Made Simple" google group
> operated by the same author
>
>
> http://groups.google.com/group/OracleMadeSimple

"Oracle instance is the genie, Oracle database is the genie's notebook." This is ridiculous. Your ebook, although free, is not worth its non-existent cost. A few points to ponder:

"Any value of cache HIT RATIO less than 85% is considered unacceptable": Patently untrue as any professional Oracle DBA who actually administers an Oracle database will attest. The wait interface is the tool of choice for tuning Oracle performance, NOT the hit ratio, as the hit ratio can be manipulated with any number of senseless selects from any table to bring it into agreement with your statement as quoted above. Ratios obscure detail, not create it. Your insistance on using them to manage and tune an Oracle database is, in my opinion, irresponsible.

The utlbstat.sql and utlestat.sql scripts are no longer in use, nor are they provided with any current release of Oracle. Statspack is the supplied utility, and it provides far better information to troubleshoot and correct problem areas. You DID mention Statspack after a lengthy and useless discussion of utlbstat/utlestat yet no statspack reports were produced or explained.

The UNDO tablespace is where rollback information is now kept, and it's managed automatically by Oracle; when properly configured the DBA has no need to manage such segments, making your 'DBA' section on rollback segments lacking in factual information.

Stop distributing this hodgepodge of wive's tales and falsehoods under the guise of Oracle knowledge and advice. It does a grave disservice to the Oracle professionals who keep databases running for mission critical applications as your over-simplification of Oracle only serves to uphold bad practices and poor metrics, both based upon ignorance. I suggest you read Thomas Kyte's book 'Expert One-on-One Oracle", Jonathan Lewis' text "Practical Oracle 8i" (it contains much which is still applicable to 9i/10g) and Cary Millsap and John Holt's text "Optimizing Oracle Performance" as much of what you've authored flies in the face of the facts their books present and support. You should also visit tahiti.oracle.com and start reading the documentation, beginning with the "Concepts Guide" and working forward.

When you finally learn how to manage an Oracle database using accepted and proven methodology THEN, and ONLY THEN, can you gut this text and rewrite it with valid assertions. And, use a spell checker on occasion; 'learnt' is not a word in the English language last I consulted the dictionary.

Your book is a disgrace to all who know better due to actually working with the product in an administrative capacity. From the content it is apparent you haven't administered an Oracle instance since your OCP exams. Possibliy you should consider using your methods on a critical Oracle instance and see how far short you fall. With 'knowledge' like yours you would not be working on any team I manage.

David Fitzjarrell Received on Sat Oct 29 2005 - 15:21:48 CDT