Re: Internals - Was Oracle replication book
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 27 Feb 2004 12:05:27 -0500
in school i'm actually calculating how many blocks are needed in different
types of queries. different search algorithms used by the CBO.(actually
calculating our own cost)
its a big of an overkill. intenals is nice, but unless you are going to code or
design a database, there is only so much you really need to know. you can get
bogged down in these details and not focus on what is really important.
>
> From: Freeman Robert - IL <FREEMANR@xxxxxxxx>
> Date: 2004/02/27 Fri AM 11:26:40 EST
> To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of ryan.gaffuri@xxxxxxx
> Sent: Friday, February 27, 2004 10:14 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxx
> > Date: 2004/02/27 Fri AM 11:03:23 EST
> > To: oracle-l@xxxxxxxxxxxxx
> > 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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
