RE: Does impdp regather statistics or just import them?

"DataPump Import (impdp) Is Analyzing The Statistics On Table Instead Of Using DBMS_STATS Package" [Doc ID 1096917.1]

Chris

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christopher.Taylor2_at_parallon.net Sent: Monday, September 17, 2012 7:57 AM To: oracle-l_at_freelists.org
Subject: Does impdp regather statistics or just import them?

Version: 10.2.0.4
Assume:

1.)      expdp included table/index statistics
2.)      the following parameter on the target db is set to false:"_optimizer_compute_index_stats",

It is my understanding that impdp will _only_ import statistics, not do a regather statistics operation.

This is based on:
Table 3-2 Original Import Parameters and Their Counterparts in Data Pump Import STATISTICS A parameter comparable to STATISTICS is not needed. If the source table has statistics, they are imported. from http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_import.htm\

However, Note: ID 793585.1 seems to imply that statistics are regathered unless you use EXCLUDE=STATISTICS and set the database parameter to false.

A few DBAs I work with believe (insist) that impdp regathers statistics and doesn't just import them - I'm hoping that is incorrect but I am unable to find a clear verification.

Chris

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 17 2012 - 08:02:35 CDT