Re: tracing sql by force matching signature

Hello,

You can try to trace it as follows:

alter session set events 'sql_trace {eq: 4343055653486697370,refn(refp(refp(refp(varaddr("ksmuh_p"), 16), 2424), 16), 8, 408)}';

Replace the first argument of the eq filter (4343%) with your signature. A complete example demonstrating that it works is available at the link below:
https://gist.github.com/mvelikikh/eee1de10c00c07f6a81743c4b935f833#file-sql_trace_filter_by_force_matching_signature-sql

It works in 19.13 and 21.5 based on my tests. It might not work in earlier versions since it relies on chunks KGLOB and kksp within heap 0 - their structure might be different across versions.

Thanks,
Mikhail.

On Fri, 28 Jan 2022 at 14:57, Mohamed Houri <mohamed.houri_at_gmail.com> wrote:

> Hello,
>
> Is it possible to trace a SQL query by its force matching signature?
>
> Thanks
>
> --
>
> Houri Mohamed
>
> Oracle DBA-Developer-Performance & Tuning
>
> Visit My - Blog <http://www.hourim.wordpress.com/>
>
> Let's Connect - <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
> Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*
>
> My Twitter <https://twitter.com/MohamedHouri> - MohamedHouri
> <https://twitter.com/MohamedHouri>
>
>

--
http://www.freelists.org/webpage/oracle-l