The ORA_PROF package contains procedures, functions, and exceptions you can use when tuning your PL/SQL program units. The services in this package allow you to track the amount of time pieces of your code take to run.
Ora_Prof.Bad_Timer
Ora_Prof.Create_Timer
Ora_Prof.Destroy_Timer
Ora_Prof.Elapsed_Time
Ora_Prof.Reset_Timer
Ora_Prof.Start_Timer
Ora_Prof.Stop_Timer