Monthly Archives: 八月 2014

Installing and Using Standby Statspack in 11g

0

Posted on by

11g active dataguard 生成的awr信息是主库的awr,而不是dataguard的awr信息,不能生成备库的awr,但是可以生产statspack。

1. Standby Statspack Usage

1.1 Statspack Installation 

The perfstat schema and statspack related objects must be present on the primary and standby prior to installing standby statspack. 

If the perfstat user does not exist in the primary site then you will need to create the perfstat schema using the following:

sqlplus / as sysdba
SQL> @?/rdbms/admin/spcr[……]

查看全文

Exclude (Automatic) Statistics Gathering from external objects

0

Posted on by

数据库在自动收集统计信息时,报如下错误:

ORA-20011: Approximate NDV failed:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error

检查到是一个外部表收集统计信息的错误

 

管方的建议是:

用DBMS_STATS.LOCK_TABLE_STATS 不让他收集统计信息

或者直接drop table

 

但由于外部表又不能删除,只好

DBMS_STATS.LOCK_TABLE_STATS ('ownname','tabname');

 

有没有lock可以通过这个视图查看

SELECT stattype_locked FROM dba_tab_statistics;

[……]

查看全文