RE: Long Parse Time
From: Tanel Poder <tanel_at_poderc.com>
Date: Thu, 7 May 2009 15:24:14 +0300
Message-ID: <627CE5F474B24CE5A9FE04F6931D9043_at_porgand>
Hi,
Date: Thu, 7 May 2009 15:24:14 +0300
Message-ID: <627CE5F474B24CE5A9FE04F6931D9043_at_porgand>
Hi,
Even a second of parsing CPU time is too long for most (sane) SQL statements!
--
Regards,
Tanel Poder
http://blog.tanelpoder.com <http://blog.tanelpoder.com/>
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Ric Van Dyke
Sent: 07 May 2009 14:45
To: Riyaj Shamsudeen; kerry.osborne_at_enkitec.com
Cc: Oracle L
Subject: RE: Long Parse Time
Riyaj is the winner!
We put this in to the view instead of the rule hint and the query pareses and runs in about one second:
/*+ opt_param('_optimizer_cost_based_transformation','off') */
--
http://www.freelists.org/webpage/oracle-l
Received on Thu May 07 2009 - 07:24:14 CDT