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,
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 :
- Cursor_sharing = similar
- _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-lReceived on Fri Jul 01 2016 - 09:36:34 CEST