hi , thanks all for the inputs, I am currently using AR Log analyzer for my analysis would like to see what RRR team has in the tool (Misi can i have a look at the tool for a day so as to convince my management to buy it). I have few questions though,
1) The application is running since 8 years almost ( ARS 5.0.1 on SOLARIS/Oracle 9) 2) When we say i need to check my indexes on all the heavy forms what do i exactly need to do i know i have some 30 index fields set on one of my heavy form i am sure its causing problems but not sure how do i tweak it. 3) I see a lot of errors in my arerror.log file which says "too many filters executed" if i am not wrong they indicate filter looping or is there any other issue. Will increasing the filter stack size to 400 from current 200 help? 4) We are also planning to increase the fast tread count to 16 from 12 and reduce the list thread count to 16 from 20 will it help? 5) And Tommy last one is for you, I am not aware of what exactly is execution paths for oracle and its optimization do we have this on oracle 9. We have already turned off the unqualified searches and working on setting up archival functionality to reduce the search timing, but it still does not seem to have made a dent in my issue. Thanks, Vikram Tommy Morris-2 wrote: > > You may also want to ask your DBA's to make sure that the queries' > execution paths are optimized. Oracle 10g would save the execution path > automatically but 11g does not. Once I started sending captured queries > (pulled from SQL logging) to our dba's and they scripted the execution > path, we started seeing big performance improvements. > > > -- View this message in context: http://old.nabble.com/Performance-matrix-tp30936611p30946631.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
