Database Utilities (MOSC)

MOSC Banner

expdp on a database with incremental stats enabled spends lot of time selecting from sys.wri$_optsta

edited May 8, 2014 7:35AM in Database Utilities (MOSC) 2 commentsAnswered

The SQL looks like this while processing "Processing object type SCHEMA_EXPORT/STATISTICS/MARKER" path.

  SELECT intcol#, hashvalue
    FROM sys.wri$_optstat_synopsis$
   WHERE bo# = nnnnn AND group# = xxxxx
ORDER BY intcol#

I have incremental stats enabled due to heavy partitioning. The above table contains approx 70m+ rows and although it is partitioned on BO#, there are NO indexes on the table. Has anyone else experienced such slowness while expdp is processing SCHEMA_EXPORT/STATISTICS/MARKER path? I don't want to exclude stats but need this to be fast as well. I am sure perhaps an local index on (BO#,GROUP#) will help but I am not sure of that since it is a SYS owned object.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center