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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo