Re: Poor Performance after 9i migration on Windows

On Fri, 09 Jul 2004 09:59:01 +0200, Christian Antognini wrote:

> Application tuning make only sense if the instance is correctly configured.
> Or do you want to start adding hints to all queries?

For one, see what are you waiting for, do you have any statistics and alike. Then worry about the instance. Speaking of a slow database is not a smart thing to do. Database is never slow, applications are. If you need help, then give me the information I need to help you. If you know the answer, then you don't need this group. First and foremost, take 10046, level 8 trace from the application that is slow. As I've said before, except in rather extreme cases, the impact of the instance parameters is few percents only. The root cause of the problem is usually fouled up SQL. I have no idea why meddling with the instance parameters has such an appeal for beginner DBAs. To my knowledge, Oracle hasn't yet shipped a version which has "_silver_bullet" parameter. That is planed for Oracle 99z.

-- 
Well-behaved women seldom make history