Re: reg Oracle 10g maintainance

rahulbabu.mummaneni_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 to http://tahiti.oracle.com and 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
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org