您如何知道是否正在使用PL/SQL包，过程或函数? [英] How can you tell if a PL/SQL Package, Procedure, or Function is being used?

问题描述

如何确定是否正在使用PL/SQL包，过程或函数?是否有一个Oracle表或视图包含有关PL/SQL包，过程或函数使用情况的统计信息?

How can you tell if a PL/SQL Package, Procedure, or Function is being used? Is there an Oracle table or view that contains statistics on PL/SQL Package, Procedure, or Function usage?

推荐答案

您也可以尝试查询USER/ALL_source:

You can also try querying USER/ALL_source:

SELECT * FROM all_source
where UPPER(TEXT) like UPPER('%procedure_name%')

或

SELECT * FROM all_source
where UPPER(TEXT) like UPPER('%package.function_name%')

您将不得不忽略自我参考，但这应该很容易发现.

You'll have to ignore self references, but that should be easy to spot.

您还需要从user/all_views中检查视图"源.不过，请参阅另一个有关查询视图源的问题.

You'll also need to check "view" source from user/all_views. See the other question about querying view source though.

您还可以检查软件包或顶级功能/过程是否与

you can also check if a package or top level function/procedure is used with

select * from all_dependencies
where referenced_name like '%PACKAGE_NAME%';

NB:根据需要使用all_/dba_切换user _

NB: switch user_ with all_/dba_ as needed

如果您专门在寻找未调用的函数，那么另一种选择是在打开警告的情况下编译代码，然后寻找PLW-06002和LPW-06006

if you are specifically looking for uncalled functions then another option is to compiler your code with WARNINGS turned on and then look for PLW-06002 and LPW-06006

exec DBMS_WARNING.add_warning_setting_cat('ALL','ENABLE','SESSION')
create or replace function x return number
as
procedure y is begin null; end;
begin
return 0;
return 1;
end;

show errors

Errors for FUNCTION X:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1      PLW-05018: unit X omitted optional AUTHID clause; default value DEFINER used
3/1      PLW-06006: uncalled procedure "Y" is removed.
6/1      PLW-06002: Unreachable code

这篇关于您如何知道是否正在使用PL/SQL包，过程或函数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！