Re: How to tune for "too many" users ?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 30 Apr 2003 11:38:04 +0100
Message-ID: <3eafa792$0$29712$ed9e5944@reading.news.pipex.net>

"Stephan Bressler" <stephan.bressler_at_siemens.com> wrote in message news:b8o7tu$n2d$1_at_news.mch.sbs.de...
> Getting worse the last 4-6 weeks, last_analyzed 3 weeks ago? And you got
> expensive statements?!
> Well, seems to be the optimizer, which looks at data volume and
distribution
> and so on.

Unfortunately neither the timescales given above, nor the symptoms described by the user actually match your diagnosis. If it was a case of bad plans then all users would be affected, the problem would not manifest itself only after n users connect. Similarly none of 4,5 or 6 equal 3.

As Norman says statspack would be the way to go.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Wed Apr 30 2003 - 05:38:04 CDT