Tim Smith wrote:
> We have an 8.05 database on windows 2000 and a legacy app that is
> getting a new connection for many operations. Due to performance
> problems we need to speed up this operation now, before we can fix the
> code.
>
> Are there any database parameters that are non-intrusive that can
> speed up the operation of getting a connection?
Hi,
I'm not sure about how many connections pro minute you are talking. But
maybe you're hitting the "EPC_DISABLED" bug (not sure, whether is still
exists in 8.0.5).
In order to fix it you need to modify your listener.ora (>>ENVS ...) and
reboot database & listener.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=DB1)
(ORACLE_HOME=/oracle/OFA_base/app/oracle/product/7.3.2)
(ENVS='EPC_DISABLED=TRUE')
)
(SID_DESC=
(SID_NAME=DB2)
(ORACLE_HOME=/oracle/OFA_base/app/oracle/product/7.3.2)
(ENVS='EPC_DISABLED=TRUE')
)
)
Check metalink note #1020763.6 for details.
Stephan
Received on Fri Feb 27 2004 - 04:25:02 CST
