I used the wrong wording there, it's actually called an Execution Plan but I think of it as a path being mapped through your database. Databases store execution plans to help them run repetitive statements more efficiently.
The database's CBO takes each SQL statement that it receives and creates an "execution plan" that it uses to run through the data. The CBO then stores that plan so that the next time that statement comes in it already knows how to run it. Sometimes the stored plan is not the best optimized plan and can be tweaked. Oracle uses EXPLAIN PLAN, in MSSQL you can view the execution plan and optimize it through Query Analyzer. You can read about Oracle's explain plan here http://www.oracle-base.com/articles/8i/ExplainPlanUsage.php -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of vikram_k Sent: Wednesday, February 16, 2011 9:53 PM To: [email protected] Subject: Re: Performance matrix 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
