What is the recommended way of finding unused functions and procedures in packages?

Question

I have a few packages which begin with the name ´LTR_´. I'm trying to clean up my codebase and would like to find if there are any unused functions and procedures.

Is it possible to query the data-dictionary to find any methods in the LTR_ packages that are not referenced from anywhere else in the DB? Is this possible without the use of a third-party tool or auditing? Thanks.

Keep in mind functions and procedures can be referenced by SQL coming from outside the database. — Brian, Mar 06 '13 at 09:48
@MridangAgarwalla:If you're using Oracle 11g ,then you can use `DBA_IDENTIFIERS` table. — Gaurav Soni, Mar 06 '13 at 10:35

score 0 · Answer 1 · answered Mar 06 '13 at 09:41

0

You can find all references with
select * from all_source where upper(text) like '%LTR_METHODNAME%'

answered Mar 06 '13 at 09:41

Egor Skriptunoff

23,359
2
34
64

What is the recommended way of finding unused functions and procedures in packages?

1 Answers1