On Fri, Dec 4, 2009 at 10:49 AM, svanderclock <svanderclock@...> wrote:

> how to detect not optimized queries ? actually i simply look the time the query take to execute, but it's not good enalf because it's can take time not because of the query but because for exemple the server is overloaded (too much users).

One way is to look for queries that consume too much disk i/o. Check
mon$statements and mon$io_stat or <ad> sinatica.com </ad>.
You may also analyze the query execution plan to identify possible
optimizations.

hth,
--
Douglas Tosi
www.sinatica.com