Benchmarking Oracle User Procedures/Functions

deLL

New Member
I'm thinking of a way on how to benchmark an Oracle procedure. My idea is this, put a \[code\]logging function\[/code\] on each \[code\]part\[/code\] of the \[code\]procedure\[/code\] you wish to benchmark. Store the time it entered that part. Then, create another app (using PHP) to compute the difference between each execution.The PHP app is needed to make it as layman as possible.This idea wont work though because it is too scattered and obstrusive. If I want to execute the function/procedure multiple times at the same time, the result will be wrong.Algorithms are fine. Codes is better. The whole app is best. :)
 
Back
Top