Re: Seeking Advice: MS SQL DBA learning Oracle?

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:<38QD8.41666$WR1.39058_at_sccrnsc01>...
> Dusan,
> Right on. Yes, the developer should have at least a basic understanding of
> how the backend works. Just the other day I had a developer want to create
> temp tables because that's what you do in Sybase. I spent some time
> explaining Oracle to them and they were pleased as punch that they didn't
> have to deal with that mess anymore. What also surprises me is those
> developers that don't read the APPLICATION developers guide. So they don't
> put performance in from the start - "we will tune later." Performance is
> part of the daily job not something you bolt on later. Okay, I occasionally
> use the _run_faster=true parameter, but usually I make the developers fix
> it. :-)
>
> Jim
>
> "Dusan Bolek" <pagesflames_at_usa.net> wrote in message
> news:1e8276d6.0205130013.234fb31a_at_posting.google.com...
> > rgaffuri_at_cox.net (Ryan Gaffuri) wrote in message
> news:<1efdad5b.0205121459.cd19ffe_at_posting.google.com>...
> > > You have IT experience which is VERY good. However, you must start as
> > > a developer and NOT as a DBA. There are no entry level DBA jobs. You
> > > have to be more of a programmer first for 2-3 years then you may be
> > > able to move over. Anyone who says you can start as a DBA is either
> > > lying or an idiot.
> >
> <snip for size>
> > Yes, I'm going to flame you right now !!! ;-)
> > For all developers: Please read Oracle Concepts. You should know
> > something about architecture of database you're writing for. I'm tired
> > about all that worthless talks about purpose of schemas, why database
> > != schema, why more than one schemas can be in one tablespace, why is
> > not a good idea to put two 30gig database in one instance even if
> > they're on the same DB server etc ...
> > And performance tuning is indeed the must for any Oracle developer.
> > New developer should start with learning about performance impacts of
> > various SQLs as soon as wrote the first lines of code. Oracle
> > developer without tuning skills is worthless and even dangerous.
> >
> > --
> > _________________________________________
> >
> > Dusan Bolek, Ing.
> > Oracle team leader
> >
> > Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
> > can call it an overture to bankruptcy) on that server. I'm still using
> > this email to prevent SPAM. Maybe one day I will change it and have a
> > proper mail even for news, but right now I can be reached by this
> > email.

When did you start out as a DBA without being a developer and how many jobs do you know that are open for DBA's who were not developers first? Almost none....
So if you tell people to try to be DBAs first nearly all of them will not get a job.

Yes, developers should learn the database, its not a pre-requisite to get your first job. In your first job they will want you to know some SQL, PL/SQL and probably forms and/or reports. You really think the DBA is gonna let some entry level DBA have anything to do with performance?

The concepts document is excellent to read after you have 6 months working experience. It covers too many topics before that. Even then, Id recommend 3 reads over a period of 2-3 months to digest it all. Received on Mon May 13 2002 - 15:28:45 CDT