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

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 ?
Received on Thu Aug 05 1999 - 03:38:01 CDT