RE: Long Parse Time

From: Tanel Poder <>
Date: Thu, 7 May 2009 15:24:14 +0300
Message-ID: <627CE5F474B24CE5A9FE04F6931D9043_at_porgand>


Even a second of parsing CPU time is too long for most (sane) SQL statements!  


Tanel Poder <>

From: [] On Behalf Of Ric Van Dyke
Sent: 07 May 2009 14:45
To: Riyaj Shamsudeen; 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') */    

-- Received on Thu May 07 2009 - 07:24:14 CDT

Original text of this message