Oracle procedure usage metrics?



  • I'm recently working in a large Oracle database that is in need of cleanup. As part of that cleanup, we'll be looking for unused PL/SQL.

    Does Oracle internally track usage of entities over time? If so, how is that information accessed?



  • Impossible to tell if a stored procedure is still needed. You can find when it was last compiled. Perhaps you can learn something from that date? No documentation available? Anything you remove can make a future procedure fail. Internally, Oracle can show you dependencies, but the problem is with all the different clients. You could add logging to each and every procedure about which you're in doubt, and come back and see after a couple of years.


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2