Re: set a rollback segment for a specific user

"Pete Sharman" <peter.sharman_at_oracle.com> wrote in message news:ahvbna01am4_at_drn.newsguy.com...
> Totally agree. In fact, to turn Oracle into SQL*Server you'd need to ADD
a lot
> more parameters - TABLE_LOCKING=ALWAYS and RUN_FAST=FALSE spring to mind
> immediately! ;)

Not to mention SINGLE_PLATFORM=TRUE, and DB_BLOCK_SIZE="8K SO THERE." <snip>

> It's great to make the database easier to manage, and I can see why they
> want to do that. But it shouldn't be at the expense of taking away
flexibility
> from the advanced users UNTIL we're guaranteed that the database does a
better
> job than manually fiddling with things does. I think we're starting to
see the
> tide turn that way on some things (LMT's vs. DMT's for example). Do you
want to
> go back to the days when you use to have to manage everything with a fine
tooth
> comb?

I'm in two minds about this. I do think Oracle should be easier to manage. I rather suspect that most people who use it do just install take all the defaults and run for a while (until they get a consultant in) maybe. To be honest this ought to be an acceptable approach to software installation (just as it is with hardware). Of course actually having sensible defaults would help in this!

OTOH I don't believe that we can ever 'guarantee that the database does a better job than manually fiddling does'. I suspect that *for the skilled professional* it will always be possible to outperform the softwares automatic (but general) choices by specific manual tuning.

I believe we are getting to the point where this 'manual fiddling about' (surely high performance technology engineering <g>) becomes more and more pointless since the software is 'good enough'. The question then becomes do you leave the ability to manually tune or do you just say this is too dangerous and more often than not will leave the database in a worse state than it was before.

--
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

******************************************