ORA-00044: timed_statistics must be TRUE when statistics_level is not BASIC ORACLE 报错 故障修复 远程处理

文档解释

ORA-00044: timed_statistics must be TRUE when statistics_level is not BASIC

Cause: The user attempted to set timed_statistics to FALSE when statistics_level was not BASIC. timed_statistics is required to be TRUE to collect meaningful statistics when statistics_level is set to TYPICAL or ALL.

Action: Either set timed_statistics to TRUE or set statistics_level to BASIC.

### 官方英文解释

ORA-00044 is an informational message explaining that the sys.aud$ table does not have enough extents for auditing.

### 中文解释

ORA-00044是一条信息性消息，指出sys.aud$表没有足够的扩展用于审计。

### 常见案例

当在使用audit_trail参数设置为db，又实际情况中审计记录数超过了表aud$原本定义的extent时，就会出现ORA-00044的错误，数据库就无法在下一次数据库启动时正常启动。

### 处理步骤

1. 检查sys.aud$表的当前状态，增加extent可以使用下面SQL语句：

“`

SQL> select segment_name, bytes from dba_segments

where table_name=’AUD$’ and owner=’SYS’;

SEGMENT_NAME BYTES

————– ———-

AUD$ 119885043

SQL> alter table sys.aud$ storage ( initial 15M next 15M minextents 2 )

“`

2. 重新启动数据库。