Anywy to accurately predict time for long running queries?

From: <ryan.gaffuri_at_cox.net>
Date: Tue, 10 Feb 2004 8:09:44 -0500
Message-Id: <20040210130942.GJCT2432.lakemtao07.cox.net@smtp.central.cox.net>

People here want me to accurately predict how long it will take long running SQL to execute. I'm reading carrie milsap's book now, and I believe he has some methods that give good estimates on overall performance(I have not gotten to that part yet).

any known methods to accurately predict sql? BTW, I dont have specs on the hardware, its a customer site... and yes I know you really need that.

I dont think this is doable, but im wondering if anyone has put together any papers on the subject.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Feb 10 2004 - 07:09:44 CST