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..

Alfa_byte,

Several parameters changed. Long answer: "default data cache" must now
be sized explicitly. Previously it inherited whatever memory was left
over in ASE after paying for all other configurable parameters.

"procedure cache percent" has been changed to "procedure cache size" --
it has an absolute size rather than a percentage of memory.

"number of engines at startup" is a new parameter.

Many other new parameters have been introduced.

Let's hope this helps.
Tom

alfa_byte2002 wrote:

alfa_byte2002 wrote:

Every time I've seen this come up in the past, it had to do with
the default data cache now needing to be sized explicitly.