CE-00039: Monitoring (Oracle database parameters)

[RU]

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

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

Информация:

• информация о параметрах БД

Запрос

select name, value from v$parameter where
name in ('memory_target','pga_aggregate_target','cpu_count',
         'sessions','processes','sga_max_size','db_block_size',
         'sga_target','db_writer_processes','db_recovery_file_dest',
         'db_recovery_file_dest_size','db_flashback_retention_target',
         'transactions','undo_management','undo_tablespace','undo_retention',
         'cursor_sharing','open_cursors','db_files') 

select * from NLS_DATABASE_PARAMETERS  
 where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET')

Решение

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

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

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (Oracle database parameters)

Information:

• information about database parameters

Query

select name, value from v$parameter where
name in ('memory_target','pga_aggregate_target','cpu_count',
         'sessions','processes','sga_max_size','db_block_size',
         'sga_target','db_writer_processes','db_recovery_file_dest',
         'db_recovery_file_dest_size','db_flashback_retention_target',
         'transactions','undo_management','undo_tablespace','undo_retention',
         'cursor_sharing','open_cursors','db_files') 

select * from NLS_DATABASE_PARAMETERS  
 where parameter in ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET')

Solution

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

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