Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Exporting and Importing table statistics

RE: Exporting and Importing table statistics

From: Weaver, Walt <wweaver_at_rightnow.com>
Date: Fri, 25 May 2001 17:38:24 -0700
Message-ID: <F001.0031062E.20010525173611@fatcity.com>

FWIW, all those people who like to slam Oracle Support should pay special attention to Anita's posts. Cool stuff.

--Walt Weaver
  Bozeman, Montana, USA

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 5/25/2001 6:50 PM

Jared,

Yes, DBMS_STATS can be used to move statistics from one db to another for the SAME table/index. It's great for moving prod stats into a dev db for sql tuning. You can also use it to set specific values (e.g. to set NUM_ROWS to 1000000).

You might want to check out the following doc on metalink:

Note: 117203.1 "How to Use DBMS_STATS to Move Statistics to a Different Database"

One caveat, it was not designed to copy stats to a different schema owner. You won't get an error running the procedure, it just won't reset any stats. You can get around this by hacking the stats table generated by DBMS_STATS and changing the username column to the new schema owner. The column names are rather cryptic, but if I remember it's C5.

HTH,


Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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.com
-- 
Author: Weaver, Walt
  INET: wweaver_at_rightnow.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).
Received on Fri May 25 2001 - 19:38:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US