CE-00063: Monitoring (Oracle datafile read\write stat)

[RU]

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

Текст сообщения: Monitoring (Oracle datafile read\write stat)

Информация

• Получение данных о суммарном чтении/записи в файлы данных

Запрос

select round(sum((ts.PHYRDS *fd.block_size))/1024/1024) "read",
       round(sum((ts.PHYWRTS *fd.block_size))/1024/1024) "write" 
  from  ((select PHYRDS, 
                  PHYWRTS, 
                  File# 
             from V$FILESTAT)
         union all   
         (select PHYRDS, 
                 PHYWRTS, 
                 File# 
            from V$TEMPSTAT) 
        )ts,
       (select File#, 
               block_size 
          from V$DATAFILE) fd
 where fd.file#=ts.file#

Решение

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

grant select any dictionary to <UserName>; 
или       
grant select on V$FILESTAT to <UserName>;
grant select on V$TEMPSTAT to <UserName>;
grant select on V$DATAFILE to <UserName>;

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (Oracle datafile read\write stat)

Information

• Obtaining data on the total read/write to data files

Query

select round(sum((ts.PHYRDS *fd.block_size))/1024/1024) "read",
       round(sum((ts.PHYWRTS *fd.block_size))/1024/1024) "write" 
  from  ((select PHYRDS, 
                  PHYWRTS, 
                  File# 
             from V$FILESTAT)
         union all   
         (select PHYRDS, 
                 PHYWRTS, 
                 File# 
            from V$TEMPSTAT) 
        )ts,
       (select File#, 
               block_size 
          from V$DATAFILE) fd
 where fd.file#=ts.file#

Solution

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

grant select any dictionary to <UserName>; 
or     
grant select on V$FILESTAT to <UserName>;
grant select on V$TEMPSTAT to <UserName>;
grant select on V$DATAFILE to <UserName>;