Hi, That is NOT an easy task.
I would recommend that you turn API/ESCL/FLTR/SQL logging on, and sample enough data to catch these same SQL-calls, and you will have a better hope of finding what you are looking for. Our commercial RRR|Log tool has one goal, and that is to make that search easier. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. > Classification: For internal use only > > Hi, > > I am currently working through all high cost SQL identified in an Oracle > (10g) AWR report. Does anyone know the best way to relate these SQL > statements to the Remedy active links and filters? I am querying the > actlink_set/push etc table via SQL Developer but so far I haven't been > able to find the right combination of statements/tables to lookup the SQL. > > As always, thanks in advance! > > Regards, > > Paul Nicolaides > Consultant > > > --- > > This e-mail may contain confidential and/or privileged information. If you > are not the intended recipient (or have received this e-mail in error) > please notify the sender immediately and delete this e-mail. Any > unauthorized copying, disclosure or distribution of the material in this > e-mail is strictly forbidden. > > Please refer to http://www.db.com/en/content/eu_disclosures.htm for > additional EU corporate and regulatory disclosures. > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"