Hi All,
Recently upgraded system from 11.9.2 to 12.5.1 (OS: Solaris 2.8).
Procedures are running very slow. Application response time went down a lot.
I've done the typical maintainence on the system (drop/create indexes; recompile stored procs.; update statistics also; etc. Also configured the system to have large procedure caches and data caches.).
It didnt make much difference. Any ideas ?
Thanks.
Recently upgraded system from 11.9.2 to 12.5.1 (OS: Solaris 2.8).
Procedures are running very slow. Application response time went down a lot.
I've done the typical maintainence on the system (drop/create indexes; recompile stored procs.; update statistics also; etc. Also configured the system to have large procedure caches and data caches.).
It didnt make much difference. Any ideas ?
Thanks.