Re: statistics created for GTTs after import
Date: Fri, 4 Dec 2015 11:09:03 +0000
Message-ID: <88B835643D7427EA.D01E693B-1920-4971-8372-35CD215E1220_at_mail.outlook.com>
I can't say with 100% confidence that the stats were gathered during import, but it affected all GTTs in the target db and they were all gathered at the same time, which was just a few minutes after the tables were created from the import.
Sent from Outlook<http://aka.ms/Ox5hz3>
On Thu, Dec 3, 2015 at 10:20 PM -0800, "Ahmed Aangour" <ahmed.aangour_at_gmail.com<mailto:ahmed.aangour_at_gmail.com>> wrote:
Hi Joel,
It's possible that on the source there were no statistics on temporary tables because the volume can change everyday and they probably relied on dynamic sampling to compute dynamically accurate statistics. By having statistics calulated now for these table you won't be able to get a good plan for each different workload. Concerning the fact that you have statistics now on your temporary tables, are you sure they were calculated during the import?
Le 3 d?c. 2015 23:20, "Joel Slowik" <jslowik_at_cps92.com<mailto:jslowik_at_cps92.com>> a ?crit : Hi Folks,
I'm not quite sure what to make of this.
I'm migrating a handful of our databases from windows servers (2003) to RHEL 7 x64 servers. These are the basic steps I'm performing:
- create database (using that very command, scripted out)
- run catalog, catproc, utlrp, and then finally run catqm
- run a script to setup our users and data schema
- expdp full from target database (database is Oracle 64bit 11.2.0.3)
- impdp schemas (just one) to source database (database is Oracle 64bit 11.2.0.4)
Somehow along the way (and this is not happening in all of our database), statistics are being gathered during import for our GTTs and set precisely to 2000 num_rows, 2000 sample size, 100 average row length, and 100 blocks. Statistics do not exists for our GTTs in our source database.
What's going on here?
-joel slowik
Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 04 2015 - 12:09:03 CET