Program error

[RU]

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

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

Информация:

• получение данных о размере дисковых групп ASM и свободном месте

• получение данных о чтении/записи в разрезе дисков (определение перекоса ввода/вывода)

Запрос

select round(free_mb/1024) "SizeFreeGB",
       round(free_mb/total_mb*100,2)"SizeFreePerc",
       name "ASMName",
       round(free_mb/total_mb*100) "SizeFreePercRound",   
       round(d.USABLE_FILE_MB/1024) "SizeFreeGBMir",
       round(d.REQUIRED_MIRROR_FREE_MB/1024) "Mirror_Free_GB",
       d.OFFLINE_DISKS
  from v$asm_diskgroup d 
order by 4

select round(sum(d.BYTES_READ)/1024/1024) "RMB",
       round(sum(d.BYTES_WRITTEN)/1024/1024) "WMB"
  from V$ASM_DISK d

Решение

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

grant select any dictionary to <UserName>; 
или  
grant select on v$asm_diskgroup to <UserName>; 
grant select on V$ASM_DISK to <UserName>;

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (Oracle ASM data)

Information:

• getting information about the size of ASM diskgroups and free space

• obtaining data on reading / writing in the context of disks (determining input / output skew)

Query

select round(free_mb/1024) "SizeFreeGB",
       round(free_mb/total_mb*100,2)"SizeFreePerc",
       name "ASMName",
       round(free_mb/total_mb*100) "SizeFreePercRound",   
       round(d.USABLE_FILE_MB/1024) "SizeFreeGBMir",
       round(d.REQUIRED_MIRROR_FREE_MB/1024) "Mirror_Free_GB",
       d.OFFLINE_DISKS
  from v$asm_diskgroup d 
order by 4

select round(sum(d.BYTES_READ)/1024/1024) "RMB",
       round(sum(d.BYTES_WRITTEN)/1024/1024) "WMB"
  from V$ASM_DISK d

Solution

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

grant select any dictionary to <UserName>; 
or 
grant select on v$asm_diskgroup to <UserName>; 
grant select on V$ASM_DISK to <UserName>;