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

Home -> Community -> Usenet -> c.d.o.misc -> Re: reg Oracle 10g maintainance

Re: reg Oracle 10g maintainance

From: <rahulbabu.mummaneni_at_gmail.com>
Date: 22 Feb 2007 11:28:52 -0800
Message-ID: <1172172531.936783.90330@v45g2000cwv.googlegroups.com>


On Feb 21, 9:42 pm, DA Morgan <damor..._at_psoug.org> wrote:
> rahulbabu.mumman..._at_gmail.com wrote:
> > Hello all...
>
> > I have recently shifted from MS SQL Server to Oracle 10g EE for my
> > Server.
> > So, can anyone please suggest me what maintanance is required for
> > Oracle 10g to be constantly running on a server without any problems.
>
> > My applications are web based applications and all are medium sized
> > applications.
> > Is there any need for me to hire a DBA to maintain my Oracle Server.
>
> > Thankyou
>
> Possibly nothing at all. A well built, well tuned system on decent
> hardware you may be able to ignore for years.
>
> Then again you may not so here's my short list of recommendations:
> 1. Go tohttp://tahiti.oracle.comand bookmark it.
> Start reading the concepts and 2 Day DBA materials and
> about the WAIT interface.
> 2. Buy every one of Tom Kyte's books you can find and begin by
> reading the portion about the differences between Oracle and
> SQL Server ... they are huge.
> 3. Read up on StatsPack and play with it.
> 4. Try to talk management into getting you, if not the full
> Grid Control, the tuning pack license.
> 5. Get a sandbox and get good with RMAN backup and recovery.
> 6. Learn what an RDA is and have one prepared at all times if
> you need to contact metalink for support.
>
> 6. Make a large sign and put it over you keyboard that reads:
> "If I don't have metrics ... I won't touch it."
>
> I don't think you need to hire a DBA, full time, but it sure
> wouldn't hurt to have someone in your pocket who could come
> when required and do a monthly or bimonthly health check for you.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

thank you Mr. Morgan.. Received on Thu Feb 22 2007 - 13:28:52 CST

Original text of this message

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