Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Internals - Was Oracle replication book

RE: Internals - Was Oracle replication book

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 27 Feb 2004 10:47:59 -0600
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B0007B@EXCHMN3>


Robert -

   Thank you for such an eloquent reply. That is why you are such an excellent author and why I have several of your books on my shelf. And thanks for all the great books you have written and are writing.

   Sometimes the problem is understanding just what areas to study in order to increase your DBA expertise. Some have the opportunity to work with one of the experts and witness their methods firsthand. For those not so fortunate, this list is a godsend.

   I had worked as a DBA for several years and was pretty comfortable with most administration commands, etc. However, studying for the OCP opened my eyes to a greater depth of knowledge. Based on recommendations from others on this list (sorry I can't recall who and Google doesn't seem to work as well as it used to), I am now beginning by studying the Oracle 10g Concepts Manual in detail. Following that I plan to study backup and recovery in detail, starting with principles.

   Thanks for sharing your insights.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Freeman Robert - IL Sent: Friday, February 27, 2004 10:27 AM To: 'oracle-l_at_freelists.org'
Subject: Internals - Was Oracle replication book

In my mind, the single most important reason to understand internals is to be able to handle just about any database recovery problem that might confront you. If you understand how the database works under the covers, how it goes about enforcing consistency, you can then begin to really understand:

  1. What is causing the database to not want to open up.
  2. The *quickest* method of recovering the database.

Sometimes, often in fact, recovering the entire database is not the best method of recovering, yet there have been many occations that I've walked into a DBA's cube to find that DBA in the middle of a full recovery. After asking the DBA a few questions, I'm like, did you try this? Noooooo... well, why not?

When I was a new DBA my response to technical questions about "How would you recover the database in this situation" was: "I'd call Oracle support, because you never know what you are going to run into during a recovery.". Now, with a little experience under my belt, I give the interviews from time to time and I hear the same types of answers on the technical interviews I give. Now, when I hear such an answer, it's a big red flag to me indicating lack of experience, confidence and knowledge of the DBA because it tells me that, indeed, this person dosen't really understand the database they manage. Sure, they can create datafiles, and resize them, but they don't really UNDERSTAND.

Of course, Oracle dosen't always help, as it does keep certain things very unspoken....

Cheers

Robert
-----Original Message-----
From: DENNIS WILLIAMS
To: oracle-l_at_freelists.org
Sent: 2/27/2004 10:15 AM
Subject: RE: RE: Oracle replication book

Ryan

   Hey looking smart in interviews is what it's all about ;-)

   I think the more you understand what is going on under the hood, the better you will be about issuing the right administration command.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan.gaffuri_at_cox.net Sent: Friday, February 27, 2004 10:14 AM To: oracle-l_at_freelists.org
Subject: Re: RE: Oracle replication book

i flipped through the internals book from ault. well written(but large print...) alot of the info seems available on metalink, but atleast its in
one place(many,many books are like that).

not sure how useful all this internal stuff is though its kind of neat to
read and makes you look smart in interviews.
>
> From: Stephen.Lee_at_DTAG.Com
> Date: 2004/02/27 Fri AM 11:03:23 EST
> To: oracle-l_at_freelists.org
> Subject: RE: Oracle replication book
>
>
> I was so disgusted with the Big Chief tablet books that it's possible
they
> put me in a bad frame of mind, so that I might not have given the
third
book
> -- which was in a normal font -- as fair a consideration as I maybe
should
> have. As best as I can remember the Big Chief books were:
>
> Mike Ault's Oracle Internals Monitoring & Tuning Scripts
>
> Oracle Utilities: Using Hidden Programs, Import/Export, SQL*Loader,
> oradebug, tkprof, & More
>
> I'm not 100% certain, but about 98% sure these were the two books that
made
> me ask: What are these guys thinking?!
>
> And for those people not familiar with the "Big Chief" thing: It is
(or
was)
> a common brand of pad of paper used by school children learning to
write.
> The Laddie pencil is a type of pencil, bigger than normal and painted
blue,
> used by these children.
>
> > -----Original Message-----
> >
> > and who were the authors? with Rampant i tend to only look
> > at books by
> > certain authors.
> >
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 27 2004 - 10:49:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US