CE-00042: Monitoring (FRA - max space usage)

[RU]

Источник ошибки: Ядро мониторинга работы СУБД Oracle

Текст сообщения: Monitoring (FRA - max space usage)

Информация

• Определение свободного места в пространстве FRA

Запрос

select s.file_type, s.percent_space_used
  from (select rau.file_type,
               rau.percent_space_used
         from v$flash_recovery_area_usage rau
order by percent_space_used desc) s
where rownum = 1

Решение

Предоставить пользователю права на чтение данных системного каталога, например

grant select any dictionary to <UserName>; 
или  
grant select on v$flash_recovery_area_usage to <UserName>;

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (FRA - max space usage)

Information

• Determination of free space in the FRA space

Query

select s.file_type, s.percent_space_used
  from (select rau.file_type,
               rau.percent_space_used
         from v$flash_recovery_area_usage rau
order by percent_space_used desc) s
where rownum = 1

Solution

Grant the user rights to read system directory data, for example

grant select any dictionary to <UserName>; 
или  
grant select on v$flash_recovery_area_usage to <UserName>;