Re: Performance Predictions - How to?

EscVector wrote:
> I have a multiple part process and I'm able to predict runtime based on
> record count within +-30 minutes. The prediction is made by taking the
> total to-be-processed record count from the longest single process and
> dividing it by the runtime total of all processes.
> How is this mathematically possible/sound? This isn't even a linear
> projection. Just dumb luck?
>
> I'm looking for ways to project performance based on record counts, so
> any suggestions are welcome.

dbms_application_info.set_session_longops

http://www.psoug.org/reference/dbms_applic_info.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org