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"
