Hi, i'm trying to tune some of our SQL inside of our custom PL/SQL Programs.
i have the query below:
select rownum, aa.*
from (select sql_id, SQL_TEXT, ELAPSED_TIME, CPU_TIME, BUFFER_GETS, DISK_READS, PARSE_CALLS, SHARABLE_MEM, fetches, executions
from v$sql
order by CPU_TIME desc) aa
where rownum < 10;
/
I want to find the PL/SQL programs that refer to these SQL by their SQL_ID or something similar.
But i do not want to use DBA_SOURCE.
Does anyone have an idea how?
thanks!