sanity check - histograms, cursor sharing & bind var peeking

From: Jo Holvoet <jo.holvoet_at_gmail.com>
Date: Fri, 1 Jul 2016 09:36:34 +0200
Message-ID: <CA+4k+SuhocRhZNMkBZmuTUcV4rZ0TwJZTZP9K34YtnLQ0ZH7gw_at_mail.gmail.com>



Hi all,

I recently inherited a database (10.2.0.4 EE 2-node RAC, about 3 TB of data).

Stats are gathered manually for certain tables with : method_opt=> 'for all columns size skewonly'

But :

  1. Cursor_sharing = similar
  2. _optim_peek_user_binds = FALSE

I would have thought in this scenario it makes no sense at all to gather histograms ? Or am I missing something somewhere ?

Thanks & regards

Jo

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jul 01 2016 - 09:36:34 CEST

Original text of this message