Re: Copying statistics : used a lot ????

[Wolfgang Breitling]

I use it a lot. I create mock databases where I just load the schema (from 
export rows=no) and then copy the statistics on top. That lets me do 
what-if scenarios, changing sql, init parameters, statistics, or even the 
Oracle version, without impacting anyone. When I find something that looks 
promising I can then try that out in a test database with actual data.

At 12:37 PM 9/11/2003 -0800, you wrote:
HI,

I was wandering if a lot of people are copying statistics using dbms_stats
from production to test environment to see what will be the access plan.
If not used, why ?  no time to look at it, bugged, not usefull ,... ?

Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 7470 and (514) 925-7187
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Wolfgang Breitling
 INET: [EMAIL PROTECTED]
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).