Tuning a query on a non-dedicated machine

From: <conwayjim_at_my-dejanews.com>
Date: Mon, 12 Oct 1998 17:21:44 GMT
Message-ID: <6vtdr9$lmo$1@nnrp1.dejanews.com>

We are looking for the right (mostly oracle) utilities to run...and statistics to capture to determine which version of a query would run more efficiently
(speedwise). We don't have a dedicated system to use to benchmark the
queries...so we want to pick the query based on analysis of reports/statistics
(explain plan is one input). Eventually...we will get real user
response time feedback.

What utilities would you run...and what stats would you look at to support your decision to rollout one query vs another?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 12 1998 - 12:21:44 CDT