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 - Works as designed ... remember to take a backup of existing stats on test in a separate table so you can reload them when needed quickly.
My experience is on 9ir2 only for this feature.
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: Stephane Paquette [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 12, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Copying statistics : used a lot ????
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 of what's in the book ?
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]>
-----Original Message-----
Grabowy, Chris
Sent: Thursday, September 11, 2003 5:44 PM
To: Multiple recipients of list ORACLE-L
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 of list ORACLE-L
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]>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Paquette
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Grabowy, Chris
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Paquette
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).
********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************2
