When selecting the profiler tab, there's nothing displayed. Used SQL Monitor for that operation and found that this is the query being executed.
SELECT ppr.runid, ppr.run_proc, ppr.run_date, ppr.run_comment, ppr.run_owner,
SUM(ppu.total_time) as run_total_timeFROM plsql_profiler_runs ppr, plsql_profiler_units ppu
WHERE ppu.runid = ppr.runid
GROUP BY ppr.runid, ppr.run_proc, ppr.run_date, ppr.run_comment, ppr.run_owner
Runtime error occurred: 904 (ORA-00904: "PPR"."RUN_PROC": invalid identifier)
I checked the table plsql_profiler_runs, there's no column called "run_proc",is there some thing wrong?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center