Re: Need advice: small system platform & dba responsibilities

From: Brian Graham <GrahamB_at_psac.com>
Date: 1995/06/07
Message-ID: <3r44f2$259_at_romulus.ott.hookup.net>#1/1


In article <3q2k8d$n89_at_news.alaska.edu>, fxgwp_at_galileo.uafadm.alaska.edu (Gail Padden) says:
>
>We will develop a small multi-user system to replace an obsolete single
>user system on Dbase. Appx 10-12 tables, appx 60k records/year, normal
>daily posting 60 trans, max users 10. Platforms possibly current novell
>server or an HP9000. Preferences lean towards Oracle because our major
>systems will soon be Oracle based (new). There are several small local
>systems using other db's (foxpro, etc). I'd like a rough estimate for
>time & knowledge required for dba responsibilities. Any advice on
>platforms will also be greatly appreciated!
>
>Thank you,
>Gail Padden
>fxgwp_at_galileo.uafadm.alaska.edu
>

Hi Gail

  I strongly recommend taking some education courses from Oracle. It is, I believe, the best way to get your initial grounding in Oracle. As you likely already are aware, there are a LOT of tools available from Oracle. I think that taking a few of the more appropriate course help greatly. After that, the question is, how fast can you read?? Oracle provides about a ton or so in documentation, and you'll have to go through a fair bit of it.
  From personal experience, the first year is the worst. Learning SQL, the tools (Forms, ReportWriter, RPT, Menu, EXP/IMP, Loader) and of course, the database itself. Having said all that, getting an initial database up is fairly easy. You then have something to learn on.   The only other question is really regarding your major systems. You may want to bring in someone to tune your database initially while you are low on the learning curve.

					  Good Luck!
	                                  Brian
--
Brian Graham                    .
Programmer / DBA        ._______|_______. Tel: 613-560-5470
Public Service Alliance       \(*)/       Fax: 613-563-3492
of Canada                     o/ \o       Email: grahamb_at_psac.com
Received on Wed Jun 07 1995 - 00:00:00 CEST

Original text of this message