Skip to Main Content
  • Questions
  • Last run date of a function on a menu

Breadcrumb

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

Question and Answer

Connor McDonald

Thanks for the question, Beth.

Asked: October 23, 2019 - 4:38 pm UTC

Answered by: Connor McDonald - Last updated: October 25, 2019 - 5:48 am UTC

Category: Database Administration - Version: 11.2.0.4

Viewed 100+ times

Whilst you are here, check out some content from the AskTom team: Converting Common Table Expressions from SQL Server to Oracle

You Asked

Is it possible extract the last run time of a function run on a menu from the Oracle database?

and we said...

Only if you store that artefact yourself.

If it just to see if that function is NOT being run, you could turn on auditing for that function (assuming it lives in the database), but be aware that we would then be tracking *every* execution of it.

There are various V$ views that might let you get a (rough) approximation, see v$sql and v$db_object_cache, but there are no guarantees in there.

and you rated our response

  (1 rating)

Reviews

Is this an EBS question?

October 24, 2019 - 7:34 am UTC

Reviewer: John Keymer

I might be wrong, however the wording of this question sounds like it might be E-Business Suite related, whereby you have "functions" (forms/web pages etc, not database functions) attached to a menu.

iif that is the case - then providing the "Sign-On:Audit Level" profile value is set to "FORM", this information is available in the table fnd_login_resp_forms for Forms accesses only.
Connor McDonald

Followup  

October 25, 2019 - 5:48 am UTC

Thanks for the addenda

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.