Performance estimation

From: <sergey_s_at_my-deja.com>
Date: Sat, 30 Sep 2000 02:50:47 GMT
Message-ID: <8r3ke6$1do$1@nnrp1.deja.com>

I've worked once with a Sybase DBA who had created an Excel spreadsheet for estimating performance of his queries. He would enter a bunch of numbers such as cache size, unit (block) size, etc. And the spreadsheet would spit out some totals (estimated execution time, resource usage, etc.). This was a long time ago, and I didn't realize the value of it as I was pretty inexperienced then.

Has anyone done anything similar for Oracle? I would love to come up with a spreadsheet like that. If you have any thoughts on this or if you have done something like that, could you share it? I could use a good starting point or any ideas.

Thank you in advance!
Sergey

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 29 2000 - 21:50:47 CDT