Program error

[RU]

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

Текст сообщения: Monitoring (Oracle archivelog generated)

Информация

• Получение данных о записи данных в журналы REDO СУБД Oracle

Запросы

База в режиме Archivelog
select nvl(round(avg(diff)),0) "diff"
  from
  (select to_char(d,'mmddhh24miss') d, (d - lag(d, 1, null) over (order by d))*(24*60*60) DIFF
     from (select FIRST_TIME d
             from v$archived_log
           order by recid  desc)
    WHERE rownum <52 order by D)

База в режиме Noarchivelog
select nvl(round(avg(diff)),0) "diff"
  from
   (select to_char(d,'mmddhh24miss') d, (d - lag(d, 1, null) over (order by d))*(24*60*60) DIFF 
      from (select FIRST_TIME d
              from v$log
             where FIRST_TIME is not null)
    order by D)
    
Объем [в ГБ] созданных за текущий день журналов REDO
SELECT ROUND(SUM(blocks * block_size)/1024/1024/1024,2) size_gb
  FROM v$archived_log
 WHERE TRUNC(first_time) >= TRUNC(SYSDATE)
GROUP BY TRUNC(first_time)
ORDER BY TRUNC(first_time) 

Информация о текущей активной группе журналов REDO
select group#, 
       bytes/1024/1024 as siz,members, 
       status,
       first_time 
  from v$log 
 where status='CURRENT'

Решение

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

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

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (Oracle archivelog generated)

Information

• Obtaining data about writing data to the Oracle DBMS REDO logs

Query

База в режиме Archivelog
select nvl(round(avg(diff)),0) "diff"
  from
  (select to_char(d,'mmddhh24miss') d, (d - lag(d, 1, null) over (order by d))*(24*60*60) DIFF
     from (select FIRST_TIME d
             from v$archived_log
           order by recid  desc)
    WHERE rownum <52 order by D)

База в режиме Noarchivelog
select nvl(round(avg(diff)),0) "diff"
  from
   (select to_char(d,'mmddhh24miss') d, (d - lag(d, 1, null) over (order by d))*(24*60*60) DIFF 
      from (select FIRST_TIME d
              from v$log
             where FIRST_TIME is not null)
    order by D)
    
Объем [в ГБ] созданных за текущий день журналов REDO
SELECT ROUND(SUM(blocks * block_size)/1024/1024/1024,2) size_gb
  FROM v$archived_log
 WHERE TRUNC(first_time) >= TRUNC(SYSDATE)
GROUP BY TRUNC(first_time)
ORDER BY TRUNC(first_time) 

Информация о текущей активной группе журналов REDO
select group#, 
       bytes/1024/1024 as siz,members, 
       status,
       first_time 
  from v$log 
 where status='CURRENT'

Solution

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

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