Re: Tracing query inside procedure without 10046

Hello Krishna,
are you talking about live analysis or about post-problem analysis?

If you mean live, you can also use the PL/SQL hierarchical profiler (DBMS_HPROF). It will show you exactly how much time is spent in your PL/SQL code or with SQL execution.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: www.soocs.de
Twitter: _at_OracleSK

> Krishnaprasad Yadav <chrishna0007_at_gmail.com> hat am 01.08.2023 07:25 CEST geschrieben:
>
> Dear Gurus, 
>
> currently working on slowness issue of procedure which is part of procedure
> like : proc_name.subproc_name , over here i need to figure out the query related to subproc_name and not by using 10046 trace .
> I tried ashrpti.sql and used pls_object_entry but I didn't get any values in the report .
> Is there any way to figure out queries related to such subproc_name also tried from dba_hist* views too by providing top_sql /pls_object values but no luck .
>
> Currently in my situation trace was taken (10046) and from procedure verified queries and by recommendation on it . but it was challenging to figure out queries without tracing.
>
> It would be great help if you provide any light on it .
>
> Regards,
> Krishna

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