I'm working on a fairly high volume 7.03 IM/7.1 patch 6 ARS (Solaris) with a remote Oracle database.
The database/AR setup is configured correctly - we have CLOB row in-storage, Oracle cursor sharing set to FORCE, etc, etc. Recently we started to see performance problems - I have tracked those down and we are dealing with them - I did notice one weird thing in the meantime. The Oracle database is set up to handle up to 400 connections. The AR Server is setup to have a min of 2/2 and a max of 33/38 fast/list threads respectively. During the performance problem periods we never got more than 12 fast threads open and 6 list threads. And neither server (AR and db) were near peak capacity. Shouldn't Remedy be opening more threads up if it is can and things are backed up? William Rentfrow Principal Consultant, StrataCom Inc. [email protected] Blog: www.williamrentfrow.com O 715-592-5185 C 715-410-8056 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
