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

Home -> Community -> Usenet -> c.d.o.server -> Stats gathering (8i) to non-data dictionary tables

Stats gathering (8i) to non-data dictionary tables

From: Mike Collier <mcollier_at_btinternet.com>
Date: 2 Aug 2005 06:58:08 -0700
Message-ID: <1122991088.736755.41550@g49g2000cwa.googlegroups.com> 





Can anyone help.  I have a requirement to gather stats in prod without
the values being put into the data dictionary and used immediately.
Instead I'd like them to go into a user stattab from where I can move
them into a non-prod instance.



That is, I'd like to do a gather_table_stats but specify the gathered
stats go to the stattab instead of a backup of the previous values.



Has anyone done this?



Many thanks in advance.
Received on Tue Aug 02 2005 - 08:58:08 CDT












Original text of this message













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