Database Utilities (MOSC)

MOSC Banner

dbms_utility.analyze_schema('schema_name','compute') after impdp

edited Jun 19, 2014 12:00PM in Database Utilities (MOSC) 1 commentAnswered

When we request a data refresh in our TEST database, the company that manages our Oracle databases performs an impdp followed by an analyze.  I keep reading that the impdp process performs the analyze as part of the datapump import.  Here's my question:

Does running a datapump import using default parameters compute schema statistics?  For example, is it sufficient to run impdp system@database directory=xyz dumpfile=abc.dmp logfile=abc_imp.log schema=AAA, or do I need to follow up with EXECUTE DBMS_UTILITY.ANALYZE_SCHEMA(('AAA','COMPUTE'); to generate statistics necessary for an efficient optimizer?

Thanks in advance!

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