Re: Performance estimation

OK, let's disagree together ;^)
Yup, the input actually is the requested response time. There is the possibility to create load files, where mix, type, and frequency of transactions can be recorded. Some even come with predefined sets for Oracle Apps. So, as it -indeed, you are right- does not predict response time for give hardware, it generates hardware requirements for a given required response time.
With a little playing around that _might_ help the original poster to get some impression whether his h/w can come close to the response wanted.

Quite a handy tool.

Brian Peasland wrote:

> > Well Brian, as much as I appreciate your comments, I have to disagree here:
>
> I'm always in the mood for a little disagreement....
>
> > Oracle itself has - in co-operation with HP, Compaq and Dell (I think it was
> > Dell)
> > create a program called database sizer.
> > It works kind of the other way around - you tell the load, and the program
> > will
> > estimate the h/w (by HP, Compaq - you get the general idea!) needed to archive
>
> So now I have to disagree with a you a little. The program you are
> talking about (from your description) helps to size the database and
> estimate the hardware. But does it accurately estimate response time for
> a given query as the original poster suggested? For instance, if I give
> you a query such as:
> SELECT col1,col2,AVG(col3)
> FROM tableA
> WHERE col1=cond1 AND col2=cond2
> GROUP BY col1,col2
> ORDER BY col1,col2;
> Can you plug in some numbers such as the block size, the buffer cache
> size, etc. and tell me how long it takes to execute this query? I think
> that this is what the original poster was looking for.
>
> I have no doubts that such a program as you described exists and is very
> helpful in a variety of situations. But it seems to digress from the
> original post.
>
> Just my 3.14159265 cents worth,
> Brian
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Tue Oct 03 2000 - 14:16:43 CDT