用户反馈ogg数据未实时同步至目标库，检查应用进程日志，部分报错信息如下：

根据日志看到在做抽取ddl时出现报错，mos匹配后，定位到时由于auto space advisor在shrink打标的空间时导致的。

（参考文档：Extract Abend - OGG-00458 Cannot Find Metadata Property (Doc ID 2179454.1) ）

禁用：auto space advisor

Steps to disable the "auto space advisor"

1. Check the status of the "auto space advisor".

SQL> SELECT client_name, status FROM dba_autotask_client;

set lines 180 pages 1000

col client_name for a40

col attributes for a60

select client_name, status,attributes,service_name from dba_autotask_client

/

2. Execute the below to disable the "auto space advisor".

BEGIN

DBMS_AUTO_TASK_ADMIN.disable(

client_name => 'auto space advisor',

operation => NULL,

window_name => NULL);

END;

/

3. Check if the "auto space advisor" is disabled.

set lines 180 pages 1000

col client_name for a40

col attributes for a60

select client_name, status,attributes,service_name from dba_autotask_client

/

Restart the Extract process after disabling the "auto space advisor".

Note: Please check with your Oracle Core DBA before disabling this "auto space advisor".

4. To enable the "auto space advisor" execute the below,

BEGIN

DBMS_AUTO_TASK_ADMIN.enable(

client_name => 'auto space advisor',

operation => NULL,

window_name => NULL);

END;

/

5. Check if the "auto space advisor" is disabled.

set lines 180 pages 1000

col client_name for a40

col attributes for a60

select client_name, status,attributes,service_name from dba_autotask_client

/