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

rahulbabu.mummaneni@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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Feb 21, 9:42 pm, DA Morgan <damor...@psoug.org> wrote:
> rahulbabu.mumman...@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...@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

thank you Mr. Morgan..