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@xxxxxxxxx> 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>
