Database Administration (MOSC)

MOSC Banner

FAIL => Table AUD$[FGA_LOG$] should use Automatic Segment Space Management

edited May 4, 2022 2:49AM in Database Administration (MOSC) 8 commentsAnswered ✓

Hi,

When we run exachk (database version 19.14 on Exadata X8M-2 | x86_64 Linux VM), we get the message " FAIL =>   Table AUD$[FGA_LOG$] should use Automatic Segment Space Management for xxx"

However, we've found it's auto with details query below:

SQL> col TABLE_NAME format a10

col segment_space_management format a20

col tablespace_name format a10

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


TABLE_NAME SEGMENT_SPACE_MANAGE TABLESPACE

---------- -------------------- ----------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center