Profiler History count

[Jeff81]

How do we control this history of the Profiler runs in the Test Window. I have history going back 9 years and I think it might be slowing it down. I can see you can delete an individual run in the window but that will take a while. Is there a file I can edit or delete?

 

[Marco Kalter]

You can delete plsql_profiler_data, plsql_profiler_units, and plsql_profiler_runs rows.

The following demo script deletes the profiler data that is owned by the current user and that is older than 1 year:

-- Delete data
delete plsql_profiler_data where runid in
  (select runid from plsql_profiler_runs
    where run_owner = user
      and run_date < trunc(sysdate) - 365);
-- Delete units
delete plsql_profiler_units where runid in
  (select runid from plsql_profiler_runs
    where run_owner = user
      and run_date < trunc(sysdate) - 365);
-- Delete runs
delete plsql_profiler_runs
 where run_owner = user
   and run_date < trunc(sysdate) - 365;