Okay, this is just a guess. Is what this report running in an Oracle Product? Does this Oracle product have a local PL/SQL engine? If so, this could possibly be your problem. Mind you, I haven't used any of Oracle's other products (Forms, Designer, etc.), but I do remember reading that some have local PL/SQL engines. This *may* mean that, since you are using PL/SQL functions in your SQL, maybe the local engine is parsing the statement for you, calling over to the server to get the raw data for the rows, and then for each row, maybe calling back out to the server again to resolve the PL/SQL function call. Such a setup would result in an abnormal growth curve of response time over distance.

Can anyone confirm or deny this theory?

- Chris