Hi
I want to list all the stored procedures that are being used, when, how many times, who uses etc(kind of monitoring/auditing). All of these stored packages are declared in packages.
Does anyone knows how to do it??
regards
--raju
Printable View
Hi
I want to list all the stored procedures that are being used, when, how many times, who uses etc(kind of monitoring/auditing). All of these stored packages are declared in packages.
Does anyone knows how to do it??
regards
--raju
use auditing
we can issue audit statements directly on objects like tables,
procedures, packages, indexes, views,..etc. but how do you audit the stored procedures and find their usage??
we have around 1600 stored procedures in 72 packages.
--raju