RE: estimate and warning before executing query

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Mon, 14 Mar 2005 15:25:48 +0100
Message-ID: <2CF83791A616BB4DA203FFD13007824A02144048@MSXVS02.trivadis.com>

Hi Eric

>Is there such a threshold in oracle that can be
>set with the same benefits:
>- early warning of 'costly' queries
>- doing only optimizing for the query

Since Oracle9i the resource manager can be setup to return an error when = the estimated execution time is larger than a threshold. Unfortunately = the estimations are not accurate in any case...

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 14 2005 - 09:30:22 CST