I don't use it a lot, since our test systems are currently complete copies of our li'l ol' 30GB production DB. But it's nice to have for things like the 9i RAC test, where we can't have a complete copy of the data (although I've yet to try it on there). And it has worked well so far from 8.1.7.4 to 8.1.7.4, all on HP/UX 11.0.
Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -----Original Message----- > From: Stephane Paquette [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 11, 2003 3:38 PM > To: Multiple recipients of list ORACLE-L > Subject: Copying statistics : used a lot ???? > > > 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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).
