Re: Oracle versus MS Sql Server

"Michael G. Schneider" <mgs_at_mgs-software.de> wrote in message news:9ratff$arm$00$1_at_news.t-online.com...
> "Howard J. Rogers" <howardjr_at_www.com> schrieb im Newsbeitrag
> news:3bd87efc$0$8345$afc38c87_at_news.optusnet.com.au...
>
> > I've got to say that your approach is doomed, and you'd be better off
> > writing applications for Access. I certainly wouldn't want to tune the
> mess
> > you, with your somewhat idiosyncratic approach, are almost inevitably
> going
> > to leave your DBAs.
>
>
> There is absolutely no reason for trying to offend me. I do know the
> difference between Access and Oracle. And when finishing my software
> development tasks there is no mess to be fixed by some DBA. If your
software
> developers make it necessary to create primary keys and constraints
> afterwards, you should think about changing software developers.
>
>
> As I already told, I am no Oracle DBA.I do not even know the course of
> education for a DBA. But if I am not completely wrong, "DBA" means
"Database
> Adminstration". Maybe me as a not natively English speaking person should
> not try to abstractely describe the word "Administration". But it
definitely
> does not sound like "Design" or "Development". Some of the subjects that
> immediately come to my mind when hearing "Database Administration" are...
>
> - install and update
> - intialization parameters
> - monitoring memory usage
> - monitoring performance
> - adjusting disk layout
> - configuring net structure
>
> These items certainly are not complete. But the other items mentioned in
> this thread (primary keys, constraints, cursors, ...) do sound like
> development issues to me.In the course of a project, these are decided by
me
> and are discussed with Database Designers.
>
> Michael G. Schneider

So tell me Michael: how do you go about getting PCTFREE right when creating a table? That's part of the create table statement, so that's definitely, according to you, in your territory. Tell us the thought processes you'd go through.

And when you've done that, indulge us all a little longer by explaining how big you're going to be making your rollback segments. That's a 'create...' statement, too, so again, that's in your territory. Tell us how you'd get the right size and the right number.

This is really turning out to be quite a funny thread.

HJR Received on Fri Oct 26 2001 - 17:24:08 CDT