Re: Copy stats from prod to development in 7.x, 8.0

Hi.

 Thank you for a hint.
 I'm going on vocation to UK for 2 weeks, but I afterward  I intent to see that case trough ( going to post the  results ( if positive )).

 Michael.

In article <933842648.1371.0.nnrp-12.9e984b29_at_news.demon.co.uk>,   "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
> Well,
>
> It does work (but you may have to flush
> the shared pool first). But the big danger
> is in doing it incorrectly and damaging
> your system - then Oracle doesn't have
> to offer you any support because you've
> done something that the manuals specifically
> tell you not to do.
>
> Having said that, I am quite happy to do this
> sort of thing as the last 'critical performance test'
> on a throwaway development system when I
> cannot scale it properly to production size.
>
> Hints:
>
> Don't assume that there isn't some internal
> consistency check in the various columns
> used. Just because you supply only 4 numbers
> to the 8i routines (say) that doesn't mean that
> only 4 numbers change on tab$. (NB if you do
>
> 'alter session events '10046 trace name context forever, level 4'
>
> before calling each of the 8i routines, you can at least
> see what 8i does, and get a clearer image of this
> columns in which tables get patched up.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> michael_bialik_at_my-deja.com wrote in message
<7oaiau$75v$1_at_nnrp1.deja.com>...
> >Hi.
> >
> > Is there any way to copy STATs from production to
> > development in Oracle 7.x or 8.0.
> > There is a package DBMS_STAT in 8i, but no such
> > thing in earlier releases.
> > Is there a danger in updating these stats "manually"
> > in SYS.xxx tables ?
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 05 1999 - 16:29:42 CDT