如何确定存储过程在Oracle中的最后修改或编译时间? [英] How do I find out when a stored procedure was last modified or compiled in Oracle?

问题描述

我最好是寻找一个SQL查询来完成此操作，但其他选项也可能有用.

I'm preferably looking for a SQL query to accomplish this, but other options might be useful too.

推荐答案

SELECT LAST_DDL_TIME, TIMESTAMP
FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'PROCEDURE'
AND OBJECT_NAME = 'MY_PROC';

LAST_DDL_TIME 是上次编译它的时间. TIMESTAMP 是上次更改的时间.

LAST_DDL_TIME is the last time it was compiled. TIMESTAMP is the last time it was changed.

即使依赖项发生更改，即使过程没有更改，也可能需要重新编译过程.

Procedures may need to be recompiled even if they have not changed when a dependency changes.

这篇关于如何确定存储过程在Oracle中的最后修改或编译时间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！