Program error

[RU]

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

Текст сообщения: Monitoring (Oracle FRA free percentage)

Информация

• Получение данных о проценте свободного места в пространстве FRA

Запрос

select name,
       round(space_limit/1024/1024/1024) "lim",
       round(space_used/1024/1024/1024) "used",
       round(((space_limit-space_used)/space_limit)*100) "free" 
  from v$recovery_file_dest 
 where name is not null

Решение

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

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

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (Oracle FRA free percentage)

Information

• Obtaining data on the percentage of requests hitting data blocks in the buffer cache. The higher the value, the better

Query

select name,
       round(space_limit/1024/1024/1024) "lim",
       round(space_used/1024/1024/1024) "used",
       round(((space_limit-space_used)/space_limit)*100) "free" 
  from v$recovery_file_dest 
 where name is not null

Solution

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

grant select any dictionary to <UserName>; 
or
grant select on v$recovery_file_dest to <UserName>;