DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: auditing stored procedures

  1. #1
    Join Date
    Oct 2006
    Posts
    3

    auditing stored procedures

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    use auditing

  3. #3
    Join Date
    Oct 2006
    Posts
    3
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width