Re: Oracle performance with Microsoft Project

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:3f589016$0$14563$afc38c87_at_news.optusnet.com.au...
> "Ed Stevens" <nospam_at_noway.nohow> wrote in message
news:co2hlv8inrtb2rpa5i3ls4eiai3rtnibfb_at_4ax.com...
>
> > >From my limited experience with SQL Server (mainly 6 and 7 and 2000),
> > >there's nothing to tune; it handles itself. Therefore an
out-of-the-box SQL
> > >Server installation might run better initially then an out-of-the-box
Oracle
> > >installation.
>
> Correction: there is NOTHING you can tune. Don't confuse lack
> of tuning ability with the lack of need to do it.

Um not really so. SQL can still be tuned, the correct object types and data types can still be picked or not by the designers, objects that contend for IO can still be separated from each other etc etc.

Of course it isn't as rich an environment, but that doesn't mean that it can't be well or badly setup, with good or bad design decisions taken. And after all most tuning is done in the design phase isn't it - thats what all the books tell me <sounds of manic laughter....>

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************