Function Madness : What to do when an application over-uses PLSQL functions.

After troubleshooting a system with CPU-overload, we found it was mainly due to too many PL/SQL
function-calls. The result was some interesting investigation into PL/SQL functions, when to use and
when use turns into AB-USE of functions.