Performance - EBS (MOSC)

MOSC Banner

Gather Stats running for long

edited Mar 2, 2020 4:05PM in Performance - EBS (MOSC) 7 commentsAnswered

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,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center