Re: Oracle Administration Requirements

Jn wrote:

> We are considering a new software application which uses the Oracle
> database. Our company has had no prior experience with Oracle - we've
> used Progress on Unix for the past 14 years and Informix on Unix for
> the past 2 years, so we do have RDBMS experience. My question is -
> how does the database administration requirements of Oracle differ
> from that of Progress and/or Informix? I keep reading in other posts
> of the high administration cost of Oracle relative to other databases.
> Can anyone elaborate on that? Will we need someone full time
> serving as the Oracle DBA? I know that we will need staff with Oracle
> database knowledge/skills - my question is - is administering the
> Oracle database / environment a full time activity?
>
> The application will have about 75 users, a production and test
> server/database of approximately 40GB each, running on Windows 2000
> servers.
>
> Thanks in advance,
> jn

Oracle is a very different animal and anyone trying to manage it with the same skill set and knowledge as learned from Progress and Informix is in for some very rude surprises.

I have a class I teach through the Puget Sound Oracle Users Group for Informix developers and DBAs moving to Oracle. Contact me off-line or in c.d.o.marketplace if interested.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)