About dbms_trace data analysis in test window

[Albert]

Hello!
When we go to a trace tab after execution of the statement we can see that PSD runs such query for EVERY line of trace (table plsql_trace_events):

select text from sys.dba_source
where type = :unit_type
and owner = :unit_owner
and name = :unit_name
and line = :unit_line

It is extremally slow

Thank you

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[Albert]

Hello, Marco
I've send the debug file to the mailbox support@allroundautomations.com
in addition
Such behaviour we can see in case of code profiling too (see trace file)
Thank you