Program error

[RU]

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

Текст сообщения: Monitoring (FRA - usage PGA memory)

Информация

• определение использования памяти в пространстве PGA

Запрос

select round(sum(b.value/1024/1024)) usepga
  from v$session a,
       v$sesstat b,
       v$statname c
 where a.sid = b.sid
   and b.statistic# = c.statistic#
   and c.name = 'session pga memory'

Решение

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

grant select any dictionary to <UserName>; 
или  
grant select on v$sesstat to <UserName>; 
grant select on v$statname to <UserName>;
grant select on v$session to <UserName>;

[EN]

Error Source: Oracle DBMS Operation Monitoring Kernel

Message text: Monitoring (FRA - usage PGA memory)

Information

• Determining memory usage in PGA space

Query

select round(sum(b.value/1024/1024)) usepga
  from v$session a,
       v$sesstat b,
       v$statname c
 where a.sid = b.sid
   and b.statistic# = c.statistic#
   and c.name = 'session pga memory'

Solution

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

grant select any dictionary to <UserName>; 
or
grant select on v$sesstat to <UserName>; 
grant select on v$statname to <UserName>;
grant select on v$session to <UserName>;