1

I have a procedure that does a ton of calculations scattered around other procedures. One specific calculation works quickly - less than half a second. The problem is that I need to run these calculations a large number of times, more than 100,000. As a result, everything works together for a very long time, more than 40 minutes.

The question is - how can you find those procedures (part of algorithm) that work out the largest percentage of time? Are there any ready-made practices for this? Any ideas? Any ways to summaraze the work time of functions?

Tres
  • 186
  • 1
  • 2
  • 11
  • 1
    have a look at `hprof` or `TKPROF`. if you have oracle enterprise Manager, that could help too – hotfix May 28 '19 at 13:11
  • The downside of both of those is that they require your DB Admin to provide you access. For some not a big deal. – Code Novice May 28 '19 at 23:32

0 Answers0