Re: The responsible

On 07/02/06, Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx> wrote:
>
> In small business ( 20 person or less ) dbas works is in other way.
> The problem is in small application (or very small applications and
> small subiness) you "don't have time",

I've worked in big businesses, I've worked in small business, I've
worked in small businesses developing software for big businesses. 
Generally you want  the important apps and the important bits of other
apps to perform really well.  A small app, or small functional area in
an app, that a lot of people use a lot of the time will probably
garner you more kudos to tune well than a big app used by two people
to run big queries over night.  The big queries may take hours to run
but, so long as the data is ready by the time the users get in in the
morning and it doesn't push your backup window so it interferes with
business,  who cares?

It's true that usually you're looking for a global solution but if
you're in a situation where an important query is running unacceptably
slow but the fix causes other queries to run slowly it's worth
remembering that you might be able to use session level parameters to
implement the fix just when you need it.  Just because a hammer is a
good tool for driving in nails, it doesn't mean you should only ever
use a hammer or even restrict your self to one type of hammer.

Stephen

--
It's better to ask a silly question than to make a silly assumption.

http://stephensorablog.blogspot.com/
--
http://www.freelists.org/webpage/oracle-l

Other related posts: