开发者

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

开发者 https://www.devze.com 2022-12-13 20:39 出处:网络
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.

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

精彩评论

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