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. 重新启动数据库。