Re: Poor Performance on Oracle9i

From: Vladimir M. Zakharychev <bob--nospam--_at_dynamicpsp.com>
Date: Sat, 6 May 2006 14:11:02 +0400
Message-ID: <e3hsnp$245b$1@hypnos.nordnet.ru>

"Vladimir M. Zakharychev" <bob--nospam--_at_dynamicpsp.com> wrote in message news:e3hs15$23ra$1_at_hypnos.nordnet.ru...
> <snip>
> In addition to what others suggested:
>
> 1) remove all hidden (starting with underscore) parameters.
> You shouldn't set them unless you understand what they
> do and possible consequences from using them or you
> are instructed by Oracle Support to set them.

Well, after reviewing the note 216205.1 I remove this suggestion, but still recommend that you remove all hidden parameters not explicitly listed in that document and check that values of those listed match Oracle recommendations.

-- 
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com

Received on Sat May 06 2006 - 05:11:02 CDT

Re: Poor Performance on Oracle9i - 9.2.0.7