Is there a faster way to delete trace files

[shaynegw]

Hi

I've been experimenting with the trace optimization feature in PL/SQL Developer. The feature works fine, but with a large trace file I find I can't delete the trace run until after the entire trace has loaded, which with one of mine took over 1/2 hr.

Is there any way to delete trace file runs via the backend so I don't have load the entire trace into PL/SQL Developer first?

Thanks and take care,
Shayne

 

[Marco Kalter]

You can delete records from the following tables:

• sys.plsql_trace_runs
• sys.plsql_trace_events

We'll look into the performance issue.