Re: Impact of an incorrect CPUSPEEDNW
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: mark.teehan@xxxxxxxxxxxxxxxxx
- Date: Fri, 15 Jan 2010 09:12:44 +0100
Mark,
The answer is obviously yes for an RMAN clone, since it is a
physical copy of database files - and system statistics are stored, in
SYS tables in the system tablespace by default. For the export, I have
run an export full followed by a 'strings' and I have grep'ed for stat
and CPU and got this among other things:
ANALSTATS TR "MGMT_ECM_HW_CPU"
); SREC.EPC := 2;
DBMS_STATS.SET_COLUMN_STATS(NULL,'"MGMT_ECM_HW_CPU"','"ECM_SNAPSHOT_ID"', NULL
,NULL,NULL,0,0,0,srec,0,6); END;
ANALSTATS TR "MGMT_ECM_HW_CPU"
); SREC.EPC := 2;
DBMS_STATS.SET_COLUMN_STATS(NULL,'"MGMT_ECM_HW_CPU"','"VENDOR_NAME"', NULL
,NULL,NULL,0,0,0,srec,0,6); END;
ANALSTATS TR "MGMT_ECM_HW_CPU"
); SREC.EPC := 2;
DBMS_STATS.SET_COLUMN_STATS(NULL,'"MGMT_ECM_HW_CPU"','"FREQ_IN_MHZ"', NULL
,NULL,NULL,0,0,0,srec,0,6); END;
ANALSTATS TR "MGMT_ECM_HW_CPU"
); SREC.EPC := 2;
DBMS_STATS.SET_COLUMN_STATS(NULL,'"MGMT_ECM_HW_CPU"','"ECACHE_IN_MB"', NULL
,NULL,NULL,0,0,0,srec,0,6); END;
ANALSTATS TR "MGMT_ECM_HW_CPU"
); SREC.EPC := 2;
DBMS_STATS.SET_COLUMN_STATS(NULL,'"MGMT_ECM_HW_CPU"','"IMPL"', NULL
,NULL,NULL,0,0,0,srec,0,6); END;
ANALSTATS TR "MGMT_ECM_HW_CPU"
); SREC.EPC := 2;
DBMS_STATS.SET_COLUMN_STATS(NULL,'"MGMT_ECM_HW_CPU"','"REVISION"', NULL
,NULL,NULL,0,0,0,srec,0,6); END;
ANALSTATS TR "MGMT_ECM_HW_CPU"
Therefore I'd tend to say 'yes' too, and I presume that expdp behaves
identically.
HTH
S Faroult
Teehan, Mark wrote:
>
> Something else that I'm checking- if you do an RMAN clone, or an
> import FULL=Y, does it pull over the system stats too? I also posted
> this to forums.oracle.com.
>
>
> Any ideas?
> Mark
>
>
> ==============================================================================
> Please access the attached hyperlink for an important electronic
> communications disclaimer:
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> ==============================================================================
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
