Gather Stats running for long
Hi All,
I was facing issue while running GSS and its running for days(2-3). While getting the trace, found below query is taking most of the time. Any idea if this is causing trouble?
EBS - 12.2.4
DB - 11.2.0.4
I was running GSS program on ALL schemas with Estimate Percent 0 and Gather Options as "GATHER AUTO".
DB size is 13Tb and few tables are over 1TB in size and are partitioned and incremental was set.
SQL ID: d89c1mh5pvbkz Plan Hash: 2577411279
SELECT /*+ rule */ U.NAME, OT.NAME, NULL, NULL, C.NAME, BITAND(H.SPARE2, 2),
BITAND(H.SPARE2, 1), H.DISTCNT, H.DENSITY, H.SPARE1, H.SAMPLE_SIZE,