CE-00061: Monitoring (Oracle UNDO information)

[RU]

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

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

Информация

• Получение данных о пространстве UNDO (размере датафайлов, параметрах undo_retention и undo_management)

Запросы

select name, value 
  from v$parameter 
 where name in ('undo_retention','undo_management') 
order by 1

select round(sum(df.maxbytes)/1024/1024/1024) "size" ,
       df.TABLESPACE_NAME,
       round(sum(df.BYTES)/1024/1024/1024) "Alloc",
       count(df.FILE_ID) "Count"
  from dba_data_files df,
       v$parameter p
 where df.tablespace_name = p.VALUE
   and p.NAME = 'undo_tablespace' 
 group by df.TABLESPACE_NAME

Решение

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

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

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (Oracle UNDO information)

Information

• Getting data about UNDO space (datafile size, undo_retention and undo_management parameters)

Query

select name, value 
  from v$parameter 
 where name in ('undo_retention','undo_management') 
order by 1

select round(sum(df.maxbytes)/1024/1024/1024) "size" ,
       df.TABLESPACE_NAME,
       round(sum(df.BYTES)/1024/1024/1024) "Alloc",
       count(df.FILE_ID) "Count"
  from dba_data_files df,
       v$parameter p
 where df.tablespace_name = p.VALUE
   and p.NAME = 'undo_tablespace' 
 group by df.TABLESPACE_NAME

Solution

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

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