We are using pl/sql profiler to collect metrics. We noticed that on one of the environment the plsql_profiler_runs table is populated with the total execution time but the finer details that gets collected in the table plsql_profiler_data is missing. Any idea why this would be happening?
We do use dbms_profiler.flush_data() before stopping the profiler and have seen this work fine in another environment.