| audit procedure inside a package [message #138121] |
Tue, 20 September 2005 04:06  |
sdecman
Messages: 20
Registered: July 2005
Location: Ljubljana, Slovenia
|
Junior Member |
|
|
Hello to all!
Probably a stupid question to ask, but I'm really stuck...
We are doing some optimization and I would like to find out how many times a certain procedure is called. Because all our procedures and functions are stored inside packages, I really don't have a clue on how to approach this problem. I've set AUDIT_TRAIL=DB and AUDIT EXECUTE ON <package> WHENEVER SUCCESSFUL gives me only the package name, not the actual procedure being called.
Need some advice...
Thanks
|
|
|
|
|
|
| Re: audit procedure inside a package [message #138256 is a reply to message #138121] |
Wed, 21 September 2005 00:37  |
sdecman
Messages: 20
Registered: July 2005
Location: Ljubljana, Slovenia
|
Junior Member |
|
|
Thanks for your reply.
| Quote: |
The easiest would be to add some coding to the procedures within this package to INSERT a row into an audit table whenever it is called.
|
I was thinking of it too, but since there are about 200 packages with at least 5 procedures per package there is a large amount of work to be done. I was looking for an "easy" solution to the problem, "straightforward" ones are usually considered as a last resort.
Regards,
Samo
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
