Bug Fixing Support for Oracle 11.2.0.3 will end soon

Rana says:

Hello Mike Dietrich,

I am reaching out to get advice on the post upgrade plans for upgrading a 110TB RAC Database currently on 11.2.0.3 to 11.2.0.4.

I have learnt about the Bug 15898932 – Wrong Cardinality estimation with predicates over nchar columns. (Doc ID 15898932.8), which we are planning to address but the issue is we are hitting around 2600+ tables of which some are in greater than couple of TB in size and really looking at ways if we can avoid re gather statistics /global statistics etc.

SQL oracle provided to identify Bug 18255105 Patch for upgrade scripts to identify histograms affected by fix of bug 15898932

select distinct OWNER, OBJECT_NAME TABLE_NAME from dba_objects where OBJECT_ID in (
select t.obj# from sys.tab$ t, sys.col$ c /* non-partitoined tables */
where bitand(t.property,32+512+4194304+8388608+2147483648) = 0
and bitand(t.flags,536870912) = 0
and bitand(t.flags,2097152) = 0 /* monitoring is off */
and bitand(t.flags,16) != 0 /* analyzed */
and t.obj# = c.obj#
and c.type# = 96 /* char type column */
union all /* table partitions */
select tp.obj# from sys.tabpart$ tp, sys.tab$ t, sys.col$ c
where tp.bo# = t.obj#
and bitand(t.flags,2097152) = 0 /* monitoring is off */
and bitand(tp.flags,2) != 0 /* analyzed */
and t.obj# = c.obj#
and c.type# = 96 /* char type column */
union all /* table subpartitions */
select tsp.obj# from sys.tabsubpart$ tsp,
sys.tabcompart$ tp, sys.tab$ t,
sys.col$ c
where tsp.pobj# = tp.obj# and tp.bo# = t.obj#
and bitand(t.flags,2097152) = 0 /* monitoring is off */
and bitand(tsp.flags,2) != 0 /* analyzed */
and t.obj# = c.obj#
and c.type# = 96 /* char type column */)
order by owner;

Thanks