Re: The responsible

On 07/02/06, Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com> wrote:

>

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