Re: Competition for OraPerf

Jonathan Lewis wrote:
> "Charles Hooper" <hooperc2000_at_yahoo.com> wrote in message
> news:1162561951.186173.66360_at_m7g2000cwm.googlegroups.com...
>
> Over a 2-hour period, an average of 241 milliseconds for
> SQL*Net message from client events tends to suggest a
> client program performing a massive load one row at a
> time. This does suggest the need for array processing,
> but as you say, pl/sql is (barring Forms) serverside. I think
> you would only look at SQL*Net tuning if you were seeing
> lots of 'more data' from or to client - because there might be
> some mileage in a larger TDU or SDU.
>
>
> And in this particular case, given the constant table-scanning going
> on, the buffer busy waits might simply be the result of sessions
> waiting for other sessions to finish a scattered read. So in a small
> sense, the suggestion of buying SSD is correct - it might reduce the
> wait times for other reads: but (a) it would probably be cheaper to
> stop doing the excess tablescans, and (b) the reason given for buying
> the SSD is not the right reason.

Thanks for the reply to my comments.

When will the other two books in series that includes "Cost-Based Oracle Fundamentals" be available? I am looking for another Oracle book or two that attacks an Oracle feature with as much detailed analysis as the "Cost-Based Oracle Fundamentals" book.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Nov 03 2006 - 09:43:47 CST