开发者

Oracle: System table/view/proc which tracks proc/function/pkg invocation?

Is there a system table/view/procedure/whatever which can be used to determine the last ti开发者_如何转开发me a proc, function, or packaged procedure was invoked?


Not really.

You can check in v$locked_object to see if it is currently being used. If you have auditing enabled for that object you may see something in the file/table. If it is INVALID in ALL_OBJECTS then you could look at what dependencies it has, see their last_ddl_time and get an idea when it might have been invalidated.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜