RE: statistics created for GTTs after import
Date: Fri, 4 Dec 2015 06:26:47 +0000
Message-ID: <2FE2AA1C5F8DEC478F58DF8DD32BA63714DA18_at_HKWPIPXMB03C.zone1.scb.net>
Does it happen for *all* the GTTs in that one schema (database) ? Or only a subset of GTTs ? Are they all defined with the same DURATION (in USER_TABLES for TEMPORARY='Y') ?
The import shouldn't be importing any rows into the GTT but I wonder if there is a DDL trigger which fires ON CREATE and populates the statistics ?
Hemant K Chitale
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joel Slowik
Sent: Friday, December 04, 2015 6:20 AM
To: 'oracle-l_at_freelists.org'
Subject: statistics created for GTTs after import
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
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 04 2015 - 07:26:47 CET