<snip>
In addition to what others suggested:
- 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.
- remove event 10235 as it should only be turned on if
you suspect there are problems with memory (hardware)
or had memory-related ORA-600/ORA-7445 errors.
Same rule applies to events as for hidden parameters - don't
set them if you don't know what they do and not instructed
to do so by OSS. This particular event may have negative
impact on performance on highly concurrent systems.
- session_cached_cursors of 4000 seems a bit too much,
what was the reason for bumping it so high?
- How were the pools configured prior to migration?
Specifically, what were the shared pool and the buffer
cache sizes?
--
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Sat May 06 2006 - 04:58:57 CDT
