Skip to Main Content
  • Questions
  • Audit execution of package body related to TABLE

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Bolat.

Asked: October 14, 2016 - 6:46 am UTC

Last updated: October 15, 2016 - 1:36 am UTC

Version: 11.2.0.4.

Viewed 1000+ times

You Asked

HI TOM,
question about auditing

We turned on DML commands for table X1.
How we check if package_body X1_PKGB (contains views, triggers, packages, synonyms) related to table is executed?
I am in interested in details - table(X1), package body, element in package body, time, Is it possible?
How can we track it?

Because we check in toad - target 'Table' - we go to tab 'Used By' - it used by package body.

With regards!

and Connor said...


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library