RE: Copying statistics : used a lot ????

2003-09-21 Thread Boris Dali
What a timely thread! We've been discussing this very issue back and forth for some time now in our organization. We are getting a new application, which presumably will run on something like lower-end Superdome 16-way, ~30GB RAM type of box. The question is whether 4-way, 4GB RAM Rp5470

RE: Copying statistics : used a lot ????

2003-09-21 Thread Boris Dali
What a timely thread! We've been discussing this very issue back and forth for some time now in our organization. We are getting a new application, which presumably will run on something like lower-end Superdome 16-way, ~30GB RAM type of box. The question is whether 4-way, 4GB RAM Rp5470

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

2003-09-21 Thread Ryan
wait a second. the CBO takes into consideration your system statistics when you analyze? Is that new in 9i? I thought the export stats and import stats were used if you wanted a 'smaller subset' of data. so you mimic the data stats? - Original Message - To: Multiple recipients of list

RE: Copying statistics : used a lot ????

2003-09-12 Thread Stephane Paquette
Well no, I have bought the Expert one on one book. I check on his web site and I found one reference where he addresses the use of changing the stats. Usually you can find what is its opinion just by the tone, but this time I was not able to see if he's against or not on this. Can you share more

RE: Copying statistics : used a lot ????

2003-09-12 Thread Jamadagni, Rajendra
Title: RE: Copying statistics : used a lot Our production and test systems are same ... test lags 24 hours behind production that's all. But I have successfully used dbms_stats to copy over stats from production to test on a table by table basis to verify explain plans. My opinion WAD

Copying statistics : used a lot ????

2003-09-11 Thread Stephane Paquette
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

RE: Copying statistics : used a lot ????

2003-09-11 Thread Jesse, Rich
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

RE: Copying statistics : used a lot ????

2003-09-11 Thread Grabowy, Chris
By chance, do you have Tom Kyte's latest book? Effective Oracle by Design?? He states his opinion on this approach on page 30, section entitled Test Against Representative Data. -Original Message- Stephane Paquette Sent: Thursday, September 11, 2003 4:38 PM To: Multiple recipients

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

2003-09-11 Thread 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

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

2003-09-11 Thread Stephen Andert
Stephane, No time to look at it enough to do it. Also, not a lot of time is spent tuning our test/dev environments. But I'd like to do it. Stephen [EMAIL PROTECTED] 09/11/03 01:37PM HI, I was wandering if a lot of people are copying statistics using dbms_stats from production to test