Exachk: Table AUD$[FGA_LOG$] Should Use Automatic Segment Space Management (Doc ID 2863038.1)

Last updated on JUNE 27, 2023

Applies to:

Symptoms

"Table AUD$[FGA_LOG$] should use Automatic Segment Space Management", but yet the query output shows "AUTO", and no data is showing in the report either.

SQL> select t.table_name,ts.segment_space_management from dba_tables t, dba_tablespaces ts where ts.tablespace_name = t.tablespace_name and t.table_name in ('AUD$','FGA_LOG$');

TABLE_NAME
--------------------------------------------------------------------------------
SEGMEN
------
FGA_LOG$
AUTO

AUD$
AUTO

>>> Exachk report shows as below

Database Server
Status Previous Status Type Message Status On Details
FAIL
21-10-26 17:13H
PASS
21-10-26 17:12H
PASS
SQL Check Table AUD$[FGA_LOG$] should use Automatic Segment Space Management All Databases

Needs attention on
Passed on -

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.