Re: Bind Variable - Query slow
From: GovindanK <gkatteri_at_gmail.com>
Date: Fri, 23 Mar 2012 16:36:00 -0700
Message-ID: <CAPb52X5dvfi0G+UM+dmz69ErD891R9xnET4HN7OpoPwtJFahog_at_mail.gmail.com>
I deleted the histogram and it worked. So i went ahead and deleted the statistics, gathered stats , checked the histogram / buckets; deleted the histogram for the columns of the particular problematic table , verified and it is now working fine. Of interest is the Metalink article : 1031826.6 ; The concepts remain the same. Don't worry about the version. I wish i had seen it earlier.
Date: Fri, 23 Mar 2012 16:36:00 -0700
Message-ID: <CAPb52X5dvfi0G+UM+dmz69ErD891R9xnET4HN7OpoPwtJFahog_at_mail.gmail.com>
I deleted the histogram and it worked. So i went ahead and deleted the statistics, gathered stats , checked the histogram / buckets; deleted the histogram for the columns of the particular problematic table , verified and it is now working fine. Of interest is the Metalink article : 1031826.6 ; The concepts remain the same. Don't worry about the version. I wish i had seen it earlier.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 23 2012 - 18:36:00 CDT